@pipeworx/sec-nport
Connect: https://gateway.pipeworx.io/sec-nport/mcp · Install: one-click buttons
Tools: 3
Mutual fund and ETF portfolio holdings, from SEC Form N-PORT. Keyless.
Tools
nport_fund_owners(security, quarter?, limit?)— which funds and ETFs hold a stock or bond, ranked by position size. Takes a ticker, a company name, or a CUSIP.nport_fund_portfolio(fund, quarter?, limit?)— one fund’s reported positions, largest first.nport_holdings_coverage()— which releases are loaded, how current they are, and what the data does not cover.
The inversion is the point of this pack
“Which ETFs hold the largest positions in NVDA?” returned no_match before this shipped, and the
router explained the gap in its own words: it would have to check each ETF individually.
edgar_fund_holdings goes fund → holdings. Nothing went security → funds, because SEC publishes
N-PORT filing-first and so does every API over it. That is a shape problem, not a rate-limit problem.
This is not 13F warmed over. 13F is institutional managers over $100M, long US equity only. N-PORT is registered funds — mutual funds and ETFs — and carries their bond positions too. “Which funds hold this corporate bond” has no 13F answer at all.
Scope, stated because a partial load read as a complete one is a wrong answer
The quarterly archive is 441MB across 32 tables. Loaded: equity, preferred and debt positions —
about 3.6M of the 5.35M holdings rows per quarter, across 14,416 funds. Not loaded: derivatives,
loans, repos and structured products. A swap notional is not a holding of the underlying, and
reporting it as one would be a wrong answer wearing a right one’s clothes. Every response carries
this in its scope field.
Two more caveats ride on every answer:
- N-PORT is filed monthly but released publicly on a quarterly lag, roughly 60 days after the
quarter ends. Responses carry
as_of_period. An answer that implies real-time is wrong. - N-PORT has no ETF flag. These are registered funds, which include ETFs and mutual funds alike; the series name is the only hint. An ETF-only answer cannot be given honestly from this filing, so the pack says that rather than inventing the classification.
Ticker resolution
The holdings table keys on CUSIP, which is proprietary to CUSIP Global Services, so this pack does
not build or cache a bulk CUSIP↔ticker table. A ticker-shaped input resolves live through
OpenFIGI (Bloomberg FIGI, openly licensed) to a canonical company name, which is then matched
against issuer_name in our own already-ingested rows — preferring the candidate that is not an
ETF or option wrapper, because “NVDA” otherwise matches Direxion Daily NVDA Bull 2X right
alongside NVIDIA and ranks them together. Same discipline as the 13F pack, deliberately.
Source
SEC Form N-PORT data sets — https://www.sec.gov/data-research/sec-markets-data/form-n-port-data-sets
Tools
- nport_fund_owners — Which mutual funds and ETFs hold a given stock or bond, ranked by position size, from SEC Form N-PORT portfolio filings — the reverse of a fund fact sheet, which makes you name the fund first. Give a
- nport_fund_portfolio — The portfolio a mutual fund or ETF reported to the SEC on Form N-PORT: its largest positions with issuer, value, share or principal count, and percent of net assets. Give the fund or ETF series name (
- nport_holdings_coverage — Which SEC Form N-PORT releases are loaded, how many funds each carries, the newest reporting period, and what the data does and does not cover. Use this to check how current fund holdings answers are
Tools
-
nport_fund_owners— Which mutual funds and ETFs hold a given stock or bond, ranked by position size, from SEC Form N-PORT portfolio filings — the reverse of a fund fact sheet, which makes you name the fund first. Give a -
nport_fund_portfolio— The portfolio a mutual fund or ETF reported to the SEC on Form N-PORT: its largest positions with issuer, value, share or principal count, and percent of net assets. Give the fund or ETF series name ( -
nport_holdings_coverage— Which SEC Form N-PORT releases are loaded, how many funds each carries, the newest reporting period, and what the data does and does not cover. Use this to check how current fund holdings answers are