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

CQG Integrated Client
Get a 2-week free trial

Learn More:

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