App Icon
Real-time and historical price data and detailed fundamentals for over 50,000 global stocks, ETF, FOREX and crypto. Build investing dashboards, portfolio trackers, stock market analysis and valuation.
Listing updated:January 25, 2023
Works with:
14,711
Overview
SheetsFinance connects Google Sheets to a huge network of global market data allowing you to build powerful investing dashboards on your own. We have over 50,000 stocks, ETFs, FOREX and cryptocurrencies with real time price quotes and over 30 years of historical price and fundamental financial data! 

📔Full Docs: www.sheetsfinance.com/docs [THEY EXPLAIN EVERYTHING!]
📔 Pre-built Templates: www.sheetsfinance.com/docs/#/templates
🆘Support: info@sheetsfinance.com 

➤ Use our function generator to access our data with no programming skills or fancy formulas required

➤ No personal or payment details needed to trial, get started immediately after install free for 15 days

➤ Unlimited data requests for only $5/month!

➤ Batch function calls, access data on hundreds of companies at once!

✔ 30 + years of all Historical Financials (Annual and Quarterly)
Income statement
Balance sheet
Cash flow 
Key financial ratios

✔ Real-time price quotes for stocks, ETFs, Crypto and FOREX
Price
Open
Previous Close
Day High
Day Low
Volume

✔ Key Company Information
P/E
EPS ttm 
Average volume
Market Cap
Year High
Year Low
50 Day Moving Average
200 Day Moving Average
ISIN
Industry
Sector
Full time employees
…and much more

✔ Daily data from any date for 30+ years
Open
High
Low
Close
Adjusted Close
Volume
Unadjusted Volume
Market Cap
Change
VWAP 

✔ 50+ financial ratios for 30+ years
Gross and Net Profit Margin
Debt Ratio
Per share statistics
Price to Book/Sales/Earnings
Dividend Payout Ratio
ROE/ROA
Current/Quick/Cash Ratio
...and much much more

✔ Price change data
1D, 5D, 1M, 3M, 6M, YTD, 1Y, 3Y, 5Y and 10Y

✔ 30+ years of historical dividend data

✔ Options chains
Puts
calls 
Expiration Dates

✔ Technical Analysis
SMA, EMA, WMA, DEMA, TEMA, Williams %R, RSI, ADX and Std. Dev
Generate from daily down to 1 min technical lines

✔ Analyst Stock Data
10 years of analyst rating data
3 years of analyst consensus data (rating totals)
Buy, Sell, Hold, Strong Buy, Strong Sell
2 years of price targets data
Filterable by date, type and analyst

✔ 100+ real time Foreign Exchange (FOREX) ratios
USD/GBP
USD/EURO
USD/AUD
USD/HKD
GBP/EUR
GBP/USD
...and much more

✔ Historical Price Data (time series) generation
Historical daily 30+ years!
Intraday 1min
Intraday 5min
Intraday 30min
Intraday 1hr

✔ Simple Sparklines
lastXdays price performance
lasXdays volume

✔ CIK and CUSIP Number Mapper
Simply map from CIK and CUSIP numbers to stock ticker symbols.

✔ Huge, growing network of financial data
CRYPTO
FOREX
NASDAQ
LSE
NYSE
EURONEXT
HKG
NSE
MCX
XETRA
OSE
SIX
AMEX
TSX
ASX
FSX
Saudi Stock Exchange
Shanghai Stock Exchange
Shenzhen Stock Exchange
Nasdaq Copenhagen
… and much more

______________________________________________________________

EXAMPLES 

➤ Real time (to the second) price:

=SF("AAPL")
or
=SF("AAPL", "realTime", "price")


➤ Real time (to the second) FOREX rate:

=SF("USDGBP")
or
=SF("USDGBP", "realTime", "price")


➤ Reported revenue from 2010:

=SF("AAPL", "historicalfinancialsIncome", "revenue", "2010")


➤ Closing price on 25th April 2014:

=SF("AAPL", "historical", "close", "2014-04-25")


➤ ROE from 1999:

=SF("AAPL", "ratios", "roe", "1999")


➤ EPS Growth (year-on-year) in 2020:

=SF("AAPL", "growth", "epsgrowth", "2020")


➤ All historical analyst stock ratings:

=SF("AAPL", "ratings")


➤ Analyst re-rates in most recent year:

=SF("AAPL", "analysts")


➤ Historical price data from 2012 to now: 

=SF_TIMESERIES("AAPL", "2010-01-01", "2021-06-01")


➤ Intraday data, 1 minute intervals:

=SF_TIMESERIES("AAPL", "null","null","1min")


➤ Options data:

=SF_OPTIONS("AAPL", "calls", "all", "2023-01-20")


➤ Historical dividend data:

=SF_DIVIDEND("AAPL", "2015-10-12", "2022-03-10", "all")

