Dynamically Ranked Correlations Market Dashboard

This Microsoft Excel® spreadsheet presents a 10-by-10 correlation matrix. In addition, a dynamically ranked view of the correlations from the 10-by-10 correlation matrix is displayed as histogram bars. The histogram bars are separated into the top 50 and bottom 50 ranked markets, which you can change by clicking either of the two toolbar buttons at the top of the chart.

There is a symbols tab where you enter your symbols and the price formatting, such as two decimal places, etc. The quote displays along the top and bottom use the same symbols as the correlation matrix, taken from the symbols tab.

The top of the correlation matrix displays the long descriptions of the symbols. Each column has a gradient background that alternates from left to right or top to bottom, which matches the gradient background of the long descriptions along the top of the matrix.

You can change the time frame and look-back period. Also, the correlation matrix is heat-mapped for the top five correlations (green) and bottom five correlations (yellow).

At the end of each row in the correlation matrix is a Chart toolbar button. Clicking this will update the scatter gram chart at the bottom to display the current correlations in that row versus the market listed in the first column of the row. The symbols and current correlations are detailed in the scatter gram chart.

Please note, you will need to enable macros for full spreadsheet functionality.

Make sure to lower your Excel RealTimeData (RTD) throttle to 0 milliseconds. Learn how to do that here.

Requires CQG Integrated Client or CQG QTrader, data enablements for all symbols displayed in this spreadsheet, and Excel 2013 or more recent.

Download the Excel File ‌‍‍‍‍

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