nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

What is the reason for this and how I can I get the correct values using the API?

nouman_ashfaq0414

I want to extract aggregated ownership data for companies using the Python API. Therefore, I request the variabe TR.CategoryOwnershipPct in combination with the Parameter 'StatType': '7'. This approach works for non-UK companies as Apple or Volkswagen. When applying it to companies in the UK as LSEG.L (see screenshots) or Unilever, there is a massive deviation for the domestic and foreign Investor values between API and Workspace.

When using 'StatType': '2', I get the correct values but as I want to perform the request for a large sample, I would prefer to only use the request with 'StatType': '7'.

Find more posts tagged with

python

#content

Accepted answers

All comments

Jirapongse

@nouman_ashfaq0414

Thank you for reaching out to us.

This forum is dedicated to software developers using LSEG APIs. The moderators on this forum do not have deep expertise in every bit of content available through LSEG products, which is required to answer content questions such as this one.

The best resource for content questions is the Helpdesk support team, which can be reached by submitting queries through LSEG Support. The support team will either have the required content expertise ready available or can reach out to relevant content experts to get the answer for you.

You need to ask for the Excel formula, such as =RDP.Data, that can be used to retrieve the required data. Then, we can help you converting that formula to Python code. You can also refer to the How to Convert the =@RDP.Data Excel Function into Code Using the LSEG Data Library for Python article.

nouman_ashfaq0414

Hi @Jirapongse,

Thank you for your response.

I checked with my product specialist and the issue is replicable from our end as well on the Python API.

There is difference in Phyton and excel formula

For reference: excel formula=@RDP.Data("LSEG.L","TR.CategoryOwnershipPct","StatType=7 CH=Fd RH=categoryvalue",B3)

Jirapongse

The equivalent Python code for that Excel formula is:

ld.get_data(
    universe=['LSEG.L'],
    fields=['TR.CategoryOwnershipPct.categoryvalue','TR.CategoryOwnershipPct'],
    parameters={'StatType':7}
)

nouman_ashfaq0414

Thank you so much for your help!

nouman_ashfaq0414

Hi @Jirapongse

The client is more concerned over the data discrepancy, there is a slight difference in the data retrieving in excel and in API codebook.

I have attached the screenshots for your reference.

May I know what could be the issue?

Jirapongse

@nouman_ashfaq0414

The library retrieves data from the backend service. The following is the raw response retrieved from the backend service.

{

  "responses": [

    {

      "columnHeadersCount": 1,

      "data": [

        ["LSEG.L", "Holdings by Foreign Investors", 72.8261],

        ["LSEG.L", "Holdings by Institutions", 67.9296],

        ["LSEG.L", "Holdings by Government", 9.5914],

        ["LSEG.L", "Holdings by Strategic Entities", 4.9032],

        [

          "LSEG.L",

          "Holdings by Holding Companies and Corporations",

          4.7287

        ],

        [

          "LSEG.L",

          "Holdings by Strategic Entities less Individuals",

          4.7287

        ],

        ["LSEG.L", "Holdings by Insiders", 0.171],

        ["LSEG.L", "Holdings by Domestic Investors", 0.1338]

      ],

    …

      "rowHeadersCount": 1,

      "totalColumnsCount": 3,

      "totalRowsCount": 9

    }

  ]

You need to contact the helpdesk team to verify the content.

nouman_ashfaq0414

Thank you for your assistance on this :)

EXPLORE OUR SITES