For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
3 1 2 4

when i use get_data on an ETF requesting various Fund holding fields the output is misaligned. Example 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                            

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythondata
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
Accepted
39.2k 75 11 27

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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
4.6k 26 7 22

Looks like a bug. I will contact product managers and let you know.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
4.3k 2 4 5

I confirm it's a bug from the back-end.

Issue not reproduced with Eikon for Office:


excel.jpg (152.2 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
5 1 0 1

What there ever a resolution to this error?

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Not yet. The fix is expected in production in a couple of weeks.

Click below to post an Idea Post Idea