Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
3 1 2 3

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?

eikoneikon-data-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apifunds
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvote
Accepted
339 4 4 6

@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.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thank you, Im using FSCREEN now.

Upvote
4.6k 26 7 22

@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.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.