Google Workspace Marketplace
Global market data for 87,000+ stocks, ETFs, crypto and forex. Real-time stock prices, dividends, 30+ years of fundamentals. Replace Google Finance™. Build a portfolio tracker, stock screener & more.
By:
Listing updated:November 18, 2026
Works with:
62K+
Overview
SheetsFinance delivers global market data directly into Google Sheets™ through a comprehensive library of custom functions. Access 87,000+ stocks, ETFs, mutual funds, cryptocurrencies, forex pairs, bonds, commodities and indices across 60+ exchanges, with 30+ years of historical prices and financial statements, professional options data, screening and connected brokerage holdings. Built for individual investors, analysts and financial professionals who need reliable data to power their models, dashboards and portfolio tracking.

🚀 Try it free for 15 days with full access to all features. No payment details required.

📈 WHAT YOU CAN DO
➤ Investing dashboard and watchlist: prices, price change, news and analyst ratings
➤ Portfolio tracker: live prices and performance for your holdings in one sheet
➤ Stock screener: filter the full database by fundamental, valuation and market filters to find new ideas
➤ Company analysis and valuation: 30+ years of annual and quarterly financial statements, 100+ financial ratios, growth metrics and company KPIs for DCF and valuation models
➤ Dividend tracker: dividend history, yield, upcoming dividend dates and dividends received
➤ Brokerage connections: connect unlimited accounts across 30+ brokers and sync holdings, balances and transactions into one sheet
➤ Options analysis: full current options chains with Greeks and implied volatility, plus IV analytics and historical contracts
➤ Crypto tracker: crypto prices and history alongside your stocks
➤ Batch data: pull up to 5,000 symbols in a single function call

🧰 BUILT-IN TOOLS
✔ Function Generator: build any SheetsFinance function by picking options from menus, no formula knowledge needed
✔ Stock Screener: filter the full database from the sidebar, or use SF_SCREEN() to keep results live in your sheet
✔ Symbol Search: find tickers across all supported exchanges, with exchange filtering
✔ Template Library: search and filter free pre-built dashboards and models, and add them straight into your open spreadsheet

🔁 A GOOGLE FINANCE AND YAHOO FINANCE ALTERNATIVE
Use SheetsFinance as a Google Finance™ alternative or Yahoo Finance alternative in Google Sheets™. Get the stock prices, historical stock data and financial statements that the GOOGLEFINANCE function doesn’t provide, without IMPORTXML scraping or fragile workarounds.

📊 DATA COVERAGE
✔ Prices and time series: price quotes (real-time on select markets), pre/post-market quotes and trades, daily and intraday history (down to 1-minute) for 30+ years, adjusted and dividend-adjusted OHLCV, VWAP, split history, sparklines and price change from 1D to 10Y

✔ Fundamentals: income statement, balance sheet and cash flow (annual, quarterly and TTM), 100+ financial ratios, growth data, company KPIs, revenue by product and geography, earnings and analyst estimates, Altman Z-Score, Piotroski Score, ESG scores and dividend history

✔ Research: analyst ratings, consensus and price targets, insider transactions and statistics, institutional holders, ownership breakdowns, short interest, historical sector and industry PE, and real-time news feeds

✔ ETFs: fund details (NAV, AUM, expense ratio), holdings, and sector and country exposure

✔ Options: professional OPRA data. Options Standard gives the full current chain with every Greek and implied volatility; Options Pro adds IV analytics, volatility surfaces, earnings and 20+ years of history including expired contracts

✔ Brokerage: connect unlimited accounts across 30+ supported brokers, including Schwab, Fidelity, Interactive Brokers, Robinhood, E*Trade, Vanguard US, Questrade, Wealthsimple, DEGIRO, Trading212, CommSec and Coinbase. Sync your current holdings, balances, recent orders, options positions, transaction history and account value history into your sheet with SF_BROKERAGE(). Connections are read-only, so no trades can be placed.

✔ Technical analysis: SMA, EMA, WMA, DEMA, TEMA, RSI, ADX, Williams %R and standard deviation, from daily down to 1-minute intervals

