Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Datastream /
avatar image
Question by chasingaming · Feb 18, 2020 at 09:44 AM · eikondatastreammergersthomson reutersacquisitions

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




People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

5 Replies

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Alex Putkov. · Feb 18, 2020 at 07:47 PM

@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.

Comment
chasingaming

People who like this

1 Show 3 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
chasingaming · Feb 18, 2020 at 07:52 PM 0
Share

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? :)

avatar image
REFINITIV
Alex Putkov. ♦♦ chasingaming · Feb 18, 2020 at 08:13 PM 0
Share

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'])
avatar image
chasingaming Alex Putkov. ♦♦ · Feb 20, 2020 at 07:41 AM 0
Share

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

avatar image
REFINITIV
Answer by zoya.farberov · Feb 18, 2020 at 05:22 PM

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.

Comment
chasingaming

People who like this

1 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
Answer by chasingaming · Feb 18, 2020 at 07:50 PM

@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!


eikon.png (337.2 KiB)
Comment

People who like this

0 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Answer by zoya.farberov · Feb 20, 2020 at 01:29 PM

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.

Comment
SupDev1

People who like this

1 Show 0 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
Answer by danielleclarke · May 13, 2020 at 10:55 AM

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?

https://developers.refinitiv.com/eikon-apis/eikon-data-api/learning?content=14707&type=learning_material_item


2.4.2 Finance data: Thompson Reuters Eikon 4.0 Deal Screener integrations with pimion


Comment

People who like this

0 Show 1 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
REFINITIV
Alex Putkov. ♦♦ · May 13, 2020 at 02:54 PM 0
Share

@danielleclarke
Old threads with accepted answers are not monitored by forum moderators. If you have a new question, always start a new thread.

Deal screening is now available through regular Screener behind the Screener button under the Thomson Reuters tab in Excel ribbon. To screen for deals select Deals from the drop-down for the Universe in the Screener wizard. The Screener wizard allows to insert the Screener expression as =TR function into Excel worksheet. This Screener expression can then be copied into get_data method of Eikon Data APIs.

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
10 People are following this question.

Related Questions

What is the time when Datastream updates closing price data??

Retrieve Datastream data when we only subscribe to Eikon

How to extract ESG Pillar Scores time series with TR function?

Multiple Errors, Eikon Datastream add on, please help

Data about all equity options in Europe

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges