Special Income-Charges (Historical)
Returns special income items or charges that are non-recurring or unusual. These one-time items are often excluded when calculating normalized earnings.
Examples
| Type | Examples |
|---|---|
| Special Income | Asset sale gains, legal settlements received |
| Special Charges | Restructuring costs, impairments, legal settlements paid |
Notes
- Positive = income (gains)
- Negative = charges (losses)
- Excluded from normalized/adjusted earnings
- Important for understanding true ongoing profitability
Syntax
=hf_Special_Income_Charges(Symbol, Year, [Quarter], [TTM])Examples
=hf_Special_Income_Charges("AAPL", 2023)=hf_Special_Income_Charges("MSFT", 2023, 2)=hf_Special_Income_Charges("GOOGL", "lq")=hf_Special_Income_Charges("TSLA", "ly")=hf_Special_Income_Charges(A1, B1, C1)When to Use
Earnings quality analysis, normalized earnings calculation, identifying one-time items
When NOT to Use
| Need normalized income | hf_Normalized_income() |
| Need core operating income | hf_Operating_Income() |
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.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?