Data Sources & Methodology
NY Fed SOMA Holdings API
As-of dates: Wednesday weekly. Data published following day. parValue is a string in the API; coerced on ingest. inflationCompensation is empty string (not null) before 2007-03-14 — the IC era gate in schema treats these as zero, never fail.
Reconciliation — soma_cusip_par_vs_summary
CUSIP-level parValue SUM vs summary notesbonds + bills + tips + frn. Tolerance ±$500k (p99 of measured residuals). TIPS rows use parValue (pre-IC); IC delta tracked separately as tipsInflationCompensation. Pre-2007-03-14 skipped (IC era gate).
FOMC QT Caps
Hand-maintained in fed_runoff_caps table. Partial unique index on effective_to IS NULL enforces single active cap. Cap for MBS separate from Treasuries. Source citations stored per row.
Note on MoM Attribution
MoM uses prior Wednesday ~28 days earlier (not prior calendar month-end). changeFromPriorWeek carries up to 7-day attribution error at month boundaries; use soma_maturity_schedule.maturity_date for exact Fed-redemption timing.