Get M&A deal data via Python API
I am having a problem understanding how to query M&A deal data through the Eikon Python API. The only documentation I have found on this matter is this post on GitHub (https://github.com/Refinitiv-API-Samples/Example.EikonAPI.Python.DealsAnalysis/blob/master/Example.EikonData.Python.DealsAnalysis.ipynb) that provides a query example. From the example, however, it is not clear to me (1) how to use the filters; (2) how many filters are available; (3) how many deal-related variables are available for each deal. Does anyone know by any chance if a complete and clear guide is available?
Best Answer
-
Hi @r.j.galema
The M&A notebook you referenced utilizes the Search service available within the platform. To better understand the basics and some advanced details related to the Search service, I would recommend the following articles:
- Building Search into your Application Workflow
This article introduces the core concepts around Search, which includes filters, navigators and dozens of examples demonstrating the features of the service - Build queries easily using Refinitiv's Search API
This is a more advanced article for users that are comfortable with the Search service but want to simplify the ways to figure out how to filter and which properties to select.
Search is a very rich, but powerful service that is sensitive to filter expressions but does allow the ability to retrieve the desired content on a granular level.
Hope this helps.
1 - Building Search into your Application Workflow
Answers
-
Hi @r.j.galema ,
In addition to @nick.zincone's comment I would like to share a code snipped which was build following the resources that Nick has shared. I have built that in this article for getting M&A data for predictive analysis. I am using RDP API there, however for your ease I posting the code build using our latest RD Libraries here as well.
MnA = rd.discovery.search(
view = rd.discovery.Views.DEALS_MERGERS_AND_ACQUISITIONS,
#specify filtering properties
filter = "((AcquirerCompanyName ne 'Creditors' and AcquirerCompanyName ne 'Shareholder') and (TargetCountry eq 'US' or TargetCountry eq 'UK')"
+ "and TransactionValueIncludingNetDebtOfTarget ge 100 and TargetPublicStatus eq 'Public')"
+ "and (TransactionStatus eq 'Completed' or TransactionStatus eq 'Pending' or TransactionStatus eq 'Withdrawn')"
+ "and (FormOfTransactionName xeq 'Merger' or FormOfTransactionName xeq 'Acquisition') and (TransactionAnnouncementDate le 2022-04-14 and TransactionAnnouncementDate ge 2022-01-01)",
#select only the required fields and order them based on announcement date
#then specify number of items to be 10000, default value is 100
select = 'TransactionAnnouncementDate, TargetCompanyName, TargetRIC',
order_by = 'TransactionAnnouncementDate desc',
top = 10000)
MnA.head()Hope this also will be useful.
Best regards,
Haykaz
1
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