API Enterprise

One exchange-traded fund's holdings over a date window: every line of every holdings file the fund published in it, oldest file first and largest weight first within a file, with the file's provenance.

The response is uncharged, and the instrument block says which fund was resolved.

Available Data Points:

• As Of Date: The holdings date the fund's file states (YYYY-MM-DD).
• Holding Name: The holding's name as the issuer prints it.
• Holding Ticker: The holding's ticker as the issuer prints it; empty where the issuer prints none.
• Holding ISIN: The holding's ISIN as the issuer prints it; empty where the issuer prints none.
• Asset Class: equity, bond, cash, futures or other (normalized by ORTEX); cash, futures and collateral lines are kept so the weights sum to the fund.
• Shares: Shares or units (par for a bond) the fund holds, as printed.
• Market Value: Market value of the holding in the fund's reporting currency, as printed.
• Weight: Fraction of the fund (0.1024 is 10.24%), as printed.
• Data Source: The issuer or exchange adapter that fetched the file (ishares_us, sec_nport).
• Fetched At: When ORTEX's archive received the file (ISO 8601, UTC): the earliest the holdings could be known.
• Holding Exchange: The holding's venue as the issuer names it; empty where the issuer names none.
• Holding MIC: The MIC ORTEX maps that venue to; empty when it maps to none. Never guessed from a ticker.
• Currency: The holding's currency as the issuer prints it (ISO 4217).
• Sector: The issuer's own sector label, in the issuer's scheme (not GICS); empty where none is printed.
• Ortex Tid: The held instrument's ORTEX listing id where ORTEX matched the line (by ISIN, or ticker and venue); null where it did not. Unmatched lines are served: they carry weight.
• Ortex Sid: The held instrument's ORTEX security id (all listings of one share line); null where unmatched.
• Ortex Cid: The held instrument's ORTEX company id; null where unmatched.
• Holding FIGI: OpenFIGI identifier of the listing ORTEX matched the line to; null where unmatched or unknown.
• Holding Composite FIGI: OpenFIGI composite (country-level) identifier of that listing; null where unknown.
• Holding Share Class FIGI: OpenFIGI share-class identifier of the matched instrument, the same on every listing of it; null where unknown.

Identifying the fund

The path is the same as on every other single-instrument endpoint: the venue, then the ticker (US/SPY, XETR/SPY5), or an identifier scheme and its value (isin/IE00B4L5Y983). An ETF is resolved against ORTEX's fund master rather than the listing master, so a fund with no listing in the security master is still reachable by venue and ticker or by ISIN. A malformed identifier is 400 invalidIdentifier; one matching no fund is 404 instrumentNotFound.

Date window

from_date is required; to_date defaults to today. Every file dated inside the window is served; a fund that publishes monthly or quarterly has one file a month or a quarter. An empty result carries the fund's full holdings range in meta.availability. Only the file in force for each date is served: when an issuer re-issues a file, the later one.

CSV is paged

A CSV response is one page, like JSON (page / page_size, up to your plan's page size), because a whole result can run to millions of lines. The Ortex-Total-Rows header gives the total, so a loader knows how many pages to request.

Try it out! You can test the API with the trial key TEST. Simply include it in your request headers; either here, or add the header "Ortex-Api-Key": "TEST" to your http request.

Trial key restrictions: Trial keys may be limited to a specific date range and set of regions. Requests outside the allowed regions or entirely outside the allowed date range are rejected; a date window that partially overlaps the allowed range is trimmed to it, reported in meta.restriction.

Get full access! Contact [email protected]