Hi there, I was wondering what the formula would be in the Excel function of Refinitiv Eikon to extract all the ESG ratings (also separate for each component) for the U.S. listed companies over the maximum period for each year including CIUSP codes. Is there anyone able to be helping me with the formula? Thanks in advance!
Hello, I am trying to get the M&A deals based on few criteria among which one important one is the acquiror nation. I cannot find that criteria in the deal screener from where I normally create the formula. Setting TR.MnAAcquirorNation for the desired country in the TR function in excel directly does not work either. This…
...n months in the formula builder? Hi there, For a thesis I am currently looking for the right formula to determine ESG data (all three components and total component) by using time series over the past decades (determined in months) What would the right formula for this? I did try:…
Hi - have dig through the web but did not find an satisfactory answer. I have a macro-enabled eikon template which calls a few of other procedures I do have in modules. I need to make sure EIKON is connected in EXCEL before calling these procedures otherwise the tool gets stucked and freezes. Is there a simple way to check…
Hello. I am a new user of Eikon, and I have found several times two different forecast: EC and GFS. I don´t know the meaning of the letters nor the difference between both concepts. Could any of you please help me on this? Thanks a lot.
I need to create a multi asset class portfolio so that I can compare Bitcoin to the portfolio. I need to know whether adding bitcoin to a multi asset class portfolio will being any diversification benefits. How do i create a portfolio like this?
... research documents? I am using EIKON Research & Advisory, which provides company research documents. However, most of research documents are with 'request' in its document title. When click on it, a pop-up window asks the following information. - job role, - broker contact information So, I wonder 1. is it free to…
Hi! I want to find the list of all trading dates between 2 given dates, say between 1 and 18 Feb 2021, should return me ['2021-02-01', '2021-02-02', '2021-02-03', '2021-02-04', '2021-02-05', '2021-02-08', '2021-02-09', '2021-02-10', '2021-02-11', '2021-02-12', '2021-02-15', '2021-02-16', '2021-02-17', '2021-02-18']
Hi, when I use the following command =@TR("BBY","TR.ISStatementLastUpdatedDate","CH=Fd RH=IN",B2) It returns 9/1/2020. However, if I go to Eikon and look at the income statement there is clearly shows income statement data for 10/31/2020. Shouldn't the date returned by the formula above be several weeks after 10/31/2020?…
Hello, I am trying to use DfAddPeriod in VBA : Public Function CreateAdxDateModule() As AdfinXAnalyticsFunctions.AdxDateModule Set CreateAdxDateModule = CreateReutersObject("AdfinXAnalyticsFunctions.AdxDateModule") End Function CreateAdxDateModule.DfAddPeriod("FRA", "12/02/2021", "1M", "EMC:S") But this does return a Type…
It looks like you're new here. Sign in or register to get started.