Option Expire Minimum
Returns the nearest 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 nearest available expiration
- Useful for front-month strategies
- May be same-day for highly liquid options
Syntax
=mxls.QM_GetOptionExpireMinimum(Symbol, OnDate)Examples
=mxls.QM_GetOptionExpireMinimum("AAPL", DATE(2024,3,15))=mxls.QM_GetOptionExpireMinimum("SPY", TODAY())=mxls.QM_GetOptionExpireMinimum(A1, B1)When to Use
- Finding front-month options
- Short-term strategies
- Weekly options trading
- Quick expiration identification
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need furthest expiration | QM_GetOptionExpireMaximum() |
| Need all expirations | QM_GetOptionChain() |
| Need next N expirations | ExpirationNext() |
Common Issues & FAQ
What if the date I provide has expired options?
The function returns the next available expiration on or after the reference date.
Can this return same-day expirations?
Yes, for liquid stocks like SPY that have daily expirations.
What date format should I use?
Use Excel's DATE() function: DATE(2024,3,15) for March 15, 2024.
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?