ROCE calculation for last 4 quarters
Return on invested capital is defined as ebit/(total current assets - total liabilities).
TR.ROCEActValue(Period=FY0) yields for apple
However the end date of this period is now almost one year ago. Apple's 3rd quarter results were presented on July 30th 2020. Meaning that this number is out of sync for 3 quarters now. If I change the period to other Periods like e.g. (LTM, FI0, FQ0) I get NA for all fields (Date, Period End Date, Return on Capital Employed). I would like to calculate the ROCE over the last four quarters. This should in my eyes be equal to the sum(EBIT(q-4);EBIT(q-3);EBIT(q-2);EBIT(q-1))/(total Assets(q-1) - Current Liabilities(q-1)).
With q-0 being defined as the current (not yet reported) quarter
Is there a way to achieve this using TR.ROCEActValue?
Best Answer
-
Hello @laurens,
In my best understanding of the question, it is not on Eikon Data APIs usage, you are looking to investigate a suspected discrepancy in content that is available from Eikon?
If this is the case, for a customer, the best approach to get this type of question answered by a Refinitiv content expert is to contact Refinitiv Content Helpdesk Online and raise a content query or to dial your local Refinitiv Helpdesk number.
The majority of the members of this forum are developers, the moderators are API experts, so do not posses the deep expertise in various areas of content that is made available by Refinitiv.
Hope this helps and please let us know if you are unable to proceed.
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 中文论坛