E-Mini S&P 500 Options Open Positions Dashboard

This Microsoft Excel® dashboard tracks open options positions for four weekly options, six end-of-month options, and six regular options. In addition, three underlying futures market positions are tracked. This version looks for any positions with strike prices that are twenty strikes above and below the ATM. There are two tabs: one tab is a display of total positions (please enter your account on this tab), and the second tab breaks down positions into expiries.

The first tab has 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. 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.

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 shown. 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 red. The totals for each of the Greeks are summarized at the bottom.

On the second tab, up to ten contracts above or below the ATM can be displayed using the twenty-strikes range. The ATM is highlighted with a blue box. There is a summary group of Greeks by first month, second month, third month, etc. If you wish to include Deltas for outright futures contracts, select Use Futures and then specify a long or short position and the contract quantity. The Deltas will then be added.

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.

5 April 2016: This new version allows open trade equity to be set to use yesterday's settlement versus today's theoretical value. You can also multiply the Delta and the Gamma by a value.


Learn More:

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