Annual compustat industrial files

Choose different or additional keysets and click the Select button to close the window. Compustat data items can be qualified by a set of secondary keys. For example, the data item SALE has secondary keys for industry format, data format, population source, and consolidation level. A different value of company sales can be available for different combinations of these keys, such as a combination that represents the originally reported sales or the final restated sales from a later filing.

CRSP calls these collections of keys and values a keyset and assigns a numeric code and mnemonic tag to each unique collection. Each of these represents different output series.

When multiple keysets are available the user can specify both the item and keyset to identify the series of interest, or use the default preset combination most commonly used.

The following examples illustrate these options using Microsoft Excel output. Reference code data can be used in two ways: to return a list of unknown codes, or to find the meaning of a specific code. Reference Numbers are numeric codes assigned to Compustat data.

Like Reference Codes, Reference Number data can be used in two ways: to return a list of unknown numeric codes, or to find the meaning of a specific numeric code. If you find that you commonly use a certain subset of items, at any time, you may highlight them and click the Add to Favorites button. Favorites is a user-created category designed to house these commonly accessed data items. To control the order in which your report will display data items, use the up and down arrows to the right of the Query Items list.

Click an item and then click the up or down arrow to reorganize the list. To remove an item or group of items, select them from the list and click the X button, located above the arrow buttons.

Select Global Item Options to include Footnotes or Data Code items for those items that have them, and to change the default from providing output in its Reported Currency to converting it to US Dollars. Selected items appear in the Screen. Note: Global options must be set prior to selecting data items in order for them to be applied.

Instead of choosing data items using the item selection screen, you can import a set of data items from a text file. Groups provide a convenient way to select multiple related data items at once.

For example, there are five items related to Filing Dates data. These items are found under the Filing Dates sub-category of the Additional Descriptions category in the data items selection screen. There you can add each of the five items to your query, one by one. That method is best if you want to modify properties such as keyset or output header of some but not all items.

Alternatively, you could add all five items at once by selecting Filing Dates under the Groups tab. This is an efficient way of selecting multiple items if you intend to apply the same properties to all items in the group.

The default option is text-based, formatted to fit the screen width specified in the Width control. Screen output appears in the hopper at the bottom of the CCMQuery window. By default, the output of the last query execution is shown in the Current tab. The Save Output and Clear Output buttons at the top of the output area allow you to save output to a text file or to clear it away. Clicking the History tab shows you the output of every query execution since the session was opened.

When you switch to the query history view, the buttons above the output area change to Save History and Clear History. Save History allows you to capture the output of an entire session. Each time you click Execute the new output is saved in the history. Then, by clicking Save History, you can save all the output to one text file. You can also save data in a number of external file formats. When you choose a non-screen format, the Output File Name field becomes active and is required.

This option generates a single output file. Note: Excel version 8 has a row limit of total rows. It is a bit old, but can tell you about all of the items available on this site. Click here for a short page-view of how to download from Compustat. To download the data, follow the instructions on the website.

You will need to ask for specific companies, using their tickers, although you can ask for many companies at once. A Pardee Library librarian can help you if you are having trouble with Compustat.

They have a compustat terminal there as well, but it is not easy to download data from that termina. QM This website also gives you lots of stock market data as well CRSP. The data set must be downloaded.