-
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.
-
API Query for Private Company Data
I have previously pulled Screener data in R using the API (see code snippet #1), but for some reason I am retrieving zero observations when I do the same using formulas from the Private Companies universe (code snippet #2). Can someone help me get this query working properly? Code snippet #1: screener_formula <- 'SCREEN(…
-
What are the codes to use for Settlement Price and 1d Return for .NET API?
We are looking for codes to use for Settlement Price and 1D Return for .NET API. Any RIC will do.
-
Mutual Funds - Holdings data
Hi, i need some help please re: the below query for returning the assets held in a particular fund, but i would like some additional fields… data, err = ek.get_data('LP65070066', ['TR.FundHoldingRIC', 'TR.FundHoldingName', 'TR.FundNumberOfShares', 'TR.FundNumberOfSharesChanged'], {'Endnum': '1000'}) if err: print(f"Error:…
-
ALT_CLOSE and defaultPricingField is null
We use a service to pull historical data and would like to get clarification regarding the pricing fields. The service we use is: https://api.refinitiv.com/data/historical-pricing/v1/views/interday-summaries/{symbol} We typically retrieve the fields: "TRDPRC_1", "OFF_CLOSE" for closing price and determine the appropriate…
