Thread: 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" <sistemas@cerealesdellitoral.com.ar> wrote in message
news:O8JJnntNFHA.576@TK2MSFTNGP15.phx.gbl...
> 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
>>
>>
>