@Academic09

Thanks for reaching out to us.

I got the same error when running the code. It could be the server timeout. The server can cancel the request due to the timeout. The get_data method is not designed to request bulk data in one request.

You may need to limit the requested date to one year. I tested it and it works fine. Otherwise, you can contact your Refinitiv account team or Sales team for other products.

The text inside the (/*....*/) characters is a comment so you can ignore it in the Python code. Therefore, the code looks like this:

deal, err = ek.get_data("SCREEN(U(IN(DEALS)), relativedate(TR.MnAAnnDate,YTD), CURN=USD)",
                        ["TR.MnASDCDealNumber","TR.MnAAnnDate","TR.MnATarget","TR.MnATargetPermId",
                         "TR.MnATargetMacroInd","TR.MnATargetMidInd","TR.MnATargetNation",
                         "TR.MnAAcquiror","TR.MnAAcquirorPermId","TR.MnAAcquirorMacroInd",
                         "TR.MnAAcquirorMidInd","TR.MnAAcquirorNation",
                         "TR.MnATargetFinAdvisor(Concat='|')",
                         "TR.MnAAcquirorFinAdvisor(Concat='|')"],{"Curn":"USD"})
deal

The output is:

I hope that this information is of help.

Hi @Academic09 ,

Thank you for your question. The Search capabilities of RD Library would be useful for ingesting M&A data. You can build up on the folowing code from this article:

MnA = rd.discovery.search(
    view = rd.discovery.Views.DEALS_MERGERS_AND_ACQUISITIONS,

    #specify filtering properties
    filter = "((AcquirerCompanyName ne 'Creditors' and AcquirerCompanyName ne 'Shareholder') and (TargetCountry eq 'US' or TargetCountry eq 'UK')"
    + "and TransactionValueIncludingNetDebtOfTarget ge 100 and TargetPublicStatus eq 'Public')"
    + "and (TransactionStatus eq 'Completed' or TransactionStatus eq 'Pending' or TransactionStatus eq 'Withdrawn')"
    + "and (FormOfTransactionName xeq 'Merger' or FormOfTransactionName xeq 'Acquisition') and (TransactionAnnouncementDate le 2022-04-14 and TransactionAnnouncementDate ge 2022-01-01)",
    
    #select only the required fields and order them based on announcement date
    #then specify number of items to be 10000, default value is 100
    select = 'TransactionAnnouncementDate, TargetCompanyName, TargetRIC',
    order_by = 'TransactionAnnouncementDate desc',
    top = 10000)

MnA.head()

You may also find this and this articles useful on utilizing the search.

Hope this would be helpful, please let me know should you have any further questions.

Best regards,

Haykaz