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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
1 2 2 6

Futures and Options Search using RICRoot

In the DSS GUI, you can perform a Futures and Options Search using a RICRoot, e.g. FFI (FTSE Index futures on LIFFE). This returns a list of the current individual contract RICs (FFIZ7, FFIH8, FFIM8, FFIU8 in November 2017) and the continuity RICS (FFIc1, FFIc2 etc).

Which DSS REST API request performs this type of search?

dss-rest-apidssdatascope-selectsearch
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
Accepted
56k 145 45 65

It should be Search/FuturesAndOptionsSearch with this payload in the body.

{
    "SearchRequest": {
        "FileCodes": null,
        "CurrencyCodes": null,
        "ExchangeCodes": null,
        "IdentifierType": "RICRoot",
        "Identifier": "FFI",
        "PreferredIdentifierType": "Ric"
    }
}

The response is:

...
 {
            "Identifier": "FFIcv1",
            "IdentifierType": "Ric",
            "Source": "IEU",
            "Key": "VjF8MHgwMDAzZjgwMGNhODg0ZmY2fDB4MDAwM2Y4MDBjYTg4NjFkOHxJRVV8RFZRVXxGVVR8fER8fEZGSWN2MXw1NTk5",
            "Description": "LIFFE FTSE 100 Idx cv1",
            "InstrumentType": "DerivativeQuote",
            "Status": "Valid"
        },
        {
            "Identifier": "FFIcoi1",
            "IdentifierType": "Ric",
            "Source": "IEU",
            "Key": "VjF8MHgwMDAzZjgwMGNhODg1MWU4fDB4MDAwM2Y4MDBjYTg4NjJkYnxJRVV8RFZRVXxGVVR8fER8fEZGSWNvaTF8NTU5OQ",
            "Description": "LIFFE FTSE 100 Idx coi1",
            "InstrumentType": "DerivativeQuote",
            "Status": "Valid"
        },
...

For more information regarding other FuturesAndOptionsSearch parameters, please refer to REST API Reference Tree.

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
1 2 2 6

Jirapongse, thank you very much for your reply to my post re FuturesAndOptionsSearch. However, I see there is a difference between this API response and waht I assume is the equivalent Search in the DSS GUI. In the DSS GUI I receive the currency and the expiry date for the futures contracts (the fixed contract futures RICs like "FFIH8").

Is it possible to get these fields in the response as per the DSS GUI? I looked at the API Reference Tree, but I cannot see a way to specify a more verbose response to include the currency and expiry date.

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
56k 145 45 65

You need to send another request to get the expiration date.

For example, you can use TermsAndConditionsExtractionRequest to get the expiration date and asset sub type. The endpoint is Extractions/Extract.

The body in the request could be:

{
    "ExtractionRequest": {
        "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TermsAndConditionsExtractionRequest",
        "ContentFieldNames": [
           "RIC", "Expiration Date", "Asset SubType"
        ],
        "IdentifierList": {
            "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [
             {"Identifier": "FFIc1", "IdentifierType" : "Ric"},
			 {"Identifier": "FFIc2", "IdentifierType" : "Ric"},
			 {"Identifier": "FFIc3", "IdentifierType" : "Ric"},
			 {"Identifier": "FFIM8", "IdentifierType" : "Ric"},
			 {"Identifier": "FFIH8", "IdentifierType" : "Ric"}
            ]
        }
    }
}

The result is:

{
    "@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#Collection(ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.ExtractionRow)",
    "value": [
        {
            "IdentifierType": "Ric",
            "Identifier": "FFIc1",
            "RIC": "FFIc1",
            "Expiration Date": null,
            "Asset SubType": "FUT"
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "FFIc2",
            "RIC": "FFIc2",
            "Expiration Date": null,
            "Asset SubType": "FUT"
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "FFIc3",
            "RIC": "FFIc3",
            "Expiration Date": null,
            "Asset SubType": "FUT"
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "FFIM8",
            "RIC": "FFIM8",
            "Expiration Date": "2018-06-15",
            "Asset SubType": "FUT"
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "FFIH8",
            "RIC": "FFIH8",
            "Expiration Date": "2018-03-16",
            "Asset SubType": "FUT"
        }
    ]
}
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.