real time charting....

  • Thread starter Thread starter Andres
  • Start date Start date
A

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
 
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
 
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/
_______
 
Back
Top