-
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…
-
Do we have an option to retrieve SDC New issues data in API?
Client provided code: import eikon as ek import pandas as pd import logging import time # Configure logging logging.basicConfig(level=logging.INFO, format='%(asctime)s - %(levelname)s - %(message)s') # Set your Eikon API key API_KEY = '' ek.set_app_key(API_KEY) # Define fields to query fields = [ 'TR.NIBPSToBenchmark',…
-
intro to using GreenGrassBlueOcean in R - unused argument (RDObject = RD)
At this time no further help needed. This post can help someone else if they get stuck. …trying to get started downloading data directly into R. Getting stuck out of the gate. library(Refinitiv) #This is the 1st line in which I get an error (taking the code straight from GGBO ReadMe) timeseries1 <- rd_GetHistory(RDObject =…
-
How to import all Global Equity managers into python that have an ISIN that starts with AU?
Hi there, I am trying to import all Global Equity managers into python (Workspace/Eikon API) that have an ISIN that starts with AU. I’ve been using as a guide but some elements are not working. If you could provide some assistance that would be appreciated.,
-
Is there a tutorial on converting the Python Eikon API to Workspace API?
Once again, I'm getting the following error: EikonError: Error code 400 | Backend error. 400 Bad Request I'm hoping that moving from the Eikon API to Workspace API (or whatever the new API is called) will help prevent such errors in the future. I'm unsure of the Workspace package name that needs to be installed using: pip…
