-
Eikon Data API Excel Addon for Linux RHEL environment
Hi all. I plan to use Linux RHEL as an operating system for one of my devices. The web version of Eikon works just fine. However, I do not have MS Office Excel. Hence, I can't use the Refinitiv Excel COM API Addon in LibreOffice Calc to retrieve and update data using formulas, as I usually do. It was very convenient to do…
-
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…
-
Question on how to retrieve data from EIKON Refinitiv add in in Excel
Hello dear community, I am trying to retrieve the following data (time series, from 01.01.2003 to 01.01.2015) from companies using their ISIN code as reference in the Eikon Refinitiv add in in Excel: S&P's, Moody's and/or Fitch's (depending on data availability) credit ratings on the same bonds; value of the bond issue in…
-
Excess Returns for ICE Indices on API
Is it possible to download the Excess Return Historical Series for ICE indices (such as .MERC0A0 for example)? I was able to retrieve total returns (in a specific ccy and in local ccy) using the RIEUR/RILOC fields. Is there an equivalent field to download the excess return as computed by ICE? Thanks,
-
Field Dictionary for RtContribute
Good Day, our company is uploading the price levels of equity and fixed income indices with the RtContribution-Formula in an Excel-workbook like this: =RtContribute($C$4,D11,$F$10:$H$10,F11:H11,$C$5) Currently we are using the field items 6,21,79 for TRDPRC_1HST_CLOSEHSTCLSDATE Could you help me out with a Field Dictionary…
-
Translating Refinitiv Excel Formula to Eikon Python API
I have an excel plugin formula which I want to convert to Python Code and get the same result via eikon Python API. My excel formula is : =@RHistory("DEBMK2;DEBMM2;DEBMN2;DEBQN2;DEBQV2;DEBQF3;DEBYF3;DEBYF4;DEBYF5;DEBYF6;DEBYF7;DEBYF8;DEBYF9;DEBYF0",".Timestamp;.Close","NBROWS:365 INTERVAL:1D",,"TSREPEAT:NO CH:IN;Fd",B27) I…
-
AttributeError: module 'anyio' has no attribute 'Lock'
Hi, I face this error message when running python with eikon api today. The error message is module 'anyio' has no attribute 'Lock'. I have already downgraded the anyio version from 3.4.0 to 3.2.1, but the problem stays. How to solve this problem? Thanks. Python 3.8.8 (default, Apr 13 2021, 15:08:03) [MSC v.1916 64 bit…
-
Dividend with specific ex date
Is it possible to get dividend data for all equities going ex date on specific date? or maybe for some market segments (not specifying all RICs explicitly)? is it possible in Eikon Excel too?
-
Excel VWAP function
Hi, just wondering if you could give an example of the vwap calculation in excel. I just want to calculate for example the vwap of the VIX index for a 10 minute period during the day.
-
Excel Formula delay
We are able to get real time data using formulas, but the values are being fetched only after the completion of the event which triggers it (say a button click).Could you please let me know if the any one of the following is feasible? 1. Calculate the Eikon formula and obtain value immediately after setting the formula to…
-
I can search data from EXCEL ADD-IN, but there is null from EIKON API
We cannot catch some tickers of the data from EIKON API, but we can search same tickers of the data from Excel Add-in. It seems that there exists the data. Why we cannot catch the data from EIKON API? How can I solve the problem? thanks. 透過EIKON API撈取資料時發現有些變數的值會撈不到(不是固定幾家公司無值，而是倒進去的所有公司都沒有那個欄位的資料值)，然而，使用Excel…
-
Streaming Data From Eikon Excel To Python
Hello, I am trying to read price data from Eikon Excel to Python Pandas DataFrame during real time updates. The issue is that Eikon Excel does not save streaming data in real time, while Python can only read saved excel files. I tried to use an Excel macro to automatically save the file during real time updates, but…
-
Data Retrieve Limit with Get_data in Code book (refinitiv.dataplatform.eikon package)
Hello, I want retrieve data from Eikon API for 'TR.CommonName,TR.F.TotRevBizActiv etc fields by importing instruments from the excel file and the instruments will be more than 1lakh OApermids, will code book able to retrieve data for 1 Lakh instruments for various fields? if yes please share sample code to retrieve the…
-
1 user receives You cannot overwrite the array cells in Range
Using Rhistory array formula works on 3 users' machines, but the 4th user receives the following message: " You cannot overwrite the array cells in Range E8". Can anyone offer some help?
