How to retrieve the historical data for officers and directors.

Question

Is there any way to automate the procedure in Excel, or are there other workarounds? Due to the large sample size, manual exporting into Excel for each company isn't feasible. Will the historical data via Python be supported in the future?

Jirapongse · Answer

@NikithaNayak

Is it this one?

df = ld.get_data(
    universe = ['AAPL.O'],
    fields = ['TR.ODOfficerFullName',
              'TR.ODOfficerPersonAge',
              'TR.ODOfficerPositionDesc',
              'TR.ODOfficerPositionStartDate',
              'TR.ODOfficerPositionEndDate',
              ],
    parameters = {
        'ODRnk':'ALL',        
        'ODStatus':'Active,Inactive'
    })
df

raksina.samasiri · Answer

Hi @NikithaNayak ,

This forum is more for programming-type queries, rather than content queries. I would recommend you to contact the support team directly via https://support.lseg.com/s/ . You can ask for the formula in the Workspace Excel which can be used to retrieve the data and if the formula is available, we can apply it to the get_data method with the Data Library for Python.

That way a content specialist can work closely with you to find a way to get the required data.

Hope this could help.

EXPLORE OUR SITES