real time charting....

[Andres]

hi, the situation is this... a web query reading at 1 minute interval stock
quotes market (not msn nor yahoo...)

Value Dif. Time
Ac. Soja /05-5 498.88 -5.95 13:30
Ac. Soja /07-5 501.96 -5.73 13:30
Ac. Soja /08-5 498.22 -6.61 13:30
Har. Soja/05-5 204.37 -1.76 13:30
Har. Soja/07-5 206.35 -1.75 13:30
Har. Soja/08-5 206.90 -1.42 13:30
Maiz /05-05 83.36 -0.49 13:30
Maiz /07-05 86.51 -0.49 13:30
Maiz /09-05 89.27 -0.29 13:30
Soja /05-05 227.36 -3.21 13:30
Soja /07-05 229.65 -4.04 13:31
Soja /08-05 228.18 -3.13 13:31
Trigo /05-05 119.51 -2.11 13:31
Trigo /07-05 122.73 -2.57 13:31
Trigo /09-05 125.30 -1.84 13:31


I want to chart the evolution of the prices. Any ideas?

thank in advance

Andres

 

[Bernard Liengme]

1) read about dynamic chart on my website
or
2) if you have XL2003 turn your data into a List; make a chart; charts made
from Lists are automatically dynamic
best wishes

 

[Jon Peltier]

Stephen Bullen has an example on his site for "remembering" the previous so many
data values from a DDE link. You may be able to adapt that to your data.

Alternatively the same process that drives the repeating queries could move the
existing data down a row each time so the new data does not overwrite it.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Jon Peltier]

I forgot to paste the link on Stephen's site:

http://oaltd.co.uk/DLCount/DLCount.asp?file=Previous.zip

- Jon