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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
Danni.Qiu avatar image
11 ●1 ●2 ●4

Can I use the screener in the R eikon API?

Try the following formula, it cannot recognize the instruments.

result9<-get_data(instruments='SCREEN(U(IN(Equity(active,public,primary))/*UNV:Public*/), IN(TR.HQCountryCode,""CN""), IN(TR.ExchangeCountryCode,""US""), IN(TR.TRBCEconSectorCode,""57""), TR.CompanyMarketCap>=43957372608.65, CURN=USD)',list("TR.CommonName","TR.HeadquartersCountry","TR.ExchangeCountry","TR.TRBCEconomicSector","TR.CompanyMarketCap"), parameters= list('curn'='usd','RH=In','CH=Fd'))



eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythonr
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

Upvotes
Accepted
Jirapongse avatar image
38.1k ●71 ●35 ●53

@Danni.Qiu

Please try this one:

result9<-get_data(instruments='SCREEN(U(IN(Equity(active,public,primary))), IN(TR.HQCountryCode,"CN"), IN(TR.ExchangeCountryCode,"US"), IN(TR.TRBCEconSectorCode,"57"), TR.CompanyMarketCap>=43957372608.65, CURN=USD)',
                  list("TR.CommonName","TR.HeadquartersCountry","TR.ExchangeCountry","TR.TRBCEconomicSector","TR.CompanyMarketCap"), 
                  parameters= list('curn'='usd'))
result9


1590979593029.png (23.9 KiB)
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.

Upvotes
chavalit-jintamalit avatar image
18k ●21 ●12 ●20

Hi @Danni.Qiu

I cannot confirm the R community version.

However on Eikon Data API(Python)

I have to replace "" with " on your syntax.



syntax = 'SCREEN(U(IN(Equity(active,public,primary))), IN(TR.HQCountryCode,"CN"), IN(TR.ExchangeCountryCode,"US"), IN(TR.TRBCEconSectorCode,"57"), TR.CompanyMarketCap>=43957372608.65, CURN=USD)'

fields = ['TR.CommonName','TR.HeadquartersCountry','TR.ExchangeCountry','TR.TRBCEconomicSector','TR.CompanyMarketCap']

df,e = ek.get_data(syntax, fields)
df.tail(10)



ahs.png (46.6 KiB)
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.

Danni.Qiu avatar image Danni.Qiu

Hi, thanks for the quick reply. I just tried your method, it still doesnt work

chavalit-jintamalit avatar image chavalit-jintamalit Danni.Qiu

You should report the issue to the R API contributor.

Note that this is not released by Refinitiv and it is not Refinitiv product.

Click below to post an Idea Post Idea