Google Finance Historical Prices
Important Notice
TheGoogleFinanceHistoricalPricesprovider is no longer functional due to changes on the Google Finance website.
Google has discontinued access to historical data via this channel.Please use alternative providers:
• Yahoo Finance Historical Prices
• MSN Money Historical PricesThese providers offer stable, up-to-date access to historical OHLCV data compatible with Excel RTD formulas.
Overview
The GoogleFinanceHistoricalPrices provider was designed to load historical price data from Google Finance directly into Microsoft Excel.
Use the following RTD formula structure:
=RTD("market.rtd",,"GoogleFinanceHistoricalPrices","<Symbol>",[<Date>],"<Data Field>")
Examples:
=RTD("market.rtd",,"GoogleFinanceHistoricalPrices","GOOGL","2017-12-31","Close")
=RTD("market.rtd",,"GoogleFinanceHistoricalPrices","GOOGL",,"Close")
In these examples:
<Symbol>is a stock ticker, such asGOOGL.<Data Field>specifies the type of data to retrieve (e.g., Close, Volume).
The Date parameter can be a valid Excel date or a string in yyyy-mm-dd format. If Date is omitted or set to 0, the formula returns data for the last trading date.
You can use the Formula Builder to generate formulas and customize separators and layout.
To find ticker symbols, visit https://www.google.com/finance/.
By default, data refreshes every 12 hours. To change this interval, use the following formula:
=RTD("market.rtd",,"GoogleFinanceHistoricalPrices","rtd_RefreshInterval",126060)
Data Fields and Excel Formulas
| Data Field | Excel Formula |
|---|---|
| Symbol | |
| Date | |
| Open | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Date],"Open") |
| High | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Date],"High") |
| Low | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Date],"Low") |
| Close | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Date],"Close") |
| Change | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Date],"Change") |
| ChangeInPercent | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Date],"ChangeInPercent") |
| ChangePercent | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Date],"ChangePercent") |
| PercentChange | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Date],"PercentChange") |
| AdjClose | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Date],"AdjClose") |
| AdjChange | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Date],"AdjChange") |
| AdjChangeInPercent | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Date],"AdjChangeInPercent") |
| AdjChangePercent | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Date],"AdjChangePercent") |
| AdjPercentChange | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Date],"AdjPercentChange") |
| Volume | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Date],"Volume") |
| PrevDate | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Date],"PrevDate") |
| PrevOpen | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Date],"PrevOpen") |
| PrevHigh | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Date],"PrevHigh") |
| PrevLow | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Date],"PrevLow") |
| PrevClose | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Date],"PrevClose") |
| PrevAdjClose | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Date],"PrevAdjClose") |
| PrevVolume | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Date],"PrevVolume") |
| RTD server values: | |
| rtd_LastError | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Date],"rtd_LastError") |
| rtd_LastMessage | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Date],"rtd_LastMessage") |
| rtd_LastUpdate | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Date],"rtd_LastUpdate") |
| rtd_LastUpdateDate | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Date],"rtd_LastUpdateDate") |
| rtd_LastUpdateTime | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Date],"rtd_LastUpdateTime") |
Aggregate Functions
| Data Field | Excel Formula |
|---|---|
| Date | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Day],"Date") |
| Day | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Day],"Day") |
| AverageVolume | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Day],"AverageVolume") |
| RTD server values: | |
| rtd_LastError | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Day],"rtd_LastError") |
| rtd_LastMessage | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Day],"rtd_LastMessage") |
| rtd_LastUpdate | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Day],"rtd_LastUpdate") |
| rtd_LastUpdateDate | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Day],"rtd_LastUpdateDate") |
| rtd_LastUpdateTime | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],[Day],"rtd_LastUpdateTime") |
Trading Days
| Data Field | Excel Formula |
|---|---|
| Date | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],"TradingDay",[Day]) |
| RTD server values: | |
| rtd_LastError | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],"TradingDay","rtd_LastError") |
| rtd_LastMessage | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],"TradingDay","rtd_LastMessage") |
| rtd_LastUpdate | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],"TradingDay","rtd_LastUpdate") |
| rtd_LastUpdateDate | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],"TradingDay","rtd_LastUpdateDate") |
| rtd_LastUpdateTime | =RTD("market.rtd",,"GoogleFinanceHistoricalPrices",[Symbol],"TradingDay","rtd_LastUpdateTime") |