-
Clarification on RIC Suffix with “^”
Hi, I have a list of RICs that include the suffix “^” followed by a letter and number — for example, ARNC.N^H23 and GTX.N^I20. Could you please explain what the letter and number after the “^” represent? Thank you for your help!
-
S&P 500 Index constituents every month
How can I get S&P500 index constituents every month since 2012-01-01? I am using excel sheet to download the data. I have tried using the function =@RDP .Data(".SPX","TR.IndexConstituentRIC","SDate=2012-01-01 CH=Fd RH=IN",B1) to get the ConstituentRIC, but it returned NULL. May I know why and how to solve this problem?…
-
News Monitor 2.0 - Top news from a specific country
I´m trying to create a News Monitor 2.0 to look for the most important news from Mexico and USA. I have tried to filter them only to show me the most important ones about relevant matters like macroeconomics, commodities, equities, etc. Im also trying to generate a python code to send a top 10 list with the most important…
-
Adding story text to output using Python API
Hi I currently have the following code that is fetching specific new articles using Python API. However I am not sure how to add the story text to the output. I currently have the Headline, StoryId, and Link to the article. Code: df = ek.get_news_headlines( 'Topic:GB AND (SOURCE:CMPNY OR SOURCE:MCE OR SOURCE:GEN)',…
-
Volatility in the number of results returned.
I'm using a Workspace session to connect to the Data Platform to collect fundamental data for a subset of 1000 firms in my sample. Below is the function call and code (Python) that I use: response = fundamental_and_reference.Definition( df['ISIN'].unique().tolist()[0:1000],…
-
How do I get data for all the fields for the rics using ld.get_data() without providing the fields?
In refinitiv data library, while using rd.get_data() method, if we don't provide any fields, it returns data for every fields. But after migrating to lseg data library, when I try to use ld.get_data(), I get error that I have to provide fields name Is there a way, we can return data for every fields without passing the…
-
Is it possible to request the CARGO (Commodity flows) data thru API?
using RDP API, is it possible to request the CARGO (Commodity flows) data ? So all imports from Japan, in bbls. (Crude oil, Fuel oil and Dirty Petroleum) I want to query this in python can someone assist me on this from the relevant specialist group?
-
Retrieving annual reports using LSEG API
For a research project, I would like to download the annual reports for a large set of European firms over the period 2010-2023 (following a similar approach as in this article: Global Evolution of Environmental and Social Disclosure in Annual Reports - Lin - 2024 - Journal of Accounting Research - Wiley Online Library).…
-
How to get domestic/international revenue of listed companies
I met a problem when I used the Python API to obtain data in the LSEG Workspace. For listed company, for example, TSLA.O (TESLA), I want to get the fields in the LSEG Workspace which can obtain the ratio of international/overseas revenue or non-local revenue to local revenue of listed companies. Since there are hundreds of…
-
Retrieve historical Ultimate Parent given a LEI
I am creating a historical database to track track the relationships between fund managers and the ultimate parent of a fund. To do this, I am using the LSEG Python API. I have been testing this procedure using the rd.get_data() function. This allows me to retrieve the name and PermID of the ultimate parent for a list of…
-
How to properly use Python to extract data from LSEG workspace
Government bonds, for example RIC = 'GB10YT=RR', which is the 10 Year Government Bonds of the UK. I am trying to grab its daily data. At first, I am using fields=['TR.OpenPrice.date','TR.OpenPrice','TR.HighPrice','TR.LowPrice','TR.ClosePrice'] in my code. But The close price showed nothing. Then, I changed the fields to…
-
Excel Add-in
Hello, I am using Mac and want to have the Excel add-in displayed as shown below: (2.png) 2.png However, I only have the following: 1.png How to get access to the first one(2. png)? On windows I know that in the start menu, I can try searching for 'Eikon' then looking for 'Refinitiv Eikon - Microsoft Excel'. However, I…
-
Evaluation Number of members of the Executive Board
Hello, I am new to the Refinitiv Workspace and am currently investigating factors influencing executive compensation (empirical analysis). Unfortunately, I have not yet found the number of members of the management board. Is there a suitable key figure that tells me this? I would like to know the number of people who cause…
-
Chain call times out
Hello, I'm having a weird issue related to the refinitiv data API, especially the rd.discovery.Chain class. I'm using this class to retrieve components of governmental yield curves, by create a Chain class with the chain RIC that i need, then using the .constituents method to retreive the information. This works well 90%…
-
Search Query for Refinitiv Data Platform
I'm working with the Refinitiv Data Platform Library for TypeScript and trying to implement a symbol search using Search.definition. In the documentation it provides the following example: const definition = Search.Definition({ query: "IBM Bonds", select:…
