-
Workspace Add-on | Excel File Freezing
User has an issue with one particular excel file and it's stuck at loading, mouse is also a blue loading circle so they cannot engage with the file, only close via Task Manager. It's a big file with macros, so I've been told it might be VBA related. Troubleshooting steps completed: Cache cleared Temporary files cleared…
-
I am looking to get institutional ownership % of a list of 1500 equities for which I have RIC codes.
Am I able to get this data quarterly from 2009-2025? and am I able to do it through the excel extension?
-
Historical data on inactive bonds?
Dear developer community, For my upcoming thesis I will require historical data on active as well as inactive bonds, including prices, spreads and ratings. However, it seems as though it simply returns NULLs for all inactive bonds. Therefore my question is whether retrieving such data is possible or not, and if so, how? My…
-
ESG ratings by deal announcement day and company
How can I get ESG scores for target companies? I am using excel.
-
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".…
-
Stock Div Data using LSEG COM library for Workspace in Excel VBA
Using the LSEG COM library for Workspace in Excel VBA what is the best way to return company dividend information? TR.DivExDate etc.
-
Mapping Bond ISIN to Issuer PermID
Hello! I would love to get some insight into a complete python method of mapping a bond ISIN to the issuer's PermID. According to helpdesk, there isn't a way, so I'll share how I've managed so far. Step 1: With my list of ISINs, I use the formula @RDP…
-
How do I include delisted firms in the screener?
I'm screening for stocks within specific industries that IPO'd on or before Dec 2005. However, I also need firms included that have IPO'd but have since been delisted. I can't seem to make that work? I'm ticking inactive as a status but it doesn't give me firms that I know for sure have been delisted since their IPO on or…
-
How do i select the year of the data?
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?
-
History of Ultimate Parent Given RIC or Perm ID
Hello, Hope everyone is doing well! I asked LSEG helpdesk about something and was redirected here. I have a list of RICs and Permanent IDs. Say I would like to get a 5 year history of multiple fields for these companies, including the history of the ultimate parent of those companies. Is there a way via Python's…
-
Can you confirm whether the Eikon Excel formulas (=TR(...), =RHistory(...)) fully support dynamic re
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 am interested in setting up a data feed into excel via your API - can you help me set it up for CN
i am interested in setting up a data feed into excel via your API - can you help me set it up for CNHSRSWATM=TRHK please?
-
I try to convert the Excel formula to VBA function
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…
-
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…