______________________________________________________________

📔ToS: https://www.sheetsfinance.com/terms-of-service 
📔Privacy: https://www.sheetsfinance.com/privacy 

______________________________________________________________

RELEASE NOTES
29/11/2022: Added CIK/CUSIP mapper, added technical analysis function, added price change function, added historical market cap. Bug fixing. Hundreds of new stocks. Optimisation of user authentication system.
01/08/2022: Added "priceTargets" data type for analyst price target information. Enabled batch functionality for "companyInfo" data type. Large addition of stocks, privacy improvements and bug fixing.
16/06/2022: Added "estimates" data type for analyst earnings forecasts, bug fix and optimisation for refresh all and refresh real-time.
9/06/2022: Bug fix for ttm data, addition of new stocks and crypto (over 50k now available!), improvements to function generator.
17/03/2022: Options chains, historical dividend data, company peers, improved formatting options for data, addition of new stocks, inclusion of adjusted close and unadjusted volume to time-series.
03/02/2022: Major server upgrades, improved loading times, optimised Google request usage.
28/01/2022: New crypto and stocks, ttm available for all historical financials, isin numbers, bug fixing.
9/11/21: New alt coins added, new historical TTM functionality, performance improvements and bug fixing.
23/09/21: Added TTM data for all companies, bug fix for ASX sparklines, bug fix for crypto info.
13/09/21: Range of years for annual reports to get multi-year output, ASX in code guide, SGX added to real-time.
30/08/21: 30+ years of quarterly reports added
28/08/21: 1000+ new cryptocurrencies added! Both real-time and historical data.
23/08/21: ASX stocks added, both real-time and historical data
14/08/21: New time series metric selection and formatting options
04/08/21: Added historical price datatype (daily stock and crypto data from any date in last 30+ years), added single cell output for ratings totals
05/07/21: Added analyst stock ratings detailed data (per broker)
04/07/21:  Added analyst stock ratings(consensus data) 
01/07/21: Added all market indices (INDEX) to searchable information
16/06/21: Additional company info data, new company growth data, refresh real-time button to force reload real time information
13/06/21: Volume sparklines
12/06/21: Default return for SF([code]), Code Guide click enter to active cell, improved error handling
10/06/21: Core function name change SF(), security improvements 
09/06/21: Added FOREX, foreign exchange now available in real time
06/06/21: "all" option for Historical Financials, time series formatting

______________________________________________________________

TOP RATED APP

SheetsFinance is one of the best rated apps on the G Suite marketplace and one of the most popular add-ons, among others, such as Google Finance, GoogleFinance, Market View, Investar.com, MarketView, Crypto, Morningstar, Refinitiv, S&P,  CryptoWallet, XERO, Alpha Vantage, Yahoo, YahooFinance, Currency Converter, SketchUp for Schools, Apipheny.io, LucidChart Diagrams, BetterCloud, Pear Deck, Lucidpress, BrainPOP, Form Ranger, Awesome Table, AODocs, EasyBib, GAT+, formLimiter, Smartsheet, Doctopus, Hapara Teacher, diagrams.net, SMART Learning Suite, Nearpod, Kami, Mavenlink, Flubaroo, NoodleTools, MindMeister, Form Publisher, Finsheet, MathType, Backupify, Choice Eliminator, EasyBib, Bark, Digication, Cisco Webex, Form Mule, MindMup, SysCloud Security, Expensify, One Up, Xero, Zoho, Cryptosheets, Cryptofinance, Screencastify, Spanning Backup, Doc Appender, DocHub, Pixton for Schools,  Wrike, Virtu / Virtru Data Protection, Super Quiz, PowerSchool, JoeZoo Express, gPanel, LumApps, Asana, GQueues, chromebookInventory, Timify.me, DocuSign eSignature, Easy Accents, Kaizena, Kabanchi, Grackle Docs, Power Tools, PlanbookEdu, VoiceThread, Sketchboard, Mindomo, Mojo Helpdesk, Slido, Stupeflix, Certify'em, StackEdit, Colaboratory, GoFileDrop, Drag, PerformFlow, Avery Easy Merge, Avery Label Merge, Foxy Labels, Taskboard, Google Tasks Desktop, OK Goldy, Google Apps Training, Slides Translator, Turnitin Draft Coach, ProjectWork, Math Equations, CoRubrics, Mail Merge, Document Studio, Control Accepting Responses, Mover, s, Publigo, Folgo, Hew Viewer with Drive, Koalendar, Zipbooks, Smallpdf, Magic Rainbow Unicorns, Sedja, Apptivo, Adveronix, Evernote, WhatsApp, Poshmark, Quilgo, PDFfiller, Airtable, OnlyOffice, ScheduleOnce, BeFunky, Photopea and more...

______________________________________________________________

