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

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

Best Answer

  • Zhenya Kovalyov
    Answer ✓

    @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")

    image

    Here is the same result in the Python API:

    image

Answers