Hi, I'm extracting a series of data related to GHG emissions and revenue to Excel, but I'm facing issues with selecting the year. Currently the year is set as FY0. How do i access the data from 2023 and 2024?
Hello everyone, I am an absolute beginner with Refinitiv Workspace/Eikon and currently working on my thesis. My research focuses on the impact of ad hoc announcements on stock prices. For this purpose, I would like to retrieve all ad hoc announcements of selected companies (for example DAX members) over the past 5 years.…
We are using a macro-enabled Excel file that retrieves historical financial data (including stock prices, company fundamentals, and returns) via the Refinitiv Eikon Excel add-in. The macro loops through a list of tickers and for each ticker: Writes the ticker into a designated input cell (calculationTicker) on a…
I try to convert the Excel formula =RDP.Data("BCYSYU.S", "ASK", "RTFEED:IDN_SELECTFEED") into a VBA function Application.Run("RDP.Data", "BCYSYU.S", "ASK", "RTFEED:IDN_SELECTFEED"). Unfortunately, it doesn't work. Can you pls assist? But before (Refinitiv Eikon) it was possible to run RtGet via Application.Run So, this…
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.…
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…
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…
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)? https://us.v-cdn.net/6038239/uploads/91FKXDPEK17W/lseg-dist-example.xlsx No idea which category this comes…
The initial Query is; Salesforce Case: 14975215 The following securities have Projected Dividends listed on the front end of the Workspace, however, they are not present in the Refinitiv API when we request them Instruments ADSGnDIVCF.F TURUDIVCF.L BASFnDIVCF.F BAYGnDIVCF.F BRKbDIVCF.U DTGGeDIVCF.F DTEGnDIVCF.F FREGDIVCF.F…
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?
It looks like you're new here. Sign in or register to get started.
