SCREENER syntax converted in Python

kwikmar1

Hi all,

I have the following Screener syntax and I tried to convert it according to the guide https://developers.refinitiv.com/en/article-catalog/article/find-your-right-companies-with-screener-eikon-data-apis-python, but I seem to be unable to do it correctly, as I get different error messages.

This is the Screener Formula

@TR("SCREEN(U(IN(Equity(active,public,primary))/*UNV:Public*/), IN(TR.ExchangeCountryCode,""CH""), TR.EnvironmentPillarScore(Period=FY0)>=80, CURN=USD)","TR.CommonName;TR.ExchangeCountry;TR.EnvironmentPillarScore(SDate=0,EDate=-13,Period=FY"&"0,Frq=FY)","curn=USD RH=In CH=Fd;CalcDate;rfperiod")

Any help to convert this to get the data frame in python would be appreciated.

Also, would it be possible to have the SDate = 2009.01.01, EDate = 2022.03.30 instead of the above?

Many thanks for your help in advance.

Cheers,

Marc

Gurpreet

Hi @kwikmar1,

You can directly use the screener formula in python by converting the parameters. Try something like this -

exp = "SCREEN(U(IN(Equity(active,public,primary))), IN(TR.ExchangeCountryCode,CH), TR.EnvironmentPillarScore(Period=FY0)>=80, CURN=USD)"
fields = ['TR.CommonName','TR.ExchangeCountry','TR.EnvironmentPillarScore']
df, e = ek.get_data(exp, fields, {'SDate':'2009-01-01', 'EDate':'2022-03-30', 'Frq': 'FY'})
print(df)

The response will be the dataframe of FY data points:

    Instrument Company Common Name Country of Exchange  Environmental Pillar Score
0       UBSG.S        UBS Group AG         Switzerland                   89.643291 
1       UBSG.S                                                            88.17924 
..         ...                 ...                 ...                         ... 
178     ZURN.S                                                           94.035762 
179     ZURN.S                                                           92.247765