Aalto Finance Databases from your labtop: Wharton Research Data Services and Capital IQ

WRDS is the place to go in case you want to work on from home. The way this works, is that you click the link and register as a Aalto user. After registration you will have to wait for approval. Once approved, you can access the data.  

Importantly, as time passes by, your access will get old. Please, do remember to renew your registration.

WRDS is an research platform that contains access to several databases, the most important ones being Compustat and CRSP. Compustat contain US company information such as income statements and balance sheets. CRSP contains US security prices.

WRDS is an umbrella or platform that actually contains several databases

To gain access to WRDS you need to do the registration. The picture below shows you how this is done.

Aalto Finance databases include WRDS, first you need to register

Once you have registered you need to learn the basics on how to use the database. This video should be helpful in getting started.

In many cases there is a need to combine data from both CRSP and Compustat. In this case common tickers should not be used. The reason for this is that one company may use several tickers in different time periods. Also, tickers are recycled, and same ticker may actually refer to two totally different companies.

Tickers should not be used to combine different data sets

Instead of tickers use this merger list. With the help of this list, you will be able to combine the identifiers from Compustat with the ones from CRSP.

Capital IQ

Also Capital IQ can be accessed from labtop. Department of Finance students and staff can access Capital IQ

Capital IQ is used to complement SDC-platinum data (available from room Q301) on research in private equity, mergers and acquisitions and leveraged buyouts. For these kind of themes, you should also check Orbis and Zephyr. These are available from Aalto University computers from here.

Here is a short video on how to use Capital IQ.

For longer training video for Capital IQ, please click this link. There is a text explaining “no content available”, but simply click play and the video will work.