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:August 31, 2024
Works with:
4K+
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
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Nancy Hall
July 31, 2022
this app is great, I has been YHFINANCE app for a while and this one is just so much better. They have a tons more of data for the same price and the doc is actually helpful, unlike YHFINANCE's doc which is basically unreadable
Is this review helpful?
Yes
No
Profile Picture
Robert Z
November 14, 2022
Why does it say free of charge? Every day it gives me no data, but it says Rate limit reached in free plan.
Is this review helpful?
Yes
No
Profile Picture
Josh Smith
July 3, 2022
Great addon, it has all the data I need. The price is a little expensive compared to some other options but for me it is worth it because of the data quality and ease of use
Is this review helpful?
Yes
No
Profile Picture
Kishor Mayani
May 19, 2023
I installed it but it do not open
Is this review helpful?
Yes
No
1-4 of 4
Search
Clear search
Close search
Google apps
Main menu