DEV Community

Mehdad Sharifi
Mehdad Sharifi

Posted on Edited on

Fast SEC EDGAR XML Parsers & JSON APIs (Form 4, 13F, N-PORT, 10-K XBRL, 8-K) for Python & MCP

Raw SEC EDGAR XML and XBRL filings are notoriously messy to parse due to XSLT wrappers, changing US-GAAP accounting tags, and deeply nested XML tables.

I built a lightweight suite of SEC EDGAR, Biotech, and B2B Intelligence APIs on Apify using pure async Python httpx (zero headless browser overhead, runs in ~4 seconds). They convert live US government filings directly into flat JSON, CSV, or Excel rows, and also work natively as MCP servers for Claude Desktop, Cursor, and n8n workflows:

  1. SEC Form 4 Insider Trading XML Parser API
    Extracts exact CEO, CFO, and Director open-market purchases (P) and sales (S), share counts, share prices, and total dollar values:
    https://apify.com/mehdad-datalabs/sec-form-4-insider-trading-scraper-xml-parser-api

  2. SEC Form 13F Institutional Holdings & Hedge Fund Whale Scraper
    Parses 13F-HR XML tables for Berkshire Hathaway (Warren Buffett), Scion (Michael Burry), BlackRock, and Citadel with automatic portfolio weight % and Put/Call option detection:
    https://apify.com/mehdad-datalabs/sec-13f-institutional-holdings-hedge-fund-whale-scraper

  3. SEC Form N-PORT Mutual Fund & ETF Portfolio Holdings API
    Extracts monthly/quarterly ETF and Mutual Fund equity, bond, and derivative holdings, CUSIPs, ISINs, and net asset weights %:
    https://apify.com/mehdad-datalabs/sec-nport-etf-mutual-fund-holdings-xml-scraper

  4. SEC 10-K & 10-Q XBRL Financial Statements & Earnings API
    Standardized quarterly and annual Revenue, Net Income, Net Profit Margin %, Diluted EPS, Operating Cash Flow, Cash, Total Assets, and Liabilities:
    https://apify.com/mehdad-datalabs/sec-10k-10q-xbrl-financial-statements-earnings-api

  5. SEC Form 8-K Corporate Events, M&A & Executive Change Scraper
    Automatically decodes 8-K item codes into plain-English catalysts including Item 5.02 CEO/CFO changes, Item 2.02 earnings releases, and Item 1.01/2.01 M&A deals:
    https://apify.com/mehdad-datalabs/sec-8k-corporate-events-ma-executive-change-scraper

  6. SEC Schedule 13D & 13G Activist Investor & 5%+ Ownership API
    Tracks hostile takeover campaigns (13D) and 5%+ institutional whale block stakes (13G):
    https://apify.com/mehdad-datalabs/sec-schedule-13d-13g-activist-investor-ownership-api

  7. SEC Form S-1 IPO Pipeline & Form 144 Insider Sale Notice API
    Tracks new S-1/F-1 tech IPO registrations, S-3 dilution shelf offerings, and Rule 144 restricted stock sale notices:
    https://apify.com/mehdad-datalabs/sec-ipo-s1-form144-insider-sale-scraper

  8. SEC Form D Startup Funding, VC Raise & Founder B2B Lead API
    Extracts newly funded private startups raising seed/VC rounds, exact dollar amounts raised, and Founder/CEO names and phone numbers from Form D XML:
    https://apify.com/mehdad-datalabs/sec-form-d-startup-funding-vc-b2b-lead-scraper

  9. US Federal Government Contract Awards & DoD B2B Lead Scraper
    Extracts Pentagon (DoD) and federal contract awards by keyword (AI, Cybersecurity, Defense) or company name:
    https://apify.com/mehdad-datalabs/us-federal-government-contract-awards-dod-b2b-scraper

  10. FDA Drug Approvals, NDA/BLA Biotech Catalyst & Pharma API
    Extracts official US FDA New Drug (NDA), Biologics (BLA), and Generic (ANDA) approvals and pharmaceutical sponsors:
    https://apify.com/mehdad-datalabs/fda-drug-approvals-biotech-catalyst-pharma-b2b-scraper

  11. ClinicalTrials.gov Phase 1-3 Biotech Catalyst & B2B Lead API
    Extracts active Phase 1, 2, and 3 clinical trials, pharma sponsors, primary completion readout dates, and study contact emails/phones:
    https://apify.com/mehdad-datalabs/clinical-trials-biotech-catalyst-cro-b2b-lead-scraper

  12. US Doctor, Dentist & Medical Clinic B2B Lead Scraper API
    Extracts verified US physicians, dentists, and medical clinics from the CMS NPI Registry with clinic owner names and direct phone numbers:
    https://apify.com/mehdad-datalabs/us-doctor-dentist-clinic-healthcare-b2b-lead-scraper

  13. CFPB Fintech & Bank Consumer Complaint Intelligence API Extract official US CFPB consumer financial complaints against banks, fintech apps, crypto exchanges (Coinbase, Robinhood, PayPal), lenders & credit bureaus into JSON/CSV. Get complaint narratives, product issues, states & company responses. Built for law firms, quant funds & MCP AI. https://apify.com/mehdad-datalabs/cfpb-fintech-bank-consumer-complaint-b2b-scraper

  14. SEC DEF 14A Executive Compensation & Proxy Statement API Extract real-time SEC EDGAR Form DEF 14A Definitive Proxy Statements, DEFM14A Merger Proxies & DFAN14A Activist Proxy Contests into clean JSON/CSV. Track CEO/CFO compensation disclosures, board elections, golden parachutes & shareholder votes. Ready for executive recruiters, n8n & MCP AI. https://apify.com/mehdad-datalabs/sec-def14a-ceo-executive-compensation-proxy-scraper

  15. FDIC US Bank Directory, Deposits, Assets & B2B Lead API Extract official US FDIC BankFind directory & bank financial health data into clean JSON/CSV. Get Commercial & Community Bank Names, Total Assets ($), Total Deposits ($), Net Income, ROA/ROE %, Branch Counts, Websites & HQ Addresses. Ideal for B2B fintech sales, n8n & MCP AI agents. https://apify.com/mehdad-datalabs/fdic-us-bank-directory-deposits-assets-b2b-scraper

All of them can be tested for free using Apify's free monthly tier. Would love any feedback on additional SEC forms or public B2B datasets you would like added!

Top comments (0)