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

Overview |  Quickstart |  Documentation |  Downloads |  Tutorials |  Articles

question

Upvotes
Accepted
38 2 1 4

Quarterly cash flow - need non-cumulative data

When I request quarterly P&L and CF data using this code:

With MyDex2RData
    .InstrumentIDList = "MSFT.O"
    .FieldList = "TR.Revenue;TR.DepreciationDepletion;TR.CapitalExpenditures"
    .RequestParam = "Sdate:20180630 Edate:20190630 Period:FQ1 Frq:FQ scale:6"
    .DisplayParam = "RH:date CH:Fd Transpose:Y"
    .Subscribe False
End With

than the P&L data returns single quarter values but the cash flow data returns cumulative data (see example below):

How can I receive the cash flow data as non-cumulative in the request?

eikoneikon-data-apiworkspaceworkspace-data-apirefinitiv-dataplatform-eikonpythoneikon-com-apidatavba
1586703345595.png (6.0 KiB)
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.

Upvotes
Accepted
38 2 1 4

Thank you for your explanation. Luckily, I was able to figure out how to do it. Here is the code and the result:

With MyDex2RData
    .InstrumentIDList = "MSFT.O"
    .FieldList = "TR.Revenue;TR.DepreciationAndDepletion;TR.CapitalExpendituresCFStmt"
    .RequestParam = "Sdate:20180630 Edate:20190630 Period:FQ1 Frq:FQ scale:6"
    .DisplayParam = "RH:date CH:Fd Transpose:Y"
End With



1588851701392.png (6.5 KiB)
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.

Upvotes
39.2k 75 11 27

@sdittmar

We are gradually transitioning from Reuters fundamentals to Refinitiv fundamentals. Under Reuters fundamentals only cumulative figures are available for most cashflow data items. Non cumulative figures are available under Refinitiv fundamentals, but unfortunately Refinitiv fundamentals field names are not yet exposed through Formula Builder wizard in Excel or through Data Item Browser app in Eikon. You can however see Refinitiv fundamentals field names in Refinitiv Financials views in Eikon application. Type in company name or symbol in Eikon command/search bar and hit Enter to display the company view. Then from the tabstrip at the top of the view select Fundamentals - Refinitiv Co. Fundamentals - Cash Flow. Alternatively in Eikon command/search bar type in the company symbol followed by white space and "CFSTMT", e.g. "MSFT.O CFSTMT" and hit Enter to go straight to Refinitiv Fundamentals Cash Flow view. Then find the line item you're interested in, hover the mouse pointer over the name of the line item and click on the question mark icon that appears against the line item name. This will pop-up a window that provides detailed explanation of the data item and the field name you can use to retrieve it. See the screenshot.


refinitivcfstmt.jpg (509.1 KiB)
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.

Click below to post an Idea Post Idea