M&A: Extracting acquirer and target security PermID and ISIN

flammers
flammers Newcomer
in Eikon Data APIs

Hi,

I am extracting Deals for a specific number of firms based on their Company PermID using the following code:

import eikon as ek
import numpy as np
import pandas as pd
import csv as csv
ek.set_app_key('APPKEY')

PermIDs = []

with open('Firm_PermIDs.csv', newline='') as f:
    reader = csv.reader(f)
    for row in reader:
        for x in row:
            PermIDs.append(x)
PermIDsString = ', '.join(PermIDs)

criteria = f"SCREEN(U(IN(DEALS)/*UNV:DEALSMNA*/),IN(TR.MNAParticipant(DealPartRole=T),{PermIDsString}),\
            BETWEEN(TR.MnAAnnDate,19990101,20230712)/*dt:Date*/, CURN=USD)"

display = ["TR.MnASDCDealNumber",
           "TR.MnAAnnDate", 
           "TR.MnAAcquirorPermId", 
           "TR.MnADealValue", 
           "TR.MnAStatus", 
           "TR.MnAType(Concat='|')", 
           "TR.MnAAcquiror", 
           "TR.MnATarget", 
           "TR.MnAAcquirorNation",
           "TR.MnATargetNation",
           "TR.MnAPctHeldAtAnnDate", 
           "TR.MnAPctOfSharesAcquired", 
           "TR.MnAPctOfSharesOwnedPostMerger",
           "TR.MnAFormType"
          ] 
pd.set_option('display.max_columns', None)
pd.set_option('display.max_rows', 300)
deals, er =ek.get_data(criteria,display)

As you can see, I am extracting a number of different deal information including the announcement date, value, status of the deal etc.

I was wondering if it's also possible to obtain the Target's and Acquirer's Security PermID as well as their ISIN codes through the API?


Thank you

Tagged:

Best Answer

  • raksina.samasiri
    raksina.samasiri admin
    Answer ✓

    Hi @flammers ,

    Regarding including both DealPartRole T and A, I found how to apply them with CodeCreator in Refinitiv Workspace/Eikon Desktop. After launching the CodeCreator (CodeCr)

    1. input instrument
    2. search for the data item (I used Deal Participant which its field is TR.MNAParticipant
    3. Click on Parameters & Quick Functions tab
    4. Select Edit on Deal Part Role
    5. Check the option(s) you would like to include
    6. Click Done
    7. The parameter is applied into the field

    1690945629069.png

    so when make a parameter to apply with all fields, the code looks like

    deals, er =ek.get_data('AAPL.O',display,{'DealPartRole': 'T:A'})

    I'd like to try if this works if put in criteria, but I don't have any example of ISINs you've used, could you please provide a few of them for further investigations.

Answers

Categories