Delaying Real time Stock quotes by "x" amount

[Jaobr17]

Greetings: I'm trying to DELAY updates on fluctuating real time Stock Futures quotes. In other words, when there is a New High or Low, that Change is delayed by a "x" amount of time where "x" can be changed when needed. I have no clue where to start. I would delay the data for only 1-3 seconds.

Thnx, Jim B

 

[knigget40]

Public Function Sleep(inSecondsToSleep As Long) As Boolean
On Error GoTo errorEncountered
Application.Wait TimeValue(TimeSerial(Hour(Now()), Minute(Now()), second(Now()) + inSecondsToSleep))
On Error GoTo 0
Sleep = True
Exit Function
errorEncountered:
Sleep = False
End Function