Google Sheets Tutorials

Welcome to Market Data’s Quickstart Tutorials! Here, you’ll find comprehensive guides and tutorials to help you get started with our two powerful products: the Market Data API and the Google Sheets Add-On. Whether you’re a developer looking to integrate real-time and historical market data into your applications using our API or a trader who prefers the simplicity and flexibility of Google Sheets, we have the resources you need.

Filter:

API Google Sheets Show All

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.

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.

A pencil on a blue-tinted calendar page, crossed by a red band lettered MARKET HOLIDAYS.

How To Get Stock Market Holidays In Your Spreadsheet

Get past, present, and future stock market holidays for the United States directly into your spreadsheet with the MARKETSTATUS formula.

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.

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.

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.

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.

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.

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.

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.

Wooden blocks lettered S&P 500, each on a taller stack of coins than the last, against a black background.

How To Find The S&P 500 Ticker Using Google Finance (SPX)

Learn how to pull S&P 500 data into Google Sheets using the correct Google Finance ticker. Avoid common errors with simple, clear guidance.

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.

Winning trades are born from superior data.

Free 30 day demo for new accounts. No credit card required.