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()…
Hi everyone, I’m a student working on a research project involving historical bond holdings, and I came across the eMAXX FTP feed, which I understand provides access to such data. However, I’m not sure what this feed is or how to use it. Since I’m using a student account, I don’t have access to live chat support, so I’m…
Hi everyone! I’m a bachelor’s student from Sweden, currently writing my thesis on excess comovement by index events. This is my first time using Eikon, and I have access to the Eikon Excel add-ons. I’m trying to retrieve historical data on the constituents of the OMX Stockholm All-Share Index (.OMXSPI) for my research.…
I am using the following call for refintiv data platform via python : rd.get_history('LGOX4-Z4', ['OPEN_PRC', 'HIGH_1', 'LOW_1', 'SETTLE'], 'weekly') The above returns a "universe not found error". When changed to a non expired spread (i.e LGOF5-G5) it works fine. I already attempted using '0#LGOX4-Z4' and 'DLGOX4-Z4' per…
How can I pause/resume the updates in Excel VBA for the Workspace Add-in? I know that for Eikon the function was "PLPauseResumeEventHandler". What is the equivalent for Workspace?
It looks like you're new here. Sign in or register to get started.
