question

Upvotes
Accepted
maximilian.syndikus avatar image
1 ●0 ●0 ●3

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.

2 Answers

· Write an Answer
Upvotes
Accepted
bob.lee avatar image
1.6k ●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
m.bunkowski avatar image
1.4k ●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.