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