Run3 Calculate AUM from Holdings
Sum the market values of all holdings to derive the Assets Under Management (AUM) for a fund as of a specific report date. Use this to answer questions about fund size in a given quarter.From its SKILL.md
npx -y skills add cxcscmu/SkillLearnBench --skill run3_Calculate-AUM-from-HoldingsAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
SKILL.md
1.2 KB, 238 tokens by cl100k_base, as published. Nobody here has run it
Steps
-
Verify the value field exists
- Confirm the holdings data has a market value or position value column
- Check field name (e.g., "market_value", "value", "position_value")
- Ensure values are in consistent currency (typically USD)
-
Handle missing or null values
- Identify rows with null market values
- Decide whether to exclude them or impute (usually exclude)
- Document how many rows are excluded
-
Sum all position values
- Calculate total:
AUM = sum(market_value)across all holdings - Ensure calculation uses correct numeric type (avoid string concatenation)
- Calculate total:
-
Verify AUM reasonableness
- Compare against any AUM figures in fund metadata if available
- Check if AUM aligns with fund size expectations (e.g., Renaissance should be large)
- Flag if AUM seems unusually high or low
-
Format and report
- Return AUM as a numeric value (e.g., in millions or billions as appropriate)
- Document the report date and accession_number alongside the AUM
What ships with it
Read from the repository
Just SKILL.md. No reference files, no scripts.