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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
gthompson6 avatar image
5 ●0 ●0 ●1

Why is get_timeseries using Eikon API not pulling the full price history?

Hi, when pulling a time series for the FTSE 250 consituents. I am not getting a full price history. Any ideas would be greatly appreciated as the request seems comfortably below the limit. Thanks.


constituents = ek.get_data('.FTMC', ['TR.IndexConstituentRIC' , 'TR.IndexConstituentName'], {'SDate':'2019-01-01'})[0]

rics = constituents['Constituent RIC']

df = ek.get_timeseries(list(rics), fields='CLOSE', start_date='2016-03-12', end_date='2019-03-12', corax='adjusted',calendar='tradingdays')

df.shape

the result is (12, 250)

Whereas there were 758 trading days in the period requested

ek.get_timeseries('.FTMC', fields='CLOSE', start_date='2016-03-12', end_date='2019-03-12', corax='adjusted',calendar='tradingdays').shape

the result is (758,1)

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythontime-series
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.

2 Answers

Upvote
Accepted
chavalit-jintamalit avatar image
18k ●21 ●12 ●20

Hi @gthompson6

Please refer to the API limitation document at https://developers.refinitiv.com/eikon-apis/eikon-data-api/docs?content=49692&type=documentation_item


Yes, the interday timeseries is limited to 3000 records per API call.

You should break down your 'rics' list into a smaller list per request, or you can reduce the period.

Please do note that there is also a limitation of 5 API calls per second and 5GB amount of data per day.


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.

Upvotes
gthompson6 avatar image
5 ●0 ●0 ●1

Actually, I've noticed 12 * 250 = 3000. So it is the API request limit?

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