question

Upvotes
Accepted
7 2 1 3

How do you get the historical RIC changes for a list of symbols ?

The suggestion in this question is interesting. But I ran through weird cases :

Is there another way to exactly match the V1 "Symbology Change" request ?

Thanks

tick-history-rest-api
trth.jpg (76.1 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvote
Accepted
38.1k 69 35 53

From the update of TRTH support team, you can use TickHistoryTimeAndSalesExtractionRequest to get the Reference & Symbology Change data. The content fields are:

        {
            "Code": "THT.Reference Change - Change Type",
            "Name": "Reference Change - Change Type",
            "Description": "Reference field changed",
            "FormatType": "Text",
            "FieldGroup": "Reference & Symbology Change"
        },
        {
            "Code": "THT.Reference Change - New Value",
            "Name": "Reference Change - New Value",
            "Description": "New value as a result of the Reference change",
            "FormatType": "Text",
            "FieldGroup": "Reference & Symbology Change"
        },
        {
            "Code": "THT.Reference Change - Old Value",
            "Name": "Reference Change - Old Value",
            "Description": "Previous value in the Reference change",
            "FormatType": "Text",
            "FieldGroup": "Reference & Symbology Change"
        },

The request looks like:

{
  "ExtractionRequest": {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.TickHistoryTimeAndSalesExtractionRequest",
    "Condition": {
      "ApplyCorrectionsAndCancellations": false,
      "DisplaySourceRIC": true,
      "MessageTimeStampIn": "GmtUtc",
      "QueryEndDate": "2017-08-17T23:59:59.999Z",
      "QueryStartDate": "2014-08-17T00:00:00.000Z",
      "ReportDateRangeType": "Range"
    },
    "ContentFieldNames": [
      "Reference Change - Change Type",
      "Reference Change - New Value",
      "Reference Change - Old Value"
    ],
    "IdentifierList": {
      "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
      "InstrumentIdentifiers": [
        {
          "Identifier": "KLOV.ST",
          "IdentifierType": "Ric"
        }
      ],
      "UseUserPreferencesForValidationOptions": false,
      "ValidationOptions": {
        "AllowHistoricalInstruments": true
      }
    }
  }
}
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
5 0 2 2

Thomas - did you ever figure this out? We are trying to do the same.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea