CRSPAccess Utilities for Linux and Sun Solaris Platforms

CRSPAccess Utilities for Linux and Sun Solaris Platforms

The CRSPAccess software, also known as CUPL, CRSP Utilities and Programming Libraries, includes utilities that may be used to extract CRSP stock and index data from the CRSP proprietary databases on Linux and Solaris platforms. They also include C and Fortran-95 programming libraries.

The CRSPAccess utilities and programming files may be used to access the CRSP US 1925 and 1962 Stock and Stock with Index Databases, and the CRSP/Compustat Merged Database.

Note: Subscriptions to a CRSP US Stock or Stock with Index database and the requisite Compustat data files are necessary for users to be eligible to subscribe to the CRSP/ Compustat Merged Database.

The CRSPAccess software is made up of a number of tools used to accomplish four major categories of tasks: creating reports, searches and database inquiries, creating subsets, and moving databases and files across machine types.

I. Reporting Tools

The reporting tools can extract time-series output, stock event data, and decile-level index data.

Data are accessed from the reporting tools through identifier keys. The primary identifier key, and the one the CRSP recommends for the CRSP Stock databases, is PERMNO, CRSP permanent security level identifier. Other identifier keys that may be used include PERMCO, CRSP’s company level identifier, current and historical CUSIPs, Tickers, and SIC codes. INDNO, CRSP’s index identifier, is used to access index data through ts_print and ind_print.

ts_print To extract time-series data over fixed or relative date ranges.
stk_print To extract event histories including name and identifier changes, delisting information, and distributions, as well as time series data extractions.
ind_print To extract index and decile-level returns, levels, counts, and weights data.
ccm_print To extract link data between CRSP and Compustat company and security level identifiers as well as Compustat company, security, and index fundamental time series, segment, and reference data from database created from the Compustat Xpressfeed files.

II. Search and Inquiry Tools

CRSP provides header files for each CRSPAccess database. These name lists are useful for finding identifiers and name histories of securities when only partial information is known. The identifiers can then be used as input to other CRSP reporting utilities or programs. The files are fixed format text files and be accessed with system utilities or other tools. CRSP provides search utilities for header files.

dstksearch To search the daily data header files
mstksearch To search the monthly data header files
dindsearch To search the daily index header files
mindsearch To search the monthly index header files
crsp_show_db_info To display parameters associated with a specific database
crsp_set_db_info To change parameters associated with a specific database

III. Subsetting Tools

These utilities can be used to create copies of CRSP databases, restricted for example on the basis of exchange and share codes, or a select group of PERMNOs.

stk_partial Creates a stock database from an existing one or to append securities from one existing database to another.
ind_partial Creates an index database from an existing one or to append indexes from one existing database to another.
crsp_stk_subset Creates a stock database from an existing one by subsetting data.
crsp_ind_subset Creates an index database from an existing one by subsetting data

IV. Moving Database and Data File Tools

rewrite_crspdb Copies a CRSPAccess database to a new directory or converts data from one binary type to another
crsp_stk_scd_load Creates secondary indexes or keys for a database
crsp_stk_headall Creates a header file with user-specified options
crsp_ind_headall Creates a header file for an index database, used primarily for a subset database
crsp_crlf2lf Removes carriage returns
crsp_lf2crlf Adds carriage returns
crsp_cutc Select columns from fixed-width text files can be written to an output file.