Issue to retrieve RICS list for a given bond using Refinitiv Data under C#
Dear Developer community.
i'm facing an issue to retrieve Ric list for a given ISIN by using Refinitiv Data (version beta4) under C#.
Indeed, i'm used to retieve this list using TR.RICS field with Excel and also Python (as shown below), but it doesn't work when using FundamentalAndReference module under .Net and i have no response.
i have tried to use symbology mdoule to get RUC from ISIN, but it gives only the composite RIC as best_match option (as it's the case under Python) is not available to set it to false and to get all corresponding rics for ISIN.
thank you for your help and assistance with this issue
Excel example
Python example
Best Answer
-
Thanks for reaching out to us.
The Refinitiv Data Library for .NET uses the DataGrid on RDP. I ran the following code.
var response = FundamentalAndReference.Definition().Universe("US912828X703")
.Fields("TR.RICS")
.GetData();It returned:
Reference Data
Response contains an empty data set: {
"error": {
"code": 221,
"description": "The access to field(s) denied."
}
}Did you get this error?
You may try to use the Search function instead.
var request = Search.Definition().View(Search.View.SearchAll)
.Query("US912828X703").Select("RIC").Top(100);I hope that this information is of help.
1
Answers
-
You can try using the 'Symbology' API to access these conversions. For example:
string symbolLookupEndpoint = "https://api.refinitiv.com/discovery/symbology/v1/lookup";
...
var endpoint = EndpointRequest.Definition(symbolLookupEndpoint).Method(EndpointRequest.Method.POST);
var response = endpoint.BodyParameters(new JObject()
{
["from"] = new JArray(new JObject()
{
["identifierTypes"] = new JArray("Isin"),
["values"] = new JArray("US912828X703")
}),
["to"] = new JArray(new JObject()
{
["identifierTypes"] = new JArray("RIC")
}),
["type"] = "auto"
}).GetData());1 -
dear @nick.zincone
i have a question regarding symbology service.
indeed, as some TR fields cannot be consumed using refinitiv data library under c# (ex "TR.PreferredRIC","TR.TD.PreferredRIC"), i have tried to get PreferredRIC for instruments (asked by ISIN) by using request body below and asking for "type": "predefined" and "route":"FindPrimaryRic".
but the response contains more than one ric.
is teher a way to get onbly one ric (preferred one) using symbology service.
Regards
Request Body:
{
"from": [
{
"identifierTypes": [
"Isin"
],
"values": [
"US912810TN81"
]
}
],
"type": "predefined",
"route": "FindPrimaryRic"
}
response body
{
"data": [
{
"input": [
{
"value": "US912810TN81",
"identifierType": "Isin"
}
],
"output": [
{
"value": "912810TN8=RRPS",
"identifierType": "RIC"
},
{
"value": "912810TN8=",
"identifierType": "RIC"
},
{
"value": "US30YTWI=RRPS",
"identifierType": "RIC"
}
]
}
],
"requestId": "445d9866-763d-49e0-b379-ef2a232d80b3",
"effectiveAt": "2023-04-28T15:50:00.612Z",
"messages": []
}
0 -
I would suggest you reach out to the helpdesk regarding this service. They should be able to bring in a product specialist who can confirm if the specific result can be achieved using the Symbology service. The moderators of this site would only have basic knowledge of this service.
However, you can try using the SymbolConversion interface within the library. For example:
response = SymbolConversion.Definition().Symbols("US912810TN81").GetData();
0 -
dear @nick.zincone
thank you for your response. Indeed, i used SymbolConversion to try to get PrimaryRIC/PreferredRIC for Bonds, but the response was not suitable as it not gives the suitable one
to construct this fiunction i fill in both FormSymbolType and ToSymbolType function parameters.
By using your example and not setting up FromSymbolType i get the right response.
0
Categories
- All Categories
- 6 AHS
- 37 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
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