Normalized Return On Stock Equity (Historical)
Returns the normalized return on stock equity (ROE) for a company, adjusted for non-recurring items. This metric provides a cleaner view of profitability by excluding one-time gains or losses.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
| ETFs | SYMBOL | SPY, QQQ |
Parameters
| Parameter | Required | Description |
|---|---|---|
| Symbol | Yes | Stock ticker symbol |
| Year | Yes | Fiscal year (2020, 2021, etc.) or period code (lq, ly) |
| Quarter | No | Calendar quarter 1-4 (default: 1) |
| TTM | No | Enter "TTM" for trailing twelve months |
Period Codes
| Code | Meaning |
|---|---|
| lq | Last quarter |
| lq-1 | Two quarters ago |
| ly | Last year |
| ly-1 | Two years ago |
| lt | Last TTM |
| lt-1 | Previous TTM |
Examples
=hf_Normalized_return_on_stock_equity("AAPL", 2023, 4)=hf_Normalized_return_on_stock_equity("MSFT", 2022, , "TTM")=hf_Normalized_return_on_stock_equity("GOOGL", "ly")=hf_Normalized_return_on_stock_equity(A1, B1, C1)When to Use
- Analyzing profitability trends over time
- Comparing normalized equity returns across companies
- Excluding one-time items from profitability analysis
- Building historical profitability models
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need current ROE | Return_On_Equity() |
| Need unadjusted historical ROE | hf_Return_on_stock_equity() |
| Need return on assets | hf_Normalized_return_on_assets() |
| Need return on invested capital | hf_Normalized_return_on_invested_capital() |
Common Issues & FAQ
Q: Why am I getting "NA"? A: Check that:
- The symbol is a valid US stock
- The year and quarter combination exists
- The company reports this metric
Q: What does "normalized" mean? A: Normalized metrics exclude one-time or non-recurring items to provide a cleaner view of ongoing operations.
Q: How is this different from regular ROE? A: Regular ROE includes all items; normalized ROE excludes extraordinary gains/losses.
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?