how to use the ElektronTimeseriesExtractionRequest to get the open price,settlement price

@lei.cheng,

First of all, there are several issues with your call, it will fail:

• Comma after the "]" just after the InstrumentIdentifiers declaration must be removed
• The ElektronTimeSeries extraction request does not deliver those 3 price fields, the correct field names are: "High", "Open", "Low"
• The Condition must include this: "ReportDateRangeType": "Range",

I changed the call to this to have it run without error:

{
  "ExtractionRequest": {
    "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.ElektronTimeseriesExtractionRequest",
    "ContentFieldNames": [
      "Settlement Price", "Volume", "High", "Open", "Low"
    ],
    "IdentifierList": {
      "@odata.type": "#ThomsonReuters.Dss.Api.Extractions.ExtractionRequests.InstrumentIdentifierList",
      "InstrumentIdentifiers": [{ "Identifier": "CMAL3", "IdentifierType":"Ric" }]
    },
    "Condition": {
      "ReportDateRangeType": "Range",
      "QueryStartDate": "2017-01-01T00:00:00.000Z",
      "QueryEndDate": "2018-08-30T00:00:00.000Z"
    }
  }
}

This ran, and delivered all fields except the Settlement price, which was always empty (even though I extended the date range to start in Jan 2017).

Explanation: that is simply because there is no settlement price for instrument CMAL3, which is a commodity future. Try an equity (for instance CARR.PA), you will get Settlement Price values.

@lei.cheng,

This forum is for software developers using Thomson Reuters APIs, and technical discussions. For data content query like this one, the best and speediest way to receive an answer is to open a content-related enquiry via My Account or to call the Thomson Reuters Help Desk directly.