If I want to populate a list in python with all the mutual funds existing, how do I do that ?

If you’re familiar with the process, would you be able to share the code or point me in the right direction? I have tried to use the material given but it does not really explain how to correctly write a query in the function.

 

For now I have written this:

 


rd.open_session()

 

search = rdp.search(

    view = rdp.SearchViews.Instruments,

    query="AUMFundNetAsset >= 150000000 AND FundInceptionDate <= DATEADD(year, -3, GETDATE()) AND UCITSFlag eq True",

    select=['FundName', 'RIC']                # I would like to have the volatility, performance for 1, 3 and 5 years, Calmar ratio, Sharpe ratio, alpha, beta and tracking error but I didn’t try to implement it for now

)

print(search)

Answers