# Options Data - API & Google Sheets Add-On > Navigate volatility with confidence. Get real-time and historical options quotes, chains, greeks and implied volatility via API or Google Sheets. Source: https://www.marketdata.app/data/options/ --- Options Data # Navigate Volatility with Confidence From subtle shifts to dramatic market swings, Market Data prepares you to tackle volatility like a pro. Dive deep into options with clarity and precision, backed by our robust data. [Try For Free](/signup/) [Pricing](/pricing/) Market Data Options APIs ## Simple To Use, Effortless Configuration, Advanced Filtering Download full option chains, use sophisticated filtering, get real-time or historical data with our robust options APIs, tailored for every requirement. Gain a competitive edge with our detailed and responsive data solutions. QuotesChainExpirationsLookup [GET /v1/options/quotes/{optionSymbol}](/docs/api/options/quotes) Quotes With More Than Just Bid & Ask Detailed real-time or historical (end of day) options quotes with a single easy-to-use endpoint. Keep up with the price, but see beyond it. - Full level 1 quote for all US-listed options - Greeks & implied volatility for all real-time quotes - Last trade price included - Open interest & volume data - Underlying price, intrinsic & extrinsic values included - First-traded date included for easy historical follow-up requests [Try for Free](/signup/) [View Docs](/docs/api/options/quotes) ``` { "s": "ok", "optionSymbol": ["AAPL271217C00250000"], "underlying": ["AAPL"], "expiration": [1829077200], "side": ["call"], "strike": [250], "firstTraded": [1741872600], "dte": [472], "updated": [1788283102], "bid": [97.95], "bidSize": [121], "mid": [98.45], "ask": [98.95], "askSize": [147], "last": [98.26], "openInterest": [3470], "volume": [11], "inTheMoney": [true], "intrinsicValue": [74.98], "extrinsicValue": [23.47], "underlyingPrice": [324.98], "iv": [0.3412], "delta": [0.8338], "gamma": [0.0019], "theta": [-0.0479], "vega": [0.9052] } ``` [GET /v1/options/chain/{underlyingSymbol}](/docs/api/options/chain) The World's Most Configurable Option Chain Endpoint Save weeks of coding time by integrating our option chain API into your application. Every filter you think you need to code has already been built by our team. Get the exact contracts you need with no code necessary. - Get real-time or historical (EOD) chains - Filter by expiration, year, month, weekly quarterly - Filter for standard or non-standard contracts - Include or exclude strikes by dollar value or delta - Set min or max values for bid/ask - Filter out contracts with excessive bid/ask spreads - Set thresholds for volume or open interest [Try for Free](/signup/) [View Docs](/docs/api/options/chain) ``` { "s": "ok", "optionSymbol": [ "AAPL271217C00320000", "AAPL271217C00325000", "AAPL271217P00320000", "AAPL271217P00325000" ], "underlying": ["AAPL", "AAPL", "AAPL", "AAPL"], "expiration": [1829077200, 1829077200, 1829077200, 1829077200], "side": ["call", "call", "put", "put"], "strike": [320, 325, 320, 325], "firstTraded": [1741872600, 1741872600, 1741872600, 1741872600], "dte": [472, 472, 472, 472], "updated": [1788283102, 1788283102, 1788283102, 1788283102], "bid": [52, 49.65, 30.8, 33.05], "bidSize": [234, 240, 173, 293], "mid": [52.975, 50.075, 31.1, 33.35], "ask": [53.95, 50.5, 31.4, 33.65], "askSize": [415, 247, 235, 168], "last": [53.64, 51.24, 30.96, 33.3], "openInterest": [891, 576, 490, 712], "volume": [15, 8, 1, 84], "inTheMoney": [true, false, false, true], "intrinsicValue": [4.98, 0, 0, 0.02], "extrinsicValue": [47.995, 50.075, 31.1, 33.33], "underlyingPrice": [324.98, 324.98, 324.98, 324.98], "iv": [0.303, 0.299, 0.2801, 0.2792], "delta": [0.6323, 0.6151, -0.363, -0.3814], "gamma": [0.0033, 0.0034, 0.0036, 0.0037], "theta": [-0.0581, -0.058, -0.0268, -0.0265], "vega": [1.3834, 1.4039, 1.3829, 1.4047] } ``` [GET /v1/options/expirations/{underlyingSymbol}](/docs/api/options/expirations) Find Out When Options Are Expiring Get a complete list of an underlying's available expiration dates quickly. Make historical requests using the same endpoint to find out when options expired in the past. - Returns all future expirations - Get a historical list of expiration dates from a specific previous trading day - Filter to include only expirations with a specific strike [Try for Free](/signup/) [View Docs](/docs/api/options/expirations) ``` { "s": "ok", "expirations": [ "2026-09-02", "2026-09-04", "2026-09-09", "2026-09-11", "2026-09-14", "2026-09-16", "2026-09-18", "2026-09-25", "2026-10-02", "2026-10-09", "2026-10-16", "2026-11-20", "2026-12-18", "2027-01-15", "2027-02-19", "2027-03-19", "2027-04-16", "2027-06-17", "2027-09-17", "2027-12-17", "2028-01-21", "2028-03-17", "2028-12-15" ], "updated": 1788283102 } ``` [GET /v1/options/lookup/{userInput}](/docs/api/options/lookup) Lookup Option Symbols Using Natural Language Lookup option symbols using text like "AAPL Jan $200 Call" instead of AAPL270115C00200000. Convert proprietary output from broker platforms to industry-standard option symbols. - Compatible with all major broker CSV formats - No specific ordering or format is required - Defaults to monthly expirations when dates are incomplete [Try for Free](/signup/) [View Docs](/docs/api/options/lookup) ``` { "s": "ok", "optionSymbol": "AAPL270115C00200000" } ``` The OPTIONDATA Formula ## The Do-It-All Formula for Options Data Designed for both real-time quotes and historical end of day quotes, OPTIONDATA is fully configurable and provides pricing data, greeks, implied volatility, and contract details for every option trading in the US. The OPTIONDATA formula is your Swiss Army knife for financial insights. OPTIONDATA with relative dates for automatic updating (image: OPTIONDATA with relative dates for automatic updating) OPTIONDATA with custom column output (image: OPTIONDATA with custom column output) ## Begin Working With Options Data Unlock the full potential of our options data with these quickstart tutorials for Google Sheets and the Market Data API. [View all](/topics/data/options/) [ (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: 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. ](/api/options/how-to-use-the-option-data-api/)[ (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/)[ (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: 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: The letters API at the centre of a cyan network diagram, its spokes radiating to eight ringed nodes on dark navy.) 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. ](/api/options/option-chain-api/)[ (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: 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: 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 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/) ## Frequently Asked Questions This section explains how our options data works—what's included, how it's sourced, and the types of access available. Browse the questions below to learn more about our options coverage, including supported exchanges, contract types, greeks, and historical depth. If you have specific needs not covered here, feel free to [reach out to our sales](/contact/?department=sales) team. ## Where does the real-time options data come from? Is it sourced directly from the exchanges? Yes—our real-time options data comes from OPRA, Market Data is an official OPRA vendor. Our OPRA feed includes data from all major U.S. options exchanges, including Cboe, NYSE, and Nasdaq. You're getting the same consolidated real-time prices that professionals use, sourced straight from the exchanges. ## What types of options data do you offer? We offer real-time quote data and end-of-day quote data for U.S. listed options. This includes bid, ask, last traded price, volume, and open interest for each contract. Our real-time quotes include all the core fields most traders need including greeks/IV, updated in real time. We don't currently provide trade-level data or candlestick-style OHLC data. ## Which exchanges are included in your options data? Our options data includes all U.S. options exchanges covered by OPRA. This means you'll receive quotes and trades from every major venue, including Cboe, NYSE, Nasdaq, MIAX, BOX, ISE, and others. The data is fully consolidated, so you don't need to worry about tracking individual exchange feeds. ## Do you provide greeks or implied volatility? Yes, we provide real-time greeks and implied volatility as part of our options quote data. This means you get live access to delta, gamma, theta, vega, and IV with every quote—no need to calculate them yourself. We don't currently offer greeks or IV for historical end-of-day data, but we're working on adding that soon. ## How far back does your historical options data go? Our historical options data includes end-of-day quotes going back to 2010. It covers U.S.-listed equity, ETF, and index options. This gives you over a decade of EOD quote data across the full OPRA universe—ideal for backtesting or research. We don't currently offer intraday history or futures options data. ## Is your historical options data adjusted for splits or dividends? No—our historical options data is provided exactly as it was reported on the day of trading. This means there are no adjustments for splits, dividends, or ticker changes. All symbols, prices, and contract details reflect the original values as traded, with no modifications. If you need adjusted data or want to account for symbol changes over time, you'll need to handle that processing on your end. ## Do you support weekly, quarterly, and LEAPS options? Yes, we support all standard contract types, including weekly, quarterly, and LEAPS options. You'll get full coverage of every listed U.S. options contract available through OPRA, regardless of expiration cycle. These contracts are included in both our real-time and historical datasets. ## Is your data filtered in any way? (E.g., do you remove zero volume strikes, consolidate chains, etc.) No—our options data is unfiltered. We don't remove contracts with zero volume, consolidate strike prices, or apply any cleanup or sampling. You get the full OPRA feed as-is, including every listed contract, whether it traded or not. ## Do you offer options chains or only individual contract lookups? Yes, we offer full options chains—and they're available through both our API and Google Sheets add-on. You can pull entire chains or narrow them down using advanced filters that work the same way in both tools. Whether you're working programmatically or in a spreadsheet, you'll be able to zero in on exactly the contracts you want. Our filtering options include strike ranges, moneyness (ITM, ATM, OTM), expiration dates, option type (call or put), volume, open interest, days to expiration, and more. You can filter based on relative percent distance from the underlying price, sort results by various fields, and even choose between midpoint, mark, or last price quotes. These tools are built to help you skip the noise and focus only on the options contracts that matter to your strategy—whether you're running a scan, backtesting, or building a live dashboard. ## Do you include expired or delisted options? What about contracts with adjusted terms or symbol changes? Yes, our historical options data includes every U.S. listed contract—expired, delisted, adjusted, and non-standard options are all included. You'll have access to contracts that are no longer trading but were active in the past, making the dataset fully suitable for research or backtesting. We include contracts modified by the OCC, such as those with adjusted deliverables due to mergers, stock splits, special dividends, or other corporate actions. This includes mini options, symbol changes, and non-standard terms—exactly as they were listed and traded at the time. Nothing is removed or filtered. Please note that while all contracts are included, we do not track or explain symbol changes or contract modifications. If a contract was adjusted or renamed, you'll need to know the correct symbol for the date you're querying. ## Get Data Anywhere How would you like to receive your data? Let's get started. (image: API network diagram showing interconnected nodes representing Market Data API infrastructure) ### Market Data API Our RESTful API allows on-demand access to our entire data catalog. With a single subscription plan, get access to both real-time and historic data on whatever instrument you need. [Try For Free](/signup/) [Try It](https://api.marketdata.app) [View Docs](/docs/api/) (image: Google Sheets interface showing market data integration with spreadsheet formulas) ### Google Sheets Add-on Use simple formulas based on GoogleFinance to download market data directly into your Google spreadsheets. Both real-time and historical data is available. [Try For Free](/signup/) [Install](https://workspace.google.com/marketplace/app/market_data/453586334945) [View Docs](/docs/sheets/)