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

Question

Question by marc.rochat · Mar 03, 2020 at 11:25 AM · python api formula screen multi instruments

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

0

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2020-03-03T12:14:35Z

REFINITIV

Best Answer

Answer by chavalit.jintamalit · Mar 03, 2020 at 12:14 PM

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)

0 · Share

10 |1500 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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

1 Reply

Watch this question

Related Questions