Ordering output from TR function in Excel

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?

Find more posts tagged with

eikon

excel

#content

#product

Accepted answers

raksina.samasiri

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.

All comments

raksina.samasiri

Hi @blucap ,

Hope this helps and please let me know in case you have any further questions.

Jirapongse

@blucap

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.

EXPLORE OUR SITES