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)Examples
=mxls.QM_GetOptionChainInTheMoney("AAPL")=mxls.QM_GetOptionChainInTheMoney("SPY")=mxls.QM_GetOptionChainInTheMoney(A1)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.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?