CRSP Demo

Step 1: What date range do you want to use?

I would like data from to

Step 2: How would you like to search this dataset?

What format are your company codes?

TICKER
PERMNO
PERMCO
CUSIP
NCUSIP
HSICCD
SICCD

How does this work?

Manually enter Company code

Company Code

Please enter Company codes separated by a space.

Example: IBM MSFT DELL

Save selected code list to myWRDS
Upload file containing Company codes

Choose a file to upload
Retrieve saved codes from myWRDS

Choose from your saved codelists
Search entire database

Conditional Statements (Optional)

How does this work?

AND OR

Step 3: What variables do you want in your query?

How does this work?

Identifying Information

Select the items you would like to include in your search. For more information on each code, use the corresponding help link.

Cusip Help

Ncusip Help

Company Name Help

Ticker Help

CRSP Permanent Company Number Help

Share Code Help

Share Class Help

Nasdaq Issue Number Help

Exchange Code Help

Header Exchange Code Help

SIC Code Help

Header SIC Code Help

Header SIC Major Group Help

Header SIC Industry Group Help

Names Ending Date Help

Trading Symbol Help

North American Industry Class System Help

Primary Exchange Help

Trading Status Help

Security Status Help

Time Series Information

Select the items you would like to include in your search. For more information on each code, use the corresponding help link.

Price Help

Price Alternate Help

Price Alternate Date Help

Ask or High Help

Bid or Low Help

Closing Bid Help

Closing Ask Help

Share Volume Help

Holding Period Return Help

Spread Between Bid and Ask Help

Holding Period Return without Dividends Help

Share Information

Select the items you would like to include in your search. For more information on each code, use the corresponding help link.

Number of Shares Outstanding Help

Shares Observation End Date Help

Share Flag Help

Delisting Information

Select the items you would like to include in your search. For more information on each code, use the corresponding help link.

Delisting Code Help

New CRSP Permno Help

Date of Next Available Information Help

Amount After Delisting Help

Delisting Price Help

Date of Delisting Payment Help

Delisting Return Help

Delisting Return without Dividends Help

Distribution Information

Select the items you would like to include in your search. For more information on each code, use the corresponding help link.

Distribution Code Help

Dividend Cash Amount Help

Factor to Adjust Price Help

Factor to Adjust Shares Help

Cumulative Factor to Adjust Price Help

Cumulative Factor to Adjust Shares Help

Declaration Date Help

Record Date Help

Payment Date Help

Acquiring PERMNO Help

Acquiring PERMCO Help

Nasdaq Information

Select the items you would like to include in your search. For more information on each code, use the corresponding help link.

Traits Code Help

National Market Indicator Help

Market Maker Count Help

NASD Index Help

Market Information (NYSE/AMEX/Nasdaq)

Select the items you would like to include in your search. For more information on each code, use the corresponding help link.

Value-Weighted Return (includes distributions) Help

Value-Weighted Return (excluding dividends) Help

Equal-Weighted Return (includes distributions) Help

Equal-Weighted Return (excluding dividends) Help

Return on S&P Composite Index Help

Step 4: How would you like the query output?

Select desired format of the output file. For large data requests, select a compression type to expedite downloads. If you enter your email address, you will receive an email that contains a URL to the output file when the data request is finished processing.

Output format: fixed-width text (*.txt); comma-delimited text (*.csv); tab-delimited text (*.txt); dBase file (*.dbf); SAS Windows_32 dataset (*.sas7bdat); SAS Solaris_64 dataset (*.sas7bdat); SAS transport file (*.trp) (PROC CPORT); SAS transport file (*.xpt) (PROC COPY); HTML table (*.htm); STATA file (*.dta); SPSS file (*.sav)

Compression Type: None; zip (*.zip); G zip (*.gz); standard UNIX (*.Z)

Date Format: YYMMDDn8. (e.g. 19840725); DATE9. (e.g. 25JUL1984); DDMMYY6. (e.g. 250784); MMDDYY10. (e.g. 07/25/1984); DDMMYY10. (e.g. 25/07/1984); YYMMDDs10. (e.g. 1984/07/25)

E-Mail Address (Optional)

Save this query to myWRDS

CRSP Demo - Monthly Stock

Step 1: What date range do you want to use?

Step 2: How would you like to search this dataset?

What format are your company codes?

Conditional Statements (Optional)

Step 3: What variables do you want in your query?

Identifying Information

Time Series Information

Share Information

Delisting Information

Distribution Information

Nasdaq Information

Market Information (NYSE/AMEX/Nasdaq)

Step 4: How would you like the query output?

WRDS Demo

Demo Datasets

Contact WRDS

Sign In to WRDS