OPT Days To Expiration
Gets the days to expiration for an option.
Syntax
=mxls.OPT_DaysToExpiration(optionSymbol)Related Formulas
More MarketXLS Options formulas you can use in the same worksheet:
- Opt Earnings Report Time
- OPT Expiration Date
- Opt Heston Delta
- Opt Heston Gamma
- OPT HESTON PRICE
- Opt Heston Rho
- Opt Heston Theta
- Opt Heston Vanna
See OPT_DaysToExpiration used in a complete workbook: Long Call Option Calculator: Model Breakeven, Greeks, and Payoff in Excel (2026)
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?