For a deeper look into our DataScope Select REST API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials

question

Upvotes
Accepted
thien.pham avatar image
4 ●0 ●1 ●2

Simple way to get Open Price for securities using DataScope?

Hi,

I am using DataScope and would need to get the open price for various securities (equities, bonds etc).

Rather than extracting historic raw ticks around the time range when the exchange opens and retrieving the very first valid tick, is there a FID that would represent the open price for that security throughout the day? Or do I need to use a different report template other than historic raw ticks?

Any advice and sample code would be appreciate.

Thanks in advance.

TP

dss-rest-apidssdatascope-selecttick-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.

1 Answer

Upvote
Accepted
Christiaan Meihsl avatar image
13.7k ●26 ●8 ●12

@3ea68ad4-ed61-470f-8598-5b20a01d18c7,

My answer assumes you are a DSS customer, and not a TRTH customer (both products use the same servers, which sometimes generates confusion).

  1. Field "Open Price" of the TimeSeriesExtractionRequest delivers the Open Price for any date range you want. This is described in DSS REST API Tutorial 4.
  2. Field "Open Price" of the EndOfDayPricingExtractionRequest delivers the Open Price for the preceding day, but will not deliver anything further back in history. This is described in DSS REST API Tutorial 2.

These 2 tutorials use On Demand requests, but you can also use scheduled requests, by choosing the corresponding templates. DSS REST API Tutorial 10 describes this for an End of Day Pricing request, following that you can easily make a Time Series extraction request.

If per chance you are a TRTH customer, then you should look at field "Open" of the ElektronTimeseriesExtractionRequest, it delivers the Open Price for any date range. This is described in TRTH REST API Tutorial 7.

Does this help ?

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.

thien.pham avatar image thien.pham

Thanks Christiaan, I am indeed a DSS customer hence will follow the sample code for TimeSeriesExtractionRequest to get backdated open prices as you have advised.

TP