This Microsoft Excel® dashboard scans the crude oil (GLOBEX) futures market options for volume and ranks the traded volume for each expiry out to sixteen months. The scan covers options traded ten strikes above and below the at-the-money option. The top five strikes by traded volume are then presented on the main display. The options are sorted by volume, not strikes. The volume data is heat-mapped, with the highest volume levels highlighted bright green.
The tables at the bottom display the last quote, net change, and total contract volume for two years and five months of crude oil futures contracts. This volume data is heat-mapped and the highest volume is highlighted in light blue.
Requires CQG Integrated Client or CQG QTrader, the CQG RTD Toolkit, data enablements for all symbols used in the spreadsheet, and Excel 2010 or higher.