App Icon
Real-time and historical intraday (1-minute) price for global equity; 30+ years of stock fundamentals, analyst estimates, ETF holdings and much more.
Listing updated:January 24, 2023
Works with:
1,334
Overview
Documentation: https://finsheet.io/docs

Finsheet is the ultimate financial data provider for Google Sheets, 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 (1-minute) 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...

*** 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")

Stocks:
=FS_EquityMetrics( "AAPL" , "revenue" , "FY" , 3)
=FS_EquityFullFinancials( "AAPL" , "bs" , "FY" , 3)
=FS_EquityCandles( "AAPL" , "1" , "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")
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