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