Options Open Positions Excel Dashboard

This Microsoft Excel® dashboard looks for forty strikes above and below the ATM. Features also include a theoretical value column. If the current best bid is higher than the theoretical value, the best bid is highlighted green. If the best ask is below the theoretical value, the best ask is highlighted red.

Along the bottom, you can enter a days-to-expiration value. You can then see plus and minus one and two standard deviations of the estimated price at that set days to expiration. The dashboard includes five tabs for monitoring five different markets and the ability to use wild cards for expiries. In addition, you can sort various columns by clicking the blue sort toolbar button in the column title. All of the columns will sort by highest to lowest except the days to expiration column.

As before, this dashboard displays your current open options and outrights positions, open trade equity, inside market information, and the option Greeks. No fill prices or closed profits and losses are displayed. The time of last trade column has histogram bars next to it to indicate the oldest trades. If the last trade is outside of the best bid and ask range, then the last trade is highlighted in red. The totals for each of the Greeks are summarized at the bottom.

You can enter three options expiries and three underlying symbols. Use uppercase for the symbols, as you would in CQG. You can also enter the strike steps. Any positions with strikes more than forty strikes above or below the at-the-money-strike are not available. Choose the number of decimals, up to seven. Enter an N for those symbols that use fractions, such as fixed income. Make sure to lower your Excel RealTimeData (RTD) throttle to 0 milliseconds.

Make sure to lower your Excel RealTimeData (RTD) throttle to 0 milliseconds. Learn how to do that here.

Requires CQG Integrated Client or CQG QTrader, data enablements for all symbols displayed in this spreadsheet, and Excel 2010 or more recent.


Learn More:

Microsoft Excel is a registered trademark of Microsoft Corporation in the United States and/or other countries.