How to get a list of fund from certain criteria?
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?
Best Answer
@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.
@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.