✔ Calendars: earnings, dividends, splits, IPOs, financial statement releases and macroeconomic events

✔ Utilities: ISIN, CIK and CUSIP to ticker mapping, relative periods (LY, LQ), currency conversion and output scaling (K, M, B)

🌍 MARKETS
NYSE, NASDAQ, AMEX, TSX, LSE, Euronext, XETRA, SIX, OSE, ASX, HKEX, NSE, BSE, Shanghai, Shenzhen, Saudi Exchange, Nasdaq Copenhagen, plus crypto, forex, commodities and more.

🧮 EXAMPLES
Prices and time series
➤ Latest price: =SF("AAPL")
➤ Latest prices for 2,000 symbols: =SF(A1:A2000)
➤ FOREX rate: =SF("USDGBP")
➤ Full Quote: =SF("AAPL", "quote", "all")
➤ Pre/post-market quote: =SF("AAPL", "prePostMarketQuote")
➤ Pre/post-market trade: =SF("AAPL", "prePostMarketTrade")
➤ Closing price on a date: =SF("AAPL", "historical", "close", "2025-04-25")
➤ Price change across periods: =SF("AAPL", "change")
➤ Daily price history since 2015: =SF_TIMESERIES("AAPL", "2015-01-01", TODAY())
➤ Intraday 1-minute history: =SF_TIMESERIES("AAPL", "2026-03-02", "2026-03-04", "1min")

Fundamentals
➤ Full profile: =SF("AAPL", "profile")
➤ Profiles 2,000 symbols: =SF(A1:A2000, "profile")
➤ Annual income statements, 2015 to 2025: =SF("AAPL", "income", "all", "2015-2025")
➤ Quarterly income statements, 2015 to 2025: =SF("AAPL", "incomeQ", "all", "2015-2025")
➤ Last 8 quarterly income statements: =SF("AAPL", "incomeQ", "all", "LQ-7:LQ")
➤ Q4 balance sheet for 2024: =SF("AAPL", "balancesheetQ4", "all", "2024")
➤ Annual revenue in AUD, scaled to millions: =SF("AAPL", "income", "revenue", "2023", "scale=M&currency=AUD")
➤ Return on equity for 2024: =SF("AAPL", "ratios", "roe", "2024")
➤ EPS growth for 2024: =SF("AAPL", "growth", "epsgrowth", "2024")
➤ Earnings history and estimates: =SF("AAPL", "earnings")
➤ Revenue by product: =SF("AAPL", "revSegProduct")
➤ Revenue by geography: =SF("AAPL", "revSegGeo")
➤ Available company KPIs: =SF("AAPL", "kpiCatalog")
➤ Specific company KPIs: =SF("PLTR", "kpis", "commercialCustomerCount&commercialRevenue", "2020-2025")
➤ Dividend history: =SF_DIVIDEND("AAPL")
➤ Inst. and Insider Ownership: =SF("AAPL", "ownership") [historical ownership with SF_TIMESERIES()]
➤ Short Interest: =SF("AAPL", "shortInterest") [historical short interest with SF_TIMESERIES()]

Screening
➤ High-ROE mid caps on NASDAQ and NYSE: =SF_SCREEN("returnOnEquityTTM>0.2&marketCap<1000000000&marketCap>500000000&exchange=NASDAQ,NYSE", "symbol&exchange&marketCap&returnOnEquityTTM", "ob=returnOnEquityTTM&limit=100")
➤ Screen in AUD: =SF_SCREEN("marketCap>1000000000", "symbol&marketCap&currency", "screenCurrency=AUD&ob=marketCap")

Brokerage
➤ Current holdings: =SF_BROKERAGE("MyAccount", "holdings", "symbol&name&price&marketValue")
➤ Account balances: =SF_BROKERAGE("MyAccount", "balances")
➤ Dividends received this year: =SF_BROKERAGE("MyAccount", "transactions", "all", "2026-01-01", TODAY(), "DIVIDEND")

