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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
9.7k 49 38 60

get_data() throws an exception when specifying certain dates

The scripting API method call: get_date() provides the ability to retrieve historical data using a date range as an optional parameter specification. The following request will return valid rows of data.

df,err = tr.get_data('.SPX', ['TR.PriceClose'], parameters={'SDate':'1970-01-01','EDate':'1970-01-04'})

When going back further in time, it appears for the above requested instrument, the data is available only until Jan 1, 1970. This can be further observed when requesting for the same data years earlier.

The above request doesn't have any historical data for the date range specified. Although it returns one row with a NaN as the value, I'm assuming this implies no data. However, I would expect such a result to occur if I continue to go back in time. Instead, if I continue to go back in years, I can reach a point where my specified date results in an exception being thrown.

I would expect no data to be returned, or something similar to the above request. Not an exception.

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonexception
img2.png (7.0 KiB)
img3.png (45.8 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.

1 Answer

Upvotes
Accepted
4.3k 2 4 5

OK, I reproduce the issue and confirm that the back-end reject request referring to data before 1950. I'm going to escalate the issue.

You can retrieve Close with the get_timeseries function (values are available since 1928):

Take care to the limit of maximum of 3000 rows, and adjust the date range so as not to reach it (otherwise, result is aligned with end_date):


example1.jpg (26.8 KiB)
example2.jpg (26.5 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.

Click below to post an Idea Post Idea