Google Finance Codes for Sheets: Tickers and Examples

In Google Sheets, “Google Finance codes” usually means the ticker symbol and, when needed, its exchange prefix used by GOOGLEFINANCE. For example, with no cell references needed, =GOOGLEFINANCE("NASDAQ:GOOG", "price") requests the current quoted price for Alphabet’s Class C shares; replace the code with the exchange and ticker for the security you want.

What a Google Finance code means

A finance code is not a special formula language or a universal number assigned to every company. It is generally a ticker symbol, sometimes qualified by an exchange code so Google can identify the listing. In a code such as NASDAQ:GOOG, NASDAQ identifies the exchange and GOOG is the ticker. The colon separates the two parts.

Some tickers are distinctive enough to work without an exchange prefix. Adding the prefix is still a good habit: symbols can be reused on different exchanges, and the same company may have multiple share classes or listings. For example, Alphabet’s Class C and Class A shares use different tickers, GOOG and GOOGL. A company name by itself is not a dependable substitute for the correct ticker.

Use the ticker for the specific security you mean, not merely the company’s brand name. A common share, preferred share, fund, depositary receipt, and bond can have different symbols and different data availability. Prefix conventions can also vary by market, so do not assume that typing a country name or a familiar exchange abbreviation will work for every international listing.

How the GOOGLEFINANCE function works

The function accepts a ticker, an optional attribute, and optional dates for historical data. The basic pattern is GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval]). Square brackets in that description indicate optional arguments; they are not typed into the formula. In a sheet, text tickers and attributes need straight double quotation marks. A cell reference, by contrast, is written without quotation marks.

For a single current quote, assume you want Alphabet’s Class C quote in one cell. The formula is:

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

If A2 contains the text NASDAQ:GOOG, the equivalent cell-reference setup is:

=GOOGLEFINANCE(A2, "price")

Google Sheets returns the requested result in the formula cell. Some requests, especially historical ones, return a small table that expands into neighboring empty cells rather than a lone value. Leave room for that output. The data comes from Google Finance and its data providers; the function does not execute a trade or connect to a brokerage account.

How to find and choose the right ticker

Look up the specific security on Google Finance and check the symbol and exchange shown for its listing. Then enter the exchange-qualified ticker in the sheet and confirm that the result corresponds to the intended company, share class, or fund. If you already have a symbol from another source, verify that it matches the Google Finance listing: market-data services do not always format symbols identically.

For a table of multiple companies, put one code in each row and use a formula that refers to that row. For instance, with ticker codes in A2:A10 and a quote formula in B2, the cell-reference version shown above can be filled down. Confirm the first few results before relying on the table; a syntactically valid code can still refer to the wrong security.

Include the exchange prefix when a symbol could be ambiguous.
Check share class and listing type, not just the company name.
Use the exact punctuation and ticker shown by the relevant listing; do not add spaces inside the ticker code.
If a listing is unavailable, try the exact Google Finance symbol or look for an alternative data source rather than guessing at a prefix.

Useful quote attributes

The attribute tells Sheets which piece of information to return. If you omit it, the function uses the default price attribute for supported securities. For clarity, it is usually better to specify the attribute you want, particularly in a shared or long-lived spreadsheet.

price requests the current quoted price.
priceopen, high, and low return the opening, high, and low prices for the current trading day where available.
volume and volumeavg request trading volume and average volume.
marketcap, pe, and eps request market capitalization, price-to-earnings ratio, and earnings per share where available.
high52 and low52 request the 52-week high and low; beta requests beta where provided.
change, changepct, and closeyest request the change, percentage change, and previous close.
currency, tradetime, and datadelay can return the quote currency, last trade time, and reported data delay.

Availability depends on the instrument and market. An attribute that works for one stock may return an error or unavailable value for another security. Do not treat a blank field as zero: it can mean the requested data is not supplied. For example, a missing earnings ratio is not evidence that the ratio is zero.

Getting historical prices

To request past data, supply a start date and either an end date or a number of days. Historical requests commonly use attributes such as open, close, high, low, volume, or all, with DAILY or WEEKLY as the interval. Use the historical attribute close when you want closing prices, rather than assuming that the current-quote attribute price will describe a date range.

