High Price Earnings Ratio (Historical)
Returns the highest P/E ratio achieved during a historical period, based on the stock's high price divided by EPS.
Notes
- Shows peak valuation during the period
- Useful for understanding valuation range
- Compare with low P/E for full range
- High P/E may indicate optimism or overvaluation
Syntax
=hf_High_Price_Earnings_Ratio(Symbol, Year, [Quarter], [TTM])Examples
=hf_High_Price_Earnings_Ratio("AAPL", 2023)=hf_High_Price_Earnings_Ratio("MSFT", 2023, 2)=hf_High_Price_Earnings_Ratio("GOOGL", "lq")=hf_High_Price_Earnings_Ratio("TSLA", "ly")=hf_High_Price_Earnings_Ratio(A1, B1, C1)When to Use
Valuation range analysis, historical valuation peaks, market sentiment analysis
When NOT to Use
| Need low P/E | hf_Normalized_Low_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:
- Income Acquired In-Process R&D (Historical)
- Income from Cumulative Effect of Accounting Change (Historical)
- Income from Tax Loss Carry Forward (Historical)
- Income Per Employee (Historical)
- Income Restructuring and M&A (Historical)
- Income Tax Expense (Historical)
- Increase Decrease In Inventories (Historical)
- Increase Decrease In Other Current Assets (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?