charting a single changing DDE cell

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

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/ne...rts/index.html

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

- Lenin


---
Message posted from http://www.ExcelForum.com/

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

LeninVMS wrote:

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/ne...rts/index.html

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

- Lenin


---
Message posted from http://www.ExcelForum.com/