I'm trying to do a couple of very simple tasks in Excel: 1. retrieve a RIC based on ISIN and 2. retrieve GICS industry group based on the RIC (I'm not even sure if there is a way to retrieve the industry group from ISIN). Currently, I would first use Build Formula to grab RICs. An example of formula looked like…
I am using Eikon Refinitiv in Excel as add-in. Office 365. VBA. Windows 10. I have a workbook with numerous worksheets, in which there are Refinitiv formulas. There are two types of formulas used: 1) Screeners in the form of formula TR(Screen. 2) data retrieval in form of RHistory. 3) data retrieval in form of TR When…
Application.Run ("PLPauseResumeEventHandler") or other vba codes? fixing some vba codes wanted to pause workbooks auto update for eikon via excel using vba was using Application.Run (PLPauseResumeEventHandler) anyway to split it into pause and resume only? or any other methods to control it? Application.Run…
hi, I have created a formula for the last trade prices, but I can't make the interval show in seconds instead of minutes. Is there any way to do this? =@RHistory($A$2:$A$15,"TRDPRC_1.Timestamp;TRDPRC_1.Close;TRDPRC_1.Open","START:"&$C$3&" END:"&$D$3&" CODE:SEDOL INTERVAL:1M",,"TSREPEAT:NO CH:IN;Fd",D8)
Hi All, I use "Power, Gas, Carbon Research and Forecasts Download Manager" to retrive fundamentals data I see on Eikon desktop graphs or table. Starting from Eikon desktop, I click on right bottom of graph or table and I find the option to "My Downloads" and "Add to Download Manager" so I can find it on Download Manager…
Hello, I am trying to get green bonds data from 2013 to 2023 using Eikon through Advanced search. How can I add a column for whether the issuer is public or private, the ISIN (it gives me the ISIN of the bond only) and the credit rating? I want to keep only the public firms. It gives me only the ticker but I want the ISIN…
Hello dear community, I am trying to find the following variables in Eikon (through its desktop app): Value of bond issue from a company; The years to maturity of these bonds; Information on whether seniority Do you know what are their names in the platform? Thank you so much in advance and happy holidays!
Hi all, I am working with the TXLA NET FLOW data in the sector of ENERGY-GAS-NORTH AMERICA-Regional Balance. I realized the oldest data of this chart as well as the excel provided is from Jan 2021, is there any method to get more historical data? Thanks a lot!
...EUR=? Do you have Code example? Best Regards Josua I'm looking forward for VBA Code to open QuoteWindow (F4) about VBA Code in EIKON Excel.
How do you fix this question that it will log out itself at weekend??
It looks like you're new here. Sign in or register to get started.
