Sheets Market Data
Go Pro

Unleash your inner analyst

with the Sheets Market Data Add-on for Google Sheets

Install the Add-on
screenshot

Get the data that matters.

Pull the latest stock data for any asset on multiple markets. Use it to build a portfolio tracker, analyze market trends, or for whatever you can think of. You're only limited by your own imagination.

The data available includes:

  • Current price
  • Daily Open, Close, Volume, High and Low
  • Forward and Trailing PE
  • Market Cap
  • Book Value
  • Shares Outstanding
  • and much more!
  • See a full list

Dig deeper to unlock new insights.

Go beyond the basics and understand more about a stock. Find your edge.

Pull data like:

  • 52 Week High, Low, and Change
  • Bid and Ask Prices
  • 52 Week High, Low, and Change
  • 50 and 200 Day Averages
  • Short Ratio
  • Quick Ratio
  • Total Debt
  • and much more!
  • See a full list

What's the difference between Sheets Market Data and GOOGLEFINANCE?

GOOGLEFINANCE is a free function that comes included in all Google Spreadsheets by default. It's Google's solution for pulling in stock market data into your spreadsheets. It's a fine solution if you just want simple stocks data for US Stocks. But if you want more data in more markets, then you'll want to use the Sheets Market Data add-on.

The Sheets Market Data add-on includes tons of additional data that you can pull into your spreadsheets. It has everything GOOGLEFINANCE offers plus a lot more. And that's just the free features. With a Pro membership, you get access to even more features, such as options data, income statement data, balance sheet statement data, cash flow statement data, earnings data, historical data, and the ability to pass a range of data rather than one at a time!

Go Pro and Get it All.

Subscribe to a pro plan and unlock everything.

only $5 per month

Pro Plan Features


Use Data Ranges

The Pro Plan makes it significantly easier to work with large amounts of data by allowing you to use ranges of data in our custom functions rather than requiring you to use one cell at a time! Learn More.

Historical Data

Get quote data as far back as 1970! Generate a separate sheet for whatever stock you want with all of its historical data, including daily prices, highs, lows, volume, and change.

historical-data

Balance Sheet Data

Get a stock's balance sheet data to better understand their books. Includes data up to 4 years ago.

Includes data for:

  • Cash
  • Net Receivables
  • Total Current Assets
  • Total Liabilities
  • Long Term Investments
  • Good Will
  • Common Stock
  • and much more!
  • See a full list

Income Statement Data

Get a stock's income statement data to better see what's generating revenue. Includes data up to 4 years ago.

Includes data for:

  • Total Revenue
  • Cost of Revenue
  • Gross Profit
  • Research & Development
  • Non Recurring
  • Operating Income
  • EBIT
  • Net Income
  • and much more!
  • See a full list

Cash Flow Statement Data

Get a stock's cash flow statement data to find out how much cash is on their books. Includes data up to 4 years ago.

Includes data for:

  • Net Income
  • Depreciation
  • Total Cash from Operating Activities
  • Capex
  • Change in Cash
  • Investments
  • and much more!
  • See a full list

Earnings Data

Get a stock's earnings data to find out how well it met its estimates. Includes data for up to 4 quarters.

Includes data for:

  • Earnings estimate
  • Actual earnings

Options Data

Not only does the Pro plan come with stock data, it also comes with options data!

Generate a separate sheet of option contracts for any stock you want, including the strike price, expiration date, in the money, current price, and more!

historical-data

Or get the details on a specific option contract.

Includes data for:

  • Strike Price
  • Current Price
  • Open Interest
  • Expiration Date
  • Change
  • High
  • Low
  • and much more!
  • See a full list

Interested in being a pro?

Subscribe below for as little as $5 per month.

Still have questions?
Email support@sheetsmarketdata.com

Ready to upgrade your financial spreadsheets?
Install the Add-on for Free