Dynamically Ranked Markets Dashboard

This Microsoft Excel® spreadsheet is a modified version of the Dynamically Ranked SPDR® ETFs Dashboard. This version allows you to enter in the symbols you want using the symbols tab. The top twenty performing markets, on a percent change basis, are automatically displayed in the top two rows of market data information and the left-hand histogram bar chart. The bottom twenty performing markets, on a percent change basis, are automatically displayed in the bottom two rows of market data information and the right-hand histogram bar chart. In addition, if the current traded volume exceeds the ten-day moving average of the volume, then a volume red alert appears in the quote display.

Also, you can enter in a symbol and time frame for a current forty-bar candlestick chart.

Requires CQG Integrated Client or CQG QTrader, data enablement for the NYSE, and Excel 2013 or more recent.

Downloads

Disclaimer

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.