How many data points can we receive using eikon python api (get_data) per requests and it's error...

... handling?

As in the documentation suggests 10K datapoints per requests but what will happen if the requests will provide more than 10k cells does it throws as error or will it simply give us a None value?

main_data,error = ek.get_data(RICS_lists,Required_fields,{'SDate':str(0), 'EDate':str(-len(date_index)+1), 'Frq':str(Frequency),'Period':str(Period),'ConsolBasis':str(ConsolBasis)})

From this line of code, I am trying to fetch data for 340 RICs from 2009 till present on a monthly frequency FOR fields (TR.Revenue, TR.Revenue.calcdate)

So the Total Number of Datapoints will be (137*340) or 2*(137*340)?

Since the total number of Cells is above 10K points this line of code doesn't give me an error.

Will this request truncate/remove the data points just to be in the limit?

Find more posts tagged with

python

eikon

workspace

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

Jirapongse

@abhichikara

Refer to this thread, the get_data limitation isn't applied in the latest version. We will update the guideline.

From my test, I can get more than 10K datapoints.

data1,err = ek.get_data('0#.NDX',['TR.RIC']) data3 = ek.get_data(data1['RIC'][0:15].tolist(),['TR.ClosePrice.Date','TR.ClosePrice'], {'Sdate':'1990-01-01', 'EDate':'2019-12-17'})    data3[0].dropna()

All comments

pimchaya.wongrukun01

Hello @abhichikara

Please refer to section What happens when a limit is reached? in Eikon Data API Usage and Limits Guideline

abhichikara

As I indicated in the question I am requesting a call that will provide me points above the data points limits yet it's not giving me an error.

Jirapongse

@abhichikara

Refer to this thread, the get_data limitation isn't applied in the latest version. We will update the guideline.

From my test, I can get more than 10K datapoints.

data1,err = ek.get_data('0#.NDX',['TR.RIC']) data3 = ek.get_data(data1['RIC'][0:15].tolist(),['TR.ClosePrice.Date','TR.ClosePrice'], {'Sdate':'1990-01-01', 'EDate':'2019-12-17'})    data3[0].dropna()

EXPLORE OUR SITES