Total return template for excel

ray.david
ray.david Newcomer
in Eikon Data APIs

Hi. Do you have an excel template that has total returns such as 1 week, 1 month, 3 month, 1 year, 3 year by equity indices, various commodities etc ? Just want to see what is moving. Thanks

Tagged:

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @ray.david

    Thanks for reaching out to us.

    I checked and found there are total return fields available in Eikon Excel.

    1664949263605.png

    You can use the following formula to retrieve data from those fields.

    =@TR("IBM.N","TR.TotalReturn;TR.TotalReturnYTD;TR.TotalReturn1Wk;TR.TotalReturn52Wk;TR.TotalReturn1Mo;TR.TotalReturn3Mo;TR.TotalReturn6Mo;TR.TotalReturn2YTD","CH=Fd RH=IN",C3)

    1664949323385.png

    You can also use the Formula Builder tool in Eikon Excel to search for other available fields.

    However, to get an Excel template, you need to contact the Eikon or Workspace support team directly via MyRefinitv. The support team can check if the required Excel template is available.

    I hope that this information is of help

Categories