What is the GOOGLEFINANCE Function

The stock market moves fast.

Blinking red and green numbers, breaking news, wild swings.

For investors, keeping up feels like chasing a runaway train.

You’ve got spreadsheets open, browser tabs multiplying, and a growing headache from trying to piece it all together.

What if you could stop chasing?

What if the numbers came to you?

Real-time updates, historical trends – all neatly delivered into your Google Sheet with a single formula?

Use our Google Finance Watchlist Template to easily monitor all your favorite stocks in one place.

That's the magic of the GOOGLEFINANCE function.

It is your backstage pass to the stock market that lets you pull live prices, track trends, and manage your portfolio effortlessly.

Why Is the GOOGLEFINANCE Function So Useful?

The GOOGLEFINANCE function enables you to make sense of the stock market.

Here's what it can do:

• Fetch Real-Time Data: Instantly grab live prices, market caps, and trading volumes.
• View Historical Trends: Explore daily or weekly stock data from the past.
• Track Your Portfolio: Create custom dashboards that update automatically, so you can see exactly how your investments are performing.

Learn more about how to get all the stock data you need directly in Google Sheets.

How to Use the GOOGLEFINANCE Function (Step-by-Step)

The GOOGLEFINANCE function is incredibly easy to use, even if you’re new to Google Sheets. With just one formula, you can pull everything from live stock prices to detailed historical trends.

Let’s break it down step-by-step so you can start using it right away.

a. Basic Usage: Understanding the Syntax

The basic structure of the GOOGLEFINANCE function looks like this:
=GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date], [interval])

Here’s what each part means:

• Ticker (Required): The stock symbol, like "AAPL" for Apple or "GOOGL" for Alphabet.
• Attribute (Optional): The specific data you want, like price, volume, or market cap. If left blank, the default is real-time price.
• Start_date (Optional): The beginning of the date range for historical data. Use DATE(year, month, day) format.
• End_date (Optional): The end of the date range. If omitted, the data will include up to today.
• Interval (Optional): Choose "daily" or "weekly" for historical data frequency.

Table of Attributes: What Data Can You Pull?

Here’s a handy guide to the most common metrics you can fetch:

Also, check out our guide on Google Finance Dividend Yield to explore this specific data metric.

Attribute	Description	Type
"price"	Current stock price	Real-Time
"high"	Day’s high price	Real-Time
"low"	Day’s low price	Real-Time
"volume"	Current trading volume	Real-Time
"marketcap"	Total market capitalization	Real-Time
"close"	Closing price for a specific day	Historical
"open"	Opening price for a specific day	Historical
"all"	Returns all available historical metrics	Historical

b. Real-Time Data Example: Getting Live Stock Prices

If you want to fetch a stock’s real-time price, here’s what you do:

1. In a cell, type: =GOOGLEFINANCE("MSFT", "price")
2. Press enter. The current price for Microsoft stock will appear.

This formula updates automatically every few minutes, ensuring you always have the latest data.

c. Historical Data Example: Exploring Past Performance

To analyze how a stock has performed over a specific period, you’ll use the historical parameters.

Example: Get Apple’s Trading Volume for July 2021

In a cell, type:

• =GOOGLEFINANCE("AAPL", "volume", DATE(2021, 7, 1), DATE(2021, 7, 31), "daily")
• Press enter. A table will populate, showing the daily trading volume for Apple during July 2021.

Tips for Using GOOGLEFINANCE Effectively

• Leave Space for Data: When pulling historical data, the function may return multiple rows and columns. Ensure there’s enough blank space in your sheet to avoid errors.
• Combine with Other Functions: Use formulas like AVERAGE() or SPARKLINE() to create summaries or visualizations.

What Exchanges Can It Access?

One of the best things about GOOGLEFINANCE is its reach. It connects you to stock exchanges across the globe, no matter where you are tracking.

