I have downloaded a list of 1000 deals using the deal screener and now have access to each deals unique SDC deal number. I want to use the SDC deal number in python to access different data specific to that deal.
For example with the SDC Deal Number: 3635942040, using excel I am able to get the 'Deal Value' & Net Income 2 Years Prior using:
=@TR("SCREEN(U(IN(DEALS)/*UNV:DEALSMNA*/), Contains(TR.MNASDCDealNumber,""3635942040""), CURN=USD)","TR.MnADealValue(Curn=USD,Scale=6);TR.MnATargetNetIncome2Y"&"rPrior(Curn=USD,Scale=6)","CH=Fd").
I want to replicate this query in Python using the Eikon API so that I can loop through my list of SDC Deal Numbers and request any deal info I need.
Any help would be greatly appreciated. Thank you!