For a worked example, assume you want daily closing data for NASDAQ:GOOG from January 2 through January 5, 2024. The date arguments are created with Sheets’ DATE function:

=GOOGLEFINANCE("NASDAQ:GOOG", "close", DATE(2024, 1, 2), DATE(2024, 1, 5), "DAILY")

The result is a table with dates and closing values for available trading days in that span; it will not necessarily have a row for every calendar day because markets close on weekends and holidays. The table needs clear cells below and beside the formula so it can expand. Check the dates and headers in the returned table before using its values in later calculations.

Currency codes and exchange rates

Currency pairs use a different-looking code from stock listings. Google Sheets supports currency conversion requests using a currency pair in the form CURRENCY:fromtocurrency, for example CURRENCY:USDEUR for US dollars to euros. With no cell references needed, a current-rate request is:

=GOOGLEFINANCE("CURRENCY:USDEUR")

This requests a conversion rate, not a promise that a bank or card provider will exchange money at that rate. Providers can apply spreads, fees, and different settlement rules. Rates can also move, so a result in a sheet is not a locked rate for a future transaction. For a reversed pair, reverse the currency codes; do not assume that the quoted number is interchangeable with its reciprocal without accounting for rounding.

Common errors and data limitations

A missing or incorrect quote does not always mean the formula syntax is wrong. Google Finance coverage varies by exchange, security type, and attribute, and some data can be delayed. Google says quotes may be delayed by up to 20 minutes, depending on the exchange. The function should not be treated as a real-time trading feed or as a guaranteed source for every market.

Check the code: Confirm the ticker, exchange prefix, punctuation, and share class against the listing.
Check the attribute: Try a basic price request first, then request additional fields that are supported for that instrument.
Check the arguments: Historical requests need valid dates and a supported interval; text values need quotation marks.
Check the output area: Historical results expand into a table, so existing cell contents can block the returned data.
Allow for refresh delays: A value may not change immediately, and repeated recalculation is not a substitute for a live feed.

Google Sheets can display loading or unavailable results when data cannot be retrieved. If a workbook makes many calls, it may also become slower or encounter temporary retrieval issues. Avoid building an unnecessarily large grid of duplicate requests; keep only fields and tickers that the sheet needs, and check important values against an appropriate primary source.

Google Sheets versus Excel and other sources

GOOGLEFINANCE is a Google Sheets function; it is not an Excel function. In Excel for Microsoft 365, Microsoft provides different options, including the Stocks linked data type and the STOCKHISTORY function for historical stock data. Those features have their own symbol matching, data coverage, and setup, so a Google Sheets formula cannot simply be copied into Excel and expected to work.

For a personal watchlist or a spreadsheet where approximate, delayed reference data is acceptable, Google Finance can be convenient because the lookup happens inside Sheets. For regulated reporting, an operational dashboard, or a decision that depends on exact timestamps and full market coverage, review a dedicated data provider’s terms and specifications. Confirm the source, delay, adjustment method, and supported instruments before comparing data from different services.

Frequently Asked Questions

Do I need an exchange code in every Google Finance ticker?
No. Some symbols work on their own, but adding an exchange prefix such as NASDAQ or NYSE helps identify the intended listing when a ticker could be ambiguous. Verify the exact format on Google Finance.

What is the Google Finance code for Alphabet?
Alphabet’s Class C shares use GOOG and its Class A shares use GOOGL; both are listed on Nasdaq. In Sheets, use the exchange-qualified code that matches the class you need, such as NASDAQ:GOOG or NASDAQ:GOOGL.

Why does GOOGLEFINANCE return an error for a valid ticker?
The symbol may be valid at another provider but unsupported by Google Finance, or the requested attribute may not be available for that security. Recheck the exchange prefix and try a basic quote before concluding that the instrument is covered.

Are Google Finance prices real time?
Not necessarily. Google reports that quotes may be delayed by up to 20 minutes depending on the exchange, and coverage and update timing can vary. Do not rely on the function as a real-time execution or trading feed.

Can GOOGLEFINANCE return historical stock prices?
Yes. Supply a historical attribute such as close, a start date, and an end date or number of days; you can also set a DAILY or WEEKLY interval. Historical output is a table and contains trading dates, not one row for each calendar day.

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.