App Icon
Real-time and historical price for global stock and crypto; 30+ years of stock fundamentals, technical analysis and more financial data.
Listing updated:September 21, 2022
Works with:
805
Overview
Documentation: https://finsheet.io/docs

Finsheet is the ultimate financial data provider for Google Sheets (Stocks, Cryptos, Bitcoin, etc...), offering institutional-grade data which is being used by hedge funds and investment banks all around the world.

We provide access to 30+ years of financial statements, 25+ years of analysts' estimates + EPS/Sales surprises and precomputed financial ratios for 47,000+ global companies. We also have 30 years of historical intraday data for US market updated in real-time, 15-minute delayed LSE data and End-of-day tick-level data for international markets. You can also access live and historical data from 10+ forex brokers and 15+ crypto brokers with up to 1-minute resolution. Additional features include: technical analysis, alternative data, options pricing, etc...

We have partnered and integrated with multiple world-class data providers so that their data APIs are readily available for our users in the API Console. With the ever growing number of integrated providers, we provide a breadth of insights and data that cannot be matched by any other website. Some of our partners and integrations are: Finnhub, Coinbase, Binance, Gemini, Kucoin, HarmonicPattern.com, Kraken, Bittrex, etc...

*** If you encounter an error when installing, it is likely that you have multiple Google accounts logged in. Solution: open an incognito window, log in just 1 account and install our add-on, then go back to your original window to use the add-on.

EXAMPLE FUNCTIONS:

To get Stock Price in Google Sheets, use these functions:
=FS_Latest( "AAPL")
=FS_Streaming( "MSFT")
The first returns the snapshot of the latest price of Apple Inc. The second returns the live price of Microsoft updated in real-time. 

Stocks:
=FS_EquityMetrics( "AAPL" , "revenue" , "FY" , 3)
=FS_EquityFullFinancials( "AAPL" , "bs" , "FY" , 3)
=FS_EquityCandles( "AAPL" , "D" , "1631022248" , "09/15/2021")

Crypto
=FS_CryptoProfile("BTC")
=FS_CryptoCandles("POLONIEX:BTC_ETH", "D", "1631022248", "09/15/2021")

Forex
=FS_ForexAllRates("USD")
=FS_ForexCandles("OANDA:AUD_SGD", "D", "1631022248", "09/15/2021")

ETFs
=FS_EtfProfile("VOO")
=FS_EtfCandles("VOO", "D", "1631022248", "09/15/2021")

Mutual Funds
=FS_MutualFundProfile("VTSAX")
=FS_MutualFundCandles("VTSAX", "D", "1631022248", "09/15/2021")

Technial Analysis
=FS_PatternRecognition("BINANCE:BTCUSDT", "60")
=FS_PatternRecognition("VOO", "D")
=FS_AggregateIndicators("TSCO.L", "D")
=FS_TechnicalIndicators("AAPL", "60", "sma", "08/01/2021", "08/15/2021", {"timeperiod", 3; "seriestype", "c"})

Alternative data
=FS_ESG("AAPL")
=FS_EarningsQuality("AAPL", "annual")

3rd party APIs
=FS_Api("Binance", "24hr Ticker Price Change Statistics")
Additional information
PricingFree of charge
Developer
Non-trader
Privacy policy
Terms of service
Stock Price in Google Sheets | Finsheet will ask for the permissions shown below. Learn more
Stock Price in Google Sheets | Finsheet will need access to your Google account
This will allow Stock Price in Google Sheets | Finsheet to :
See, edit, create, and delete all your Google Sheets spreadsheets
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
Loading
Search
Clear search
Close search
Google apps
Main menu