-
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 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…
-
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.
-
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?
-
Reuters COM API working but Excel RIbbon missing
Hi Community, I have the problem that the add-in is working (RtGet() and RtContribute() work fine for example) only the Thomson Reuters Ribbon is not showing in my Excel 2010. COM Add-In is activated. Maybe as an additional Information: we started opening Excel sheets programmatically by using Powershell recently. Reuters…
-
Hi! I want to download bulk data for banks eg. ROA for all commercial banks in the US between 2010-2
Hi! I want to download bulk data for banks eg. ROA for all commercial banks in the US between 2010-2019. Is there any way using EIKON? Or simply I have to select a bank then to searach on the financials and to download at bank level? Thank you
-
Hi, I have an excel request that references the method ZAV(). What is ZAV()? What does it do? Is
Hi, I have an excel request that references the method ZAV(). What is ZAV()? What does it do? Is there a place I can find documentation on that method? =TR("MSFT.O","ZAV(TR.TotalRevenue(Scale=6))","SDate=0 EDate=-199 Period=FQ0 Frq=FQ",B2) Thanks!
-
Excel stuck on processing when loading from a fresh session new profile and new session always same
Hello chaps we're on Windows 10 0365 2016 32bit, our Eikon addin is APPV but for some reason this on1 user always has issues using Eikon and the add-in for excel, mostly the addin fails to load and excel simply is stuck on processing or the Eikon application takes a while to load and is dreadfully slow? I've monitored his…
-
Can i use cell references in DDE links? example: =REDILink|'L1'!'SPY;Lp'. is there a way to refer
Can i use cell references in DDE links? example: =REDILink|'L1'!'SPY;Lp'. is there a way to reference a cell for the symbol instead of needing SPY hard coded in the formula?
-
Do you know the reason why Excel could crash when it is trying to run Reuters routines?
Hello, I am writing to you because I am experiencing some issues with VBA and some Reuters routines. To summarize the situation: I used a VBA code with the goal to open a specific file to update Reuters prices (TR formulas in different sheets) and after, I copy the data in another file. It was working well during 3 months…
-
Access mutual fund portfolio holdings via Eikon Excel Add_In (Eikon COM)
Hi, Is it possible to retrieve all the holdings using a ticker in Reuters Excel add-in? For example for product IE00BM67HT60, I used ticker TR.FundHoldingName but I could only retrieve top holdings for this ETF, and I also want to know the tickers which can retrieve all the currencies/counties. I used ticker…
-
DDE links =REDILink|'L1'!'SPY;LP' gets the the latest price (LP). Where can I find a list of all ty
DDE links =REDILink|'L1'!'SPY;LP' gets the the latest price (LP). Where can I find a list of all types of data available like high and low and volume?
-
Rdata and ONTIME parameter to record close prices at a specified time using a copy paste macro on Ge
The client's using the formula: =RData("FGBLZ9";"LAST";;{"ONTIME:10:45";"MACRO:Snapshot"};;A1)
-
I remember there was a DDE formula to get positions that included account number and symbol in the f
I remember there was a DDE formula to get positions that included account number and symbol in the formula. Can someone tell me the formatting of that dde formula?
-
how to stop retrieving data every time i open a workbook?
I am working on a workbook which has an enormous amount of formula and it takes time every time I open the file. is there an option I can set the file to refresh manually?
-
How to query mostly read news for a certain ticker via Eikon API?
I'd like to retrieve headline of mostly read news within a certain period for a given RIC. Eikon provides such functionality to filter Most Read for past 24 hours. Is there a way to achieve the same via Python API?
-
Can I get average hist. option prices with the Eikon Database?
Hi all, I have an enquiry concerning historical option data from the Eikon database. I would like to get historical data of option prices. Average European call and put option prices that are at the money (e.g. 0.97-1.03) and close to maturity (for example 10 - 90 days).The data should give a single time series with 1…
-
I have cleared the DDE's from my order entry tool in the VBA code however every time i use the Clear
I have cleared the DDE's from my order entry tool in the VBA code however every time i use the Clear Status button they seem to reappear, maybe theres something in that sub that i need to deactive?
-
Simple issue... trying to get data from REDI to Excel with DDE links. =REDILink|'L1'!'SPY;LP'
Simple issue... trying to get data from REDI to Excel with DDE links. =REDILink|'L1'!'SPY;LP' this gets "last price" LP What do I use to get the 1 min % Change?
-
As there any mechanism where i can request data items at runtime in a same batch file or stream .and
As there any mechanism where i can request data items at runtime in a same batch file or stream .and also remove a particular item at runtime in a batch request or stream while receiving other data item values ?
-
How can I download price history data in 5 minutes intervals for several stocks from EIKON using the
How can I download price history data in 5 minutes intervals for several stocks from EIKON using the formula builder in Excel ? I can somehow only select daily data
-
Excel add in dll
I'm having problem with excel add in. After eikon has been installed, I could see that the add in is loading during Excel start. However, no tab appears. Add in was active in the Excel Options. Disable/enable did not solve the problem. At some point I clicked Remove, and now I cannot find how to add it. FAQ page says to…
-
Hi Team, Could you tell me what is the technology that Eikon and Eikon Excel uses to connect with ea
Hi Team, Could you tell me what is the technology that Eikon and Eikon Excel uses to connect with each other?
-
Eikon DDE server & topic
Does Eikon offer classic DDE connectivity and if it does can you please let me know what the Service and Topic names are? I am asking because I have a legacy VB.NET app that works with DDE & Thomson One and we're planning to replace Thomson One with Eikon and ideally just change DDE info in order for the app to work with…