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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
25 2 7 10

How can i extract the major shareholders with the Python API?

What is the parameter for the Eikon Python API to retrieve the main shareholders of an instrument? I expect it to be something like TR.Shareholders but i cant find anything like it.

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonextraction
icon clock
10 |1500

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

Upvote
Accepted
18k 21 12 20

Hi,

You can use TR.InvestorFullName and TR.ShareHeld fields.

This is my code:

import eikon as ek
ek.set_app_id('<your app id>')
ek.get_data(instruments=['0005.HK'], fields=['TR.InvestorFullName','TR.SharesHeld'])

This is part of the result as of 3rd Jan 2018

(    Instrument                                 Investor Full Name  \
0      0005.HK             JPMorgan Asset Management U.K. Limited
1      0005.HK        BlackRock Institutional Trust Company, N.A.
2      0005.HK                 Ping An Asset Management Co., Ltd.
3      0005.HK                           The Vanguard Group, Inc.
4      0005.HK         Legal & General Investment Management Ltd.
5      0005.HK           Norges Bank Investment Management (NBIM)
...
...
...
     Investor Shares Held
0              1319000852
1              1267291596
2              1007946172
3               509326108
4               401921814
5               373122115
...
...
...
}
icon clock
10 |1500

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

Thanks! Is there a quick way to retrieve this as a percentage instead of the number of shares held?

Ok i found that by adding TR.PctOfSharesOutHeld to the fields array i can retrieve this.

Upvotes
38.1k 71 35 53

Typically, you can use Data Item Browser (DIB) app to find the required fields.

Otherwise, you can contact Eikon Excel support team for the requested fields which can be used with the =TR() function. After that, you can also use those fields with Eikon Python API.

You can contact Eikon support team via Contact Us.


dib.png (53.7 KiB)
icon clock
10 |1500

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

Upvotes
25 2 7 10

As i said i already tried looking for major shareholders using the data browser, however nothing shows up, hence this post. As you suggest i will try the contact us link. I will publish an answer as soon as i have it.

icon clock
10 |1500

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

Click below to post an Idea Post Idea