Historical CEO total compensation per fiscal year via Eikon Data API

Jan__00

Hi,

I am trying to retrieve the total compensation of a company's CEO for each fiscal year, for example from 2002 to 2025, using ek.get_data. So far the only field I found is TR.CGAnalyticHighestRemuneration, but it returns a single value per year for the highest-paid executive, so I cannot verify whether that person was actually the CEO. Is there a data item that returns historical total compensation per officer by fiscal year together with the officer's role, so that I can restrict the result to the CEO?

Thanks a lot!

Jirapongse

@Jan__00

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. You can also refer to these articles:

• How to Convert the =@RDP.Data Excel Function into Code Using the LSEG Data Library for Python
• Converting =RDP.HistoricalPricing() Excel Function to ld.get_history() in Python