Market Quotes Dashboard

This Microsoft Excel® spreadsheet pulls market data from CQG Integrated Client or CQG QTrader. There is a Symbols tab where you can enter the symbols, the parameter for decimal formatting, and the title for each group of quotes on the main display. On the main display, the markets are dynamically ranked by percent net change and the long descriptions are heat mapped to indicate the strongest (bright green) and the weakest (bright red) markets. In addition, if the last price is within two ticks of the high, the high price is highlighted green. If the last price is within two ticks of the low, then the low price is highlighted red.

There are three background versions available: black, night view of Europe, and stars.

Requires CQG Integrated Client or CQG QTrader, data enablements for all symbols used in the spreadsheet, and Excel 2010 or higher.


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