-
Industry codes in MnA
I need granular NAICS codes for MnA deals. However, I only seem to get industry labels and descriptions. Merging these back to codes would be extremely painful. How can I pull these with TR.MnA through the API? If this isn't possible, does Eikon provide a match table?
-
Eikon to LSEG Workspace API
Hi Team We are receiving issue while fetching data from LSEG Worspace API while the similar code is working fine in Eikon. Please check provide the solution as soon as possible CODE:- import refinitiv.data as rd from refinitiv.data.discovery import Screener from refinitiv.data.content import search from datetime import…
-
Can i get for Eikon api python, to generate a code for m&a deals screenin?
i need help for Eikon api python, to generate a code for m&a deals screening: worldwide deals, announcement date between 01.01.2010-31.07.2024, status completed, The deal value >$1 million, Both acquirer as target are Listed on a stock exchange, The acquirer holds <50% of the target’s publicly traded shares before the…
-
Is there a way to batch download filings for a particular SDC Deal Number?
I would like to download the filings for a particular SDC File Number but I have to manually download one by one. Is there a faster way to do this such as batch download functionality?
-
Limit on exporting to excel
I have been having trouble exporting the data to excel. As you can see in the image, the export excel button is not highlighted, meaning I am unable to download the data. I have found the following on: https://www.eur.nl/en/library/news/eikon-deal-screener-limitations "Eikon Deal Screener has some limitations since the 1st…
-
How to add the list of securities that have deal character code as a bond type in BRS/Aladdin?
Hi team, I would like to request your assistance on this one. Can the attached list of securities with deal character code is <DATACNTR> be added in BRS/Aladdin? Our client is looking to have the value <DATACNTR> added to the bond type in Aladdin. DATACNTR.pdf
-
ISIN codes through deal screener
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…
-
DSCREEN Close Price filed
Greetings, I am currently advancing my project focused on companies undergoing delisting. Utilizing the DSCREEN application, I have successfully compiled a comprehensive list of companies that have been delisted, along with detailed information regarding the transactions that led to their delisting. My next objective is to…
-
Is there a way to screen or retrieve newly added Project Finance Deals in Python API?
Could you kindly offer further guidance on how to effectively download the updated dataset (i.e. the part you recently purchased from third parties)? Additionally, I understand that Python can be utilized for this purpose. If possible, could you provide any advice, resources, or documentation on how to proceed with Python…
-
I'm trying to obtain a list of advisors and their roles in M&A deals. How can I be sure to assign...
... the roles correctly when advisors have multiple roles? I'm trying to obtain a list of advisors and their roles in M&A deals. I have code to pull the deals, but the advisors and the roles come in a concatenated field. Some advisors have multiple roles. If the first advisor has two roles and the second advisor has one…
-
Add additional fields in Python from M&A Screener data
Hi, currently I'm using this formula df, err = ek.get_data("WTB.L",fields=["TR.OrganizationID"]) OrgPermId = df["Organization PermID"].values[0] screener_exp = 'SCREEN(U(IN(DEALS)), IN(TR.MnATargetPermId,"'+str(OrgPermId)+'"))' deals, err = ek.get_data( instruments=[screener_exp],…
-
Sustainabilty-Linked bond deals via python API
Hi all, I am searching for a way to request sustainability-linked bonds and loans via python API. I tried refinitiv.data package but could not find a fitting function or filter to extract this specific type of products. Is there an actual way to do this? Regards Fritz
-
Deals in Data Item Browser?
Hi, Following from this Q&A, I was trying to find new fields who's data I could retrieve from your RD Python library. In this example, your coleague uses fields 'TR.MnASDCDealNumber' to 'TR.MnAAcquirorNation', but how can I find ou tthe list of all the available such fields for deals? Right now, I'm just blindly trying…
-
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…
-
What does it mean when a deal is Tranche Primary?
Hello, I am downloading deals, one of the fields that I use is the following: 'TR.NISdcPackageNumber.IsTranchePrimary'. I was wondering what does it mean when the tranche is primary (T). Does primary refer to the market where the tranche is commercialized, so the ones that are not primary would be registered when the…
