Find fund ISIN from RDP Fund name or Id

Question

question

maximilian.syndikus

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

#technology rdp-api #content refinitiv-data-libraries

Apr 04, 2023 at 11:12 AM

10 |1500

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

raksina.samasiri Apr 12, 2023 at 04:04 AM

Hi @maximilian.syndikus ,

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

raksina.samasiri Apr 19, 2023 at 04:13 AM

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

Thanks,
AHS

Answer 1 · 2023-04-06T06:17:52Z

bob.lee

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&amp;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&amp;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
}

Apr 06, 2023 at 06:17 AM

10 |1500

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

Answer 2 · 2023-04-04T13:59:21Z

m.bunkowski

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}

Apr 04, 2023 at 01:59 PM

10 |1500

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

Q&A Forum

question

Find fund ISIN from RDP Fund name or Id

2 Answers

Write an Answer

question

Find fund ISIN from RDP Fund name or Id

2 Answers

Write an Answer

Related Questions