Screener formula does not work in Eikon API

Question

Question by miriam.benito · May 30, 2019 at 09:37 AM · eikon api eikon data api screener excel api

Screener formula does not work in Eikon API

I am trying to use the same formula than Excel is retrieving me in Python and it is not working.

=TR("SCREEN(U(IN(Private(OrgType(COM, UNK, MKP)))/*UNV:Private*/), IN(TR.TRBCActivityCode,""5430102016""), IN(TR.HeadquartersRegion,""Europe""), BETWEEN(ZAV(TR.PCSmartRatiosLiquidityGlobalRank), 1.00, 20.00), CURN=USD)","TR.CommonName;TR.TRBCActivity"&";TR.HeadquartersRegion;ZAV(TR.PCSmartRatiosLiquidityGlobalRank)","curn=USD RH=In CH=Fd")

captura-de-pantalla-2019-05-30-a-las-153423.png (418.6 KiB)

0

10 |1500 characters needed characters left characters exceeded

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

Answer 1 · 2019-05-30T13:27:33Z

REFINITIV

Best Answer

Answer by Gurpreet. · May 30, 2019 at 01:27 PM

Hi @miriam.benito, Can you try this and see if it works for you:

exp = "SCREEN(U(IN(Private(OrgType(COM, UNK, MKP)))), IN(TR.TRBCActivityCode,""5430102016""), IN(TR.HeadquartersRegion,""Europe""), BETWEEN(ZAV(TR.PCSmartRatiosLiquidityGlobalRank), 1.00, 20.00), CURN=USD)" fields = ['TR.COmmonName', 'TR.TRBCActivity', 'TR.HeadquartersRegion', 'ZAV(TR.PCSmartRatiosLiquidityGlobalRank)'] 

df, e = ek.get_data(exp, fields)

print(df)

Here is my output:

     Instrument  ... ZAV(TR.PCSmartRatiosLiquidityGlobalRank)
0    4298157373  ...                                        9
1    4298203137  ...                                       18
2    4298232673  ...                                       14
3    4298253815  ...                                       14
4    4298266156  ...                                       14
5    4298270206  ...                                        3

0 Show 1 · Share

10 |1500 characters needed characters left characters exceeded

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

miriam.benito · May 31, 2019 at 06:20 AM 0

Share

Hi @Gurpreet.

I do not know why I cannot run the same command...

captura-de-pantalla-2019-05-31-a-las-121849.png (217.7 KiB)

Answer 2 · 2019-05-30T10:01:16Z

REFINITIV

Answer by Gurpreet. · May 30, 2019 at 10:01 AM

@miriam.benito Can you post your instrument list and complete script. I tried it with few instruments and the formula worked ok.

0 Show 1 · Share

10 |1500 characters needed characters left characters exceeded

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

miriam.benito · May 30, 2019 at 10:27 AM 0

Share

@Gurpreet. Thanks for your response. I think that the question is wrongly posed. I wanted to retrieve the private companies of the activity with the code 5430102016 (Food markets) with those filters. There is no more than 5000 companies with those filters (already checked it via Screener), hence, I do not have the instrument list I want that list :)

The code is:

exp = "SCREEN(U(IN(Private(OrgType(COM, UNK, MKP)))/*UNV:Private*/), IN(TR.TRBCActivityCode,""5430102016""), IN(TR.HeadquartersRegion,""Europe""), BETWEEN(ZAV(TR.PCSmartRatiosLiquidityGlobalRank), 1.00, 20.00), CURN=USD)"

ek.get_data(instruments=[exp], fields=["TR.CommonName","TR.TRBCActivity","TR.HeadquartersRegion","TR.PCSmartRatiosLiquidityGlobalRank"])

Thanks a lot!

Answer 3 · 2019-05-31T09:23:56Z

REFINITIV

Answer by Gurpreet. · May 31, 2019 at 09:23 AM

Hi @miriam.benito Can you please confirm that you are using the latest version of Eikon API ?

>>> import eikon as ek
>>> ek.__version__
'1.0.1'

0 Show 1 · Share

10 |1500 characters needed characters left characters exceeded

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

miriam.benito · Jun 01, 2019 at 05:27 AM 0

Share

Hi @Gurpreet.,

It was the version.. thank you for the point!

Screener formula does not work in Eikon API

3 Replies

Watch this question

Related Questions