PDA

View Full Version : Macro and Chart running on Streaming Data



nitzbar
09-11-2008, 10:04 AM
Hi ! I recently created a chart based off a macro that runs on a DDE feed of live market data. Ideally, I would like the macro to run and generate the chart whenever a fresh set of values is fed into excel. However, this doesn't happen and I have currently set the macro to run at intervals of 1-2 mins. Even in this case, as the day goes by and a large amount of input data accumulates, the macro becomes exceedingly slow.

I would like the macro to just run on the fresh set of values instead of performing all the calculations again. Any suggestions on how to tackle this ?