For a deeper look into our Eikon Data API, look into:
Overview | Quickstart | Documentation | Downloads | Tutorials | Articles
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)
Then to get these fields you need to use DEX2 library of Eikon COM APIs. See
https://developers.refinitiv.com/en/api-catalog/eikon/com-apis-for-use-in-custom-applications/tutorials#tutorial-3-fundamental-and-reference-data
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.refinitiv.com/en/api-catalog/eikon/eikon-data-api/tutorials#fundamentals-api-company-tearsheet-estimate
Sorry we are using the .Net client library which doesn't have a function "Get Data" as near as I can tell.
