-
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:…
-
Refintiv Historical Data API. How do you get exchange information?
I want to get exchange information for time and sales data. How do I do this using the python code for historical_pricing? This is my python code: response = historical_pricing.events.Definition( universe=rics, start=start_datetime, end=end_datetime ).get_data() Is there a way to get time and sales data WITH exchange…
-
How can we request the CommoditySearch API for the particular ric code?
The request body for the request is as in the code block below. Here, we are receiving the response with unwanted Identifier value such as 'D-NGMMH25' with prefix 'D'? How can we get only the valid Identifier assigned to our user. { "SearchRequest": { "KeywordQuery": "NGMM", "ExpirationDate": { "@odata.type":…
-
How to use rdp.session.platform.Definition with RDP Password in refinitiv-data v1.6.2?
Hi Refinitiv Developer Community, I'm trying to authenticate to the Refinitiv Data Platform using the refinitiv-data Python library, specifically version 1.6.2. My environment is Python 3.12 running on Ubuntu. My goal is to establish a platform session using my RDP credentials (App Key, RDP Username [which is a Machine ID…
-
Python API - get Currency from ISIN (bond or equity)
-
How to load Excel Workspace Addin from python script?
Hello Team, I am trying to open an excel file from the python script, file is opening but when Workspace addin is throwing Exception error "Class not registered". Addin is getting loaded correctly when excel file is directly opened. I am sharing the code here, please help me resolve this issue asap
-
Using Getdata function to Get CUSIP based on RIC
Hello! Sorry, I need to change a bit about my question. When I was using Getdata function in Refinitiv Workspace API, I used RIC to get CUSIP (and I set the parameter: 'SDate' and 'EDate', I tried to make they are the same day to get the certain day's data). However, most of the transfer is right, some of the CUSIP I got…