OPT Expiration Date

Gets the expiration date from an option symbol.

Syntax

=mxls.OPT_ExpirationDate(optionSymbol)

Excel Online (Mac & Windows)

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today

MarketXLS Excel Add-in Tutorial - How to Use OPT Expiration Date and Other Financial Formulas

▶

How does MarketXLS work?