Market Quotes Dashboard

This Microsoft Excel® spreadsheet uses the CQG XL Toolkit to pull in market data. 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.

Requires an enablement turned on by your FCM 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.