-
the sample code for "WorkspaceRefreshAll" on WS Excel
Could youd please provide the sample code for "WorkspaceRefreshAll" on WS Excel to use REFRESH button?
-
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.
-
Hello, on the M&A database on eikon I would like to put a filter to eliminate every target company w
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 workbook.
If Application.Run "EikonRefreshWorkbook" works for RHistory just let me know. Call Sheet4.SpinButton1_SpinDown DoEvents Application.Run "EikonRefreshWorkbook" DoEvents Application.Run "EikonRefreshWorkbook" DoEvents Call CopyPaste DoEvents
-
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)
-
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…