Retrieving Company Board Members from Bloomberg Data
Summary
The document describes how to retrieve a company’s board or executive-officer list from Bloomberg, as a first step toward analyzing individuals systematically. It gives an Excel approach using a Bloomberg data field for company executive officers and outlines a Python alternative through Bloomberg’s API.
The Python example uses a wrapper to request the same data and return it as a pandas dataframe. The answer notes that API access depends on having Bloomberg Terminal software and an active login, and that the API must be installed. The material offers a practical starting point for extracting company-level personnel data, but it does not explain how to obtain further personal details, validate the returned roster, or handle coverage differences across securities and companies.
Key ideas
- Bloomberg Excel can retrieve a company’s executive-officer list through a data request.
- Bloomberg’s Python API can request the same company personnel data.
- A Python wrapper can simplify API calls and return the results in a dataframe.
- The described API method requires Bloomberg software and an authenticated Terminal session.
- The document does not show how to retrieve individual-level records beyond the initial list.
Tags
Full text
# How to retrieve list of names of board members for a given ticker from Bloomberg Professional
# How to retrieve list of names of board members for a given ticker from Bloomberg Professional
I would like to investigate some data on individual board members in a systematic way. I have a Bloomberg Terminal at my disposal, which I would like to use for this. In a first step, I need to retrieve a list of all board members for a given company ticker. In a second step, I would then want to retrieve personal-level data for each individual.
Some pointers regarding both steps would be much appreciated. This seems to be a rather specific use case, so I haven't been able to find anything on this online.
## Answer by Steven S. (score 1)
https://quant.stackexchange.com/a/52908
For the Excel case, you can use `=BDS("AAPL US Equity","COMPANY_EXEC_OFFICERS")`.
Trying to figure out the Python way to do it, so consider this a bump.
## Answer by David Duarte (score 1)
https://quant.stackexchange.com/a/52912
You can install and use the Bloolmberg api in python quite easily. Apart from the Bloomberg terminal software you will have to install the bloomberg api.
Then you can either use the api directly in python by importing it, or, because the api is not so easy to use directly and its kind of verbose, you can use one of the various open source wrappers available of github.
NOTE: this will only work if you are logged in to a the bloomberg terminal so no use trying this if you don't have a login.
Here is an example with `pybbg`:
```
import pybbg
bbg = pybbg.Pybbg()
bbg.bds("AAPL US Equity","COMPANY_EXEC_OFFICERS")
```
With return a pandas dataframe with the data you requested.Shown in full with attribution under the source's licence. Licence: CC BY-SA 4.0 (Stack Exchange)
This summary was written by Stratmill's research agent from the original; it is not a copy of the source.