I need help with LSEG codebook

Jeeva_1

just as I used query = (
"SCREEN(U(IN(DEALS)/UNV:DEALSLOANS/), "
"BETWEEN(TR.LNFinancialCloseDate, 2000-01-01, 2024-12-31), "
"CURN=USD)"
) for loans dataset

I want some data on Public companies and I want to know the exact query for public companies universe screener

Like the one attached in the image

Jirapongse Phuriphanvichai

@Jeeva_1

Thank you for reaching out to us.

It should be like this:

screen_exp =(
    'SCREEN(U(IN(Equity(active,public,primary))), '
    'IN(TR.HQCountryCode,"TH"), '
    'CURN=USD)'
)
ld.get_data(
    universe = screen_exp,
    fields = ['TR.CommonName'])

It is better to use the Screener app in the Workspace Excel to build the screener formula.

Then, refer to the following article to convert it into Python code.

• How to Convert the =@RDP.Data Excel Function into Code Using the LSEG Data Library for Python
• Find Your Right Companies with SCREENER | the Data Library (Python)