For a deeper look into our DataScope Select REST API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
37 1 0 5

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!

dss-rest-apidssdatascope-select#contentextraction
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvote
Accepted
32.2k 40 11 19

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?


icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvote
32.2k 40 11 19

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?


icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
37 1 0 5

@zoya faberov

I tried adding "Contract Month and Year" like you suggested, but it only returned "None".

Please see image below.

image.png


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!


image.png (25.0 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvote
37 1 0 5

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.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.