Option Expire Maximum
Returns the furthest available expiration date for options on a given underlying stock using QuoteMedia's data service.
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 |
| OnDate | Date | Yes | Reference date |
Notes
- Returns the LEAPS or furthest-dated expiration
- Different stocks have different maximum expirations
- Liquid stocks typically have longer-dated options
Syntax
=mxls.QM_GetOptionExpireMaximum(Symbol, OnDate)Examples
=mxls.QM_GetOptionExpireMaximum("AAPL", DATE(2024,3,15))=mxls.QM_GetOptionExpireMaximum("SPY", TODAY())=mxls.QM_GetOptionExpireMaximum(A1, B1)When to Use
- Finding LEAPS options
- Long-term options strategies
- Determining available expirations
- Planning long-dated positions
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need nearest expiration | QM_GetOptionExpireMinimum() |
| Need all expirations | QM_GetOptionChain() |
| Need next N expirations | ExpirationNext() |
Common Issues & FAQ
Why do some stocks have longer expirations?
Liquid, popular stocks (AAPL, SPY) typically have LEAPS extending 2+ years. Less liquid stocks may only have 6-12 months of expirations.
What are LEAPS?
Long-Term Equity Anticipation Securities are options with expirations typically 1-3 years out.
What date format should I use?
Use Excel's DATE() function: DATE(2024,3,15) for March 15, 2024.
Related Formulas
More MarketXLS Options formulas you can use in the same worksheet:
- Option Filter
- Option Strikes
- Option Symbol
- Options Change in OI Leaders
- Options Change in Volume Leaders
- Options Delta
- Options Gamma
- Options Implied Volatility
See QM_GetOptionExpireMaximum used in a complete workbook: Options Spreadsheet in Excel: Track, Value, and Stress-Test Trades with MarketXLS
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?