
Stock Analysis
- 5.7k installs
- 338 repo stars
- Updated January 31, 2026
- claude-office-skills/skills
stock-analysis evaluates equities with fundamental ratios, technical indicators, peer comparison, and formatted investment reports.
About
The stock-analysis skill produces structured equity research using fundamental and technical frameworks across US, China A-shares, and Hong Kong markets. Users provide a ticker or financial data plus an analysis type: quick metrics overview, deep fundamental review, technical chart review, or peer comparison. Fundamental workflows evaluate valuation ratios including P/E, P/B, P/S, EV/EBITDA, and PEG, profitability metrics like gross, operating, and net margins, ROE and ROIC, revenue and EPS growth, and balance-sheet health via debt/equity, current ratio, interest coverage, and FCF yield. Technical review covers moving averages, MACD, RSI, support and resistance, and chart patterns such as head and shoulders or breakouts. Reports include executive summary, key metrics versus industry, valuation assessment, risk factors, bull and bear cases, and an informational disclaimer. The skill integrates office-mcp tools for spreadsheets and charts but cannot provide real-time prices, investment advice, or proprietary trading data.
- Covers US, China A-shares, and Hong Kong equities with ticker or supplied financials.
- Supports quick, deep fundamental, technical, and peer comparison analysis modes.
- Evaluates valuation, profitability, growth, and balance-sheet metrics with industry context.
- Produces structured reports with bull case, bear case, risks, and rating labels.
- Integrates office-mcp spreadsheet and chart tools; excludes real-time prices and advice.
Stock Analysis by the numbers
- 5,730 all-time installs (skills.sh)
- +104 installs in the week ending Jul 28, 2026 (Skillselion tracking)
- Ranked #14 of 1,136 Finance & Trading skills by installs in the Skillselion catalog
- Security screen: LOW risk (skills.sh audit)
- Data as of Jul 28, 2026 (Skillselion catalog sync)
stock-analysis capabilities & compatibility
- Capabilities
- fundamental_analysis · technical_analysis · valuation_metrics · peer_comparison · risk_assessment
- Works with
- excel
- Use cases
- trading · research · data analysis
- Runs
- Runs locally
- Pricing
- Free
What stock-analysis says it does
Analyze stocks with fundamental and technical analysis. Supports US, China A-shares, and Hong Kong markets.
This analysis is for informational purposes only and does not constitute investment advice.
npx skills add https://github.com/claude-office-skills/skills --skill stock-analysisAdd your badge
Show developers this skill is listed on Skillselion. Paste this into your README.
| Installs | 5.7k |
|---|---|
| repo stars | ★ 338 |
| Security audit | 3 / 3 scanners passed |
| Last updated | January 31, 2026 |
| Repository | claude-office-skills/skills ↗ |
How do I structure a fundamental and technical stock analysis report for a ticker across supported markets?
Analyze equities with fundamental and technical metrics across US, A-share, and Hong Kong markets.
Who is it for?
Analysts researching US, A-share, or Hong Kong tickers who need templated equity reports from provided data.
Skip if: Skip for real-time quotes, trade execution, or personalized investment advice per skill limitations.
When should I use this skill?
User provides a ticker like AAPL or 600519.SH and requests fundamental, technical, or peer stock analysis.
What you get
Markdown stock analysis report with key metrics, valuation, technical levels, risks, and bull/bear thesis sections.
- Investment report PDF or markdown
- Comparison metrics table
- Technical and fundamental charts
By the numbers
- Version 1.0.0 under MIT license from claude-office-skills
- Supports 3 equity markets: US, China A-shares, and Hong Kong
Files
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 and trend direction
- RSI: Overbought (>70) / Oversold (<30)
Chart Patterns
- Support/Resistance: Key price levels
- Head and Shoulders: Reversal pattern
- Double Top/Bottom: Reversal signals
- Breakouts: Volume-confirmed moves
---
Output Format
# Stock Analysis Report: [TICKER]
**Company**: [Full Name]
**Market**: [Exchange]
**Sector**: [Industry]
**Analysis Date**: [Date]
---
## Executive Summary
[2-3 sentence overview of the company and investment thesis]
**Rating**: [Bullish / Neutral / Bearish]
**Risk Level**: [Low / Medium / High]
---
## Key Metrics at a Glance
| Metric | Value | vs Industry | Assessment |
|--------|-------|-------------|------------|
| P/E Ratio | XX.X | +/-XX% | [Undervalued/Fair/Expensive] |
| P/B Ratio | X.XX | +/-XX% | |
| ROE | XX.X% | +/-XX% | |
| Revenue Growth | XX.X% | +/-XX% | |
| Net Margin | XX.X% | +/-XX% | |
| Debt/Equity | X.XX | +/-XX% | |
---
## Fundamental Analysis
### Business Overview
[Description of business model, revenue streams, competitive advantages]
### Financial Performance
[Revenue trends, profitability, cash flow analysis]
### Valuation Assessment
[Fair value estimation, comparison to historical and peers]
---
## Technical Analysis
### Price Trend
[Current trend, key levels, momentum]
### Key Levels
- Support: $XX.XX
- Resistance: $XX.XX
- 52-week Range: $XX.XX - $XX.XX
---
## Risk Factors
1. [Risk 1]
2. [Risk 2]
3. [Risk 3]
---
## Investment Thesis
### Bull Case
[Positive scenario]
### Bear Case
[Negative scenario]
---
## Disclaimer
This analysis is for informational purposes only and does not constitute investment advice. Past performance does not guarantee future results.---
Example
User Request
Analyze Apple (AAPL) stock. Focus on fundamental analysis and current valuation.My Response
Stock Analysis Report: AAPL
Company: Apple Inc. Market: NASDAQ Sector: Technology / Consumer Electronics Analysis Date: January 2025
---
Executive Summary
Apple remains the world's most valuable company with a dominant ecosystem in consumer electronics and services. Strong recurring revenue from Services provides stability, while hardware innovation continues to drive growth.
Rating: Neutral Risk Level: Low
---
Key Metrics at a Glance
| Metric | Value | vs Industry | Assessment |
|---|---|---|---|
| P/E Ratio | 28.5 | +15% | Premium valuation |
| P/B Ratio | 45.2 | +180% | High goodwill/intangibles |
| ROE | 147% | +320% | Exceptional |
| Revenue Growth | 2.1% | -5% | Slowing |
| Net Margin | 25.3% | +85% | Industry-leading |
| Debt/Equity | 1.76 | +40% | Manageable |
[...continues with full analysis...]
---
Tips for Better Results
1. Provide recent financials if available for more accurate analysis 2. Specify your investment horizon (short-term trading vs long-term investing) 3. Mention specific concerns you want me to address 4. Include peer companies for comparison analysis 5. Specify market context (bull/bear market conditions)
---
Limitations
- Cannot access real-time market data
- Analysis based on publicly available information only
- Does not account for insider information or pending announcements
- Valuation models have inherent assumptions and limitations
- Not a substitute for professional financial advice
---
Built by the Claude Office Skills community. Contributions welcome!
Related skills
How it compares
Use stock-analysis for multi-market equity research reports; use DeFi-focused OKX skills for on-chain protocol positions.
FAQ
What does stock-analysis do?
stock-analysis evaluates equities with fundamental ratios, technical indicators, peer comparison, and formatted investment reports.
When should I use stock-analysis?
User provides a ticker like AAPL or 600519.SH and requests fundamental, technical, or peer stock analysis.
Is this skill safe to install?
Review the Security Audits panel on this page before installing in production.