-
Can you explan about this API endpoint?
All, I am interested in the REST API, can you explain me what these endpoints are for? How can I get a permission of them and what is the price?
-
Why is data not flowing in API while available in Excel for active funds?
Hi Team, We have use Code like this one: import refinitiv.data as rd rd.open_session() df = rd.get_data( universe = ['LP68702800','LP68611492'], fields = ['TR.ISIN', 'TR.FundName','TR.FundObjective','TR.FundRIESGEnviron','TR.FundRIESGGov','TR.FundRIESGSoc'], ) display(df) These fund RICs are active so we are curious why it…
-
Eikon API Connection Refused
I am having issues with connecting to API via the APP KEY - it sucessfully works initially however after some time or restarting my computer when I try connecting with the same appkey it then suddenly fails and trying http://127.0.0.1:9060/api/status I get connection refused. If I generate a new appkey and then use that it…
-
Workspace is able to recognize specific SEDOLs but api fails
Hi, if you search 6195739 (sedol code), you'll get Chubu Steel Plate Co Ltd on Workspace; However, if I use rd.get_data(universe=['6195739'], fields=['TR.PriceClose']) it returns RDError: Error code -1 | Unable to resolve all requested identifiers in ['6195739']. However, if I use the corresponding RIC code: 5461.T, and…
-
Get "related instruments" using the refintiv.data API
Hi all, I'm looking into using the refintiv.data python API to calculate benchmarks for bonds. Right now the process is very manual and not scalable, I'm searching the bond in the workspace and looking at the "Related Instruments" tab, then creating my query and looking at the results. (see screenshot) I would like to use…
-
how to achieve USUM1P=ECI data
how to achieve USUM1P=ECI series data, with prelim publish data and prelim publish date. our economic data's logic is blur, user want to test market reaction when economic data publishes. But either cannot get the Latest data (for example, the latest data is of 13th September with no data), or cannot get the last publish…
-
Refinitiv Python Connection Open session HTTTP Request id 0; get_date failed
Hello, I'm using Python and connecting to Refinitv.data. The script is run by Task Scheduler, after rd.open_session(), the get_data() function is failed to perform. It worked well when I'm using Jupyter. Below is the message. Would anyone be able to help me with the issue. Thank you for your help. Best, Tim
-
Help on SEDOL to RIC Conversion
API - EIkon Language - Python Environment - Windows I converted some 5000 stocks SEDOLS into RIC. I got all the RIC. Named it RIC1 ric1=pd.DataFrame(ek.get_symbology(sedols1, from_symbol_type='SEDOL', to_symbol_type=['RIC'])) Than I converted all the RIC into string by the function…….…
-
Error on handshake url http://127.0.0.1:9060/api/handshake : ReadTimeout('')
Error:ek.set_app_key('') 2024-08-27 12:35:48,279 P[39232] [MainThread 43996] Error on handshake url http://127.0.0.1:9060/api/handshake : ReadTimeout('') 2024-08-27 12:35:48,280 P[39232] [MainThread 43996] Error on handshake url http://127.0.0.1:9060/api/handshake : ReadTimeout('') 2024-08-27 12:35:48,282 P[39232]…
-
PYTHON SYNATX FOR ACCESING NEWS USING GENERAL KEYWORDS
am currently using your API key through Python code for my application and have a few questions regarding its usage. * How can I access news through Python? For example (shown below), in your guide, you use the code “MSFT.0”. How can I find the corresponding codes for all my suppliers (manually searching is difficult since…
-
how to get multi-language company name by eikon api
how to get multi-language company name by eikon api
-
Align ESG data with market data (in time).
I'm working with the EK API to get ESG data with market and fundamentals data for a company (e.g., AAPL.O). My goal is to pull fields related to price, market cap, ESG scores, and Scope 1 emissions (and other extra-financial data). I have problem aligning the dates. Here is the code I'm using: fields = [ 'TR.PriceClose',…
-
Company Events Data do not get downloaded in Python Workspace API
When using the Python Workspace API under Windows 10, Events data for companies are not getting downloaded, even if parameters (e.g. Start-End Dates or Event Types) are changed. For example, the following code:…
-
Async retrieval of Quarterly and Period Data
Hi everyone, I have a question regarding data retrieval by periods. Over here, is the equivalent of what I am trying to do, just that it is using get_data() instead of get_data_async(). This is an example that I can't make asynchronous: quarterly_revenue = rd.get_history( universe=[f"{ticker}"], fields=["TR.Revenue"],…
-
Download bond prospectus via API
Hi all, I am trying to download a list of corporate bond prospectus available at Eikon (around 3000 bonds). I have the ISIN and RIC of bonds. Is there a way of bunch downloading from API? Many thanks!
-
Unable to connect on VS Code Python
Hi there, Whilst I have been using CodeBook, I'd also like to code locally on my machine and use Visual Studio Code. However, the following script returns an error and as a result I am unable to connect: import refinitiv.data as rd from refinitiv.data.content import news from IPython.display import HTML import pandas as pd…
-
Downloading 10k filings LSEG Workspace
I want to download 10k filings for specific companies. I can select multiple companies and then press the download button in lseg workspace under the fillings tabs. The downloaded 10k filings are in pdf is there a possibility to download these filing as html?
-
Batch Save of Call transcripts
Hi, using LSEG Workspace vers. 1.25, "Advanced Events Search" app (ADVEV), after finding Earning Conference Call transcripts I need, the buttons "Batch Print" and "Batch Save" lead to a request to install "Batch Print/Save App". Even if installed and running, request continue and no download is possible. Strange thing:…
-
JET in Workspace?
A partner company that I work with has a single version of an app, that is used in both Eikon and Workspace. That app uses the JET API to retrieve some basic data. A customer has reported a problem, which appears to indicate that JET in Eikon and JET in Workspace are returning different data. What is the status of JET in…
-
How to Efficiently Retrieve TR.PrimaryInstrument for Delisted Equities?
Hello everyone, I'm currently working on a project where I retrieve RICs and PrimaryRICs for a set of ordinary shares from various global markets using the Refinitiv Research API (EQUITY_QUOTES) through codebook. Then I use the PrimaryRICs to gather fundamental data for these companies. However, I've encountered a problem…
-
1\. Are you allowed to access the Refinitiv Data Platform real-time services via websocket
1\. Are you allowed to access the Refinitiv Data Platform real-time services via websocket. 2\. If you are: what is the hostname and authHostName (the authentication hostname) , they could be the same. 3\. What is the current and relevant code example in either Python or C#. 4\. Is there updated documentation that we can…
-
Eikon Data API to fetch Tesla's current stock price into Google Sheets
I am trying to use the Eikon Data API to fetch Tesla's current stock price into Google Sheets, but I keep getting an error saying that the endpoint is incorrect. Where can I find the correct endpoint, or could you provide an example endpoint for me?
-
Issues with rd.open_session (python API)
hey guys, I'm trying to run the following lines: import refinitiv.data as rd rd.open_session() trading_instrument = 'ESc1' prices = rd.get_history( universe = trading_instrument, fields=['TRDPRC_1'], start = "1997-01-01", end = "2024-07-31", ) prices = prices.loc[:,~prices.columns.duplicated()] prices and now I'm getting…
-
Is there a way to batch download filings for a particular SDC Deal Number?
I would like to download the filings for a particular SDC File Number but I have to manually download one by one. Is there a faster way to do this such as batch download functionality?
-
How do I get the Eikon equivalent of calcdate in dsws API?
How do I get the Eikon equivalent of calcdate in dsws API? The Eikon API call is: =@TR('ASX300 List'!J3:J500,"TR.RecMean.calcdate;TR.NumOfRecommendations;TR.NumOfStrongSell;TR.NumOfSell;TR.NumOfHold;TR.NumOfBuy;TR.NumOfStrongBuy;TR.PriceTargetMean;TR.RecMedian;TR.RecMedianLabel","SDate=1D CH=Fd RH=IN",$AB$1) DSWS API call:…
-
Error code -1 | timed out
Hi, im trying to create a request using this code: ek.set_app_key(refinitiv_key) rd.open_session() start_date = "2023-1-1" end_date = (date.today() - BDay(1)).strftime("%Y-%m-%d") tickers = pd.read_excel(ruta_insumos+"\Diccionario_Eikon.xlsx",sheet_name='Mercado')["Ticker"].to_numpy() tickers = tickers.tolist()…
-
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,…
-
Python refinitiv.data Screener not working
I have the following screener code in python ... import refinitiv.data as rd rd.open_session() syntax = ( 'SCREEN(' 'U(IN(Equity(active,public,primary))),' 'TR.CompanyMarketCap(Scale=6)>=300,' 'TR.F.NetDebtToEBITDA(Period=FY0)<=3,' 'NOT_IN(TR.GICSIndustryGroupCode,4010,4020,4030),' 'IN(TR.RegCountryCode,IN),'…
-
how to use RefinitivData API in Django app
I want to use refinitiv.data api to get some data in Django app, when i open session An error occurred while requesting URL('http://localhost:9060/api/status'). ConnectError('[WinError 10061] No connection could be made because the target machine actively refused it') An error occurred while requesting…
-
Failed return when pass the parameters to get_data
Hello, I'm new to the TR API and have been using Python to perform API queries. My script has been running smoothly for about two years. However, when I attempted to run it this week, I encountered various errors. After reviewing the code in my backup (codebk), it appears that the function get_data([list], 'Instrument')…
-
Eikon API - Extracting Ownership Information at the Quarter Level
I am using the Eikon API to pull firm ownership information in Python. I only need the resulting df to contain four variables: the firm's ticker, the date for the shares held, the number of shares held, and the investor type. My issue is that it is pulling the information for each specific investor, whereas I would like…
-
How do I fix the duplicate dates when I try to retrieve the TR.FIXINGVALUE for USDSOFR= using Worksp
import refinitiv.data as rd rd.open_session() df = rd.get_data( universe = ['USDSOFR='], fields = ['TR.FIXINGVALUE'], parameters = { 'SDate': '2024-07-01', 'EDate': '1D', 'Frq': 'D', 'CH': 'IN;Fd', 'RH': 'date' } ) display(df) When using the above code instead of returning the values for 24/07/2023 it duplicates the value…
-
Shareholders report not loading
Good afternoon everyone, For some reason shareholders report of ownership is not loading and this red error pops out. it was working fine till today. Everything else works fine but just this shareholder report is not loading. Thanks in advance.
-
How can I retrieve in Excel historical swaption volatility surfaces?
I need to get swaption volatility surfaces for a time lenght of at least 8/9 years. I have 14 different exercise dates and 14 different tenors. It is for my master thesis. I looked up at the Q&A and I tried to insert them with RHistory function: =RHistory("EUR3MX1Y=TTKL; EUR3MX2Y=TTKL; EUR3MX3Y=TTKL; EUR3MX4Y=TTKL;…
-
Issue with "WorkspaceRefreshWorksheet" on Workspace VBA
I'm having difficulty with including the workbook name on "WorkspaceRefreshWorksheet". I'm using: Sub WSRefreshSheet() DoEvents Application.Run "WorkspaceRefreshWorksheet", True, 120000, "[Book1]Sheet1" DoEvents End Sub But it doesn't run unless I remove the Workbook name ([Book1]). Works perfectly fine if only "Sheet1" is…
-
Hi Team, one of our client is facing issue with Macro not working when try to save PDF
Macro1.PNG Hi Team, one of our client is facing issue with Macro not working when try to save PDF
-
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…
-
How to retrieve historical swaption volatilities in Excel?
I need to get swaption volatility surfaces for a time lenght of at least 10 years. It is for my master thesis. I looked up at the Q&A and I tried to insert them with RHistory function: =RHistory("USD3MFSR";"BID.TIMESTAMP;BID.CLOSE";"NBROWS:1500 INTERVAL:1D";"CH:IN;Fd STREPEAT:N";B3) Unfortunately it's not working. It says…
-
How to download CPI data from eikon api
I would like to download US monthly CPI, norminal CPI and core CPI via eikon api. However, I cannot find relevant api functions for this purpose. I would appreciate if anyone could point me to the right direction.
-
Refreshing a Specific Worksheet on Workspace VBA
Having difficulty with using the Application.Run "WorkspaceRefreshWorksheet" VBA function on Workspace. I found the information below on refreshing worksheets: 2 - EikonRefreshWorksheet takes a third optional parameter worksheetToRefresh. This is the name of the worksheet to refresh. It can be in "[Book1]Sheet1" format to…