question

Upvotes
Accepted
1 0 2 3

How to get ESG data for funds?

phython.pngThe case in the above screenshot uses a RIC for a fund which has ESG data on the Workspace. Unfortunately, when we try to read this into Python it does not return anything.

The example case is MSFT.O and this loads the ESG data successfully. How would we do the same for Funds?


One of the funds we are looking into is:

Name: MSIF Calvert Sustainable Climate Al Fd I USD Acc

ISIN: LU2459593203

RIC: LP68706140

#product#contentesgfunds
phython.png (41.8 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Hello @JoanneCamille.Andes

Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?


If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.

Thanks,


AHS

@JoanneCamille.Andes

Hi,

Please be informed that a reply has been verified as correct in answering the question, and marked as such.

Thanks,

AHS

Upvotes
Accepted
1.6k 3 2 3

Hi @JoanneCamille.Andes , The fund level ESG data should be obtained vi the RDP Funds API service. Below is the REST query followed by the response object using your sample fund:


https://api.refinitiv.com/data/funds/v1/assets?symbols=68706140&properties=esg

{
  "assets": [
    {
      "id": "68706140",
      "esg": [
        {
          "date": "2023-04-30",
          "items": [
            {
              "type": {
                "id": "56300",
                "code": "ESGSC",
                "name": "ESG Score"
              },
              "value": 74.93446704
            },
            {
              "type": {
                "id": "56301",
                "code": "SGCvrgcnt",
                "name": "ESG Coverage count"
              },
              "value": 181.0
            },
            {
              "type": {
                "id": "56303",
                "code": "NEVIRPS",
                "name": "Environment Pillar Score"
              },
              "value": 71.57303343
            },
            {
              "type": {
                "id": "56304",
                "code": "RsrcsScr",
                "name": "Resource Use Score"
              },
              "value": 83.31939405
            },
            {
              "type": {
                "id": "56305",
                "code": "mssnsScr",
                "name": "Emissions Score"
              },
              "value": 83.85738209
            },
            {
              "type": {
                "id": "56306",
                "code": "nvrnmntlnnvt",
                "name": "Environmental Innovation Score"
              },
              "value": 50.15628497
            },
            {
              "type": {
                "id": "56307",
                "code": "SclPllrScr",
                "name": "Social Pillar Score"
              },
              "value": 78.59254951
            },
            {
              "type": {
                "id": "56308",
                "code": "WrkfrcScr",
                "name": "Workforce Score"
              },
              "value": 86.10246983
            },
            {
              "type": {
                "id": "56309",
                "code": "HmnRghtsScr",
                "name": "Human Rights Score"
              },
              "value": 72.11364571
            },
            {
              "type": {
                "id": "56310",
                "code": "CmmntyScr",
                "name": "Community Score"
              },
              "value": 85.32069502
            },
            {
              "type": {
                "id": "56311",
                "code": "PrdctRspnsbl",
                "name": "Product Responsibility Score"
              },
              "value": 68.06029526
            },
            {
              "type": {
                "id": "56312",
                "code": "GvrnncPllrSc",
                "name": "Governance Pillar Score"
              },
              "value": 71.97565321
            },
            {
              "type": {
                "id": "56313",
                "code": "MngmntScr",
                "name": "Management Score"
              },
              "value": 73.30162409
            },
            {
              "type": {
                "id": "56314",
                "code": "ShrhldrsScr",
                "name": "Shareholders Score"
              },
              "value": 62.14942685
            },
            {
              "type": {
                "id": "56315",
                "code": "CSRStrtgyScr",
                "name": "CSR Strategy Score"
              },
              "value": 80.08513839
            },
            {
              "type": {
                "id": "56316",
                "code": "SGCmbndScr",
                "name": "ESG Combined Score"
              },
              "value": 64.38114823
            },
            {
              "type": {
                "id": "56317",
                "code": "SGCntrvrssSc",
                "name": "ESG Controversies Score"
              },
              "value": 68.02088332
            },
            {
              "type": {
                "id": "56302",
                "code": "SGCvrgVl",
                "name": "ESG Coverage % Value"
              },
              "value": 99.50885024
            }
          ]
        }
      ]
    }
  ],
  "totalRecords": 1,
  "fromIndex": 0,
  "toIndex": 0,
  "pageNumber": 0
}


icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Hi @bob.lee,


Does this mean that in order to access the code above, client would need access to REST API?

If yes, is this a feature (REST API) available within the TRTH product?

Upvotes
1.6k 3 2 3

@irving.deauna , The RDP Funds API is providing the service only via the REST API. It is part of the RDP services, so I do not think it is available within TRTH product.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Hi @bob.lee,

Thank you. Per client's reply:

"Does EY have access to the REST API? We are still trying to extract fund information and I believe that the REST API is required for this?"

That being said, is there a way for us to check if client has access to RDP REST API?

User is: tom.chatt@uk.ey.com
Account Name: EY Global Services Limited

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.