0

I am extracting 10-year Rolling Return data from a universe of mutual funds from Eikon in the Jupyter Python environment, where some funds have partial date between the 10-year period (in this case 2012-09-30 to 2022-08-31) such as return data starting at a different date or not ending on the specified date.

Is there a way in python (or excel) to filter out these funds that have partial/no data, as the data needs to be cleaned and cannot be done manually due to the size of the dataframe. The code is down below:

while True:
try:
    df, err = ek.get_data(
    instruments = ['US3163898733',
    'US3499031793',
    'US56170L7376',
    'US66538H3104'
    ... (there several more funds below but I have done an example of 4 to save time)...
df.to_csv('funddata.csv')
print(df)
cj4641
  • 1
  • Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. – Community Sep 21 '22 at 03:38

0 Answers0