DSS REST API Search FuturesAndOptionsSearch getting Gold composite weekly options expiries

una.keller
una.keller Newcomer
in DSS

I want to get expiries for GC weekly options (specifically "0#GMW+", "0#GWW+" and "0#GCW+").

I usually use the datascope select search FuturesAndOptionsSearch rest api.

I use this to get expiries for Equity Options ("0#SPX*.U and "0#SPXW*.U") but it doesn't work for GC weekly options.

{
    "SearchRequest": {
        "FileCodes": null,
        "CurrencyCodes": null,
        "StrikePrice": null,
        "ExchangeCodes": ["CMX"],
        "ExpirationDate": null,
        "IdentifierType": "RICRoot",
        "Identifier": "GCW*",
        "AssetStatus": "Active",
        "FuturesAndOptionsType": "FuturesOnOptions"
    }
}

The response

{
    "@odata.context": "https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#Collection(DataScope.Select.Api.Search.FuturesAndOptionsSearchResult)",
    "value": []
}


What is the best way to get the expiries for these chainRICs? Why does the FuturesAndOptionsSearch work on some types of options and not others?


Working examples for 0#SPXW*.U

{
    "SearchRequest": {
        "FileCodes": null,
        "CurrencyCodes": null,
        "StrikePrice": null,
        "ExchangeCodes": ["OPQ"],
        "ExpirationDate": null,
        "IdentifierType": "RICRoot",
        "Identifier": "SPXW*",
        "AssetStatus": "Active",
        "FuturesAndOptionsType": "Options"
    }
}

Response:

{
    "@odata.context": "https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#Collection(DataScope.Select.Api.Search.FuturesAndOptionsSearchResult)",
    "value": [
        {
            "Identifier": "SPXWf302343500.U",
            "IdentifierType": "Ric",
            "Source": "OPQ",
            "Key": "VjF8MHgwMDEwMGIwMDJmOGMyMTNifDB4MDAxMDBiMDAyZjhiZTViOXxPUFF8RFZRVXxERVJWfE9QVHxEfHxTUFhXZjMwMjM0MzUwMC5VfDcxNjk",
            "Description": "SPXW JN3Q 4350C",
            "InstrumentType": "DerivativeQuote",
            "Status": "Valid",
            "ExchangeCode": "OPQ",
            "CurrencyCode": "USD",
            "FuturesAndOptionsType": "Options",
            "PutCallCode": "Call",
            "ExpirationDate": "2023-06-30T00:00:00.000Z",
            "StrikePrice": 4350,
            "AssetStatus": "Active"
        },
        {
            "Identifier": "SPXWr302345000.U",
            "IdentifierType": "Ric",
            "Source": "OPQ",
            "Key": "VjF8MHgwMDEwMGIwMDJmOGMyMWEwfDB4MDAxMDBiMDAyZjhiZTY4YXxPUFF8RFZRVXxERVJWfE9QVHxEfHxTUFhXcjMwMjM0NTAwMC5VfDcxNjk",
            "Description": "SPXW JN3Q 4500P",
            "InstrumentType": "DerivativeQuote",
            "Status": "Valid",
            "ExchangeCode": "OPQ",
            "CurrencyCode": "USD",
            "FuturesAndOptionsType": "Options",
            "PutCallCode": "Put",
            "ExpirationDate": "2023-06-30T00:00:00.000Z",
            "StrikePrice": 4500,
            "AssetStatus": "Active"
        },
...
Tagged:

Best Answer

  • raksina.samasiri
    raksina.samasiri admin
    Answer ✓

    Hi @una.keller ,

    I'm posting the resolution from the support ticket below as a reference

    In the API query used the RIC root is incorrect; hence the response has no values extracted. Please find the below RIC roots respectively and the example API request with response attached.

    Chain RIC RIC Root
    0#GMW+ GM2W
    0#GWW+ GW2W
    0#GCW+ GC3W


Answers

  • raksina.samasiri
    raksina.samasiri admin

    Hi @una.keller ,

    The moderators
    on this forum are expertise on Refinitiv APIs usage. However, they do not have
    deep expertise in every type of content available through Refinitiv products.
    Such expertise is available through Refinitiv Helpdesk, which can be reached
    via MyRefinitiv. To be of help, ticket number 12640612 was raised on your
    behalf and the support team is going to contact you soon to assist with this.

    Hope this helps
    and please let me know in case you have any further questions

  • una.keller
    una.keller Newcomer
    https://community.developers.refinitiv.com/discussion/comment/105885#Comment_105885
    @raksina.samasiri thank you for raising a ticket for me!
  • una.keller
    una.keller Newcomer

    For other looking for an answer, you can use Extractions to get the same data for expired options

    https://selectapi.datascope.refinitiv.com/RestApi/v1/Extractions/ExtractWithNotes


    {"ExtractionRequest": {
            "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.HistoricalReferenceExtractionRequest",
            "ContentFieldNames": [
               "RIC", "Security Description", "Put Call Flag", "Expiration Date",  "Strike Price"
            ],
            "IdentifierList": {
                "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
                "InstrumentIdentifiers": [
                    { "Identifier": "0#GWW+", "IdentifierType": "ChainRIC" }
                ],
                "ValidationOptions": {"AllowHistoricalInstruments": true},
                "UseUserPreferencesForValidationOptions": false
            },
            "Condition": {
                "ReportDateRangeType": "Range",
                "QueryStartDate": "2023-12-01",
                "QueryEndDate": "2023-12-31"
            }
        }
    }


Categories