Expiry Date (On Demand)
Gets the expiration date for an option contract from QuoteMedia. Returns the date when the option expires.
Symbol Format
Options use OCC (Options Clearing Corporation) format:
- Format:
SYMBOL + YYMMDD + C/P + Strike(8 digits) - Example:
AAPL240315C00170000= AAPL Call, Mar 15 2024, Strike $170
Notes
- Only works with option symbols
- Date is extracted from the option symbol
- Useful for calculating days to expiration
Examples
=QM_ExpiryDate("AAPL240315C00170000")=QM_ExpiryDate("MSFT240315P00400000")=QM_ExpiryDate(A1)=QM_ExpiryDate(A1)-TODAY()When to Use
- Calculating days to expiration
- Organizing options by expiry
- Time decay analysis
- Expiration calendar management
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need option price | QM_Last() |
| Need call/put type | QM_CallPut() |
| Need option Greeks | QM_Stream_Theta(), etc. |
| Need next expiration | ExpirationNext() |
Common Issues & FAQ
Q: Why am I getting an error? A: This function only works with option symbols in OCC format, not stock symbols.
Q: How do I calculate days to expiration?
A: Use =QM_ExpiryDate(A1)-TODAY() to get the number of days remaining.
Q: Why am I getting #N/A? A: Check that the option symbol is in valid OCC format and .
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?