# SEC 13F Manager Quarterly Report Scraper (`automation-lab/sec-13f-manager-quarterly-report-scraper`) Actor Extract SEC 13F manager holdings rows with CUSIP, value, shares, voting authority, filing dates, and source XML URLs. - **URL**: https://apify.com/automation-lab/sec-13f-manager-quarterly-report-scraper.md - **Developed by:** [Stas Persiianenko](https://apify.com/automation-lab) (community) - **Categories:** Business - **Stats:** 2 total users, 1 monthly users, 100.0% runs succeeded, 0 bookmarks - **User rating**: No ratings yet ## Pricing Pay per event This Actor is paid per event. You are not charged for the Apify platform usage, but only a fixed price for specific events. Since this Actor supports Apify Store discounts, the price gets lower the higher subscription plan you have. Learn more: https://docs.apify.com/platform/actors/running/actors-in-store#pay-per-event ## What's an Apify Actor? Actors are a software tools running on the Apify platform, for all kinds of web data extraction and automation use cases. In Batch mode, an Actor accepts a well-defined JSON input, performs an action which can take anything from a few seconds to a few hours, and optionally produces a well-defined JSON output, datasets with results, or files in key-value store. In Standby mode, an Actor provides a web server which can be used as a website, API, or an MCP server. Actors are written with capital "A". ## How to integrate an Actor? If asked about integration, you help developers integrate Actors into their projects. You adapt to their stack and deliver integrations that are safe, well-documented, and production-ready. The best way to integrate Actors is as follows. In JavaScript/TypeScript projects, use official [JavaScript/TypeScript client](https://docs.apify.com/api/client/js.md): ```bash npm install apify-client ``` In Python projects, use official [Python client library](https://docs.apify.com/api/client/python.md): ```bash pip install apify-client ``` In shell scripts, use [Apify CLI](https://docs.apify.com/cli/docs.md): ````bash # MacOS / Linux curl -fsSL https://apify.com/install-cli.sh | bash # Windows irm https://apify.com/install-cli.ps1 | iex ```bash In AI frameworks, you might use the [Apify MCP server](https://docs.apify.com/platform/integrations/mcp.md). If your project is in a different language, use the [REST API](https://docs.apify.com/api/v2.md). For usage examples, see the [API](#api) section below. For more details, see Apify documentation as [Markdown index](https://docs.apify.com/llms.txt) and [Markdown full-text](https://docs.apify.com/llms-full.txt). # README ## SEC 13F Manager Quarterly Report Scraper Extract institutional investment manager holdings from public SEC 13F-HR and 13F-HR/A filings. ### What does this SEC 13F scraper do? This actor downloads SEC EDGAR submissions JSON, finds quarterly 13F filings, locates the filing information-table XML, and saves one dataset row per holding. It is built for structured holdings data, not raw filing archiving. ### Who is it for? - Financial analysts tracking hedge-fund and institutional positions - Investor-relations teams monitoring peer ownership - Fintech data teams enriching securities datasets - Compliance teams reviewing reported 13F positions - Journalists and researchers following manager portfolio changes ### Why use it? SEC 13F filings are public but awkward to normalize at scale. This scraper turns XML filings into export-ready rows with manager, filing, issuer, CUSIP, value, share amount, discretion, and voting authority fields. ### How does it work? 1. You provide SEC CIKs or resolvable manager/ticker queries. 2. The actor requests `data.sec.gov/submissions/CIK##########.json`. 3. It filters recent filings for `13F-HR` and optionally `13F-HR/A`. 4. It opens each SEC archive `index.json`. 5. It chooses the information-table XML document. 6. It parses every `infoTable` holding. 7. It saves normalized rows to the default dataset. ### Data you can extract | Field | Description | |---|---| | managerCik | SEC manager CIK | | managerName | SEC registrant/manager name | | formType | 13F-HR or 13F-HR/A | | filingDate | SEC filing date | | reportDate | Period/report date from submissions metadata | | accessionNumber | SEC accession number | | issuerName | Reported issuer name | | titleOfClass | Security class | | cusip | CUSIP | | reportedValue | Raw SEC information-table value | | sharesOrPrincipalAmount | Shares/principal amount | | sharesOrPrincipalType | SH or PRN | | putCall | Put/call marker when reported | | investmentDiscretion | Investment discretion | | votingSole | Sole voting authority | | votingShared | Shared voting authority | | votingNone | No voting authority | | informationTableUrl | Source XML URL | ### How much does it cost to scrape SEC 13F holdings? The actor uses pay-per-event pricing. You pay a small run start fee and a per-holding-row fee. Because the actor uses public SEC HTTP endpoints and no browser, typical compute costs are low. ### Input: manager CIKs Use `ciks` for the most reliable workflow. Examples: ```json { "ciks": ["0001067983"], "maxFilings": 2, "maxItems": 150 } ```` ### Input: manager names or tickers Use `managerQueries` when you only know a ticker or exact SEC directory name. CIKs are still recommended because many 13F managers are not operating-company tickers. ### Input: date range Use `fromDate` and `toDate` to limit filing dates. Example: ```json { "ciks": ["0001067983"], "fromDate": "2025-01-01", "toDate": "2026-12-31" } ``` ### Input: amendments Set `includeAmendments` to `true` to include `13F-HR/A` filings. Set it to `false` if your workflow only wants original filings. ### Input: limits Use `maxFilings` to control how many filings are processed. Use `maxItems` to cap dataset rows. Small first runs are recommended while testing a new manager list. ### Output example ```json { "managerCik": "0001067983", "managerName": "BERKSHIRE HATHAWAY INC", "formType": "13F-HR", "filingDate": "2026-05-15", "reportDate": "2026-03-31", "issuerName": "ALLY FINL INC", "cusip": "02005N100", "reportedValue": 498992850, "sharesOrPrincipalAmount": 12719675, "investmentDiscretion": "DFND", "votingSole": 12719675 } ``` ### Tips for best results - Prefer CIKs over names. - Start with `maxFilings: 1` for a smoke test. - Keep a real contact in the SEC User-Agent field. - Use date filters for repeat quarterly jobs. - Export CSV for spreadsheets and BI tools. ### Common use cases - Monitor a manager's latest quarterly holdings - Build a 13F holdings history database - Compare reported positions across managers - Enrich securities records by CUSIP - Feed compliance or due-diligence workflows ### Integrations Use the Apify API to run this actor on a schedule after quarterly 13F filing deadlines. Export results to: - Google Sheets - Snowflake - BigQuery - PostgreSQL - S3 - Internal dashboards ### API usage with Node.js ```js import { ApifyClient } from 'apify-client'; const client = new ApifyClient({ token: process.env.APIFY_TOKEN }); const run = await client.actor('automation-lab/sec-13f-manager-quarterly-report-scraper').call({ ciks: ['0001067983'], maxFilings: 2, maxItems: 150, }); console.log(run.defaultDatasetId); ``` ### API usage with Python ```python from apify_client import ApifyClient import os client = ApifyClient(os.environ['APIFY_TOKEN']) run = client.actor('automation-lab/sec-13f-manager-quarterly-report-scraper').call(run_input={ 'ciks': ['0001067983'], 'maxFilings': 2, 'maxItems': 150, }) print(run['defaultDatasetId']) ``` ### API usage with cURL ```bash curl -X POST \ "https://api.apify.com/v2/acts/automation-lab~sec-13f-manager-quarterly-report-scraper/runs?token=$APIFY_TOKEN" \ -H 'Content-Type: application/json' \ -d '{"ciks":["0001067983"],"maxFilings":2,"maxItems":150}' ``` ### MCP: use with Claude Desktop and Claude Code Connect Apify MCP and enable this actor: ```bash claude mcp add apify-sec-13f https://mcp.apify.com/?tools=automation-lab/sec-13f-manager-quarterly-report-scraper ``` Claude Desktop JSON configuration: ```json { "mcpServers": { "apify-sec-13f": { "url": "https://mcp.apify.com/?tools=automation-lab/sec-13f-manager-quarterly-report-scraper" } } } ``` Example prompts: - "Run the SEC 13F scraper for Berkshire Hathaway and summarize the top holdings." - "Compare the latest two 13F filings for this CIK." - "Export these 13F holdings to CSV." ### Scheduling Create an Apify task with your manager CIK list. Schedule it quarterly or monthly depending on your monitoring workflow. ### SEC fair-access notes The actor uses public SEC endpoints. It sends a descriptive User-Agent and processes filings conservatively. Do not remove the contact string if you run at larger scale. ### Data freshness The actor reads current SEC submissions metadata at run time. New filings become available when SEC publishes them through EDGAR. ### Limitations - Name resolution is best-effort through the SEC ticker directory. - CIK input is recommended for institutional managers. - The actor does not calculate quarter-over-quarter position changes by itself. - The actor does not enrich CUSIPs with market prices. ### Troubleshooting If you get no rows, check that the CIK files 13F-HR reports in the selected date range. If a manager name does not resolve, provide the CIK directly. If SEC returns throttling responses, lower the filing limit and keep a descriptive User-Agent. ### Legality SEC EDGAR filings are public records. You are responsible for using the data in compliance with SEC terms, fair-access guidance, and your local laws. ### FAQ #### Why did my run return no holdings? The CIK may not have a 13F-HR filing in your selected filing-date range. Expand the date range or verify the manager CIK on SEC EDGAR. #### Why should I use CIKs instead of names? SEC manager names can vary and many 13F filers are not ticker-listed operating companies. CIKs are exact and avoid ambiguity. ### Related scrapers - https://apify.com/automation-lab/sec-form-nport-mutual-fund-holdings-scraper - https://apify.com/automation-lab/sec-investment-adviser-public-disclosure-scraper - https://apify.com/automation-lab/sec-form-adv-filing-monitor ### Support If you need a missing 13F XML variant handled, open an issue with the CIK, accession number, and expected output. ### Changelog Initial version extracts SEC 13F-HR and 13F-HR/A holdings from public EDGAR information tables. # Actor input Schema ## `ciks` (type: `array`): SEC CIK values for institutional investment managers. Enter with or without leading zeroes. ## `managerQueries` (type: `array`): Optional names/tickers to resolve using the SEC company ticker directory. CIKs are more reliable for 13F managers. ## `fromDate` (type: `string`): Earliest SEC filing date to include, in YYYY-MM-DD format. ## `toDate` (type: `string`): Latest SEC filing date to include, in YYYY-MM-DD format. Leave empty for latest available. ## `includeAmendments` (type: `boolean`): Include 13F-HR/A amended filings in addition to original 13F-HR filings. ## `maxFilings` (type: `integer`): Maximum 13F filings to process across all managers. ## `maxItems` (type: `integer`): Maximum holding rows to save to the dataset. ## `userAgent` (type: `string`): Descriptive User-Agent/contact string sent to SEC. Keep a real contact for SEC fair-access compliance. ## Actor input object example ```json { "ciks": [ "0001067983", "0001166559" ], "managerQueries": [], "fromDate": "2025-01-01", "includeAmendments": true, "maxFilings": 3, "maxItems": 20, "userAgent": "AutomationLabs SEC 13F Scraper contact@automation-lab.io" } ``` # Actor output Schema ## `overview` (type: `string`): No description # API You can run this Actor programmatically using our API. Below are code examples in JavaScript, Python, and CLI, as well as the OpenAPI specification and MCP server setup. ## JavaScript example ```javascript import { ApifyClient } from 'apify-client'; // Initialize the ApifyClient with your Apify API token // Replace the '' with your token const client = new ApifyClient({ token: '', }); // Prepare Actor input const input = { "ciks": [ "0001067983", "0001166559" ], "managerQueries": [], "fromDate": "2025-01-01", "toDate": "", "includeAmendments": true, "maxFilings": 3, "maxItems": 20, "userAgent": "AutomationLabs SEC 13F Scraper contact@automation-lab.io" }; // Run the Actor and wait for it to finish const run = await client.actor("automation-lab/sec-13f-manager-quarterly-report-scraper").call(input); // Fetch and print Actor results from the run's dataset (if any) console.log('Results from dataset'); console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`); const { items } = await client.dataset(run.defaultDatasetId).listItems(); items.forEach((item) => { console.dir(item); }); // 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs ``` ## Python example ```python from apify_client import ApifyClient # Initialize the ApifyClient with your Apify API token # Replace '' with your token. client = ApifyClient("") # Prepare the Actor input run_input = { "ciks": [ "0001067983", "0001166559", ], "managerQueries": [], "fromDate": "2025-01-01", "toDate": "", "includeAmendments": True, "maxFilings": 3, "maxItems": 20, "userAgent": "AutomationLabs SEC 13F Scraper contact@automation-lab.io", } # Run the Actor and wait for it to finish run = client.actor("automation-lab/sec-13f-manager-quarterly-report-scraper").call(run_input=run_input) # Fetch and print Actor results from the run's dataset (if there are any) print("💾 Check your data here: https://console.apify.com/storage/datasets/" + run["defaultDatasetId"]) for item in client.dataset(run["defaultDatasetId"]).iterate_items(): print(item) # 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start ``` ## CLI example ```bash echo '{ "ciks": [ "0001067983", "0001166559" ], "managerQueries": [], "fromDate": "2025-01-01", "toDate": "", "includeAmendments": true, "maxFilings": 3, "maxItems": 20, "userAgent": "AutomationLabs SEC 13F Scraper contact@automation-lab.io" }' | apify call automation-lab/sec-13f-manager-quarterly-report-scraper --silent --output-dataset ``` ## MCP server setup ```json { "mcpServers": { "apify": { "command": "npx", "args": [ "mcp-remote", "https://mcp.apify.com/?tools=automation-lab/sec-13f-manager-quarterly-report-scraper", "--header", "Authorization: Bearer " ] } } } ``` ## OpenAPI specification ```json { "openapi": "3.0.1", "info": { "title": "SEC 13F Manager Quarterly Report Scraper", "description": "Extract SEC 13F manager holdings rows with CUSIP, value, shares, voting authority, filing dates, and source XML URLs.", "version": "0.1", "x-build-id": "aqfEvgiSiJCG6Q2GN" }, "servers": [ { "url": "https://api.apify.com/v2" } ], "paths": { "/acts/automation-lab~sec-13f-manager-quarterly-report-scraper/run-sync-get-dataset-items": { "post": { "operationId": "run-sync-get-dataset-items-automation-lab-sec-13f-manager-quarterly-report-scraper", "x-openai-isConsequential": false, "summary": "Executes an Actor, waits for its completion, and returns Actor's dataset items in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK" } } } }, "/acts/automation-lab~sec-13f-manager-quarterly-report-scraper/runs": { "post": { "operationId": "runs-sync-automation-lab-sec-13f-manager-quarterly-report-scraper", "x-openai-isConsequential": false, "summary": "Executes an Actor and returns information about the initiated run in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK", "content": { "application/json": { "schema": { "$ref": "#/components/schemas/runsResponseSchema" } } } } } } }, "/acts/automation-lab~sec-13f-manager-quarterly-report-scraper/run-sync": { "post": { "operationId": "run-sync-automation-lab-sec-13f-manager-quarterly-report-scraper", "x-openai-isConsequential": false, "summary": "Executes an Actor, waits for completion, and returns the OUTPUT from Key-value store in response.", "tags": [ "Run Actor" ], "requestBody": { "required": true, "content": { "application/json": { "schema": { "$ref": "#/components/schemas/inputSchema" } } } }, "parameters": [ { "name": "token", "in": "query", "required": true, "schema": { "type": "string" }, "description": "Enter your Apify token here" } ], "responses": { "200": { "description": "OK" } } } } }, "components": { "schemas": { "inputSchema": { "type": "object", "properties": { "ciks": { "title": "Manager CIKs", "type": "array", "description": "SEC CIK values for institutional investment managers. Enter with or without leading zeroes.", "items": { "type": "string" } }, "managerQueries": { "title": "Manager names or tickers", "type": "array", "description": "Optional names/tickers to resolve using the SEC company ticker directory. CIKs are more reliable for 13F managers.", "items": { "type": "string" } }, "fromDate": { "title": "From filing date", "type": "string", "description": "Earliest SEC filing date to include, in YYYY-MM-DD format." }, "toDate": { "title": "To filing date", "type": "string", "description": "Latest SEC filing date to include, in YYYY-MM-DD format. Leave empty for latest available." }, "includeAmendments": { "title": "Include amendments", "type": "boolean", "description": "Include 13F-HR/A amended filings in addition to original 13F-HR filings.", "default": true }, "maxFilings": { "title": "Maximum filings", "minimum": 1, "maximum": 1000, "type": "integer", "description": "Maximum 13F filings to process across all managers.", "default": 3 }, "maxItems": { "title": "Maximum holdings rows", "minimum": 1, "maximum": 100000, "type": "integer", "description": "Maximum holding rows to save to the dataset.", "default": 500 }, "userAgent": { "title": "SEC User-Agent contact", "type": "string", "description": "Descriptive User-Agent/contact string sent to SEC. Keep a real contact for SEC fair-access compliance." } } }, "runsResponseSchema": { "type": "object", "properties": { "data": { "type": "object", "properties": { "id": { "type": "string" }, "actId": { "type": "string" }, "userId": { "type": "string" }, "startedAt": { "type": "string", "format": "date-time", "example": "2025-01-08T00:00:00.000Z" }, "finishedAt": { "type": "string", "format": "date-time", "example": "2025-01-08T00:00:00.000Z" }, "status": { "type": "string", "example": "READY" }, "meta": { "type": "object", "properties": { "origin": { "type": "string", "example": "API" }, "userAgent": { "type": "string" } } }, "stats": { "type": "object", "properties": { "inputBodyLen": { "type": "integer", "example": 2000 }, "rebootCount": { "type": "integer", "example": 0 }, "restartCount": { "type": "integer", "example": 0 }, "resurrectCount": { "type": "integer", "example": 0 }, "computeUnits": { "type": "integer", "example": 0 } } }, "options": { "type": "object", "properties": { "build": { "type": "string", "example": "latest" }, "timeoutSecs": { "type": "integer", "example": 300 }, "memoryMbytes": { "type": "integer", "example": 1024 }, "diskMbytes": { "type": "integer", "example": 2048 } } }, "buildId": { "type": "string" }, "defaultKeyValueStoreId": { "type": "string" }, "defaultDatasetId": { "type": "string" }, "defaultRequestQueueId": { "type": "string" }, "buildNumber": { "type": "string", "example": "1.0.0" }, "containerUrl": { "type": "string" }, "usage": { "type": "object", "properties": { "ACTOR_COMPUTE_UNITS": { "type": "integer", "example": 0 }, "DATASET_READS": { "type": "integer", "example": 0 }, "DATASET_WRITES": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_READS": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_WRITES": { "type": "integer", "example": 1 }, "KEY_VALUE_STORE_LISTS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_READS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_WRITES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_INTERNAL_GBYTES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_EXTERNAL_GBYTES": { "type": "integer", "example": 0 }, "PROXY_RESIDENTIAL_TRANSFER_GBYTES": { "type": "integer", "example": 0 }, "PROXY_SERPS": { "type": "integer", "example": 0 } } }, "usageTotalUsd": { "type": "number", "example": 0.00005 }, "usageUsd": { "type": "object", "properties": { "ACTOR_COMPUTE_UNITS": { "type": "integer", "example": 0 }, "DATASET_READS": { "type": "integer", "example": 0 }, "DATASET_WRITES": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_READS": { "type": "integer", "example": 0 }, "KEY_VALUE_STORE_WRITES": { "type": "number", "example": 0.00005 }, "KEY_VALUE_STORE_LISTS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_READS": { "type": "integer", "example": 0 }, "REQUEST_QUEUE_WRITES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_INTERNAL_GBYTES": { "type": "integer", "example": 0 }, "DATA_TRANSFER_EXTERNAL_GBYTES": { "type": "integer", "example": 0 }, "PROXY_RESIDENTIAL_TRANSFER_GBYTES": { "type": "integer", "example": 0 }, "PROXY_SERPS": { "type": "integer", "example": 0 } } } } } } } } } } ```