TR Function : Retrieve date from cell

barbara.guinot
barbara.guinot
in Eikon Data APIs

Hello,

I'm a MA student and using Eikon Excel for my financial thesis on ESG and M&A.

I have all my M&A and financials data, including the date of the annoucement. I would like to retrieve through the TR function the target ESG score one year before the annoucement date. That's on this last point that I experience an issue. I can't call the cell with the date and setting one year before.

I tried this formula but it does not work :


=@TR($E2;";TR.RIC;TR.CommonName;TR.TRESGCScoreGrade.date;TR.TRESGCScoreGrade;TR.TRESGCScore";"Period=FY-1 Sdate:#1 Edate:#1";;$B2 )

B2 being the cell with the announcement date.


Your help would be precious

Thanks a lot

Barbara

Tagged:

Best Answer

  • Alex Putkov.1
    Alex Putkov.1
    Answer ✓

    @barbara.guinot

    Would you mind elaborating on what exactly doesn't work? The formula you're using looks OK to me, but I don't know what result you're expecting. From your description I'm guessing you may want to change Period=FY-1 to Period=FY0. The EDate parameter is not necessary for your purposes, but there's no harm in including it. Replacing TR.TRESGCScoreGrade.date with TR.TRESGCScoreGrade.fperiod may be more illustrative to interpret the results. When I use

    =TR("AAPL.O","TR.RIC;TR.CommonName;TR.TRESGCScore.fperiod;TR.TRESGCScoreGrade;TR.TRESGCScore","Period=FY0 SDate:#1",,B2)

    and set the value in B2 to say 1-Jun-2015, I get ESG score for FY2014. Is this not what you're expecting or what you're looking to get?

Answers

Categories