How do I pull data on historical officers ina company i.e. I would like to know who was the CEO during 2015-2021 at Apple?
@sven.thoren
Thank you for reaching out to us.
This forum is dedicated to software developers using LSEG APIs. The moderators on this forum do not have deep expertise in every bit of content available through LSEG products, which is required to answer content questions such as this one.
The best resource for content questions is the Helpdesk support team, which can be reached by submitting queries through LSEG Support. The support team will either have the required content expertise ready available or can reach out to relevant content experts to get the answer for you.
You need to ask for the Excel formula, such as =RDP.Data, that can be used to retrieve the required data. Then, we can help you converting that formula to Python code.
Please include the URL of this discussion in your raised question to prevent it from being redirected back to this Q&A forum.
Got this from helpdesk (pls see below). Can we transfer this into Python?
Hello, Sven.
We can try the below
Kindly use position start date and position end date in excel as well here is an example of formula we can use in excel
=@RDP .Data("AMZN.O","TR.ODOfficerFirstName;TR.ODOfficerLastName;TR.ODOfficerPositionDesc;TR.ODOfficerPositionStartDate;TR.ODOfficerPositionEndDate;TR.ODOfficerPositionDesc","CH=Fd RH=IN",B2)
I am using the LSEG Data Library for Python and the code looks like this:
df = ld.get_data( universe = ['AMZN.O'], fields = ['TR.ODOfficerFirstName', 'TR.ODOfficerLastName', 'TR.ODOfficerPositionDesc', 'TR.ODOfficerPositionStartDate', 'TR.ODOfficerPositionEndDate', 'TR.ODOfficerPositionDesc']) df
The output is:
The output is the same of the output from Excel.
If this is not the data that you want, you contact the helpdesk to verify this formula.
How do I turn this into Python?
=@RDP .Data($B$5:$B$104,"TR.ODOfficerFullName;TR.ODOfficerPersonAge;TR.ODOfficerPositionDesc;TR.ODOfficerPositionStartDate;TR.ODOfficerPositionEndDate","ODRnk=ALL ODRole=CEO ODStatus=Active,Inactive ch=fd rh=in null=blank",,$D$3)
