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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
1 0 0 2

Looking for FundRollingPerformance and TotalReturn

My application's user is asking me for FundRollingPerformance and TotalReturn. Both are available via the Excel app but we want to use the Eikon API to pull them into his custom application. Does anyone know where they are?

This is the excel formula:

TR(Sheet1!$B$2:$B$31,"TR.TotalReturn","Frq=D SDate=2000-01-02 EDate=0D CH=IN RH=date SORTA=date",B2)

TR(Sheet1!$B$32:$B$34,"TR.FundRollingPerformance(RollTimeFrame=SI)","CH=IN RH=date",B2)

eikoneikon-data-apipythonworkspacerefinitiv-dataplatform-eikonworkspace-data-apifunds
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.

Upvotes
Accepted
39.3k 76 11 27
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.

Upvotes
39.3k 76 11 27

In Eikon Data APIs you can use the same field names and most of the same parameters as in =TR Excel worksheet function with the exception of parameters that control refresh and formatting of the return, e.g. "CH" and "RH". The equivalent calls to the two functions you mentioned are

ek.get_data(['IWM'],['TR.TotalReturn.date','TR.TotalReturn'],{'Frq':'D','SDate':'2000-01-02','EDate':'0D'})

ek.get_data(['IWM'],['TR.FundRollingPerformance.date','TR.FundRollingPerformance'],{'RollTimeFrame':'SI'})

You might want to check out the following tutorial, which discusses at length modeling data retrieval in Excel and implementing it using Eikon Data APIs.
https://developers.thomsonreuters.com/eikon-data-apis/learning?content=14707&type=learning_material_item

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.

Upvotes
1 0 0 2

Sorry we are using the .Net client library which doesn't have a function "Get Data" as near as I can tell.

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.