question

Upvotes
Accepted
1 3 4 7

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

{
  "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

dss-rest-apitick-history-rest-api
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.

use the ElektronTimeseriesExtractionRequest to get the settlement price

1 Answer

Upvotes
13.7k 26 8 12

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

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.

thank u very much

hi,Christiaan Meihsl

how to know if the insturment has the settlement price?

thank u

cheng

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