question

Upvotes
Accepted
mraza avatar image
1 ●0 ●1 ●1

Historical Officers and Directors data pull using API

Hello,


I was just wondering if it's possible to retrieve data on previous officers and directors through the API in Refinitiv Workspace. My understanding is that it was previously not possible through the Eikon API, but is there any change as we shift to Workspace?


Thanks in advance.

eikon-data-apiworkspace-data-api#technology#product
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

wasin.w avatar image   wasin.w

Hello @mraza

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?


If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,


AHS


aramyan.h avatar image   aramyan.h

Hi @mraza ,

Please be informed that a reply has been verified as correct in answering the question, and marked as such.

Thanks,

AHS

1 Answer

· Write an Answer
Upvotes
Accepted
raksina.samasiri avatar image
14.2k ●30 ●5 ●10

Hi @mraza ,

I cannot find how to retrieve the historical data of officers and directors data with the Refinitiv Data library yet. However, as the moderator of this forum is not an expert in every content set available in Refinitiv, that expertise can be found in the Helpdesk which can be reached via MyRefinitiv, which I found the related case raised a few weeks ago with the answer from support team as below 

I have worked with our Specialist regarding the historical officers and directors data with an API. Please be advised that historical data for Board Members/Directors for a given company is currently not supported as confirmed by our Specialist. You may see general guidelines on how to pull up officers and directors below.

Using sample RIC <CHRH.CO>, you may access the Overview page > ESG Tab > Officers. You may also export the data in excel by clicking the Export to Excel option located at the upper right side of the ESG page.


In case this could help, below is the code to retrieve the current data with Refinitiv Data Library. However, checking the Parameters tab in the Data Item Browser, it seems the historical data of field TR.OfficerName isn't available.

import refinitiv.data as rd
rd.open_session()

rd.get_data(
    universe=['AAPL.O'],
    fields=['TR.OfficerName',
            'TR.OfficerTitle',
            'TR.OfficerTitleSince',
            'TR.OfficerAge'
           ],
    parameters={'RNK':'R1:R30'}
)

1680141852603.png

Please let me know in case you have any further questions.


1680141852603.png (55.5 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Jeslin.S avatar image Jeslin.S

How can we get the biography& education, affiliations and committee of an officer in this same table?

For example, 1702023216204.png

I want to retrieve all the information from this tab. Is it possible?

1702023216204.png (218.8 KiB)

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.