Eikon box shows different fund constituents than EIKON Python API

grigorios.mamalis

@nick.zincone Hi, I am using EIKON API to retrieve Fund constituents using Python ("EAP" in sequel) script shown below. Upon comparing it with what I get from EIKON box (Derived Holding), I see a "slightly" different picture

a. "EAP"result gives a total of weights equal to ~300% whereas EIKON box shows 100% ("ACCOUNTS PAYABLE" which accounts for -200% is missing from "EAP" result together with some smaller stuff.

b. EIKON Box Derived Holdings is ~2,200 rows, whereas the "EAP" result is ~2,000rows ..

Is there an explanation?

Many thanks in advance, Grigorios

**********************************************************************************************************************************

fundISIN = "CH0214985100"

fieldSet = ["TR.FundHoldingRIC", "TR.FundHoldingRIC", "TR.FundCountryOfDomicile","TR.FundHoldingName",

"TR.FundLatestFilingDate", "TR.FundNumberOfShares", "TR.FundNumberOfSharesChanged", "TR.FundPercentageOfFundAssets"]

fund_Info, err = ek.get_data(fundISIN, fieldSet, {'StartNum':1, 'EndNum':2000})

mysum = fund_Info["Percentage of Fund Assets"].sum()

print(mysum)

# 300.5548

jason.ramchandani01

@grigorios.mamalis You are curtailing the API return by using the EndNum parameter of 2000 - if you say use 20000 - it will return the full 2200 entries as per the terminal. I am using the Refinitiv Data Library here which is a newer and better version of the Eikon Library.

pip install refinitiv-data

import refinitiv.data rd
rd.open_session()

df = rd.get_data(universe=['CH0214985100'],
            fields=['TR.FundHoldingRIC','TR.FundCountryOfDomicile','TR.FundHoldingName',
            'TR.FundLatestFilingDate','TR.FundNumberOfShares','TR.FundNumberOfSharesChanged',
            'TR.FundPercentageOfFundAssets'],
           parameters={'StartNum':1,'Endnum':20000}
           )
df

At the bottom you can see the missing ACCOUNTS PAYABLE, EUR CASH, GBP CASH AND JPY CASH entries.

I hope this can help

grigorios.mamalis

@jason.ramchandani01 Many thanks. I only now realized there was this 2000 figure.