GOOGLEFINANCE function in Google Sheets

GOOGLEFINANCE fetches current or past prices of shares and currencies from Google Finance.

GOOGLEFINANCE brings market data into a sheet: share prices, index levels, currency rates. With it, a list of holdings can show its own current value. Nothing has to be typed in or downloaded.

The examples have no results printed here, because the answers change through the day. The information on this page is about how the function works. It is not investment advice.

Syntax

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

Argument	What it is
`ticker`	The exchange and symbol as text, such as "NSE:INFY", or a currency pair such as "CURRENCY:USDINR".
`attribute`	What to fetch: "price" (the default), "high", "low", "volume", "marketcap", "pe", "close" and others.
`start_date`	For past data: the first date.
`end_date or num_days`	The last date, or a number of days from the start date.
`interval`	"DAILY" or "WEEKLY".

Examples

=GOOGLEFINANCE("NSE:INFY")
Result: depends on live data or changes each time
The latest available price of a share, named by exchange and symbol.
=GOOGLEFINANCE("NSE:INFY","pe")
Result: depends on live data or changes each time
A named attribute: here the price-to-earnings ratio.
=GOOGLEFINANCE("CURRENCY:USDINR")
Result: depends on live data or changes each time
A currency rate: how many rupees for one US dollar.
=100*GOOGLEFINANCE("CURRENCY:USDINR")
Result: depends on live data or changes each time
A conversion: 100 dollars in rupees.
=GOOGLEFINANCE("NSE:INFY","close",DATE(2026,1,1),DATE(2026,1,31),"DAILY")
Result: depends on live data or changes each time
Past closing prices for a month, as a table of dates and prices.
=INDEX(GOOGLEFINANCE("CURRENCY:USDINR","price",DATE(2026,1,15)),2,2)
Result: depends on live data or changes each time
The rate on one past date. A historical request returns a small table with headings, and INDEX picks the value from its second row and column.

Before relying on it

Google states that the data may be delayed, by up to about twenty minutes for some exchanges, and that it is provided "as is" for information, not for trading. Treat the figures as a convenient guide. For a transaction, a tax return or accounts, use the figures from your broker, the exchange or your bank.

Not every exchange and instrument is covered, and coverage changes. If a symbol returns #N/A, check on the Google Finance website whether it is listed there and under what code.

The ticker

Write the exchange code, a colon and the symbol, in quotation marks: "NSE:INFY", "BOM:500209", "NASDAQ:GOOG". Without the exchange, Google guesses, and may pick a company of the same symbol in another country. Always include it.

Keep the tickers in a column and refer to the cell: =GOOGLEFINANCE(A2). Then one formula, copied down, prices a whole list.

Attributes

Attribute	Gives
`"price"`	latest price (the default)
`"priceopen"`	today's opening price
`"high"`, `"low"`	today's high and low
`"volume"`	shares traded today
`"marketcap"`	market capitalisation
`"pe"`	price-to-earnings ratio
`"eps"`	earnings per share
`"high52"`, `"low52"`	52-week high and low
`"change"`, `"changepct"`	change since the previous close
`"closeyest"`	previous day's close

Some attributes are not available for every instrument.

Currencies

A currency pair is written "CURRENCY:" followed by the two three-letter codes, from and to: "CURRENCY:USDINR" is the price of one dollar in rupees. Multiply an amount by it to convert. The rate is a market mid-rate. A bank or card will apply its own rate and charges.

Past prices

Give a start date, and either an end date or a number of days, and the function returns a table: a heading row, then a row for each day with the date and the value. Dates in the result carry a time of day.

Because a historical request returns a table even for a single day, picking one figure needs INDEX, as in the last example: row 2, column 2 is the first value under the headings.

Past data makes a good partner for SPARKLINE: =SPARKLINE(GOOGLEFINANCE("NSE:INFY","close",TODAY()-90,TODAY())) draws three months of prices in one cell.

A simple holdings table

With tickers in column A, quantities in B and purchase prices in C:

current price: =GOOGLEFINANCE(A2)
current value: =B2*GOOGLEFINANCE(A2)
gain or loss: =B2*(GOOGLEFINANCE(A2)-C2)

Limits

Prices update while the sheet is open, not continuously.
Historical results cannot be used through the Sheets API or downloaded by scripts in some cases. Google restricts this data.
Mutual fund NAVs, bonds and many smaller instruments are often missing.

Common mistakes

No exchange in the ticker.
Expecting a single number from a historical request.
Dates typed as text. Use DATE.
#N/A for a symbol Google Finance does not carry, or outside its coverage.
Treating a delayed, indicative figure as exact.

In Excel

Excel has no GOOGLEFINANCE. Microsoft 365 offers a Stocks data type and a STOCKHISTORY function. A sheet with GOOGLEFINANCE keeps only its last values when saved as an Excel file.

Related functions

The results on this page were worked out by us from the sample sheet; they were not produced by a script running Google Sheets. If Sheets shows you something different, please tell us.

This is an independent help site. It is not connected with or approved by Google. Google Sheets is a trademark of Google LLC, named here only to say which program a formula is for. The people and figures in the sample sheets are made up.