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?
Best Answer
-
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 With0
Answers
-
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.
0 -
Thanks again for the explanation. This coding problem took me a minute, and your post helped me to break through. I am quite new to this, but I am trying to learn it because my company needs me to. We want to offer more finance-related services to attract more customers.
And one of the directions the management of the company wants us to cover is DCF finance. We’ve never done that before and need to take some time to learn. Thankfully, some online resources and forums are ready to help with that. Learning and re-learning are the future, so I don’t complain.0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