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-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
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.

1 Answer

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

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 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea