How can I do a bulk download for the list of Ric's in order to improve the time performance?
I am currently downloading underlying Ric's for a list of Ric's defined as "unique_col1":
combined_data = pd.DataFrame()
#Loop through the instruments and fetch data for each
for instrument in unique_col1:
data, err = eikon.get_data(
instrument,
fields=['TR.DRUnderlyingQuoteRic'])
# Check for errors
# if err is not None:
# print(f"Error for {instrument}: {err}")
# else:
df = pd.DataFrame(data)
df['Instrument'] = instrument # Add a column to identify the instrument
combined_data = combined_data.append(df, ignore_index=True)
- I get a "Backend error. 400 bad request"
- When I do it with limitations it takes too long. I want to run it for 3000 Ric and a list of 200 Ric takes already 4 minutes
