FINANCE for Yahoo=FINANCE
Price, summary, statistics, financials, ESG and profile data for one ticker.
=FINANCE("BTC-USD")
Google Sheets add-on
Yahoo Finance data in your spreadsheet, one formula away
=FINANCE is the fastest way to pull Yahoo Finance data into Google Sheets. It works like =GOOGLEFINANCE and covers much more: over 200 live and historical data points for stocks, ETFs, funds, FOREX, crypto and more.
| A | B | C | |
|---|---|---|---|
| 1 | symbol | regularMarketPrice | regularMarketChangePercent |
| 2 | AAPL | 347.73 | -0.14 |
| 3 | MSFT | 524.51 | 0.66 |
| 4 | BTC-USD | 80,083.77 | -0.52 |
| 5 | EURUSD=X | 1.1627 | 0.12 |
| 6 | GC=F | 4,137.80 | -0.31 |
Illustrative values
Every market Yahoo Finance covers
Use the same ticker symbols you see on finance.yahoo.com.
StocksETFsMutual funds
FOREXCommoditiesCryptocurrenciesIndices
Six formulas, 200+ data points
Type a formula in any cell. The add-on calls the direct Yahoo Finance API and fills the results into your sheet.
=FINANCE_QUOTES
Live quotes for up to 50 tickers in a single call, one row per ticker.
=FINANCE_QUOTES("AAPL,BTC-USD,EURUSD=X")=FINANCE_HISTORY
Historical closing prices at any interval from 1 minute to 3 months.
=FINANCE_HISTORY("GLD","1d","3mo")=FINANCE_STATEMENTS
Income, balance sheet and cash flow statements, yearly or quarterly.
=FINANCE_STATEMENTS("MSFT","*.*","QUARTERLY")=FINANCE_OPTIONS
Option chains with calls and puts for any listed expiration date.
=FINANCE_OPTIONS("AMZN")=FINANCE_SEARCH
Look up ticker symbols by company name or keyword.
=FINANCE_SEARCH("Apple")Why spreadsheet users switch from GOOGLEFINANCE
Far more data
Fundamentals, analyst targets, ESG scores, short interest, dividends, pre- and post-market prices, and full financial statements.
Live and historical
Real-time quotes plus intraday or long-range history, back to the first trading day with "max".
Feels native
Plain spreadsheet formulas. Reference cells, combine with other functions, and share sheets with your team.
Batch quotes
Fetch up to 50 tickers in one cell with FINANCE_QUOTES to keep large portfolios fast.
Your data stays yours
Spreadsheet contents are never synced to our servers. Data goes straight from Yahoo Finance to your sheet.
Wildcards
Grab whole groups with "price.*", "financial.*" or "*.*" instead of listing every field.
Get started in a minute
Install the add-on
Open the Google Workspace Marketplace listing and click Install.
Open a spreadsheet
In Google Sheets, open Extensions → FINANCE for Yahoo → Formula Builder to build formulas without memorizing fields.
Type a formula
Enter =FINANCE("AAPL") in a cell. You have 7 days of full access to try everything.
Simple pricing
Try every feature free for 7 days, then subscribe for unlimited access.
Free trial
$0 / 7 days
Everything included, so you can build your sheet before you pay.
- All six functions
- All 200+ data points
- No credit card required
Unlimited
$19 / month
For investors, analysts and teams who rely on their sheets every day.
- Unlimited requests
- Every function and data point
- Email support
- Manage or cancel any time under My Account
Subscribe from Extensions → FINANCE for Yahoo → Upgrade to Premium inside Google Sheets. Payments are processed securely by Stripe.
Trusted by spreadsheet power users
Numbers from the Google Workspace Marketplace listing.
4.8★★★★★
Average rating from 771 reviewers
48K+
Installs on the Google Workspace Marketplace
“Extremely useful tool for pulling stock data, saves a bunch of time!”
Frequently asked questions
How is this different from GOOGLEFINANCE?
=FINANCE works the same way: you pass a ticker and the attributes you want. It reads from Yahoo Finance, so it supports more symbols (crypto pairs, futures, many international listings) and many more fields, including financial statements, option chains, analyst targets and ESG scores.
Which ticker symbols can I use?
Any symbol that works on finance.yahoo.com, for example AAPL, BTC-USD, EURUSD=X, GC=F or ^GSPC. If you don't know a symbol, use =FINANCE_SEARCH("company name").
Is the data real-time?
The add-on returns the data Yahoo Finance publishes. Many quotes are real-time; some exchanges are delayed by Yahoo Finance. Google Sheets also caches custom function results, so see refreshing and optimization.
What happens after the free trial?
Formulas show a message asking you to upgrade. Your sheets and formulas stay as they are, and they return data again as soon as you subscribe via Extensions → FINANCE for Yahoo → Upgrade to Premium.
How do I cancel?
Open Extensions → FINANCE for Yahoo → My Account in Google Sheets and cancel there, or email support@webdatahub.com.
Do you see my spreadsheet data?
No. The add-on runs inside your Google account and none of your spreadsheet contents are synced to our servers. Read the privacy policy for details.
Bring Yahoo Finance into Google Sheets today
Seven days free. No credit card required.
Install FINANCE for Yahoo