Oct 02, · This time we’ll use the improved Query system in recent versions of Excel combined with data from Google Finance. It’s a sad indictment of Microsoft Office that the best place to get stock data is Google. Google’s version of Excel is Sheets and that has a Author: slicelive.com How to Import Share Price Data into Excel (with Yahoo! Finance) IMPORTANT: On 2 November , Yahoo blocked access to the CSV API. No solution is yet known. Editor's Note: This software is non-commercial and for personal use only. No support is available. Yahoo! and Google both unofficially provide a free way to download stock quotes using an API. Historical prices are also available on Google Finance outside of the Portfolios section. The Portfolio and Historical Prices sections of the website have the option of downloading the information in spreadsheet format, which you can then import to Excel. Google Finance, like most Google services, requires a .