-
Historical RICs on Mutual fund holdings
Hello everyone, I’m attempting to retrieve historical mutual fund holdings using the following code: However, the table appears as follows: As you can see, the code returns only the RICs from the most recent holdings, not those from earlier dates. I have two questions: How can I retrieve historical RICs for my mutual fund…
-
How can I use API to authomatically download funds' holdings informations?
Hi everyone, I am a researcher at the Catholic University of Milan, currently working on a project that involves historical holdings data for U.S. actively managed mutual funds. Specifically, I require the full holdings information (not just the top 3 holdings) for all such mutual funds, on a quarterly basis over the past…
-
Total Return data request in MS Excel
Hello, I'm looking for the Total Return data of delisted companies (e.g., SVB, Varta etc.) and it's my first time using LSEG Workspace. Can anybody help me to find the TRI data of both companies step by step for the period of beginning 2021 until end 2024? Please use the Excel add-in of LSEG Workspace. Where I've to click…
-
Live Mode via VBA
Hello, how can I activate in Workspace Excel "Contribute Now » Live Mode" via VBA ? We're currently experiencing a problem with some users where the Excel workspace jumps to "Manual Mode" when opening it. To avoid this, I'd like to enable "Live Mode" when opening the sheet using VBA.
-
How can I get the BloombergUI.xla Excel Add-in back?
Following the recent Workspace upgrade, one of our workbooks no longer pulls in price data. Looking at the VBA Project References I can see that BloombergUI.xla no longer exists (C:\blp\API\Office Tools\BloombergUI.xla). This has been discussed under FMC Request 28-062025226 and we were advised to reach out here for help…
-
Download Adjusted Close Prices in Excel
Hello, Would it be possible to download Adjusted Close Prices in Excel and not only Close Prices? I remember that in the past there was a specific function but it is not anymore available. Thank you.
-
Excel-VBA Command posting on behalf of a client
Could you please give me an Excel-VBA command to call the Workspace-Excel Menu-command Excel Menu “Workspace” -> Options -> Online -> “Shut Down”
-
VB/PYTHON CONNECTION TO wORKSPACE
Hi, Is there a possibility to connect via VB or python code directly to the Workspace excel API and retrieve information from it?
-
AdfinXAnalytics in Workspace
Hi Team, Is there any way to use AdfinXAnalytics with Workspace Excel? We have a user who has this in his Excel file. I found some references to an LSEG COM API solution, but it doesn't seem to include AdfinXAnalytics, just DEX and Real Time:…
-
historical estimated EPS for multiple periods
Hello everyone I require the historical mean estimate earnings per share from analysts for a company for multiple time periods forward. For example, the forecasts made in 2017 for the following five years 2017-2021, the forecasts made in 2016 for the years 2018-2021 and so on. I've seen that the reifinitiv eikon terminal…
-
Why does the LSEG Workspace “Company Tree Structure” Excel export fail for some companies?
I am using the “Company Tree Structure” feature within LSEG Workspace to export group hierarchy data into Excel. While the download works as expected for many companies, it consistently fails or gets stuck in a loading state for a subset of both public and private companies. This issue persists regardless of the account…
-
Historical Pricing with more than one underlying in excel vba
Hi, We used excel vba code with the old "RHistoryAPI.dll" to query the prices for several stock underlyings. In the new "LSEG COM Library for Workspace" I also looked at the example file for historical pricing from the website "https://developers.lseg.com/en/api-catalog/workspace-sdk/lseg-com-library-for-workspace".…
-
LSEG Workspace Excel Addin - startup load failure from C# app
Hello I try to open Excel workbook with LSEG Workspace COM addin from C# app but it fails to load addin on startup; while if I open same file manually addin loads correctly. please help me to open Excel file with workspace addin active through C#, thanks
-
Excel Add-in
Hello, I am using Mac and want to have the Excel add-in displayed as shown below: (2.png) 2.png However, I only have the following: 1.png How to get access to the first one(2. png)? On windows I know that in the start menu, I can try searching for 'Eikon' then looking for 'Refinitiv Eikon - Microsoft Excel'. However, I…
-
Could you provide me with a documentation for library (oRtList As WorkspaceRtLib.AdxRtList)?
Raised this on client's behalf. Looking forward to your response. Contact Name : Majdeddine Younes Account Name : Landesbank Baden Wuerttemberg Query : I used to use AdfinXRtLib (Eikon) in my VBA and would like to have a similar library while using Workspace. Since I now have the Adfin Analytics tab in my workspace Excel,…
