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. 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.
Subscription Information
CRSPAccess Utilities for Linux
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. 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.
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.
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.
IV. Moving Database and Data File Tools