charting a single changing DDE cell

[Bob Chapman]

I have a spreadsheet that captures real time stock data via a DDE link. The
cell captures the last price of a stock as it changes over time. Can you
chart that changing cell as the day progresses. Maybe capture the data and
then chart it or a macro which plots that cell every minute?

Bob

 

[LeninVMS]

You would need to capture the value of that changing cell periodically
in a growing table, possibly in a different sheet.

For example, every time you update it via the DDE, you could run a code
that copies the value of the cell to the last row of the table.

Use a dynamic chart to plot the values in the new chart so that it gets
automatically updated.

http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html

http://peltiertech.com/Excel/Charts/Dynamics.html

- Lenin

 

[Jon Peltier]

Also Stephen Bullen has an example that remembers the last N values in a
DDE linked cell (http://bmsltd.ie).

- Jon