TR.EnvironmentPillarScore only returns NULL value I Same request 2 days ago worked fine

haggi

Dear Community,

I am trying to retreive ESG data with the TR.EnvironmentPillarScore function through the Excel Add-On API.

However the same function which worked two days ago now returns a NULL value for all inputs.

=@TR(AA4;"TR.EnvironmentPillarScore";"SDate=#1";AK2;F4)

AA4 = BNPP.PA

AK2=Output Cell

F9= 03.07.2016

Double checking with the Python API also only returns NaNs. What can the problem be?

Thanks in advance!

Jirapongse

@haggi

Thank you for reaching out to us.

I used the following formula to get the data.

=@TR("BNPP.PA","TR.EnvironmentPillarScore","SDate=2016-07-03 CH=Fd RH=IN",F2)

The output is:

The following is the output from Eikon Data API.

If the problem happens with the formula in the Eikon Excel, please contact the Eikon support team via MyRefinitiv to verify what the problem is.

keks96

https://community.developers.refinitiv.com/discussion/comment/106839#Comment_106839

Hi, I ran your suggestion since I have the same issue. The result was the same. Still retrieving NULL values. All ESG data is NULL.

Jirapongse

https://community.developers.refinitiv.com/discussion/comment/106851#Comment_106851

@keks96

You can test it by retrieving the data in Eikon Excel. If the result from the Eikon Excel is also NULL, please contact the Eikon support team via MyRefinitiv to verify what the problem is.