For investors all around the world, investments and real-time financial data translates to: Investitionen und Finanzdaten in Echtzeit | Investeringen en realtime financiële gegevens | Investissements et données financières en temps réel | Inversiones y datos financieros en tiempo real | Investimentos e dados financeiros em tempo real | Investimenti e dati finanziari in tempo reale | Επενδύσεις και οικονομικά δεδομένα σε πραγματικό χρόνο | Investice a finanční údaje v reálném čase | Inwestycje i dane finansowe w czasie rzeczywistym | Инвестиции и финансовые данные в реальном времени | Yatırımlar ve gerçek zamanlı finansal veriler | الاستثمارات والبيانات المالية في الوقت الحقيقي | 投资和实时财务数据 | 투자 및 실시간 재무 데이터 | 投資とリアルタイムの財務データ | การลงทุนและข้อมูลทางการเงินแบบเรียลไทม์ | निवेश और वास्तविक समय के वित्तीय डेटा | real time quotes, currency, alpha, beta, dividends, crypto, portfolio, stocks, fiat currencies, streaming charts, live stock market data, dividends data, investment tracking, investing, trade, trading, tracker, finance, market, data, analytics, stockbroker, adviser, ticker symbol, tickers, stock, etf, crypto, cryptos, cryptocurrency, altcoin, altcoins, bitcoin, btc
______________________________________________________________

DISCLAIMER

SheetsFinance (This add-on) and its authors are not responsible for any trading loss incurred by following the data returned. Information is provided 'as is' and solely for informational purposes, not for trading purposes or advice.
Additional information
PricingFree of charge trial
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
Marcello Sequeira
January 8, 2023
Ease of use, rich features & well documented. Helps focus time and energy on stock analysis rather than copy-pasting, calling APIs etc. Well worth the subscription given the time saving opportunity.
Is this review helpful?
Yes
No
Profile Picture
Ryan Howell
January 5, 2023
I spent my free trial building a quick value calculator (I like Phil Town's methods he outlines in his books). I'm by no means an Excel/Google Sheets guru but it was pretty easy to get it all set up, and it saves me a ton of time digging through financial statements and websites to find the data I need. The documentation is great, the developer is responsive, personable, and open to suggestions (for example, I would like more tools for REIT analysis, which I'm told is already on the radar). The templates are pretty useful too. If you are looking for something customizable, or a cheap plug and play template, you really can't beat it for the price!
Is this review helpful?
Yes
No
Profile Picture
Mark Emery
January 7, 2023
SheetsFinance is exactly what I have been looking for in terms of getting Realtime Stock data into google sheets. I highly recommend the SheetsFinance add-on for google sheets. The documentation integrated with the add-on provides very good reference to questions that I had when getting all the attributes into my spreadsheet.
Is this review helpful?
Yes
No
Profile Picture
Value Investment Score
July 28, 2022
I found SheetsFinance a very useful and powerful tool to perform financial analysis, esp for a person with no tech background like me. I'm familiar with Google spreadsheets and SheetsFinance allow me to collect real time data, the most updated and historical fundamental data very easily~!!! just 1 function in 1 cell! It helps to make the financial analysis work a lot more easier convenient. Besides, it is much better than GoogleFinance function. I really love SheetsFinance and strongly recommend it to all users who wants to do analysis on Google sheets. It's great to put everything in one place and be able to generate the latest data automatically.
Is this review helpful?
Yes
No
Profile Picture
sal sh
December 3, 2022
No futures data support like emini sp500 etc the developer reached out to me about this feature and promised to add it in future. Good Luck
Is this review helpful?
Yes
No
Profile Picture
P B
June 27, 2022
Been using it for a week now and it does a great job of generating nearly all the fundamental data needed to build a proper model for nearly any company (IS, BS, CF statements normalized across many years). Handy ratios including the definitions used by the tool (as definitions can vary provider to provider) are a nice touch. Cool base templates provided to get you started, and the interface to build your own formulas is very intuitive. It may not be free but the price is so low compared to all the time it will save you!
Is this review helpful?
Yes
No
Profile Picture
James
August 31, 2022
This is a pretty damn good extension only problem it is a paid service and you can get the information yourself using the =importxml( function. Highly recommend for anyone new/inexperienced with google sheets
Is this review helpful?
Yes
No
Profile Picture
Jasvinder Bhatia
December 27, 2022
Excellent work. Looking for it as my Go-To source.
Is this review helpful?
Yes
No
Profile Picture
Faisal Albawardy
January 18, 2023
Cool tool, ETF's are a bit finicky though
Is this review helpful?
Yes
No
Profile Picture
G
June 28, 2022
VERY USEFUL! SheetsFinance data combined with some handy Google Sheets knowledge is the most flexible and best valuable for money finance tool I have found so far.
Is this review helpful?
Yes
No
1-10 of 58
Search
Clear search
Close search
Google apps
Main menu