-
Im having trouble the get aligned data with dates for some instruments
Im having trouble with the API. As you can see below, the resultant dataframe comes with null values on the last dates, and values on the first dates. The problem is that the "MATD3.SA" didnt exist before 2021. On excel, with same parameters, the dataframe comes alright, with null values up to 2014. So why is this…
-
API Rate Limit Issues
We're noticing weird behaviour on the response headers when calling PermID API using our token. Before we were receiving the following headers X-RateLimit-Limit-day X-RateLimit-Remaining-day which we use in order to manage our requests, but now the response seems to have changed, and we're not getting those headers…
-
Pricing basis for Physical Commodities
I want to get FX broken dates calculator to hedge basis price contracts for commodities e.g. Cotton. Sample code as below: df = ld.get_history('JCI-CTN-ANHUI','TRDPRC_1',start='01-Jan-2025',end='26-Jun-2025') #This is spot price for China Anhui cotton. df2 =…
-
Why am I receiving "a 'dict' object has no attribute 'url' in my API code?
Client is receiving "a 'dict' object has no attribute 'url" error message when trying this code on his end: import refinitiv.data as rd rd.open_session() df = rd.get_data( universe = [ 'US0378331005', 'US02079K3059', 'GB00BH4HKS39', ], fields =…
-
Usage of Screener in Python
I need to know how to properly work with the API so I can use all data and be able to filter through it as in the Screener. Therefor I use python. I need help with binding the API and accessing the necessary Data. Example: average ROE of the consumer Discretionary Sector
-
pricing/snapshots Market Cap field
Hi, How can I get the Market Cap of a stock using the pricing/snapshots service? https://api.refinitiv.com/data/pricing/snapshots/v1/?universe=/{RIC}Error or is there any other service that I can get the updated market data that should be change during trading time according to the stock price. Thanks!
-
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…
-
Download 10-K filings and time of receipt with Filings API
Hi, I had a question on using the Filings API (described here: https://developers.lseg.com/en/article-catalog/article/introduction-to-filings---python) : Is it possible to download both the document and its metadata at the same time? I need to download the 10-K filings for multiple companies and also need the exact time…
-
Cannot find the appropriate field to get data from Economic indicators
For the economic indicators, with RIC='aXZBISNXBR', which is shown below There is monthly data in the chart. But when I was looking for the field to get this data, I checked for the DIB, but I could not find the right Item Code for the indicator. I think it should be 'ECON_ACT'. But no data was shown when I checked for…
-
Eikon API request failed. Do you have an Eikon license and Eikon open?
Hi Team, I'm assisting User regarding an error in API. The client [GESG1-163451] mentioned that it was working two weeks ago. Troubleshooting Steps Taken: Verified workflow: Opened the Workspace application Launched RStudio/API Run the Codes and the error appears "Eikon API request failed. Do you have an Eikon license and…
-
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()…
-
Historical Yearly ESG Data
I'm using the Refinitiv Python API (refinitiv-data) to pull ESG data (2013–2024) for multiple companies. I want a wide format like this: I use the rd.get_history command (see screenshot below), and get a very large dataset with date in column 1, and instrument + variable for each column filled with many N/A values as the…
-
Historical data from ipo date
Hello, I would like to know how can I retrieve historical data from a stock from the ipo date without me knowing what is the ipo date? In this request: https://api.refinitiv.com/data/historical-pricing/v1/views/interday-summaries/RICI get only 30 days of history and If I use the parameters from start and end I need to know…
-
Error for pricing data
Hello, I was trying to extract the price for NVDA by the code below but got a 403 Error. Can you help me on that? import refinitiv.data as rd from refinitiv.data.content import pricing quote = rd.content.pricing.Definition( "NVDA.O", fields=["BID", "ASK", "TRDPRC_1"] ).get_data() RDError: Error code 403 | access denied.…
-
Issuer with Calendar services
Dear Developers community i'm facing an issue with calendar service (https://api.refinitiv.com/data/quantitative-analytics-dates-and-calendars/v1/calendars). Indeed, when i extract the calendars List available, i get 'USER_CLDR_1' in the list returned using API.