-
API Query for Private Company Data
I have previously pulled Screener data in R using the API (see code snippet #1), but for some reason I am retrieving zero observations when I do the same using formulas from the Private Companies universe (code snippet #2). Can someone help me get this query working properly? Code snippet #1: screener_formula <- 'SCREEN(…
-
Why the depositary receipt that API found is different than what I see in WS (Price&Chart)
This is a question from a trial user who is testing out the WS API. for the specific ticker (like 9988.HK), I can find the DR under the ‘Price & Chart’, but it's different from the results I got from the API. May I check the reason? here is the code and result…
-
need to filter Japanese stock data with api
I need to filter Japanese stock data that meets the following criteria: Exchanges: Tokyo (TKS), Osaka (OSE), Nagoya (NGY), Fukuoka (FKU) Security Type: Common Stock Listing Status: Including Active and Delisted Country of Domicile: Japan Time Range: Monthly data from January 2024 to April 2025 I have tried various query…
-
RDError: Error code -1
<refinitiv.data.session.Definition object at 0x7f4339b689d0 {name='codebook'}> Here we are using the LSEG Data Library version 1.6.1 'SCREEN(U(IN(Equity(primary,public,active))),TR.F.PriceToBookValuePerShr(Period=FY0)<1,IN(TR.ExchangeCountryCode,JP, US, FR, CA, GB, DE, IT, TW, CH),CURN=USD)' RDError: Error code -1 I've…
-
Standardized Fundamentals are Appearing in Company profile but not appearing in Screener & in Exce
I have access to Refinitiv Workspace via my academic account. I can view financials (e.g., Revenue from Business Activities - Total) from company profiles such as RVSB.O. However, when I attempt to retrieve the same standardized fundamental fields using the Screener tool or Excel Add-in formulas, the values do not appear.…
-
Python Code in Workspace.
do you have the python code requiring the permid of all companies for which Refinitiv can provide ESG scores or data ?
-
How to Retrieve Historical ESG Ratings for M&A Target Companies in Refinitiv Eikon?
Hi all, I'm a student at the University of Amsterdam currently working on my thesis. I'm researching M&A deals and trying to gather historical ESG ratings for the target companies involved. I used DSCREENER in Refinitiv Eikon to identify relevant M&A deals from the past few years. However, I wasn't able to filter or…
-
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""),…
