Definition
An ETF holdings file is an issuer-provided snapshot of positions and weights as of a stated date. Unlike a fact sheet's top-ten list, a complete file may include securities, cash, receivables, derivatives, collateral, short positions, and identifiers such as CUSIP or ISIN.
It shows current implementation, not the permanent boundaries of the strategy. The prospectus describes what a fund may do; the holdings file shows what it reported doing at one moment. Some files are daily, others delayed or periodic, and column definitions differ by issuer.
Why It Matters
A fund name can conceal concentration, duplicated exposure, credit risk, option notional, or a large cash balance. Complete holdings help test whether the portfolio supports the strategy story. They also improve overlap analysis because two different security names may represent the same issuer, index exposure, or economic risk.
A single file is still not a performance explanation. Settlement items can temporarily inflate cash, derivatives can create exposure beyond market value, and a rebalance can make one date unrepresentative. Preserve dates and definitions before drawing conclusions.
A Repeatable Reading Order
1. Verify the file
Confirm fund name, ticker, share class, as-of date, publication date, currency, and whether the file is complete. Save the original rather than copying only visible webpage rows.
2. Read the data dictionary
Identify how the issuer defines weight, market value, par value, shares, coupon, maturity, and asset class. Determine whether weights use net assets, gross assets, or another denominator. Parentheses or negative values may indicate shorts, liabilities, or formatting—not missing data.
3. Reconcile the total
Sum reported weights where practical and investigate why they differ from 100%. Rounding, cash, receivables, payables, leverage, derivatives, and unsettled trades can explain a gap. Do not force a file to total 100% by deleting rows you do not understand.
4. Normalize identities
Use stable identifiers when available. Group share classes, bonds from the same issuer, fund-of-fund positions, and derivatives tied to the same reference asset. Keep both issuer and security-level views: credit concentration and instrument concentration answer different questions.
5. Measure relevant exposures
For equity funds, inspect company, sector, country, and top-position weights. For bond funds, inspect issuer, credit quality, maturity, duration, and currency. For option funds, capture underlying, contract type, strike, expiration, direction, contracts, and notional where available. Market value alone can understate derivative exposure.
6. Compare with governing documents
Test current positions against the objective, principal strategy, concentration policy, and index methodology. A permitted exposure may be absent today. An unfamiliar line may be collateral or a transition position rather than a new strategy.
7. Compare multiple dates
Use several snapshots around ordinary periods and rebalances. Separate durable design from trading noise, then log unexplained changes for issuer commentary or shareholder reports.
Example
An illustrative option-income ETF's webpage lists ten stocks totaling 42%. Its downloaded file also contains an index option with almost no positive market value, Treasury collateral, cash, and receivables. Noah initially calls it a plain equity portfolio.
After reading the column definitions, he calculates the option's notional exposure and recognizes that market value does not measure the obligation. He groups stock and derivative exposure by underlying, checks the option mandate in the prospectus, and repeats the review after expiration. The complete picture matches an equity-plus-options strategy, not the top-ten preview alone.
Common Mistakes
- Using top holdings as the complete portfolio. Important exposures may sit below the cutoff.
- Ignoring the as-of date. Holdings and fund statistics may describe different dates.
- Treating market value as derivative exposure. Notional, delta, and contract terms may matter.
- Dropping cash and accounting rows. They can explain reconciliation differences.
- Assuming every negative row is an error. It may represent a short or liability.
- Combining securities by name alone. Identifiers and economic underlyings are more reliable.
- Treating one rebalance date as normal. Compare multiple snapshots.
FAQ
Why do weights not add to exactly 100%?
Rounding, derivatives, leverage, unsettled trades, receivables, payables, and the stated denominator can all affect the total. Consult the file definitions before interpreting the difference.
How often should I download holdings?
Match frequency to the strategy and decision. A stable broad index fund may need less monitoring than an active, leveraged, or options-heavy fund. Always capture a new file before a material review.
Are daily holdings audited?
Do not assume they are. Treat issuer files as useful dated disclosures and reconcile important questions with shareholder reports and other official documents.
What should I read next?
For an index fund, compare current positions with its index methodology. For any fund, use Fund Overlap to translate rows into portfolio-level concentration.
