-
Parent Issuer Bond Rating
we need to monitor credit rating for any new trades timely with Excel/Python API. We would also like to check how to get the credit rating of its immediate parent for a bond position by Excel API. Can you please advice? For example, the issuer of the bond (ISIN: XS3081762828) is ICBC (London Branch) and its immediate…
-
Vba macro code to pause updates or resume updates
Hello Team, Hope everyone is well on your end, apologies for asking but can you assist with one of our client's query please? (CASE#15599046) "In reuters excel, there is a data tool to pause updates or resume updates, may i know if this is something we can use vba macro code to control?" Thank you in advance
-
Hi Team, posting on behalf of client - Macro Code refreshes a selection
Query : Do we have the same code for macro where it refreshes a selection? As per client, the file has a multiple tab. Upon checking, there are the available macro code that we have : - "WorkspaceRefreshAll" - refreshes all workbooks in the current instance of Excel. - "WorkspaceRefreshWorkbook" - refreshes current…
-
How to pull historical financial data from ISIN's
Hi, =@DSGRID ($A$1:$A$1007,RI,P,PO,PB,PA,VO,IBNOSH,04/01/2025,,Daily,RowHeader=true;ColHeader=true;Heading=true;Transpose=true;Code=true;DispSeriesDescription=false;YearlyTSFormat=false;QuarterlyTSFormat=false;MonthlyTSFormat=true;AutoRefresh=false) is what I used to pull the historical data for some stocks in the excel…
-
EXCEL API
Hello team, requesting assistance for a query raised by 1 of our client 'How can I download min-by-min OHLC data for RIC <.IEBRT> using the excel API between two dates? Thank you
-
VBA Query
Hello Team, I am raising this query on behalf of a client. 1.Client would like to know more about below WORKSPACE office add-in update on VBA, such as how to use it? Below is the office add-in update log 26.20.9.0 New option to switch between Asynchronous and Synchronous modes in VBA. — How to use it? 2.Please provide an…
-
How can I extract firm-year panel data for DAX/MDAX/SDAX companies from LSEG Workspace efficiently?
Hi, I am conducting an empirical panel study (fixed effects) on board diversity in German listed firms for 2022–2024. I need firm-year data (e.g. female board representation, ROA, ROE, Tobin’s Q, governance and ownership variables) for DAX, MDAX and SDAX companies, but I cannot retrieve these variables reliably in LSEG…
-
I'm working in codebook using a jupyter notebook.
I'm working in codebook using a jupyter notebook. I have some data in an excel which I want to add to my analysis. I have dropped the excel file into the same folder in codebook as my Jupyter file, however the following code cannot load the file into the Jupyter notebook: Lombards =…
-
Can someone check and assist our user related to Excel Macro please.
https://us.v-cdn.net/6038239/uploads/4X92DWMG1EVF/eikon-template-2025-281-29.xlsx ISINs were working fine when it was run manually,however, upon using client's Macro it's not working and having some issues.
-
hi, need to know the availability of API for reuters for Power BI or Excel
hi, need to know the availability of API for reuters for Power BI or Excel
-
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".…
