Skip to content
Alternative Finance

Spreadsheets

Google Finance alternative for Google Sheets: add-ons, APIs and formulas that go beyond GOOGLEFINANCE

The best Google Finance alternative for Google Sheets depends on what GOOGLEFINANCE is missing for you. For real-time prices and financial statements inside Sheets, add-ons such as Wisesheets (functions like WISE and WISEPRICE, 20 years of statements, 80,000+ tickers), YHFINANCE (quotes, history, statements, options from Yahoo data, plans from about $19 a month), MarketXLS (live prices, fundamentals, ETF and fund data, full option chains) and Market Data (free add-on with a subscription, 15 years of history). For a free, programmable feed, call an API such as Alpha Vantage, Financial Modeling Prep, SEC EDGAR or FRED from Apps Script. Keep GOOGLEFINANCE for what it does well: delayed prices and basic attributes with zero setup.

Google Finance alternative for Google Sheets: add-ons, APIs and formulas that go beyond GOOGLEFINANCE

What GOOGLEFINANCE does and does not do

The function returns current and historical prices and a set of attributes (price, volume, market cap, P/E, EPS, 52-week range, currency rates and mutual-fund data) with a formula such as `=GOOGLEFINANCE("NASDAQ:AAPL", "price")` or `=GOOGLEFINANCE("AAPL", "close", DATE(2026,1,1), TODAY(), "DAILY")`. Its limits, per Google's help page and 2026 reviews: prices are delayed up to about 20 minutes and never stream; there are no income statements, balance sheets or cash-flow statements; options, many international tickers and ETF holdings are missing; and data cannot be exported from the function to other apps. That is enough for a watchlist and a simple portfolio, not for a valuation model.

GOOGLEFINANCE versus the alternatives
CapabilityGOOGLEFINANCEWisesheetsYHFINANCEMarketXLSMarket DataFree API via Apps Script
Real-time pricesNo (delayed)YesYesYesYesDepends on API
Historical pricesYes30+ yearsYesYes15 yearsYes
Financial statementsNoUp to 20 yearsYesYesLimitedYes (FMP, EDGAR)
Options chainsNoLimitedYesFull chains with GreeksYesDepends
ETF and fund dataBasicYesYesYesYesDepends
CostFreePaid tiersFree trial; ~$19/mo+PaidFree with subscriptionFree tiers with limits
SetupNoneInstall add-onInstall add-onInstall add-onInstall add-onScript and API key

Option 1: add-ons from the Workspace Marketplace

  1. 1

    Install from Extensions → Add-ons → Get add-ons

    Search for Wisesheets, YHFINANCE, MarketXLS or Market Data; grant the permissions the add-on requests (they read and write your sheet).

  2. 2

    Sign in and enter your plan key

    Free trials are standard; paid plans unlock history depth and real-time data.

  3. 3

    Use the add-on's functions

    For example `=WISE("AAPL", "revenue", 2025)` for a statement item or `=WISEPRICE("AAPL", "price")` for a live quote in Wisesheets; YHFINANCE and MarketXLS have their own function names documented in the add-on.

  4. 4

    Mind recalculation

    Add-on functions refresh on a schedule or on demand; thousands of live cells can hit rate limits.

Which to choose: Wisesheets for fundamentals and long history; YHFINANCE if you want Yahoo-sourced data and options at a low entry price; MarketXLS for options chains and fund data; Market Data if you already subscribe to its API. All depend on a backend feed, as Financial Modeling Prep's review notes, so check the data source and its exchange coverage.

Option 2: free APIs through Apps Script

If you can paste a few lines of JavaScript, Google Apps Script turns any REST API into a custom function. Alpha Vantage and Financial Modeling Prep offer free keys with daily limits; SEC EDGAR's XBRL company-facts endpoint is free and keyless; FRED gives macro series with a free key. A minimal custom function:

Sheets' built-in IMPORTDATA, IMPORTJSON (via script) and IMPORTXML functions can also pull CSV or JSON endpoints directly without script for simple cases. The alternative finance data APIs page lists endpoints, keys and limits.

Option 3: keep GOOGLEFINANCE and add around it

For a personal portfolio the pragmatic setup is GOOGLEFINANCE for prices and currency rates (free, zero maintenance), one add-on or script for the statements or options you need, and manual entry for holdings and cost basis. Set the sheet to recalculate on change and every hour rather than every minute to avoid the function's known flakiness under load. Export to a personal-finance app if you want net-worth tracking across accounts; see Quicken alternatives.

Depth of financial-statement history available in Sheets (years)
  • GOOGLEFINANCE0
  • Market Data (prices)15
  • Wisesheets (statements)20
  • Wisesheets (prices)30

As reported in 2026 reviews; verify with each vendor.

Building a simple portfolio sheet, step by step

  1. 1

    Columns

    Ticker, exchange, quantity, cost basis, currency, price, value, gain, weight.

  2. 2

    Prices

    =GOOGLEFINANCE(B2&":"&A2, "price") for each row, or an add-on function for real-time.

  3. 3

    Currency

    =GOOGLEFINANCE("CURRENCY:"&E2&"USD") to convert; multiply value by it.

  4. 4

    Totals and weights

    SUM for value; each value ÷ total for weight; conditional formatting for drift.

  5. 5

    Fundamentals

    One add-on column for revenue growth or P/E per holding.

  6. 6

    History

    A second sheet with =GOOGLEFINANCE(ticker, "close", start, end, "WEEKLY") per holding for charts.

  7. 7

    Refresh control

    File → Settings → Calculation: recalculate on change and every hour.

