-
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!
-
New functions in Reuters
=RHistory(WIPLN3MD=;"ASK.Timestamp;ASK.Close";"START:"&2021-09-30-2&" END:"&2024-09-30&" ADJUSTED:YES INTERVAL:1D";;"SORT:ASC NULL:PREVIOUS TSREPEAT:NO DAY:A CH:Fd";GM3) Hi, Due to an update, my old functions are not working - any idea how to improve the code above?
-
$$ER: E100,INVALID CODE OR EXPRESSION ENTERED for a Credit Default Swap
Hello, I am having trouble getting the Total Return Index from selected Credit Default Swaps. The Error-Code: $$ER: E100,INVALID CODE OR EXPRESSION ENTERED keeps showing up, regardless of which CDS I choose in Datastream. I am able to get the Total Return Index for Stocks and Bonds, CDS are the only type that do not work:…
-
Access error while accessing refinitive Eikon through VBA
Hi, I am having a problem while trying to access to some data through excel. In the Excel file I am getting the error in the line of code: This script has been working for long time until today. The error that I get in excel is this one: While pasting the gateway URL into internet and put my credentials, I get this message…
-
Excel-Add In "NULL"
Hi, I need financial data of several years for many companies. This has worked for all years via the Excel Add-In except for 2022. Apart from the first row, "NULL" appears for all observations although the formula has been applied correctly and the data should also be available according to the balance sheet. Does anyone…
-
Not sure why certain values are not getting returned in Excel. Is there a capacity limit?
=RediLink|'L1'!'8411.T;ADV5' This is returning zero. Does this mean an underlying table has not updated or something?
-
Powerlink Addin Error - Eikon COM addin
Hello, I am receiving the below error: Excel is running with some issues on the powerlink addin, do you want to disable it What should I do to resolve the issue? So far, restarting the pc is the only solution
-
Dex2 Initialization Failed.
Hello, I'm currently pulling historic data into an excel document, but every time I attempt to refresh, I receive the error "Dex2 Initialization Failed." This error has not appeared before, and I have made no changes since the last time it succeeded. I am signed into the Refinitiv Eikon desktop app as well as the Excel…
-
Eikon Excel add-in - Refresh All Workbooks - not working
Hi, I am using Eikon Excel add-in, and have a strange behavior when Refreshing Data. I use Option RIC and want to get the underlying RIC and the underlying Last Price. In order to do that, I must first Click on “Refresh – All Workbooks”, but this just pulls the underlying RIC, but not the Underlying Last price. In order to…
-
Error when downloading data through excel add-in
Hi, I am downloading a bunch of data in excel from the Refiniv 365 add in. However, I am getting a lot of error messages for different companies and for different financial variables. Thus, I immediately thought that it was because there were no data available for that company and those variables, but when I go into the…
-
Server response is not valid (Excel API)
Hi, Response calling API in Excel: "Server response is not valid" rebooted computer several times, etc. refreshed workbook, called API several time and still get same error. Any help will be highly appreciated Thanks Charles
