Hi, I'm trying to import stock quotes into a calc spreadsheet. I found this example of a source link from an older post:
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. Using it in File/Open, .csv file type does work, but it places its data in a new spreadsheet. That presents the problems of 1) I'd rather have the data directly in the active sheet and 2) how would I open the remote data for /several/ stock symbols into the same sheet? There's hopefully a fairly simple way to do this. I'd be grateful for some guidance. Thanks, p. -- Using OOo 2.0.3 on Win XP sp2. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