Troubleshooting GOOGLEFINANCE

Common errors and fixes
SymptomCauseFix
#N/A for a tickerWrong exchange prefix or unsupported securityUse EXCHANGE:TICKER; check the symbol on Google Finance
Loading… never resolvesToo many calls or Google-side outageReduce cells, wait, or move prices to an add-on
Historical data returns a two-column arrayExpected behaviourUse INDEX to pull the value column
Prices differ from brokerDelay of up to ~20 minutesUse a real-time add-on if it matters
Mutual fund attributes blankLimited fund coverageUse a fund-capable add-on
Function disabled in a published sheetGOOGLEFINANCE does not work in some embedded viewsPublish values, not formulas

Excel users: the equivalent options

Excel's Stocks data type (Microsoft 365) pulls quotes and basic fields much like GOOGLEFINANCE; MarketXLS and Wisesheets also run in Excel; Tiller feeds bank data into Excel for personal finance; and Power Query can call the same free APIs described on the APIs page. The trade-offs are the same: free functions are delayed and shallow, add-ons cost money and depend on their feeds.

Automating refreshes and staying under rate limits

Custom functions that call an API run every time the sheet recalculates, which burns through free API quotas quickly. Three patterns fix it. Cache: wrap the fetch in CacheService so a ticker's price is stored for, say, 15 minutes and re-used. Batch: write one script that loops through all tickers in a range and writes values into cells, run by a time-driven trigger (Extensions → Apps Script → Triggers) every hour, rather than one formula per cell. Throttle: add Utilities.sleep between calls and catch errors so a failed call writes a blank rather than breaking the sheet. With these, a free Alpha Vantage or Financial Modeling Prep key covers a few hundred tickers a day comfortably.

Worked example: a dividend tracker in Sheets

  1. Columns: ticker, shares, price (GOOGLEFINANCE), annual dividend per share (add-on function or manual), yield, annual income.
  2. Yield = dividend ÷ price; income = dividend × shares; totals at the bottom.
  3. A second sheet pulls ex-dividend dates from the add-on and uses conditional formatting to flag the next 30 days.
  4. A monthly trigger appends the portfolio's total income projection to a history sheet for a chart.
  5. Currency: convert foreign dividends with GOOGLEFINANCE currency rates.

GOOGLEFINANCE alone cannot supply dividend amounts or dates reliably, which is exactly where an add-on earns its fee; everything else in the tracker is free.

Sharing and publishing sheets with live data

Shared sheets recalculate for every viewer, which multiplies API calls and can exhaust an add-on's quota or a free API key quickly. For a sheet many people view, run the refresh script on a schedule, write values (not formulas) into a published tab, and share that tab. Published-to-web sheets do not execute GOOGLEFINANCE or add-on functions reliably, so publish values. If the data is licensed (most add-ons and paid APIs restrict redistribution), check the terms before sharing a sheet outside your organisation.

Common formulas

Useful formulas
GoalFormula
Current price=GOOGLEFINANCE("NASDAQ:MSFT", "price")
Daily closes for a year=GOOGLEFINANCE("MSFT", "close", TODAY()-365, TODAY(), "DAILY")
Currency conversion=GOOGLEFINANCE("CURRENCY:USDEUR")
Market cap=GOOGLEFINANCE("MSFT", "marketcap")
Revenue (Wisesheets)=WISE("MSFT", "revenue", 2025)
Live price (Wisesheets)=WISEPRICE("MSFT", "price")
Option chain (MarketXLS)=QM_GetOptionChain("MSFT")

Function names for add-ons are as documented by the vendors in 2026 reviews; check each add-on's current documentation.

Questions people ask

What is the best Google Finance alternative for Google Sheets?

Wisesheets for fundamentals and long price history, YHFINANCE for Yahoo-sourced quotes and options at a low price, MarketXLS for option chains and fund data, Market Data if you have its subscription, or a free API via Apps Script if you can script.

Is there a free alternative to GOOGLEFINANCE?

Yes: free API tiers from Alpha Vantage and Financial Modeling Prep, the keyless SEC EDGAR API and FRED, called from Apps Script or IMPORT functions, within daily limits.

Why is GOOGLEFINANCE not updating?

The function is delayed and refreshes on Google's schedule; heavy sheets with many calls can stall. Reduce live cells, set recalculation to hourly, or move prices to an add-on.

Can I get options data in Google Sheets?

Not from GOOGLEFINANCE. MarketXLS and YHFINANCE return option chains; MarketXLS includes Greeks and open interest.

Sources and further reading

Related topics

Updated October 12, 2026 · By Alternative Finance editorial team

Next step

Compare real offers from funding partners

Tell us a little about the business and we route the request to partners that fund your industry, size and credit profile. You compare the total payback and decide. Nothing is binding until you sign.

  • Soft inquiry to request offers; a hard pull only if you proceed with a funder.
  • Decisions in as little as 24 hours for many products; funding often within days.
  • Use our calculators to check the true cost before you accept anything.

See what you may qualify for

Takes about a minute. Requesting offers does not affect your credit score. Free, no obligation.

We are not a lender or broker. Requests are forwarded to funding partners free of charge. How the site is paid.