-
Can someone check and assist our user related to Excel Macro please.
https://us.v-cdn.net/6038239/uploads/4X92DWMG1EVF/eikon-template-2025-281-29.xlsx ISINs were working fine when it was run manually,however, upon using client's Macro it's not working and having some issues.
-
Workspace Add-on | Excel File Freezing
User has an issue with one particular excel file and it's stuck at loading, mouse is also a blue loading circle so they cannot engage with the file, only close via Task Manager. It's a big file with macros, so I've been told it might be VBA related. Troubleshooting steps completed: Cache cleared Temporary files cleared…
-
How to reset a Excel VBA Macro Password
Hi All, We are migrating from Eikon > Workspace and one of our desks use a 20 year old spreadsheet with a VBA Macro locked down with a password, preventing us to modify it for Workspace. If anyone knows how to reset a VBA Macro password, please advise. Many Thanks!
-
Question on Excel Macros
Hello the Live Chat couldn't answer my question and referred me to this Forum. It regards to Excel which, to my amazement, is not included in the "Select a category" menu above. I have a macro that calls 10 RICs, one after the other in a loop, downloads the same basic data for each RIC, copy paste the results in another…
-
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.
-
the sample code for "WorkspaceRefreshAll" on WS Excel
Could youd please provide the sample code for "WorkspaceRefreshAll" on WS Excel to use REFRESH button?
-
Hello, on the M&A database on eikon I would like to put a filter to eliminate every target compan...
...y without an ESG score. Does anyone know how to do that? Hello, on the M&A database on eikon I would like to put a filter to eliminate every target company without an ESG score. Does anyone know how to do that?
-
Macro "Application.Run "EikonRefreshAll", True, 30000" not working
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…
-
Macro data
Hi, I am looking for API-services that can provide me with macro data. I am looking for this specific information; a lot of inflation data - I can send you more specific information if a recive a mail a lot of growth data - I can send you more specific information if a recive a mail All the world indices, most important is…
-
Cell referencing using Redi API
I had looked at an previous answer provided in which the user had to create a function (Eval) as part of the process. I did this but it doesnt consistently return values. I wonder if there might be a better way that is now available as that solution was written a few years back =RediLink|'L1'!'1605.T;BP,DH,DL' so for…
-
How to get the annual issuance amount of corporate bond in a country
How can I retrieve the total issuance amount of corporate bonds in a country for a certain time period but not the details of each single issuance?
-
EIKON QUESTION VBSCRIPT
I have one question about Eikon that I am hoping you could help address. We have Eikon set up on a laptop that we check out to faculty and students. Our IT department recently alerted us that they have been getting security alerts from the laptop related to Eikon’s use of VBScript and macros. Our campus no longer supports…
-
In VBA I have *Application.Run "EikonRefreshWorkbook"* as a code line to refresh my excel workboo...
...k. I was reading on line that that only refreshes TR equations, I was wondering what a refresh code for RHistory functions would be? If Application.Run "EikonRefreshWorkbook" works for RHistory just let me know. Call Sheet4.SpinButton1_SpinDown DoEvents Application.Run "EikonRefreshWorkbook" DoEvents Application.Run…
-
Rdata and ONTIME parameter to record close prices at a specified time using a copy paste macro on...
... German version of Excel The client's using the formula: =RData("FGBLZ9";"LAST";;{"ONTIME:10:45";"MACRO:Snapshot"};;A1)
-
Retreiving data from external file
Hi, I'm using a sheet using TR Eikon Office to receive data from eikon and are trying using a macro in another workbook that copies and pastes this data. The macro opens the data downloader file and copy the data to paste this into the other workbook. The problem I encounter is that the macro is faster than updating the…
