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
Examples
=QM_GetOptionChainInTheMoney("AAPL")=QM_GetOptionChainInTheMoney("SPY")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
Common Issues & FAQ
Q: What determines if an option is ITM? A: For calls: strike < stock price. For puts: strike > stock price.
Q: Why use ITM options? A: ITM options have intrinsic value, lower time value decay, and higher delta (move more with stock).
Q: Can ITM options become OTM? A: 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?