Difference between Eikon Excel and Python API results

Hi,

I've noticed a discrepancy between data results using Eikon Formulas in Excel and Python API.

This is the Excel formula and results:

image

=TR("US29355XAD93",$F$3:$J$3,"TOP=5  CH=Fd RH=IN",E6)

While this is the Python ones:

image

campi=['TR.GR.RatingSourceCode',  'TR.GR.RatingDate',  'TR.GR.Rating ',  'TR.GR.RatingSPEquivalentRank',  'TR.GR.RatingSourceDescription']

dict_opt={'TOP':'5', 'CH':'Fd', 'RH':'IN'}

df,err=ek.get_data(['XS1384857493'],campi, dict_opt)

It seems to the column Rating SP Equivalent Rank is flipped upside down. Can anybody help me? Are there hyper parameters or options to use? Results in JSON format are not different from the above ones.

Thanks

Sort by:
1 - 1 of 11