Difference between Eikon Excel and Python API results

nicola.torresani

Hi,

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

This is the Excel formula and results:

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

While this is the Python ones:

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

Alex Putkov.1

This is a known issue for which there's no workaround, I'm afraid. The fix is currently planned for end of April. For more details see these two threads
https://community.developers.refinitiv.com/questions/23364/eikon-api-incorrect-output-when-start-date-is-befo.html

https://community.developers.refinitiv.com/questions/23111/corporate-action-adjustment-factor-missing-data-bu.html

nicola.torresani

https://community.developers.refinitiv.com/discussion/comment/23932#Comment_23932

Thank you @Alex Putkov.1 So is there no other way than to wait till April?

Alex Putkov.1

https://community.developers.refinitiv.com/discussion/comment/24012#Comment_24012

For this specific use case you could try constructing the request that would return a single row instead of a table. E.g. add the filter on specific rating source to the parameters. But there's no generic workaround, I'm afraid.