Normalized Low Price Earnings Ratio (Historical)
Returns the lowest normalized P/E ratio during a historical period, using normalized earnings to remove one-time items.
Notes
- Shows trough valuation during the period
- Normalized earnings provide cleaner comparison
- Useful for understanding valuation floor
- Compare with high P/E for range
Syntax
=hf_Normalized_Low_Price_Earnings_Ratio(Symbol, Year, [Quarter], [TTM])Examples
=hf_Normalized_Low_Price_Earnings_Ratio("AAPL", 2023)=hf_Normalized_Low_Price_Earnings_Ratio("MSFT", 2023, 2)=hf_Normalized_Low_Price_Earnings_Ratio("GOOGL", "lq")=hf_Normalized_Low_Price_Earnings_Ratio("TSLA", "ly")=hf_Normalized_Low_Price_Earnings_Ratio(A1, B1, C1)When to Use
Valuation floor analysis, historical valuation troughs, buying opportunity analysis
When NOT to Use
| Need high P/E | hf_High_Price_Earnings_Ratio() |
| Need current P/E | PERatio() |
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.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
- Normalized Net Profit Margin (Historical)
- Normalized Return On Assets (Historical)
- Normalized Return On Invested Capital (Historical)
- Normalized Return On Stock Equity (Historical)
- Notes Payable (Historical)
- Number Of Days Cost Of Goods Sold In Inventory (Historical)
- Number Of Employees (Historical)
- Number of Part-time Employees (Historical)
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?