-
Difference between 'Date' and 'Calcdate'
Hello everyone, I have a quick question regarding ESG-related data items and the dates they refer to. Let’s say I request ESG data (e.g. CO₂ emissions) for a company on 15 April 2024, and I receive a value in return. I would like to understand whether the reported value actually refers to that calculation date (15 April…
-
How to pull historical price data for multiple companies in Excel using Workspace?
Hi everyone, I'm building a database in Excel with about 100 listed companies and indices. I want to pull historical closing price data for each of them—ideally with the dates in the first column, and each company's closing price in separate columns. I've used the formula builder tool in Excel to get the latest share price…
-
Why does Alt+F11 won't open WS VBA Editor?
With the latest version of WS, Alt + F11 is not opening the VBA editor. Please liaise directly with the client to fix the issue and / or with product team to raise an enhancement request. Also, can you give me the regression tests performed before releasing a new WS version? Client's verbatim: Under WIN11, with Office 2021…
-
Is there an RSS feed or a way to play the news stories outside the workspace app?
Is there an RSS feed or a way to play the news stories outside the workspace app? Can I embed the news stories in my Excel worksheet?
-
What's the Add-in API for workspace to refresh the sheet?
What's the Add-in API for workspace to refresh the sheet?
-
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…