Region	Exchange Code	Description	Delay (minutes)
Americas	BCBA	Buenos Aires Stock Exchange	20
BMV	Mexican Stock Exchange	20
BVMF	B3 – Brazil Stock Exchange and Over-the-Counter Market	15
CNSX	Canadian Securities Exchange	Realtime
CVE	Toronto TSX Ventures Exchange	15
NASDAQ	NASDAQ Last Sale	Realtime *
NYSE	NYSE	Realtime *
NYSEARCA	NYSE ARCA	Realtime *
NYSEAMERICAN	NYSE American	Realtime *
OPRA	Options Price Reporting Authority	15
OTCBB	FINRA OTC Bulletin Board	15
OTCMKTS	FINRA Other OTC Issues	15
TSE	Toronto Stock Exchange	15
TSX	Toronto Stock Exchange	15
TSXV	Toronto TSX Ventures Exchange	15
Europe	AMS	Euronext Amsterdam	15
BIT	Borsa Italiana Milan Stock Exchange	Realtime
BME	Bolsas y Mercados Españoles	15
CPH	NASDAQ OMX Copenhagen	Realtime
EBR	Euronext Brussels	15
ELI	Euronext Lisbon	15
EPA	Euronext Paris	15
ETR	Deutsche Börse XETRA	15
FRA	Deutsche Börse Frankfurt Stock Exchange	Realtime
HEL	NASDAQ OMX Helsinki	Realtime
ICE	NASDAQ OMX Iceland	Realtime
IST	Borsa Istanbul	15
LON	London Stock Exchange	Realtime
MCX	Moscow Exchange	Realtime
RSE	NASDAQ OMX Riga	Realtime
STO	NASDAQ OMX Stockholm	Realtime
SWX, VTX	SIX Swiss Exchange	15
TAL	NASDAQ OMX Tallinn	Realtime
VIE	Vienna Stock Exchange	15
VSE	NASDAQ OMX Vilnius	Realtime
WSE	Warsaw Stock Exchange	15
Africa	JSE	Johannesburg Stock Exchange	15
Middle East	TADAWUL	Saudi Stock Exchange	15
TLV	Tel Aviv Stock Exchange	20
Asia	BKK	Thailand Stock Exchange	15
BOM	Bombay Stock Exchange Limited	Realtime
KLSE	Bursa Malaysia	15
HKG	Hong Kong Stock Exchange	15
IDX	Indonesia Stock Exchange	10
KOSDAQ	KOSDAQ	20
KRX	Korea Stock Exchange	20
NSE	National Stock Exchange of India	Realtime
SGX	Singapore Exchange	Realtime
SHA	Shanghai Stock Exchange	1
SHE	Shenzhen Stock Exchange	Realtime
TPE	Taiwan Stock Exchange	Realtime
TYO	Tokyo Stock Exchange	20
South Pacific	ASX	Australian Securities Exchange	20
NZE	New Zealand Stock Exchange	20

These exchanges give you access to real-time or slightly delayed data. They cover prices, volumes, and performance metrics from markets all over the world.

Advanced Features and Tips

The GOOGLEFINANCE function is powerful on its own. But when combined with other features in Google Sheets, it becomes a truly dynamic tool for tracking, analyzing, and visualizing your investments.

Here are some advanced ways to level up your usage:

a. Combining GOOGLEFINANCE with Other Functions

Want to go beyond raw numbers? Combine GOOGLEFINANCE with other Google Sheets functions to create meaningful visuals and summaries.

Visualize Trends with SPARKLINE

The SPARKLINE function generates mini charts right inside your sheet, perfect for visualizing stock trends over time.

Example: Creating a Trendline for a Stock Price

1. Fetch historical closing prices for a stock:
   =GOOGLEFINANCE("AAPL", "close", DATE(2023, 1, 1), DATE(2023, 12, 31))
2. Use SPARKLINE to display these prices as a chart:
   =SPARKLINE(B2:B250) (Assuming your data is in column B)

b. Building a Portfolio Tracker

One of the best ways to use GOOGLEFINANCE is to build a portfolio tracker that updates automatically.

Steps to Set Up a Portfolio Tracker

1. Create a Table: Add columns for ticker, stock name, number of shares, purchase price, current price, and total value.
2. Fetch Data: Use GOOGLEFINANCE to pull real-time stock prices into the current price column:
   =GOOGLEFINANCE(B3, "price")(Assuming your ticker symbols are in column B).
3. Calculate Total Value: Multiply the number of shares by the current price.
   Example formula: =D3*F3 (Shares in column D, current price in column F).

c. Common Limitations and Workarounds

