I am using TimeSeries.SetupDataRequest and getting incomplete data

DataServices.Instance.TimeSeries.SetupDataRequest(security.Ticker.ToUpper())
                .From(startDate)
                .To(endDate).WithAllFields()
                .WithTimeZone(TimezoneType.GMT)
                .WithInterval(CommonInterval.TradeAndQuotes)
                .WithNumberOfPoints(999999)
                .OnDataReceived(DataReceivedCallback1)
                .OnStatusUpdated(StatusUpdatedCallback)
                .CreateAndSend();

For a single day I am getting incomplete data.

I have to do it in 1 hour chunks which takes forever!

Find more posts tagged with

python

eikon

api

time-series

trade

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

Zhenya Kovalyov

@293b571b-7462-4aaa-b8e5-e0528f0fae86_deprecated_84a0d5d5-d4cd-4aa9-b45a-7daa4c1787d0 Hi Jonathan,

60,000 items per request is a hard limit set on the .NET Time series API at the moment. Desktop usage workflow implies that this is more than enough, and in no way is able to handle 1,000,000 TasTaq data per request. So, you can either create multiple requests to get this data, or use an enterprise product (like Thomson Reuters Tick History) which has a REST API and is able to handle such volumes.

Let me know if you require any additional info on this.

All comments

Zhenya Kovalyov

@293b571b-7462-4aaa-b8e5-e0528f0fae86_deprecated_84a0d5d5-d4cd-4aa9-b45a-7daa4c1787d0 could you please provide more details on this?

What instruments are you requesting the data for? Can you give an example RIC?
What are the values of the startDate and the endDate?
What do you mean by incomplete data? Can you give an example?

Thanks!

unknown

aapl-example-traedes-and-quotes.zipThank you Zhenya, by the way - I speak Russian.

This is true for every ticker I can think of including AAPL.O

I am attaching an example file of incomplete data for AAPL.

In this example I requested data for 12/7/2018 from 12:00:00 to 23:59:59

I only got data from 15:52 to 16:02 (when the market closed)

What happened to 12:00:00 - 15:52:00 ?

It seems that the set limit of data points of 60,000 is ludicrous and completely unusable as there are usually well over 1,000,000 trades/quotes per day on any given day.

Zhenya Kovalyov

@293b571b-7462-4aaa-b8e5-e0528f0fae86_deprecated_84a0d5d5-d4cd-4aa9-b45a-7daa4c1787d0 Hi Jonathan,

Let me know if you require any additional info on this.

Zhenya Kovalyov

@293b571b-7462-4aaa-b8e5-e0528f0fae86_deprecated_84a0d5d5-d4cd-4aa9-b45a-7daa4c1787d0 to get a predictable result, I suggest you use either startDate and WithNumberOfPoints, or the endDate and WithNumberOfPoints. This way you can control the size of the output.

EXPLORE OUR SITES