SDC platinum

mjabir514

I'm currently accessing SDC Platinum through the LSEG Workspace interface. Is it possible to download SDC Platinum data using Python? If so, could you please share a sample code?

raksina.samasiri

Hi @mjabir514 ,

Here’s the step to export as a formula and convert it to Python code to be used with the Data Library

1. Export as Excel formula on SDC app
   
2. Here’s the example exported file
   
3. Which can convert to Python code as below (Example code of Screener() function and how to use it with get_data() function is in the attached resource above

import lseg.data as ld

ld.open_session()

criteria = 'SCREEN(U(IN(DEALS)) AND relativedate(TR.MnAAnnDate, YTD) AND IN(TR.MnATargetNation, "BN","KH","TL","ID","LA","MY","MM","PH","SG","TH","VN"),CURN=USD)'

fields = [

     "TR.MNASDCDealNumber"

,"TR.MnAAnnDate"

,"TR.MnARankDate"

,"TR.MnAEffectiveDate"

,"TR.MnAStatus"

,"TR.MnAType(Concat=';')"

,"TR.MnAAcquisitionTechnique(Concat=';')"

,"TR.MnATarget"

,"TR.MnATargetUltParentShortName"

,"TR.MnATargetPublicStatus"

,"TR.MnATargetNation"

,"TR.MnATargetRegionAndSubRegion(Concat=';')"

,"TR.MnATargetMacroInd"

,"TR.MnATargetMidInd"

,"TR.MnATargetBusDesc"

,"TR.MnAAcquiror"

,"TR.MnAAcquirorUltParentShortName"

,"TR.MnAAcquirorPublicStatus"

,"TR.MnAAcquirorNation"

,"TR.MnAAcquirorRegion"

,"TR.MnAAcquirorMacroInd"

,"TR.MnAAcquirorMidInd"

,"TR.MnAAcquirorBusDesc"

,"TR.MnADealValue(Curn='USD',Scale=6,PrintFormat=True)"

,"TR.MnADealValue(Curn='EUR', Scale=6, PrintFormat=True)"

,"TR.MnARankValueIncNetDebt(Curn='USD', Scale=6, PrintFormat=True)"

,"TR.MnARankValueIncNetDebt(Curn='EUR', Scale=6, PrintFormat=True)"

,"TR.MnATargetNetSalesLTM(Curn='USD', Scale=6, PrintFormat=True)"

,"TR.MnATargetNetSalesLTM(Curn='EUR', Scale=6, PrintFormat=True)"

,"TR.MnATargetEbitdaLTM(Curn='USD', Scale=6, PrintFormat=True)"

,"TR.MnATargetEbitdaLTM(Curn='EUR', Scale=6, PrintFormat=True)"

,"TR.MnAEquityValueAtAnnouncement(Curn='USD', Scale=6, Concat=';', PrintFormat=False)"

,"TR.MnAEquityValueAtAnnouncement(Curn='EUR', Scale=6, Concat=';', PrintFormat=False)"

,"TR.MnAEnterpriseValueToSales(PrintFormat=False)"

,"TR.MnAEnterpriseValueToEBIDTA(PrintFormat=False)"

,"TR.MnAEnterpriseValueToEBIT(PrintFormat=False)"

,"TR.MnAPctHeldAtAnnDate(PrintFormat=True)"

,"TR.MnAPctOfSharesSoughtInTendOffer(PrintFormat=True)"

,"TR.MnAPctOfSharesAcquired(PrintFormat=True)"

,"TR.MnAConsiderationOffered(Concat=';')"

,"TR.MnAConsidPricePerShare(Curn='USD', Concat=';', AddEnddated=False)"

,"TR.MnAConsidPricePerShare(Curn='EUR', Concat=';', AddEnddated=False)"

,"TR.MnAInitialOfferPrice(Curn='USD', PrintFormat=True)"

,"TR.MnAInitialOfferPrice(Curn='EUR', PrintFormat=True)"

,"TR.MnAPremiumOffered1DayPriorAnn(PrintFormat=True)"

,"TR.MnAPremiumOffered1WeekPriorAnn(PrintFormat=True)"

,"TR.MnAPremiumOffered4WeekPriorAnn(PrintFormat=True)"

,"TR.MnATargetOrAcquirorFinAdvisorParentLong(Concat=';')"

,"TR.MnATargetFinAdvisorLong(Concat=';')"

,"TR.MnATargetFinAdvisorCount(PrintFormat=True)"

,"TR.MnAAcquirorFinAdvisorLong(Concat=';')"

,"TR.MnAAcquirorFinAdvisorCount(PrintFormat=True)"

,"TR.MnASynopsis"

,"TR.MnATargetSDCCusip"

]

deals_screener = ld.get_data(criteria, fields)

deals_screener

Here’s the output