-
What API endpoints aside from datagrid can replicate this SCREENER?
=@TR("SCREEN(U(IN(DEALS)/UNV:DEALSLOAN/),IN(TR.LNParticipant(LNPartRole=LNB:LNBIP:LNBUP:LNBMP:LNR:LNRIP:LNRUP:LNRMP:LNAB:LNABIP:LNABUP:LNABMP:LNG:LNGIP:LNGUP:LNGMP:LNLBO:LNLBOIP:LNLBOUP:LNLBOMP:LNPG:LNPGIP:LNPGUP:LNPGMP),4296949406), BETWEEN(TR.LNMaturityDate,20250319,20750319)/dt:Date/,…
-
rd.get_data for Deal Screener
I am not able to query deals data by using 'rd.get_data' with the same format as the previous 'ek.get_data'. I would like to know if there are any changes for deal screener query syntax using the new API call. (See screenshot 1.png)
-
Org ID from equity search
Hi, I am performing a query using the following formula, but I would like to add also the field "Org Id" to the search. I was not able to do it properly, as when I add the term "TR.OrgidCode" to the fields, I only retrieve NAs. criteria = "SCREEN(U(IN(DEALS)/UNV:DEALSEQ/), IN(TR.NIIssueType,""FO"",""IPO""),…
-
NACE code for Loans
Hi, I am trying to replicate in the codebook a Screener search for all the Loans in EU27+US in 2024 and retrieve the NACE code of the borrower to then aggregate the loan amount at that level. There should be some mistake in my formula, as I fail to retrieve any populated value for the fields 'Use of proceeds' and 'Total…
-
DealScreener | Leveraging Lists
Hi Community, Happy Friday :) I have the following problem. Within DealScreener, I created a list/screen of IPOs in the United States (see screenshot below). Based on this list/screen, I want to find out which of these IPO firms acquired another firm. For this, I changed the asset class to "M&A" and wanted to include the…
-
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…
