-
Lseg data - Workspace API returns error for M&A
The attached python code returns "SCREEN(MnANation(JP), DealType(M&A), TOP(10)) processing failed…." error. Please advise what is wrong.
-
Why do I keep getting timeout errors when pulling the full list of US stocks? Are there any solution
cond = 'IN(TR.ExchangeCountryCode,US)' each_req = "SCREEN(U(IN(Equity(active,public)))/UNV:Public/, " + cond + ", NOT_IN(TR.InstrumentTypeCode,BONDFUT,BONDSPREAD,CEF,ETF,ETFA,ETFB,ETFC,ETFE,ETFM,ETFO,ETFX,ETMF,FUN,GROWUNT,HDG,INS,OPF,OPTRTS,PAIDSUBRTS,PREFERRED,PRF,RTS,SUBSRTS),CURN=USD)" fields = ["TR.OrganizationID",…
-
Dual-listed stocks/ Dual listings
I am wondering whether it is possible to identify dual-listed stocks from Refinitiv. I am interested in dual listings (different to cross listings) where two entities enter into an equalization agreement and become dual-listed. There are two main types: Combined entities and separate entities. Combined entities refer to…
-
Importing Deal Screener
Hi! I am trying to access M&A data via a Python App but I'm getting an error importing the Deals Screener. This is my attempt: import refinitiv.data as rd from refinitiv.data.discovery import search from refinitiv.data.content import deals import pandas as pd rd.open_session(app_key="APP KEU") screener = deals.Screener()…
-
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…