Step 1: Choose your date range.
Step 2: Apply your company codes.

Select an option for entering company codes.

Please enter Company codes separated by a space.
Example: IBM MSFT AAPL [ Code Lookup ]
Save code list to Saved Codes
Upload a plain text file (.txt), having one code per line.
Choose from your saved codelists.
Search the entire database.
This method allows you to search the entire database of records. Please be aware that this method can take a very long time to run because it is dependent upon the size of the database.

Screening Variables

Several screening variables are pre-selected to produce one record per GVKEY-DATADATE pair, while keeping the vast majority of records. Examples of excluded rows include those with restated data, different views of the same data (pro forma, pre-FASB). Click on each variable for a more detailed explanation.

Consolidation Level
Industry Format
Data Format
Population Source
Company Status

Conditional Statements (Optional)

How does this work?

Step 3: Query Variables.

Select Variable Types

Select the items you would like to include in your search.

Selected 1

Select 2

How does this work?

Selected 0


Select 7

Select 34

Select 25

Select 382

Select 328