Research
➤ Analyst price targets: =SF("AAPL", "priceTargets")
➤ Analyst rating history: =SF("AAPL", "ratings")
➤ Insider transactions: =SF("AAPL", "insiders")
➤ Institutional holders by shares held: =SF("AAPL", "instHolders", "all", "", "ob=shares")
➤ Historical sector PE: =SF("NASDAQ", "sectorPE")
➤ Latest news: =SF_NEWS("AAPL")
➤ Latest crypto news: =SF_NEWS("BTCUSD", "crypto")

ETFs
➤ ETF details: =SF("SPY", "etfInfo")
➤ ETF holdings: =SF("SPY", "etfHoldings")
➤ ETF sector exposure: =SF("SPY", "etfSectors")

Options
➤ Options chain with Greeks (Options Standard): =SF_OPTIONS("AAPL", "calls&puts")
➤ Single contract: =SF_OPTIONS("AAPL270115C00200000")
➤ IV rank (Options Pro): =SF_OPTIONS_PRO("AAPL", "ivRank")

Technical analysis
➤ Daily SMA 20 over 100 days: =SF_TECHNICAL("AAPL", "20sma&all", "daily", TODAY()-100, TODAY())
➤ 5-minute RSI 14 over 15 days: =SF_TECHNICAL("AAPL", "14rsi&all", "5min", TODAY()-15, TODAY())

Calendars
➤ Dividend calendar for Frankfurt, next 90 days: =SF_CALENDAR(".DE", "dividends", TODAY(), TODAY()+90, "all")
➤ Earnings calendar for India (NSE), next 30 days: =SF_CALENDAR(".NS", "earnings", TODAY(), TODAY()+30, "all")

💲 PRICING
Plans start from $12/month. See https://www.sheetsfinance.com/pricing

🔗 LINKS
📔 Documentation: https://www.sheetsfinance.com/docs
📔 Templates: https://www.sheetsfinance.com/templates
🆘 Support: support@sheetsfinance.com
📄 Terms: https://www.sheetsfinance.com/policy/terms
🔒 Privacy: https://www.sheetsfinance.com/policy/privacy

