Is there any other way to identify RICs for Fix Income instruments via TRTH v2 API?

Since we currently cannot use Fix Income's ISIN, CUSIP or SEDOL in the historical search for RIC mapping. The client has the following question, “Is there any other way to identify RICs for Fix Income instruments via API?”
Could you please look into it and provide an update?
Best Answer
-
You can use "Historical Criteria Search" to find Fixed Income RICs
For example; you can Search by maturity Date range.
Request:
POST https://hosted.datascopeapi.reuters.com/RestApi/v1/Search/HistoricalCriteriaSearch HTTP/1.1
Authorization: Token <your_auth_token_goes_here>
Prefer: respond-async
Content-Type: application/json; odata=minimalmetadata
{
"Request": {
"BondTypeCodes": null,
"ContributorIds": null,
"CountryCodes": null,
"CurrencyCodes": null,
"ExchangeCodes": null,
"FutureMonthCodes": null,
"InstrumentTypeCodes": null,
"OptionMonthCodes": null,
"OptionTypeCodes": null,
"CouponRate": {
"Min": 30
},
"StrikePrice": null,
"ExpiryDate": null,
"MaturityDate": {
"Start": "2016-09-01T00:00:00.000Z",
"End": "2016-09-30T23:59:59.000Z"
},
"Range": {
"Start": "2015-09-30T00:00:00.000Z",
"End": "2016-09-30T00:00:00.000Z"
}
}
}Response
HTTP/1.1 200 OK
{
"@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#Collection(ThomsonReuters.Dss.Api.Search.HistoricalSearchResult)",
"value": [
{
"Identifier": "984308CM6=RRPS",
"IdentifierType": "Ric",
"Source": "",
"Key": "VjF8MHgzMDAwMDAwMDAwMDAwMDAwfDB4MzAwMDAwMDAwMDAwMDAwMHx8fHx8fHw5ODQzMDhDTTY9UlJQU3w",
"Description": "Historical Instrument",
"InstrumentType": "Unknown",
"Status": "Valid",
"DomainCode": "6",
"FirstDate": "2015-11-26T00:00:00.000Z",
"LastDate": "2016-09-28T00:00:00.000Z",
"History": [
]
},
{
"Identifier": "AAHA2YEUAM=MP",
"IdentifierType": "Ric",
"Source": "",
"Key": "VjF8MHgzMDAwMDAwMDAwMDAwMDAwfDB4MzAwMDAwMDAwMDAwMDAwMHx8fHx8fHxBQUhBMllFVUFNPU1QfA",
"Description": "Historical Instrument",
"InstrumentType": "Unknown",
"Status": "Valid",
"DomainCode": "6",
"FirstDate": "2007-08-25T00:00:00.000Z",
"LastDate": "2016-11-23T00:00:00.000Z",
"History": [
]
},
{
"Identifier": "AAHR1YGBAL=MP",
"IdentifierType": "Ric",
"Source": "",
"Key": "VjF8MHgzMDAwMDAwMDAwMDAwMDAwfDB4MzAwMDAwMDAwMDAwMDAwMHx8fHx8fHxBQUhSMVlHQkFMPU1QfA",
"Description": "Historical Instrument",
"InstrumentType": "Unknown",
"Status": "Valid",
"DomainCode": "6",
"FirstDate": "2014-09-20T00:00:00.000Z",
"LastDate": "2016-11-23T00:00:00.000Z",
"History": [
]
},
{
"Identifier": "AAHR1YUSAL=MP",
"IdentifierType": "Ric",
"Source": "",
"Key": "VjF8MHgzMDAwMDAwMDAwMDAwMDAwfDB4MzAwMDAwMDAwMDAwMDAwMHx8fHx8fHxBQUhSMVlVU0FMPU1QfA",
"Description": "Historical Instrument",
"InstrumentType": "Unknown",
"Status": "Valid",
"DomainCode": "6",
"FirstDate": "2014-09-20T00:00:00.000Z",
"LastDate": "2016-11-23T00:00:00.000Z",
"History": [
]
}
•••
]
}Please see this tutorial for more info.
https://developers.thomsonreuters.com/thomson-reuters-tick-history-trth/thomson-reuters-tick-history-trth-rest-api/learning?content=13755&type=learning_material_item0
Answers
-
Hello @Warat B.
Thanks for the solution, while it seems to work I was not able to extract the RIC for the instrument FR0011138742. Could you check if the instrument is valid?
Maturity data range :
{ "Start": "2017-06-10T00:00:00.000Z", "End": "2017-06-11T00:00:00.000Z" } } }
0 -
The RIC is <FR0011138742=>
"FR0011138742" Maturity Date is 2018-12-06
Which means you have to use this range.
"MaturityDate": {
"Start": "2018-12-06T00:00:00.000Z",
"End": "2018-12-06T23:59:59.999Z"
},0 -
Thanks for all the help.
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
- 690 Datastream
- 1.4K DSS
- 629 Eikon COM
- 5.2K Eikon Data APIs
- 11 Electronic Trading
- 1 Generic FIX
- 7 Local Bank Node API
- 3 Trading API
- 2.9K Elektron
- 1.4K EMA
- 255 ETA
- 559 WebSocket API
- 39 FX Venues
- 15 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 25 Messenger Bot
- 3 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 60 Open Calais
- 279 Open PermID
- 45 Entity Search
- 2 Org ID
- 1 PAM
- PAM - Logging
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 23 RDMS
- 2K Refinitiv Data Platform
- 716 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
- 106 UPA
- 194 TREP Infrastructure
- 229 TRKD
- 918 TRTH
- 5 Velocity Analytics
- 9 Wealth Management Web Services
- 95 Workspace SDK
- 11 Element Framework
- 5 Grid
- 19 World-Check Data File
- 1 Yield Book Analytics
- 48 中文论坛