How do I use pull data from Deal Screener in python?

Question

So in the lseg workspace, I can set up a deal screener, add SKHY.O as a ticker, set it to equity, and then add "Shares Offered All markets" as a field.  Now lets say I want to do this in python using lseg data library and want to pull data for a list of tickers, how can I do this?  My goal is to pull the initial shares offered for a list of ADRs, which I'm pretty sure is "Shares offered all markets"

Can anyone advise?  Or give me a general example of deal screener python code to work off of?

Jirapongse · Answer

@jirukulapati

The Deal Screener requires Perm IDs, not RICs. The Perm ID of SKHY.O is 4295881619. The Python code looks like this:

df= ld.get_data(
    universe = ['SCREEN(U(IN(DEALS)),TR.NIisECM=True,IN(TR.NIParticipant(NIDealPartRole=IS),4295881619))'],
    fields = [
        "TR.NIDealID",
        "TR.NISdcPackageNumber",
        "TR.NIMasterDealType.code",
        "TR.NIAllManagersRole(Concat='|').code",
        "TR.NIManagersRole(Concat='|').code",
        "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.NIIssuerExchTicker(Concat='|')",
        "TR.NISecurityTypeAllMkt",
        "TR.NIOfferingTechnique(Concat='|')",
        "TR.NIGrossSpreadAsPctOfPrincipalAmtThisMktPrint",
        "TR.NIIssuerDomicileSubRegion",
        "TR.NIIssuerDomicileRegion",
        "TR.NIIssuerTRBCBusinessSector",
        "TR.NIIssuerTRBCEcoSec",
        "TR.NILeadLeftBookrunner(Concat='|')",
        "TR.NIBookOrCoManager(Concat='|')",
        "TR.NITotalShrsOfferedAllMkts",
        ],
    parameters = {'Curn':'USD'}
)
df

For multiple Perm IDs, you can set the universe, as follows.

universe = ['SCREEN(U(IN(DEALS)),TR.NIisECM=True,IN(TR.NIParticipant(NIDealPartRole=IS),4295881619,4298007752))'],

You can also use the following function to convert RICs to Perm IDs.

from lseg.data.content import symbol_conversion

response = symbol_conversion.Definition(
    symbols='SKHY.O,LSEG.L',
    to_symbol_types = ['IssuerOAPermID']

).get_data()

response.data.df

Then, you can set the universe as follows:

universe = [f'SCREEN(U(IN(DEALS)),TR.NIisECM=True,IN(TR.NIParticipant(NIDealPartRole=IS),{", ".join(response.data.df['IssuerOAPermID'].values)}))'],

raksina.samasiri · Answer

Hi @jirukulapati ,

Please try exporting the screen as a formula following article Find Your Right Companies with SCREENER | Developer Community

the exported file contains screener formula which can be converted to Screener function syntax in Python, example code can be found in

https://github.com/LSEG-API-Samples/Example.DataLibrary.Python/blob/lseg-data-examples/Examples/1-Access/EX-1.01.08-Screeners.ipynb

EXPLORE OUR SITES