Welcome to the Peppercorn Data Browser. Ask me anything about your fund data — I'll translate your question into SQL and show the results.

Try:
• "Show me all funds with their share class counts"
• "What are the latest NAV prices for BlackRock?"
• "Compare YTD returns across all share classes for portfolio 42"
• "Which funds have the highest net assets?"
• "Show composition breakdown for Golub Capital as of 2025"
Select a fund from the sidebar

NAV Per Share History

Select a fund to load charts

Total Net Assets

Returns (YTD)

Composition Breakdown

Distribution History

Offering Price

Shares Outstanding

🔧 Maintenance

Data enrichment and repair tools.

Remap Share Classes

Merge multiple share classes into one. All PE data rows referencing the source share classes will be updated to the target share class ID. Useful for remapping orphaned placeholder classes.

→

Fill Missing NAVPS / NetAssets

Calculates missing NAVPS or NetAssets from SharesOutstanding data: NAVPS = NetAssets ÷ Shares, NetAssets = NAVPS × Shares.

Composition Data Dedup

Finds duplicate composition data per (date, type) from different filings. Shows totals for each set — delete the one with incorrect percentages.

Holdings Data Dedup

Finds duplicate holdings per date from different filings. Shows row count, total fair value, and total % — delete the incorrect set.

Harmonize Share Class Names

Standardizes share class naming: "Class S Shares" → "S", "Institutional Class" → "I", normalizes status codes, and syncs ShareClassCode with ShareClassName.

Enrich Fund Profiles from EDGAR

Fetches the latest filing for each fund, extracts fund metadata (strategy, manager, inception, etc.) and share class details (minimums, distribution policy, structure) using Claude, then updates T_PORT_PORTFOLIO and T_PORT_SHARE_CLASS.

Database

Anthropic API