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

Razeen_Ptp

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)

Jirapongse

@Razeen_Ptp

Thank you for reaching out to us.

To use the Search API, please refer to the following articles:

• Building Search into your Application Workflow
• Accelerating Search: Unlocking the Power of Property Exploration
• Find content and functionality using the Data Library with Workspace Advanced Search