Hi @bill39

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

You are mostly exceeding the limitation (10000 records per API call)

I do not know what is inside your lists('Inv Trust List').

Assuming that it is a large list as you mentioned and it may be a culprit.

So you can split them into a smaller list per API call.

Here is a modified code to break the list down into multiple smaller groups.

Please note that I added the time package (import time)

#import packages
import eikon as ek # the Eikon Python wrapper package
import pandas as pd
import numpy as np
import datetime
import time
from datetime import timedelta, date, datetime
from pandas.tseries.offsets import BDay
 
ek.set_app_key('xxxxxxxxxxxxxxxxxxxxx')

#assuming that these are RIC code in ric_list, in your program, it reads from lists
ric_list = ['AAL.L','ABF.L','ADML.L','AHT.L','ANTO.L','AV.L','AZN.L','BAES.L']

#split them into a group of 'ric_per_call' into array_ric_list
ric_per_call = 3 #change to any number of RIC per API call
array_ric_list = []
i = 0
while i < len(ric_lists)/ric_per_call:
    array_ric_list.append(ric_lists[i*ric_per_call:(i+1)*ric_per_call])
    i += 1


#loop API call between groups of RIC
end_date = date.today()
start_date = end_date - timedelta(days=365)

end_date_str = datetime.strftime(end_date, "%Y-%m-%d")
start_date_str = datetime.strftime(start_date, "%Y-%m-%d")

todays_date = date.today()
todays_date_str = datetime.strftime(todays_date, "%Y%m%d")

addHeader = True #this variable to addHeader to csv just one time

for riccodes in array_ric_list:
    print("API calls for:",riccodes)
    df, e = ek.get_data(riccodes,
                    ['TR.RNSFilerName','TR.RNSAnnouncedDate','TR.RNSTransactionType',
                     'TR.RNSARNumShrsTransacted','TR.RNSARPctOSTransacted',
                     'TR.RNSARTransactionPrice','TR.RNSARMktValTransaction',
                     'TR.RNSARTotShrsPostTrans','TR.RNSARPctOSPostTrans'])

    df['RNS Announced Date'] = pd.to_datetime(df['RNS Announced Date'])
    mask = (df['RNS Announced Date'] > start_date_str) & (df['RNS Announced Date'] <= end_date_str)
    df = df.loc[mask]

    df.rename(columns={'RNS AR Price (at Transaction) - £': 'RNS AR Price (at Transaction) GBP',
                       'RNS AR Market Value of Transaction - £': 'RNS AR Market Value of Transaction - GBP'},
              inplace=True)

    if addHeader:
        df.to_csv('Daily API Download_' + todays_date_str + '.csv', header=True)
        addHeader=False #Only add header one time
    else:
        df.to_csv('Daily API Download_' + todays_date_str + '.csv', mode='a', header=False)
    
    time.sleep(5) #delay between each API call

print('Done')

Here is the result:

API calls for: ['AAL.L', 'ABF.L', 'ADML.L']
API calls for: ['AHT.L', 'ANTO.L', 'AV.L']
API calls for: ['AZN.L', 'BAES.L'] Done

Hello @bill39

Please refer to this question as it is similar.