Google Sheets Add-on
Easily download real-time and historical stock, options, ETF, and mutual fund prices directly into Google Sheets with a simple formula. It's as intuitive as the GoogleFinance formula, ensuring a smooth transition. Market Data's free Sheets Add-on is the ideal tool for stock and options traders.
Free For All Market Data Users
The Easiest Way To Get Data
The Market Data Google Sheets Add-On is completely free and included as part of your Market Data subscription.
Learn moreOfficial Google Sheets Add-On
Connect Market Data with any of your existing Google Sheets.
Video Tutorials
YouTube tutorials to teach you step by step how to use our formulas.
Real-Time Prices
Use simple formulas to easily download real-time stock, options, and index prices into your sheet.
15+ Years of Historical Data
Backtest your strategies with 15 years of historical data.
Historical Intraday Stock Prices Down To The Minute
Break free from daily candlesticks with intraday stock prices in whatever time resolution you need, from one minute on up. Market Data makes it easy to backtest and model intraday trades with a simple formula to obtain historical intraday prices.
GoogleFinance vs. Market Data
GoogleFinance doesn't provide options data and only offers daily or weekly stock prices.
Market Data gives you access to current and historical options quotes going back 15+ years. You can also get intraday stock prices down to the minute—choose from 1, 5, 15-minute intervals or set a custom interval that fits your needs.
See why Market Data is the better choiceHow To Use The Sheets Add-on
Getting started with Google Sheets has never been easier. Make the most of the Add-on's features with these quickstart tutorials. View all
How to Calculate Theta For An Option
Learn how to calculate theta and understand how to add time decay to your spreadsheets.
How To Get An Earnings Calendar For Any Stock In Google Sheets
Add an earnings calendar to Google Sheets using Market Data's EARNINGS formula. Find what Wall Street Analysts are projecting for next quarter.
Candles vs Quotes, What’s The Difference?
What's the difference between candles vs quotes when it comes to stock data? Market Data offers both candlestick and quote data, so make sure you use the right
How To Get Real-Time Stock Prices in Google Sheets
The GOOGLEFINANCE formula gives 15-min delayed stock prices. Get real-time stock prices into Google Sheets using the STOCKDATA formula.
How To Build A Covered Call Spreadsheet
Learn how to build a covered call spreadsheet to track all your covered calls. Download our free covered call tracking spreadsheet example sheet for Google Shee
How To Calculate The Intrinsic / Extrinsic Value of an Option In Your Spreadsheet
Using the OPTIONDATA formula, you can automatically calculate the implied volatility of any option that is currently trading.
How To Get Historical Options Prices For Your Spreadsheet
Using the Market Data Add-on, it is possible to get historical options prices going back decades directly into your spreadsheet with a simple formula.
How To Calculate Implied Volatility In Your Spreadsheet
Using the OPTIONDATA formula, you can calculate implied volatility for any option.
How To Bulk Download Stock Data in Google Sheets
Learn how to perform bulk stock data downloads using Market Data's Google Sheets Add-on.
How To Use The Stock Market Holidays API
Use the stock market holidays API to get the open or closed status for any date in the past, present or future.
How To Calculate Option Greeks In Your Spreadsheet
The OPTIONDATA formula will calculate the option greeks to your spreadsheet automatically using the keyword "greeks" as a parameter. Risk management has never b
How To Get Options Prices in Google Sheets
Learn how to add real-time and historical options prices into your Google Sheets spreadsheets using a single formula.
How To Get An Option Chain In Google Sheets
Use the OPTIONCHAIN formula to get a complete real-time option chain in Google Sheets. Filter by date, days to expiration, strike, deltas, and more.
How To Get Intraday Stock Prices in Google Sheets
Learn how to get intraday stock prices in Google Sheets (with prices down to the minute) using a simple formula that works the same way as GoogleFinance.