Question by ets_bond_trader: Importing Yahoo Finance historical quotes into Excel?
Is there a way to have excel pull historical quotes from Yahoo Finance and then propogate the fields so that I can measure some performance metrics for different time periods (i.e. 1 and 3 month % change)?
Thanks
Best answer:
Answer by Gary E
You can import data from web pages using Data, Get External Data , From Web in Excel 2007 or Data, Get External Data, New Web Query in Excel 2003.
The wizards are good at taking you through the process of getting the data and placing it in a worksheet where you specify.
It will probably work well for a short term study of historical data.
However, the import process depends on the target web page layout not changing and my experience has been the web pages displaying information that the providers want to protect seem to routinely change to make maintenance of imports a major ongoing headache over time. Enough so for me that I have stuck with cutting and pasting any data of the type that I routinely want.
If you try using the import, and you need help with the Excel 2007 wizard or getting started in Excel 2003, indicate which version of Excel you have and where you are getting stuck and I, or someone else should be able to provide more assistance.
What do you think? Answer below!