Trader’s roundtable: correllation between ETFs

Creativity, management
Comments
Microsoft Excel (Windows)
Image via Wikipedia

In a recent discussion among traders, the idea of how to measure the correlation between various ETFs in the world market model arose.

Here is my method:

I set up a table, updated automatically daily iwant to compare the daily % gains and losses as the data points, then just pick the desired time frames and run =CORREL on it in Excel, that uses the =CORREL function to find the correllations between the broad indices

Iwant to compare the daily % gains and losses as the data points, then just pick your desired time frames and run =CORREL on it
I  use XLQ from qmatix.com to fetch and update daily performance data; a great time saving utility program with a robust  set of functions and a great yahoo group.
see attached snapshot of todays correllations
the left table is a cross-correllation on 200 days of data
the right table is 4 diff times frames of indices vs SPY
green is exceptionally highly correllated,  red is exceptionally uncorrellated for that data set
Related articles by Zemanta
Reblog this post [with Zemanta]
Tortoise Capital Management © 1996 Frontier Theme