# Google Sheets Add-on | Market Data > Easily download real-time and historical stock, options, ETF, and mutual fund prices directly into Google Sheets with Market Data's free add-on. Source: https://www.marketdata.app/sheets/ --- # 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. [Install](https://workspace.google.com/marketplace/app/market_data/453586334945) [View Docs](/docs/sheets/) [Get Started With Market Data In Google Sheets: Get Real-Time Stock & Options Prices For Your Sheets](https://youtube.com/watch?v=D_NpqYGdtDg) 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 more](/docs/sheets/) Official 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. (image: A MacBook Pro showing a Google Sheet titled Stock Trades, dense with dated price rows, its worksheet tabs running along the bottom) ## 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. [Install](https://workspace.google.com/marketplace/app/market_data/453586334945) ## 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 choice](/topics/sheets/) [ Options Data ### Options Quotes & Chains ](/topics/sheets/options/)[ Intraday Stock Data ### 1 Minute Resolution Stock Data ](/topics/sheets/stocks/)[ ETF & Mutual Fund Data ### Vanguard, Fidelity, T. Rowe Price, and More ](/topics/sheets/funds/) ## How 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](/topics/sheets/) [ (image: A phone home screen in close-up: the green Google Sheets icon between the Google and Instagram icons.) 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. ](/sheets/options/how-to-get-options-prices/)[ (image: A phone home screen in close-up: the green Google Sheets icon between the Google and Instagram icons.) 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. ](/sheets/options/option-chain/)[ (image: Covered call payoff profile: the combined position breaks even at 95, rises to a profit of 5.00 at 100, and stays flat above it, while losses continue below 95.) How To Build A Covered Call Spreadsheet Build a covered call tracker in Google Sheets, formula by formula — and download our free example sheet to start tracking your positions today. ](/sheets/options/how-to-build-a-covered-call-spreadsheet/)[ (image: A close, shallow-focus photograph of green and red candlesticks on a dark trading screen.) Candles vs Quotes, What’s The Difference? Candles or quotes? STOCKDATA returns both, and picking the wrong one skews your spreadsheet. Here is what each one holds and when to use it. ](/sheets/stocks/candles-vs-quotes/)[ (image: The Greek letter theta, the options Greek for time decay, glowing white against a purple starfield.) How to Calculate Theta For An Option Learn how to calculate theta and understand how to add time decay to your spreadsheets. ](/sheets/options/how-to-calculate-theta/)[ (image: Option value before expiration: red extrinsic value shrinks as blue intrinsic value grows from at-the-money into the money.) 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. ](/sheets/options/intrinsic-extrinsic-value/)[ (image: The word EARNINGS across a wireframe globe, ringed by bar charts, pie charts, line graphs and spreadsheet panels on a green background.) 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. ](/sheets/stocks/earnings-calendar/)[ (image: The Greek alphabet in white capitals on dark grey, five rows of five, delta and theta among them.) How To Calculate Option Greeks In Your Spreadsheet The OPTIONDATA formula pulls delta, gamma, theta and vega straight into your spreadsheet, so position risk updates itself with the market. ](/sheets/options/calculate-option-greeks/)[ (image: Rows of five-decimal quotes such as 1.20506 and 1.18189 glowing green and blue on a dark screen.) 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. ](/sheets/stocks/how-to-get-real-time-stock-prices/)[ (image: A phone home screen in close-up: the green Google Sheets icon between the Google and Instagram icons.) 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. ](/sheets/options/historical-options-prices/)[ (image: Rows of green and magenta prices beside six-figure volumes on an angled market quote board.) 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. ](/sheets/stocks/bulk-download-stock-data/)[ (image: A white bell curve over a faded blue collage of web pages, above a red band lettered IMPLIED VOLATILITY.) How To Calculate Implied Volatility In Your Spreadsheet Using the OPTIONDATA formula, you can calculate implied volatility for any option. ](/sheets/options/implied-volatility/)