-
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…
-
Using Python API, will it allow me to get more than 5K rows worth of records from the screener?
-
set time range for daily stock price
Hi, I am using the screener from Refinitiv workspace to extract daily stock prices for a long list of companies. I want to obtain data from Feb-April 2022, but it seems like it only has the option to either select one specific date or select a range of dates before "today". Am I missing something? Or should i use other…
-
How to exclude the previous results of the screener in the next screen code?
Want to download big screener of stocks. The problem is the script limits the download to maximum of 10000 stocks at one time having about 50000 records. what is the way to iteratively download the full records from the screener.
-
No Data Available for ESG Statement
Hi, I need to access ESG information on companies in S&P 500 index (e.g. ESG score, ESG controversies) for multiple years. I use the SCREENER app for that, however, the relevant columns return as NAs. Moreover, when opening an individual company profile, the ESG statement says "No Data Available." I used these exact steps…
-
How to pull Top 400 AUM companies on CODEBK?
Query: I'm trying to retrieves the top 400 AUM companies via Refinitiv Data Python library. I found an excel formula, but I'm wondering if I can do the same with Python? =TR("SCREEN(U(IN(equity(active,public,primary))/*UNV:Public*/), TOP(TR.AssetsUnderManagement(Period=FY0) , 400, nnumber),…
-
Possible to identify MNE's with screener app?
In Refinitiv Workspace's SCREENER app, is there a "data item"/parameter that allows for the identification of multinational enterprises / MNE's? And, on a related note, is there a "data item" that reflects companies' operational locations- that is, the countries in which a company physically operates but is not…
-
Is there a way to batch download filings for a particular SDC Deal Number?
I would like to download the filings for a particular SDC File Number but I have to manually download one by one. Is there a faster way to do this such as batch download functionality?
-
Python refinitiv.data Screener not working
I have the following screener code in python ... import refinitiv.data as rd rd.open_session() syntax = ( 'SCREEN(' 'U(IN(Equity(active,public,primary))),' 'TR.CompanyMarketCap(Scale=6)>=300,' 'TR.F.NetDebtToEBITDA(Period=FY0)<=3,' 'NOT_IN(TR.GICSIndustryGroupCode,4010,4020,4030),' 'IN(TR.RegCountryCode,IN),'…
-
How to link screener list with codebook to search a specific keyword?
Hi I have created a list of US banks for my research purpose using Refinitiv Screener, however, I am required to create a column for 'digital scoring', is it possible to use Refinitiv CODEBOOK to generate this column by searching for specific keywords like 'online banking', 'financial technology', 'digital banking'..etc in…
-
Company Screener not returning results
I am trying to run the screener function on python but a code which used to work in the past is now not working properly. I would expect the below to yield results but nothing seem to come up? code = 'TR.NAICSSubsectorAllCode(Concat=|)' naics_code = '325' syntax = 'SCREEN(U(IN(Equity(active,public,private,primary))), \…
-
SCREEN syntax changes when moving from Eikon Python API to Workspace Python API
I have a SCREEN implementation in Eikon API using Python that has been working fine for many months: instrument = "SCREEN(U(IN(Equity(active,public,primary,countryprimaryquote))),IN(TR.ExchangeMarketIdCode,XNYS),BETWEEN(TR.Price52WeekHighDate,20240628,20240628))" df, err =…
-
How to get share classes for listed companies via API?
Hi, we want to get all share classes for listed companies. For example, Square Inc. has class A share (listed) and class B share (private). We are not sure what is the command to get this information via API or on Eikon app. Thanks!
-
How can I pull "Private Equity/VC" data from the SCREENER app using the Eikon API?
I would like to pull data from the SCREENER App on Private Equity/VC using the Eikon API. In WorkSpace I do this by opening the SCREENER app, setting "Universe" to "Private Equity/VC" and then setting any other filters I need. Based off this documentation of how to use the API to pull data from the SCREENER App, it appears…
-
DSCREEN Close Price filed
Greetings, I am currently advancing my project focused on companies undergoing delisting. Utilizing the DSCREEN application, I have successfully compiled a comprehensive list of companies that have been delisted, along with detailed information regarding the transactions that led to their delisting. My next objective is to…