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…
The OHLC data is missing for the LCOc1-LCOc3 jumbo spread. Although the volume values seem to be accurate but the OHLC data is not there. The data for December 2017 and July 2018 is missing. Please find the attached screenshot for reference. If this is not the right forum for posting this then please let me know where to…
It looks like you're new here. Sign in or register to get started.
