real time charting....
 

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Andres" wrote in message
...
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

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

Andres wrote:

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

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

http://oaltd.co.uk/DLCount/DLCount.a...e=Previous.zip

- Jon

Jon Peltier wrote:

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

Andres wrote:

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