Ranked Markets Dashboard

This Microsoft Excel® spreadsheet is a combination of market quotes and dynamic ranking. There is a Symbols tab where you can enter the symbols and the parameter for decimal formatting, or you can enter B for bonds and fractions. You can set the clock in the main display. It is set to Chicago time by default.

This dashboard offers a unique format where the current market data is displayed as a border around the chart information. The spreadsheet has equity index futures along the top row, FX futures along the bottom row, metals and energy futures in the left-hand column, and fixed income futures in the right-hand column.

Ranked Markets Dashboard

The markets are ranked based on percent net change and then the descriptions are heat-mapped based on performance. The markets with the lowest percent change are bright red. The markets with the highest percent net change are bright blue/green. With a quick glance, you can easily identify relative performance within the group by the colors. The histogram bar chart is also dynamically ranked.

The four quadrant charts display candlestick charts based on percent change from the previous day's settlement.

There are two versions available: one uses all black for the background and the second uses images for chart backgrounds.

It is recommended that this Excel spreadsheet be closed each night to avoid Excel memory issues.

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.




Trading and investment carry a high level of risk, and CQG, Inc. does not make any recommendations for buying or selling any financial instruments. We offer educational information on ways to use our sophisticated CQG trading tools, but it is up to our customers and other readers to make their own trading and investment decisions or to consult with a registered investment advisor. The opinions expressed here are solely those of the author and do not reflect the opinions of CQG, Inc. or its affiliates.