Based on Jonn Geanakoplos's work, and inspired by this post, I though it would be helpful to make this more easily trackable. Data for this project comes from here, with the following methodology:
Pursuant to FINRA Rule 4521(d), FINRA member firms carrying margin accounts for customers are required to submit, on a settlement date basis, as of the last business day of the month, the following customer information:
- the total of all debit balances in securities margin accounts; and
- the total of all free credit balances in all cash accounts and all securities margin accounts.1
FINRA collects the required data via FINRA's Customer Margin Balance Form. The data is compiled in aggregate form, made available below and in Excel format via the download link on this page. See Margin Balance Reporting: Frequently Asked Questions under FINRA Rule 4521(d) (published April 13, 2021) for additional guidance on the calculation of these balances. Monthly variations in the reported balances may be partially due to member firms modifying the methods used in determining the balances reported to FINRA since the publication of the FAQ. Please note, FINRA generally publishes updates to the Margin Statistics on the third week of the month following the reference month. FINRA does not provide the data outside of this webpage and data feeds are not available.
Data is drawn from this public google sheet which is updated monthly.
Points represent cumulative losses for each day, bars represent monthly changes. The line repreents a general additive model smooth on cumulative losses to date; the shaded grey band represents the 95% confidence interval based on extant variation (e.g. point scatter). A wider grey band means more uncertainty, a narrower grey band means less uncertainty.