Org ID from equity search

Giacomo_C

Hi, I am performing a query using the following formula, but I would like to add also the field "Org Id" to the search. I was not able to do it properly, as when I add the term "TR.OrgidCode" to the fields, I only retrieve NAs.

criteria = "SCREEN(U(IN(DEALS)/UNV:DEALSEQ/), IN(TR.NIIssueType,""FO"",""IPO""), IN(TR.NITransactionStatus,""LIVE""), TR.NIisECM=True, BETWEEN(TR.NIIssueDate,"+t+","+t+")/dt:Date/, CURN=EUR)"

criteria = "SCREEN(U(IN(DEALS)/UNV:DEALSEQ/), IN(TR.NIIssueType,""FO"",""IPO""), IN(TR.NITransactionStatus,""LIVE""), TR.NIisECM=True, BETWEEN(TR.NIIssueDate,"+t+","+t+")/dt:Date/, CURN=EUR)"
display = ["TR.NIIssuerPermID",

        "TR.NIISINAtOffer",   

        "TR.LegalEntityIdentifier",


        "TR.NIDealID",

        "TR.NISdcPackageNumber",

        "TR.NIMasterDealType.code",

        "TR.NIIssueDate",

        "TR.NIIssuer",

        "TR.NIIssueType",

        "TR.NITransactionStatus",

        "TR.NIIssuerNation",

        "TR.NICurrentFilingDate",

        "TR.NIOfferPricePrintUniform",

        "TR.NIProceedsAmtInclOverallotSoldAllMkts(Scale=6,Curn=EUR)",

        "TR.NIProceedsAmtInclOverallotSoldThisMkt(Scale=6,Curn=EUR)",

        "TR.NIIssuerExchTicker",

        "TR.NIIssuerDomicileSubRegion",

        "TR.NIIssuerDomicileRegion",

        "TR.NIIssuerTRBCBusinessSector",

        "TR.NIIssuerDomicileNation"]


df = rd.get_data(criteria, display)

where 't' is a date variable that I use to loop the query.

Thank you.

Jirapongse

@Giacomo_C

Thank you for reaching out to us.

I checked and found that the TR.OrgidCode fields is not in the Deals category. I think this is why it can't be used in the Deals screener.

You can verify this by using the Screener app. Otherwise, please contact the helpdesk team directly via MyAccount to confirm this.