Workspaces

Thom Hartle
Apr 23, 2015
Updated: Jul 23, 2019

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... more

Thom Hartle
Jan 05, 2015
Updated: Sep 14, 2018

This Microsoft Excel® spreadsheet uses a quadrant format to display correlations. For each quadrant, you can enter five symbols for the horizontal axis and five symbols for the vertical axis. You can enter the time frame, the lookback period, and... more

Thom Hartle
Feb 19, 2015
Updated: Sep 14, 2018

This Microsoft Excel® spreadsheet presents two views of current market data and two correlation matrices. The market data sections use the symbols entered into the first column. The last quoted price and net change are displayed. In addition, the... more

Thom Hartle
Jun 09, 2016
Updated: Sep 14, 2018

This Microsoft Excel® dashboard displays market data and correlations of US equity SPDR® (Standard & Poor's Depositary Receipts) ETF products. The ETFs are grouped by Core, Style, Sector, and Industry.

You can enter a time frame and a... more