R
Ron Vleugel
Hi,
Via Yahoo I am trying to get stock quotes into my Excel worksheet:
So via goto A1, select Data->Get External Data->New Web Query
and use e.g.
http://finance.yahoo.com/d/quotes.csv?s=EBAY&f=sl
The result is
A1==EBAY,82.70,"1/27/2005","4:00pm",+0.38,82.64,83.75,81.68,17412500
Now, I expected that the above line can easily be positioned into different
cells. Unfortunatelly I don't know how to do this. So I would like to have
the above output like:
A1 == EBAY B1==82.70 C1==1/27/2005 etc
Does anybody know how to do this?
I appreciate your help.
Ron
Via Yahoo I am trying to get stock quotes into my Excel worksheet:
So via goto A1, select Data->Get External Data->New Web Query
and use e.g.
http://finance.yahoo.com/d/quotes.csv?s=EBAY&f=sl
The result is
A1==EBAY,82.70,"1/27/2005","4:00pm",+0.38,82.64,83.75,81.68,17412500
Now, I expected that the above line can easily be positioned into different
cells. Unfortunatelly I don't know how to do this. So I would like to have
the above output like:
A1 == EBAY B1==82.70 C1==1/27/2005 etc
Does anybody know how to do this?
I appreciate your help.
Ron