MnA Deal Information

gabriel.matejka

Hi,

I would like to retrieve additional information about deals via the api, but I can only appear to get deal value. Is there a way to retrieve other target financials also?

Sample code:

screener <- 'SCREEN(U(IN(DEALS)),IN(TR.MnATRBCActivity,"5020101011"))'

fields <- c(
"TR.MnASDCDealNumber",
"TR.MnAAnnDate",
"TR.MnATarget",
"TR.MnAAcquiror",
"TR.MnATargetNation",
"TR.MnAAcquirorNation",
"TR.MnADealValue")

RD$get_data(screener, fields)

Jirapongse

@gabriel.matejka

Thank you for reaching out to us.

First of all, I assume that you are using the third party R library to retrieve data as we don't provide any libraries for R. Our current LSEG Data Libraries support Python, Dot Net, and Typescript.

You can get the PermIDs of target companies from the screener and then use the PermIDs to get RICs or prices. The equivalent Python code looks like this:

df = ld.get_data(
    universe=['SCREEN(U(IN(DEALS)),IN(TR.MnATRBCActivity,"5020101011"))'],
    fields=[
        "TR.MnASDCDealNumber",
        "TR.MnAAnnDate",
        "TR.MnATarget",
        "TR.MnAAcquiror",
        "TR.MnATargetNation",
        "TR.MnAAcquirorNation",
        "TR.MnADealValue",
        "TR.MnATargetPermId",
        "TR.MnATargetParentPermID",
        "TR.MnATargetUltParentPermID"
    ])
ld.get_data(
    universe = df['Target PermID'][0],
    fields = ['TR.CommonName','TR.PriceClose','TR.RIC'])

You can also use the Data Item Browser tool to search for RICs and parameters.