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

marc.rochat

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

chavalit-jintamalit

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.