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
raptorsun avatar image
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.

veerapath.rungruengrayubkul avatar image   veerapath.rungruengrayubkul

Hi @raptorsun

Is the reply below satisfactory in resolving your query?

If yes, please click the 'Accept' text next to the reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question.

Thanks,

AHS

Christiaan Meihsl avatar image   Christiaan Meihsl

@raptorsun, thank you for your participation in the forum. Are any of the replies below satisfactory in resolving your query? If yes please click the 'Accept' text beneath the most appropriate reply. This will guide all community members who have a similar question. Otherwise please post again offering further insight into your question. Thanks, AHS

2 Answers

· Write an Answer
Upvote
Accepted
Wan Po.Lee avatar image
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.

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