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
11 2 6 6

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-apipythonrefinitiv-dataplatform-eikonworkspaceworkspace-data-apir
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.

Upvotes
Accepted
78.1k 246 52 72

@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 512.0 KiB each and 1.0 MiB total.

Upvotes
18.2k 21 13 21

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 512.0 KiB each and 1.0 MiB total.

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

You should report the issue to the R API contributor.

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

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.