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?
Best 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.
0
Answers
-
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.
0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