Currently for my master's thesis, I'm doing research on M&A.
I have collected about 700+ acquisitions & mergers over the past years through using the Deal Screener in the Thomson Reuters tab on Excel. All I need to do now is get the Market cap and other financials from the companies that I have found who did an M&A.
I know that you can easily get financials for these companies using the RIC or an ISIN number. However, while using the deal screener, it does not offer me an option to return any identification number which can be used to request financials such as the stock Price, EBIT, ...
How can I request a RIC or ISIN number (or sortalike number) using the deal screener? I have looked everywhere on the internet but can't seem to find anything. Or is there another identification code that I can use or request somewhere by using the deal screener?I also have the names, CUSIP number, ticker symbols of the companies, but I can't be asked to enter them manually & look up the financials one by one... This would take ages. Also by selecting the range of all these names, cusip, tickers, it just returns me errors.
I'd be forever grateful if someone could help me out here.
You can include TR.MnAAcquirorPermId and TR.MnATargetPermId in the list of fields you request from the Screener. These fields will return the PermID for the acquirer and the target. PermIDs can then be used to retrieve financials for these companies. E.g. 4295873661 is the PermID for Siemens Ltd. The following expression returns the latest Siemens Ltd stock close price and annual EBIT.
ek.get_data('5000018278', ['TR.PriceClose', 'TR.EBIT'])
Follow the Screener wizard in Excel to see what other fields the Deal Screener can return.
How about this approach:
In your Screener, when you screen:
In Lists, select My Portfolios & Lists, choose Create New and create your custom list, by uploading a file of available RICs.
Is this roughly what you are looking to do?
If not, for Eikon application usage, a more in-depth Eikon help can be reached via
Eikon => Help option of Eikon desktop menu.
@zoya.farberov Thank you for your quick response. The thing is, I'm not using the regular 'Screener' but the 'Deal Screener' in Excel. I use this to request all the Deals over past 10 years, with prestake <50%, poststake >50%, all listed targets & acquirers & cross-border flag.
I need to use the Deal screener according to my university, but no one is able to give me an answer how to get a RIC or ISIN code for the acquirer and the target.
This is the screen I use:
All I need is the screen to return me a RIC or ISIN code. How do I do this because this doesn't show up in the 'request' list (so to speak).
With this RIC or ISIN code I can easily get financials by using Eikon Datastream -> Time series request.
Tomorrow I will definitely check the 'help' option.
But do you know how I can get the RIC number from the acquirer or target by using the Deal Screener?
Very kind regards!
To research content available via Eikon Data API, fields and parameters, a very useful tool is Data Item Browser (DIB) in Eikon.
For more info on how to use please refer to this tutorial.
Hope this helps you proceed.
Hello, I'm a student at UCD Lochlann Quinn School of Business. When I complete screening for a case study, can it be exported to Excel, if the number of results is greater than 15,000? Is it possible to use Python and Eikon Data API to pull the Deal Screener data?