Home MarketXLS
Dashboard MarketXLS
Screener MarketXLS
Options Profit Calculator MarketXLS
Stock Ranks MarketXLS
Spreadsheet Builder MarketXLS
Documentation MarketXLS
Logout MarketXLS

Options Symbol - MarketXLS Analytics

Live
Available on:
Excel Desktop
Category:MarketXLS Analytics

Description

Returns an option symbol generated using the stock, expiry date, Call/Put flag, and strike price information provided.

Syntax

OptionSymbol(ByVal Symbol, ByVal ExpiryDate, ByVal CallPutFlag, ByVal StrikePrice)

Examples

=OptionSymbol("MSFT",TODAY() + (6 - WEEKDAY(TODAY())),"Call",300)
=OptionSymbol("MSFT",TODAY() + (6 - WEEKDAY(TODAY())),"Put",300)
=OptionSymbol("MSFT",TODAY() + (6 - WEEKDAY(TODAY())),"Put",350)
=OptionSymbol("MSFT","2022-09-17","Put",300)
=OptionSymbol("MSFT","2022-09-17","Call",300)
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 Options Symbol and Other Financial Formulas
▶
How does MarketXLS work?