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

Contents

Historical Prices at Google Finance

You may open https://www.google.com/finance, search a ticker like GOOGL, and click the 'Historical prices' link on the left panel.

You may use URLs like https://www.google.com/finance/historical?q=GOOGL to open pages with historical prices directly.

You may download the historical prices to a CSV file using the 'Download to spreadsheet' link on the right panel.

You may download data for the required selected period.
Unfortunately, Google allows loading historical prices using download utilities for the one last year only.

URLs to Download Historical Prices from Google Finance

You may download historical prices from Google Finance with download utilities using URLs like this:

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

You may use any free tool like CURL to download data.

We recommend you to try gwebcmd, a specialized download and parser utility.

For example, you may download data using the command like this:

gwebcmd webtocsv "http://www.google.com/finance/historical?q=GOOGL&output=csv" googl.csv /add=Symb=GOOGL /quoteChar=

gwebcmd has special useful options like /add and /quoteChar to convert loaded data.

For example, the source data look like this:

Date,Open,High,Low,Close,Volume
19-May-17,952.82,959.56,952.00,954.65,1360299
18-May-17,943.20,954.18,941.27,950.50,1800465
17-May-17,959.70,960.99,940.06,942.17,2449058

The result of gwebcmd looks like this:

Symb;Date;Open;High;Low;Close;Volume
GOOGL;2017-05-19;952.82;959.56;952;954.65;1360299
GOOGL;2017-05-18;943.2;954.18;941.27;950.5;1800465
GOOGL;2017-05-17;959.7;960.99;940.06;942.17;2449058

So, you may get CSV data suitable for further import to a database without additional conversions.

Loading Historical Prices from Google Finance with Batch Files

You may create a simple batch file to load historical prices for a list of tickers with any command line download utility.

Create a text file like 'tickers.txt' and place tickers one by line like:

TICKERS.TXT
AAPL
FB
GOOGL
YHOO

Create a batch file like 'load.cmd' with the following commands:

LOAD.CMD
@echo off

@for /F %%i in (tickers.txt) do (
    gwebcmd webtocsv "http://www.google.com/finance/historical?q=%%i&output=csv" %%i.CSV ^
        /add=Symb=%%i /quoteChar= /delay=200 /echoOutputFileName
)

Run it. You will see the result:

C:>load.cmd
AAPL.CSV - 251 rows
FB.CSV - 251 rows
GOOGL.CSV - 251 rows
YHOO.CSV - 251 rows

Pay attention to the /delay parameter. Use the delay to avoid banning your IP due to frequent multiple automatic requests.

Undocumented URLs to Download Historical Prices from Google Finance

Google has an undocumented web service that returns historical and intraday prices in a specific text format.

You may download data. However, you need a special parser like Market.csv to convert results to CSV.

URLs for daily and weekly historical prices:

http://www.google.com/finance/getprices?q=GOOGL&i=86400&p=1Y&f=d,c,v,o,h,l

http://www.google.com/finance/getprices?q=GOOGL&i=604800&p=10Y&f=d,c,v,k,o,h,l

URLs for 1, 5, 15, 30, and 60-minute intraday prices:

http://www.google.com/finance/getprices?q=GOOGL&i=60&p=1d&f=d,c,v,o,h,l

http://www.google.com/finance/getprices?q=GOOGL&i=300&p=5d&f=d,c,v,o,h,l

http://www.google.com/finance/getprices?q=GOOGL&i=900&p=5d&f=d,c,v,o,h,l

http://www.google.com/finance/getprices?q=GOOGL&i=1800&p=30d&f=d,c,v,o,h,l

http://www.google.com/finance/getprices?q=GOOGL&i=3600&p=30d&f=d,c,v,o,h,l

Downloading Historical Prices from Google Finance using Market.csv

Market.csv is a specialized tool for loading data from Yahoo Finance, Google Finance, and MSN Money.

You place the required tickers to a file like tickers.txt.

TICKERS.TXT
^VIX
SPY
AAPL
NYSE:BRK.B
RIO.L
GBPUSD

Then you execute commands to download data using the required data providers:

C:\MarketData
market.csv.exe download GoogleHistoricalPricesDaily
market.csv.exe download GoogleHistoricalPricesWeekly
market.csv.exe download GoogleIntradayPrices1m
market.csv.exe download GoogleIntradayPrices5m
market.csv.exe download GoogleIntradayPrices15m
market.csv.exe download GoogleIntradayPrices30m
market.csv.exe download GoogleIntradayPrices60m

The tool downloads data, archives the data to zip files and converts the data to CSV.

You may get results in the output files like GoogleHistoricalPricesDaily.csv, GoogleHistoricalPricesWeekly.csv, etc.

Moreover, Market.csv includes ready-to-use SQL codes and format files to import CSV data into a Microsoft SQL Server database.

Downloads

Products for Traders and Investors
WEB.CSV
The app loads data from the web (HTML, XML, JSON, and CSV) into CSV
Version: 4.7 | 11/03/2017 | 1.4MB | Home | What's New | Editions
Download
MARKET.CSV
The app loads data from Yahoo Finance, Google Finance, and MSN Money to CSV and SQL Server
Version: 2.7 | 12/13/2017 | 0.9MB | Home | What's New | Edition Comparison
Download

Disclaimer

Google Finance is a logo and registered trademark of Google Inc.