How can I access the Company Tree Structure through the Python Eikon API?

The Company Tree Structure is one of the applications in the "Overview" tab of a company view in Eikon. I would like to retrieve this information using the eikon Python package and related API Key. However, I don't find any documentation how to do this (what function, parameter set to use).

Best Answer

  • Starting with an organization PermID or a RIC for the company common stock use TR.ImmediateParentId, TR.ImmediateParent fields to go one level up the company tree structure or use fields TR.UltimateParentId, TR.UltimateParent to jump to the top of it.
    Use fields TR.RelatedOrgId, TR.RelatedOrgName, TR.RelatedOrgType to retrieve the list of immediate subsidiaries, affiliates and joint ventures.

    E.g.

    ek.get_data('LSE.L',['TR.RelatedOrgId','TR.RelatedOrgName','TR.RelatedOrgType'])

    For more information about these and other fields you can use to create the company tree structure use Data Item Browser (DIB) or CodeCreator (CODECR) apps in Eikon or Refinitiv Workspace.

Answers