While GOOGLEFINANCE is a fantastic tool, it has a few gaps that can limit its utility:

• No Financial Statements: You won’t find income statements, balance sheets, or cash flow data.
• Delayed Data: Some exchanges provide data with a delay of 15-20 minutes.

The Solution: Wisesheets

To overcome these limitations, pair GOOGLEFINANCE with Wisesheets, a tool designed to provide detailed financial data for stock analysis.

With Wisesheets, you can:

• Access 20 years of financial data, including income statements, balance sheets, and cash flows.
• Fetch metrics with a simple formula like:
  =WISE("AAPL", "REVENUE", 2020, "Q1") (Apple’s revenue for Q1 2020).
• Retrieve detailed data for exchange-traded funds (ETFs) alongside individual stocks.
• Fetch historical and current dividend income to track income from investments.
• Access forward-looking analyst estimates to better understand potential stock performance.
• Seamlessly integrate with Google Sheets or Excel for a complete analysis experience.

Why Combine GOOGLEFINANCE and Wisesheets?

GOOGLEFINANCE is like having binoculars at a football game.

You can see who’s got the ball. Maybe even who’s sprinting.

But you’re still missing the stats, the playbook, the backstory.

Wisesheets is like the analyst in the locker room with the whiteboard.

It’s calling out the turnovers, the play-calling mistakes, the yards after contact.

It’s breaking down the team’s performance over the last five seasons – not just what’s happening on the field today.

With a single formula, it’ll tell you how much cash Apple actually pulled in last year. Or how Microsoft’s dividend payouts have grown (or stalled). Or what Nvidia’s profit margins looked like the last time interest rates were this high.

Here’s what you can do with Wisesheets:

• Pull income statements, balance sheets, and cash flows

• Retrieve specific financial data using the WISE function

Example:

=WISE("AAPL", "Revenue", 2023)
=WISE("AAPL", "Net Income", 2023)
=WISE("AAPL", "Operating Cash Flow", 2023)

• Track quarterly EPS for earnings trend analysis

Example:

=WISE("AMZN", "EPS", 2024, "Q1")
=WISE("AMZN", "EPS", 2023, "Q4")

• Analyze dividend growth over time

Example:

=WISE("MSFT", "Dividend", 2022)
=WISE("MSFT", "Dividend", 2021)

• Compare valuation metrics like P/E ratios

Example:

=WISE("GOOGL", "PE Ratio", 2023)
=WISE("NVDA", "PE Ratio", 2023)

Wisesheets works natively inside both Excel and Google Sheets, making it easy to combine with GOOGLEFINANCE for a complete investing dashboard.

Pro Tip: Use GOOGLEFINANCE for real-time tracking and Wisesheets for deep financial analysis. Together, they turn your spreadsheet into a full-blown investing toolkit.

Common Errors and How to Fix Them

Even though the GOOGLEFINANCE function is simple to use, you may encounter a few common errors. Don’t worry – most of these are easy to troubleshoot and fix.

Here’s a breakdown of frequent issues and how to resolve them:

a. #REF Error

Why It Happens: The #REF error usually appears when there isn’t enough space in your sheet to display the data, especially when pulling historical data that returns multiple rows and columns.

Solution:

• Ensure there’s enough blank space below and to the right of the cell where you entered the formula.
• If you’re pulling large datasets, consider placing the formula in a separate, empty tab for better organization.

b. Incorrect Syntax or Invalid Ticker

Why It Happens:
This error occurs when:

• The stock ticker is misspelled or incorrect (e.g., “AAPL” vs. “APPL”).
• The formula syntax isn’t structured properly, such as missing quotation marks.

Solution:

• If your ticker or attribute is in a cell, ensure it’s referenced correctly (e.g., =GOOGLEFINANCE(A1, B1)).
• Double-check the ticker symbol on reliable sources like Google Finance or Yahoo Finance.
• Follow this syntax for accuracy: =GOOGLEFINANCE("TICKER", "ATTRIBUTE")

c. GOOGLEFINANCE Not Working

Why It Happens:
There are times when GOOGLEFINANCE simply doesn’t return data. This might be due to:

• Delayed updates from certain exchanges (e.g., 15-20 minutes for some regions).
• Unsupported metrics or attributes.
• Google’s financial data provider temporarily being unavailable.

