Google Sheets GOOGLEFINANCE: Prices, History, and Limits

Google Sheets’ GOOGLEFINANCE function retrieves supported market information, including current quote data and historical prices, directly into a cell. Enter a ticker and an attribute, such as =GOOGLEFINANCE("NASDAQ:GOOG","price"), to request a quote; the function is useful for tracking and analysis, but its data can be delayed or unavailable and should not be treated as a live trading feed.

What GOOGLEFINANCE Does in Google Sheets

GOOGLEFINANCE connects a spreadsheet to market data that Google makes available for supported securities and currency pairs. It can return a single value, such as a share price, or a table of historical values. The returned information is placed in the sheet, where you can use it alongside ordinary formulas, charts, and filters.

The function is specific to Google Sheets. It is not an Excel function, and entering the same formula in Microsoft Excel will not retrieve Google Finance data. Google Sheets formulas can recalculate as the sheet updates, but that does not mean every quote changes continuously or at the instant a trade occurs.

People commonly use it to follow a small watchlist, compare historical closing prices, or make a chart from market data. It is not a substitute for a broker’s order screen, a financial data service with a guaranteed update schedule, or professional financial advice.

Syntax and Common Attributes

The general syntax is GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval]). The ticker is required. The remaining arguments are optional, and the date and interval arguments are used for historical requests. If you leave out the attribute, Sheets uses the default attribute, which is the price.

For a quote request, the ticker identifies the security and the attribute specifies the value you want. Common attributes include:

price for the current price reported by the data source.
priceopen, high, and low for the opening, high, and low prices associated with the current trading day.
volume and volumeavg for trading volume and average volume.
marketcap, pe, and eps for market capitalization, price-to-earnings ratio, and earnings per share when available.
high52 and low52 for the 52-week high and low, and currency for the currency in which the security is priced.
tradetime, datadelay, change, and changepct for trade-time, delay, and price-change information where supported.

Availability is not uniform across all tickers or exchanges. An attribute that works for one company may return an error or no data for another. Historical requests use a different group of attributes, generally including open, close, high, low, volume, or all.

Getting a Current Quote

For the most reliable ticker identification, include the exchange and symbol separated by a colon. With no input cells required, this example asks for the price associated with Alphabet’s Class C stock:

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

The result is the price value returned by Google Finance for that ticker; the exact number varies with the data available and the time the sheet updates, so it cannot be stated as a fixed result here. Omitting the second argument requests the default price attribute. A ticker entered without an exchange may work, but a symbol can be ambiguous or interpreted differently, so an exchange prefix is often clearer.

You can also keep ticker and attribute inputs in cells rather than editing the formula repeatedly. With the ticker NASDAQ:GOOG in A2 and the attribute price in B2, enter this in C2:

=GOOGLEFINANCE(A2,B2)

C2 returns the requested value for the ticker in A2 and attribute in B2, if that combination is supported. Copying the formula down a column lets you build a watchlist, provided each row has a valid ticker and attribute. Keep in mind that many independent requests can make a large sheet slower or more difficult to refresh.

Retrieving Historical Prices

To request historical data, supply a historical attribute and a start date. You can also specify an end date or a number of days, and optionally choose a daily or weekly interval. This example uses literal dates, so it does not depend on input cells:

=GOOGLEFINANCE("NASDAQ:GOOG","close",DATE(2025,1,1),DATE(2025,1,31),"DAILY")

The formula returns an expanded table of available daily closing-price observations for the requested period, generally with date and closing-price column headings. It will not necessarily produce one row for every calendar day: markets close on weekends and holidays, and the data source may not have an observation for every requested date. The specific prices depend on the data returned for that period.

Historical data is an array result, so leave empty cells beneath and beside the formula for the output to expand. If another value blocks the output range, Sheets may show an expansion error. A weekly interval can reduce the number of rows for a long range. For historical requests, use supported historical attributes such as close; quote attributes such as price are not interchangeable with historical attributes.

Choosing Tickers and Organizing a Watchlist

Stock symbols are not always unique across markets, and company names can change while symbols stay similar. Use the exchange prefix when possible, and check that the result corresponds to the security you intended before building calculations around it. For example, NASDAQ:GOOG identifies a different share class from NASDAQ:GOOGL.

Currency pairs use a currency ticker format rather than a stock exchange and company symbol. With no input cells required, this request asks for the USD-to-EUR currency rate:

=GOOGLEFINANCE("CURRENCY:USDEUR")

