Deals ID and Data

MatildeCiani

Is there a way we could get certains indicators from a vector of Deal IDs?

I have tried the get_data function, but that requires RICs. Is there something similar for deals?

For example, "proj" is a vector of Project IDs, and "pjf_fields" is the vector of indicators I want to download. What functions could I use to get something similar to this?

all_results = []


for proj in list_projects:

    universe = [str(proj)]   


    df = ld.get_data(

        universe=universe,

        fields=pjf_fields

    )


    df["Project"] = proj

    all_results.append(df)


final_df = pd.concat(all_results, ignore_index=True)

final_df



print(len(final_df))

Thank you in advance!

Matilde

Jirapongse

@MatildeCiani

Thank you for reaching out to us.

I am using the Instrument ID from the answer on this discussion with the following code.

ld.get_data(
    universe = ['34390726821@DEALID','34390733488@DEALID'],
    fields =  ['TR.PJFAnnouncementDate','TR.PJFFinancedDate','TR.PJFProjectLocation',
               'TR.PJFProjectCompany','TR.PJFProjectLongitude','TR.PJFProjectLatitude',
               'TR.PJFProjecttCompanyImmParentPermID','TR.PJFProjecttCompanyUltParentPermID',
               'TR.MnARelPJFSdcDealNumber','TR.MnARelatedProjectPermId','TR.PJFPkgTotalProjectCost',
               'TR.PJFProjectCurrency'])