ISIN codes through deal screener

Hi, I am currently using excel add-in to getter data on M&A deals. I am using the deal screener but I am not able to pull the ISIN code for the acquirer and the target. I am currently preparing for another (very scarce) timeslot in the Refinitiv database provided by my university and I would like to know which steps I should take to retrieve the ISIN codes! I am using the Eikon API (at least I think so), and I am in a windows environment.

Find more posts tagged with

isin

deals

#product

Accepted answers

Jirapongse

@esete

Thank you for reaching out to us.

As far as I know, the deal screener can't provide ISINs. It provides the acquirer and targer PermIDs.

Therefore, you need to convert PermIDs to ISINs by using symbology APIs. You can use the Refinitiv Data Library for Python to convert symbologies. The examples are on GitHub. For example:

response = symbol_conversion.Definition(
    symbols=["4295865004"],
    from_symbol_type=symbol_conversion.SymbolTypes.OA_PERM_ID,
    to_symbol_types=[
        symbol_conversion.SymbolTypes.RIC,
        symbol_conversion.SymbolTypes.ISIN
    ],
).get_data()


response.data.df

All comments

Jirapongse

@esete

Thank you for reaching out to us.

As far as I know, the deal screener can't provide ISINs. It provides the acquirer and targer PermIDs.

Therefore, you need to convert PermIDs to ISINs by using symbology APIs. You can use the Refinitiv Data Library for Python to convert symbologies. The examples are on GitHub. For example:

response = symbol_conversion.Definition(
    symbols=["4295865004"],
    from_symbol_type=symbol_conversion.SymbolTypes.OA_PERM_ID,
    to_symbol_types=[
        symbol_conversion.SymbolTypes.RIC,
        symbol_conversion.SymbolTypes.ISIN
    ],
).get_data()


response.data.df

EXPLORE OUR SITES