For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
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'})
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/
Right, I meant the total return over a period for an index. I've tried using the above formula for individual equities and it works fine, but it doesn't work when I use an index instead of an individual stock ticker. Can you help me figure out why that is? Thanks.
