In the example, I enter Yahoo! stock symbols into cells A5 till A12. Cell A12 is a dummy variable – more about it later. To retrieve 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 want to refresh the quote info as the quotes might change during the day. To do that, just change the dummy variable (cell A12) to another value. This will force another fetch from the Yahoo! server.
The historical data is imported on a similar principle. I hope the 2 examples in the file is self-explanatory. The function name for historical data is GETSTOCKHISTORY.