Convert Option Symbol Format - MarketXLS Analytics

Live

Available on:

Excel Desktop

Category:MarketXLS Analytics

Description

Returns the converted option symbol from one platform to another.

Examples

=OptionSymbolConvert(OptionSymbol("MSFT",TODAY() + (6 - WEEKDAY(TODAY())),"Call",300),"qm","cs")

Historical Data Available: No

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 Convert Option Symbol Format and Other Financial Formulas

▶

How does MarketXLS work?

Similar Functions

Assets Non Current (Historical)
=hf_Assets_Non_Current("MSFT",2022) - Returns the value for the year 2022.
Black Scholes Option Value
=BlackScholesOptionValue("AAPL240315C00170000", "0.04", "0.3")
Convert Unix Time stampt to Excel date
=UnixTimeToExcelDate("1709913600")
Option Statistics
=QM_GetRecentOptionStats("MSFT")
Options Symbol
=OptionSymbol("MSFT",TODAY() + (6 - WEEKDAY(TODAY())),"Call",300) - Returns the call option symbol for MSFT contract with the expiry date of next friday and a strike price of 300
Optionsymbol
=qm_optionsymbol()