Knowledge Base | How to Load Historical Stock Prices from Google Finance to Excel

Contents

Overview

Google Finance allows loading historical prices in CSV using URLs like

http://www.google.com/finance/historical?q=GOOGL&output=csv

You may open this URL directly in Microsoft Excel using the Data, From Web wizard.

However, you may use our several products to load these data into Microsoft Excel in several ways, for free.

Loading Historical Prices from Google Finance into Microsoft Excel using SaveToDB Add-In

The SaveToDB add-in allows opening XML, JSON, HTML, and CSV from the web and converting data to refreshable Excel tables.

Moreover, you may customize URLs to change symbols using the ribbon:

Load Data from Web

Also, you may create and apply table views to filter data using various conditions directly in Excel:

Create Different Table Views

You may use these features in the free SaveToDB Express edition.

To load historical prices, click Wizards, Data Connection Wizard, select Web Data Provider and select an URL to connect.

URLs of historical prices from Google Finance look this:

http://www.google.com/finance/historical?q={Symbol=GOOGL}&output=csv

You may see the defined URL parameter with the default value like {Symbol=GOOGL}.

The SaveToDB add-in is a free cool tool to load data from the web. Try it.

Loading Historical Prices from Google Finance into Microsoft Excel using WEB.RTD

WEB.RTD is another cool tool that allows loading data from 20 URLs for free.

WEB.RTD is a universal downloader and parser.

You may start Formula Builder, paste the URL, and click Go.

Formula Builder loads data and creates RTD formulas that you copy into Excel spreadsheets:

WEB.RTD Formula Builder

Then you may remove unnecessary formulas and organize formulas to get the required reports and models:

Report Worksheet Example

WEB.RTD refreshes data automatically with the period specified by a formula like:

=RTD("web.rtd",,$A$1,"RTD_REFRESHINTERVAL",24*60*60)

WEB.RTD is a cool tool as you may load almost everything that you see on the web.

However, you should know data URLs.

Loading Historical Prices from Google Finance into Microsoft Excel using Market.rtd

WEB.RTD, described above, is a universal parser and RTD server for Microsoft Excel.

Contrary, Market.rtd is a specialized RTD server for loading data from Yahoo Finance, Google Finance, and MSN Money.

You may also create and copy formulas using Formula Builder.

However, Formula Builder contains predefined data providers that is much better.

Market.rtd Formula Builder - Providers

You may select how to organize formulas, by rows or by columns, and paste them into Microsoft Excel spreadsheets.

Then you format your model and get refreshable results like this:

Example of Google Finance Quotes

You may get a lot of data using Market.rtd with the regular Microsoft Excel RTD formulas like these:

=RTD("market.rtd",,"GoogleFinanceHistoricalPricesCSV","GOOGL","2016-12-30","Open")
=RTD("market.rtd",,"GoogleFinanceHistoricalPricesCSV","GOOGL","2016-12-30","Close")
=RTD("market.rtd",,"GoogleFinanceHistoricalPricesCSV","GOOGL","2016-12-30","PrevClose")

You may customize the refresh interval using the formula like:

=RTD("web.rtd",,"GoogleFinanceHistoricalPricesCSV","RTD_REFRESHINTERVAL",24*60*60)

The free edition of Market.rtd allows refreshing data for 10 tickers (in all opened workbooks).

However, you may change tickers. So, you may build your models for free.

Moreover, Market.rtd includes a lot of examples for available providers. So, you may adapt them to your needs easily.

Downloads

Products for Traders and Investors
SaveToDB Add-In for Microsoft Excel
The add-in loads data from the web (HTML, XML, JSON, and CSV) into Microsoft Excel
Version: 8.0 | 11/27/2017 | 15.0MB | Home | What's New | Editions
Download
WEB.RTD
The app loads data from the web (HTML, XML, JSON, and CSV) into Microsoft Excel
Version: 1.7 | 12/13/2017 | 5.4MB | Home | What's New | Edition Comparison
Download
MARKET.RTD
The app loads data from Yahoo Finance, Google Finance, and MSN Money into Microsoft Excel
Version: 5.8 | 12/15/2017 | 4.3MB | Home | What's New | Edition Comparison
Download

Disclaimer

Google Finance is a logo and registered trademark of Google Inc.
Microsoft Excel is a logo and registered trademark of Microsoft Corporation.