Institutional Holdings Data: How to Compare Managers and Quarters
A repeatable workflow for turning delayed 13F tables into manager and security-level research.
Institutional holdings data aggregates disclosed positions across investment managers, usually from SEC Form 13F in the United States. Useful history keeps the manager, report period, filing timestamp, accession, security identifier, class, shares, reported value, discretion, voting authority, and amendment lineage so quarter-to-quarter changes can be interpreted without future information.
Choose the correct comparison clock
Holdings are effective at quarter end but become public later. Portfolio change analysis can compare report periods, while an investable signal can begin only after each filing was accepted and available.
Managers may file on different dates, so a cross-manager snapshot built from the latest available reports can mix information ages. Preserve both effective and known-at clocks in every joined table.
Resolve managers and securities
Manager names vary across filings and reorganizations. Use the SEC filer CIK as the durable manager key. For securities, retain the reported CUSIP, issuer, class, and original values even when a normalized ticker is added.
Share-class changes, mergers, spin-offs, splits, and amendments can create apparent buys or sells. A research layer should flag mapping changes rather than hiding them behind a current ticker.
- Compare only eligible filings at the cutoff.
- Version security mappings.
- Separate reported value from calculated portfolio weight.
- Keep confidential-treatment and missing-table states visible.
Metrics worth calculating
Concentration, new positions, exits, share changes, manager overlap, and security-level ownership can be useful derived measures. Each should record its eligible filings, denominator, mapping version, and calculation time.
Avoid ranking managers on stale or incomplete universes. A derived leaderboard is only as reliable as its filing coverage and point-in-time eligibility rules.
How DataCedar preserves the evidence
DataCedar separates acquisition from serving. Permitted source responses are retained with retrieval time and identifiers, normalized into DataCedar-owned tables, checked against expected coverage, and exposed through a stable versioned API. A collector can be replaced without changing the customer contract or making an upstream provider a runtime dependency.
Every research stream carries effective and known-at time where the distinction matters. Rights-restricted, unavailable, partial, stale, and genuinely empty states remain visible, so a backtest can fail closed and a buyer can see the product boundary before committing engineering time.
Key takeaways
- 01Keep effective and public times separate.
- 02Use CIK and CUSIP-based identity before ticker labels.
- 03Treat amendments and corporate actions as first-class events.
- 04Version every derived ownership metric.
Query public company evidence through one stable API. Free Explorer tier, no card.
Start freeView pricing