I am looking to analyse primary bond data and need the YTD and Credit Ratings at issuance. For some bonds I used the formula builder and "Yield to Maturity" function to extract YTM at issuance for data. For some, however, it returned "NULL" or an empty row. What does "NULL" and empty row imply in this context? Is data…
Hi Team, Please can you help with VBA query from client below. I wonder if you can provide some instructions on how to use VBA to refresh Reuters formulas in excel efficiently? We are quite struggling with the current VBA as the Excel process hang in the middle and crash after I refresh for consecutive times (usually >3…
Hello the Live Chat couldn't answer my question and referred me to this Forum. It regards to Excel which, to my amazement, is not included in the "Select a category" menu above. I have a macro that calls 10 RICs, one after the other in a loop, downloads the same basic data for each RIC, copy paste the results in another…
I cannot log in using eikon desktop app. when i try to log in, appears message: REFINITIV EIKON Desktop 4.0.65 (build 4.0.65202) Error description: Configuration Download Error The application failed to download the product configuration. Possible causes: • you are not connected to the network • the Refinitiv Platform is…
Hello, I would need to get a table with the different ISIN and fields, and finally the average of each field. before that, I would like to set some rules to exclude the outliers. output example: EV/EBITDA P/B P/Sales AAPL 7 …. … MSFT 3 … … Average 5 … … could you please help me with the code below: thanks
Hello everyone, I'm a complete beginner using refinitive Eikon for my Master's thesis. I need data on the manufacturing companies of S&P 500 from the years 2010 to 2019. How can I dowload lists like this so that I have it in an excel file? Is it possible to download who was CEO for the respective company in those years?…
I am encountering some difficulties while using Refinitiv for my research on the impact of ESG characteristics of target companies on M&A premiums. When using the Screener app in the Refinitiv Eikon Workspace, I can successfully select a sample of M&A transactions. However, I am unable to include ESG data when choosing the…
=RHistory(WIPLN3MD=;"ASK.Timestamp;ASK.Close";"START:"&2021-09-30-2&" END:"&2024-09-30&" ADJUSTED:YES INTERVAL:1D";;"SORT:ASC NULL:PREVIOUS TSREPEAT:NO DAY:A CH:Fd";GM3) Hi, Due to an update, my old functions are not working - any idea how to improve the code above?
Can you please advise the products LSEG offers used in the US Municipal world, i need tools to be able to price municipal bonds current and historical prices using benchmarks, trade and quote prices, and comparables data. Right now I have an Eikon kiosk, which has the municipal bonds calculator and comparables data access,…
I am trying to open an excel workbook, connect to the Refinitiv Addin and refresh some formulas using python win32com.client, but unfortunately that is yielding an error as highlighted below. Here's the code I am using: import win32com.client excel = win32com.client.Dispatch("Excel.Application") wb = excel.Workbooks.Add()…
It looks like you're new here. Sign in or register to get started.