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.