-
How to Grab Bid & Ask at Certain times using Excel add on
Hi, I've been trying to make a formula to try and grab the Bid and Ask price at certain times using the Excel add on for Refinitiv. I've tried to use the =RHistory formula to do this using preset data to the left of formula as seen in the example below.…
-
Excel, Blocked Content : The ActiveX content
Hi All, We are currently UAT Workspace v1.26.312 in our Citrix env and Excel is presenting "ActiveX content blocked" for sheets with VBA code, the previous WS/Excel version experienced no ActiveX blocks. Has anyone experienced this? Our desktop physical pc's do not have this issue, so possibly linked with our Citrix/MS365…
-
Convert bond RICs/ISIN symbols to Parent RIC (RIC of the Issuer) with Excel?
Using Green Bond Guide in Sustainability, I got a list of Bonds with bond RICs, bond ISIN and Issuers Name. I am trying to download multiple companies' data (ROA%, Total Asset and Total debt percentage to total capital) through Screener. However, the the Porfolio import require Symbols/ Company RICs and PermID beside…
-
Switching from refinitiv eikon datastream excel add-ins post LSEG transition.
My request tables on excel all use the refinitiv eikon datastream add-in to retrieve data series. Since the transition to LSEG Workspace, I cannot process tables and wish to know how to solve this. DO I simply have to change add-ins or will I have rebuild request tables all over again?
-
Income Distribution Data Download
Hi, is it possible to download the data in the attached screenshot directly into Excel using formulae in the Excel API please? (instead of going into Workspace/DIST and then using the "Export to Excel" icon option)? No idea which category this comes under I'm afraid
-
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?
