What is GOOGLEFINANCE in Google Sheets?
GOOGLEFINANCE connects your sheet to Google market data. Pass a ticker symbol, an attribute like price or volume, and optional date range arguments for historical quotes. Portfolio trackers and FX dashboards use it to avoid manual price copy-paste.
When to use it
Use GOOGLEFINANCE for simple stock quotes, mutual fund NAV, currency conversion, or historical price series on a personal or team dashboard.
When to skip it
Skip GOOGLEFINANCE for licensed real-time trading feeds, exotic instruments Google does not list, or compliance-grade audit trails. Paid data vendors may be required.
How it works
-
1
Enter a ticker such as GOOGLEFINANCE("AAPL", "price") for the latest price.
-
2
Swap the attribute argument for open, high, low, volume, pe, or marketcap as needed.
-
3
Add start and end dates plus a daily or weekly interval for historical tables.
-
4
Use GOOGLEFINANCE("CURRENCY:USDEUR") for exchange rates in finance models.
-
5
Leave room for historical queries to spill multiple rows of date and close columns.
-
6
Document that delays and symbol coverage follow Google Finance policies, not your broker.
Examples in Google Sheets
Live price column
=GOOGLEFINANCE(A2, "price") down a list of tickers in column A fills current prices in column B.
USD to EUR rate
=GOOGLEFINANCE("CURRENCY:USDEUR") supplies a spot rate for invoice conversion.
One-year history
=GOOGLEFINANCE("MSFT", "close", TODAY()-365, TODAY()) returns dated closing prices for a chart.
Better Sheets resources
Common mistakes
-
Using wrong exchange prefixes for international tickers, which returns #N/A.
-
Expecting after-hours prints to match your brokerage platform exactly.
-
Building margin calls on GOOGLEFINANCE without understanding update delays.
-
Mixing attribute names; "price" vs "close" behave differently on historical calls.
-
Referencing delisted symbols and not handling #N/A in downstream formulas.
Frequently asked questions
- Is GOOGLEFINANCE real-time?
- It is delayed market data suitable for dashboards, not a live trading feed.
- GOOGLEFINANCE for crypto?
- Some crypto pairs work with CURRENCY or specific symbols. Coverage changes over time.
- Why #N/A on a valid ticker?
- Wrong market prefix, typo, or Google dropped support for that symbol.
- Can GOOGLEFINANCE return dividends?
- Some attributes expose yield or company info. Check current attribute list in Google help.
- Historical data limits?
- Very long ranges may truncate or slow recalc. Test your date window.
- GOOGLEFINANCE vs IMPORTXML?
- GOOGLEFINANCE is built for market data. IMPORTXML scrapes arbitrary web pages.
- Multiple tickers at once?
- Use one formula per row or ARRAYFORMULA with a ticker list in a column.
Related Tutorials
Watch how GOOGLEFINANCE works
Google Sheets Interface Changes
The First Thing I Do When Starting a Google Sheet
Google Sheet Basics - The Absolute Basics
MAKE Your Google Sheets Add-on DISCOVERABLE
MAKE Your Google Sheets Add-on WORK
Related blog posts
Guides that explain GOOGLEFINANCE in more depth.
Build Better Financial Templates
By crafting and selling high-quality, customizable financial templates, one can cater to the needs of those who lack the time or expertise to create their own.
Read post →Getting Started in Google Sheets Spreadsheet Management
Users can also customize the appearance of their spreadsheets with different fonts, colors, and themes.
Read post →20 Google Sheet Tips for Bookkeepers
Google Sheets offers a cost-effective, flexible, and collaborative solution for managing financial data, performing calculations, generating reports, and staying organized.
Read post →Related terms
IMPORTRANGE
IMPORTRANGE loads values from a range in another Google spreadsheet into your current file. You pass the spreadsheet URL or key plus a range string with an optional sheet name. After you grant access once, the link stays live and updates when the source changes.
Read guide →SPARKLINE
SPARKLINE draws a miniature chart inside one cell from a row or column of numbers. Choose line, column, bar, or winloss types and pass an options object for color, axis, and markers. Dashboard tables use sparklines to show trend without full charts.
Read guide →QUERY
QUERY runs a SQL-like statement against a range of cells and returns a new table of results. You pass a data range, a query string with SELECT, WHERE, ORDER BY, and optional headers. It is the fastest way to filter, sort, group, and pivot sheet data without helper columns.
Read guide →IMPORTXML
IMPORTXML fetches a URL and returns data matching an XPath query. You can scrape page titles, meta tags, table cells, or RSS-style XML fields. It is more precise than IMPORTHTML when you need one value or a repeating node set from structured markup.
Read guide →Done reading about GOOGLEFINANCE?
Membership unlocks 600+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Need this once
Jump to a free tool or a single tutorial for this topic.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.