Excel Question

[Eiger 10]

I am trying out a set of indicators real time and find that they seriously slow down my charting software. I can make an OLE link from Excel to the software. I am wondering though, can Excel be made to run real time? In other words, will it update real time or do you need to keep copying & pasting data into it?

[GammaJammer 10]

It can do, provided your charting package supports it. Usually via something called DDE (dynamic data exchange). Not all charts do - what are you using? Usually it's just a realtime feed of bid/offer etc. Don't know about actually grabbing each price update as it comes through (if that's what you're referring to) - can undoubtably be done in vba, but you would need to be a cleverer man than me (or at least, have a lot more time on your hands - I'm sure I could do it eventually).

 

Someone on this site will know how I reckon.

 

GJ

[Eiger 10]

Thanks, Gamma. I appreciate the response. I use MetaStock Pro as my charting software. I am using an indicator that makes a lot of calcs and slows MS way down to a crawl. I have a pretty good computer with 4 Gigs of ram and a zippy dual core processor, so i figure that it would be better to do the calucs outside MS. MS allows an easy link into Excel, though I must say, I will need help in programming, as i am not that sophisticated. Thanks again.