Category: Datasets

Explanation

This dataset holds 16,330,443 SEC filings for 593,451 unique CIKs over 1993-2016. Columns include company name (coname), form type (formtype), central index key (cik), the url of the full filing (filename) and filing date (date). Note that the cik is the historic cik at time of the filing, not the current cik.

This dataset is a merge of the master index files that are freely available on SEC's website. For example, ftp://ftp.sec.gov/edgar/full-index/2012/QTR4/company.idx

A zipfile (237 MB) can be downloaded here. The file is in SAS format, unzipped about 2.2 GB. To use it with other software, consider converting it with Stata Transfer.

The url in the dataset (field: filename) is not the full url. It needs to be prepended by: http:\\www.sec.gov\Archives\

Usage

Extract the zip to a (new) directory (for example: C:\libraries\edgar) and create a library reference to this directory (libname edgar "c:\libraries\edgar\"). After this point, you can use the dataset in SAS by referring to it (edgar.filings).

This table can be used to download the filings to your hard drive for further investigation. Also, it makes it easier to identify observations with confounding events. For example, when doing an event study it is easy to exclude firms that filed a form 8-K (material event) in the dates around the event date.

Other Datasets
No related posts

forum

Latest forum posts
Fama French 49 YES 49 !!! by CA Miller
date format by Emily
Discretionary Accruals by jwhi121
question about discretionary accrual models by kerrida
Combining Global and North American data by CA Miller
File for Eventus or SAS Event Study by samme
quarterly accruals by lxt88
Financial Statement Comparability - De Franco, Kothari and Verdi (2011, JAR) Replication by rowing
question about discretionary accrual models by Zenghui
problem in perl by KZ

All rights reserved. © 2010-2014 wrds.us [Copyright] [Privacy Statement] [Disclaimer] [About]