Hi, I am trying to run a screener for M&A deals for a list of identifiers with the following code. Unfortunately I am receiving the following error:
KeyError: 'headers'
headers = [header['displayName'] for header in data_dict['headers'][0]]
This seems to be a bug and in other questions I have found it was recommended to limit the number of securities - ideally I would run 40 or 50 securities all at the same time, but in this case even running two or single ones results in an error. Could you please advise or suggest a workaround? Happy to use the RDP Library should that be easier. In such a case would you mind helping out with the code for that.
Thanks!
tickers_string = '4295912121,5000296881' deals_start = '20110101' deals_end = '20210730' df_mna, err = ek.get_data("SCREEN(U(IN(DEALS)/*UNV:DEALSMNA*/), TR.NIisECM=False, IN(TR.MNAParticipant(DealPartRole=T)," + tickers_string + "), BETWEEN(TR.MnAAnnDate," + deals_start + "," + deals_end + ")/*dt:Date*/, CURN=USD)", ["TR.NISdcDealNumber","TR.MnAAnnDate","TR.MnARankDate","TR.MnARankValueIncNetDebt(Curn=USD,Scale=6)","TR.MnATarget","TR.MnATargetPermId","TR.MnATargetShortBusDesc", "TR.MnATargetUltParent","TR.TR.MnATargetUltParentPermID","TR.MnATargetTRBCEcoSec","TR.MnATargetTRBCBussSec","TR.MnATargetUltParentTRBCEcoSec","TR.MnATargetNation","TR.MnAAcquiror", "TR.MnAAcquirorPermId","TR.MnAAcquirorShortBusDesc","TR.MnAAcquirorPermId","TR.MnAAcquirorUltParent","TR.MnAAcquirorUltParentPermID","TR.MnAAcquirorTRBCEcoSec","TR.MnAAcquirorTRBCBussSec", "TR.MnAAcquirorUltParentTRBCEcoSec","TR.MnAAcquirorNation", "TR.MnATargetFinAdvisor(Concat='|')","TR.MnAAcquirorFinAdvisor(Concat='|')","TR.MnAEquityValueAtAnnouncement(Curn=USD,Scale=6)" ])