SEC EDGAR Form D Offerings — New Capital Raised

Every SEC EDGAR Form D and Form D/A exempt-offering notice filed in your date window, with the full issuer record — and with the one number the source refuses to state: how much capital was actually raised in that filing.

The problem this exists to fix

totalAmountSold on a Form D/A amendment is the offering's cumulative lifetime total, not the money raised in that filing. Nothing in the filing says so. A field named totalAmountSold, on a document dated today, reads as today's raise — so any pipeline that treats a D/A as a funding event double-counts every dollar the offering has ever taken.

Measured against the live source over all 55 amendments filed 2026-08-05, every one of which resolved to the filing it supersedes:

totalAmountSold as filed, summed	$7,522,721,612
New capital actually raised	$1,578,311,991
Old money already counted on an earlier filing	79%

And it does not fail in only one direction. 40 of those 55 amendments raise the figure over the filing they supersede, 16 of them from a prior of exactly $0 — so "just ignore amendments" is not a fix either. That is where the genuine new money arrives.

Concrete: on 2026-08-05, AG Realty Value Fund X (A), L.P. filed a D/A reporting totalAmountSold of $371,750,789. The filing it amends reported the same $371,750,789. New capital raised in that filing: $0. Any minimum amount filter reading the as-filed field waves it through as a $371M round.

What you get

Each row is one Form D or D/A filing, carrying:

The resolved amounts — totalAmountSoldAsFiled, priorTotalAmountSoldUsd (from the filing this one supersedes, reached through previousAccessionNumber), newCapitalRaisedUsd (the difference), amountIsCumulative, and newCapitalBasis stating exactly how the number was derived.

The issuer — entity name, CIK, full address, phone, jurisdiction of incorporation, entity type, year of incorporation, industry group, investment fund type, revenue range.

The offering — total offering amount as filed (including the literal Indefinite, never coerced to 0), amount remaining, date of first sale, duration, minimum investment accepted, security types, federal exemptions claimed, non-accredited investor flag, investor count, sales commissions, finders' fees, gross proceeds used.

The people — every related person (executive officers, directors, promoters) with name, relationships, location and role clarification.

Provenance — accession number, filing date, direct EDGAR URLs for both this filing and the prior one, so every number is one click from its source.

Filter on the real number

minNewCapitalUsd filters on money actually raised in the filing, not on the cumulative total. On 2026-08-05, ten amendments would clear a $1,000,000 cumulative floor while having raised nothing at all. Those are exactly the rows that pollute a funding-signal feed.

Input

{
  "startDate": "2026-08-05",
  "endDate": "2026-08-05",
  "formTypes": ["D", "D/A"],
  "minNewCapitalUsd": 1000000,
  "maxFilings": 1000
}

All fields optional. With no input at all it reads the most recent complete business day — deliberately not today, because EDGAR's daily index keeps growing through the evening and a run against today returns a partial set that looks complete. Window maximum is 31 days.

Sample output

{
  "accessionNumber": "0001739086-26-000001",
  "formType": "D/A",
  "filedDate": "2026-08-05",
  "entityName": "AG Realty Value Fund X (A), L.P.",
  "issuerCik": "1739086",
  "stateOrCountry": "NY",
  "entityType": "Limited Partnership",
  "industryGroup": "Pooled Investment Fund",
  "totalOfferingAmountAsFiled": "Indefinite",
  "totalAmountSoldAsFiled": "371750789",
  "totalAmountSoldUsd": 371750789.0,
  "priorAccessionNumber": "0001739086-25-000002",
  "priorTotalAmountSoldUsd": 371750789.0,
  "newCapitalRaisedUsd": 0.0,
  "newCapitalBasis": "AMENDMENT_DELTA",
  "amountIsCumulative": true,
  "guidance": "Form D/A. totalAmountSold is CUMULATIVE for the offering; newCapitalRaised is this filing's total minus the total on the filing it supersedes.",
  "filingUrl": "https://www.sec.gov/Archives/edgar/data/1739086/000173908626000001/primary_doc.xml",
  "priorFilingUrl": "https://www.sec.gov/Archives/edgar/data/1739086/000173908625000002/primary_doc.xml"
}

newCapitalBasis is always one of:

Value	Meaning
ORIGINAL_FILING	Original Form D — the first reported total, so all of it is new.
AMENDMENT_DELTA	Prior filing retrieved; new capital is the difference.
UNRESOLVED_PRIOR	Prior filing unavailable. newCapitalRaisedUsd is null, never guessed.
NON_NUMERIC_AMOUNT	An amount is not a number (e.g. Indefinite). Carried through as filed.

A negative newCapitalRaisedUsd is real and is reported as-is: issuers do revise a total downward, and clamping it to zero would hide the restatement.

Source and correctness

Read directly from SEC EDGAR, keyless, structured XML — not HTML scraping:

• https://www.sec.gov/Archives/edgar/daily-index/{yyyy}/QTR{n}/form.{yyyymmdd}.idx
• https://www.sec.gov/Archives/edgar/data/{cik}/{accession}/primary_doc.xml

The prior filing is reached through previousAccessionNumber under the issuer's CIK — not the accession number's own prefix. On 12 of those 55 amendments the filing was submitted by an agent and the prefix belongs to a different entity, so the obvious prefix-derived URL 404s on about a fifth of the population, silently, as a missing amendment rather than an error.

US federal public-domain data. Requests carry a contact-bearing User-Agent and stay inside SEC's published 10 requests/second fair-access ceiling.

Four canaries abort the run rather than emit a wrong row, because each of these failures produces output that looks perfectly healthy: an index layout change (would read as a quiet day), an empty or truncated index, a renamed XML amounts element (would null every amount), and a broken prior-filing URL (would null newCapitalRaised throughout, indistinguishable from a window with no amendments). All four are exercised as tests, not merely asserted.

Pricing

Pay per event. You are charged for business days indexed, for filings returned, and for amendment chains resolved — the last only when the prior filing was actually retrieved and a real difference computed. Filings excluded by your minNewCapitalUsd floor are not charged.