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

vanderkroon
vanderkroon Explorer
in Eikon Data APIs

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

Tagged:

Best Answer

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭
    Answer ✓

    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.thomsonreuters.com/eikon-web-and-scripting-apis/learning?content=14707&type=learning_material_item
    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.

Answers

Categories