which field to use for Total Return nos. in excel API. TR.TotalReturn is not working

sujit

Find more posts tagged with

python

eikon

workspace

eikon-com-api

eikon-data-api

refinitiv-dataplatform-eikon

workspace-data-api

Accepted answers

Zhenya Kovalyov

@sujit, a few questions.

Which API are you using? If it is .NET, the Data API does not have access to the fundamental database, only real-time and time series.

Which asset are you looking to get Total Return for? TR.TotalReturn refers to equities.

Here is an example in Excel:

=TR("AAPL.O","TR.TotalReturn","SDate=0D EDate=-1AY")

Here is the same result in the Python API:

All comments

Zhenya Kovalyov

@sujit, a few questions.

Which API are you using? If it is .NET, the Data API does not have access to the fundamental database, only real-time and time series.

Which asset are you looking to get Total Return for? TR.TotalReturn refers to equities.

Here is an example in Excel:

=TR("AAPL.O","TR.TotalReturn","SDate=0D EDate=-1AY")

Here is the same result in the Python API:

sujit

I downloaded single query sample excel book from https://docs-developers.thomsonreuters.com/1535000730857/12020/ that has field list mentioned as TRDPRC_1.HIGH etc. When I replace those fields with TR.TotalReturn, it returns invalid field. But TRDPRC_1.HIGH etc returns valid nos. singlequery.png

sujit

@Zhenya Kovalyov Thanks for pointing this out. However, when I try to initialize Dex2 seession, it throws up an error: 53:File not found: PLVbaApis.dll

When I try to add this dll to References-VBA project, it says: Cant add a reference to the specified file

Regard

Sujit

EXPLORE OUR SITES