-
Why is data not flowing in API while available in Excel for active funds?
Hi Team, We have use Code like this one: import refinitiv.data as rd rd.open_session() df = rd.get_data( universe = ['LP68702800','LP68611492'], fields = ['TR.ISIN', 'TR.FundName','TR.FundObjective','TR.FundRIESGEnviron','TR.FundRIESGGov','TR.FundRIESGSoc'], ) display(df) These fund RICs are active so we are curious why it…
-
Can I get quaterly ESG data for FTSE100 as a bulk?
Can I get quaterly ESG data for FTSE100 as a bulk?
-
Align ESG data with market data (in time).
I'm working with the EK API to get ESG data with market and fundamentals data for a company (e.g., AAPL.O). My goal is to pull fields related to price, market cap, ESG scores, and Scope 1 emissions (and other extra-financial data). I have problem aligning the dates. Here is the code I'm using: fields = [ 'TR.PriceClose',…
-
Filings and ESG API issue
I would like to clarify a few points. It seems the API we are requesting is not a real-time data API from exchanges. The first one is the Filings API from the following thread: https://community.developers.refinitiv.com/questions/100586/retrieving-annual-reports-using-eikon-api.html. Below is the screenshot of the response…
-
When will ESG scores for FY 2023 be available ?
Hey, my study is focus on the Germany companies who are in the range of MDAX, DAX, TecDAX index. But now the updated ESG score data are for FY 2022. Do you know when will ESG scores for FY 2023 be available ? Thousand thanks. Shirely
-
Backend error. 400 Bad Request, ESG score retrieval
Dear Developer Community, I want to download ESG and Pillar scores for all US stocks from 2011 to 2023 on a quarterly basis via the Eikon Data API. I am using the get_data(..) function with the following specifications fields = ["TR.TRESGScore", "TR.EnvironmentPillarScore", "TR.SocialPillarScore",…
-
Announcement Date of ESG-Score
Unfortunately, as a research assistant, I don't have access to the helpdesk, so I hope that someone here can answer my question: I want to carry out an event study and need the date on which an ESG score was published in Refintiv Eikon. The papers I have found use TRESGScore.date as the publication date, but is the ESG…
-
Using Eikon API to retrieve the filing dates of annual reports and ESG reports
I am trying to retrieve the filing dates of annual reports and ESG reports using a search query similar to https://community.developers.refinitiv.com/questions/95582/eikon-api-retrieve-annual-report-publication-date.html, and I've met several confusing issues. api_key = 'my api key' ek.set_app_key(api_key) isin_df =…
-
ESG Module - Access Denied
Hi Team, Good afternoon. May I know if ESG Module in API has additional fees/subscription? My client tried to access the module: https://cdn.refinitiv.com/public/rd-lib-python-doc/1.0.0.0/book/en/sections/content-layer/esg/esg-full-measures/get-data.html. and got access denied. May I know if what approval needs to be added…
-
Extract ESG scores based on ISIN codes
I am using Refinitiv Eikon Datastream in Excel. I want to extract the ESG scores of several companies I have collected in a sample, I have the ISIN codes belonging to those companies. How can I insert those ISIN codes in Datastream to extract the ESG scores belonging to those companies?
-
How to filter through for ETFs using the Morningstar Rating in Refinitiv (using rd.get_history)
Hello LSEG Community, I am currently collecting data on many ESG ETFs through Refinitiv workspace using rd.get_history in Python. However, I would like to know if their is a function I can use to filter ETFs that I have downloaded from Refinitiv Workspace based on their specific Morningstar Ratings. This is so I can only…
-
CODEBOOK for Datastream
Hello Team, I have a client with a query as below. I am trying to use the CODEBOOK app (CODEBK) - a development environment for financial coders with a fully hosted cloud-based kernel for Python computations, closely integrated with Refinitiv. I am currently attempting to extract Scope 1 and Scope 2 emissions based on a…
-
impact of ESG in M&A transactions
Hello, I would like to know how I can select filters for my research regarding the impact of ESG factors in M&A transactions, initially for a general search, then for a comparison between Asia, Europe, and America, and subsequently for an analysis between sectors. Finally, I would like to compare the ESG scores of the…
-
Automate 8 digit CUSIP to pull Scope 1 and 2 emissions
portfolio_holdings CUSIP.pdf Attached are the portfolio holdings I have retrieved from the 13F holdings from Refinitiv. The column name "CUSIP" provides the company 8-digit CUSIP. My next step is to obtain the Scope 1 and Scope 2 emissions from each company listed here. This is only a small part of my dataset; therefore, I…
-
Download a desription of all ESG variables
Hello, How to download the a list with the name and description of all ESG variables that LSEG offers? For instance: DIR Score and its description what it means, etc.
-
ESG Scores for M&A Deals
Hi, I have a list of M&A Deals screen and I would like to obtain the ESG Scores of the companies involved in each deal (Target and Acquirer) in the year of the announcement and also 2 years later. I tried to use TR.TRESGScore on Excel but i would have to specify for each deal the specific date, is there any quicker way?
-
Missing data under Eikon but available through Datastream
Hello, I am running Eikon API through Python to retrieve quarterly historical information on certain indices from 2000-2022. However, my extract has certain unexpected empty cells for common fields like Market Cap and Total Return which are available through Datastream (Excel). Below is an example count of missing data…
-
Error fetching data for given date. Error code -1 | Backend error. 400 Bad Request Requested univers
Hello I am running an Eikon API code through Python to generate Excel output for different indices every quarter from 2000-2022. However, on several occasions, the code generates the following error on a given date: Error fetching data for 2012-10-01: Error code -1 | Backend error. 400 Bad Request Requested universes:…
-
Filter for companies with Carbon (CO2) emissions.
I wish to filter for U.S. companies with accessible CO2 emissions data. I have implemented this in the screener by establishing filters for, for instance, 5 and 10 years (filtering for GHG Scope 1 emissions > 0). Is there a method to filter for companies that possess emission data spanning the last 10 years (including…
-
Emissions data and estimation method: reporting data
Dear all, I am using Workspace add-in in Excel. I have several companies from which I would like to retrieve scope 1 and 2 emissions as a time series. I managed to do that using Datastream formula builder. Behind the emissions is an estimation method. I can retrieve this estimation method using the historical data in the…
-
ESG Data in Bulk.
I am trying to access ESG data in bulk. The purpose is to gather ESG scores point-in-time and compare the different cohorts of the ESG scores databases (backfilled vs non-backfilled). To do so, I am following this tutorial.…
-
How can I get data on further back than 3 years using the Screener-app in Refinitiv Workspace?
Hi there! I am trying to pull a data-set on GHG emissions Scope 1, 2 and 3 on companies in the STOXX 600 and SP 500 Indexes. I am using Refinitiv Workspace Desktop Client for Windows 11. I have found the right metrics, but when I use the Screener app in Refinitiv Workspace I can only get data for 3 years back? When I look…
-
How can I download ESG ratings for the full universe of companies for company reporting year 2021 us
I tried using the ESG CUSTOM SCORING TEMPLATE for retrieving ESG scores from all companies of each industry using Refinitiv Excel Add-in. However, the values of the ESG score do not match with the values which are presented in the Refinitiv Eikon Workspace (see screenshots). I am wondering if this is a common error?…
-
Matching ISIN codes with emissions data and accounting data
Dear all, Note: I am very new to using Refinitv so bear with me if these questions are very basic. I am currently working with a sample of ISIN codes that I retrieved from Screener in Excel earlier. This was my code: =@TR("SCREEN(U(IN(Equity(active or inactive,public,primary))/*UNV:Public*/),…
-
pulling individual esg metrics
Hello, I am trying to get the ESG metrics that an refinitiv ESG score is using to python. I am basically looking at trying to get each indivudal metric into a dataframe, but not the whole score. How would i go about doing this? I understand that i can manually write each metric i want, but my questions if there's an easier…
-
RDP Carbon Emission Data
Hi - I'm accessing carbon emission data from RDP (bulk-climate) via python. But the JSON files (of type Fundamentals Global) are difficult to normalize into any sort a table and I assume the files have to joined with CRReference and CRPeriod source to get to time dimension. Has anyone used these files and has any example…
-
Emission SCore and EmissionScore Grade_Methodology_Eikon
Hello, How can I get the methodology for Emission Score and Grade, please?
-
How to get ESG data for funds?
The case in the above screenshot uses a RIC for a fund which has ESG data on the Workspace. Unfortunately, when we try to read this into Python it does not return anything. The example case is MSFT.O and this loads the ESG data successfully. How would we do the same for Funds? One of the funds we are looking into is: Name:…
-
How to translate Excel formula into python syntax?
I need to extract historcal ESG through Refinitiv Eikon Python. i have the following Excel formula and need to translate it into python syntax, please! =@RDP.Data("AAPL.O","TR.TRESGScore(RollPeriods=True IncludePartialYear=True)","Period=FY0 Frq=FY SDate=2019-01-01 EDate=2022-12-31 CH=Fd RH=IN;date",C3)
-
How will I get the welcome email that contains credentials to access the API?
Hi. I am new here. I created an account on the Developer's community. I need to access the ESG data for which I will need the welcome email that contains my credentials like machine id, user id etc. what are the next steps to get the welcome email?
-
ESG Data Extraction through Eikon API
Hi team, Requesting assistance on the below query: What I need I to replicate the data I showed in the screenshot with the python API (Eikon python package). Currently I am usin the EIKON python package to retrieve ESG data from the API, I would like to include the source of the controversies in to the values of each…
-
ESG Data Access API
Hi, I need to know how to request a API Key from Refinitiv and use it to access the ESG Ratings data through it. Best, Khushal
-
How can I get instrument metadata from NDA via RDP API?
Hi , I'm from Refinitiv ACE team. We used self platform for update content with python language. Generally, we use Refinitiv Data Platfrom library to retrieve ric data from elektron. We have requirement to access NDA data for update metadata when some ric has stock event update. It's suggested that we can use ADC API…
-
Get ESG scores
I am writing a diploma at the university and I need data on the ESG rating of companies from SQP500 from 2016-2021 for every month (or at least for a year), but I can't pull this data from the Refinitiv as my university does not have access to refinitiv. Can someone help to collect them, or maybe someone has ready-made…
-
Are ESG scores from MSCI available on Eikon? If so, how is it possible to retrive data?
Just wondering where to get access to MSCI scores on Eikon platform. Are ESG scores from MSCI available on Eikon? If so, how is it possible to retrive data?
-
Content layer - ESG Bulk - FileNotFoundError: no init file found in folder
Hi, I am trying to collect ESG via RD and the Bulk method as shown on GitHub, but Getting the following error that seem to come from the RD library... Am I doing something wrong? # !pip install refinitiv-data import refinitiv.data as rd # pip install httpx==0.21.3…
-
Access denied to ESG data, due to missing scope [trapi.data.esg.views-measures-standard.read]
I am trying to retrieve some ESG data for a given ticker. I am getting an Error Code 403 | access denied. Here is a snippet of code: tst_ric = 'LTR.AX' response = esg.standard_measures.Definition(tst_ric).get_data() response.data.df This code leads to the following error: RDError: Error code 403 | access denied. Scopes…
-
ESG Scores and Pillar Scores for M&A Target and Acquierer
HI, I am using the Eikon API in Python. I am trying to get the ESG scores of the target companies at the day of the deal announcement and the acquirer scores on the deal announcement as well as 6 months after the deal is closed. I have the following code that partially works (I am not getting the exact date as per the M&A…
-
Get Date, Time and URL for ESG Controversies
Hi, I am trying to get the date, time and URL of certain news controversy categories. I used the "CODECR" app/ Formula Builder in Eikon to formulate the code. However, the results do not deliver the required date and URL (see picture) but they are available in Eikon (see picture). What is the problem here? Besides that…
-
Downloading multiple tearsheets at once
Hello I would like to download multiple Shareholder Activism Tearsheets at once. When I open the Corporate Governance Market Overview in Eikon, I can see a list of Shareholder Activism Campaigns with some high-level information (e.g. activist, target, status). However, I'm interested in more detailed data that I can access…