Sample OpenOffice Calc file to download Yahoo! stock quotes and historical data into spreadsheet
In the example, I enter Yahoo! stock symbols into cells A5 till A12. Cell A12 is a dummy variable - more about it later. To get the stock details, i.e. price, stock name, last date, bid, ask and volume, I select cells B5 till G11, enter "=GETSTOCKDETAILS(A5:A12)" and then press the keys control-shift-enter together. It will retrieve the quote details in a single web query.
Often, you might
Read more [...]