Data Items behind Shareholder History Screen

s2782245

Hi Community,

I have a question: How can I find the Data Items behind the "Shareholder Report" in its specific configuration as it is displayed in Eikon? By "Data Items" i mean the very specific TR.CODES and the parameter implemented to retrieve the displayed results as can be seen in the attached Screenshot:

My ultimate goal is to get the same output via python and the API.

Kind regards

raksina.samasiri

Hi @s2782245 ,

Hovering your cursor on the column, such as the % Outstanding one, the [?] button will be shown up. If you click on this, the field definition and the Excel function used to retrieve this data will be shown on the pop-up

from this Excel function

Excel Function: =TR("SIEGn.DE@RIC","TR.PctOfSharesOutHeld")

It can be converted to this Python code

df, err = ek.get_data(['SIEGn.DE@RIC'], [ 'TR.PctOfSharesOutHeld'])
df

and with other columns field name

df, err = ek.get_data(['SIEGn.DE@RIC'],
                      [ 'TR.FirmInvestorId', 
                       'TR.PctOfSharesOutHeld',
                       'TR.SharesHeld',
                       'TR.SharesHeldChange',
                       'TR.SharesHeldValue',
                       'TR.HoldingsDate',
                       'TR.FilingType',
                       'TR.InvParentType',
                       'TR.InvestorType',
                       'TR.TotalEquityAssets',
                       'TR.InvInvestmentStyleCode',
                       'TR.OwnTrnverRating', # 0 = N/A, 1 = Low, 2 = Medium, 3 = High
                       'TR.InvestorAddrCity',
                       'TR.InvAddrCountry',
                       # 'TR.ConsHoldPctPortfolio'
                      ])
df

Here's the result

Hope this helps and please let me know in case you have any further questions