Excel formula to API Script - 16030891

Aileeeeen

Posting on behalf of client

Client wants to get all private companies in API. As per product specialist, this data can pull using below excel formula. Kindly convert below excel formula to API

=@TR("SCREEN(U(IN(Equity(private))/*UNV:Private*/), IN(TR.HQCountryCode,""IS""), CURN=USD,TR.OrganizationStatusCode=Act)","TR.CommonName;TR.HeadquartersCountry;TR.TRBCIndustry","curn=USD RH=In CH=Fd")

Jirapongse

@Aileeeeen

Thank you for reaching out to us.

The code looks like this:

ld.get_data(
    universe = 'SCREEN(U(IN(Equity(private))), IN(TR.HQCountryCode,"IS"), CURN=USD,TR.OrganizationStatusCode=Act)',
    fields = ['TR.CommonName','TR.HeadquartersCountry,','TR.TRBCIndustry'],
    parameters = {'Curn':'USD'}
)

It uses the LSEG Data Library for Python. The examples are also available on GitHub.

The client can also refer to the following articles.

• 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)