Solution:

1. Check for delays: Refer to the list of supported exchanges and their delays to confirm.
2. Verify metric availability: Some advanced metrics like full financial statements aren’t supported by GOOGLEFINANCE. Consider using complementary tools like Wisesheets for these gaps.
3. Retry later: In rare cases, data may be unavailable temporarily. If the issue persists, it may indicate an unsupported ticker or region.

Tips to Avoid Errors

• Always test your formulas with a small dataset before scaling up.
• Use Google’s support page to verify the latest syntax and updates to the function.
• Keep an alternative tool like Wisesheets handy for unsupported metrics or advanced financial data.

Learn more about Yahoo Finance API and other advanced stock data solutions.

Download Your Free GOOGLEFINANCE + Wisesheets Template

Managing investments has never been easier. With our GOOGLEFINANCE + Wisesheets Template, you’ll have everything you need to track, analyze, and visualize stock data at your fingertips.

Download Your Free Template

Note: To use the template, you’ll need a Wisesheets account. Don’t have one yet? Get your Wisesheets account here for free.

What’s Inside the Template?

• Dynamic Financial Metrics: Access key financial data for any stock, including revenue, market cap, PE ratio, and more.
• Integrated Wisesheets Functions: Get detailed financials, such as income statements and cash flows, for over 14 global exchanges.
• Pre-Built Calculations: Automatically calculate 3-year averages, financial ratios, and per-share metrics for deeper insights.

How to Use the Template

1. Change the Ticker: Replace the stock ticker in cell A1 with the company you want to analyze (e.g., "AAPL" for Apple).

2. Press Enter: Hit Enter, and the template will automatically fetch and update the data for your selected company.

3. Dive into Metrics: Review metrics like revenue, PE ratio, and cash flows, all dynamically calculated and displayed.

FAQs About the GOOGLEFINANCE Function

How often does the data update?

The update frequency depends on the stock exchange:

• Real-Time Data: Some exchanges, like NASDAQ or NYSE, provide real-time updates.
• Delayed Data: Other exchanges might have delays of 15–20 minutes.

You can refer to the list of supported exchanges and delays in the What Exchanges Can It Access? section.

---

What are the most commonly used metrics?

Here are the most popular attributes you can pull with the GOOGLEFINANCE function:

• "price": Real-time stock price.
• "volume": Trading volume for the current day.
• "high" / "low": Daily high or low prices.
• "close": Closing price for a specific day (historical).

For a complete list, refer to the Basic Usage section where attributes are detailed.

---

Does GOOGLEFINANCE work for mutual funds, crypto, etc.?

• Mutual Funds: Limited support for mutual funds, depending on the exchange.
• Crypto: Unfortunately, GOOGLEFINANCE does not directly support cryptocurrencies.
• Alternative: Use tools like Wisesheets or dedicated APIs for crypto and mutual fund data.

---

What can I do if GOOGLEFINANCE stops working?

If the function doesn’t return data or displays an error:

1. Check the ticker: Ensure it’s spelled correctly and supported.
2. Verify availability: Some attributes or regions may not be supported.
3. Retry later: Data availability can sometimes be affected by Google’s provider.

For unsupported metrics like full financial statements or cryptocurrency, consider pairing GOOGLEFINANCE with a tool like Wisesheets.

---

Does GOOGLEFINANCE Function get the total number of shares?

No, GOOGLEFINANCE does not directly provide the total number of shares for a company.
Workaround: Use other financial tools or APIs to access this metric if needed.

---

Simplifying Stock Tracking with GOOGLEFINANCE

Tracking the stock market can feel like chaos. Numbers flying around, tabs open everywhere, trying to make sense of it all.

But it doesn’t have to be this complicated.

The GOOGLEFINANCE function keeps things simple. Real-time prices, historical data, automatic updates – all in one place.

So, give it a shot. Mess around with the examples. Change a ticker, tweak a formula, see how easy it is to get the info you need.

But the truth is, even GOOGLEFINANCE can only take you so far. For full-on financial analysis, like income statements or detailed metrics, Wisesheets is where it’s at. It’s the backup you didn’t know you needed.

Try Wisesheets for Free