🛠️ RELEASE NOTES
Full history in the Change Log: https://www.sheetsfinance.com/docs/change-log
10/11/2026: NEW Options Standard plan, with SF_OPTIONS returning full current option chains with Greeks; SF_OPTIONS_PRO for history and analytics. Pinned sidebar navbar and clearer daily usage.
5/11/2026: NEW template library search and filters, with templates added straight into the open spreadsheet. More reliable template inserts and charts.
2/11/2026: NEW prePostMarketTrade type for pre and post-market trades. Refresh button for connected brokerage accounts.
28/10/2026: NEW brokerage account summary and value history, with account nicknames and filters.
20/10/2026: NEW relative periods using LY and LQ for navigating data. Fixes to calYear for improved conversion of fiscal to calendar year data.
7/10/2026: NEW batching for financial scores. Usage history charts. NEW brokerage orders date filtering.
30/09/2026: NEW short interest function for current and historical. NEW ownership function for breakdown of institutional, insider and undisclosed company ownership. Sidebar layout and design fixes.
20/09/2026: NEW company KPI functions "kpis" and "kpiCatalog". NEW options currency=XXX and scale=K|M|B for converting and scaling function outputs.
09/09/2026: NEW "financials" calendar type for statement releases. Bug fixing for empty values.
02/09/2026: NEW screenCurrency=<code> added to SF_SCREEN() for currency-aware screening. SF usage tracking added to account page.
24/08/2026: NEW pre- and post-market historical data for supported intraday periods using the "extended" option in SF_TIMESERIES(). Function Generator updates and other optimisations.
17/08/2026: NEW stock split history in SF_TIMESERIES(), including split ratios, types, date ranges and Function Generator support.
23/07/2026: NEW brokerage connections: BMO InvestorLine, CIBC Investor's Edge, moomoo and TD Direct Investing. Improved historical EOD handling for market holidays and weekends.
23/06/2026: Persistent sign-in fixes.
20/05/2026: Updated setup and sign-in experience, brokerage sorting, options caching, eToro connections and futures data for Interactive Brokers.
28/04/2026: NEW onboarding and trial flow. Improved Google Sheets™ installation, email verification, password resets and brokerage connections.
09/04/2026: NEW RELEASE Professional options OPRA data package: chains, IV analytics, vol surfaces, 20+ years of history, including expired contracts. SF_OPTIONS_PRO() and SF_BROKERAGE() added to the Function Generator. Other optimisations.
03/04/2026: Real-time update speeds for Charles Schwab brokerage connections.
16/03/2026: Reduced latency on real-time exchange quotes, fixed symbol display for brokerage options transactions. Fixed technicals bug for ADX.
19/02/2026: Fix for calYear to index quarterlies by calendar year. Improved intraday time-series retrieval speeds. Fixed exchange display for brokerage options positions.
09/02/2026: NEW dailyAdj time-series for dividend-adjusted OHLCV.
01/02/2026: Fixed filter counter bug for screener, added decimal option to price change data, TTM ratios batch now 500 for Pro accounts.
18/01/2026: Excel add-in released.
11/01/2026: New brokerages added, bug fixing for brokerage connections.
14/11/2025: V4 RELEASE: new and improved financial statements, new IPO calendar, new sorting/filtering, lots of new data points added. See Change Log for full breakdown.
15/07/2025: New metrics added to companyInfo function. Batch processing improvements.
02/07/2025: 98 new metrics added to Stock Screener, new Stock Screener UI in-app. Bug fixing for long-period sparklines.
20/06/2025: Updated ratios function, new ratios, TTM ratios batching for 10-50 symbols, yield and frequency added to dividends.
29/05/2025: Bug fixing, exchange filter added to symbol search in-app, metric ordering for options, metric chaining for brokerage.
30/04/2025: NEW Brokerage Connections: connect your brokerage accounts to Google Sheets™.
22/04/2025: Fixed ADX bug for technicals, bug fixing for stock screener.
14/03/2025: NEW revenue segmentation by product or geography for US stocks using revSegProduct and revSegGeo, for both annual and quarterly statements.
12/02/2025: NEW batching of historical EOD data, metric chaining for historical function.
16/12/2024: Fixed RSI bug, new financial ratios added.
12/11/2024: Automatic handling of non-trading days for technicals, timezone bug fixes, options data optimisations.
08/10/2024: Template Library added to Google Sheets™. Automatic handling of bi-annual reporting companies.
20/09/2024: NEW SF_NEWS() for real-time news feeds, new daily historical shares outstanding and float, new score function for Altman Z-Score and Piotroski Score, added divYield to companyInfo, caching improvements.
27/08/2024: New template library, new blog, batch increase to 5,000, timezone bug fixes.
03/07/2024: Improvements to TTM data, new search terms for SF_CALENDAR, bug fixing.
27/06/2024: NEW SF_CALENDAR function for dividend, split, earnings and macroeconomic calendars. New Insider Trading and Insider Trading Statistics functions. New historical Sector and Industry PE ratios for all markets.
06/06/2024: New account management system and website, multiple connections, improved Symbol Search, speed improvements to caching and data retrieval.
12/04/2024: Added ISIN Mapper.
04/04/2024: New ESG and Owners Earnings functions, Analyst Ratings function updated, historical market cap output range increased to 5 years, new "Clear Cache" tool, major speed and memory optimisation improvements.
20/03/2024: Technical Analysis extended to 20+ years for daily and inter-day data. Bug fixing.
06/03/2024: New "mid" metric for options, updated ROIC calculation.
...

For older releases, see the full history in our Change Log: https://www.sheetsfinance.com/docs/change-log

⚠️ DISCLAIMER
Data is provided "as is" for informational purposes only and is not trading or investment advice. SheetsFinance is not responsible for any trading losses incurred from using the data.

