WS API: Workaround for Extracting the Historical total Compensations of companies to their CEOs?

Christian_Ada

The end-user is trying to get is the total compensation the CEO of a company received in a specific year.
++++++++++++++++++++++++++
import refinitiv.data as rd
rd.open_session()
df = rd.get_data(
universe = ['SBUX.O'],
fields = [
'TR.ODOfficerFullName(ODRole=CEO)',
'TR.ODOfficerCompFYDTotalComp.periodenddate',
'TR.ODOfficerCompFYDTotalComp',
],
parameters = {
'SDate': '2020-01-01',
'EDate': '2025-12-31',
'Frq': 'Y'
}
)
df
++++++++++++++++++++++++++++++
However, I encountered an issue – correct me if I am wrong – it seems the retrieval is restricted to the current CEO. What I am asking is whether there is a way to get this data not tied to a specific person. For example, I would like to retrieve the total compensation for the Starbucks CEO for the years 2020, 2021, 2022, 2023, and 2024, regardless of whether the CEO changed in 2023. Ultimately, the amount the company paid to its CEO in a given year is what is relevant to me, not who held the position.

 As per testing, we can only see 2 consecutive periods for Starbucks

Another example for Large-cap firm: Boeing ('BA'). The had a change in CEO in August 2024. Using the fields same above, shows a totals compesation of 614,500 in 2025, 540,494 in 2024 and 362,589 in 2023 which cannot be the CEOs compensation. Using the same code for AMZN.O (CEO change in 2021) the reported fiscal year total compesnation is in all periods 1,681,840. Comparing to the numers reported in the workspace this represents the ocmpensatoin of Mr. Jeffrey Bezos (executive chariman of the Board and Founder) and not Mr. Andrew Jassy (Preisdent, Chief Executive Officer, since 2021).

Jirapongse

@Christian_Ada

Thank you for reaching out to us.

I tested that code in Excel and got the same data.

=@RDP.Data("SBUX.O","TR.ODOfficerFullName(ODRole=CEO);TR.ODOfficerCompFYDTotalComp.periodenddate;TR.ODOfficerCompFYDTotalComp","Sdate=2020-01-01 EDate=2025-12-31 CH=Fd RH=IN",B2)

I checked and found that these fields may not support the SDate and EDate parameters.

According to the answer in this discussion, the code to get previous (inactive) CEO officers could be like this.

df =ld.get_data(
    universe = ['SBUX.O'],
    fields = ['TR.ODOfficerFullName','TR.ODOfficerPositionDesc','TR.ODOfficerCompFYDTotalComp.periodenddate','TR.ODOfficerCompFYDTotalComp'],
    parameters = {
        'ODStatus':'Inactive',
        'ODRnk':'all',
        'ODRole':'CEO'}
)

df 

However, please contact the content team to verify it and share the Workspace Excel formula, such a =RDP.Data which can be used to retrieve the required data.

Then, I can check if it can be converted to Python code.