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.

Every stock database contains four files:

cheadfile.dat

Header list, one line per issue, sorted by PERMNO, with the fields PERMNO, PERMCO, CUSIP - Header, Company Name - Header, Ticker Symbol - Header, CRSP Exchange Code - Header, and price data range. (Note: SIC Code - Header may be included in a user-created header file using the crsp_stk_headall utility.

headfile.dat

Historical header list, one line per historical name, sorted by PERMNO and effective name date, with the fields PERMNO, PERMCO, CUSIP, Company Name, Ticker, CRSP Exchange Code, and effective range of name information. (Note: SIC Code - Header may be included in a user-created header file using the crsp_stk_headall utility.

psortbyp.dat

A PERMNO list of issues in the database; one PERMNO per line sorted by PERMNO.

headind.dat

An index description, setid, and INDNO of all index series and groups in the database.

CRSP provides the following search utilities for header files.

A. dstksearch To search the daily data header files
B. mstksearch To search the monthly data header files
C. dindsearch To search the daily index header files
D. mindsearch To search the monthly index header files
E. cst_search To search the CRSP\Compustat Merged Database (CCM) current and historical header files
F. ncst_search To search the CRSP\Compustat Merged Database (CCM) current and historical header files
G. crsp_show_db_info To display parameters associated with a specific database
H. crsp_set_db_info To change parameters associated with a specific database