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
Statistik Dude avatar image
75 ●4 ●5 ●6

Historical subsidaries of an ultimate parent.

Hello guys,

I have managed to download a list with all firms, which have the same ultimate owner id:


syntax = 'SCREEN(U(IN(Equity(active,inactive,public,private,primary))),
                   IN(TR.UltimateParentId, "%s"))'%(ult_id)
fields = ['TR.CommonName','TR.AlsoKnownAsName', 'TR.FormerlyKnownAsName',
          'TR.DoingBusinessAsName' ,'TR.OrganizationID']
df,e = ek.get_data(syntax, fields)


However, I have not managed to download the data per year. The above code only gives the most recent data, but the ownership structure of companies change over years. Is it possible, to retrieve somehow a list of subsidiaries of a specific year? The syntax query was new to me, but it seems to work the best. However, I have not managed to add a year to the syntax, which helps to identify, since when the subsidiary is part of the ultimate owner.


Or does somebody have a different idea, how to get a list of firms which belong to an ultimate parent on a yearly basis?

I would appreciate any help.

Kind Regards

Statistik Dude

eikon-data-apipython 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.

wasin.w avatar image   wasin.w

Hello @Statistik Dude

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

1 Answer

· Write an Answer
Upvotes
Accepted
nick.zincone avatar image
17.2k ●82 ●39 ●63

Hi @Statistik Dude

These forums are dedicated to API-related questions. For questions around content, you will need to involve a content specialist to confirm content availability. Within your desktop application (Refinitiv Workspace/Eikon), you can ask this question within the "Get Help & Support" menu option - or click "F1".

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.