Upgrade from Eikon -> Workspace. Learn about programming differences.

For a deeper look into our Eikon Data API, look into:

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
barry.chapman avatar image
36 ●1 ●2 ●3

Where can I find documentation on using get_data in Python.

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,

syntax
icon clock
10 |1500

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

Jirapongse avatar image   Jirapongse

@barry.chapman

Hi,

Thank you for your participation in the forum.

Are any of the replies below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

wasin.w avatar image   wasin.w

Please be informed that a reply has been verified as correct in answering the question, and has been marked as such.

Thanks,


AHS

3 Answers

· Write an Answer
Upvotes
Accepted
raksina.samasiri avatar image
14.2k ●30 ●5 ●10

hi @barry.chapman ,

The related resources are provided below

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.

1655865031020.png

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 MyRefinitiv1655865702678.png



1655865031020.png (141.4 KiB)
1655865702678.png (7.4 KiB)
icon clock
10 |1500

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

Upvotes
barry.chapman avatar image
36 ●1 ●2 ●3

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?

icon clock
10 |1500

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

Upvote
Jirapongse avatar image
78.8k ●250 ●52 ●74

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

1655890322945.png

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




1655890322945.png (65.2 KiB)
1655890227270.png (70.7 KiB)
icon clock
10 |1500

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

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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