when i use get_data on an ETF requesting various Fund holding fields the output is misaligned. Ex...

...ample code below for CSM.Z, the RICS are not aligned with FundNumber of Shares etc.

dfetf, err = ek.get_data(['CSM.Z'],['TR.FundHoldingRIC(StartNum=1,EndNum=10)', 'TR.FundHoldingName(StartNum=1,EndNum=10)','TR.FundNumberOfShares','TR.FundPercentageOfFundAssets','TR.FundGeographicFocus'],{'StartNum':'1','EndNum':'10'})
dfetf.head()
Out[41]:
Instrument Holding RIC Holding Name \
0 CSM.Z AAPL.OQ SOCIETE GENERALE/CREDIT SUISSE 130/30 LARGE CA...
1 CSM.Z MSFT.OQ APPLE INC ORD
2 CSM.Z FB.OQ PROSHARES REPO & OTHER INVESTMENTS
3 CSM.Z AMZN.OQ MICROSOFT CORP ORD
4 CSM.Z GOOGL.OQ FACEBOOK INC ORD
Number of Shares Percentage of Fund Assets Geographic Focus
0 2.00 3.9967 United States of America
1 105103.00 2.3634
2 15076261.32 2.3539
3 148022.00 1.5931
4 64087.00 1.5107

Best Answer

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭
    Answer ✓

    The issue is fixed. The fix was deployed in production on 30-Apr-18.

Answers