-
Intermittent errors using Refinitiv Data Library via Python
My customer is getting intermittent errors when using Refinitiv Data Library API via Python (They were not getting errors when they were on Eikon API) The error code they get more often than not is....raise RDError (-1 except_msg) refinitiv.data.errors.RDError: Error code -1 Backend error. 400 Bad Request Requested…
-
What is actual master RIC to get all SPY and SPX options ?
Can you please tell me What is actual master RIC to get all SPY and SPX options ? . I want to download SPY and SPX options complete data of 5 years.
-
Can I filter for certain files using the filings endpoint?
I am using this endpoint Filings API | Devportal (lseg.com) and want to only return filings in English language. How do i set this? I tried 'Accept-Language': 'en' in the headers to no avail. Are there any payload parameters I can use? I would also be interested in any other filters/payloads we can add to a request to this…
-
Cannot download file from filings endpoint
For some files I get the following error when trying to download certain file urls, e.g. for emea1-apps.platform.refinitiv.com/Apps/AdvFilings/FRS_GET?DocumentId=78170311&ContentFormat=pdf): Document request failed, Exception is Could not find file…
-
How to efficiently and briskly retrieve datapoints for all SNP 500 RICs
Hi everyone, I am trying to retrieve some Fundamental and Reference data for all of the SNP 500 stocks. These datapoints include values such as Income before Extraordinary Items, EBIT, Capital, etc. Now, I am trying to asynchronously retrieve all of this data. At first, I tried to loop ethrough the list of the RICs of the…
-
Timed out on the end point
Hello, I have a loop to evaluate OTC Equity options via the end point: "https://eu-west-1-api.refinitiv.com/data/quantitative-analytics/v1/financial-contracts" and also tried: "https://api.refinitiv.com/data/quantitative-analytics/v1/financial-contracts" but am getting the error either way. I am passing 90 options at a…
-
Python for creating large databases
Good morning, I am needing to obtain a large amount of data for an institutional project at the University and I have not been able to do this, since the page collapses, as does the extension in Excel. They tell me that from Python there is a method to address this, I would appreciate any information about how I can use…
-
Refinitiv Data Library for Python: Error code 429
Hello, I'm using the Refinitiv data library for python. In particular, I'm using the following function and have been getting some errors for too many requests. Using rd.get_history(), we were pulling data for a total of 6,458 RICs, separating the requests out into loops of 100 RICs and 3 fields. We've only submitted…
-
rd.getHistory with Interval = tas and Conditions
I am trying to retrieve the 'CONDITIONS' data when calling rd_getHistory with the Time and Sales ("tas") interval for equity instruments: df = rd.get_history(universe, start = "2024-07-18T13:30:00.000", end = "2024-07-18T20:00:00.000", fields=["TRDPRC_1","TRDVOL_1","CONDITIONS"], interval = "tas") In Workspace if I display…
-
Certain Refinitiv Data requests work individually, but not concurrently (Python)
Hi everyone, I have an issue regarding concurrency with functions using get_data(). My workflow is as such where I have multiple requests of get_data() and get_history() in different asyncrhonous functions that I am executing concurrently using Python's `asyncio` library. Now, the issue is, when these functions are…
-
How to download adjusted close prices?
Hi!, I'm currently working on a portfolio optimization assignment in R and need to download the historical data for 10 stocks, including the adjusted close price to calculate the returns. However, when I downloaded the historical Excel data from Refinitiv Eikon, I noticed that it had it didn't have any column for adjusted…
-
Finding DHL Group in Refinitiv database
Hello, I need to find financial data for German companies (using Refinitiv worldscope fundamentals annual) but I cannot find the DHL group under its ticker DHL or name (or previous name Deutsche Post AG). The company does show up under the name Deutsche Post AG and the ticker DPW but the data is wrong since that is for…
-
Retrieve Time and Sales Data Information
Hello! To explain the background of my questions: I am working on a project where I want to identify individual trades above and below a certain value threshold. For example, I want to get the volume of AAPL.O for trades above $10,000. I use the Refinitiv Python API, specifically, the refinitiv-data library. Question 1: I…
-
Refinitiv API errors
I tried running this code (attached below). The code is inconsistent in giving results. It worked in the very first attempt for 12 companies but then it throws an error when I ran it for more than 2 companies and sometimes it runs in 3rd/4th attempts. In this inconsistency problem, we can not just say that this code will…
-
Migration of Eikon get_timeseries "tick" interval calls to rd.get_history
When requesting get_timeseries from Eikon Python API with interval ‘tick’, it would return Date,VALUE,VOLUME data: Date,VALUE,VOLUME 2024-06-27 13:30:00.135,135.79,200 2024-06-27 13:30:00.357,135.86,14 I would call it like this: while (rows == 50000): #and (df.index[0] >= start_date_time_obj ) : dfloop =…
-
Looking for historical credit rating bond data for a large amount of bonds on Eikon
I am looking to find historical credit ratings for a vast amount of bonds (spanning about 10 years). I can't search for a specific date because they were all issued at different times. When using codebook, I managed to find ratings for a large number of bonds but that was the rating at the time of my search instead of…
-
Historical option data
Good morning, I have been extracting expired options data through the Refinitiv Data Platform API and a couple of questions have arisen: I am trying to extract data from the year 2000 to the present, but I am only getting data from 2015. Is this due to a limitation of the API? When extracting the data, the Greeks do not…
-
Is it possible to get link/url to news article.
I am just working with the refinitiv news data apis. I'm just wondering if its possible to get the url to the original article? I can't currently seems to find that outputted by any of the endpoints. Thanks
-
API Playground not working
I can't seem to access the api playground. Keep getting this "access_denied" error message. Does anyone know why this is? Or if there is another way to get the documentation for the Refinitiv apis? Also I have covered my email in the screenshot, but I am signed in. Thanks
-
Data retrival using RIC vs CUSIP
I am using a list of RICs to retrieve data: fields = ["TR.CUSIP","TR.OPENPRICE", "TR.CLOSEPRICE", "TR.BIDPRICE", "BID", "TR.ASKPRICE", "ASK", "NAVALUE", "TR.NETASSETVAL", "TR.Volume", "TR.NUMBEROFTRADES", "TR.CompanySharesOutstanding", "TR.SharesOutstanding", "TR.Name"] month = rd.get_history(universe="TZA", fields=fields,…
-
Using RDP libraries , i want to get the futures first trade date, expiration date, futures contract
Using RDP libraries , i want to get the futures first trade date, expiration date, futures contract date using .net
-
What is the common identifier to merge M&A data from LSEG Screener and ESG data from LSEG Worksapce?
I have tried various identifiers like CUSIP, ISIN, SEDOL etc. but none is avaliabale for both of the datasets.
-
Using DSCD in Eikon API
Hi, I'm using the Eikon API (eikon, and refinitiv.dataplatform) in Python and was wondering if there is a way to use Datastream's DSCD to query Data in Python with the Eikon Api? So far I've only been using RICs for my queries, however, the number of DSCDs for which no RIC was available was quite significant in my case.…
-
Structure RICs
Hi is there any way to find about all RIC connected to a specific RIC Example: For 3 Month SOFR Futures its RIC is SRA, for its Future Outright chain its 0#SRA: for its Futures spread chain its 0#SRA-:, for its futures butterfly chain its 0#SRABF-: similarly for condor chain its 0#SRACF-:. I found these using hit and…
-
Need help on accessing RIC pricing information via refinitiv API
Hi, Tried below API on API playground - but seems access denied , tried refinitiv credentials but still not letting me in. can someone please help me on this please. need to get RIC snap via http request. Example below https://api.refinitiv.com/data/pricing/beta3/snapshots?universe=USD=,KIBOR= JSON response on API…
-
Get all futures contracts from ticker or isin
Hi all, I'm trying to find the query to get all futures contract info from the underlying isin / ticker. More specifically, i would like to input the isin/ticker of a security and get all the futures contract on that security. The final goal of this would be to get the RIC code of these contracts. Does anyone have an idea…
-
Price Target data retruning from rd.get_data when data exists in DIB
hello, for many symbols, for one example, CUSIP 094235108 DIB shows data for: 'TR.PriceTargetMedian', 'TR.PriceTargetMean', 'TR.PriceTargetNumIncEstimates', but when i pull the data with rd.get_data in python, all three return <NA>. is there a difference in pulling via CUSIP as i do in rd.get_data vs how Eikon converts the…
-
How to filter through for ETFs using the Morningstar Rating in Refinitiv (using rd.get_history)
Hello LSEG Community, I am currently collecting data on many ESG ETFs through Refinitiv workspace using rd.get_history in Python. However, I would like to know if their is a function I can use to filter ETFs that I have downloaded from Refinitiv Workspace based on their specific Morningstar Ratings. This is so I can only…
-
Get RIC code for derivative using the underlying RIC code
Hi, I'm trying to get the RIC code for some futures contract, especially for index futures. The data i have is the Underlying RIC code. I would like to see all futures contract on that index, with as much information possible so that I can find the one I need. I tried using a Definition Search with the DERIVATIVE_QUOTES or…
-
Filter for organizations with Empty GicsCode category via Python API
Using the Python Refinitiv.data API I want to filter for organizations without a GICS code. How can I setup the filter query to exactly filter for "" (empty string?) This is the code I am using: import refinitiv.data as rd rd.open_session() response = search.Definition( view = search.Views.ORGANISATIONS, filter =…
-
get_history stopped working in API (Visual code studio)
Hi, since few weeks ( not sure but I think after upgrading some python libraries like pandas etc.) I have problems with getting data using refinitive API in Visual code studio. for example I get empty df with this simple code: import pandas as pd import refinitiv.data as rd rd.open_session()…
-
What is the limit in rdp for number requests per second?
What is the limit of number of requests per second in RDP for these APIs: 1) /auth/oauth2/v1/token 2) /discovery/symbology/v1/lookup 3) /discovery/symbology/v1/lookup-type 4) /data/historical-pricing/v1/views/intraday-summaries/{universe} 5) /data/pricing/snapshots/v1/
-
Running a forloop on many ETFs in Python
Hello, I'm currently utilizing Python as my programming language with Refinitiv Workspace as the API. My objective is to construct a for loop to gather ETF tickers (approximately 500 ETFs) in Python, subsequently converting them into daily returns, and finally plotting these returns into an Excel file. However, I've…
-
Fetch news associated with RIC codes using RDP News API on T+1 basis
Hi, We are currently managing a list of approximately 2000 RIC codes and are looking to streamline the process of retrieving related news for each code, on a T+1 basis. Our goal is to identify and fetch news from the prior day that is related to each RIC code. We have not been able to find a working solution using the…
-
List of upcoming stock splits from Refinitiv Data Platform
Hi - Does anyone know if there is an API to retrieve a list of upcoming domestic stock splits (US and Canada) from the Refinitiv Data Platform? The RDP URL should start with https://api.refinitiv.com/... Thank you. Doug
-
Workspace is all blank (both App and Web ver.)
I have encountered an issue with the Workspace today; neither the app nor the web version seems to be working (please refer to the attachments). Is there any scheduled system maintenance for today? or any one face the same problem?
-
Issues downloading Economic Indicator history and even fields
Hi, i've got an issue downloading historic data for economic indicators. my code is this: df = rd.get_history( universe=['aUSSPDIVY'], interval="monthly", start="1924-03-01" ) print(df) aUSSPDIVY VALUE Date 2022-05-31 1.567599 2022-06-30 1.641982 2022-07-31 1.64768 2022-08-31 1.560287 2022-09-30 1.69635 2022-10-31 1.767346…
-
What does 0#NASDCONS.O RIC return
What does this RIC #NASDCONS.O return? And how to check what are the available one?
-
Issue to use rd.get_data
dear developer community i rise this topic to share with a strange behavior when using rd.get_data. Indeed, when i use rd.get_data to retrieve Refinitiv fields, the response status and time token depend on fields type requested (TR Fields Vs non TR Fields): - Fields requested contain only TR fields: the response is quick…
-
Cannot load the list of associated URLs from http://localhost:9060/api/rdp/streaming/pricing/v1/ for
Hi, I am using the refinitiv.data package in python when running Eikon on my desktop. All functions seem to be working correctly (e.g rd.get_history() works fine) but when I use rd.get_data() i am getting this error: Cannot load the list of associated URLs from http://localhost:9060/api/rdp/streaming/pricing/v1/ for…