-
Why is the fperiod not properly aligned with the values?
I'm having problem when downloading financial income data. For this example in the code below, the "Financial Period Absolute" (fperiod) is not properly aligned with the true financial data. We can see that on "TR.F.OperProflnOpCASR | XEBT", there are 2 values on FY2024Q4, but it should be one value for FY2024Q4 and…
-
Excel Integration: How to retrieve full monthly historical data for a CUSIP (similar to Workspace)
I need functionality where I can input a CUSIP into Excel and automatically retrieve the full monthly historical data for that CUSIP. The output should look exactly like the monthly historical view available in Workspace under "Trade Check" (see attached screenshot for reference). Please let me know how I can achieve this…
-
Datastream Excel: Trading Date in DSGRID
Hi, Can you please let me know how to change the date to trading date in Excel? I have searched everywhere now and would really appreciate the direct help. The formula below gives me 262 days.…
-
Quarterly passive ownership data
Hi, For an academic research I would like to retrieve quarterly data (for selected stocks) representing the percentage of shares held passively. Since I have no previous experience with Workspace I could use some help on how to do this. I tried building a formula via the Excel add-in but couldn't find the correct datatype…
-
How do I write VBA code to call Refinitive Excel function and refresh the underlying data
-
API content vs Excel Add-in content
Hi all, is there a difference between the content sets I have available through the API vs the Excel add-on? For example, if I am extracting from the below datasets, should I expect similar results? FX rates; Interest rate curves; Macro indicators (inflation, GDP, policy rates, public debt-to GDP, budget balance, etc.);…
-
Problem connecting to excel PowerlinkCOMAddIn.COMAddIn using python win32com.clieny
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()…
-
LSEG Workspace Excel Addin - C# program load fail
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;…
-
Historical levels from inception till current date for an Index
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
-
[First-time user] Real-time Engine Initialization Error
Hi, I logged onto Refinitiv Eikon - Microsoft Excel for the first time and tried the following code on A1 cell. "=@TR("IBM","CF_CLOSE","RH=IN")" The Refinitiv Eikon is online, as does the Datastream, and I tried several variations of the code from the user guide and I still have a difficulty debugging the error "Real-Time…
-
Is there a way to call on Geographic revenue via a Segment Code or Name?
I am using Excel and while I can call on a company's Geographical data as a whole using…
-
Issue with field PDOR_1 with LSEG Data API
I am attempting to get the previous date of release of an economic indicator EUECBR=ECI. On Workspace Quote page that field id PDOR_1. I am able to get the data for this field with Workspace Excel as well, however in Python API it gives me NA. Can someone assist me with this please? I have attached relevant screenshots…
-
Workspace Excel Plugin : get last pricing dates and values
Good morning all, I hope this message finds you well. I am writing to seek assistance with the LSEG Workspace Excel plugin. Specifically, I need help with retrieving the last pricing date of the year and its value for a security using the Workspace Excel plugin. Despite my efforts, I am unable to achieve the desired…
-
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…
-
Data S&P 500 to excel - beginner
Hello everyone, I'm a complete beginner using refinitive Eikon for my Master's thesis. I need data on the manufacturing companies of S&P 500 from the years 2010 to 2019. How can I dowload lists like this so that I have it in an excel file? Is it possible to download who was CEO for the respective company in those years?…
