Extracting deals won't working anymore when using "Form of the Deal" as a criterion

flammers

Until a few days ago, I didn't experience any issues extracting Deals using the following code:

criteria = "SCREEN(U(IN(DEALS)/*UNV:DEALSMNA*/), \
            BETWEEN(TR.MnAAnnDate,19900101,20001231)/*dt:Date*/, \
            IN(TR.MnAStatus,""C""), \
            TR.MnADealValue(Scale=6,IncludeNull=False)>=1, \
            IN(TR.MnAFormType,""A"",""AA"",""AC"",""AM"",""AR"",""M""), CURN=USD)"

display = ["TR.MnASDCDealNumber",
           "TR.MnAAnnDate",
           "TR.MnAAcquiror",
           "TR.MnATarget",
           "TR.MnAAcquirorNation",
           "TR.MnATargetNation",
           "TR.MnADealValue", 
           "TR.MnAAcquirorPublicStatus",
           "TR.MnATargetPublicStatus",
           "TR.MnAStatus",
           "TR.MnAPctOfSharesOwnedPostMerger",
           "TR.MnAFormType"
          ] 
Deals1990_2000, er =ek.get_data(criteria,display)

However, since then running the code results in the following output (which is obviously not correct):

The issue can be solved if I remove the "TR.MnAFormType" parameter in the display list. I checked the data item browser and it seems that this is the correct parameter.

raksina.samasiri

hi @flammers and @brad15

The fix has been released on production and I've verified that it works now. Could you please check and confirm.

raksina.samasiri

hi @flammers ,

I put parameter debug=True in get_data function (with field "TR.MnAFormType" ) to see the JSON request and response and I got the response containing an error mentioned 'processing failed.'. So I raised case number 10744958 on your behalf in my.refinitiv.com product support. They will contact you soon to provide the support.

brad15

I am running into similar errors, where previously successful M&A queries have suddenly stopped working. Would love to hear the results of the support case.

flammers

Support told me that a team would take care of the bug over the weekend of Dec 17 and 18. Since this weekend it is not possible for me to extract deals using the API at all.