-
Is there a possibility to do a regression/correlation analysis of ESG KPIs and the ESG Score using A
Client wants to pull ESG KPIs and the ESG Score through API and do a regression analysis to see if the values affect each other.
-
install the refinitiv library for python
I have just tried to install the refinitiv library for python on my computer. Unfortunately there are “unsolvable” version conflicts - see screenshot attached Apparently the library only supports outdated pandas (max 1.6.0) versions (I have installed 2.2.2), which are not compatible with the installed Python version…
-
How can I use the result of first code as universe for the second set of codes in python API?
For example =@TR(TR(TR(M20,"TR.FiIssuerOrganization","CODE:ISIN"),"TR.CreditRatioPD") This one retrieves first the issuer organization id from the ISIN of the bond Then after getting the organization ID, it gets the default probability. All in one go. So the formula has 2 layers, one for getting org id, then another for…
-
[WinError 10061] No connection could be made because the target machine actively refused it
I had this weird issue from the new Python API for workspaces. Error using get_history_func>get_history (line 206) Python Error: RDError: Error code -1 | [WinError 10061] No connection could be made because the target machine actively refused it It doesn't happen all the time but frequently and last for 2-3 days (maybe…
-
Workspace API Query
I am using refinitiv.data version 1.6.1 and Python version 3.12.4. My current subscription is for Refinitiv Workspace. I have the following questions: * Is there any option to use the Python API without getting kicked out of the workspace desktop session all the time? * What is the exact difference between eikon library,…
-
"Too many requests" when trying to download historic bond yields
Hello - I need to download historic yields for bonds -- and the size of the download would be too big for Excel. When I increase the size of the download, I get errors, usually this one: "RDError: Error code 429 | Too many requests, please try again later." I've also just had timeouts or it returns empty data frames. Below…
-
Symbol support with Workspace get_history
I am migrating a solution from Eikon to Workspace. Here is code to pull some daily bars: import sys import refinitiv.data as rd import pandas as pd import datetime rd.open_session(app_key =<>KEY) Symbol_T = sys.argv[1] Date_T = sys.argv[2] universe = [Symbol_T] df = rd.get_history(universe, end = Date_T,…
-
Eikon to Workspace API
1. Is the Workspace API compatible with Eikon Desktop Data API or is there a need to revamp the application? We use EikonDesktopDataAPI.dll. 2. Does the Workspace API support leased line connection?
-
Industry Median fields not working
Fields related to the median industry (found in Codecreator) are giving me error 414. Is it something related to these fields or what is the reason? Any alternative would be appreciated. from refinitiv.data.content import fundamental_and_reference fields = [ 'TR.MedianIncAvailToComExclExordItemsMargPct',…
-
SCREEN syntax changes when moving from Eikon Python API to Workspace Python API
I have a SCREEN implementation in Eikon API using Python that has been working fine for many months: instrument = "SCREEN(U(IN(Equity(active,public,primary,countryprimaryquote))),IN(TR.ExchangeMarketIdCode,XNYS),BETWEEN(TR.Price52WeekHighDate,20240628,20240628))" df, err =…
-
Get Intraday Prices for European Governement Bond
Hello, I want to get intraday prices minute by minute for European Bonds (traded prices and volume) for Portuguese government bonds at the intraday level (tick, minute, hour). Let use the RIC: PT10YT=RR I managed to get quotes for last price of the day but not all intraday prices in a frequency of minute by minute. Thank…
-
Refinitiv .Net API Intraday Summaries Request TimeZone
Hi, I am requesting 1 minute candles for EUR= with the following: var DataResponse = Summaries.Definition().Universe("EUR=") .Interval(Summaries.Interval.PT1M) .Count(1440) .GetData(); I see that the timestamps for the returned records are in local time. How would I request them to be returned in UTC? thanks
-
How can I print an Workspace QuoteApp Window from workspace Excel VBA
Hello I'm using workspace , could you please tell me how i can open a print quote from refinitiv workspace VBA ? I used "reuters://REALTIME/verb=FullQuote/ric= on refinitiv EIKON excel , but with Workspace excel , it doesn't work
-
Volume becomes N/A when you adjust the end date.
Replicated the code and notice that the issue is replicable: The Last day becomes N/A for March 29, 2004, when we adjust the end date to March 30,2004 then the 29 has value and the N/A moves to the day 30. Here is the code try changing the End date into march 29, 2004 then 30 and then 31 import refinitiv.data as rd…
-
Why the 2nd get_history is failed
Hello. I have a python program (using refinitiv.data library) that will obtain the refinitiv data twice: 1st part. get_data for [ 'trd_status', 'CF_DATE', 'TR.ACCUMULATEDVOLUME(SDate=0,EDate=0,Frq=D)', 'TR.ACCUMULATEDOFFBOOKVOLUME(SDate=0,EDate=0,Frq=D)' ] for a list of securities, which works fine. split_rq3 =…
-
Joint Organisation Data Initiative (JODI) app data into API
Client is using data on the JODI page and would like to incorporate this with our Excel data base using an API. Though c noticed there is no RICs for the curves, what would be the workaround, without having to download the curves manually via the export to excel icon?
-
Unable to retrieve mid price for WTI futures using get_history
I have issues with the python API. the get_history function works fine for certain RICs but I am getting errors for others, for instance: df = rd.get_history( universe=["LGOc1"], interval="1h", fields=["MID_PRICE"], count=1000) df = rd.get_history( universe=["CLc1"], interval="1h", fields=["MID_PRICE"], count=1000) An…
-
Is it possible to get the dataframe list of powerplants from POWOUT app into Codebook?
Hi Team, Is it possible to get the dataframe list of powerplants from POWOUT app into Codebook? Kindly advise. Thank you in advance.
-
Starting Workspace APP from python (Windows 11)
On the way to batch run my data collecting. Plan is to schedule a .py script ( which of course contains import refinitiv.data as rd ) For the API to work, the desktop app needs to run, no other way I am told. Hence, how can i start the app from a python script? Saves me a Task Scheduler entry ... Task Scheduler being ...…
-
How to add historical date when using the quick function, GRMEDIAN, from Workspace Excel to Python?
Refinitiv Data Platform (Workspace) - Python - Windows How do we add a date as a row header from the code below? This produces historical data and the client asks if we could add dates for each data point. import refinitiv.data as rd rd.open_session() df = rd.get_data( universe = ['NVDA.O'], fields =…
-
Infrastructure 360 (GINFR) through Python API
I'm looking for a way to access the data available in LSEG Workspace under "Infrastructure 360" (GINFR) through the Python API. They don't appear in the DEALS_MERGERS_AND_ACQUISITIONS and LOAN_INSTRUMENTS views, which is reasonable. However, I haven't been able to find any record of them by just searching for the…
-
How can I pull "Private Equity/VC" data from the SCREENER app using the Eikon API?
I would like to pull data from the SCREENER App on Private Equity/VC using the Eikon API. In WorkSpace I do this by opening the SCREENER app, setting "Universe" to "Private Equity/VC" and then setting any other filters I need. Based off this documentation of how to use the API to pull data from the SCREENER App, it appears…
-
What Happened to Efficiency Ratio?
Hello everyone, Does anyone know if there have been any changes related to the Efficiency Ratio? I can no longer find it in the fundamentals of companies, and when I search for it in the search areas by manually entering the column, it only provides me with the most recent data available and not the annual data. The same…
-
Company Delisting Study
Output.csv.zip Greetings! I am writing to seek your expertise in enhancing a sophisticated codebase designed to extract Reference Instrument Codes (RICs) from the three principal U.S. exchange markets: NASDAQ, NYSE, and NYSE American. This code efficiently retrieves both historical and current data, focusing on detailed…
-
Can I download company annual reports in a machine readable format?
Is there a way to take a list of RICs (say, 100 RICs) and for each of them download the text of their corporate annual reports into some format readable by a machine, such as a dataframe -- i.e., I don't want to download 100 pdfs. thanks!
-
Retrieving parameters e.g. free float of a stock via workspace API
Hi, i use the Workspace API and i want to retrieve some parameters e.g. the free float of a stock. Is this possible and how does it work? What parameters are available via the workspace API? Is there a kind of overview available? Thanks, Stefan
-
Refinitiv ISIN into RIC search for Bond
Hi, there are a number of questions and answers on this topic though it appears nothing is consistent / simple. I am accessing refinitiv data library via a workspace access The tutorial sugges the below to retrieve a RIC from an ISIN.... import refinitiv.data as rd from refinitiv.data.content import symbol_conversion #…
-
Fixed Income Indexes
Hi, all, I'm trying to get historical prices for fixed income indexes. But I get different results depending if I use RDP api (desktop session with Workspace app) and Eikon api (desktop session with Eikon desktop app). This is code for RDP API: import refinitiv.data as rd bond_indexes =…
-
Getting bond priced given CUSIP and given yield
Hello Team, I am interested to get bond pricing for a given CUSIP and given yield hoping the backend can use the Bond terms in EJV(FI database). I tried the Bond_Pricing.ipynb examples and used different CUSIPs but none of the various examples(Bond Pricing, Single Bond, Individual Pricing Parameters) in CodeBook work(for…
-
how to use Eikon API to get stock RIC code
Question: 1. We get a stock information: 600687.SS and how to use Eikon API to get stock RIC code? We use Eikon desktop to find the RIC code is 600687.SS^C21. This is a delisted stock. 2. Could we use search function and how to write the statement? Thanks. Python statement we used now: data, err =…
-
Grain Tender data via API
Is there a way to get GRAINTENDERS via the api? GRAINTENDERS is not really an instrument key or a chain. I have tried df = ek.get_data(['graintenders'], fields="Commodity") and df = ek.get_timeseries(['graintenders'], start_date=start_date, end_date=end_date, fields="Commodity") But get "nothing found" or invalid RIC.
-
FTSE Russell Green Revenues
On Workspace if I search for the company 'AAPL.O', under the tab 'ESG', then 'FTSE Russel Green Revenues', what are the fields for getting this data via the workspace API? I can't seem to find any related fields via the data item browser.
-
Data API Proxy "unavailable"
Sent here by the Refinitiv Workspace support team. This is the problem: * I am running Workspace Desktop version 1.23.269 on macOS 14.1.1. * I have generated an "Eikon Data API" and can use it successfully with refinitiv.data in the CODEBOOK app inside Workspace. * In any local Python environment (i.e. outside of…
-
Is it possible to pull Exponential Moving Average data using the RD Library?
I am looking to get EMA intraday data for Tesla, but I am unable to find the correct data item. Please see screenshot. Thanks in advance.
-
historical analyst data download
Hello, Could you help me write the command in Excel Workspace to download historical analyst forecast data for all public companies? This is what I have as of now... thank you!…
-
I have PermID and Issuer names and I need to retrieve the cik numbers for these issuers. Can someone
I have PermID and Issuer names and I need to retrieve the cik numbers for these issuers. Can someone help me with the code to do this? I am using Workspace in my computer.
-
Python: "import eikon" works, "import refinitiv.data" runs but returns no data
I am new to the api and trying to figure it out. I have Workspace and was able to create an api key which I have been testing on my own Python programs successfully, so long as the sample code is based on: import eikon as ek However, when I try to recreate code that is based on the import: import refinitiv.data as rd Calls…
-
How to load in live options quote data in Python using Workspace API?
I currently have Workspace open and I am looking at the derivatives tab of the SPX. It has exactly what I am looking for: different strike prices with different maturity dates and bid, ask, volume, and open interest data on those derivatives. I am trying to load that exact data into my own Python program in real time using…
-
Can I get Investor portfolio history report (INVPORT) via Eikon API
I want to pull out data in the snapshot using Eikon API. Thanks in advance
-
API Eikon RICs Information with Minute Frequency back to 2022 and 2021
Hi, I'm trying to retrieve historical information of a specific RIC back to 2022 (also 2021 I need) with a "minute" frequency via the Eikon API but there seems to be no data available (I'm using Python). Could anyone help to understand if there are any workarounds or any other function or way to recover the date. Below is…