I'd like to find all project finance related to the data centres through the Refinitiv API.

Question

Hello, I'd like to find all project finance related to the data centres through the Refinitiv API. I have only been able to get the data from "search.Views.DEALS_MERGERS_AND_ACQUISITIONS", which is M&A and not project finance or through the deals universe in the screener, for which I don't know how to build a query to filter for project finance, as I don't know what the necessary fields are

Jirapongse · Answer

@Amjath

The code looks like this:

df= ld.get_data(
    universe=['SCREEN(U(IN(DEALS)), IN(TR.PJFProjectUniverseType,"SDCPJF"), IN(TR.PJFProjectPrimaryIndustrySubSector,"DC"), CURN=USD)'],
    fields=['TR.PJFDealId',
            'TR.PJFAnnouncementDate',
            'TR.PJFProjectName',
            'TR.PJFProjectNation',
            'TR.PJFProjectStatus',
            'TR.PJFTotalProjectCost(Scale=6)',
            'TR.PJFIndSector(Concat="|")',
            'TR.PJFSponsor(Concat="|")',
            'TR.PJFProjectUniverseType(Concat="|")',
            'TR.PJFProjectPrimaryIndustrySubSector']
)
df

For more information, please refer to these 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)

Amjath · Answer

Hi @Jirapongse Thank you for responding, please find the below excel formula, can you please converting that formula to Python code?

=@TR("SCREEN(U(IN(DEALS)/*UNV:DEALSPROJECTFINANCE*/), IN(TR.PJFProjectUniverseType,""SDCPJF""), IN(TR.PJFProjectPrimaryIndustrySubSector,""DC""), CURN=USD)","TR.PJFDealId,TR.PJFAnnouncementDate,TR.PJFProjectName,TR.PJFProjectNation,TR.PJFProjectStatus,TR.PJF"&"TotalProjectCost(Scale=6),TR.PJFIndSector(Concat='|'),TR.PJFSponsor(Concat='|'),TR.PJFProjectUnivers"&"eType(Concat='|'),TR.PJFProjectPrimaryIndustrySubSector ","Curn=USD CH=Fd")

Jirapongse · Answer

@Amjath

Thank you for reaching out to us.

This forum is dedicated to software developers using LSEG APIs. The moderators on this forum do not have deep expertise in every bit of content available through LSEG products, which is required to answer content questions such as this one.

The best resource for content questions is the Helpdesk support team, which can be reached by submitting queries through LSEG Support. The support team will either have the required content expertise ready available or can reach out to relevant content experts to get the answer for you.

You need to ask for the Excel formula, such as =RDP.Data, that can be used to retrieve the required data. Then, we can help you converting that formula to Python code.

You can use the following code to list all available fields in the DEALS_MERGERS_AND_ACQUISITIONS view.

response = search.metadata.Definition(
    view = search.Views.DEALS_MERGERS_AND_ACQUISITIONS  # Required parameterc
).get_data()

response.data.df

EXPLORE OUR SITES