This Microsoft Excel® dashboard displays market data for grain spreads traded on the Globex platform using a matrix-style format. The outrights are along the top row and the start of each row. The best bid and best ask are also included. If the latest quote is a new bid, then the bid price is highlighted green. If the latest quote is a new ask, then the ask price is highlighted 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 with increasing levels of intensity of blue for 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.
Make sure to lower your Excel RealTimeData (RTD) throttle to 50 milliseconds or lower. Learn how to do that here.
Requires CQG Integrated Client or CQG QTrader and Excel 2013 or more recent. This product is copyrighted content owned by CQG.