Officer and Director data

DSA_ISDS

Am I able to pull the 5-year history of Officers and Directors (more specifically CEOs/CFOs) of a company (e.g. Rogers Communications, RCIb.TO) via API? Specifically, I would like to retrieve all the CEOs/CFOs that's been at a company within the last five years. I am currently use the following code to retrieve the Officers and Directors but am unsure if this only reflects the current Officers and Directors of the company.

pbl, err = ek.get_data(instruments=[screener],
fields= ['TR.CUSIP',
'TR.CommonName',
'TR.ICBIndustry',
'TR.ExchangeCountry',
'TR.ShortExchangeName',
'TR.RegistrationCountry',
'TR.RegStateProvince',
'TR.CompanyMarketCapitalization',
'TR.OfficerName(RNK=R1:R50)',
'TR.OfficerRank(RNK=R1:R50)',
'TR.ODOfficerPersonGender(ODRNK=R1:R50)',
'TR.OfficerAge(RNK=R1:R50)',
'TR.OfficerTitle(RNK=R1:R50)',
'TR.OfficerTitleSince(RNK=R1:R50)',
'TR.ODOfficerCompSalary(ODRnk=R1:R50)',
'TR.ODOfficerCompFYDTotalComp(ODRnk=R1:R50,Curn=CAD)'
])

Jirapongse

@DSA_ISDS

Thank you for reaching out to us.

Eikon Data API is outdated. Please use the LSEG Data Library for Python instead. Please refer to this Essential Guide to the Data Libraries - Generations of Python library (EDAPI, RDP, RD, LD) article.

The code looks like this:

import lseg.data as ld
ld.open_session()

df = ld.get_data(
    universe = ['RCIb.TO'],
    fields = [
    'TR.ODOfficerFullName(ODStatus=Inactive, ODRnk=all)',
    'TR.ODOfficerPositionDesc(ODStatus=Inactive, ODRnk=all)',
    'TR.ODOfficerPersonAge(ODStatus=Inactive, ODRnk=all)',
    'TR.ODOfficerPositionStartDate(ODStatus=Inactive, ODRnk=all)',
    'TR.ODOfficerPositionEndDate(ODStatus=Inactive, ODRnk=all)'
    ]
    )
df