buidling OHLC price series from single DDE link

[2mc]

I want to build a series of one minute price bars of a stock. [A "bar" has an open, high, low, and close.] I want to build the series from a single DDE link receiving real-time streaming price data.

Does anyone have any ideas? Or, can someone point me to an article that may describe something similar?

Thank you very much.
Matt

 

[PaddyD]

check out the examples on Steven Bullen's site that use circular references to monitor changing values coming in from dde links (i.e. no VBA )

http://www.bmsltd.co.uk/Excel/Default.htm

they're in the 'worksheet functions section. post back if you need more...

paddy

 

[2mc]

Thanks, but that didn't help. I know how to use circular references and do so in a worksheet I use to monitor my positions.

I'm more interested in how to get row after row of one minute bars consisting of open, high, low, close data from a single DDE link that continually updates with the latest price. [I also have a link for the time as well.]

Thanks anyway.
Matt
This message was edited by 2mc on 2002-11-04 00:10

 

[2mc]

Does anyone have any ideas of how to accomplish this? I'm sure it can be done.

Thanks for any help anyone can give me.

Matt