question

Upvotes
Accepted
1 0 0 2

Find fund ISIN from RDP Fund name or Id

Hi, I am trying to find all ISINs of the share classes belonging to a fund ISIN. I am using the property "RelatedAssets". For example, for fund ISIN LU0188167505, I get

{
                    "code": "SHARECLASSES",
                    "values": [
                        {
                            "name": "AXA IM FIIS US Short Duration High Yield F USD M D",
                            "id": 68365074
                        },...
                    ]
}

How can I find the ISIN for the fund

id = 68365074  , name = AXA IM FIIS US Short Duration High Yield F USD M D

using the funds API?

Thanks

#technologyrdp-api#contentrefinitiv-data-libraries
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.

Upvotes
Accepted
1.5k 3 2 3

Hi @maximilian.syndikus , You can find all the "related share classes" directly using the ISIN. Using your example, the query is:

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

You should bet back the response like below:

{
  "assets": [
    {
      "id": "LU0188167505",
      "relatedAssets": [
        {
          "code": "UMBRELLAASSET",
          "type": {
            "id": "28030",
            "name": "Umbrella Fund"
          },
          "values": [
            {
              "name": "AXA IM Fixed Income Investment Strategies",
              "id": 65006302
            }
          ]
        },
        {
          "code": "PRICOD",
          "type": {
            "id": "26786",
            "name": "Primary fund"
          },
          "values": [
            {
              "name": "AXA IM FIIS US Short Duration High Yield F USD C",
              "id": 65119947
            }
          ]
        },
        {
          "code": "PORTFOLIOASSET",
          "type": {
            "id": "45",
            "name": "Fund Portfolio"
          },
          "values": [
            {
              "name": "AXA IM FIIS US Short Duration High Yield",
              "id": 35166792
            }
          ]
        },
        {
          "code": "SHARECLASSES",
          "values": [
            {
              "name": "AXA IM FIIS US Short Duration High Yield F USD M D",
              "id": 68365074
            },
            {
              "name": "AXA IM FIIS US Short Duration High Yield A EUR H D",
              "id": 65088934
            },
            {
              "name": "AXA IM FIIS US Short Duration High Yield A GBP H C",
              "id": 68356477
            },
            {
              "name": "AXA IM FIIS US Short Duration High Yield I USD C",
              "id": 65006334
            },
            {
              "name": "AXA IM FIIS US Short Duration High Yield I EUR H C",
              "id": 65006331
            },
            {
              "name": "AXA IM FIIS US Short Duration High Yield I USD D",
              "id": 68124158
            },
            {
              "name": "AXA IM FIIS US Short Duration High Yield A CHF H C",
              "id": 68656553
            },
            {
              "name": "AXA IM FIIS US Short Duration High Yield F CHF H C",
              "id": 68057251
            },
            {
              "name": "AXA IM FIIS US Short Duration High Yield E EUR H C",
              "id": 68075226
            },
            {
              "name": "AXA IM FIIS US Short Duration High Yield B JPY H C",
              "id": 68604489
            },
            {
              "name": "AXA IM FIIS US Short Duration High Yield B CHF H D",
              "id": 68473468
            },
            {
              "name": "AXA IM FIIS US Short Duration High Yield B USD C",
              "id": 65006317
            },
            {
              "name": "AXA IM FIIS US Short Duration High Yield B CHF H C",
              "id": 68057250
            },
            {
              "name": "AXA IM FIIS US Short Duration High Yield E USD C",
              "id": 68076214
            },
            {
              "name": "AXA IM FIIS US Short Duration High Yield A GBP H D",
              "id": 68012384
            },
            {
              "name": "AXA IM FIIS US Short Duration High Yield A USD D",
              "id": 68012403
            },
            {
              "name": "AXA IM FIIS US Short Dur Hg Yld A Dis Mth fl USD",
              "id": 68245725
            },
            {
              "name": "AXA IM FIIS US Short Duration High Yield B EUR H D",
              "id": 65027907
            },
            {
              "name": "AXA IM FIIS US Short Duration High Yield F CHF H D",
              "id": 68473469
            },
            {
              "name": "AXA IM FIIS US Short Duration High Yield F AUD H D",
              "id": 68604845
            },
            {
              "name": "AXA IM FIIS US Short Duration High Yield B USD D",
              "id": 68055435
            },
            {
              "name": "AXA IM FIIS US Short Duration High Yield B GBP H D",
              "id": 68146473
            },
            {
              "name": "AXA IM FIIS US Short Duration High Yield B EUR H C",
              "id": 65006315
            },
            {
              "name": "AXA IM FIIS US Short Duration High Yield Z USD C",
              "id": 68240708
            },
            {
              "name": "AXA IM FIIS US Short Duration High Yield Z CHF H D",
              "id": 68473478
            },
            {
              "name": "AXA IM FIIS US Short Duration High Yield F USD C",
              "id": 65119947
            },
            {
              "name": "AXA IM FIIS US Short Duration High Yield Z EUR H C",
              "id": 68240706
            },
            {
              "name": "AXA IM FIIS US Short Duration High Yield Z EUR H D",
              "id": 68240707
            },
            {
              "name": "AXA IM FIIS US Short Duration High Yield A EUR H C",
              "id": 65006313
            },
            {
              "name": "AXA IM FIIS US Short Duration High Yield Z CHF H C",
              "id": 68257884
            },
            {
              "name": "AXA IM FIIS US Short Duration High Yield F EUR H D",
              "id": 65115430
            },
            {
              "name": "AXA IM FIIS US Short Duration High Yield B GBP H C",
              "id": 65006316
            },
            {
              "name": "AXA IM FIIS US Short Duration High Yield F EUR H C",
              "id": 65115429
            }
          ]
        }
      ]
    }
  ],
  "totalRecords": 1,
  "fromIndex": 0,
  "toIndex": 0,
  "pageNumber": 0
}

Then if you want to get the ISIN of all the share classes under the same portfolio, you can just check their ISIN using the Lipper ID in the previous result. e.g. for Lipper ID: 68365074, you can use the query:

https://api.refinitiv.com/data/funds/v1/assets?symbols=68365074&properties=codes[filter:ISIN] 

You should get:

{
  "assets": [
    {
      "id": "68365074",
      "codes": [
        {
          "code": "ISIN",
          "type": {
            "id": "1424",
            "name": "ISIN Code"
          },
          "values": [
            {
              "value": "LU1390070776"
            }
          ]
        }
      ]
    }
  ],
  "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.

Upvote
1.3k 5 3 6

Hi @maximilian.syndikus
You can try:

request_definition = rd.delivery.endpoint_request.Definition(
    method = rd.delivery.endpoint_request.RequestMethod.POST,
    url = 'https://api.refinitiv.com/data/funds/v1/assets',              
    body_parameters = {"universe": 
                       { "symbols": [
                           "68365074"]
                       },
                       "properties": [
                           {"name": "codes",
                            "filter": "ISIN"})
response = request_definition.get_data()
response.data.raw

to get a response like this:

{'assets': [{'id': '68365074',
   'codes': [{'code': 'ISIN',
     'type': {'id': '1424', 'name': 'ISIN Code'},
     'values': [{'value': 'LU1390070776'}]}]}],
 '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.

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.