Retrieving RIC Contract Year and Month
Hello,
I was wondering if there are "ContentFieldNames" for contract year and month? Using [second last, last] characters in the RIC for [month, year] is sometimes unreliable for me, since I have instruments that expire in 10+ years (e.g. NGZ34 for natural gas December 2034). I would prefer not to implement my own parsing logic if not necessary.
Using "Expiration Date" isn't plausible either. For example, CLZ2 (light crude December 2022) expires 2022-11-21.
Sample Query:
{"ExtractionRequest": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TermsAndConditionsExtractionRequest",
"ContentFieldNames": [
"RIC", "RIC Root", "Underlying RIC", "Security Description", "Periodicity",
"First Trading Date", "First Notice Day", "Last Trading Day", "Expiration Date"],
"IdentifierList": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{
"Identifier": "0#CL:",
"IdentifierType": "ChainRIC"
}
]
}
}
}
Thanks!
Best Answer
-
Hello @jacktan ,
Considering the difference in the results that you observe, and there are a couple of possible explanations to the different result with the exact same request, that I can think of:
1. Permissions could be different. You could run the same request via DSS GUI and to see if you are able to obtain the complete result. I suggest to open a support ticket with DSS support via Refinitiv Helpdesk Online -> Product -> DSS to verify that your user ID is permissioned to retrieve this field for this chain.
2. Are you testing the request with a naked request via Postman or via custom code? If from custom code, after you are confirmed to be permissioned for the field, I would test with Postman "naked" request to avoid any potential code discrepancy causing the lack of the result. Please refer to Postman tutorial REST API Tutorial 7: On Demand T&C extraction and starter Postman request collection can be downloaded from DSS REST Downloads to enable a quick test.
Let us know how this works on your side and if we could be of more help?
1
Answers
-
Hello @jacktan ,
Try with:
{"ExtractionRequest": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TermsAndConditionsExtractionRequest",
"ContentFieldNames": [
"RIC", "RIC Root", "Underlying RIC", "Security Description", "Periodicity",
"First Trading Date", "First Notice Day", "Last Trading Day", "Expiration Date","Contract Month and Year"],
"IdentifierList": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{
"Identifier": "0#CL:",
"IdentifierType": "ChainRIC"
}
]
}
}
}Results should look like:
...
{
"IdentifierType": "ChainRIC",
"Identifier": "0#CL:",
"RIC": "CLZ2",
"RIC Root": "CL",
"Underlying RIC": null,
"Security Description": "LIGHT CRUDE DEC2",
"Periodicity": "M",
"First Trading Date": "2013-11-20",
"First Notice Day": "2022-11-23",
"Last Trading Day": "2022-11-21",
"Expiration Date": "2022-11-21",
"Contract Month and Year": "DEC2022"
},
...Is this what you are looking for?
1 -
I tried adding "Contract Month and Year" like you suggested, but it only returned "None".
Please see image below.
My request to "/Extractions/ExtractWithNotes":
{"ExtractionRequest": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TermsAndConditionsExtractionRequest",
"ContentFieldNames": [
"RIC", "Contract Month and Year", "Security Description",
"First Trading Date", "First Notice Day", "Last Trading Day", "Expiration Date"],
"IdentifierList": {
"@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [
{
"Identifier": "0#CL:",
"IdentifierType": "ChainRIC"
}
]
}
}
}Thanks!
0 -
After raising a ticket with a product specialist, this was the final verdict:
'Contract Month and Year' field is not supported for Tick History users. As an alternative you may use the Expiry date field in 'Historical Reference' and 'Elektron Time Series' report templates.
1
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 中文论坛