question

Upvotes
Accepted
1 0 0 0

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.

#productisindeals
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Upvotes
Accepted
86k 292 53 78

@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


icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.