Fed SOMA Holdings: Federal Reserve Balance Sheet by CUSIP avatar

Fed SOMA Holdings: Federal Reserve Balance Sheet by CUSIP

Pricing

Pay per usage

Go to Apify Store
Fed SOMA Holdings: Federal Reserve Balance Sheet by CUSIP

Fed SOMA Holdings: Federal Reserve Balance Sheet by CUSIP

Official NY Fed System Open Market Account (SOMA) holdings: weekly totals (bills, notes/bonds, TIPS, FRNs, MBS, CMBS, agencies) since 2003, every Treasury and agency MBS CUSIP the Fed holds on any as-of date, or one CUSIP's history. QT tracking, no API key.

Pricing

Pay per usage

Rating

0.0

(0)

Developer

Dmitry Ostrovsky

Dmitry Ostrovsky

Maintained by Community

Actor stats

0

Bookmarked

2

Total users

1

Monthly active users

a month ago

Last modified

Categories

Features

Limited permissions

Share

Apify Actor that pulls the Federal Reserve's System Open Market Account (SOMA) holdings from the official New York Fed Markets Data API (https://markets.newyorkfed.org/static/docs/markets-api.html) and returns clean, typed rows. No API key needed, no scraping.

SOMA is the Fed's portfolio of Treasury and agency securities, the asset side behind quantitative easing (QE) and quantitative tightening (QT). The NY Fed publishes it weekly, as of each Wednesday.

Modes

  • summary (default): weekly totals by asset class since July 2003: bills, notes & bonds, TIPS (plus inflation compensation), FRNs, agency MBS, CMBS, agency debt, and the total, with the week-over-week change in the total. Good for charting QT runoff.
  • treasury: every Treasury CUSIP the Fed holds on one as-of date (about 430 securities): maturity, coupon or FRN spread, par value, share of the issue outstanding held, and the change from the prior week and year.
  • agency: every agency debt, agency MBS and CMBS CUSIP on one as-of date (about 9,000 securities): description (e.g. UMBS MORTPASS 2% 10/51), term, and current face value.
  • cusip: the full weekly history of one or more CUSIPs (Treasury or agency), e.g. to see when the Fed bought a security and how its holding ran off.

Input

  • mode: summary, treasury, agency, or cusip.
  • securityTypes (treasury/agency): Bills, NotesBonds, TIPS, FRNs or MBS, CMBS, Agency Debts. Empty = all.
  • asOfDate (treasury/agency): 2026-10-07. Empty = latest. A non-Wednesday date snaps to the latest published date on or before it.
  • cusips (cusip mode): comma-separated, e.g. 3132DVGB5,912828YK0.
  • startDate / endDate (summary/cusip): optional date filters.
  • lastN (summary): latest N weeks when no start date is set (default 12).
  • minParValue: skip holdings smaller than this (USD).
  • sortBy (treasury/agency): value_desc (default), maturity_asc, as_published.
  • maxRows: total row cap (1-20000, default 1000).

Example: the 20 largest MBS pools the Fed holds right now

{ "mode": "agency", "securityTypes": "MBS", "maxRows": 20 }

Output

Summary row:

{
"asOfDate": "2026-10-07",
"total": 6360519997880.2,
"totalChangeFromPriorWeek": 1946000000,
"bills": 562156926700,
"notesBonds": 3597915855200,
"tips": 279965204500,
"tipsInflationCompensation": 106300118348.37,
"frn": 20045553800,
"mbs": 1890705863534.6,
"cmbs": 7383594145.6,
"agencies": 2347000000,
"totalInBillions": 6360.52,
"source": "Federal Reserve Bank of New York Markets Data API (SOMA)"
}

Holding row (treasury/agency/cusip modes):

{
"asOfDate": "2026-10-07",
"cusip": "912797SK4",
"assetClass": "Treasury",
"securityType": "Bills",
"securityDescription": null,
"issuer": null,
"maturityDate": "2026-10-29",
"coupon": null,
"spread": null,
"term": null,
"parValue": 29005617900,
"currentFaceValue": null,
"value": 29005617900,
"inflationCompensation": null,
"percentOutstanding": 0.0919952532500852,
"changeFromPriorWeek": 0,
"changeFromPriorYear": null,
"isAggregated": null,
"source": "Federal Reserve Bank of New York Markets Data API (SOMA)"
}

value is par value for Treasury and agency debt, and current face value for MBS/CMBS, so you can sort or sum across asset classes. percentOutstanding is published by the NY Fed as a fraction of the issue outstanding (0.092 = 9.2%). Summary total excludes TIPS inflation compensation, matching the NY Fed.

Notes

  • Published weekly (Thursday afternoon ET, as of Wednesday). Amounts in USD.
  • Public data only. Limited-permission Actor; standby off. Not affiliated with the Federal Reserve Bank of New York or the Federal Reserve System.
  • Pairs well with the NY Fed SOFR & reference rates, FINRA short interest and SEC filing Actors from the same author.
  • Charges: one actor-start event per run and one summary-row / holding-row event per dataset item if pay-per-event pricing is enabled.