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

ant1bball

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.

chavalit-jintamalit

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
...
...
...
}

Jirapongse

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.

ant1bball

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.

ant1bball

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

ant1bball

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