TR Function : Retrieve date from cell

barbara.guinot
barbara.guinot Newcomer
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

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In
Register

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In
Register

Quick Links

Categories