View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Andy Andy is offline
external usenet poster
 
Posts: 414
Default Real-time charting of DDE links

I have DDE links for my stock analysis. All the cells below are dynamically
updating and I would like the chart (in real-time) the number "-86.1%" from
below. I would like to chart 1-minute candle stick charts that show the
open-high-low-close for each candle. Do you possiblly know of any programs
that could do this for me?
Thanks!

HIGH LOW LAST Range
DD 48.33 46.97 47.15 -86.8%
DOW 44.33 43.53 43.70 -78.7%
AA 38.36 37.31 37.40 -91.4%
MON 96.50 94.26 94.56 -86.6%
FCX 114.24 107.19 108.10 -87.1%
-86.1%
=SUM(F2:FF6)/5
=(Last-High)/(High-Low)


"Jon Peltier" wrote:

Could you provide a few more details about what you need? I've dabbled in
this area just a bit.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"andy" wrote in message
...
Is it possible to chart DDE links in real-time in Excel? Could someone
please point me in the right direction to find out how this can be done.
Thanks!