Overall Score
Returns a composite overall score for a stock on a scale of 1-100. This score combines value, quality, and technical factors into a single metric.
Supported Symbol Formats
| Type | Format | Example |
|---|---|---|
| US Stocks | SYMBOL | AAPL, MSFT |
Score Interpretation
| Score Range | Interpretation |
|---|---|
| 80-100 | Excellent overall - strong value, quality, and momentum |
| 60-79 | Good overall score |
| 40-59 | Average/mixed signals |
| 20-39 | Below average |
| 1-19 | Poor overall profile |
Components
The overall score typically combines:
- Value Score (RankValue) - valuation metrics
- Quality Score (RankQuality) - fundamental strength
- Technical Score (RankTechnical) - price momentum
Notes
- Single metric for quick screening
- Balanced across multiple factors
- Use component scores for deeper analysis
Examples
=RankOverall("AAPL")=RankOverall("MSFT")=RankOverall("JNJ")=RankOverall(A1)=IF(RankOverall("AAPL")>70,"Strong","")When to Use
- Quick stock screening
- Building balanced portfolios
- Comparing stocks across dimensions
- Comprehensive stock evaluation
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Pure value investing | RankValue() |
| Quality focus | RankQuality() |
| Technical/momentum focus | RankTechnical() |
| Specific fundamental analysis | Individual metrics |
Common Issues & FAQ
Q: What is a good overall score? A: Above 70 indicates strong overall profile. 80+ is excellent. However, look at component scores to understand what's driving the rating.
Q: Why might a stock have high overall but low individual scores? A: A very high score in one dimension can offset lower scores in others. Check RankValue, RankQuality, and RankTechnical individually.
Q: Is overall score enough for investment decisions? A: It's a good starting point, but understand the component scores and do additional research.
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?