-
How do I include delisted firms in the screener?
I'm screening for stocks within specific industries that IPO'd on or before Dec 2005. However, I also need firms included that have IPO'd but have since been delisted. I can't seem to make that work? I'm ticking inactive as a status but it doesn't give me firms that I know for sure have been delisted since their IPO on or…
-
I'm using the screener from Python. Is there a way to filter for instruments where TR.TRBCEconomicSe
import eikon as ek import pandas as pd Set your App Keyek.set_app_key("...") expr = ( 'SCREEN(' 'U(IN(Equity(active,public,primary))) AND TR.IsPrimaryQuote = 1 AND TR.IsDelistedQuote = false, IN(TR.TRBCEconomicSector,""), ' 'TOP(TR.CompanyMarketCap, 25, nnumber), ' 'CURN=USD' ')' ) fields = [ "TR.OrganizationID",…
-
How to download panel data from Refinitiv workspace in a long format but not wide format?
I would like to extract ESG score of all public and private firms for the past 20 years. However, the data I extract from the screener is wide format, which is inconvenient to use. How can I download it in a long format? At the same time, the fiscal year end item does not have time series option as the ESG score item.…
-
deals / loans data dictionary
Greetings. Is there are data dictionary for loans somewhere ? i see that i can access 1151 data items via the screener but i would like to have a dictionary or a template with the variables names and corresponding codes
-
Client (university professor) having Restriction on Data Extraction via Python API
I am a user of LSEG/Refinitiv Workspace. Within the Screener application, when I run a search using the criteria “Universe: Public Companies, Country of Exchange: Turkey,” I can access data for 590 companies in your database.Through the Add Column option in the Screener application, I am able to seamlessly export the…
-
How to pull all public company actual revenue by country and industry in Codebook
Hello, I have tried this script in Codebook but get an error. Can you help me adjust the code to work? end goal: dataset for all public companies (~68k companies) with columns Country | Industry | Actual Revenue Q1'25 We would love to also have more quarters of historical data as well. Here is the current code import…
-
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",…
-
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. https://us.v-cdn.net/6038239/uploads/6I0G56MB3Z5P/m-26a-data-script.txt
-
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
