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

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!

Best Answer

  • Jirapongse
    Answer ✓

    @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:

    1689046443590.png

    The following is the output from Eikon Data API.

    1689046465621.png

    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.


Answers

  • 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.

  • @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.