This Microsoft Excel® dashboard displays the current crude oil options market ranked by the time of the last trade. It has two columns for two different expiry months. There are two tabs where you enter in the delivery month and the start and end range of strike prices. If you see a trade for today with no traded contract volume, it is because the trade is part of a spread.
Make sure to lower your Excel RealTimeData (RTD) throttle to 50 milliseconds. Learn how to do that here.
Requirements: CQG Integrated Client, data enablements for all symbols displayed in this spreadsheet, and Excel 2010 or more recent.