Cash From Disc. Investing Activities (Historical)
Returns cash flows specifically from discontinued investing activities. This relates to capital expenditures or asset sales from business segments being discontinued.
Notes
- Part of discontinued operations reporting
- May be zero or NA without discontinued operations
- Separates ongoing from discontinued investing activities
- Useful when analyzing company restructuring
Syntax
=hf_Cash_from_Disc_Investing_Activities(Symbol, Year, [Quarter], [TTM])Parameters
Stock ticker symbol
Fiscal year
Quarter (1-4)
Use TTM for trailing twelve months
Examples
=hf_Cash_from_Disc_Investing_Activities("AAPL", 2023)=hf_Cash_from_Disc_Investing_Activities("MSFT", 2023, 2)=hf_Cash_from_Disc_Investing_Activities("GOOGL", "lq")=hf_Cash_from_Disc_Investing_Activities("TSLA", "ly")=hf_Cash_from_Disc_Investing_Activities(A1, B1, C1)When to Use
Discontinued operations analysis, restructuring analysis, investing cash flow breakdowns
When NOT to Use
| Need total investing cash flow | hf_Net_Cash_Investing() |
| Need financing discontinued | hf_Cash_from_Disc_Financing_Activities() |
Common Issues & FAQ
What year formats are accepted?
Use numeric years (2023) or period codes: lq (last quarter), ly (last year), lt (last twelve months), lq-1 (quarter before last).
Why am I getting "NA"?
The company may not report this metric, or data may not be available for the requested period.
What's the difference between quarterly and TTM?
Quarter shows one quarter's data. TTM (trailing twelve months) sums the last 4 quarters.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today