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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
raptorsun avatar image
3 ●0 ●1 ●2

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-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonfunds
icon clock
10 |1500

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

2 Answers

Upvote
Accepted
Wan Po.Lee avatar image
339 ●3 ●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 5.0 MiB each and 10.0 MiB total.

raptorsun avatar image raptorsun

Thank you, Im using FSCREEN now.

Upvote
Zhenya Kovalyov avatar image
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 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea