Stanford University GSB financial research databases

• Financial data files at Stanford University
  • CRSP data
  • Compustat data
  • I/B/E/S and Zacks earnings forecast data
  • Financial data available via the Windows95 interface on the GSB-net includes: American Business Disc; Books in Print Plus; Business Date Line; Compact Disclosure; Companies International; Compustat & Global Vantage; Computer Select; Corporate Affiliations Plus; County & City Compendium; CRB Infotech; Disclosure Worldscope; F&S Index; Folio; HBS Publishing Index; Industry Review; International Financial Statistics; InvesText (analyst reports); Morningstar Mutual Funds; National Trade Data Bank; Serials Directory; Sheshunoff Bank Data; Wall St. Journal Ondisc.
• Tips on dealing with huge files
• SAS program access to the financial databases
  • Note on SAS version 6.09 on crown/birr vs. SAS 6.11 on leland
  • Notes on SAS programs to access CRSP data
  • Notes on SAS programs to access Compustat data
• Fortran programs to read Compustat and CRSP data
• On references and getting help
• About this webpage

        What changes in 1995 files?
                Compustat:  
                        we now have "complete" rather than "limited" files
                        Compustat added 20 vars to out dataset; some to outby
                                what are these new variables
                        
                CRSP:
                        we now have combined NYSE/AMEX/NASDAQ rather than
                                separate NYSE/AMEX vs. NASDAQ
                        1995 CRSP data is not readable from SAS 6.09

Most users will find it most convenient to access the data through SAS programs, although Fortran still has some advantages.

[NOTICE 8/98: THE CONVENIENT WEB LOOKUP OF PERMNOS HAS BEEN REMOVED DUE TO OFFICIAL CRSP REQUEST. Although it obviously makes CRSP data more valuable if it is more easily matched to other data sources, the Center for Research in Security Prices apparently seeks to protect a copyright(?) or something on the PERMNOs that is endangered by open display of permno-to-cusip correspondence, etc. It would be okay to have this feature on a password-protected webpage, apparently. doncram 8/98] Look up CUSIP or PERMNO from 1995 CRSP stock data arranged [DISABLED]:

• in COMPANY NAME field alphabetical order
• in CUSIP order
• in PERMNO order
• in TICKER order

Apparently, the prim-supp-tert.annual is the complete industrial annual file of NYSE/AMEX companies which replaces the more limited version GSB purchased in 1994. The full_coverage.annual file covers industrials listed in the NASDAQ and regional exchanges and more. The merged_industrial.annual file is the corresponding ``Industrial Research'' file as described in the Compustat manual (Chapter 1 page 1 dated 6/94 v25) (Note this page of the Compustat manual is unchanged from 1994 to 1995 versions. Note that other pages were added or replaced by new page inserts, e.g. Chapter 5-Data Definitions page 257 dated 3/95 v25). It contains companies which have been deleted from the Primary-Supplementary-Tertiary and Full Coverage files due to bankruptcy, mergers, etc.

The canadian\_us\_industrial file is apparently the U.S. dollar-denominated version of Compustat's Canadian file, which covers major Canadian firms.

The aggregate file has information summed for 275 industry groupings, including the S\&P 500 and other S\&P and Dow Jones indices.

The bank and business information files are not readable by SAS PROC DATASOURCE.

The 1994 limited subscription data remains available for GSB researchers on gsb-crown and gsb-birr.

In addition, Jackson library has the Compustat Compact Disclosure data on CD-ROM. This is a menu-driven, friendly interface that has well served many researchers as well as general business students.

See Ellen Engel's handout entitled "Collecting data from the Compustat PC Plus CD-ROM database", which she wrote for a presentation for accounting students given 2/11/94. She also provided sample programs for accessing Compustat tape data on Lira. The CD-Rom version is available through Jackson Library via the MBA network. She recommends using the CD-Rom version for screening companies of interest (say, all companies which experienced net losses for three years running during 1980-1992). For Bank data, and for downloading some complex or large sets of data from the Industrial database, you use Fortran programs. Ellen's sample programs, in Fortran, were available on Lira in:

	userdisks:[resources.routines]compustat.demo

The format he recommends is like the following:

		conm y1 sal at pccf ...
		conm y2 sal at pccf ...
		conm y3 sal at pccf ...

	infile filename lrecl=330 missover;
	input conm91 $ @34 sal91 at91 pccf91 ...;
	input conm92 $ @34 sal92 at92 pccf92 ...;
	company = conm92;
	drop conm91 conm92;

/afs/ir/data/gsb/ibes/DETAIL
/afs/ir/data/gsb/ibes/SUMMARY

There is a current, printed version of IBES monthly summary information such as mean, median, low, high forecasts by analysts of earnings for next two fiscal years for each firm (following is from Socrates):

I/B/E/S MONTHLY SUMMARY DATA (New York, N.Y. : Lynch, Jones & Ryan)
       LOCATION: Jackson Business Periodicals (Library has NOV. 15, 1984- 
                   (INCOMPL.) (LATEST ISSUE: REFERENCE TABLE A-1; PREVIOUS 11 
                   YEARS: PERIODICAL STACKS; PRIOR YEARS IN THIRD FLOOR 
                   STACKS))

There is an equivalent(?) earnings forecast database called Zacks, to which Stanford does not subscribe(?), except in printed form: see the

ZACKS EARNINGS FORECASTER (Chicago, Ill. : Zacks Investment Research, 
       1987-). Apr. 17, 1987-
       LOCATION: Jackson Business Periodicals (Library has Apr. 17, 1987- 
                   (PERIODICAL STACKS; LATEST ISSUE: REFERENCE TABLE A-1))

                                options obs=100
                                options nonotes
                                qprint,qprintn,qaprint small printouts

        %crspmer(indata,drets,begdate,enddate,outdata);