Form D Flow (SEC private-offering pulse by month, PIT-clean, w/ breakdown) [beta]
mars_form_d_flowAggregate SEC Form D private-offering flow as a time series — "how much private capital was raised via Reg D exemptions by month?" — with industry / jurisdiction / entity-type breakdowns. The cleanest PIT-anchored private-capital pulse mars ships: every row is a real SEC filing, so filing_date is a genuine point-in-time date (the day it hit EDGAR), with no extraction ambiguity, no dedup, and no coverage cliff. 765K filings (410K of them pooled-fund), 2006 → today.
Required: from_date + to_date (max 20-year window) + bucket (week|month|quarter|year). Optional: industry (industry_group_type exact — the live values are descriptive title-case strings, e.g. 'Other Technology', 'Commercial', 'Biotechnology', 'Oil and Gas', 'REITS and Finance', 'Residential', 'Other Health Care', 'Investing', 'Manufacturing', 'Other' — NOT uppercase codes), jurisdiction_of_inc (FULL UPPERCASE name, e.g. 'DELAWARE' / 'TEXAS' / 'CALIFORNIA' / 'NEVADA' / 'BRITISH COLUMBIA, CANADA' — NOT a 2-letter code), entity_type ('Corporation' / 'Limited Liability Company' / 'Limited Partnership' / 'Business Trust' — LP is a decent fund-vehicle proxy), breakdown_by (industry|jurisdiction|entity_type|fund_type), as_of (PIT gate on filing_date).
Contracts: (1) NO integrity_tier filter — Form D rows are SEC-clean by construction. (2) exclude_amendments defaults true — amendments are retroactive updates that would double-count. (3) total_offering_amount = the offering REGISTERED (a ceiling, not necessarily raised); total_amount_sold = raised as of the filing date (can grow via later amendments). Report both; don't call the offering amount 'raised.' (4) as_of gates filing_date <= as_of — a past as_of reconstructs the pulse as it was knowable then, leak-free.
Fund flows (2026-07-18): fund_type ('Hedge Fund' / 'Private Equity Fund' / 'Venture Capital Fund' / 'Other Investment Fund' — exact title-case) + is_pooled_fund (bool) are now populated (410K pooled filings, ~54% of corpus), so PE/VC/Hedge private-fund flow is one query — e.g. fund_type='Venture Capital Fund' for the VC-fund-formation pulse; each bucket also carries n_pooled_funds. Complements mars_sector_funding_flow (news-extracted operating raises); the two are NOT summable.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"from_date": "<from_date>",
"to_date": "<to_date>",
"bucket": "<bucket>"
},
"name": "mars_form_d_flow"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| as_of | No | ISO 8601 UTC PIT gate on filing_date. Default now(). | |
| bucket | Yes | Bucket size. Required. | |
| to_date | Yes | YYYY-MM-DD. Required. Must be > from_date; max 20-year window. | |
| industry | No | industry_group_type exact match — descriptive title-case (e.g. 'Other Technology', 'Commercial', 'Biotechnology', 'Oil and Gas'). | |
| from_date | Yes | YYYY-MM-DD. Required. Lower bound on filing_date. | |
| fund_type | No | Pooled-vehicle fund type, EXACT title-case: 'Hedge Fund' / 'Private Equity Fund' / 'Venture Capital Fund' / 'Other Investment Fund'. Only pooled filings carry it (~54% of corpus). | |
| entity_type | No | Filer entity type ('Corporation' / 'Limited Liability Company' / 'Limited Partnership' / 'Business Trust'). | |
| breakdown_by | No | Split each bucket by this dimension (one flat row per bucket × value). | |
| is_pooled_fund | No | true = pooled investment vehicles only; false = operating-company/other. Omit for both. | |
| exclude_amendments | No | Exclude amendment filings (retroactive updates). Default true — set false to include. | |
| jurisdiction_of_inc | No | Full UPPERCASE jurisdiction of incorporation, e.g. 'DELAWARE' / 'TEXAS' / 'CALIFORNIA' / 'NEVADA' / 'BRITISH COLUMBIA, CANADA'. Not a 2-letter code. |