How to retrieve Bond (DCM) Deals from Bond Screener in Python API?
Client's query: Is to get "Use of Proceeds: Project Finance" and New Issues Ratings: Moody's Debt/Bank Loan Rating" in Deal Screener app and requested if this is available in Python API.
Tried using code:
import refinitiv.data as rd
rd.open_session()
df= rd.get_data(
universe=['SCREEN(U(IN(DEALS)/UNV:DEALSBOND/),TR.NIisECM=False, relativedate(TR.NIIssueDate,YTD)/dt:Date/, IN(TR.NIUseOfProceedsType,"121","114","113","112","89","88","86","68","65","64","62","58","52","49","4"&"8","47","45","44","41","32","26","25","15","14","8","6","2"), NOT_IN(TR.NIRatingsMoodysDebt,"60","50","25"), CURN=USD)'],
fields=['TR.NIDealID','TR.NISdcPackageNumber','TR.NIIssueDate()','TR.NIIssuer','TR.NIIssuerPermId','TR.NIIssueType(Concat"&"='|')','TR.NITransactionStatus','TR.NIIssuerNation','TR.NICurrentFilingDate','TR.NIOfferPricePrintUniform','TR"&".NIProceedsAmtInclOverallotSoldAllMkts(Scale=6)','TR.NIProceedsAmtThisMkt(Scale=6)','TR.NIIssuerExchTick"&"er(Concat='|')','TR.NISecurityTypeAllMkt','TR.NIOfferingTechnique(Concat='|')','TR.NIGrossSpreadAsPctOfPri"&"ncipalAmtThisMktPrint','TR.NIIssuerDomicileSubRegion','TR.NIIssuerDomicileRegion','TR.NIIssuerTRBCBusiness"&"Sector','TR.NIIssuerTRBCEcoSec','TR.NILeadLeftBookrunner(Concat='|')','TR.NIBookOrCoManager(Concat='|')','TR"&".NIUseOfProceedsType(Concat='|')','TR.NIRatingsMoodysDebt',]
)
display(df)
But I am getting error message "Syntax invalid".
