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
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
Q: What year formats are accepted? A: Use numeric years (2023) or period codes: lq (last quarter), ly (last year), lt (last twelve months), lq-1 (quarter before last).
Q: Why am I getting "NA"? A: The company may not report this metric, or data may not be available for the requested period.
Q: What's the difference between quarterly and TTM? A: Quarter shows one quarter's data. TTM (trailing twelve months) sums the last 4 quarters.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today