-
Family Controlled Firms
how can i determ if 800 different firms are family controlled using refinitiv for excel?
-
How to retreive any data using API which is using GRSUM function in excel?
How to retreive any data using API which is using GRSUM function in excel?
-
Where can I find a guide or documentation that lists all ETF data items available in Workspace?
Hi all, I am a student using Refinitiv Workspace through my university, and I’m currently working on a project involving Exchange traded funds domiciled in Europe. I’d like to better understand what’s possible with my account and how to find the right resources. Is there a field guide or documentation that lists all ETF…
-
Request for Macro News Excel File in LSEG Workspace
I am currently using LSEG Workspace and would like to set up an Excel file that automatically updates with macroeconomic news data. Specifically, I’m looking for a file that includes the following columns: Type of release Date of the release Time of the release Actual value Expected value (when available) The data should…
-
S&P 500 Index constituents every month
How can I get S&P500 index constituents every month since 2012-01-01? I am using excel sheet to download the data. I have tried using the function =@RDP .Data(".SPX","TR.IndexConstituentRIC","SDate=2012-01-01 CH=Fd RH=IN",B1) to get the ConstituentRIC, but it returned NULL. May I know why and how to solve this problem?…
-
DFO Request Table - decimal places
I am using the Datastream for Office (DFO) request table to download stock prices of companies, but the output comes only at 2 decimal places, I want to increase these to at least 4 decimal places. How to do it?
-
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.
