-
speed up the data refresh within Excel, or use the LSEG Python API to replicate the data pull
We have an Excel file called the Macro Weekly Calendar which is used weekly by our team at Frais Capital. The file pulls live data directly through Refinitiv Workspace Lite via the Excel add-in. The file contains four types of live data: Economic indicators for Australia, United States and China — including macro data such…
-
Why while running the macro, it seems like something is preventing the RDP.HistoricalPricing formula
I am trying to fetch historical price data via the formula =@RDP.HistoricalPricing() during the execution of a VBA macro. While running the macro it seems like something is preventing the RDP.HistoricalPricing-formula from displaying the data. During the process the macro is supposed to loop through a handfull of RICs to…
-
Can someone check and assist our user related to Excel Macro please.
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…
