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.



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.