BTC: Realized Loss by Age
Shown as its 2019–2022 sample; the latest readings and full history are included with Pro.
The loss realized each day by coins spent below their cost, split by the age of the spent coins.
Why use it. Shows which holding periods capitulate: heavy losses from young coins are typical of sharp sell-offs, losses from old coins of deep bear markets. How to read it. The bands stack to the day's total realized loss.
Calculation. For each band: the sum of spent coins x (their creation-day price - the price at the start of the day they were spent), over the coins spent below their cost. A coin's age is counted in whole UTC days: the reporting day minus the UTC day its output was created, by block header time. The bands are: under 1 day (created that same day), 1 day to 1 week (1 to 6 days), 1 week to 1 month (7 to 29 days), 1-3 months (30 to 89), 3-6 months (90 to 179), 6-12 months (180 to 364), 1-2 years (365 to 729), 2-3 years (730 to 1,094), 3-5 years (1,095 to 1,824), 5-7 years (1,825 to 2,554), 7-10 years (2,555 to 3,649), 10-15 years (3,650 to 5,474) and 15 years or more. Because ages are counted in whole days rather than hours, a coin near a band edge can sit in the neighbouring band for up to a day. A spent coin's sale value is the BTC/USD price at the start of the UTC day it was spent and its cost the price at the start of the day it was created, the site's SOPR convention; a spend is in profit when the first is higher and in loss when it is lower. Coins created and spent on the same UTC day share one price, so the under-1-day band always has a SOPR of 1 and no realized profit or loss. Ages belong to outputs, not owners: spending an output resets the age of everything it pays, change and moves between one owner's addresses included, so the bands show how long coins have been unmoved on the blockchain, not how long their holders have held them. Coins created before 18 July 2010, the first day with a BTC/USD price, have no cost basis and are left out of every USD value and ratio here; they sit in the oldest bands. Computed by CryptoKeyhole from its own Bitcoin node's record of every unspent and spent output by creation day, with its own admitted daily BTC/USD prices. Daily from 18 July 2010. Each value describes the UTC day after its last block, valued at the day's closing price; the open day is a labelled partial, valued at the latest completed hour and updated through the day, and becomes final six blocks after the day's last block.