J
John Haldi
I have a small application (VB 2005) which needs to continuously retrieve
data from an spreadsheet that contains RTD (real time) stock price
information. So for example in my spreadsheet I'm watching the Bid/Ask/Last
prices for 30 stocks. In my application I want to have a grid that displays
the same data continously.
What is the most efficient (in terms of CPU usage) way of accomplishing
this? I've written a first attempt which goes through a loop and does a poll
of each cell individually via a Range("a1").value type of call, but when I
put this on a timer with a short interval it spikes up right away on the task
manager CPU monitor.
Is there a way to bind to this data so that it is "data aware" and knows
whenever one of these prices changes without my having to poll via a timer?
Many thanks,
John
data from an spreadsheet that contains RTD (real time) stock price
information. So for example in my spreadsheet I'm watching the Bid/Ask/Last
prices for 30 stocks. In my application I want to have a grid that displays
the same data continously.
What is the most efficient (in terms of CPU usage) way of accomplishing
this? I've written a first attempt which goes through a loop and does a poll
of each cell individually via a Range("a1").value type of call, but when I
put this on a timer with a short interval it spikes up right away on the task
manager CPU monitor.
Is there a way to bind to this data so that it is "data aware" and knows
whenever one of these prices changes without my having to poll via a timer?
Many thanks,
John