13f-analyzer
Perform various data analysis on SEC 13-F and obtain some insights of fund activities such as number of holdings, AUM, and change of holdings between two quarters.
- License 许可
- Apache-2.0
- 最近更新
- 2026-11-14
- Stars
- ★ 0
- Forks
- 1
01 前言 Front Matter
- name
- 13f-analyzer
- description
- Perform various data analysis on SEC 13-F and obtain some insights of fund activities such as number of holdings, AUM, and change of holdings between two quarters.
02 资源文件 2
- 脚本scripts/holding_analysis.py2.2 KB
- 脚本scripts/one_fund_analysis.py5.2 KB
03 SKILL.md 正文
Overview
All helper scripts live under 13f-analyzer/scripts/. Invoke them with the
skill-folder-prefixed path (examples below assume the working directory is
/root or any directory that contains the 13f-analyzer/ skill folder).
Quantity conventions (IMPORTANT)
- AUM (dollars): sum of
INFOTABLE.VALUEacross every row for the accession, OR equivalentlySUMMARYPAGE.TABLEVALUETOTALfor the accession. The scripts here use the INFOTABLE sum and report it asTotal AUM. - Number of stocks held: the number of distinct CUSIPs on the
common-equity subset (after filtering
TITLEOFCLASSto common/ADR/etc.), NOT the raw INFOTABLE row count. Options and multiple share classes for the same issuer can inflate the row count; always deduplicate onCUSIP. - Top Buys / Top Sells across quarters: compute per-CUSIP VALUE sums
within each quarter FIRST, then outer-merge on CUSIP, then take the dollar
delta
v_current - v_baseline, rank descending by that delta.
Analyze the holding summary of a particular fund in one quarter:
python3 13f-analyzer/scripts/one_fund_analysis.py \
--accession_number ... \
--quarter 2025-q2
This prints, for the given accession in the given quarter:
Total number of INFOTABLE rows(raw row count — diagnostic only)Total AUM(sum ofVALUEacross all rows for the accession, in dollars)Number of stock holdings (distinct CUSIPs)— this is the canonical "how many stocks are held" answerTotal stock AUM(sum ofVALUErestricted to the common-equity subset)
Analyze the change of holdings of a particular fund between two quarters:
python3 13f-analyzer/scripts/one_fund_analysis.py \
--quarter 2025-q3 \
--accession_number <accession number assigned in q3> \
--baseline_quarter 2025-q2 \
--baseline_accession_number <accession number assigned in q2>
Recipe used internally (and recommended if you redo it by hand):
- For each quarter, filter
INFOTABLEto the accession. - Restrict to common-equity rows via the
TITLEOFCLASSwhitelist. groupby('CUSIP').VALUE.sum()per quarter so duplicate CUSIP rows are collapsed.- Outer-merge the two per-CUSIP tables on
CUSIP, fill missing values with 0. ABS_CHANGE = VALUE_current - VALUE_baseline.- Sort descending by
ABS_CHANGE→ positive deltas are Top Buys; negative deltas (ascending) are Top Sells. Rank by dollar delta, not shares and not percentage.
Analyze which funds hold a stock to the most extent
python3 13f-analyzer/scripts/holding_analysis.py \
--cusip <stock cusip> \
--quarter 2025-q3 \
--topk 10
The script reads INFOTABLE and COVERPAGE for the requested quarter,
sums VALUE per ACCESSION_NUMBER for the given CUSIP, joins to
COVERPAGE.FILINGMANAGER_NAME, and prints the top-k rows as
rank, FILINGMANAGER_NAME, ACCESSION_NUMBER, TOTAL_VALUE. Use the printed
FILINGMANAGER_NAME directly for questions that ask for fund-manager names.
04 同仓库更多 Skills
video-frame-extraction
Extract frames from video files and save them as images using OpenCV
openai-vision
Analyze images and multi-frame sequences using OpenAI GPT vision models
image-ocr
Extract text content from images using Tesseract OCR via Python, including structured field extraction from receipts and forms
video-frame-extraction
Extract frames from video files and save them as images using OpenCV
openai-vision
Analyze images and multi-frame sequences using OpenAI GPT vision models
image-ocr
Extract text content from images using Tesseract OCR via Python, including structured field extraction from receipts and forms