question

Upvotes
Accepted
89 9 16 18

no expiration date, what's wrong in the code?

I use code and RIC: ESM0m or 1UROZ0m

Why is there no expiration date?

Automation cannot be done because of this problem.

Historic RIC: ESM0m or 1UROZ0m

help me, please

code:

                        var extractionDatesResult = ExtractionsContext.Extract(
                            new HistoricalReferenceExtractionRequest
                            {
                                ContentFieldNames = new DssCollection<string>()
                                {
                                    "RIC", "Start date", "Change Date", "Expiration Date"
                                },

                                Condition = new HistoricalReferenceCondition
                                {
                                    StartDate = result.FirstDate,
                                    EndDate = result.LastDate
                                },

                                IdentifierList = new InstrumentIdentifierList
                                {
                                    InstrumentIdentifiers = new[]
                                    {
                                        InstrumentIdentifier.Create(result.IdentifierType, result.Identifier)
                                    },
                                    ValidationOptions = new InstrumentValidationOptions
                                    {
                                        AllowHistoricalInstruments = true
                                    },
                                    UseUserPreferencesForValidationOptions = false
                                }
                            });

                        dynamic srcLastDate = null;
                        foreach (var content in extractionDatesResult)
                            foreach (var prop in content.DynamicProperties)
                            {
                                Console.WriteLine("{0}\t {1},\r", prop.Key, prop.Value);
                                if (srcLastDate == null && prop.Key == "Expiration Date" && prop.Value != null) srcLastDate = prop.Value;
                            }
tick-history-rest-apiexpiration
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.

Upvote
Accepted
30.2k 34 11 17

Hello @s61670,

I can confirm that I see the same result, for these instruments, with HistoricalReferenceExtractionRequest.

I would suggest, if you are looking to extract content for historical instruments, by requesting them within dates when they were available, to use HistoricalSearch, for this purpose, instead:

{ {protocol}}{ {host}}{ {api}}Search/HistoricalSearch

{
  "Request": {
    "Identifier": "1UROZ0m",
    "IdentifierType": "Ric",
    "Range": {
      "Start": "2008-01-01T00:00:00.000Z",
      "End": "2021-01-01T00:00:00.000Z"
    }
  }
}

resulting in:

{
    "@odata.context": "https://hosted.datascopeapi.reuters.com/RestApi/v1/$metadata#Collection(ThomsonReuters.Dss.Api.Search.HistoricalSearchResult)",
    "value": [
        {
            "Identifier": "1UROZ0m",
            "IdentifierType": "Ric",
            "Source": "",
            "Key": "VjF8MHgzMDAwMDAwMDAwMDAwMDAwfDB4MzAwMDAwMDAwMDAwMDAwMHx8fHx8fHwxVVJPWjBtfA",
            "Description": "Historical Instrument",
            "InstrumentType": "Unknown",
            "Status": "Valid",
            "DomainCode": "6",
            "FirstDate": "2015-12-15T00:00:00.000Z",
            "LastDate": "2020-12-19T00:00:00.000Z",
            "History": []
        }
    ]
}

However, for an authoritative answer on content availability, please contact Refinitiv Helpdesk Online -> Content -> RTH to be connected with Refinitiv content experts, directly.


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
89 9 16 18

Expiration Date null


17032021.png (3.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.