Financial analysis logic
Logical patterns for comparing 13F holdings across quarters to determine net change.From its SKILL.md
npx -y skills add cxcscmu/SkillLearnBench --skill financial-analysis-logicAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
SKILL.md
0.9 KB, 181 tokens by cl100k_base, as published. Nobody here has run it
Financial Analysis Logic
When comparing quarterly 13F holdings (Q2 vs Q3), follow these steps:
- Accession Number Retrieval: Locate the submission metadata for the target firm in both quarterly folders. The
COVERPAGE.tsvorSUBMISSION.tsvusually links the manager name to an accession number. - Holdings Data Loading:
INFOTABLE.tsvcontains the granular list of stocks held by the manager for that specific submission/accession.- Merge these tables using 'CUSIP' as the primary key.
- Change Calculation:
- Calculate value change:
delta_value = (Q3_value_held - Q2_value_held). - Sort by
delta_valueto identify increased/decreased investments.
- Calculate value change:
- CUSIP Identification: Always normalize CUSIP strings before comparison.
What ships with it
Read from the repository
Just SKILL.md. No reference files, no scripts.