Null data extracted for given RIC EUR1YO=R

{

"ExtractionRequest": {

"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TermsAndConditionsExtractionRequest",
"ContentFieldNames": [
"RIC", "Currency Code","Expiration Date","Security Description","Maturity Date",
"Strike Price","MiFID Exercise Style","Sub-Class Notional Currency Pair","FX Type - ESMA","MiFID FX Type"
,"Notional Currency 1 - DSB","Notional Currency 2"
],
"IdentifierList": {

"@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
"InstrumentIdentifiers": [

{ "Identifier": "EUR1YO=R", "IdentifierType": "Ric" }
]
}
}
}

Best Answer

  • Hi @jay416505,

    I have also found null value in various fields even there is no permission error in the Notes. This likely is related to content of the RIC. I would suggest you contact DSS Content support via MyRefinitiv to verify the result.

    "Contents": [
            {
                "IdentifierType": "Ric",
                "Identifier": "EUR1YO=R",
                "RIC": "EUR1YO=R",
                "Currency Code": null,
                "Expiration Date": null,
                "Security Description": "Euro/US Dollar 1 Year ATM Option",
                "Maturity Date": null,
                "Strike Price": null,
                "MiFID Exercise Style": null,
                "Sub-Class Notional Currency Pair": null,
                "FX Type - ESMA": null,
                "MiFID FX Type": null,
                "Notional Currency 1 - DSB": null,
                "Notional Currency 2": null
            }
        ],

Answers

  • Hi @jay416505, Are you extracting with notes; i.e. using the hosted.datascopeapi.reuters.com/RestApi/v1/Extractions/ExtractWithNotes endpoint? If so, the notes included with extraction response will indicate the reason for not providing this data.

    For e.g. in my case I get this response:

    Column 'MiFID Exercise Style' suppressed for lack of 'MiFID Reference' and 'Non-Tick History Terms and Conditions' permissions.
    Column 'Sub-Class Notional Currency Pair' suppressed for lack of 'MiFID Reference' and 'Non-Tick History Terms and Conditions' permissions.
    Column 'FX Type - ESMA' suppressed for lack of 'MiFID Reference' and 'Non-Tick History Terms and Conditions' permissions.
    Column 'MiFID FX Type' suppressed for lack of 'MiFID Reference' and 'Non-Tick History Terms and Conditions' permissions.
    Column 'Notional Currency 1 - DSB' suppressed for lack of 'MiFID Reference' and 'Non-Tick History Terms and Conditions' permissions.
    Column 'Notional Currency 2' suppressed for lack of 'MiFID Reference' and 'Non-Tick History Terms and Conditions' permissions.