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.
Upgrade from Eikon -> Workspace. Learn about programming differences.
For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
1
●0 ●0 ●0
ISIN codes through deal screener
Hi @esete ,
Thank you for your participation in the forum.
Are any of the replies below satisfactory in resolving your query?
If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.
Otherwise please post again offering further insight into your question.
Thank you,
AHS
79.4k
●253 ●52 ●74
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
