For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
@paul67 The reason it is doing this is because of API limits. You can find out more information about API limits here. In the case of get_timeseries the limit is 3000 rows for interday. Hence why your return is being truncated. You can call the service iteratively per RIC or chunk of RICs that conform to the limits. The other thing with your query is that you didn't specify a field so you could get Open, High, Low, Close, Volume by default - if you only want Close - just specify that field.
Try this:
start='2016-08-01' end='2020-09-11' ts = pd.DataFrame() df = pd.DataFrame() instruments = ['EURCBS3M=ICAP', 'EURCBS6M=ICAP','EURCBS9M=ICAP','EURCBS1Y=ICAP','EURCBS18M=ICAP','EURCBS2Y=ICAP'] for r in instruments: try: ts = ek.get_timeseries(r,'CLOSE',start_date=start,end_date=end,interval='daily') ts.rename(columns = {'CLOSE': r}, inplace = True) if len(ts): df = pd.concat([df, ts], axis=1) else: df = ts except: pass df
I hope this can help.