-
FX cross in Turn Dates in API
Hi team, Specialist here from Customer Support. Related to this q&a Is there a way to retrieve Turn Dates for a specific currency pair directly on Python ? — LSEG Developer Community there is a specific parameter if you want to calculate CCy1 or CCy2 which is then discussed in this guide:…
-
Workspace API using LSEG Data Library does not show any result
Trying to pull data by Worksapce API (LSEG Data Libarry, desktop session) returns "Company Common Name", instead of "Toyota Motor Corp" by rics = ['7203.T'] fields = ['TR.CommonName'] df, err = ld.get_data(universe=rics, fields=fields) lseg-data version is 2.1.1 python code, log file and result screenshot is as attached.…
-
WS API How to Retrieve MBS, ABS, and Corporate Bond by Country or Currency
Currently, Our client is looking to obtain data on U.S. MBS (Mortgage-Backed Securities), ABS (Asset-Backed Securities), as well as corporate bonds categorized by country or currency. Until now, he has been using the following method to retrieve government bond data. However, he have not been successful in acquiring MBS…
-
Stream timeouts on websocket under python lseg.data API
We're streaming LSEG data using the LSEG Data Library for Python, using lseg.data.content.pricing. Sometimes— seemingly at random (different times of day, sometimes after streams have been up for hours, other times after just minutes), we receive Stream.on_status events with the following (example) payload: status: {'ID':…
-
Unable to load syntax in Workspace Codebook. Result only shows blank line or black square.
I am trying to run the code below but I'm only getting blank result or a black square as a result: import refinitiv.data as rd rd.open_session() df = rd.get_data( universe = [ 'FDBc1' ] , fields = [ 'CF_CLOSE', 'CF_VOLUME', 'HST_CLOSE', 'HST_VOLUME' ] ) display(df) and import refinitiv.data as rd rd.open_session() df =…
-
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],…
-
Workspace API python:Retrieve EUR-denominated French government bonds
Our client is currently working on the government bond curve for the European region. However, using the method below, He is unable to retrieve EUR-denominated French government bonds (while major countries such as Germany and Belgium are returned correctly). If you happen to know a way to obtain them, I would greatly…
-
Fewer Observations when downloading data again
Hello everyone, I am a PhD student and I've been using Refinitiv to download firm-level data for my research. I'm currently facing a problem. I downloaded my main dataset around September 2024. In March 2025, I needed to add another variable, so I re-run the same script to download the data through the Python API. The…
-
How to download documents from Research Filings?
Hello team, raising this query on behalf of client Llohann Dallagnol Speranca I have gotten a handful of URLs though the "TR.CSRReporting.esgsourceurl" field. However, most of the recent ones are files in http://filings.research.refinitiv.com. I would like to be able to download those reports as well. How can I do that?…
-
Why can't I access the news API? Neither in Workspace excel add-in, nor in python.
-
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…
-
How to get spot currency historical_data from Refinitiv Workspace
this is my code: def get_historical_data(rics: list, start_datetime: str, end_datetime: str): """ Retrieve historical pricing data for a given ticker and time range. Args: rics (list): The list of RICs (e.g., ['AAPL.O', 'GOOG.O']) start_datetime (str): Start datetime in ISO format (e.g., '2023-04-07T15:14:25.165')…
-
Retrieving Bond Rating Data Based on Tickers
I'm trying to retrieve the most recent bond ratings from Moody's, S&P, and Fitch from a list of tickers. I convert the list of tickers to both ISIN and RICs with this code that seems to work: I tried throwing the whole list of codes as either RICa rics = codes['RIC'].tolist() or ISIN as isin = codes['IssueISIN'].tolist()…
-
How to get historical price data of GOV BOND(EXPIRED/MATURED) like JP10504214C9 more efficiently
It seems to work below code but is there more efficiently codes like historical_function in workspace API? ### import refinitiv.data as rd import refinitiv.data.content.ipa.financial_contracts as rdf from refinitiv.data.content.ipa.financial_contracts import bond rd.open_session() import pandas as pd from datetime import…
-
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…