Derived Asset Type Allocation For Funds/ETF
I was looking to get the attached info using Eikon API
I tried the get_data(TICKER', ['TR.FundAssetAllocation','TR.FundAllocationName']) for 2 ETFs in HK and one in India.
The HK ETFs don't seem to hv any data, but the Indian ETF shows the accurate breakdown by asset class. Is there a way to get the derived Asset Type allocation for 9010.HK? Is there a python desktop RDP api function that would make this process easier. I understand RDP has an endpoint url
'<a rel="nofollow" href="https://api.refinitiv.com/data/funds/v1/assets/9010.HK?properties=DerivedAllocations">https://api.refinitiv.com/data/funds/v1/assets/9010.HK?properties=DerivedAllocations</a>'
for derived allocations.
Best Answer
-
Hi again @rajanraju, I noticed you mentioned "RDP". There is a newer Funds API: "RDP Funds API", but it is a separate product, not the ADC based API you are using. The RDP Funds API do have the data you are asking for, and it is updated much more frequently than the ADC based API. Please check the result below I got from the API Playground using Lipper's RDP Funds API.
{
"assets": [
{
"id": "9010.HK",
"derivedAllocations": [
{
"type": {
"id": "368",
"code": "ASSTALL",
"name": "Asset Allocation"
},
"values": [
{
"date": "2021-04-30",
"values": [
{
"name": "Equity",
"rank": 1,
"value": 97.5698,
"values": [
{
"name": "Equities",
"rank": 1,
"value": 97.5698,
"values": [
{
"name": "Equity",
"rank": 1,
"value": 82.2558,
"values": [
{
"name": "Common Shares",
"rank": 1,
"value": 82.2558,
"id": 3617
}
],
"id": 29863
},
{
"name": "Depository Receipts",
"rank": 2,
"value": 14.4474,
"values": [
{
"name": "Depository Receipts",
"rank": 1,
"value": 14.4474,
"id": 3625
}
],
"id": 31842
},
{
"name": "Preferreds",
"rank": 3,
"value": 0.8666,
"values": [
{
"name": "Preferred Stock",
"rank": 1,
"value": 0.8666,
"id": 3627
}
],
"id": 32441
}
],
"id": 32450
}
],
"id": 370
},
{
"name": "Cash",
"rank": 2,
"value": 1.7291,
"values": [
{
"name": "Cash/Cash Equivalents",
"rank": 1,
"value": 1.7291,
"values": [
{
"name": "Cash",
"rank": 1,
"value": 1.7291,
"values": [
{
"name": "Cash",
"rank": 1,
"value": 1.7291,
"id": 29721
}
],
"id": 29861
}
],
"id": 14572
}
],
"id": 369
},
{
"name": "Other",
"rank": 3,
"value": 0.7012,
"values": [
{
"name": "Other Assets",
"rank": 1,
"value": 0.5807,
"values": [
{
"name": "Other",
"rank": 1,
"value": 0.5807,
"values": [
{
"rank": 1,
"value": 0.5807,
"id": 5750
}
],
"id": 29864
}
],
"id": 32454
},
{
"name": "Derivative",
"rank": 2,
"value": 0.1205,
"values": [
{
"name": "Structured Financials",
"rank": 1,
"value": 0.1205,
"values": [
{
"name": "Linked Notes and Deposits",
"rank": 1,
"value": 0.1205,
"id": 32383
}
],
"id": 32449
}
],
"id": 31841
}
],
"id": 372
}
]
}
]
}
]
}
],
"totalRecords": 1,
"fromIndex": 0,
"toIndex": 0,
"pageNumber": 0
}0
Answers
-
@rajanraju, It is likely an service issue at the backend database that some of the funds (e.g. ETF domiciled in Hong Kong) didn't got updated with the asset type allocations. The Industry sector allocation of these sample Hong Kong ETF are there, but yes, they missed the asset type allocations. You can raise this via client support for them to escalate that to technical team. Or you may wait to coming Monday to see if these are loaded as I believe this kind of data are loaded weekly on Eikon platform.
0 -
Many thanks. However, on Eikon the asset type allocations are being shown (my first image). So would this mean that there is another data source used by Eikon in the display? When I raised this, the Helpdesk first advised there was no excel addin to retrieve the derived data, and on my request gave the RDP endpoint.
As a separate point, the Eikon API query should have picked up the last available date ie last month. But as the result was a nan, would there be any way to find the last available asset type allocation?
0 -
@rajanraju, I guess I missed your comment earlier. But you can see my 2nd message to you showing that, yes, The newer RDP Funds API is able to provide you the asset allocations of the ETF you asked for.
0 -
@b.lee thank you. I seem to be having issues logging into the API Playground - so will get that addressed. As the RDP API has this functionality, do I need to subscribe separately for the RDP product (as you have flagged this), or as an Eikon API user, I can access this API as well. If the RDP API is able to access the data, any reason why the Eikon API is not able to access the same dataset?
0 -
@rajanraju, Firstly, focusing on the issue you are having now: if it is not that urgent, I believe you should raise that to support to get it resolved within the Eikon API platform you are using. This should be the easiest and no extra cost to you.
The Eikon API (part of the Eikon platform) is an older service and have less data and less frequent updates. The new RDP Funds API is a separate product/service requires separate fee and license. Talk to your a/c manager for details.
For using RDP Funds API, you need to subscribe a separate license for that first. You need to talk to the account manager serving you, or sales if you are talking to one of them. RDP Funds API is a REST API, once you subscribed the service, you do not need Eikon/Workspace platform to use it. You can use it as long as you have the Internet access. The RDP Funds API is part of the RDP REST API service that I am aware there is Python library to help you to login. But actually you do not really need it as all you need is HTTPS connection to the services. I got it working using Python and also Node.js.
1
Categories
- All Categories
- 6 AHS
- 39 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 60 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