Google Sheets™ and Google Finance™ are trademarks of Google LLC.
Additional information
PricingFree of charge trial
Developer
Support
Privacy policy
Terms of service
SheetsFinance | Stock Market Analysis will ask for the permissions shown below. Learn more
SheetsFinance | Stock Market Analysis will need access to your Google account
This will allow SheetsFinance | Stock Market Analysis to :
View and manage spreadsheets that this application has been installed in
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Robert Amico
August 20, 2026
Very easy to use. Pulls a lot of data quickly into Google Sheets. I used Gemini to assist with creating the functions I needed. I tested several other solutions and SheetsFinance was easiest and provided the best value for my purpose.
Is this review helpful?
Yes
No
Profile Picture
Erskine Tanner
March 20, 2026
SheetsFinance has proved to be a great solution for the Portfolio. We track about 300 stocks globally so that means a lot of different markets and need a lot of relevant data beyond price and PE. SheetsFinance provides all of this and the company offers super friendly, efficient and helpful support with using the product and integrating it into Google Sheets - even helping with formula and syntax suggestions. I was particularly grateful for all the help David offered in rationalizing the number of calls I was making and ensuring I got just the fields and data needed. An excellent solution. The different tier of plans make this very affordable. I also like the fact that SheetsFinance can work to add new stocks as I have more than a few obscure ones I need data for
Is this review helpful?
Yes
No
Profile Picture
samuel bharksuwan
June 28, 2026
Just started using it today and it was easy to use. I am novice with spreadsheets and formulas. This add on saves is going to save me so much time and keep accurate records of my holdings. No more manual entries to keep my sheets up to date. Highly recommend for beginners and anyone who wants to automate their spreadsheets.
Is this review helpful?
Yes
No
Profile Picture
Nick Martin
September 15, 2026
Good app, easy to integrate with good support does what it says on the box.
Is this review helpful?
Yes
No
Profile Picture
Marc Trudeau
February 27, 2026
SheetsFinance is my new way to analyse the stocks that interest me. It is easy to configure and carries most of the information needed. Two problems though: SheetsFinance does not give me access to many (penny) stocks that are on the Vancouver stock exchange (XTSX for Microsoft; or ***.V for Yahoo); this is rather annoying because, now, I must keep a separate Excel worksheet (and EPF) for these stocks. The second problem pertains to Google Sheet, I think: I often get messages that the time limit was attained and the execution stops; to solve this issue, I am thinking of going back to Excel. But, the most annoying issue is about the stocks not available, hoping that they will be in the near future.
Is this review helpful?
Yes
No
Profile Picture
Sri R
March 17, 2026
Have been using SheetsFinance to auto track and report on all my Options trading across different brokerages. This has simplified the process, eliminated all the manual editing errors, and brought data across different brokerages under the same format. Will continue to use SheetsFinance and will look forward to their updates. Giving 4 stars only because, for some of the brokerages the refresh is once in 24 hours. Will look forward to this being near real time and will get 5 stars from me!
Is this review helpful?
Yes
No
Profile Picture
Zac White
December 18, 2025
This is the best application I have ever found on sheets. I say that completely genuinely. I usually use things on the "it works well enough" basis. This not only works, but it works well. It has an insane amount of options, does everything so quickly, and there's even a function to refresh errors. I have never seen something so well-made on workspace.
Is this review helpful?
Yes
No
Profile Picture
Steve Thode
April 15, 2026
amazing. uniform. easy to use! still learning the capability but definitely a huge win
Is this review helpful?
Yes
No
Profile Picture
Brian Anderson
March 25, 2026
Seems to be the most comprenensive real-time data source and at a reasonable price. Offers more bang for the buck and hopefully no missing data like GoogleFinance().
Is this review helpful?
Yes
No
Profile Picture
Ivan Lee
July 29, 2026
Thanks David for enabling this wonderful add in to spreadsheets (both Googlesheet & Excel) for easy updating of financial data for customised usage.
Is this review helpful?
Yes
No
1-10 of 115
Search
Clear search
Close search
Google apps
Main menu