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
3 0 0 4

How do I obtain time series of top 10 investors for a list of firms?

Using the Eikon API, how do I obtain time series data for the top 10 investors for a list of firms (in Python)?
For example this:

df, e = ek.get_data('FIEG.DE',['TR.ISIN','TR.InvestorFullName','TR.PctOfSharesOutHeld','TR.PctOfSharesOutHeld.date','TR.InvestorType'],{'SDate':'2000-12-31','Frq':'Y', 'EDate':'2002-12-31'}) #time range

gives me all investors, and I am wondering how to limit to top 20 (or 50 or whatever).
Thank you!

apipython apitime-series
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
Accepted
10.5k 19 6 9

Hi @Hannes Wagner Thanks for your question. So I have check a bit and I think this works best doing it one year at a time:

df, e = ek.get_data('FIEG.DE'['TR.ISIN','TR.InvestorFullName','TR.PctOfSharesOutHeld','TR.PctOfSharesOutHeld.date','TR.InvestorType'],{'SDate':'-1FY','StartNum':1,'EndNum':10}) 

1682695754703.png

I hope this can help.


1682695754703.png (190.4 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.

@jason.ramchandani01

it helped me, thanks.

Regarding the parameters:

{'SDate':'-1FY','StartNum':1,'EndNum':10}

Could you point to some documentation?

TIA

Upvotes
3 0 0 4

Yes, it does help! Thank you!

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.