Total Return for an Index

Hi,

I would think this would be an easy question, but I can't seem to get a total return for S&P 500 (or other example indices, for that matter), but the formula works fine for stocks. Can someone please advise? My call is below:


ek.get_data(['.SP500'],['TR.TotalReturn'],{'SDate':'2017-01-01', 'EDate':'2018-01-01'})

Best Answer

  • chavalit-jintamalit
    Answer ✓

    Hi @jason.miller

    I am not sure by the meaning of TotalReturn on the index.

    You may want to verify this with Refinitiv Helpdesk by asking if there's any fields carrying the information you are interested in by using =TR function in Eikon Excel.
    If there's a way to do this using a formula in Excel, then this formula can be replicated using Eikon Data APIs.
    The Refinitiv Content Helpdesk can be reached using Contact Us capability in your Eikon application.
    Or by calling the Helpdesk number in your country.
    Or at https://my.refinitiv.com/

Answers