Globex Natural Gas Options Volume Dashboard

This Microsoft Excel® dashboard scans the options on the natural gas (Globex) futures market for volume and ranks the volume traded for each expiry out sixteen months. The scan covers options traded ten strikes above and below the at-the-money option. Then the top five strikes by traded volume are presented on the main display. The options are sorted by volume, not strikes. The options volume data is heat-mapped with the highest volume levels in bright green.

In addition, the bottom section displays the last quote, net change, and total contract volume for three years and six months of natural gas futures contracts. The volume data is heat-mapped using light blue for the highest volume.

Download the Excel File ‌‍‍‍‍

Requires CQG Integrated Client or CQG QTrader, CQG's Excel RTD add-in, data enablements for all symbols used in the spreadsheet, and Excel 2010 or higher.

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