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
Syntax
=hf_Operating_gains_losses(Symbol, Year, [Quarter], [TTM])Parameters
Stock ticker symbol
Fiscal year or period code (lq, ly, etc.)
Calendar quarter (1-4)
Set to 'TTM' for trailing twelve months
Returns
Operating gains or losses
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
Why do some companies have large operating gains?
Large operating gains often come from selling business units or significant assets. GE, for example, had large gains from selling various divisions.
Should I exclude these from analysis?
For trend analysis, it's often better to exclude large one-time operating gains/losses to see underlying business performance.
Why am I getting "NA"?
Many companies have minimal operating gains/losses in most periods. This field may be empty or zero.
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