-
Question on Excel Macros
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 to eikon desktop app
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…
-
Retrieving different fields and make calculations in a table
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
-
Data S&P 500 to excel - beginner
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?…
-
How can I download ESG data for companies involved in M&A transactions?
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…
-
New functions in Reuters
=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?
-
US Municipal bonds - LSEG products
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,…
-
How to Use eMAXX FTP Feed for Downloading Data?
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…
-
Help Needed: Historical OMXSPI Constituents Using Eikon Excel Add-Ons
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.…
-
What RICS to use when using get_history to get data for expired spreads ie LGOX4-Z4
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…
