Option Strikes
Returns an array of available option strike prices for a given underlying symbol. Use optional filters to narrow down to specific expirations, moneyness, or option types.
Parameters
| Parameter | Required | Default | Description |
|---|---|---|---|
| Symbol | Yes | - | Underlying stock ticker (e.g., AAPL, TSLA) |
| Expire | No | all | Expiration filter: 'all', 'next', or specific date |
| Money | No | all | Moneyness: 'all', 'itm', 'otm', 'atm' |
| CallPutFlag | No | all | Option type: 'all', 'call', 'put' |
Moneyness Filters
| Filter | For Calls | For Puts |
|---|---|---|
| itm | Strike < Stock Price | Strike > Stock Price |
| otm | Strike > Stock Price | Strike < Stock Price |
| atm | Strike near Stock Price | Strike near Stock Price |
Notes
- Returns an array that spills into multiple cells in Excel
- Strikes are sorted in ascending order
- ATM filter returns strikes within a small range of current price
Examples
=Strikes("AAPL")=Strikes("AAPL", "next")=Strikes("TSLA", "all", "otm", "call")=Strikes("SPY", "next", "itm", "put")=Strikes("MSFT", "2024-03-15")=Strikes(A1, B1, C1, D1)When to Use
- Building options chain analysis tools
- Finding available strike prices for strategy planning
- Identifying strike price intervals for a symbol
- Creating options selection dropdowns
- Analyzing option liquidity across strikes
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need expiration dates | Expirations() |
| Need strike nearest to price | StrikeNext() |
| Need option prices | Option_Last_Price() |
| Need full options chain | GetOptionsChain() |
| Need option Greeks | Option_Delta(), Option_Gamma() |
Common Issues & FAQ
Q: Why am I only getting a few strikes? A: Check your filters - using 'next' expiration or specific moneyness filters will narrow results. Use 'all' for comprehensive list.
Q: How do I get strikes for a specific date? A: Pass the expiration date as the second parameter:
=Strikes("AAPL", "2024-03-15")
Q: Why doesn't ATM return exactly at-the-money? A: ATM filter returns strikes near the current price (within a small range), as exact ATM strikes may not exist for all symbols.
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?