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.