evo-sec-13f-analysis

SEC 13F Filings Analysis Skill

Overview

Analyze SEC Form 13F filings from EDGAR bulk data. Supports fuzzy searching for fund managers, calculating AUM, counting stock positions, comparing holdings across quarters, and finding top holders of specific securities.

Data Structure

• COVERPAGE.tsv: Filing-level index with FILINGMANAGER_NAME and ACCESSION_NUMBER
• INFOTABLE.tsv: Individual security holdings with CUSIP, VALUE (in dollars for 2023+), SSHPRNAMT
• Tables joined by ACCESSION_NUMBER

Key Rules

• VALUE column is in dollars for filings from 2023 onward
• ACCESSION_NUMBER changes every quarter - must look up independently per quarter
• Fuzzy matching needed for FILINGMANAGER_NAME (case-insensitive)
• Aggregate by CUSIP before cross-quarter comparison
• Use outer join for complete position change analysis
• Count stocks by unique CUSIPs

Quick Start — End-to-End Usage

import sys
sys.path.insert(0, '/app/environment/skills/evo-sec-13f-analysis/scripts')
from utils import run_13f_analysis, validate_answers

# Run the full analysis: discovers funds, computes AUM, compares quarters,
# finds top holders, and writes answers.json
answers = run_13f_analysis(
    q2_dir='/root/2025-q2',
    q3_dir='/root/2025-q3',
    output_path='/root/answers.json'
)

# Validate the output
validate_answers('/root/answers.json')

Individual Utility Functions

For custom analysis, you can import individual functions:

import sys
sys.path.insert(0, '/app/environment/skills/evo-sec-13f-analysis/scripts')
from utils import (
    load_coverpage, load_infotable, fuzzy_search_coverpage,
    get_accession_number, get_fund_aum, get_holdings, count_stocks,
    compare_holdings_across_quarters, find_cusip_by_issuer, top_holders_by_cusip
)

# Load data
coverpage = load_coverpage('/root/2025-q3')
infotable = load_infotable('/root/2025-q3')

# Find a fund manager (fuzzy match)
name, acc = get_accession_number(coverpage, 'renaissance technologies', infotable)

# Get AUM
aum = get_fund_aum(infotable, acc)

# Count stocks
num_stocks = count_stocks(infotable, acc)