Find fund ISIN from RDP Fund name or Id

maximilian.syndikus
Newcomer
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
0
Best Answer
-
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
}0
Answers
-
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.rawto 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}0
Categories
- All Categories
- 3 Polls
- 6 AHS
- 36 Alpha
- 166 App Studio
- 6 Block Chain
- 4 Bot Platform
- 18 Connected Risk APIs
- 47 Data Fusion
- 34 Data Model Discovery
- 685 Datastream
- 1.4K DSS
- 615 Eikon COM
- 5.2K Eikon Data APIs
- 10 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 252 ETA
- 556 WebSocket API
- 38 FX Venues
- 14 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 23 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 275 Open PermID
- 44 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 22 RDMS
- 1.9K Refinitiv Data Platform
- 652 Refinitiv Data Platform Libraries
- 4 LSEG Due Diligence
- LSEG Due Diligence Portal API
- 4 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.2K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 12 World-Check Customer Risk Screener
- 1K World-Check One
- 46 World-Check One Zero Footprint
- 45 Side by Side Integration API
- 2 Test Space
- 3 Thomson One Smart
- 10 TR Knowledge Graph
- 151 Transactions
- 143 REDI API
- 1.8K TREP APIs
- 4 CAT
- 27 DACS Station
- 121 Open DACS
- 1.1K RFA
- 104 UPA
- 193 TREP Infrastructure
- 228 TRKD
- 917 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 90 Workspace SDK
- 11 Element Framework
- 5 Grid
- 18 World-Check Data File
- 1 Yield Book Analytics
- 46 中文论坛