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?


Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @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()

    image


Answers