Ownership Fields returning different number of fields - Error

Giorgio Cozzolino
Giorgio Cozzolino
in Eikon Data APIs

I am currently trying to obtain Fund Ownership information via Python, and while the data is downloaded fine, the issue is with the number of hits being returned. As an example ticker we can take XOM, and you can see that when you run the following two queries separately you get a different number of hits:

TR.FundPortfolioName - returning 3866 values

R.FundParentName - returning 3837 values

The issue here is that with both not having the same lenght, the information cannot be compared. Can you please advise on what to do here? Otherwise I see the field of R.FundParentName as worthless. The same unfortunately applies for TR.FundPctPortfolio, for which 3044 values are available. In my mind the blanks should count as data points, despite being blanks. Please see below for a snapshot certifying that some of the values are incomplete (anything for which the lenght of the individual dataframe is different from 3866). Can anyone suggest a workaround? Would I need perhaps to introduce the equivalent of "NULL=BLANK" in Excel, if there's anything as such, so to give all series the same n. of values?

image

Tagged:

Best Answer

  • Jirapongse
    Jirapongse
    Answer ✓

    @giorgio

    For TR.FundPctPortfolio, you can try ZAV(TR.FundPctPortfolio). From my testing, when using TR.FundPctPortfolio with IBM.N, it returns 2947 rows. However, when using ZAV(TR.FundPctPortfolio), it returns 3620 rows.

    For TR.FundParentName, I get the same result when using Eikon Excel. You may need to contact the Eikon Excel support team via MyRefinitiv for a solution. The solution may be applied to the get_data method.


Categories