OPT Time Value
Time value of the option.
Syntax
=mxls.OPT_TimeValue(optionSymbol, optionPrice, stockPrice)Parameters
optionSymbolstringRequired
optionPricenumberRequired
stockPricenumberRequired
Related Formulas
More MarketXLS Options formulas you can use in the same worksheet:
- OPT Underlying Symbol
- Opt Vanna Volga Delta
- Opt Vanna Volga Gamma
- Opt Vanna Volga Implied Vol
- Opt Vanna Volga Rho
- Opt Vanna Volga Theta
- Opt Vanna Volga Vanna
- Opt Vanna Volga Vega
See OPT_TimeValue used in a complete workbook: Bull Call Spread Calculator: Strike Width, Breakeven and Real Fill Prices 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?