I have live exchange price quotes posting into an Excel spreadsheet. I want a VBA code that would alert me if the live quotes have not been updated in the last 15 minutes.
Can anyone suggest a VBA quote or direction that I can pursue to solve this ?
I have live exchange price quotes posting into an Excel spreadsheet. I want a VBA code that would alert me if the live quotes have not been updated in the last 15 minutes.
Can anyone suggest a VBA quote or direction that I can pursue to solve this ?
Is it a DDE feed? The problem with that is that it doesn't register as a change, so I think you would have to have a reference to a key cell and monitor the calculate event.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote
