Niklas Nebel <Niklas.Nebel <at> Sun.COM> writes: > > 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 > I have struggled for two weeks with this exact problem! Why can't openoffice handle the URL "http://quote.yahoo.com/d/quotes.csv?s=MSFT&f=sl1d1t1c1ohgv&e=.csv";, when Firefox handles it perfectly. Obviously earlier openoffice did handle it but now cannot. See the thread at http://www.oooforum.org/forum/viewtopic.phtml?t=4103.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
