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

barry.chapman

Thanks for the response, that part of the question is answered.

Can you also tell me, what is the difference between TR.TotAssets and TR.F.TotAssets , and in general, what does the .F mean?

Jirapongse

@barry.chapman

I checked and found that it relates to the Fundamentals Source: Refinitiv Company Fundamental (TR.F.), or Refinitiv Financials. You can find this setting in Eikon Excel.

You may contact the Eikon support team directly via MyRefinitiv for more information.