-
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…
-
Issue with rd.get_data - Server Connection Problem
Dear Support Team, I am experiencing issues with server connectivity when using rd.get_data in Python to retrieve data via API. Recently, I switched the library from Eikon to Refinitiv. While using rd.get_data, sometimes the function returns data immediately, but other times it takes a long time to respond and eventually…
-
How to calculate FX settlement date?
Hello friend, I'm using Workspace Settlement Calendar Calculator to calculate FX broken dates start date and end date, like the red box outlined in the screenshot below. I would like to know how to archieve this by Python. Thanks & Regards, Mark