DEV Community

NexGenData
NexGenData

Posted on • Originally published at thenextgennexus.com

New: SEC Fails-to-Deliver Tracker — Short Squeeze Data — official SEC fails-to-deliver data as queryable JSON

What it does

This actor turns the SEC's official bi-monthly Fails-to-Deliver (FTD) files into a clean, queryable JSON feed. The SEC ships FTD as a pipe-delimited fixed-format dump with no API, no ticker index, and a quirky half-month naming convention — so normally you download the whole-market file and write a parser every two weeks. This actor does that for you: filter by ticker, CUSIP, minimum fails quantity, or file period and get back clean rows, pay-per-record.

Who it's for

Short-squeeze and momentum traders, market-microstructure researchers, quant desks, and anyone tracking settlement fails as an official, free signal without a Bloomberg terminal or Ortex seat.

Sample fields / output

  • settlementDate
  • quantityFails — fails quantity
  • cusip
  • symbol
  • price

Example use cases

  • Track FTD spikes on a watchlist ticker to flag potential short-squeeze setups.
  • Filter the whole-market file to fails above a threshold to surface market-wide settlement stress.
  • Build a bi-weekly FTD time series per symbol for microstructure research.

▶ Run SEC Fails-to-Deliver Tracker — Short Squeeze Data on Apify →

Related actors

FAQ

How current is the data?

It reflects the SEC's bi-monthly FTD release schedule — the regulator publishes settlement fails roughly twice a month.

Is the data official?

Yes. It comes directly from the SEC's published Fails-to-Deliver files, not a third-party estimate.

Can I filter to a single ticker?

Yes. Filter by symbol, CUSIP, minimum fails quantity, or file period and get back only the rows you need.

Top comments (0)