-
Refinitiv Data Library performance significantly worse than Eikon Data API
Hello, Due to the fact the Eikon API is going to be phased out, I've started looking at replacing code from using the Eikon Library, to the Refinitiv Data Library in Python. Currently everything is clear and going smoothly, but I've noticed that the RD library has significantly worse performance than the eikon library. For…
-
Fetching data of company level in python
Hi, If I search for a given ric (GE), and go to Ownership tab. We get data like Top Investors, Investor Type, Breakdown, and Holding Concentration. I want to extract these for a company over time through a codebook in Python. How can I do that? Thank you for the help.
-
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.
-
Convert python code to ‘import eikon as ek’
Hi Team, Can you help me to use eikon api and use the command ‘import eikon as ek’ to import the code below? import refinitiv.data as rd rd.open_session() rd.get_history( universe='CBF24^2', fields=["SETTLE"], count=1, ) Could you please provide the code that can be used through eikon package? For some reason, seems…
-
Error Retrieving Data through Eikon API
Hi Team, I managed to install the eikon package and set the app key, however, when I tried to run any of the test codes, like " df = ek.get_timeseries(["MSFT.O"], start_date="2016-01-01", end_date="2016-01-10") " I ran into error. It would be great it someone could provide some advice. Thanks in advance!! Here's what I…
-
How can I get real-time stock price using EIKON API or Refinitiv-data API ?
I want to get real-time stock price for S&P 500 constituents and S&P 500 Index. I did it 2 ways, there are each problem. And there are delayed data only. Do I need additional subscription charged? Please check there are any problem. 1. spx_cons = ['MMM.N', 'AOS.N', 'ABT.N', ....] data, err = ek.get_data(spx_cons,…
-
how can I get all the instruments/companies that has the field information?
Hi all, I'm using Refinitiv data platform on Jupyter lab, Windows. So I'm trying to get all the companies that disclosed their emissions data, not a certain number of companies. However, the code creator requires me to put "instrument" to generate the code. How do I get all the list of the companies with the certain…
-
monthly data is wrong
on 'Price History' page with this RIC named 'CMZN0' I searched with the interval as 'Daily' and 'Monthly' Base on Daily data below, the average of Oct-2023 has to be '2449.20' but in the other picture, It provides 2432.50 for Oct-2023. how to get precise 'monthly data'?
-
refinitiv.data not able to retrieve RDP access token (Error code 401)
Hello, Recently I received Refinitiv Workspace and am using it instead of the old Eikon application. I am using the eikon and refinitiv.data API via Python. The eikon API works without any issue, however when I try to retrieve data using refinitiv.data I receive the error code 401 with the following message: When opening a…
-
Using the Refinitiv-Eikon applications-- if a variable is available using the Data Item Browser, but
Hello, I am trying to download time-series data regarding company geographic revenues and assets. Using the Data Item Browser, I can see a "Geographic Total Assets" variable. However, when I use the Screener application, this variable is no longer there. Does this mean that I cannot download the variable? Thanks for the…
-
Question about zero issued amount of bond presented in Eikon debt database
Hi, I have a question about Bonds US03785EK863, which has zero issued amount of bond or no face value of bond but has trading data during 2014/7/8 and 2014/10/8. The link is here. I am not sure whether this observation is wrong or not. And I am wondering what has happened to this data. Best
-
[Error 400 - invalid_grant] error description
I am running below rd.get_data( universe=['LSEG.L', 'VOD.L'], fields=['BID', 'ASK'] ) and getting error RDError: Error code -1 | Error code -1 | Insufficient scope for key=/streaming/pricing/v1/, method=GET. Required scopes: {'trapi.streaming.pricing.read'} Available scopes: {'trapi.search.read',…
-
RDPError: Error code 400 | Backend error. 400 Bad Request
While processing requests using Eikon API, I sometimes receive error. Is there any way to resolve this error. I encounter production hours loss due to this, it is not necessary that this errors comes to specific requests (ek.get_data(["0#.SPX"]......) or (ek.get_data(".VIX",'TR.PriceClose')) or any other. RDPError: Error…
-
eikon api daily limit reset time
Hi team, my client is asking about daily reset time of eikon data api download limit quota. Before it was 00:00 hkt, then they found on 28 June, it change to 15:40; on 2 July, it changed to 10:00; on 9 July, it changed to 14:40. All time stamp are HKT. So may I know what exactly is the limit reset time everyday? Thanks in…
-
How to extract data for Bonds ISINs using Python
Im trying to retrieve historical prices for bonds on refinitiv eikon for around 500 bonds, however the code Im trying its not working: "... dataframes = {} for isin in isin_numbers: try: # Fetch the issue date df_issue_date, err = ek.get_data(isin, ['TR.FiIssueDate']) issue_date = df_issue_date['Issue…
-
Retrieving historical constituent data using R
Hi Team, we have a client that is trying to retrieve historical data using R with the following code: get_data('0#.KLSE(2018-01-01)', list('TR.InstrumentName', 'TR.CompanyMarketCap(ShType=OUT)')) but they are not able to retrieve it. Client said they were able to retrieve this previously with the below image similar…
-
How to determine the remaining response daily volume limit for certain workspace?
Hi, Is there a way to determine the remaining volume daily limit for refinitiv data library for Python? I checked the Usage and Limits Guideline and determined the allowable response volume limit of 5GB. I wanted to see how much volume left can we still query from python API calls so as to gauge whether I need to limit the…
-
Error opening session in API.
Dear, on 05/06 at 19:40 GMT-3 we had the error below to connect to the API and since then we have no access to quotes: 2022-05-09 16:45:49.6170|Warn|Refinitiv.DataPlatform.Core.PlatformSessionCore|12|RDP Authentication failed System.ArgumentException: An item with the same key has already been added. at…
-
Filter companies based on a compound keyword in the Business Description: normalization for singular
I am trying to understand how I should account for all possible cases, when I am looking for companies that contain a compound keyword in their Business Description. For the sake of illustrating my point, let us take the following company: Company Common Name: Oxford Lasers Ltd Identifier: 4296593425 Business Description:…
-
Filter companies based on a compound keyword in the Business Description, using the Eikon API
I learnt how do it with simple keywords (single word) following this article: https://developers.refinitiv.com/en/article-catalog/article/find-your-right-companies-with-screener-eikon-data-apis-python. But there is an issue when the keyword is compound (spelled with two different words). I will give an example to…
-
Apparent inconsistency in GPB Libor 6M ZC curve
Good Morning, I am using RDP to retrieve GBP Libor 6M curve, and I have noticed that there is a difference with the data that I get from the Eikon Desktop Application using the RIC for Zero Coupon Curves 0#GBPSBSLZ=R. I would appreciate if you could explain me the reasons for the difference that I am going to show now. In…
-
Apparent inconsistency in GPB Libor 6M ZC curve
Good Morning, I am using RDP to retrieve GBP Libor 6M curve, and I have noticed that there is a difference with the data that I get from the Eikon Desktop Application using the RIC for Zero Coupon Curves 0#GBPSBSLZ=R. I would appreciate if you could explain me the reasons for the difference that I am going to show now. In…
-
RDP: MainThread Error: no proxy address identified. Check if Desktop is running.
Hi! If I try import refinitiv.dataplatform as rdp rdp.open_desktop_session('mykey') then I get 2021-12-15 12:31:40,000 - Session session - Thread 31172 | MainThread Error: no proxy address identified. Check if Desktop is running. But My desktop app is definitely running. Then if I try # this is just a test df =…
-
Dividend adjusted historical prices
From what I researched in this forum, Eikon does not provide dividend adjusted historical prices. But since the posts are very old (more than 2 years old), I would like to know if such a feature was implemented since them. Using unadjusted prices for modelling is unacceptable and even free services such as Yahoo have…
-
How can I find CUSIP or ISIN code in an Eikon Refinitiv database?
I have assembled a database of CVC investments and want to match this data with a Compustat Global database. For this, I would need either the CUSIP or ISIN code of the listed companies. I have found PermID, firm/fund organization ID and Ticker, but these were insufficient. Help would be greatly appreciated!!
-
Is there a way to get Standalone data of a Conglomerate using Eikon API ?
Something like this where I can find just Parent Co.'s numbers and not just consolidated numbers.
-
ASX300 成分股snapshot数据
我们想实现每个工作日上午8:30和10:00两个时间点,通过Eikon获得两次澳洲ASX300成分股的四个实时数据(1.一天的股价变动%,2.股价变化值,3.当前股价,4当前市值)并按市值从大到小排序。 我们想探讨如何通过Eikon自动在这两个时间点完成数据更新工作。 目前来看,ek.get_time_series()可以提取intraday的交易数据的话会很有帮助,或者考虑scheduler。任何建议,也和我们说,感谢!
-
How to get a time series of Implied Volatility for 1 month option for AAPL, FB for last 3 years usin
Hi Team, Good day. How to get a time series of Implied Volatility for 1 month option for AAPL, FB for last 3 years using python code? Thank you.
-
Ho do I get Specific Close price?
Hi Guys I am trying to pull historical Ldn specific close prices from certain Curves in Python. this is my Python code based on how it seems to be required in Excel and my previous question. ek.get_data('DUBSGSWMc2',['TR.TRADEPRICEEUROPE.Timestamp', 'TR.TRADEPRICEEUROPE.Close'],parameters={'SDate': "2021-01-01", 'EDate':…
-
python如何获取一个指标的field='GEN_VAL1'的数据,需要历史数据
ticker是2YSB-USG-A1, field是GEN_VAL1, 需要历史数据, 请问用python怎么写脚本?能否给个范例,谢谢!
-
How to find the name of a list of indexes via the ek.get_data() method?
Hi Team, Hope all is well. Client is willing to find the name of a list of indexes via the ek.get_data() method but does not find the right field (parameter) in the method. For example, if he tries with '.SPXESUN', via ek.get_data('.SPXESUN', 'TR.IndexName'), he could not retrieve the right name, which is 'S&P 500 ESG…
-
Sometimes the Eikon API just randomly returns extra (wrong, duplicated) data
I am trying to get ETP AUM using the Eikon API. Sometimes the exact same request returns extra rows with bad data. Please see below as an example (I am using Python API in python 3.6): The extra row of bad data appears intermittently but frequently. Sometimes, there is a lot of bad data, e.g. (here is an example from the…
-
ek.get_timeseriesで複数銘柄のデータ取得における、取得期間不足の問題
pythonにおいて、下記プログラムで日経225の構成銘柄のデータを期間2017-01-01 ~ 2021-02-18で同時に取得した所、期間2017-01-01 ~ 2021-02-01のデータが取得できませんでした。 この原因はなんでしょうか? また、どのように改善を行えばよろしいでしょうか? app = '' import eikon as ek import numpy as np import pandas as pd from tqdm.auto import tqdm ek.set_app_key(app) target_data_code = ek.get_data(['0#' + '.N225'],fields =…
-
Trying to download an assortment of fields (10Y history) for Honda motors. I am getting duplicate re
df, err = ek.get_data( instruments = 'JP3854600008 ', # instruments = inputs, fields = [ 'TR.CashAndSTInvestments.date', 'TR.EV.value', 'TR.CompanyMarketCap.value', 'TR.CashAndSTInvestments.value', 'TR.TotalDebtOutstanding.value' ], parameters = {'Frq':'FY','SDate':'0','EDate':'-10', 'CURN':'USD'} )
-
Python to download Debt Structure with issuer and subsidaires bonds
Hi team, Below debt structure sample doesn't apply to Sates Own enterprises like 1288.HK. It will show all it's ultimate parents bonds. 1038.HK is another example. So, wonder is it any other sample can show how to get issuer and subsidaries bonds as same as Eikon Debt Structure of bonds. Thanks.…
-
Hi, I am trying to retrieve the close price for BRL= in R using the API. But when I request the seri
Hi, I am trying to retrieve the close price for BRL= in R using the API. But when I request the series, it just returns 3000 values, is there a limitation in the api ?
-
Which fields to use in get_data that correspond to OPEN, HIGH, LOW, CLOSE, VOLUME in get_timeseries?
Is it possible to get the same data from get_timeseries with get_data or does it use a different back end all together?
-
eikon get_data api cpp version
Is there a CPP interface for the eikon get_data and get_timeseries APIs? Thanks.
-
Loading TAS-Data via RHistory in Excel
Hey, I tried to get "Times and Sales"- Data via the RHistory-Funktion in Excel. In Eikon the Data from the last three month is available. But when I select this periode of time, i get only TAS-Data from the last ~ten days. Does anybody know, why the function isn't loading the whole data but only a small part of it? Jacob
-
Eikon not pulling correct CY data
I'm using the following code. Not able to get correct Calendar Year data. Data is the same for CY and FY data df_test_3 = ek.get_data('EMR.N', ['TR.Revenue.fperiod' , 'TR.Revenue.periodenddate' , 'TR.Revenue' , 'TR.NetSales' , 'TR.CostofRevenueTotal' , 'TR.GrossProfitMarginIndustrialAndUtilityPct' ,…