Historical subsidaries of an ultimate parent.

Statistik Dude

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

nick.zincone

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