Skip to Main Content

Frequently Requested FOIA Document: Fails-to-Deliver Data

Education/Help/Guides/FAQs
 
 

Frequently Requested FOIA Document: Fails-to-Deliver Data


What You Should Know About the Data

This text file contains the date, CUSIP numbers, ticker symbols, issuer name, price, and total number of fails-to-deliver (i.e., the balance level outstanding) recorded in the National Securities Clearing Corporation's ("NSCC") Continuous Net Settlement (CNS) system aggregated over all NSCC members. Data prior to September 16, 2008 include only securities with a balance of total fails-to-deliver of at least 10,000 shares as of a particular settlement date. Data on or after September 16, 2008 include all securities with a balance of total fails-to-deliver as of a particular settlement date. The data include fails-to-deliver in equity securities.

The values of total fails-to-deliver shares represent the aggregate net balance of shares that failed to be delivered as of a particular settlement date. If the aggregate net balance of shares that failed to be delivered is less than 10,000 as of a particular settlement date prior to September 16, 2008, then no record will be present in the file for that date even if there are fails in that security. If the aggregate net balance of shares that failed to be delivered is zero as of a particular settlement date on or after September 16, 2008, then no record will be present in the file for that date. Fails to deliver on a given day are a cumulative number of all fails outstanding until that day, plus new fails that occur that day, less fails that settle that day. The figure is not a daily amount of fails, but a combined figure that includes both new fails on the reporting day as well as existing fails. In other words, these numbers reflect aggregate fails as of a specific point in time, and may have little or no relationship to yesterday's aggregate fails. Thus, it is important to note that the age of fails cannot be determined by looking at these numbers. In addition, the underlying source(s) of the fails-to-deliver shares is not necessarily the same as the underlying source(s) of the fails-to-deliver shares reported the day prior or the day after.

Data Prior to July 2009

Prior to July 2009, the files contain each settlement date over a calendar month. The monthly files are archived in a zipped file for each calendar quarter. We cannot guarantee the accuracy of the data.

Data Starting July 2009

Starting July 2009, each month is contained in two files. The first half of a given month is available at the end of the month. The second half of a given month is available at about the 15th of the next month. We cannot guarantee that the data will be posted by a particular date. We cannot guarantee the accuracy of the data.

The price field includes the closing price of the security on the previous day as long as the price is available and is greater than one penny. When the price is not available or is less than a penny, the field is filled with a “.”. Even when prices are included in the data, we cannot guarantee that this price matches closing prices available from other sources.

Please note that fails-to-deliver can occur for a number of reasons on both long and short sales. Therefore, fails-to-deliver are not necessarily the result of short selling, and are not evidence of abusive short selling or “naked” short selling. For more information on short selling and fails-to-deliver, see http://www.sec.gov/spotlight/keyregshoissues.htm, http://www.sec.gov/divisions/marketreg/mrfaqregsho1204.htm, and http://www.sec.gov/rules/final/34-50103.htm.

What You Should Know About the Data File

The information in this file is raw data — data that are meant to be used as input to another program. The data items are provided as a "pipe delimited" text file. Although the file can be viewed in any program that accepts ASCII text (for example, a word processor), the data fields are best viewed when imported into a program that accepts delimited data, such as a spreadsheet or a statistical application. The record layout and maximum field sizes are shown below for those who want to process the data into another form.

Field Name Field Description Maximum Size
SETTLEMENT DATE SETTLEMENT DATE Number - 8 digits
CUSIP CUSIP 9 characters
SYMBOL TICKER SYMBOL 10 characters
QUANTITY (FAILS) TOTAL FAILURE-TO-DELIVER SHARES Number - unlimited
DESCRIPTION COMPANY NAME 30 characters
PRICE CLOSING PRICE ON PREVIOUS DAY Number - unlimited

For technical questions regarding the website, send an e-mail message to webmaster@sec.gov. For additional information about the data, call the SEC's Office of Freedom of Information and Privacy Act Operations at (202) 551-7900.

Current Data

Download the Current Fails-to-Deliver Data
Report for the second half of July 2014

Archive Data