-
we need to use “screen” function in python to find the company, remember the companies are not liste
My understanding is that we need to use “screen” function in python to find the company, remember the companies are not listed, they DO NOT have RIC. I believe we need to similar code as below, but the universe should be set to “Private equity” My question is that I need CODE to produce the same output as I use “DSCREEN”.…
-
How to filter the Nasdaq index in eikon terminal?
I need to download the data of Nasdaq listed companies in eikon terminal? I can't find the Nasdaq index list in the screener panel, and I can't find the Nasdaq exchange in the exchange name section. Can you give me some help? Thank you!
-
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/,…
-
How to run a SCREENER formula in Excel to CODEBOOK?
What is wrong with this screening code? df, err = ek.get_data('SCREEN(U(IN(Equity(active,public))/UNV:Public/), IN(TR.InstrumentTypeCode,"ADR","BDR"), IN(TR.ExchangeMarketIdCode,"BVMF","XBSP")',['…
-
Price Target High, Price Target Low, Price Target Median, Price Target Mean data in the API
Hello everyone, I can't find the Price Target High, Price Target Low, Price Target Median, Price Target Mean data in the API on a universe. The file below is the universe and the parameters I want but only the columns for this data are empty. Thanks,
-
Sources of funds for M&A deal
Hi all, I am currently working on my master's thesis, which involves analyzing the source of funds in financial transactions. Does anyone know which is the best way/function to get to know how a M&A transaction was financed (debt/equity or both)? I'm using the Deals Screener Worksheet of Refinitiv Eikon. Thank you in…
-
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""),…
-
Panel of ESG scores till most recent update
Hello, I am trying to obtain a panel of all ESG scores for any company (public or private) in France. I create my universe using this command: df = rd.get_data(["SCREEN(U(IN(Equity(active,public,private,primary))/*UNV:PublicPrivate*/), TR.HasESGCoverage==true, IN(TR.HeadquartersCountry,""France""),…
-
List of companies Post business combination with SPACs
Could you please guide me on how to use the LSEG Workspace Screener to find a list of companies that have gone public through a SPAC merger, specifically those that have already completed their business combination?
-
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…
-
Company screening via Codebook
Hello everyone, I am currently working on a project where I need to screen for all private companies of a country with revenues between EUR 250m and EUR 10bn during a specified fiscal year. I would like to specifically screen for companies where full income statements and balance sheets are available in Refinitiv within…
-
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…
-
Codebook to download in excel loans data from the screener
am trying to use the codebook to download in excel loans data from the screener. I am using the following code: import refinitiv.data as rd from refinitiv.data.discovery import Screener rd.open_session() loans = Screener('U(IN(DEALS)/*UNV:DEALSLOAN*/), BETWEEN(TR.LNTrancheClosingDate,20240301,20240302)/*dt:Date*/,…
-
Workspace Screener in Codebook returns error code 800
When running a screener in Python (Codebook), error code 800 is returned (see screenshot). What can be done to remedy this?
-
Back-end errors in get_data and SCREEN
Hello - I have a script that I've used for over a year without many problems, but lately I am getting a lot of "400 Bad Requested universes". You can see below I am screening for companies. When I put this screener syntax in Excel's TR function, I am able to download companies fine. However, I need this Python workflow to…