This Microsoft Excel® dashboard displays market data for crude oil spreads traded on the CME Globex platform. The dashboard is in a matrix-style format. The outrights are along the top row and the start of each row. The best bid and best ask are displayed. If the latest quote is a new bid, then the bid price is highlighted in green. If the latest quote is a new ask, then the ask price is highlighted in red.
Below the best bid row for each contract is today’s traded volume. Each volume row is heat mapped using black for the lowest traded volume and increasing levels of intensity of blue for indicating the higher levels of traded volume. The outright contract at the start of each row is not included in the heat mapping comparison.
The two forward curve charts use the last trade for the data points unless the last trade is outside of the best bid and best ask, then the mid-point of the best bid and best ask is substituted. The red line is a polynomial regression line.
Two dashboards are available. One displays the forward curve of the calendar spreads using the front contract for each calendar spread, i.e., May, June, May July, etc. The other displays the forward curve for each consecutive one-month calendar spread, i.e., May, June, June July, etc.
Requires CQG Integrated Client or CQG QTrader and Excel 2010 or more recent.