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
Examples
=QM_GetOptionExpireMinimum("AAPL", DATE(2024,3,15))=QM_GetOptionExpireMinimum("SPY", TODAY())=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
Q: What if the date I provide has expired options? A: The function returns the next available expiration on or after the reference date.
Q: Can this return same-day expirations? A: Yes, for liquid stocks like SPY that have daily expirations.
Q: What date format should I use? A: 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?