Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
sc11214 avatar image
22 ●3 ●3 ●6

Officer and directors data

Hello,

I am trying to access Officer&Directors data through the Eikon API. I cannot get the full history but only the most recent observation. Here is an example of the code:

    dt, err = ek.get_data(instr,['TR.CLOSEPRICE.date', 
                                 'TR.OfficerTitle(RNK=R1:R100)',
                                 'TR.OfficerTitleSince(RNK=R1:R100)',
                                 'TR.OfficerName(RNK=R1:R100)',
                                 'TR.OfficerAge(RNK=R1:R100)'],
                                {'SDate': '2010-01-01','EDate':'0', 'Frq':'Y'})


Here is the output:


                                        Officer Title  ... Officer Title Since
0      Chairman of the Board, Chief Executive Officer  ...                2021
1                                       Vice Chairman  ...                2021
2   Senior Vice President and Chief Financial Officer  ...                2018
3           Senior Vice President and General Counsel  ...                2015
4                          Vice President, Controller  ...                2017
5                           Lead Independent Director  ...                2005
6                                Independent Director  ...                2020
7                                Independent Director  ...                2012
8                                Independent Director  ...                2015
9                                Independent Director  ...                2019
10                                                     ...                <NA>


Does anyone have any idea how I can get the history? Specifically, what I am looking at is just the name and bio info of the CEO per year.


Thanks

eikoneikon-data-apirefinitiv-dataplatform-eikonworkspaceworkspace-data-api
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.

jonathan.legrand avatar image jonathan.legrand
Hi @sc11214 ,

It seems as though the API call (as it is) does provide the name of CEOs. Have you got an example of the bio you're also after? What do you expect in such a bio?

raksina.samasiri avatar image   raksina.samasiri

hi @sc11214,

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

wasin.w avatar image   wasin.w

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

Thanks,


AHS

5 Answers

· Write an Answer
Upvotes
Accepted
jonathan.legrand avatar image
5.8k ●21 ●2 ●6

Hi @sc11214 ,

When looking on the Data Item Browser, I can see that elements such as TR.OfficerTitle are static fields, not Time Series ones. Static fields do not change with specified dates in parameters.

Static fields have a parameters tab that look like this:

1631204241403.png


Time Series fields have a parameters tab that look like this (with a 'series' tickbox'):


1631204307006.png



1631204241403.png (54.6 KiB)
1631204307006.png (75.2 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.

Upvotes
sc11214 avatar image
22 ●3 ●3 ●6

@jonathan.legrand Yes I get the CEO name but I need an history. From the call I only get the most recent CEO. For what concern the bio I am not too worried about it. Age, and sex would do. What I really care about is the history of the name, i.e., who was the CEO in 2010, 2011, ...

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.

Upvotes
jonathan.legrand avatar image
5.8k ●21 ●2 ●6

Hi @sc11214 ,


You can look for Time Series Fields only on the Data Item Browser via the cog at the top right of the screen:

1631204592228.png

Please do let me know if you find the data item you're looking for. Else, please note that this forum is for API-related issues. If you have a content question, please direct it to the helpdesk.


1631204592228.png (95.1 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.

Upvotes
sc11214 avatar image
22 ●3 ●3 ●6

@jonathan.legrand Thanks for your response. I'll talk to the helpdesk then to understand why there are not time-series data for directors (there should be in theory, I though there was a problem with my API request)

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.

Upvotes
ltr.msc avatar image
1 ●0 ●0 ●0

@sc11214 Is there any update on this? Could the helpdesk help and did you manage to pull historical Officer and Director information? I have the same issue right now and would be happy for any tips

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.

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.