For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 0

Total return template for excel

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

excel
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

Upvotes
Accepted
56.1k 145 45 65

@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


1664949263605.png (138.3 KiB)
1664949323385.png (18.3 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.