-
In RDP API Datagrid I get a few total assets values for the same fiscal year period. How is that pos
In RDP API Datagrid I get a few total assets values for the same fiscal year period. How is that possible? Please see screenshot attached. I have many similar examples.
-
Error when connecting to Eikon via Python
Hi, I am using Python to connect to Eikon using my windows 11 PC. When I tried to run the following code: import eikon eikon.set_app_key('app_key') The terminal returned with the following errors: 2024-09-11 14:26:31,219 P[8112] [MainThread 3920] Error on handshake url http://127.0.0.1:9060/api/handshake : ReadTimeout('')…
-
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…
-
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…
-
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…
-
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…….…
-
how to achieve USUM1P=ECI data
As our economic data's logic is blur, I cannot find out via which Ric i could get USUM1P=ECI 's latest published data. the Ric CF_Last not work. And eikon.get_data('USUM1P=ECI', ['ECI_ACT_DT', 'ECON_ACT', 'TR.IndicatorLastObservationDate']) not work either
-
How to retrieve monthly institutional shareholding data for over 200 firms from 2003 to 2023 using E
Hi everyone, I am relatively new using Eikon API and I am also relatively unfamiliar with the code. I want to retrieve the monthly institutional shareholding data for about 200 firms from 2003 to 2023 without having to download the shareholder report for every company one by one. Specifically, taking one company's…
-
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]…
-
Start from LEI to get company information
New user of Code Book inside Eikon API. I want to start with LEI and find corpororate information like parent LEI and industry code. Input: ZYBR0GI2DCOB4RV8NO37 Output industry group: debt fund
-
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',…
-
Missing Data for multiple rics
Using the Refinitiv.Data nuget package for c# and Eikon login information i am missing data for a number of rics example below ENOYBLARHZ5 2024-06-26 to 2024-07-15 ENOYBLCPHZ5 2024-06-10 to 2024-07-15 My query returns data both before and after the intervals listed above…
-
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…
-
How to know the currency in which my data is collected ? (using Python Eikon Data API)
Dear network, I am currently collecting companies financial data for my master's thesis, using Python Eikon Data API. I want all my data in USD but some companies have different standardized currency (eg file attached). When I collect the data with Jupyter, I don't know the currency of the data, and then how to convert it…
-
Obtain list of all equity indices in a country
Hello, I'm working with Datastream and Eikon. I noticed that on the Datastream navigator we can get access to a list of equity indices for individual countries ("markets" as per the Datastream Navigator terminology)--see attached screenshot for reference.Capture.PNG To avoid manual work, I would like to use Python and my…
-
Obtain Closing Price of stock on set series of dates and return NULL if there is not data for that d
Hi All, How can I obtain the daily closing price for a stock for specified dates, returning NULL on any specific dates that do not have data? I'd like to obtain the daily price of several stocks over a set period of time. Ideally my output will look like this: Where a day that the latest closing price is not available…
-
HTTP request failed: Invalid port: 'None'
We are not able to use Eikon API . When we run the python code, I get error " HTTP request failed: Invalid port: 'None' this is the sxs logs that we got
-
How to extract DV01 from 10 year US Treasury Yield curve using Eikon API? The data is on a page of R
-
Error: No Proxy Address Identified
Using Eikon library for Python imported as "ek" Eikon application is running. App key is generated and enabled. When running ek.set_app_key('xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx') I get following error: 2024-08-12 12:28:48,546 P[22820] [MainThread 13216] Error: no proxy address identified. Check if Eikon Desktop or Eikon API…
-
EikonError: Error code 400 | Backend error. 400 Bad Request for data item "TR.ConsHoldPctPortfolio
I tried to send again a request including the "TR.ConsHoldPctPortfolio" variable, but it seems that the Eikon API still cannot return the required data (specifically for that variable). I tested this several times over the last 3 hours. I tried replicating using the additional syntax, but to no avail. Could you please…
-
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?
-
Is there a way to pull up TOP NEWS app -> COMMODITIES -> ENERGY into API in Eikon?
We wanna see trending topics, last news, market snap shop
-
Is there a way to obtain OSP/WLD quote data page in API in Eikon?
-
Error code -1 | UDF Core request failed. Gateway Time-out Requested universes: ['ENP-WKLFET-EIA
The customer is using below code but getting error-Error code -1 | UDF Core request failed. Gateway Time-out Requested universes: ['ENP-WKLFET-EIA import refinitiv.data as rd rd.open_session() df = rd.get_data( universe = ['GB2YT=RR'], fields = [ 'TR.BIDPRICE(Frq=D,SDate=2020-01-01,EDate=2024-07-30)',…
-
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…
-
get_news_headline and quotation marks
hi there! im trying to use the get_news_headlines function to pull out headlines for a list of entities. The list if entities are saved on to a txt. file saved locally on my computer. As an example, my txt file contains the name "SINGAPORE AEROSPACE MANUFACTURING PTE LTD". While running the get_news_headlines function, I…
-
Refinitiv Data API performs worse than Eikon on large universes
Hello. I've recently been looking at implementing the Refinitiv Data Library in existing code over the eikon library. I've found that when large universes are specified, the refinitiv data library performs significantly worse than the eikon library. Following some testing some strange results were found. For example: When…
-
ALL App keys shown as incorrect App keys
I'm a new user to Eikon data API. When I try to use the api keys I got from App Key generator. I get an error saying The output is the same irrespective of using Codebook or Jupyter, If I use my colleague's app key it works without issues
-
Unable to use App Key generator
I'm trying to use the App Key Generator and when I open the app key generator app it gives me an error HTTP error:403 Forbidden.
-
"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…
-
Not same fields available from .Net vs Python for get_history
Hello, It seems that we cannot query the same fields for historical prices from Python and .Net. We would like to query TR.TotalReturn in the .Net C# API as such : var response = Summaries.Definition(new List<string>() {"0001.HK"}) .Fields(new List<string>() {"TR.TotalReturn"}) .Interval(Summaries.Interval.P1D) .GetData();…
-
Error 503: Server unavailable. Waiting 1 seconds...
When trying to fetch data through the EIKON API, I get a 503 error indicating that the server is unavailable. It was working perfectly until a few days ago, but now it has stopped functioning. i need some help on this: Error 503: Server unavailable. Waiting 1 seconds... Failed to retrieve data for CAL-SP-D1H09 after 10…
-
The problem if I don’t start python as an admin thet eikon redirects me to cfauth.com when authentif
When we don’t start python as an admin then eikon redirects me to cfauth.com when authentificating and not to localhost:9060 [2024-07-17 15:00:41,878;s] - [INFO] - [log] - Send GET request to http://127.0.0.1:9060/api/status to detect API Proxy... [2024-07-17 15:00:41,879;s] - [DEBUG] - [log] - Request to…
-
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 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.
-
Filings and ESG API issue
I would like to clarify a few points. It seems the API we are requesting is not a real-time data API from exchanges. The first one is the Filings API from the following thread: https://community.developers.refinitiv.com/questions/100586/retrieving-annual-reports-using-eikon-api.html. Below is the screenshot of the response…
-
How to include dates into ek.get_news_headlines
Hello, I want to get news data from the 2000s. It seems that I need to use ek.get_news_headlines instead of rd.news.get_headlines. However, I can't figure out how to include dates in my code. It gives an error every time. For example ek.get_news_headlines(query='Topic:LSEG and Language:LEN', count=10,…
-
Field for Frequency or Interval
Hi, I have a list of RIC. I want to fetch the frequency or interval of each. Some of them are daily, some weekly, quarterly and so on. I don't want to check one by one. What is the fastest way to have this info? is there a field to specify this. I am using eikon python API. I also use the Excel Eikon plugin.
-
How to get fund portfolio data
I use Eikon in Excel. 1. How can I get a list of all Korean mutual funds? Even though I used the code below, an error occurred and I was unable to obtain data. =TR("FDS_ALLFUNDS", "RIC,Name", "COUNTRY=South Korea;FUNDTYPE=Mutual Fund") 2. How can I get 10 years of quarterly fund ownership portfolio reports for all the…