Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
I am using Eikon for Excel.
I have a list of identifiers in column A and for each of them I need the ESG score.
=TR(A2,"ABS(TR.TRESGScore)","period=FY0 Sdate=01-Jan-2010 Edate=31-DEC-2022 Frq=Y CH=In RH=FPA TRANSPOSE=Y",C1)
The above function works well. However, the output is poorly aligned, with different years in the same column, see pic below.
Is there a way to align the output so that all FY2018 are nicely stacked in the same column?
Hi @blucap ,
Thank you for your participation in the forum.
Are any of the replies below satisfactory in resolving your query?
If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.
Otherwise please post again offering further insight into your question.
Thanks,
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.
Thanks,
AHS
Hi @blucap ,
Thank you for posting the question in this forum. However, this forum is dedicated to an API usage question hence, the moderators on this forum do not have deep expertise in every type of content available through Refinitiv products such as Eikon Excel. Such expertise is available through Refinitiv Helpdesk, which can be reached via MyRefinitiv then the support team is going to contact you directly to assist with this.
Hope this helps and please let me know in case you have any further questions.
Thanks for reaching out to us.
You can try the following formula.
=TR("AEC000101019,AEC000201017,AED000201015","ABS(TR.TRESGScore)","period=FY0 Sdate=01-Jan-2010 Edate=31-DEC-2022 CH=In RH=Fpa TRANSPOSE=Y SORT=A",C1)
The output looks like this:
If this doesn't work, you can contact the Eikon Excel support team directly via MyRefinitiv. The support team can help you find the parameters that can be used to format the output.
I hope that this information is of help.
