Value Score

Returns a composite value score for a stock on a scale of 1-100. Higher scores indicate better value (more undervalued).

Supported Symbol Formats

Type Format Example
US Stocks SYMBOL AAPL, MSFT

Score Interpretation

Score Range Interpretation
80-100 Deep value, potentially very undervalued
60-79 Good value
40-59 Fair value
20-39 Expensive
1-19 Very expensive, potentially overvalued

Factors Considered

The value score typically considers:

  • P/E ratio vs sector/market
  • P/B ratio
  • P/S ratio
  • EV/EBITDA
  • Other valuation metrics

Notes

  • Score is relative to market/sector
  • Higher is better for value investors
  • Combine with quality score for GARP investing

Examples

=RankValue("AAPL")
Apple value score
=RankValue("T")
AT&T value score
=RankValue("BRK.B")
Berkshire Hathaway value score
=RankValue(A1)
Symbol from cell reference
=IF(RankValue("AAPL")>70,"Value","")
Flag high value stocks

When to Use

  • Value investing stock screening
  • Identify undervalued stocks
  • Compare relative valuations
  • Portfolio value assessment

When NOT to Use

Scenario Use Instead
Quality assessment RankQuality()
Technical analysis RankTechnical()
Overall stock rank RankOverall()
Individual valuation ratios PE, PB, PS functions

Common Issues & FAQ

Q: What is a good value score? A: Above 70 indicates good value. 80+ suggests potential deep value. However, very high scores may indicate value traps - check quality score too.

Q: Why do growth stocks have low value scores? A: Growth stocks typically trade at premium valuations (high P/E, P/S), resulting in low value scores. This doesn't mean they're bad investments.

Q: How often does this update? A: The score updates as underlying valuations change - typically daily.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Value Score and Other Financial Formulas
How does MarketXLS work?