What is Google Finance | GOOGLEFINANCE data on Google Sheets

History of Google Finance

It was first launched by Google on March 21, 2006. 7 months later Google relaunched a revamped version of their finance featuring site on December 12, 2006, featuring a new homepage design that lets users see currency information, sector performance for the United States market, and a listing of top market movers along with the relevant and important news of the day.
Google added its advertising to its finance page on November 18, 2008. Since 2008, it has not undergone any major upgrades and the Google Finance Blog was closed in August 2012.

How to get data from GOOGLEFINANCE to Google Sheets

How to fitches'' current or historical securities information from Google Finance.

GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])

ticker - The ticker symbol for the security to consider. It’s mandatory to use both the exchange symbol and ticker symbol for accurate results and to avoid discrepancies. For example, use “NASDAQ:GOOG” instead of “GOOG.”

If the exchange symbol is not specified, GOOGLEFINANCE will use its best judgement to choose one for you.

Note: Reuters Instrument Codes are no longer supported. For example, use TSE:123 or ASX:XYZ instead of ticker 123.TO or XYZ.AX.

attribute - [ OPTIONAL - "price" by default ] - The attribute to fetch about ticker from Google Finance and is required if a date is specified.

attribute is one of the following for real-time data:

"price" - Real-time price quote, delayed by up to 20 minutes.
"priceopen" - The price as of market open.
"high" - The current day's high price.
"low" - The current day's low price.
"volume" - The current day's trading volume.
"marketcap" - The market capitalization of the stock.
"tradetime" - The time of the last trade.
"datadelay" - How far delayed the real-time data is.
"volumeavg" - The average daily trading volume.
"pe" - The price/earnings ratio.
"eps" - The earnings per share.
"high52" - The 52-week high price.
"low52" - The 52-week low price.
"change" - The price change since the previous trading day's close.
"beta" - The beta value.
"changepct" - The percentage change in price since the previous trading day's close.
"closeyest" - The previous day's closing price.
"shares" - The number of outstanding shares.
"currency" - The currency in which the security is priced. Currencies don't have trading windows, so open, low, high, and volume won't return for this argument.
attribute is one of the following for historical data:
"open" - The opening price for the specified date(s).
"close" - The closing price for the specified date(s).
"high" - The high price for the specified date(s).
"low" - The low price for the specified date(s).
"volume" - The volume for the specified date(s).
"all" - All of the above.
attribute is one of the following for mutual fund data:
"closeyest" - The previous day's closing price.
"date" - The date at which the net asset value was reported.
"returnytd" - The year-to-date return.
"netassets" - The net assets.
"change" - The change in the most recently reported net asset value and the one immediately prior.
"changepct" - The percentage change in the net asset value.
"yieldpct" - The distribution yield, the sum of the prior 12 months' income distributions (stock dividends and fixed income interest payments) and net asset value gains divided by the previous month's net asset value number.
"returnday" - One-day total return.
"return1" - One-week total return.
"return4" - Four-week total return.
"return13" - Thirteen-week total return.
"return52" - Fifty-two-week (annual) total return.
"return156" - 156-week (3-year) total return.
"return260" - 260-week (5-year) total return.
"incomedividend" - The amount of the most recent cash distribution.
"incomedividenddate" - The date of the most recent cash distribution.
"capitalgain" - The amount of the most recent capital gain distribution.
"morningstarrating" - The Morningstar "star" rating.
"expenseratio" - The fund's expense ratio.
start_date - [ OPTIONAL ] - The start date when fetching historical data.
If start_date is specified but end_date|num_days is not, only the single day's data is returned.
end_date|num_days - [ OPTIONAL ] - The end date when fetching historical data, or the number of days from start_date for which to return data.
interval - [ OPTIONAL ] - The frequency of returned data; either "DAILY" or "WEEKLY".
interval can alternatively be specified as 1 or 7. Other numeric values are disallowed.

Contact Us

Google Finance Sheet, Ticker For Google, Google Historical Stock Prices, Google Finance Google Sheets, Google Stock Ticker, Ticker Symbol For Google, Google Sheets Stock Price, Googlefinance Sheets, Historical Stock Price Data, Google Sheets Googlefinance, Googlefinance Attributes, Google Sheet Stock Price, Google Sheets Stocks, Google Finance Historical Data, Google Sheet Finance, Google Finance Stock Price, Google Finance In Google Sheets, Google Finance Ticker, Ticker In Finance, Google Sheets Get Stock Price, Google Sheet Google Finance, Googlefinance Price, Google Finance Data, Finance Google Sheets, Historical Financial Data, Stocks Google Sheets, Stock Price In Google Sheets, Googl Google Finance, Google Sheet Stock, Google Sheets Stock Price On Date, Google Finance In Sheets, Get Stock Price In Google Sheets, Google Sheets Stock Data, Google Finance Historical Prices, Google Finance Google Stock, Google Finance Currency Historical Data, Google Finance Real Time Data, Google Finance Historical Stock Prices, Get Historical Stock Prices, Stocks In Google Sheets, Googlefinance Date, Google Finance Price On Date, Google Stock Ticker Symbol, Google Sheets Historical Stock Price, Google Finance Date, Google Sheets Stock Ticker, Google Finance Low, Google Finance Dashboard, Google Finance Symbols, Google Finance On Google Sheets, Googlefinance Currency Date, Google Finance Sheets Currency, Google Finance Price On A Date, Sheets Stock Price, Using Google Finance In Google Sheets, Stock Data In Google Sheets, Google Sheets Financial Data, Get Historical Stock Data, Google Stock Sheet, Google Finance To Google Sheets, Stock Data Google Sheets, Google Sheets Finance Stock, Google Sheet Stocks, Google Sheets Real Time Stock Data, Googlefinance Close, Google Finance Stock Ticker, Google Finance Google Sheets Currency, Google Sheets For Finance, Google Sheets Finance Stock Price, Google Finance Earnings Date, Google Finance Stock Data, Historical Data Google Finance, Google Finance Historical, Google Finance Earnings, Google Finance Close, Get Stock Price Google Sheets, Google Finance Get Historical Data, Google Finance For Google Sheets, Stock Ticker Google Sheets, Google Finance Stock Price History, Google Sheets Historical Stock Data, Google Finance Data In Google Sheets, Google Finance Ticker Symbols, Google Finance Price Date, Historical Finance Data, Google Finance 52 Week Low, Google Sheet Real Time Stock Price, Historical Stock Price Google Sheets.