
Stock Analysis
Produce structured fundamental and technical stock research reports for US, China A-share, and Hong Kong tickers using spreadsheet-friendly outputs.
Install
npx skills add https://github.com/claude-office-skills/skills --skill stock-analysisWhat is this skill?
- Fundamental analysis: P/E, P/B, ROE, revenue growth, and margin framing
- Technical analysis: trend, support/resistance, and indicator commentary
- Peer comparison, industry positioning, and explicit risk assessment
- Office MCP hooks: read_xlsx, create_xlsx, create_chart, analyze_spreadsheet
- Bilingual workflow support (English and Chinese) for cross-market coverage
Adoption & trust: 3.9k installs on skills.sh; 196 GitHub stars; 3/3 security scanners passed (skills.sh audits).
Recommended Skills
China Stock Analysissugarforever/01coder-agent-skills
Grimoire Polymarketfranalgaba/grimoire
Backtesting Frameworkswshobson/agents
Stock Analysisgracefullight/stock-checker
Coinglassstarchild-ai-agent/official-skills
Akshare Stockmolezzz/openclaw-stock-skill
Journey fit
Common Questions / FAQ
Is Stock Analysis safe to install?
skills.sh reports 3 of 3 security scanners passed. Review the Security Audits panel on this page before installing in production.
SKILL.md
READMESKILL.md - Stock Analysis
# Stock Analysis Skill ## Overview I help you analyze stocks using fundamental and technical analysis methods. I can evaluate companies across US, China A-shares, and Hong Kong markets. **What I can do:** - Fundamental analysis (P/E, P/B, ROE, revenue growth, margins) - Technical analysis (trend, support/resistance, indicators) - Peer comparison and industry positioning - Risk assessment and investment thesis - Generate structured analysis reports **What I cannot do:** - Provide real-time stock prices (use external data sources) - Give investment advice or recommendations - Guarantee future performance - Access proprietary trading data --- ## How to Use Me ### Step 1: Provide Company Information Tell me: - Stock ticker/code (e.g., AAPL, 600519.SH, 0700.HK) - Market (US/China A-shares/Hong Kong) - Or provide financial data directly ### Step 2: Choose Analysis Type - **Quick Analysis**: Key metrics overview - **Deep Dive**: Comprehensive fundamental analysis - **Technical Review**: Chart patterns and indicators - **Peer Comparison**: Compare with competitors ### Step 3: Receive Analysis Report I'll provide a structured report with: - Company overview - Key financial metrics - Valuation assessment - Risk factors - Investment thesis --- ## Analysis Framework ### Fundamental Analysis Metrics #### Valuation Ratios | Metric | Formula | Interpretation | |--------|---------|----------------| | P/E Ratio | Price / EPS | <15 undervalued, >25 expensive | | P/B Ratio | Price / Book Value | <1 potential value, >3 growth priced in | | P/S Ratio | Price / Revenue | Useful for unprofitable companies | | EV/EBITDA | Enterprise Value / EBITDA | <10 attractive, >15 expensive | | PEG Ratio | P/E / Growth Rate | <1 undervalued relative to growth | #### Profitability Metrics | Metric | Formula | Good Benchmark | |--------|---------|----------------| | Gross Margin | Gross Profit / Revenue | >40% strong pricing power | | Operating Margin | Operating Income / Revenue | >15% efficient operations | | Net Margin | Net Income / Revenue | >10% healthy profitability | | ROE | Net Income / Shareholder Equity | >15% good capital efficiency | | ROIC | NOPAT / Invested Capital | >WACC value creation | #### Growth Metrics | Metric | What to Look For | |--------|------------------| | Revenue Growth | >10% YoY indicates strong demand | | EPS Growth | Should outpace revenue (operating leverage) | | FCF Growth | Sustainable growth driver | #### Financial Health | Metric | Formula | Safe Range | |--------|---------|------------| | Debt/Equity | Total Debt / Equity | <1 for most industries | | Current Ratio | Current Assets / Current Liabilities | >1.5 healthy liquidity | | Interest Coverage | EBIT / Interest Expense | >5 comfortable | | FCF Yield | FCF / Market Cap | >5% attractive | ### Technical Analysis Patterns #### Trend Indicators - **Moving Averages**: 50-day, 200-day crossovers - **MACD**: Momentum