For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
11 1 2 4

get_timeseries() pulls intraday data even if interval is daily

We have developed python code that pulls daily oil and natural gas data every Thursday. However, a couple of weeks ago, the code started pulling intraday data before the market closed. This had not occurred before and caused some problems with our content.

The dummy example below pulls intraday values for Thursday. However, in prior reports, the Thursday's intraday was not pulled. Nothing changed on our end including the run time, which is usually around 9:30 AM EDT.

# current date/time is 2020-10-8 9:30:00 EDT (this pulls intraday data for 10-8)
df = ek.get_timeseries('NHV21', start_date='2019-01-01', end_date='2020-10-8 9:30:00', interval=interval)

As the default interval is "daily", one would expect that the data pulled would be from 2019-01-01 - 2020-10-7 (omitting Thursday's intraday print).

Could you clarify whether interval='daily' will only pull daily settles? Or will it pull daily settles until the most recent day, then simply pull the most recent quote?

Finally, was there a change made to the API that would explain this behavior? Again, none of the code on our end was changed.

Thanks in advance.

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvote
Accepted
13k 32 12 18

Hi @michaelberk99, Your RIC NHV21 seems to be invalid, but I can replicate this behavior with other instruments.

ek.get_timeseries('IBM.N', start_date='2020-10-01', end_date='2020-10-09T09:30:00', interval='daily')

To get clarification on the data content, I would suggest that you raise a ticket with Refinitiv helpdesk and select "I need help understanding content in a product".


1602250659127.png (12.2 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Thanks for the answer! The RIC was a typo - I meant to use NGV21 in the above example. And noted I'll open the ticket now.

Click below to post an Idea Post Idea