Options Data

The “Options” topic delves into the intricacies of options trading, providing readers with essential insights on accessing and leveraging options data through our products, such as APIs, SDKs, and spreadsheet add-ons. This area focuses on practical applications, offering tutorials, code snippets, and strategies to help traders and developers integrate options data into their trading platforms, analytical tools, or custom applications. It aims to simplify the complexities of options markets, ensuring users can effectively analyze, trade, and manage options with the support of our comprehensive data solutions.

Filter:

API Google Sheets Show All

No articles on this page match that filter.

The Greek alphabet in white capitals on dark grey, five rows of five, delta and theta among them.

Missing Options Contracts — Why You Can’t Find Them

Understanding the common reasons traders can't find certain missing options contracts. The importance of knowing how options contracts are created and traded.

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 DATA API in heavy black capitals, rim-lit in cyan against a deep navy starfield, with faint candlesticks arcing upward behind the words.

How To Use The Option Data API — With Examples!

The Option Data API allows you to easily get a real-time or historical option quote for stock, ETF, or index options.

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.

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.

How To Use The Option Chain API — With Examples!

The Option Chain API allows for ample sorting & filtering during each request, making it easy to get exactly the data you need.

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.

A black felt letter board spelling DOWNLOAD, a 3.5-inch floppy disk propped on its corner, on a wooden table.

How To Download Historical Options Prices in CSV Format

Market Data makes it easy to download historical options prices for the entire market or for a single symbol.

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.

Winning trades are born from superior data.

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