How to get a list of fund from certain criteria?

raptorsun

I'm looking for a query to get a list of funds meeting certian criteria. I use the follow query to get a list of companies in UK.

import eikon as ek
import pandas as pd
ek.set_app_key('[app key here]')
screener_exp = """SCREEN(U(
    IN(Equity(active,public,primary))),
    IN(TR.ExchangeCountryCode,"GB"),
    TR.CompanyMarketCap(Sdate=0D)>=50000000,
    TR.NumberOfAnalysts(Period=FY1)>=1)"""
request_fields = [
    ek.TR_Field('TR.CommonName'),
]
instruments, err = ek.get_data(screener_exp, request_fields)

How to use a similar screen query to get the list of funds?

Wan Po.Lee

@raptorsun, @Zhenya Kovalyov please notes there is the new fund screening app. you can type "FSCREEN" to find it in Eikon bar. The old "fund screener app." will be deactivated later.

Zhenya Kovalyov

@raptorsun unfortunately not. Screener can be used only for public and private companies at the moment.

You can use a a simple fund screener in Eikon (type Fund Screener into the command bar and hit Enter) and then export the results to python manually.

raptorsun

Thank you, Im using FSCREEN now.