Continuously updating chart for stock prices

[Marco123]

Hi All,

I am trying to create a chart in Excel VBA that continuously updates with (historical) stock prices and P&L for backtesting a trading strategy. The user will be able to see the chart update i.e. the graph moving up or down and P&L change accordingly.

Essentially, I would like to create/code the functionality seen in this video clip.

http://www.youtube.com/watch?v=1_C44nTGwUg

It doesn’t need to be quite as sophisticated as in this clip but I am looking to create a chart that the user can see updating, and old data will eventually “drop off” at the back of the chart, as shown in the clip.

I am fairly competent at VBA, and my first thoughts would be to create a graph in VBA, then run a loop that automatically updates the data, and have some kind of delay (application.wait etc) so the user can see the chart changing.

Any ideas?

 

[SkipVought]

hi,

Did you visit his site and download his file?

What have YOU tried so far?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[Marco123]

Unfortunately it’s not free to download that backtesting spreadsheet shown in the clip. Moreover, even if I did there is still a chance the VBA code could be password protected.

Though, I have tried at a very basic level pretty much what I mentioned in my previous post and it appears to work.

 

[SkipVought]

Well than I guess it's your loss.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]