Basic information on financial databases: cook books, tips and tricks & economic news

This blog contains schematic easy to grasp - hands on - help in performing searches in economic databases, making work sets and making them inter-exchangeable between the databases.

* Disclaimer. I am not a finance professional. Most posts are the result of personal findings.

All presented images are scaled and can be enlarged to original size (click the picture).

Search This Blog


Board information - Compustat / Execucomp

Not all databases provide information on executive boards, governance or any other relevant board information.This post will seek to provide an overview of some databases that do.

Compustat / Execucomp (WRDS databases)
Compustat North America has got a sub database called Execucomp (executive compensations). Its main aim is to provide information on remunerations, pensions, awards etc. for executives from American companies.
Compustat Global does unfortunately not have such a database.

The data can be very specific and detailed. Understanding of executive compensations might be of great help. I'll stick to Annual compensations (which are things like salary and bonusses etc.)
Unless you upload a file you have to look up companies manually. Comopany Identifiers used in execucomp are most often GVKEY, Ticker, CUSIP, SIC (industries)  (there may be vatiations) and an id identifying the executive ??

Example: Annual Compensation

Getting meta data on the executives (not the remunerations)

Step 1
First set your desired Time window in Step 1.
This specific database deals with annual data, hence the data options.

Step 2
You can manually look for companies or upload lists of

 * * * * Uploading a list  * * * *
When working with a workset within WRDS the most commonly used identifier will be the GVKEY.

Use this link and another menu opens with a Browse button (bladeren)
Click this and an expplorer screens opens where you can select your file.
Note: be certain to store your identifier in a single file as the system doesn't recognise composed files.
The format has to be a TXT file.
Select your file.
 * * *

Select the radio box GVKEY in STEP 2 (GVKEY)

Press "Contains" this way you are save from exact phrases / search terms

Select e.g. GVKey codes and > Add to list (this implies you can search for more than one company at a time)

Press button add codes to querry (brings back to th general menu)

Step 3: Selecting variables
First section : general company info (name, location etc)
Second section: executive information

(meta data ececutives)
Dowload output: recommended is saving as as TXT file (eithjer fixed width or tab delimited)
Save with right click on the TXT link

Opening in Excel calls up a wizard.

Continue untill this screen. Scroll all the way to the right and Shift-click to select all columns. Confirm the text file with the radio button text (top left of the wizard)


The meta data can basically be downloaded from any section in Execucomp.
Finacial data can be downloaded for a stretch of years, and Execucomp  provides much information.

---------------  ------------------- --------------- ------------- ----------------- ------------------ ---------

But there are other board structures and functions.
Think of auditors and various committees.

More databases offering board information

Database Asset4

In Lexis/ Nexis (News)

In Audit analytics

In Bureau van Dijk databases (Amadeus, Bankscope, REACH)

No comments:

Post a Comment