This gives you a structured framework for analyzing stocks across US, Chinese, and Hong Kong markets with both fundamental and technical methods. You feed it a ticker and financial data, choose between quick overview or deep dive, and get back a formatted report with valuation ratios, profitability metrics, risk assessment, and bull/bear cases. The analysis templates are solid with specific benchmarks like ROE over 15% or current ratio above 1.5, though you'll need to bring your own market data since it can't pull live prices. Best for documenting your research process or building investment memos rather than getting trading signals.
npx -y skills add claude-office-skills/skills --skill stock-analysis --agent claude-codeInstalls into .claude/skills of the current project.
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:
What I cannot do:
Tell me:
I'll provide a structured report with:
| 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 |
| 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 |
| Metric | What to Look For |
|---|---|
| Revenue Growth | >10% YoY indicates strong demand |
| EPS Growth | Should outpace revenue (operating leverage) |
| FCF Growth | Sustainable growth driver |
| 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 |
# 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.
Analyze Apple (AAPL) stock. Focus on fundamental analysis and current valuation.
Company: Apple Inc. Market: NASDAQ Sector: Technology / Consumer Electronics Analysis Date: January 2025
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
| 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...]
Built by the Claude Office Skills community. Contributions welcome!
larksuite/cli
googleworkspace/cli
googleworkspace/cli
googleworkspace/cli