Lesson 2 of 8

Diversification and correlation

Step 3 of 6

Worked example

Daily total returns (dividends included) from Yahoo Finance adjusted closes, computed by script on 20 Nov 2026. The first close is 11 Jan 2024, the day US spot bitcoin funds such as IBIT began trading; the last is 19 Nov 2026. That gives 717 daily returns, just under three years. The funds:

  • SPY: the S&P 500 (500 large US companies).
  • QQQ: the Nasdaq-100 (100 large, tech-heavy US companies).
  • TLT: long-term US government bonds (20+ years).
  • GLD: gold.
  • IBIT: bitcoin (a fund that holds bitcoin and trades like a share).
Pair Correlation What it means
SPY – QQQ 0.95 Nearly the same bet
SPY – GLD 0.20 Weak link
SPY – TLT 0.11 Almost no link
SPY – IBIT 0.42 Moderate link
Bitcoin – Ether 0.82 Crypto moves together

(Bitcoin–Ether: Yahoo's BTC-USD and ETH-USD prices every calendar day, 19 Nov 2023 to 19 Nov 2026, 1,096 daily returns, because crypto trades at weekends.)

So SPY plus QQQ is not diversification (most of QQQ's companies are in SPY), and five coins are mostly one crypto bet.

The bitcoin number depends on the data

Measured three ways over about three years of daily returns, stocks against bitcoin came out between 0.2 and 0.4: 0.42 for IBIT against SPY (the 717 returns above), and 0.38 for Yahoo's BTC-USD and 0.20 for FRED's Coinbase series (CBBTCUSD), both against FRED's S&P 500 index on the same 752 days. Bitcoin trades around the clock, so a "daily close" taken at a different time from the 4 pm New York close blurs which day a move belongs to. Always say which price series you used.

Correlations can jump in a crisis

Damodaran's yearly total returns (updated 5 Jan 2026). A 60/40 portfolio here means 60% S&P 500 and 40% 10-year US government bonds:

Year S&P 500 10-year bond 60/40 mix
2008 −36.55% +20.10% −13.9%
2022 −18.04% −17.83% −18.0%
2008: 0.6 × −36.55 + 0.4 × 20.10  = −21.93 + 8.04  = −13.9%
2022: 0.6 × −18.04 + 0.4 × −17.83 = −10.82 − 7.13  = −18.0%

In 2008 bonds rose while stocks crashed. In 2022, when rising interest rates hit both, bonds gave no cushion at all.

Bitcoin too: in the 2020 crash (SPY and Yahoo BTC-USD, 29 daily returns to 31 Mar 2020 from the 19 Feb close) the correlation was 0.58, higher than the 0.38–0.42 above. Diversification can help least on the worst days.