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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
1 0 0 1

(DSS REST API help) Using Futures and Options, I need closing price over the next few months

Used POST request,
https://selectapi.datascope.refinitiv.com/RestApi/v1/Search/FuturesAndOptionsSearch

And request body is

{
    "SearchRequest": {
        "FileCodes": null,
        "CurrencyCodes": null,
        "ExchangeCodes": null,
        "StrikePrice": null,
        "ExpirationDate": null,
        "IdentifierType": "Ric",
        "Identifier": "SB*",
        "PreferredIdentifierType": "Ric"
    }
}




Sample output obtained is

{
    "@odata.context": "https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#Collection(DataScope.Select.Api.Search.FuturesAndOptionsSearchResult)",
    "value": [
        {
            "Identifier": "SB-6=R",
            "IdentifierType": "Ric",
            "Source": "TRC",
            "Key": "VjF8MHgwMDEwMGIwMDBhYjg0YjQxfDB4MDAxMDBiMDAwYWI4NGI0MHxUUkN8RFZRVXxERVJWfEZVVHxEfHxTQi02PVJ8NjAxMA",
            "Description": "IUS Sugar No.11 6 Month Electronic Commodity Spread Contract",
            "InstrumentType": "DerivativeQuote",
            "Status": "Valid",
            "ExchangeCode": "TRC",
            "CurrencyCode": "USc",
            "FuturesAndOptionsType": "Futures",
            "PutCallCode": "",
            "AssetStatus": "Active"
        },
        {
            "Identifier": "SB-1=R",
            "IdentifierType": "Ric",
            "Source": "TRC",
            "Key": "VjF8MHgwMDEwMGIwMDBhYjg0YjY3fDB4MDAxMDBiMDAwYWI4NGI2NnxUUkN8RFZRVXxERVJWfEZVVHxEfHxTQi0xPVJ8NjAxMA",
            "Description": "ICE US Sugar No 11 1 Month Electronic Spread",
            "InstrumentType": "DerivativeQuote",
            "Status": "Valid",
            "ExchangeCode": "TRC",
            "CurrencyCode": "USc",
            "FuturesAndOptionsType": "Futures",
            "PutCallCode": "",
            "AssetStatus": "Active"
        }
}


I am looking for this kind of data (This sample is from NYB exchange website).
I need latest price for the day, Open, High and Low.

image_50_1_50.png
image-50-1-50.png


Does not matter, even If we have to call multiple Rest APIs, can we get the tabular data like above image ?


-Raghu

#technologydss-rest-api#contentfutures
image-50-1-50.png (185.5 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.

1 Answer

· Write an Answer
Upvotes
Accepted
81.3k 267 53 76

@raghu.icecraft

Thanks for reaching out to us.

You need to know which report templates that can be used to extract the required data. You can refer to the Refinitiv DataScope Select Data Content Guide which provides definitions of all of the data fields available in DataScope Select.

You can try EndOfDayPricingExtractionRequest, IntradayPricingExtractionRequest, or CompositeExtractionRequest.

For example, the CompositeExtractionRequest looks like this:

{
    "ExtractionRequest": {
        "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.CompositeExtractionRequest",
        "ContentFieldNames": [
            "Open Price",
            "High Price",
            "Low Price",
            "Close Price"
        ],
        "IdentifierList": {
            "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [
                {
                    "Identifier": "SB-6=R",
                    "IdentifierType": "Ric"
                },
                {
                    "Identifier": "SB-1=R",
                    "IdentifierType": "Ric"
                }
            ]
        }
    }
}

The output looks like this:

 "Contents": [
        {
            "IdentifierType": "Ric",
            "Identifier": "SB-6=R",
            "Open Price": 0.2,
            "High Price": 0.35,
            "Low Price": 0.08,
            "Close Price": 0.29
        },
        {
            "IdentifierType": "Ric",
            "Identifier": "SB-1=R",
            "Open Price": 0.32,
            "High Price": 0.5,
            "Low Price": 0.31,
            "Close Price": 0.46
        }
    ],

The output will be in JSON format or Comma-Separated Values (CSV).

Otherwise, you can contact the Datascope Select support team directly via MyRefinitiv to ask for the report templates and fields that can provide the required data.

I hope that this information is of 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.

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.