MarketXLS Tutorials

Search…

Getting Started

Functions: How to Use

Core concepts

Options Pricing

Historical Pricing

Create Charts using MarketXLS

Option Pricing with Quotemedia

This article describes various commonly used Options Pricing functions with Quotemedia’s options Data.

- 1.
**To get all option chain of a stock symbol**

1

=QM_List(“getOptionChain”,”Symbol”,”MSFT”)

Copied!

MarketXLS internally is able to understand both symbologies as shown below…

1

=QM_Last(“@MSFT 180629P00090000”)

2

=QM_Last(“MSFT180629P00090000”)

Copied!

Quotemedia’s option Symbols are structured as follows…

MSFT (and two spaces): Six character option root symbol using any prefix/suffix as defined by the OSI definition; left-justified, space-padded.

In the case where the option root symbol is three characters, it will be followed by three spaces.

MarketXLS also understands option symbols structured as follows…

Root Symbol + Expiration Year(yy) + Expiration Month(mm) + Expiration Day(dd) + Call/Put Indicator (C or P) + Strike Price Dollars + Strike Price Fraction of Dollars (which can include decimals)

1

=QM_ExpiryDate(“@MSFT 180629P00090500”)

2

=QM_ExpiryDate(“MSFT180629P00090000”)

Copied!

1

=QM_CallPut(“@MSFT 180629P00090500”)

Copied!

1

=QM_Strike(“@MSFT 180629P00090500”)

Copied!

1

=QM_ContractHigh(“@MSFT 180629P00090500”)

Copied!

1

=QM_ContractLow(“@MSFT 180629P00090500”)

Copied!

1

=QM_OpenInterest(“@MSFT 180629P00090500”)

Copied!

To get all the option contracts use the following function

1

=QM_List("getOptionChain","Symbol","FDX","money","In")

Copied!