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

lei.cheng

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

i use the above script to get the settlement price,but the system said no location.

how to get the settlement price ?

thank u

lei.cheng

use the ElektronTimeseriesExtractionRequest to get the settlement price

Christiaan Meihsl

@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.

Christiaan Meihsl

@lei.cheng, I updated my answer for open, high and low.

As stated, the settlement price seems not to be available for CMAL3. For a 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.

lei.cheng

https://community.developers.refinitiv.com/discussion/comment/31014#Comment_31014

thank u very much

lei.cheng

https://community.developers.refinitiv.com/discussion/comment/31014#Comment_31014

hi,Christiaan Meihsl

how to know if the insturment has the settlement price?

thank u

cheng

Christiaan Meihsl

https://community.developers.refinitiv.com/discussion/comment/31043#Comment_31043

@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.