SEC Fails-to-Deliver Data (FTD)
Pricing
$0.20 / 1,000 rows
SEC Fails-to-Deliver Data (FTD)
Official SEC fails-to-deliver data: shares that failed to settle in NSCC's CNS system, by settlement date, CUSIP and ticker, with price and dollar value. Filter by symbol, CUSIP, date range, size. Twice-monthly files back to 2009.
Pricing
$0.20 / 1,000 rows
Rating
0.0
(0)
Developer
Pushbuild Data
Maintained by CommunityActor stats
0
Bookmarked
2
Total users
1
Monthly active users
a day ago
Last modified
Security
Limited permissionsShare
Official fails-to-deliver data published by the U.S. Securities and Exchange Commission: the aggregate number of shares that failed to settle in the NSCC Continuous Net Settlement system, per security and settlement date.
What you get
One row per security per settlement date:
settlementDate, symbol, cusip, description, quantityFails, price (prior-day close as published), valueUsd (shares x price), sourceFile.
Inputs
- symbols / cusips: limit to specific securities.
- latestOnly: just the newest half-month file (default when no dates are given).
- dateFrom / dateTo: settlement-date range (up to two years per run).
- minQuantity / minValueUsd: drop small fails.
- sort: newest date, most shares, or largest dollar value.
- maxItems: up to 100,000 rows.
Notes
- The SEC publishes two files a month (1st-15th and 16th-end), roughly two weeks after the period ends.
- Figures are the outstanding fail balance on that date, not new fails; a balance can carry over several days.
- Fails can result from either long or short sales; they are not a direct measure of naked short selling.
Example
