-
how can i get a list of all U.S. stocks?
If I want to get a list of all U.S. stocks, how should I do it? I tried using: cond = 'IN(TR.ExchangeCountryCode,US)' each_req = "SCREEN(U(IN(Equity(active,public)))/*UNV:Public*/, " + cond + ",…
-
Python Screener() function error
Dear all, I get an error when I try to run a screen in Python on CodeBook. I start with the example ,ipynb file provided (titled "Access__Screeners_And_Peers.ipynb") To get the screen I want, I follow the explanations on the Developers portal: I use the screener function on the Workspace desktop app (no error), then I…
-
Use API as a screener
What could I use to pull LSEG data with the API similarly to the screener function? IE, I wanted to pull the top 100 companies and list their state of incorporation, market cap, and industry?
-
How to determien Peer Groups on own criteria
Hi Refinitiv Developer Community, I am working with a list of ~450 companies (primarily listed firms) and would like to retrieve, for each company, a list of peer companies — ideally 5 to 10 — using the Refinitiv Eikon or Workspace Python API. In the Workspace platform, I know the “Peers” tab in the GUI and the PEERS()…
-
Download of common stocks
Hello, I want to download only French common stocks with the screener in Excel. How can I do it? Because in my screener there is written also "Indices, Lists, Portfolios…". Thank you in advance
-
How to get all the Rics of a sector (ex. consumer discretionary) and then calculate with its numbers
import pandas as pd # Example test data for 5 stocks in the Consumer Discretionary sector df = pd.DataFrame({ "Instrument": ["A", "B", "C", "D", "E"], "TR.TotalNetIncome": [100, 200, 150, -50, 300], # Net income "TR.AverageTotalEquity": [1000, 2000, 1200, 500, 2500] # Equity }) # Calculate ROE (Return on Equity = Net…
-
Usage of Screener in Python
I need to know how to properly work with the API so I can use all data and be able to filter through it as in the Screener. Therefor I use python. I need help with binding the API and accessing the necessary Data. Example: average ROE of the consumer Discretionary Sector
-
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”.…
