Discover Refinitiv
MyRefinitiv Refinitiv Perspectives Careers
Created with Sketch.
All APIs Questions & Answers  Register |  Login
Ask a question
  • Questions
  • Tags
  • Badges
  • Unanswered
Search:
  • Home /
  • Eikon Data APIs /
avatar image
Question by sujit · Aug 22, 2018 at 04:13 AM · excel apitotal return

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

People who like this

0 Show 0
Comment
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

1 Reply

  • Sort: 
avatar image
REFINITIV
Best Answer
Answer by Zhenya Kovalyov · Aug 22, 2018 at 06:42 AM

@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:


screen-shot-2018-08-22-at-113412.png (19.2 KiB)
screen-shot-2018-08-22-at-114014.png (22.3 KiB)
Comment

People who like this

0 Show 4 · Share
10 |1500 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

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

avatar image
sujit · Aug 23, 2018 at 01:16 AM 0
Share

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

singlequery.png (100.5 KiB)
avatar image
REFINITIV
Zhenya Kovalyov ♦♦ sujit · Aug 24, 2018 at 04:30 AM 0
Share

@sujit

You are using an incorrect API. TR.TotalReturn is a fundamental database field, you can access it with an API called DEX - here is the tutorial

avatar image
sujit · Sep 18, 2018 at 07:18 AM 0
Share

@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

avatar image
REFINITIV
Zhenya Kovalyov ♦♦ sujit · Sep 18, 2018 at 08:05 AM 0
Share

are you running the code in Eikon Excel? Do you have a correct declaration of the function?

Public Declare Function CreateReutersObject Lib "PLVbaApis.dll" (ByVal progID As String) As Object

Watch this question

Add to watch list
Add to your watch list to receive emailed updates for this question. Too many emails? Change your settings >
9 People are following this question.

Related Questions

Trying to convert an Excel search line to python

Can EstGuidMeanAtDate return a single number?

Why do some funds have a PCTCHNG & Total Return whilst others have just PCTCHNG and others have neither? When pulling through from the Python Data API

On repeated dates inside a request

How to retrieve Swaption Volatility in Excel API, e.g. http://emea1.apps.cp.thomsonreuters.com/Explorer/GuideDefault.aspx?s=GFI40+AL+3&st=Menu+G+C&context=OV

  • Feedback
  • Copyright
  • Cookie Policy
  • Privacy Statement
  • Terms of Use
  • Careers
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Alpha
  • App Studio
  • Block Chain
  • Bot Platform
  • Calais
  • Connected Risk APIs
  • DSS
  • Data Fusion
  • Data Model Discovery
  • Datastream
  • Eikon COM
  • Eikon Data APIs
  • Elektron
    • EMA
    • ETA
    • WebSocket API
  • Legal One
  • Messenger Bot
  • Messenger Side by Side
  • ONESOURCE
    • Indirect Tax
  • Open PermID
    • Entity Search
  • Org ID
  • PAM
    • PAM - Logging
  • ProView
  • ProView Internal
  • Product Insight
  • Project Tracking
  • Refinitiv Data Platform
    • Refinitiv Data Platform Libraries
  • Rose's Space
  • Screening
    • Qual-ID API
    • Screening Deployed
    • Screening Online
    • World-Check One
    • World-Check One Zero Footprint
  • Side by Side Integration API
  • TR Knowledge Graph
  • TREP APIs
    • CAT
    • DACS Station
    • Open DACS
    • RFA
    • UPA
  • TREP Infrastructure
  • TRIT
  • TRKD
  • TRTH
  • Thomson One Smart
  • Transactions
    • REDI API
  • Velocity Analytics
  • Wealth Management Web Services
  • World-Check Data File
  • Explore
  • Tags
  • Questions
  • Badges