FAQ: Where can I find the board size?

Board size is not available as a variable in WRDS databases (you can find it in Datastream – it’s an item from Asset4 (Mnemonic CGBSDP060)).

This means that when you use for example RiskMetrics, you have to calculate the board size, by counting the board members.

You can do this in Excel by making a new variable, by combining the year and an identifier of the company for each person in your data set (for example taken from RiskMetrics). Then you can count how often that combination of year and company exists in the dataset, using the countif-function in Excel. This will give you the size of the board.

We have created a new column with a combination of the year and the cusip of the company (function: Concatenate), then we used the function Countif to count the number of times a certain combination appears in that new column.

Of course this only works when you haven’t used any conditional statements to select or delete specific board members!


2 thoughts on “FAQ: Where can I find the board size?

    • Thanks for the tip. I will adjust the post. We get this question from students who are downloading data from for example RiskMetrics and there is no easy link between Datastream and RiskMetrics.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s