Expirated Date in REST API

Carlos.solano · 2022-06-09T14:30:55+00:00

There was an error rendering this rich post.

Hi,

We are trying to export via API the formula we currently export via Excel from Eikon ((@TR(G$3:BO$3;"EXPIR_DATE";"CH=Fd RH=IN")) in order to get the ExpirateDate.

Could you please help us to know how we can get this information through REST API? As you can see in the attached file, we get as NULL this field.

Example ExpirationDate NULL.pdf

Find more posts tagged with

dss-rest-api

Accepted answers

zoya faberov

Hello @Carlos.solano ,

I suggest to contact Refinitiv content support directly, to help verify if the relevant contact can be requested with permissions that you have in place, via Refinitiv Helpdesk Online -> Help with content.

There can be another way of requesting the same information, that content experts for the product will be able to confirm.

However, if it is not available, please contact your Refinitiv account team, for help with permissions.

All comments

zoya faberov

Hello @Carlos.solano ,

From my testing, requesting one of these instruments via EOD template returns result with Expiration date that is not populated. Please also see this previous discussion thread for a relevant discussion of the same, this may have to do with the instrument type being requested.

I find, that with Terms and Conditions request type:

{{protocol}}{{host}}{{api}}Extractions/ExtractWithNotes
{
    "ExtractionRequest": {
        "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.TermsAndConditionsExtractionRequest",
        "ContentFieldNames": [
           "RIC", "CUSIP", "ISIN", "SEDOL", "Issuer OrgID", "Currency Code","Expiration Date","Issuer PermID", "Maturity Date",
"Underlying Contract Expiry Date"
        ],
        "IdentifierList": {
            "@odata.type": "#DataScope.Select.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
            "InstrumentIdentifiers": [

                 { "Identifier": "TFMBMc1", "IdentifierType": "Ric", "Source":"*" }

            ]
        }
    }
}

I see in the results "Underlying Contract Expiry Date" that appears to be the expiry date that you are looking for:

{
    "@odata.context": "https://selectapi.datascope.refinitiv.com/RestApi/v1/$metadata#DataScope.Select.Api.Extractions.ExtractionRequests.ExtractionResult",
    "Contents": [
        {
            "IdentifierType": "Ric",
            "Identifier": "TFMBMc1",
            "RIC": "TFMBMc1",
            "CUSIP": null,
            "ISIN": null,
            "SEDOL": null,
            "Issuer OrgID": null,
            "Currency Code": "EUR",
            "Expiration Date": null,
            "Issuer PermID": null,
            "Maturity Date": null,
"Underlying Contract Expiry Date": "2022-06-29"
        }
    ],
...

However, to verify if this is the optimal field to request, or there is another recommended approach to requesting the content that you are interested in, suggest to contact Refinitiv content experts directly, via Refinitiv Helpdesk Online -> Content -> DSS

Hope that this information is of help

Carlos.solano

Hi, @zoya faberov

Thanks for your answer!

As you said, It looks like the "Underlying Contract Expiry Date" is the information we're looking for, however, we don't have permission to export this field.

Please, could you give us access to the "TermsAndConditionsExtractionRequest" template in order to see this field?

Thanks in advantage!

Regardss,

Carlos.solano

I'm sorry! The usser we are testing with is 9027518.

Thank you!

zoya faberov

Hello @Carlos.solano ,

There can be another way of requesting the same information, that content experts for the product will be able to confirm.

However, if it is not available, please contact your Refinitiv account team, for help with permissions.

Quick Links

All Forums
Recent Questions

EXPLORE OUR SITES