Google Sheets GOOGLEFINANCE: Prices, History, and Limits

Yes. Google Sheets can retrieve financial information with the GOOGLEFINANCE function: enter a ticker and, optionally, a data attribute to show a quote, currency rate, or historical prices. For example, with no cell references required, =GOOGLEFINANCE("NASDAQ:GOOGL","price") requests Google’s latest available price for Alphabet’s Class A shares; the result may be delayed and is not guaranteed to be real time.

What GOOGLEFINANCE does

GOOGLEFINANCE is a built-in Google Sheets function that requests market information from Google Finance and displays the result in a cell or as a range. It is useful for a watchlist, a simple price-history table, or a spreadsheet that converts amounts between currencies. It is not a full trading platform, and the information it returns should not be treated as a live order quote or a substitute for checking the relevant exchange or financial provider.

The function is designed around a security or currency identifier and a requested attribute. In a current-data request, the attribute specifies what to return, such as price, trading volume, or market capitalization. In a historical-data request, the attribute identifies the price or volume series and a date range. Some attributes are unavailable for some securities, and the function can return an error when Google Finance does not recognize or provide data for the requested instrument.

Use Google Sheets in a web browser for the instructions and examples here. Google Sheets also has mobile apps, but editing and reviewing a wide output range is usually easier in the browser. Excel has separate stock and history features; its formulas and data connections are not interchangeable with GOOGLEFINANCE.

Basic syntax and ticker symbols

The general syntax is GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval]). The ticker is normally a text value, often with an exchange prefix such as NASDAQ:GOOGL or NYSE:KO. Including the exchange can help distinguish securities that have similar symbols. A ticker accepted by one provider is not necessarily recognized by Google Finance.

With a ticker typed directly into the formula and no input cells, this requests the latest available price:

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

With the exchange-qualified ticker in A2, this version lets you change the security by editing that cell:

=GOOGLEFINANCE(A2,"price")

For many quote requests, the attribute can be omitted and the function returns the price by default. Naming it explicitly is clearer when someone else will read or maintain the sheet. Common current-data attributes include price, priceopen, high, low, volume, marketcap, tradetime, datadelay, volumeavg, pe, eps, shares, and currency. Availability varies: a blank or error is possible even when the ticker itself is valid.

Getting historical prices

To request historical data, give the function a historical attribute and a start and end date. Historical requests return a table that spills into neighboring cells, commonly with a date column and a column for the requested value. Leave enough empty space to the right and below the formula; existing values in the output area can prevent the result from expanding.

With the ticker in A2 and no date cells needed, this requests daily closing prices from January 1 through January 5, 2024:

=GOOGLEFINANCE(A2,"close",DATE(2024,1,1),DATE(2024,1,5),"DAILY")

The date range is illustrative; it is not a prediction or a recommendation. The historical attributes include open, close, high, low, and volume. The interval can be DAILY or WEEKLY. For example, changing the final argument in the formula above to "WEEKLY" requests weekly data rather than daily rows. Historical output is a result table, not a single quote, so formulas that expect one value may need to refer to a particular cell in that returned table.

To keep a sheet adaptable, put the first and last dates in cells and refer to them in the function. With the ticker in A2, start date in B2, and end date in C2, use:

=GOOGLEFINANCE(A2,"close",B2,C2,"DAILY")

Use actual date values in B2 and C2, rather than text that only looks like a date. If you want to compare prices across securities, remember that different exchanges may have different trading calendars, currencies, and holiday schedules. A missing row does not necessarily mean the security had a zero price.

Currency exchange rates

GOOGLEFINANCE can return exchange-rate data using a currency pair. The pair is written as CURRENCY: followed by the source and target currency codes. For example, with the formula entered in any empty cell, this requests the USD-to-EUR rate:

=GOOGLEFINANCE("CURRENCY:USDEUR")

The returned figure represents the requested conversion rate, not a guaranteed rate available to a customer at a bank, card provider, or currency exchange counter. Providers can apply spreads, commissions, and different rates. If the rate is used in a spreadsheet calculation, label the currencies clearly and record the date or time of the rate when that distinction matters. A displayed exchange rate can change, and the function is not a source of binding transaction terms.

Delays, coverage, and data limitations

Google Finance quotes may be delayed; Google states that market data can be delayed by up to 20 minutes, depending on the exchange. Do not assume that a cell updates tick by tick or represents the price at the moment you view it. Delays and data availability differ by market and instrument. If timing matters for a decision or transaction, confirm the quote with the exchange, broker, or other appropriate source.

Coverage is not universal. Some international exchanges, securities, and attributes may not be supported, and Google notes that not all markets provide every kind of data. A ticker copied from another service may need an exchange prefix or may simply be unavailable. The function can also produce errors when a symbol is invalid, a requested attribute is unsupported, or data is temporarily unavailable. Check the ticker and attribute before assuming the spreadsheet itself is broken.

