We are migrating from Excel Eikon to Excel Workspace. Currently, we are using a C# program to automate the process. However, while we can load the Excel Add-in in Eikon, we are unable to load the add-in after switching to Workspace. Here is a sample of our C# code: using Excel = Microsoft.Office.Interop.Excel;…
Hello Team, An excel sheet crashes upon retrieving data from Workspace add-in. It can be replicated inhouse. We checked with excel experts (GBC team) and they informed that it has macros and so needs to be raised to Developers to check further. Could you please advise? The file has .xlsm extension, so its not even allowing…
I need to download the data of Nasdaq listed companies in eikon terminal? I can't find the Nasdaq index list in the screener panel, and I can't find the Nasdaq exchange in the exchange name section. Can you give me some help? Thank you！
Hi All, How can I get time series data for ETF % ownership of individual stocks. I can find this data on the fund ownership summary data but only for the latest filing date. I also want to collect this data on the SP500 so ideally I would be able to collect this information for all 503 stocks at once rather than doing so…
I am trying to open an excel workbook, connect to the Refinitiv Addin and refresh some formulas using python win32com.client, but unfortunately that is yielding an error as highlighted below. Here's the code I am using: import win32com.client excel = win32com.client.Dispatch("Excel.Application") wb = excel.Workbooks.Add()…
Hi, I'm transition from using the Eikon Excel add-in to Refinitiv WorkSpace excel add-in, but unfortunately the real time retrieval from Reuters stopped working. Function Reuters_IDN(Sec As String, Field As String) Dim res As Variant res = "Retrieving..." While res = "Retrieving..." res = Application.Run("RtGet", "IDN",…
Hi All, I am looking to get the historical levels (close price) for MOILGE index from 2008 till the current date. What should the formula be to get this data. I am currently using Eikon termina - MOILGE page - Prices & Charts - Updating the date range and then copying to excel. Regards, Grishin
I am looking to analyse primary bond data and need the YTD and Credit Ratings at issuance. For some bonds I used the formula builder and "Yield to Maturity" function to extract YTM at issuance for data. For some, however, it returned "NULL" or an empty row. What does "NULL" and empty row imply in this context? Is data…
Hi Team, Please can you help with VBA query from client below. I wonder if you can provide some instructions on how to use VBA to refresh Reuters formulas in excel efficiently? We are quite struggling with the current VBA as the Excel process hang in the middle and crash after I refresh for consecutive times (usually >3…
It looks like you're new here. Sign in or register to get started.
