Google Sheets Function· Sheets-only

GOOGLEFINANCE

Fetch current or historical market data for a stock or currency.

This function works the same in Google Sheets as it does in Excel — same syntax and arguments.

Syntax

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

GOOGLEFINANCE returns securities data (price, volume, historical series, FX rates) straight into a cell. It's Google Sheets-only and has no Excel equivalent (Excel uses the Stocks data type instead).

Arguments

tickerrequiredThe symbol, e.g. "NASDAQ:GOOG" or "CURRENCY:USDEUR".
attributeoptionalWhat to fetch, e.g. "price", "volume".

Examples

=GOOGLEFINANCE("NASDAQ:GOOG", "price")

Result: Live share price

Returns the current price of the GOOG share.

FAQ

Is GOOGLEFINANCE real-time?

Prices can be delayed up to ~20 minutes and are for informational use.

Related functions

IMPORTRANGE