The returned value is the available exchange-rate quote, not a guaranteed rate for a bank transfer or card transaction. Financial institutions may apply spreads, fees, or their own rate-setting methods. If you use currency data in a spreadsheet, note the date and purpose of the rate and avoid assuming it matches a completed transaction.

A practical watchlist can keep symbols in one column and descriptions in another, with separate columns for requested attributes. Put headers at the top, use consistent exchange prefixes, and record when a figure is retrieved if the timing matters. A spreadsheet display is a snapshot of data available to the service, not proof that a market value is current to the second.

Refresh Behavior, Delays, and Data Limits

Google states that GOOGLEFINANCE data may be delayed, often by up to 20 minutes, and that quotes are provided for informational purposes. The actual delay and update behavior depend on the market and data source. A displayed quote can remain unchanged while the market is closed or while a particular data point has not refreshed.

Not every security, exchange, or attribute is covered. Some values may be absent, stale, or returned as an error. Historical data can also have coverage limits, and the function is not intended to provide every field available from a professional market-data feed. Google may change data availability or behavior, so avoid relying on a formula as the only source for time-sensitive decisions.

For a personal spreadsheet, the most useful safeguard is to show the ticker and requested attribute alongside the result, and to verify unusual values against a trusted source. If the sheet supports a decision with financial consequences, confirm the relevant quote, timestamp, and transaction terms independently.

Common Errors and How to Troubleshoot Them

A formula error does not always mean the syntax is wrong. Check the ticker, the attribute, and whether the requested data is available. Then confirm that a historical formula has valid dates and enough blank cells for its results.

Unrecognized ticker or missing data: add the exchange prefix, check the symbol spelling, and verify that the security is supported.
Unsupported attribute: try an attribute appropriate to the request. Historical data uses historical attributes such as close, while a current quote commonly uses price.
Array expansion error: clear cells in the area where the historical table needs to appear.
Unexpected or unchanged quote: consider market hours and data delays, then compare the value with another reliable source.
Formula parse error: check the comma-separated arguments, quotation marks around text values, and parentheses. In some spreadsheet locales, formula separators may differ.

If you want a friendlier display when a request fails, and A2 contains a ticker such as NASDAQ:GOOG, this formula returns the requested price or the word Unavailable if the request produces an error:

=IFERROR(GOOGLEFINANCE(A2,"price"),"Unavailable")

The result is either the returned price or the text Unavailable; it does not fix missing data or tell you why the request failed. Use this kind of error handling for presentation, not as a way to imply that a missing quote is a valid zero or current value.

Google Sheets Compared with Excel and Other Options

GOOGLEFINANCE is a Google Sheets function, not a formula supported by Excel. Excel users need a different data source or a feature designed for Excel, such as its connected stock data types where available. Those tools have their own setup, coverage, and refresh behavior; a GOOGLEFINANCE formula cannot simply be copied into an Excel cell.

Within Sheets, the function is convenient for straightforward quote and historical-price requests because it can return data without manually copying values. For larger projects, frequent updates, broader market coverage, or contractual service guarantees, a dedicated provider or broker platform may be more appropriate. Compare coverage, update frequency, usage terms, and cost before choosing a data source.

Charts can be made from the historical table once it has populated: select the date and value columns, then use Insert > Chart in Google Sheets. A chart does not improve the quality or freshness of the source data; it only visualizes the values the function returned. For a report, include a clear label and date context so readers do not mistake a delayed quote for a real-time one.

Frequently Asked Questions

Is GOOGLEFINANCE real time in Google Sheets?
Not necessarily. Google says data may be delayed, often by up to 20 minutes, and refresh timing varies. Do not rely on it as a real-time trading feed.

How do I get a stock price in Google Sheets?
Enter a ticker and the price attribute, for example =GOOGLEFINANCE("NASDAQ:GOOG","price"). The ticker should identify the intended exchange and security, and availability is not guaranteed for every listing.

Can GOOGLEFINANCE return historical prices?
Yes. Supply a historical attribute such as close, a start date, and optionally an end date or duration and interval. Historical results expand into a table, so leave room for the output.

Why does GOOGLEFINANCE return an error?
The ticker or attribute may be unsupported, the request may not have available data, or historical results may be blocked by occupied cells. Check the symbol and arguments, then make sure the array output area is clear.

Does GOOGLEFINANCE work in Microsoft Excel?
No. It is specific to Google Sheets. Excel requires a separate supported data feature or an external data provider, and its available instruments and refresh behavior differ.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.