MarketXLS

Option Chain In The Money

Returns only in-the-money (ITM) options from the option chain using QuoteMedia's data service.

What is In-The-Money (ITM)?

Option Type ITM When
Call Strike < Current Stock Price
Put Strike > Current Stock Price

ITM options have intrinsic value and would be profitable to exercise immediately.

Supported Symbol Formats

Type Format Example
US Stocks SYMBOL AAPL, MSFT
ETFs SYMBOL SPY, QQQ

Parameters

Parameter Type Required Description
Symbol String Yes Underlying stock ticker

Notes

  • Filters chain to only ITM options
  • Useful for covered call writers and put sellers
  • ITM options have delta closer to +/-1

Syntax

=mxls.QM_GetOptionChainInTheMoney(Symbol)
Excel Online (Mac & Windows)

Parameters

symbolstringRequired

Underlying stock ticker symbol

Returns

array

In-the-money option chain data

Examples

=mxls.QM_GetOptionChainInTheMoney("AAPL")
ITM options for Apple
=mxls.QM_GetOptionChainInTheMoney("SPY")
ITM options for SPY
=mxls.QM_GetOptionChainInTheMoney(A1)
Symbol from cell reference

When to Use

  • Covered call writing strategies
  • Deep ITM option strategies
  • Analyzing options with intrinsic value
  • Finding options for exercise

When NOT to Use

Scenario Use Instead
Need full option chain QM_GetOptionChain()
Need OTM options QM_GetOptionChainOutOfTheMoney()
Need ATM options QM_GetOptionChainAtTheMoney()
Need all with Greeks QM_GetOptionQuotesAndGreeks()

Common Issues & FAQ

What determines if an option is ITM?

For calls: strike < stock price. For puts: strike > stock price.

Why use ITM options?

ITM options have intrinsic value, lower time value decay, and higher delta (move more with stock).

Can ITM options become OTM?

Yes, if the stock price moves unfavorably. An ITM call becomes OTM if stock drops below strike.

Related Formulas

More MarketXLS Options formulas you can use in the same worksheet:

See QM_GetOptionChainInTheMoney used in a complete workbook: Live Option Chain Data in Google Sheets: What GOOGLEFINANCE Covers and Where MarketXLS Picks Up

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Option Chain In The Money and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions