I have a list of mutual funds and want to retrieve NAV data from 2000 to 2021.
While using get_timeseries, I have many errors such as this :
"2021-05-27 10:18:45,909 P [MainThread 19388] Error with LP60000031: Invalid RIC"
Here is the code I use :
funds = ['LP60000026', 'LP60000031', 'LP60000042']
NAV_EU = pd.DataFrame(index = test.index)
#index is a weekly index from 2000 to 2021 (such as in get_timeseries)
errors = 
for fund in funds :
nav = ek.get_timeseries(fund, start_date='2000-01-01', end_date='2021-05-01', interval='weekly')
NAV_EU[fund] = nav
except Exception :
#NAV_EU = np.nan
I get only nav for LP60000026 which is the only fund that survives over the period.
How could I get data for the two other funds witn Nan values when they were not existing?