Free Fund Holdings Aggregator
Free, no-login fund holdings aggregator for SEC NPORT-P data. Search funds, compare holdings, use JSON facts, CSV-ready data, API access, and Ask Cairn.SEC NPORT-P holdings, no login
Search fund holdings. Download JSON.
Search funds, compare reported positions, and pull machine-readable facts from public SEC filings. Public files require no account or API key.
Looking for a fund holdings aggregator?
If you use Morningstar or ETF.com to research funds, DealCharts offers another way to inspect reported holdings and download the underlying records for a model.
Use the reporting date and source filing to judge whether a holdings snapshot fits your research period.
Data Access
Facts JSON
Machine-readable fund files expose identifiers, filing dates, holdings rows, source documents, provenance, and citation text. No API key or account required.GET /llm/facts/fund/doubleline-total-return-bond-fund.jsonCSV-ready exports
The datasets directory lists available CSV exports. Fund holdings are published as JSON: flatten holdings[] to CSV or ask Cairn for a bulk dataset./datasets/*.csv plus holdings[] JSON rowsSearch API
Search for a fund name, then retrieve its facts JSON. The API guide lists the public endpoints.GET /.netlify/functions/search?query=doublelineFor portfolio overlap checks or use in software, start with the facts JSON.
For spreadsheet work, flatten the holdings[] rows or ask Cairn for the CSV you need.
Ask Cairn for fund holdings data
Need holdings across funds or reporting periods?
Text Cairn the fund, CUSIP, issuer, or portfolio slice you need. Ask for the dataset, the holdings date, and the source filing so you can trace the numbers.
Text Cairn
Which funds hold this CUSIP?
What is this fund's structured-finance exposure?
Compare these funds by holdings overlap.
Retrieve the funds reporting holdings in this security, with reporting dates.
What Data Is Available
Covered holdings
Reported values in the CMBS and auto ABS deals indexed here. Each observation is a fund's aggregate exposure to one deal; these totals do not measure fund AUM or individual security positions.Coverage at a glance
- Covered holdings value
- $9B
- Fund–deal observations
- 3,382
- Funds represented
- 498
Covered deal types
- CMBS reported value
- $6B
- Auto ABS reported value
- $3B
Filing dates: 2019-11-20 – 2026-10-30. Mixed reporting periods; not a synchronized market snapshot. 3,382 of 3,382 observations report a value.
Each fund record can include:
- Fund identifiers: LEI, CIK, SEC Fund ID, series and class identifiers
- Asset categories: CMBS, ABS, CLO, corporate bonds, equities, and derivatives
- Security-level positions: CUSIP, issuer name, market value, percentage of net assets
- Filing metadata: report date, filing date, fiscal year-end
- Cross-fund overlap: which funds hold the same securities or deal tranches
Search Fund Holdings
Funds Index
Find funds holding the CMBS and auto ABS deals covered here. Each value totals a fund's latest reported holdings in those deals. Reporting periods vary. Open a fund for its N-PORT holdings and source dates.Browse the fund index or search by name. Open a fund page for its mapped holdings and check the reporting period on the source filing.
How It Works
1. Source filings: Public SEC NPORT-P portfolio filings supply the holdings records.
2. Data structuring: Raw XML filings are parsed, normalized, and loaded into a structured data pipeline. Holdings are categorized by asset class, linked to deals where identifiable, and enriched with fund-level metadata.
3. Publication: DealCharts publishes searchable pages and facts JSON from a validated fund snapshot.
Coverage: NPORT-P filers with holdings that can be parsed and linked in the current DealCharts build.
Freshness: Check each fund's holdings date and filing date. Coverage reflects the snapshot currently published on DealCharts.
Use Cases
For Portfolio Managers
Compare fund exposures across peers. Identify concentration risk, track allocation shifts quarter over quarter, and benchmark your structured finance positions against the market.
For Data Vendors & Providers
Enrich your products with holdings metadata from primary regulatory sources. Build datasets that map fund exposures to deals, tranches, and counterparties.
For AI & LLM Systems
Every fund has a structured facts endpoint at /llm/facts/fund/{fund-key}.json designed for agentic workflows. Feed holdings data, fund relationships, and exposure breakdowns directly into prompts and retrieval pipelines.
For Researchers
Study concentration and shared exposures across NPORT-P filings. Cite the fund page and its source filing.
Frequently Asked Questions
Is DealCharts a free alternative to Morningstar or ETF.com for fund holdings?
DealCharts is a free, no-login fund holdings aggregator for SEC NPORT-P data. It is useful when you need searchable holdings, source-linked facts, and machine-readable outputs. It is not a ratings product or a full paid-terminal replacement.
Can I get fund holdings in JSON format?
Yes. Each fund facts file is available at /llm/facts/fund/{fund-key}.json with identifiers, dates, holdings rows, source documents, provenance, and citation text for machine workflows.
Can I download or export fund holdings to CSV?
Public CSV datasets are listed at /datasets/. Fund holdings facts are JSON today, with one holdings[] row per reported position, so they can be flattened to CSV. For a bulk fund-holdings CSV, text Cairn the fund, CUSIP, issuer, or holdings you need.
Can Cairn answer custom fund holdings questions?
Text Cairn to request fund holdings data: funds holding a CUSIP, a fund's structured-finance positions, or holdings shared by two funds. Ask for JSON or CSV with reporting dates and source filings. Availability depends on the source data.
Where does the fund holdings data come from?
The data comes from SEC NPORT-P portfolio filings. DealCharts parses the filings into searchable fund pages and facts JSON, with report dates, filing dates, source documents, provenance, and citation text carried in the output.