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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
1 3 2 7

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-apidatascope-selectdsssearch
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
81.3k 266 53 76

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 3 2 7

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
81.3k 266 53 76

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.

Upvotes
1 0 0 0

I am using RDP , do you know how to get this information

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.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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