Lesson 2 of 8

Diversification and correlation

Step 4 of 6

Do it yourself

Small and practical. Do it now while it is fresh.

About 6 minutes. Made-up monthly returns (%) for three funds:

Month Fund A Fund B Fund C
1 2 1 −1
2 −3 −2 2
3 4 3 −2
4 1 2 0
5 −2 −1 1
6 3 2 −1

Put them in a sheet and use =CORREL() for A with B, and A with C. Which fund would do more to smooth a portfolio that already holds A?

Show answer

A–B: about +0.96. A–C: about −0.98.

Fund C. It moves opposite to A; Fund B is nearly a copy of A. (Six months is far too few to trust; real correlations need years of data.)

Next lesson: Position sizing: how big is each bet?, setting the most you'll lose on one idea and working backwards to how much to buy.