• UnderwaterUnderwater
Analysis
  • Overview
  • Cost-basis map
  • Assets
  • Portfolio
  • Methodology
liveSep 29
  1. Dashboard
  2. Methodology
as of Sep 29, 04:15 AM

Methodology

How the cost basis and the underwater supply are derived, which endpoints feed them, and where the CoinMarketCap API got in the way.

Methodology

Price tells you what an asset is worth. It does not tell you what the people holding it paid. We reconstruct an aggregate cost basis from one year of daily price and volume, then measure how much of that traded supply sits at a loss.

cost basis = Σ(priceᵢ · volumeᵢ) / Σ(volumeᵢ)
underwater = Σ volumeᵢ [priceᵢ > price_now] / Σ volumeᵢ

CoinMarketCap exposes price and 24h volume but not realised cost basis, so VWAP over the trailing window is used as the proxy for the market's aggregate entry price. A coin is underwater when most of the volume that traded in the last year changed hands above today's price. The marginal holder is holding a loss.

Stablecoins are excluded and assets with fewer than 120 daily observations are dropped. The market series begins 2025-11-13. Snapshot assembled 9/29/2026, 4:15:30 AM.

Endpoints used

  • /v1/cryptocurrency/listings/latest
    universe, tags to sectors, volume
  • /v1/cryptocurrency/quotes/historical
    365 daily price + volume points
  • /v3/fear-and-greed/historical
    sentiment overlay
  • /v1/global-metrics/quotes/latest
    market-wide context
Where the API got in the way: history is capped at 12 months, quotes/historical is billed per row, and there is no field for realised entry price, so VWAP is a proxy.