This Microsoft Excel® dashboard displays volume and open interest data for soybeans, soybean meal, and soybean oil contracts for tracking the rolls. All of the active deliveries for each individual symbol are displayed in a single dashboard detailing market data. There are three tabs, one for each market.
The volume column highlights, in gold, the contract that has the largest twelve-day moving average. You can change the look-back period for the moving average. You can also enter a calendar date and pull a moving average value of the volume from that date.
The top five contracts by open interest are highlighted in gold. If the thirty-minute volume exceeds yesterday's thirty-minute volume for the same time, then the volume is highlighted in red.
Requires CQG Integrated Client or CQG QTrader, data enablements for all symbols displayed in the spreadsheet, and Excel 2010 or more recent.