Option Expirations
Returns an array of available option expiration dates for a given underlying symbol. Use optional filters to narrow down to weekly or monthly expirations.
Parameters
| Parameter | Required | Default | Description |
|---|---|---|---|
| Symbol | Yes | - | Underlying stock ticker (e.g., AAPL, TSLA) |
| Expire | No | all | Type filter: 'all', 'weekly', 'monthly' |
| Money | No | all | Moneyness: 'all', 'itm', 'otm', 'atm' |
| CallPutFlag | No | all | Option type: 'all', 'call', 'put' |
Expiration Types
| Filter | Description |
|---|---|
| all | All available expirations |
| weekly | Weekly expirations only (Fridays) |
| monthly | Standard monthly expirations (3rd Friday) |
Notes
- Returns an array that spills into multiple cells in Excel
- Dates are sorted in chronological order
- Weekly options are available for high-volume stocks
- LEAPS expirations may extend 2+ years out
Examples
=Expirations("AAPL")=Expirations("AAPL", "weekly")=Expirations("SPY", "monthly")=Expirations("TSLA", "all", "all", "call")=Expirations(A1)When to Use
- Building options chain analysis tools
- Finding available expiration dates for strategy planning
- Creating expiration date dropdown selectors
- Identifying weekly vs monthly expiration availability
- Planning options rolls and calendar spreads
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need strike prices | Strikes() |
| Need next expiration only | ExpirationNext() |
| Need option prices | Option_Last_Price() |
| Need full options chain | GetOptionsChain() |
| Need days to expiration | Calculate from result |
Common Issues & FAQ
Q: Why don't I see weekly expirations? A: Not all stocks have weekly options. Only high-volume stocks and ETFs have weekly expirations available.
Q: How do I find the next expiration only?
A: Use ExpirationNext("AAPL", 1) for the nearest expiration date.
Q: What format are the dates returned in? A: Dates are returned in YYYY-MM-DD format which Excel can parse as dates.
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?