Help & Support
Send Feedback
Sheets Market Data
Add stock market and financial data to your Google Spreadsheets.
35 users
Works with
Unleash your inner analyst!

Sheets Market Data is an add-on for Google Spreadsheets that allows you to pull in stock market and financial data into your spreadsheets. It comes loaded with features for free including stock quotes, fundamental data, and key statistics. Some of the data you can pull for free are:
・Current price
・Daily Open, Close, Volume, High and Low
・Forward and Trailing PE
・Market Cap
・Book Value
・Shares Outstanding
・and much more!

Pro features include the ability to pass ranges of data into our functions, auto-generating sheets with historical data for any stock on the market, time series data, income statement data, balance sheet data, cash flow statement data, earnings data, and options data! Below are just a few of the types of data you can access:
・Total Cash
・Net Receivables
・Total Current Assets
・Total Liabilities
・Long Term Investments
・Good Will
・Common Stock
・Research & Development
・Non Recurring
・Operating Income
・Total Cash from Operating Activities
・Change in Cash
・Earnings Estimate and Actual
・Options contract information
・and much more!

Sheets Market Data supports data from the following exchanges:
・ Chicago Board of Trade (CBOT)
・ Chicago Mercantile Exchange (CME) 
・ Dow Jones Indexes	
・ Nasdaq Stock Exchange	
・ ICE Futures US	
・ New York Commodities Exchange (COMEX)	
・ New York Mercantile Exchange (NYMEX)	
・ Options Price Reporting Authority (OPRA) 
・ OTC Bulletin Board Market	
・ OTC Markets Group	N/A
・ S & P Indices	
・ Buenos Aires Stock Exchange (BYMA)	
・ Vienna Stock Exchange	
・ Australian Stock Exchange (ASX)	
・ Euronext Brussels	
・ Sao Paolo Stock Exchange (BOVESPA)	
・ Toronto Stock Exchange (TSX)	
・ TSX Venture Exchange (TSXV)	
・ Santiago Stock Exchange	
・ Shanghai Stock Exchange	
・ Shenzhen Stock Exchange	
・ Prague Stock Exchange Index	
・ Nasdaq OMX Copenhagen 
・ Egyptian Exchange Index (EGID)	
・ Nasdaq OMX Tallinn 
・ Nasdaq OMX Helsinki 
・ Euronext	
・ Euronext Paris	
・ Berlin Stock Exchange	
・ Bremen Stock Exchange	
・ Dusseldorf Stock Exchange	
・ Frankfurt Stock Exchange	
・ Hamburg Stock Exchange	
・ Hanover Stock Exchange	
・ Munich Stock Exchange	
・ Stuttgart Stock Exchange	
・ Deutsche Boerse XETRA	
・ Currency Rates	
・ Athens Stock Exchange (ATHEX)	
・ Hong Kong Stock Exchange (HKEX)	
・ Nasdaq OMX Iceland 
・ Bombay Stock Exchange	
・ National Stock Exchange of India 
・ Indonesia Stock Exchange (IDX) 
・ Euronext Dublin	
・ Tel Aviv Stock Exchange	
・ EuroTLX	
・ Italian Stock Exchange	
・ Nikkei Indices 
・ Tokyo Stock Exchange	
・ Nasdaq OMX Riga	
・ Nasdaq OMX Vilnius 
・ Malaysian Stock Exchange	
・ Mexico Stock Exchange (BMV)	
・ Euronext Amsterdam	
・ New Zealand Stock Exchange (NZX)	
・ Oslo Stock Exchange	
・ Euronext Lisbon	
・ Qatar Stock Exchange	
・ Moscow Exchange (MOEX) 
・ Singapore Stock Exchange (SGX)	
・ Johannesburg Stock Exchange	
・ Korea Stock Exchange	
・ Madrid SE C.A.T.S.	
・ Saudi Stock Exchange (Tadawul)	
・ Nasdaq OMX Stockholm 
・ Swiss Exchange (SIX)	
・ Taiwan OTC Exchange	
・ Taiwan Stock Exchange (TWSE)	
・ Stock Exchange of Thailand (SET)	
・ Borsa İstanbul
・ FTSE Indices
・ London Stock Exchange
・ London Stock Exchange
・ Caracas Stock Exchange

To learn more about Sheets Market Data, how to get Pro features, and read the documentation, visit our website:
Jeff Bonano
March 1, 2019
The concept is good and from the examples I see, it is exactly what I needed. Sadly each time I try to use it, it keeps coming back withe "No data" as a result. Tickers are correct, so having a trouble shooting guide would be nice.
Submit reply
A User of Sheets Market Data
February 14, 2019
Thanks a lot for creating this add-on! Very helpful. But it often returns errors. So I have to cut and then paste the formula back so it "re-loads". Also it re-calculates all the values in the sheet when sorting rows. I mean it could be more optimized I guess, but having it like it is now, is already great!
Submit reply
A user of Sheets Market Data
February 14, 2019
Hi Vladimir, thanks for the feedback! Sorry you are running into errors. What kinds of errors were you running into? We're always looking for ways to improve the add-on so any further details can help us optimize it more for you. Thanks again for the feedback and rating!
1-2 of 2
Additional information
Clear search
Close search
Google apps
Main menu