Lesson 4 of 6

Risk: volatility and drawdowns

Step 4 of 6

Do it yourself

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

About 8 minutes. Here are FRED's daily closes for the 12 months to 19 Nov 2026 (checked 20 Nov 2026):

Highest close Lowest close after that date
Bitcoin (CBBTCUSD) $96,852.91 on 14 Jan 2026 $58,585.96 on 30 Jun 2026
S&P 500 (SP500) 7,818.93 on 6 Oct 2026 7,323.63 on 18 Nov 2026
  1. Compute each drawdown: trough ÷ peak − 1.
  2. Compute the gain each needs to get back: peak ÷ trough − 1.
  3. Which fell further from its top? Which needs the bigger gain to recover?

Optional, about 15 minutes: find the numbers yourself. This FRED link downloads a file of bitcoin's daily closes since 20 Nov 2025 (one row per day: date, price). Open it in your spreadsheet. =MAX(B:B) gives the highest close; search the sheet for that number to find its date. Then use =MIN() on the rows below it for the lowest close after. For the S&P 500, change CBBTCUSD to SP500 in the link.

Show answers
Bitcoin:  58,585.96 ÷ 96,852.91 − 1 = −39.5%   gain needed: +65.3%
S&P 500:  7,323.63 ÷ 7,818.93 − 1   = −6.3%    gain needed: +6.8%

Bitcoin fell much further, and needs a much bigger gain to get back. If you downloaded the files on a later day, your 12 months and numbers will differ.

Next lesson: Probability and expected value. Instead of guessing one outcome, you'll think in several outcomes with odds attached.