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
marc.rochat avatar image
1 ●0 ●0 ●0

Is there a way to write a SCREEN formula for multiple instruments

hi,

Is there a way to transform the following formula (or term) into a list of instruments or do i have to loop over thefull 6k+ list of TR.OrganizationID:

exp="SCREEN(U(IN(Private(OrgType(COM, UNK, MKP)))/*UNV:Private or Public*/),TR.UltimateParentId = 4297297477)"

# eg ,TR.UltimateParentId = 4297297477 -> TR.UltimateParentId = [4297297477,...,...]

fields=["TR.UltimateParentId","TR.OrganizationID","TR.CommonName","TR.HeadquartersCountry"]

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


any other efficient suggestion welcomed!

thanks in advance

marc

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

zoya faberov avatar image   zoya faberov

Hello @marc.rochat,

Thank you for your participation in the forum.

Is the reply below satisfactory in resolving your query?

If so please can you click the 'Accept' text next to the appropriate reply. This will guide all community members who have a similar question.

Thanks

-AHS

chavalit-jintamalit avatar image   chavalit-jintamalit

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such. Thanks, AHS


1 Answer

· Write an Answer
Upvotes
Accepted
chavalit-jintamalit avatar image
18.2k ●21 ●13 ●21

You can use the SCREENER app to try to define your search exp.

There is a "Contains" and "OR" operations.


But I don't think it will be able to handle 6K+ list.

ahs.png (6.3 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.

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.