Now liveThe Skillselion MCP - thousands of ranked skills, loaded into your agent mid-task. No install.Get it →
claude-office-skills avatar

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)
At a glance

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
From the docs

What stock-analysis says it does

Analyze stocks with fundamental and technical analysis. Supports US, China A-shares, and Hong Kong markets.
SKILL.md
This analysis is for informational purposes only and does not constitute investment advice.
SKILL.md
npx skills add https://github.com/claude-office-skills/skills --skill stock-analysis

Add your badge

Show developers this skill is listed on Skillselion. Paste this into your README.

Listed on Skillselion
Installs5.7k
repo stars338
Security audit3 / 3 scanners passed
Last updatedJanuary 31, 2026
Repositoryclaude-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

SKILL.mdMarkdownGitHub ↗

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
MetricFormulaInterpretation
P/E RatioPrice / EPS<15 undervalued, >25 expensive
P/B RatioPrice / Book Value<1 potential value, >3 growth priced in
P/S RatioPrice / RevenueUseful for unprofitable companies
EV/EBITDAEnterprise Value / EBITDA<10 attractive, >15 expensive
PEG RatioP/E / Growth Rate<1 undervalued relative to growth
Profitability Metrics
MetricFormulaGood Benchmark
Gross MarginGross Profit / Revenue>40% strong pricing power
Operating MarginOperating Income / Revenue>15% efficient operations
Net MarginNet Income / Revenue>10% healthy profitability
ROENet Income / Shareholder Equity>15% good capital efficiency
ROICNOPAT / Invested Capital>WACC value creation
Growth Metrics
MetricWhat to Look For
Revenue Growth>10% YoY indicates strong demand
EPS GrowthShould outpace revenue (operating leverage)
FCF GrowthSustainable growth driver
Financial Health
MetricFormulaSafe Range
Debt/EquityTotal Debt / Equity<1 for most industries
Current RatioCurrent Assets / Current Liabilities>1.5 healthy liquidity
Interest CoverageEBIT / Interest Expense>5 comfortable
FCF YieldFCF / 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

MetricValuevs IndustryAssessment
P/E Ratio28.5+15%Premium valuation
P/B Ratio45.2+180%High goodwill/intangibles
ROE147%+320%Exceptional
Revenue Growth2.1%-5%Slowing
Net Margin25.3%+85%Industry-leading
Debt/Equity1.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.

This week in AI coding

Five minutes, every Monday - the tools, releases and tactics for developers.

unsubscribe anytime.