Where can I find documentation on using get_data in Python.

barry.chapman

eg I have this excel function:

=@TR({"ANZ.AX","CBA.AX","NAB.AX","WBC.AX"},"TR.TotalReturn52Wk","Frq=Y SDate=0 EDate=-19 CH=IN RH=calcdate;date")

is there documentation that describes how to translate that to Python get_data call.

Also what is the difference between TR.TotAssets and TR.F.TotAssets, where can I find documentation on this?

Thanks,

raksina.samasiri

hi @barry.chapman ,

The related resources are provided below

• Eikon Data APIs for Python - Reference Guide
• Quick Start guide
• an example code of get_data function can be found in the Codebook app inside Eikon Desktop/ Refinitiv Workspace
  • __Examples__/01. Data Retrieval & Discovery/01.04. Eikon Data API/EX_01_04_01__Eikon_Data_API__Get_Data.ipynb

For this case, the Excel formula can be converted to Python code as below

import refinitiv.dataplatform.eikon as ek

ek.set_app_key('DEFAULT_CODE_BOOK_APP_KEY')

df, err = ek.get_data(["ANZ.AX","CBA.AX","NAB.AX","WBC.AX"]
                      , [ "TR.TotalReturn52Wk.calcdate"
                         , "TR.TotalReturn52Wk.date"
                         , "TR.TotalReturn52Wk"]
                      , {'Frq':'Y', 'SDate':'0', 'EDate':'-19'})
df

Here's the output, compared to the output of Eicon Excel. If you'd like to get the same format with Excel output, you may use Python code to format the output dataframe.

The Data Item Browser (DIB) app can be used to see the description of each field, however, For in-depth, individual help with Refinitiv content, as a
customer, please submit your content questions directly to MyRefinitiv