Join Early Retirement Today
Reply
 
Thread Tools Display Modes
Correlations
Old 04-04-2007, 10:55 AM   #1
Recycles dryer sheets
 
Join Date: Sep 2005
Posts: 97
Correlations

So, I've been going through my investments, reading investment books, thinking about slicing and dicing vs total market, etc. Being a little bored this morning I decided to put the last few years returns into a spreadsheet to see how the asset class correlations work out. Using the Excel CORREL() function, I get the following correlations (calculated on the yearly returns) between the S&P500 and the following assets:

2000 - 2006 (sorted)
===========
VTRIX (VG Intl val): 0.979
VGTSX (VG Intl): 0.961
NAESX (VG Small): 0.951
VWELX (VG Wellington): 0.905
VGSIX (VG Reit): 0.821
Dogs of the Dow: 0.813
DODBX (DC balanced): 0.790
VISVX (VG Small val): 0.782


Looking at just more recent data:
2002-2006 (also sorted)
=========
VGTSX: 0.999
VTRIX: 0.997
VWELX: 0.997
DODBX: 0.976
NAESX: 0.972
VISVX: 0.972
VGSIX: 0.901
Dogs: 0.820


From this data, asset allocation using the common slicing and dicing methods appears to be a waste of time.

I'm thinking this means the financial markets have become very efficient and it's easy for a person like me to buy into all these assets. Money flows easily around and around.

__________________
Is this a good time to RE ? Ok, how about now...
Dry Socks is offline   Reply With Quote
Join the #1 Early Retirement and Financial Independence Forum Today - It's Totally Free!

Are you planning to be financially independent as early as possible so you can live life on your own terms? Discuss successful investing strategies, asset allocation models, tax strategies and other related topics in our online forum community. Our members range from young folks just starting their journey to financial independence, military retirees and even multimillionaires. No matter where you fit in you'll find that Early-Retirement.org is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with our members, see fewer ads, upload photographs, create a retirement blog, send private messages and so much, much more!

Re: Correlations
Old 04-04-2007, 11:09 AM   #2
Recycles dryer sheets
fluffy's Avatar
 
Join Date: Jun 2006
Posts: 82
Re: Correlations

http://etf.seekingalpha.com/article/24018 did something similar and its results show less correlation for int'l.

Note their "Beware the Black Box" section -- perhaps this happened with your results?
__________________
We come in the spirit of hostility and menace
fluffy is offline   Reply With Quote
Re: Correlations
Old 04-04-2007, 11:13 AM   #3
Thinks s/he gets paid by the post
FIRE'd@51's Avatar
 
Join Date: Aug 2006
Posts: 2,433
Re: Correlations

Even though correlation coefficients of 0.8 - 0.9 can appear to be high, there can still be significant tracking error between the two portfolios. The tracking error (standard deviation of the return difference) for two portfolios is calculated from:

tracking error = S x ( 1 - R^2 ) ^ 0.5

where S = the portfolio volatility and R is the correlation coefficient

If R=0.9 and S = 15% (annual)

tracking error = 15 x ( 1 - 0.81)^0.5 = 15 x 0.44 = 6.5%

This means that there is about a 1/3 probability that the return difference between the two portfolios will be greater than 6.5% over a year.
__________________
I'd rather be governed by the first one hundred names in the telephone book than the Harvard faculty - William F. Buckley
FIRE'd@51 is offline   Reply With Quote
Re: Correlations
Old 04-04-2007, 11:30 AM   #4
Recycles dryer sheets
 
Join Date: Sep 2005
Posts: 97
Re: Correlations

Quote:
Originally Posted by fluffy
http://etf.seekingalpha.com/article/24018 did something similar and its results show less correlation for int'l.

Note their "Beware the Black Box" section -- perhaps this happened with your results?
I just used yearly returns and a somewhat different time period. Maybe that's the source of the difference. Or, since I used only yearly data, maybe this is one of those errors when calculating the statistics from a small sample size.

For yearly returns I just used the yearly data from Morningstar in their total returns page.
__________________
Is this a good time to RE ? Ok, how about now...
Dry Socks is offline   Reply With Quote
Re: Correlations
Old 04-04-2007, 11:57 AM   #5
Recycles dryer sheets
 
Join Date: Sep 2005
Posts: 97
Re: Correlations

Quote:
Originally Posted by FIRE'd@51
Even though correlation coefficients of 0.8 - 0.9 can appear to be high, there can still be significant tracking error between the two portfolios.
Thanks!

Another thing I just noticed. 2003 was a big year for all of the indexes. Removing that year from the calculation reduces the correlations by a large amount. For example: DODBX goes from 0.79 to 0.62.
__________________
Is this a good time to RE ? Ok, how about now...
Dry Socks is offline   Reply With Quote
Re: Correlations
Old 04-04-2007, 01:16 PM   #6
Recycles dryer sheets
 
Join Date: Mar 2005
Posts: 329
Re: Correlations

5yrs is too small a period esp when you do yearly returns. Not enough data points. You might want to do monthly returns atleast. Also the last few yrs have been lights out for almost all asset classes. Everything went up a lot. And there haven't been any big negative events in specific asset classes. Extend it to 10+ yrs and you might start noticing stuff.

Also there is not rule which says the correlations should stay where they are right now

-h
__________________
Hope springs eternal in the human breast:Man never is, but always to be blest.
The soul, uneasy and confined from home,Rests and expatiates in a life to come.
lswswein is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
recommended bond portfolio JohnEyles FIRE and Money 54 10-07-2006 03:09 PM
An oddball idea? modlair FIRECalc support 90 06-17-2006 05:04 PM
SWR rule-of-thumb assuming principal preservation Delawaredave FIRE and Money 13 02-05-2006 11:22 PM
SWR of 6.21% for 26 years amt FIRE and Money 242 03-19-2005 04:17 AM

» Quick Links

 
All times are GMT -6. The time now is 04:28 AM.
 
Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2024, vBulletin Solutions, Inc.