I have the following question regarding the Refinitiv Eikon Excel add-in:
I have retrieved the announcement dates for various M&A transactions. For those target firms, I want to have certain financial data from the end of the past fiscal year before the announcement date of the M&A. For example, the announcement date of a merger was mid-August 2020. For this company, the Fiscal Year ends at the end of June 2020. Thus, I need the financial data (e.g., net income) from June 31, 2020. How do I enter this in the formula, so that it works automatically for each line? So far, I have only been able to figure out how to retrieve financial ratios from the previous Fiscal Year using the formula builder, starting from the current year, or on a specific date with the help of specific PermIDs of the target firms.
What formula do I have to use in the formula builder in order to get the data of the end of the fiscal year prior to the deal announcement?
Thank you so much for your help!