Lseg data - Workspace API returns error for M&A

Midori

The attached python code returns "SCREEN(MnANation(JP), DealType(M&A), TOP(10)) processing failed…." error. Please advise what is wrong.

M&A_data_Script.txt

Jirapongse

@Midori

Thank you for reaching out to us.

How did you get this formula? Typically, you can use the screener app in the LSEG Workspace to generate a screener formula and then convert it to the Python code. For example:

screener_expression = 'SCREEN(U(IN(DEALS)), IN(TR.MnANationHQ,"JP"), IN(TR.MnAType,"11"), CURN=USD)'

ma_fields = [
    "TR.MnASDCDealNumber",
    "TR.MnAAnnDate",
    "TR.MnARankDate",
    "TR.MnARankValueIncNetDebt(Curn=USD,Scale=6)",
    "TR.MnATarget",
    "TR.MnATargetPermId",
    "TR.MnATargetMacroInd",
    "TR.MnATargetMidInd",
    "TR.MnATargetNation",
    "TR.MnAAcquiror",
    "TR.MnAAcquirorPermId",
    "TR.MnAAcquirorMacroInd",
    "TR.MnAAcquirorMidInd",
    "TR.MnAAcquirorNation"
]

ma_df = ld.get_data(
    universe=screener_expression,
    fields=ma_fields,
    parameters={"Curn": "JPY"}
)
ma_df

You can also refer to this Find Your Right Companies with SCREENER | the Data Library (Python) article.

Moreover, you can contact the helpdesk team to generate or verify a screener formula.

Once you have the correct screener formula, we can assist you in converting it into Python code.