stock-evaluator-v3

Comprehensive evaluation of potential stock investments combining valuation analysis, fundamental research, technical assessment, and clear buy/hold/sell recommendations. Use when the user asks about buying a stock, evaluating investment opportunities, analyzing watchlist candidates, or requests sto

By sundial-org · 378 installs

npx skills add sundial-org/awesome-openclaw-skills --skill stock-evaluator-v3

Source repository · Upstream listing

Stock Evaluator (Enhanced) ⚠️ CRITICAL: MANDATORY DELIVERABLES CHECKLIST Every analysis MUST include ALL of these: ☐ Technical Analysis (price action, indicators, key levels, Ichimoku Cloud) ☐ Fundamental Analysis (business, financials, competitive position) ☐ Advanced Financial Metrics (F Score, Z Score, M Score, Max Drawdown, Value Trap Score) ☐ Investor Persona Scores (8 legendary investor frameworks) ☐ Valuation Assessment (multiple methods with margin of safety) ☐ Bull vs. Bear Case (both sides with balance assessment) ☐ Clear Recommendation (BUY / HOLD / SELL with conviction rating) ☐ Alternative Candidates (if SELL: provide 3 5 better alternatives) ☐ Enhanced Quant Style Dashboard (React dashboard with 60+ metrics, Ichimoku, investor personas, TOP NEWS, and key notes) If you cannot complete any item, STOP and ask for clarification. ⚠️ CRITICAL: DATA INTEGRITY RULES ZERO FABRICATION POLICY NEVER fabricate, estimate, or hallucinate ANY numeric data point. Every metric in the dashboard MUST come from: 1. A web search result with a cited source 2. Company filings (10 K, 10 Q, earnings reports) 3. Official financial data providers If data cannot be found → Use "N/A" or " " MANDATORY WEB SEARCHES (minimum per analysis) You MUST perform these searches before populating the dashboard: Search Query Template Data Retrieved 1 "[TICKER] stock price market cap P/E ratio" Price, Market Cap, P/E 2 "[TICKER] ROE ROA profit margin 2024 annual report" Financial ratios 3 "[TICKER] revenue growth earnings growth FY2024" Growth rates (REPORTED) 4 "[TICKER] Piotroski F Score" F Score (or calculate) 5 "[TICKER] insider trading SEC Form 4 2025" Insider buys/sells 6 "[TICKER] short interest percentage float" Short interest 7 "[TICKER] RSI MACD 50 day 200 day moving average beta volatility" Technical indicators 8 "[TICKER] analyst price target consensus" Analyst targets DATA SOURCE HIERARCHY Use sources in this priority order: 1. Official company filings (SEC EDGAR, company investor relations) 2. Exchange data (NYSE, NASDAQ, LSE official) 3. Verified financial data (Yahoo Finance, Google Finance, MarketWatch) 4. SEC Form 4 (for insider trading ONLY) 5. FINRA/exchange (for short interest ONLY) PROHIBITED Using training knowledge for ANY specific current numbers Analyst reports (per user preference) Estimates without sourcing "Common knowledge" assumptions HANDLING UNAVAILABLE DATA Situation Action Display Metric not found after searching Display "N/A" value: "N/A" Data is outdated ( 1 year old) Note the date value: "15.2% (2023)" Conflicting sources Use most authoritative Note in analysis Calculated metric (F Score) Show calculation Explain in text Insider data unavailable Show "N/A" insBuys: "N/A" CRITICAL: Zero means "zero occurred" NEVER substitute zeros for missing data. STANDARDIZED METRIC LABELS Use these EXACT labels in the dashboard (matches reference screenshots): Row 1: PRICE & VALUATION FINANCIAL PERFORMANCE Label Notes Price: $XX.XX or €XX.XX Market Cap: $XXB or €XXB Trailing P/E: XX.XX Forward P/E: XX.XX Subsector P/E: XX.XX or N/A PEG (1Y): X.XX with benchmark (<1) ROE: XX.XX% with benchmark ( 20%) ROA: XX.XX% with benchmark ( 10%) Profit Margin: XX.XX% with benchmark ( 20%) Operative Margin: XX.XX% with benchmark ( 20%) NOTE: "Operative" not "Operating" Gross Margin: XX.XX% with benchmark ( 40%) ROIC: XX.X% with benchmark ( 15%) Row 2: GROWTH METRICS RISK INDICATORS Label Notes Revenue (YoY): XX.XX% with benchmark ( 10%) REPORTED only Earning (YoY): XX.XX% with benchmark ( 0%) REPORTED only EPS (TTM): $X.XX Forward EPS: $X.XX Growth Rates: Capped: X.X% / Uncapped: X.X% Analyst Target: $XX.XX CRS (0 1): X.XX with benchmark (Medium) Debt/Equity (mrq): X.XX with benchmark (0.5 1) Piotroski F: X with benchmark (≥7) Altman Z: X.XX with benchmark ( 3) Beneish M: X.XX with benchmark (< 1.78) Value Trap: XX (Label) Row 3: LIQUIDITY & FREE CASH FLOW INSIDER & SENTIMENT & CLASS Label Notes Current Ratio: X.XX with benchmark (1 2) Cash: $X.XB Debt: $X.XB or N/A FCF Growth 5Y: XX.X% with benchmark ( 5%) FCF Yield: X.XX% with benchmark ( 4%) FCF Margin: XX.XX% with benchmark ( 15%) Payout Ratio: XX.XX% with benchmark (<50%) Buys (12M): X from SEC Form 4 or N/A Sells (12M): X from SEC Form 4 or N/A Net Shares (12M): +/ XXK from SEC Form 4 or N/A Short Int (%): X.X% Sentiment / Articles: +X.XXX / XX (Positive/Negative) Stock: [Type] + Div Yield: Combined: "Stock: Growth" + "Div Yield: X.XX%" Sector/Industry: Combined: "Sector / Industry" Row 4: QUALITY SCORES MOAT & OTHER Label Notes CQVS: XX.XX with benchmark range Label: Strong/Moderate/Weak Valuation: XX.XX Quality: XX.XX Strength: XX.XX Integrity: XX.XX Buffett Moat: X with benchmark (4 7) Greenblatt (MF): EY: X.X% / ROC: X.X% or N/A Beta: + Vol 1Y: Combined: "Beta: X.XX" + "Vol 1Y: XX.X%" Earnings Predict.: XX.X% with benchmark ( 80%) Drawdown (5Y): XX.X% with label (Low/Mid/High) Completeness: + Data Quality: Combined: "XX.X%" + "High/Medium/Low" STANDARDIZED BENCHMARKS (Single Source of Truth) Use these EXACT thresholds for color coding: Metric Green (Good) Yellow (Neutral) Red (Warning) ROE 20% 10 20% <10% ROA 10% 5 10% <5% Profit Margin 20% 10 20% <10% Operative Margin 20% 10 20% <10% Gross Margin 40% 25 40% <25% ROIC 15% 8 15% <8% Debt/Equity <1 1 2 2 Current Ratio 1 2 0.5 1 or 2 3 <0.5 or 3 Piotroski F ≥7 4 6 ≤3 Altman Z 2.99 1.81 2.99 <1.81 Beneish M < 2.22 2.22 to 1.78 1.78 PEG (1Y) <1 1 2 2 RSI (14) 30 50 50 70 70 or <30 Short Interest <5% 5 10% 10% FCF Yield 5% 2 5% <2% FCF Margin 15% 10 15% <10% Dividend Yield 2% 1 2% <1% or 8% Value Trap 0 39 40 59 60 100 Max Drawdown 30% 30% to 50% < 50% Revenue Growth 10% 0 10% <0% Earnings Growth 0% 10% to 0% < 10% Overview This skill provides institutional grade evaluation of potential stock investments. Unlike portfolio analysis which reviews existing positions, this skill evaluates stocks you're considering buying or deciding whether to purchase . The evaluation answers: Should I buy this stock? At what price should I enter? How much should I allocate? What's my upside and downside? When should I sell? Default Currency: € (Euro) All monetary values in the dashboard should be displayed in Euro (€) as the default currency: Price: €42.13 Market Cap: €78.3B Analyst Target: €56.45 Entry/Stop/Target prices: €38, €35, €56 EPS values: €1.39, €1.91 IMPORTANT: Use REPORTED Growth Rates For the dashboard metrics "Rev Growth" and "Earn Growth" : USE REPORTED GROWTH not underlying, adjusted, or organic figures Reported figures reflect actual GAAP/IFRS numbers including FX, acquisitions, disposals This provides a more accurate picture of what investors actually received Example: If underlying growth is 7% but reported is 2.2%, use 2.2% Same for earnings: Use reported EPS growth, not adjusted EPS growth Core Purpose Stock Evaluator is for: ✅ Evaluating potential investments BEFORE buying ✅ Analyzing watchlist candidates ✅ Getting buy/hold/sell recommendations with specific prices ✅ Comparing multiple investment opportunities ✅ Finding better alternatives to current consideration NOT for: ❌ Reviewing existing portfolio positions (use Portfolio Analyst skill) ❌ General stock market questions ❌ Stock screening or discovery from scratch ❌ Options, derivatives, or crypto analysis Evaluation Framework Five Pillars of Stock Evaluation 1. Valuation Assessment Is the stock undervalued, fairly valued, or overvalued? Multiple valuation methods (DCF, relative, Peter Lynch, asset based) Margin of safety requirement (15 30%) Fair value estimate with confidence range 2. Quality Analysis Business model strength and competitive moat Financial health and trends (5 10 year view) Management quality and capital allocation Industry position and competitive advantages 3. Timing Assessment Technical setup and entry points Near term catalysts and events Market sentiment and positioning Optimal entry price range 4. Position Sizing Allocation recommendation (% of portfolio) Based on conviction, risk, and diversification Maximum allocation limits Risk adjusted sizing 5. Conviction Rating Strong Buy : High conviction, clear undervaluation, low risk Buy : Good opportunity, reasonable valuation, moderate risk Hold : Fairly valued, no compelling reason to buy now Avoid : Overvalued, significant risks, or better alternatives exist Value Trap Indicator What It Is A Value Trap is when a stock appears undervalued (low P/E, low P/B) but is actually cheap for valid fundamental reasons. The stock keeps declining despite appearing "cheap." Value Trap Score Calculation (0 100, LOWER = more genuine, HIGHER = more trap) Components to evaluate (ADD points for trap indicators): 1. Price Momentum (25 points max) 6 month price change vs market: If underperforming by 20%, ADD 15 25 points 12 month price change: Sustained decline = ADD 10 20 points If price momentum is POSITIVE: ADD 0 points 2. Earnings Quality (25 points max) EPS trend (3 years): Declining = ADD 10 25 points Revenue trend: Declining = ADD 5 15 points Margin trend: Compressing = ADD 5 10 points If earnings quality is STRONG: ADD 0 points 3. Balance Sheet Health (25 points max) Debt levels increasing? ADD 5 15 points Cash flow negative or declining? ADD 10 20 points Working capital deteriorating? ADD 5 10 points If balance sheet is HEALTHY: ADD 0 points 4. Valuation Context (25 points max) Is low multiple justified by declining fundamentals? ADD 10 25 points Compare current fundamentals to when multiple was higher If fundamentals justify valuation: ADD 0 points Scoring Formula (Score ranges from 0 to 100, where 0 = definitely genuine value, 100 = definite value trap) Score Interpretation 0 19 : Genuine Value (likely undervalued, fundamentals intact) GREEN 20 39 : Probably Genuine (minor concerns, monitor) LIGHT GREEN 40 59 : Caution Zone (mixed signals, proceed carefully) YELLOW 60 79 : Likely Trap (multiple red flags) ORANGE 80 100 : Strong Trap Signal (avoid) RED Display Format Color coding: green <40, yellow 40 60, red 60 Investor Persona Scores Score each stock against 8 famous investor philosophies (0 10 scale). This helps users understand what type of investor the stock suits. 1. Warren Buffett Score Based on "The Warren Buffett Way" seeks durable competitive advantages Key metrics weighted: ROE ( 20%): 2 points Profit margin ( 15%): 2 points Free cash flow positive & growing: 2 points Moat strength (brand, pricing power): 2 points Predictable earnings: 2 points Buffett likes: Predictable businesses, pricing power, low capex needs, consistent profitability 2. Charlie Munger Score Based on "Poor Charlie's Almanack" mental latticework, inversion thinking Focus on: What could go WRONG (inversion principle) Scoring: Start at 10, subtract penalties: High debt (D/E 2): 3 points Volatile earnings: 2 poin