Board composition of listed companies

Hello,

Is there a way for me to retrieve the list of all officiers in a company and each of their committee membership using the Codebook environment? I have raised this issue earlier, as it is possible to see a person being a member of different committees in the screener, but in the codebook we see only one committee per person. To give an example, I check company with RIC 3257.TW, Mr. Tao Lin Chang is member of 3 committees, (CSR Responsibility, Audit, Compensation) whereas with API it is only possible to see Audit committee. I use the following code to retrieve the data:

import refinitiv.data as rd

rd.open_session()

df = rd.get_data(

universe=['3257.TW'],

fields=[

'TR.ISIN',

'TR.CompanyName',

'TR.ODOfficerCommitteeName(odrnk=all, odshowAllCommittees=True)',

'TR.ODOfficerPermID(ODRnk=ALL)'

]

)

Which gives following result:

The help desk provided the below screenshots, showing the actual committee membership, but they could not provide the code that would produce this output:

Could you please help me to retrieve this information correctly with the codebook? Thank you very much.

Find more posts tagged with

python

codebook

#technology

Accepted answers

All comments

raksina.samasiri

Hi @Nuglug ,

Can you try this? I've grouped parameters into one param to apply it to all the fields in this request and add Person Perm ID (which I get the field name from Code Creator application)

ld.get_data(

    universe=['3257.TW'],

    fields=[

        'TR.ISIN',

        'TR.CompanyName',

        'TR.ODOfficerCommitteeName',

        'TR.ODOfficerPermID',

        'TR.ODPersonPermID'],

    parameters={'ODRnk':'ALL', 'odshowAllCommittees':'True'}

)

Nuglug

Hi @raksina.samasiri ,

Thank you for this response. However, this does not answer my question. The output you provided is exactly the same as the one I provided. You would see in line 8, the observation with officier permid 99608255753, should normally show 3 committees. That is what I am trying to retrieve with the API.

I just added the officer name into the code you provided for convenience:

import refinitiv.data as rd
rd.open_session()

rd.get_data(

universe=['3257.TW'],

fields=[

    'TR.ISIN',

    'TR.CompanyName',

    'TR.Odofficerfullname',

    'TR.ODOfficerCommitteeName',

    'TR.ODOfficerPermID',

    'TR.ODPersonPermID'],

parameters={'ODRnk':'ALL', 'odshowAllCommittees':'True'}

)

And the output is the following:

If you look at the information for Mr. Wen-Hsiung Chan (8th row, officier permid 99608255753), he is a member of 3 committees:

I would like to have 3 rows for Mr. Wen-Hsiung Chan, showing 1 committee each, like the solution provided by helpdesk (without being able to provide the code that produces it) like below:

Thank you very much.

Jirapongse

@Nuglug

You need to use the fundamental_and_reference class with the extended_params to format the output. The code looks like this.

resp2 = fundamental_and_reference.Definition(
    universe=['3257.TW'],
    fields=['TR.ODOfficerCommitteeName(ODRnk=All,odshowAllCommittees=True)'],
    extended_params = {"layout":{"rows": [
                            { "item": "PersonID" },{"item":"OfficerID"}],
                       "columns": [
                            { "item": "dataitem" }
                        ]}}).get_data()

resp2.data.df