How do I get an identifier code through the deal screener?
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.
Kind regards
@Jordy
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.
Thank you! I will definitely test this tomorrow! I think this might be the right answer. So I just type the 'TR.MnAAcquirorPermID and TR.MnATargetPermID' in the screen I just posted below? :)
Here's an example that retrieves all the deals announced between Feb 1st and Feb 18th 2020.
ek.get_data('SCREEN(U(IN(DEALS)),' +
'BETWEEN(TR.MnAAnnDate,20200201,20200218), CURN=USD)',
['TR.MnASDCDealNumber', 'TR.MnAAnnDate',
'TR.MnATarget', 'TR.MnATargetPermId',
'TR.MnAAcquiror', 'TR.MnAAcquirorPermId'])
Dear Mr Putkov
You have been a great help! I think I succeeded in getting a sample through using the regular screener in stead of the deal screener now. Maybe it is a very far reach but so far I think my sample is ok. I have gotten a sample containing of the following criteria:
- Deal status completed
- Announcement date: between 01/01/2009 - 31/12/2019
- Both acquirer as target are Listed on a stock exchange
- Both acquirer as target are from a known country
- Pre-acquisition stake <50% and post-acquisition stake >50%
- Deal form= merger or acquisition (however not sure if I need to include this???)
- Excluding the financial sector/industry
- And lastly: Cross border deals/flag = true
Does this look ok to you?
Then for the financials for the TARGET company, a year before the announcement date:
I need the current assets, current liabilities, total assets, EBIT, total debt, sales, I think I have managed to find these already. But then I need the market capitalisation and the retained earnings lastly, but I have not seem to find these in the screener?
Is there a way I can obtain these or do you have some sort of formula?
I would be forever grateful to you, sir!
Very kind regards
Hello @Jordy,
How about this approach:
In your Screener, when you screen:
- Universe=Deals
- Asset Class=M&A
- Include= pick Lists option
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!
Hello @chasingaming,
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.