Quotes can be delayed and are not guaranteed to be real-time.
Not every exchange, ticker, security type, or data attribute is covered.
Historical results can differ from a quote because the date, trading session, or market calendar differs.
Historical data from GOOGLEFINANCE cannot be downloaded or accessed through the Google Sheets API or Apps Script, according to Google’s function documentation.
The function’s output and availability can change; it is not an archival or audited market-data feed.

For these reasons, a spreadsheet built with this function is best viewed as a convenient reference or analysis aid. It is not suitable as the sole source for time-sensitive execution, compliance records, or a guaranteed historical data archive.

Building a useful watchlist

A simple watchlist can pair a ticker column with one or more quote columns. With symbols in A2:A10, enter a price formula in B2 using A2 as the ticker, then fill it down. With the ticker in A2, the formula is:

=GOOGLEFINANCE(A2,"price")

Keep the ticker in its own column instead of embedding it separately in every formula. That makes it easier to audit the symbols, change an instrument, and spot a typo. Add plain-language headings such as “Ticker,” “Price (source currency),” and “Last checked” so readers do not confuse a quote with a portfolio value or a guaranteed execution price.

For a more informative sheet, consider including:

The full company or fund name beside the exchange-qualified ticker.
A currency column, since prices from different markets may not share a currency.
A note explaining whether the figure is current data or historical closing data.
A date range and interval for historical tables.
A separate source or verification note for data that must be checked elsewhere.

Do not assume that putting multiple calls in a sheet creates a synchronized snapshot. Different instruments can have different delays, trading hours, and update behavior. If the sheet is shared, explain those limitations near the values rather than relying on readers to infer them.

Troubleshooting common problems

If a formula returns an error, start with the simplest checks. Confirm that the ticker is spelled correctly and that the exchange prefix is appropriate. Try a commonly supported attribute such as price, then verify whether the security and requested attribute are available through Google Finance. Check quotation marks, commas, and parentheses if the formula was copied from a document or another locale; Sheets formulas in many locales use different argument separators.

If a historical formula gives a result but not the layout you expected, inspect the cells beside and below it. Historical requests return multiple cells, and occupied cells can block the expanded output. Also check that the start and end dates are valid date values and that the requested interval is DAILY or WEEKLY. A historical request for a holiday or a date without a trading session will not necessarily create a row for that date.

If a quote seems stale, remember that the function may be delayed and does not promise a refresh at a particular instant. Re-entering a formula repeatedly is not a dependable way to obtain a live quote. Check the value against Google Finance or a source appropriate to your need, and avoid designing a time-critical process around spreadsheet recalculation.

How it compares with alternatives

Google Sheets’ main advantage is convenience: the function is built into the spreadsheet and can return both quote-style values and historical tables without a separate data-import setup. Its main trade-off is limited coverage and control. It does not provide the service guarantees, broad instrument coverage, or synchronized low-latency feed that may be required for professional market-data work.

In Excel, Microsoft 365 offers different tools, including linked Stocks data types and the STOCKHISTORY function in supported versions. These features have their own coverage and update behavior; they do not use Google Finance data, and Excel does not recognize the Sheets-only GOOGLEFINANCE function. A third-party market-data provider may offer an API or downloadable files, but check its price, licensing, supported exchanges, delay, rate limits, and permitted use before building a workbook around it. For occasional reference, manually checking an exchange or broker may be simpler and more reliable than maintaining a complex data connection.

Frequently Asked Questions

Is Google Sheets GOOGLEFINANCE real time?
Not necessarily. Google Finance market data can be delayed by up to 20 minutes, depending on the exchange, and updates are not guaranteed to be instantaneous. Verify time-sensitive quotes with a suitable provider.

How do I get a stock price in Google Sheets?
Enter a ticker and the price attribute in a cell, for example =GOOGLEFINANCE("NASDAQ:GOOGL","price"). Use an exchange prefix where possible, and check that Google Finance supports the symbol.

Can GOOGLEFINANCE return historical prices?
Yes. Specify a historical attribute such as close, a start date, an end date, and optionally a daily or weekly interval. The output expands into a table, so keep the surrounding cells empty.

Why is GOOGLEFINANCE not working for my ticker?
The ticker or exchange prefix may be wrong, the security may not be covered, or the requested attribute may be unavailable. Test a supported attribute and confirm the symbol on Google Finance; some markets and instruments are not supported.

Can I use GOOGLEFINANCE in Excel?
No. GOOGLEFINANCE is a Google Sheets function. Excel has separate stock-data features, including Stocks data types and, in supported versions, STOCKHISTORY; they work differently and draw on different services.

Can I rely on GOOGLEFINANCE for investment decisions?
It can be useful for general reference and spreadsheet analysis, but its data may be delayed, incomplete, or unavailable. It is not financial advice or a guaranteed trading quote; check real transaction terms and consult a qualified professional when appropriate.

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.