Markets Ranked Dashboard

This Microsoft Excel® spreadsheet uses the CQG Toolkit to pull in market data. There is a Symbols tab where you can enter the symbols and the parameter for decimal formatting.

This dashboard offers a unique format where the current market data is displayed as borders 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. With a quick glance, you can easily identify relative performance within the group by the colors.

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, and the markets with the highest percent net change are bright blue/green. 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.

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. Learn how to do that here.

Requires an enablement turned on by your FCM and Excel 2013 or more recent. This product is copyrighted content owned by CQG.

Downloads

Microsoft Excel is a registered trademark of Microsoft Corporation in the United States and/or other countries.