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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
vanderkroon avatar image
40 ●5 ●5 ●11

retrieving broken down by quarter - from the TR Eikon API Proxy

When you open up Eikon, type in <AAPL> (Apple Inc), select <Financials>, in <Financials> select <Cash Flow>, then for <period> select <TTM> (=trailing twelve months). Then you get an overview of the <Cash from Operating Activities> broken down by quarter. In this case (AAPL) you get 64,068 - 66,339 - 65,417 - 65,824 - 63,173, for Jul-2017 thru Jun-2016.

Now my QUESTION: How can I retrieve this from the TR Eikon API Proxy? (If I use TR.CashFromOperatingAct(Period=FY0) then I get an error (AttributeError: 'BlockManager' object has no attribute ’T), meanwhile I am not convinced that this is the proper indicator.)

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpython
icon clock
10 |1500

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

1 Answer

Upvotes
Accepted
Alex Putkov.1 avatar image
39.2k ●75 ●11 ●27

Here's the call:
ek.get_data('AAPL.O',['TR.CashFromOperatingAct.date','TR.CashFromOperatingAct'],{'SDate':0, 'EDate':-4, 'Period':'LTM', 'FRQ':'FI'})
I would strongly recommend modeling your data retrieval in Excel where you can take advantage of GUI based helpers to discover metadata and figure out parameters you need to use. This tutorial talks about metadata discovery at length.
https://developers.refinitiv.com/en/api-catalog/eikon/eikon-data-api/tutorials#fundamentals-api-company-tearsheet-estimate
And if you cannot figure out the parameters you need to use in Excel, you can always call Thomson Reuters Helpdesk and Helpdesk representative will be happy to guide you.
Once you figured out how to retrieve data into Excel, translating it into Eikon Python syntax is quite trivial.

icon clock
10 |1500

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

Joris.Hoendervangers avatar image Joris.Hoendervangers

Thanks Alex. FYI: this client is running MacOS so he using the Eikon API with the Eikon Web version.

Click below to post an Idea Post Idea