Operating Gains Losses (Historical)
Returns historical operating gains or losses for a company. These are gains or losses from operating activities that are not part of core business operations, such as gains/losses on asset sales or other operating adjustments.
Supported Symbols
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
| International | SYMBOL | SHOP, TSM |
Parameters
| Parameter | Description |
|---|---|
| Symbol | Stock ticker symbol |
| Year | Fiscal year (2020, 2021) or period code (lq, ly, lt) |
| Quarter | Optional: 1, 2, 3, or 4 for quarterly data |
| TTM | Optional: Set to "TTM" for trailing twelve months |
Types of Operating Gains/Losses
| Type | Description |
|---|---|
| Asset Disposals | Gains/losses from selling operating assets |
| Impairments | Write-downs of operating assets |
| Restructuring | Gains from restructuring activities |
| Litigation | Settlements affecting operations |
Notes
- Positive values indicate gains, negative indicate losses
- Often considered non-recurring items
- May be excluded from adjusted earnings metrics
Examples
=hf_Operating_gains_losses("AAPL", 2023)=hf_Operating_gains_losses("MSFT", 2023, 2)=hf_Operating_gains_losses("GE", "ly")=hf_Operating_gains_losses("IBM", 2023, , "TTM")=hf_Operating_gains_losses(A1, B1, C1)When to Use
- Understanding non-recurring operating items
- Adjusting for one-time gains/losses
- Analyzing core operating performance
- Evaluating restructuring impacts
- Quality of earnings analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need operating income | hf_Operating_Income() |
| Need extraordinary items | hf_Extraordinary_gains_losses() |
| Need net income | hf_Net_income_loss() |
| Need EBIT | hf_Earning_Before_Interest_and_Taxes() |
Common Issues & FAQ
Q: Why do some companies have large operating gains? A: Large operating gains often come from selling business units or significant assets. GE, for example, had large gains from selling various divisions.
Q: Should I exclude these from analysis? A: For trend analysis, it's often better to exclude large one-time operating gains/losses to see underlying business performance.
Q: Why am I getting "NA"? A: Many companies have minimal operating gains/losses in most periods. This field may be empty or zero.
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?