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 60,000 stocks, ETFs, FOREX, cryptocurrencies, bonds, mutual funds and indices with real-time stock prices and over 30 years of historical price and fundamental financial data! *** Our new Stock Screener now lets you screen our enormous database of global financial assets by a series of filters directly from your spreadsheet *** 📔Full Docs: www.sheetsfinance.com/docs [THEY EXPLAIN EVERYTHING!] 📔 Pre-built Templates: www.sheetsfinance.com/docs/#/templates 🆘Support: support@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 $8.20/month! [ONE TIER FOR FULL, UNLIMITED ACCESS] ➤ Batch function calls, access data on hundreds of companies at once! ➤ Built-in Stock Screener for searching and filtering ALL our available financial assets. ✔ 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, FOREX, Indices, Mutual Funds and more… 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 ✔ ETF Data ETF details - NAV, AUM, Expense ratio ETF holdings - by weight, absolute value and more.. ETF sector exposure breakdowns ✔ Options Generate entire chains or specific contracts Puts Calls Expiration dates lists ✔ 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") ➤ Real-time (to the second) FOREX rate: =SF("USDGBP") ➤ Annual income statements from 2012 to 2022: =SF("AAPL", "historicalfinancialsIncome", "all", "2012-2022") ➤ Q4 balance sheet from 2021: =SF("AAPL", "historicalfinancialsBalanceQ4", "all", "2021") ➤ Closing price on 25th April 2022: =SF("AAPL", "historical", "close", "2022-04-25") ➤ ROE from 2020: =SF("AAPL", "ratios", "roe", "2020") ➤ EPS Growth (year-on-year) in 2022: =SF("AAPL", "growth", "epsgrowth", "2022") ➤ Historical price data from 2012 to now: =SF_TIMESERIES("AAPL", "2012-01-01", TODAY()) ➤ Intraday data, 1-minute intervals: =SF_TIMESERIES("AAPL", "", "", "1min") ➤ Options data: =SF_OPTIONS("AAPL", "calls", "all", "2024-01-20") ➤ Options data (direct contract symbols): =SF_OPTIONS("AAPL240920C00160000") ➤ Historical dividend data: =SF_DIVIDEND("AAPL") ➤ Institutional Holders (ordered by number of shares) =SF("AAPL","instHolders","all", "", "ob=shares") ➤ ETF Holdings: =SF("SPY","etfHoldings") ➤ ETF Detailed Info: =SF("SPY", "etfInfo") ➤ ETF Sector Breakdowns: =SF("SPY", "etfSectors") ➤ Analyst Price Targets: =SF("AAPL","priceTargets") ➤ Price Change: =SF("AAPL","change") ➤ Technical Analysis – SMA 20 over the last 100 days: =SF_TECHNICAL("AAPL", "20sma&all", "daily", TODAY()-100, TODAY()) ➤ All historical analyst stock ratings: =SF("AAPL", "ratings") ➤ Analyst re-rates in most recent year: =SF("AAPL", "analysts") ______________________________________________________________ 📔ToS: https://www.sheetsfinance.com/terms-of-service 📔Privacy: https://www.sheetsfinance.com/privacy ______________________________________________________________ RELEASE NOTES 13/09/2023: All new quarterly ratio data, multi-year ratios, and ratio metric chaining. 4/08/2023: Ordering of chained metrics dictates order of output. 2/08/2023: New chaining of metrics for "realTime" and "companyInfo" functions, chaining of metrics for batch functions, fixed timezone bug. 16/07/2023: New Stock Screener sidebar and SF_SCREEN() function, bug fixing, now over 60,000 financial assets available, new order by feature for organising data. 12/07/2023: Added institutional holders, added new crypto, added refresh errors feature 27/06/2023: Increased batch data pulls to 300 simultaneous items. Added "max" as option to "change" data type. Caching optimisations. 9/06/2023: Added detailed ETF Info function and ETF Sectors function. Added Company Earnings Announcements. 24/05/2023: New in-built Function Generator and Code Guide. New data for companyInfo and for historical balance sheet. 10/05/2023: Added ETF Holdings, fixed analysts data, better date formatting 06/04/2023: Direct SEC links, speed increases 26/02/2023: Direct options contract searching, ttm cash flow statements, multi-year quarterly statement dump, new stocks 12/03/23: Updated function generator. 10/02/23: Speed improvements, increased rate limits and data delivery optimisation. 08/01/23: New stocks, ASX now available in batch requests 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, WiseSheets, 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.