For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
1 0 0 0

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

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):

api-dals-issue.jpg

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.


eikon-data-apiworkspacepythonapideals
api-dals-issue.jpg (36.8 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

1 Answer

Upvotes
1.7k 2 4 7

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.

1638537786467.png


1638537786467.png (127.5 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea