Ordering output from TR function in Excel

blucap
blucap Explorer
in Eikon Data APIs

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?

screenshot-2023-05-10-153500.png

Tagged:

Best Answer

  • raksina.samasiri
    raksina.samasiri admin
    Answer ✓

    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.

Answers

  • Jirapongse
    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:

    1683697533472.png

    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.

Categories