Infrastructure 360 (GINFR) through Python API

eikon29
eikon29 Newcomer
in Eikon Data APIs

I'm looking for a way to access the data available in LSEG Workspace under "Infrastructure 360" (GINFR) through the Python API. They don't appear in the DEALS_MERGERS_AND_ACQUISITIONS and LOAN_INSTRUMENTS views, which is reasonable. However, I haven't been able to find any record of them by just searching for the (supposed) PermID/DealID either. How can I get a pull of all projects in the dataset straight into Python to then perform further analyses on?

Tagged:

Best Answer

  • Dhruv Singal
    Dhruv Singal Newcomer
    Answer ✓

    I came up with the following, which matches the number of obervations the Screener returns. It's (significantly) less than in GINFR, though there seemingly are duplicated in the latter. pjf_fields is a list of the fields related to project finance (TR.PJF) I found in the CodeCreator.


    pjf_data = []

    for year in trange(1990,2024):
        df,err = ek.get_data("SCREEN(U(IN(DEALS)/*UNV:DEALSPROJECTFINANCE*/), IN(TR.PJFProjectUniverseType,""SDCPJF""), BETWEEN(TR.PJFFinancedDate," + str(year) + "0101," + str(year) + "1231)/*dt:Date*/)",
                             pjf_fields)
        pjf_data.append(df)

    pjf_data = pd.concat(pjf_data,ignore_index=True)

Answers

  • jason.ramchandani01
    jason.ramchandani01 admin

    @eikon29 So I don't believe this content set is available via API search views. The only way I think you can get this data in Workspace is by pulling it via the excel button. I have asked the content team to confirm and I will report back here. Please bear with me.

Categories