-
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""),…
-
conversational API
Hi I have seen a demo using a factset agent in a chatbot and was wondering whether you offer something similar to this https://developer.factset.com/api-catalog/conversational-api-powered-by-factset-mercury
-
Clarification on Market Index Used for TR.WACCBeta
Dear LSEG Support, I am using the TR.WACCBeta field from Refinitiv and need clarification on the market index used in its calculation. Which market index is used to compute TR.WACCBeta for different stocks? Does the index selection vary by country, exchange, or sector? Is there a way to retrieve the specific market index…
-
API stops pulling data for specific RIC
Hi, I have an Python API to pull CA data on a list of RICs every day. For this RIC, "BONDS", my API call works for a while and then stopped pulling data on Feb 14, 2025, and when I called helpdesk I was told this is not a specific identifier. I understand what they say, but "BONDS" as a specific identifier works…
-
API content vs Excel Add-in content
Hi all, is there a difference between the content sets I have available through the API vs the Excel add-on? For example, if I am extracting from the below datasets, should I expect similar results? FX rates; Interest rate curves; Macro indicators (inflation, GDP, policy rates, public debt-to GDP, budget balance, etc.);…
-
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""),…
-
analyst forecast data and actual EPS data for all US firms
Hello team, reaching out on behalf of a client. Could you please help me with getting the analyst forecast data and actual EPS data for all US firms from 2000-2024 via Python? We cannot use Excel since the number of firms is too large.
-
Gross vs Net Price Data
I am using the following formula to pull historical prices for a large number of ISINs: df_int, err = ek.get_data(instruments = isins ,fields = ['TR.CLOSEPRICE','TR.CLOSEPRICE.date'], parameters = {'Frq' : 'D,','SDate': '2012-01-01', 'EDate' : '2023-12-31','CH' : 'Fd','RH' : 'IN'}) This successfully pulls a price each day…
-
using the Eikon API -- new user
I am now a legacy Eikon user. We switch to Workspace soon. I'd like to automate downloads of some data using your API. It looks like you have python libraries eikon, refinitiv.data, and lseg.data. Is one of these libraries preferred? Also, is there a way to use your API without logging into the desktop application? This…
-
How to handle error after transition from Eikon to Workspace
Hi, I'm pulling data from API on thousands of RIC daily. I may have RIC's that's no longer valid, or with typo. Under Eikon, my Python code below will return DataFrame containing information with NA for invalid RIC ('BF.B' and 'BONDS') if I simply ignore df_error, when the list RIC are all invalid. import…
