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:
=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
Find more posts tagged with
Sort by:
1 - 1 of
11
Sort by:
1 - 1 of
11
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
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
Thank you @Alex Putkov.1 So is there no other way than to wait till April?
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.