Option Chain At The Money
Returns only at-the-money (ATM) options from the option chain using QuoteMedia's data service.
What is At-the-Money (ATM)?
ATM options have a strike price equal or very close to the current stock price. These options have:
- Highest time value (extrinsic value)
- Delta near 0.50 (calls) or -0.50 (puts)
- Most sensitive to implied volatility
- Highest gamma (most price sensitivity)
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 strikes near current price
- ATM options have highest theta decay rate
- Most liquid options are often ATM
Examples
=QM_GetOptionChainAtTheMoney("AAPL")=QM_GetOptionChainAtTheMoney("SPY")Symbol from cell reference
When to Use
- Straddle and strangle strategies
- Delta-neutral trading
- Volatility trading
- Finding highest gamma options
When NOT to Use
Common Issues & FAQ
Q: What defines ATM exactly? A: ATM options have strikes closest to the current stock price. If stock is at $150.50, the $150 and $151 strikes may both be considered ATM.
Q: Why are ATM options important? A: ATM options have:
- Highest time value
- ~50 delta (move $.50 for every $1 stock move)
- Most sensitivity to volatility changes
Q: Why use ATM for straddles? A: ATM straddles are delta-neutral and profit from price movement in either direction.
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?