Paul_B wrote:
http://finance.yahoo.com/d/quotes.csv?s=SUNW&f=sl1d1t1c1ohgv&e=.csv
It yields the following data:
"SUNW",5.59,"11/22/2006","4:00pm",+0.05,5.58,5.64,5.55,44316292
Using the link in the Import External Data dialog doesn't work
because the defined range required is not a local range but one
in the remote file, which doesn't exist in this case.
Use a linked sheet (and simple formulas if you need the values on
another sheet).
2) how would I open the remote data for /several/ stock symbols
into the same sheet?
Yahoo lets you specify several stock names, separated by "+".
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
