Stock Analysis Agent - AI-Powered Investment Research

📋 Project Overview & Problem Statement

Challenge: Retail investors spend countless hours manually screening stocks, analyzing financial statements, researching competitive advantages, and evaluating dividend sustainability. This process is time-intensive, requires expertise across multiple domains, and often leads to inconsistent analysis.

Solution: Stock Analysis Agent is a multi-agent AI system that automates the entire investment research workflow for Malaysian stocks. It screens 50+ stocks against your criteria, performs 7-category fundamental analysis, researches business moats via web search, and generates professional investment reports with actionable buy/hold/avoid recommendations.

Key Benefits

Time Savings: Reduce stock research from days to minutes with automated screening
Comprehensive Analysis: 5 specialized AI agents analyze fundamentals, moats, dividends, and valuation
Data-Driven Insights: Real-time financial data from Yahoo Finance + web research
Professional Reports: Investment reports with 0-100 scoring and clear recommendations
Stock Discovery: Batch screening to uncover hidden investment opportunities

🤖 Multi-Agent AI Architecture

🔍 Agent 1: Stock Screener

Validates stocks against investment criteria: PE ratio (4-15), ROE (≥5%), dividend yield (≥1%), price limits, market cap, and trading volume.

📈 Agent 2: Fundamental Analyst

Scores fundamentals (20pts), financial health (15pts), and valuation (20pts) using ROE, EPS, debt ratios, and pricing metrics.

🏰 Agent 3: Business Moat Analyst

Researches competitive advantages via Tavily web search. Evaluates brand strength, network effects, cost advantages, and barriers to entry (15pts).

💰 Agent 4: Dividend & Cash Flow Analyst

Analyzes dividend sustainability, payout ratios, yield trends, and cash flow quality (15pts). Assesses long-term income potential.

📋 Agent 5: Investment Report Generator

Compiles all analysis into professional markdown reports with visualizations, scoring breakdown, and actionable recommendations.

Investment Yardstick (0-100 Scoring System)

Category	Weight	Max Points	Evaluation Criteria
Fundamentals & Profitability	20%	20	ROE, EPS, profit margins, operating efficiency
Financial Health & Solvency	15%	15	Debt ratios, current ratio, book value, liquidity
Valuation	20%	20	PE ratio, price-to-book, price-to-sales
Business Moat	15%	15	Competitive advantages, brand, barriers
Cash Flow & Dividends	15%	15	Dividend yield, payout ratio, sustainability
Management & Outlook	10%	10	Track record, governance, strategy
Liquidity	5%	5	Trading volume, bid-ask spread

Recommendation Scale

80-100 points: Strong Buy 🟢 - Excellent investment opportunity
60-79 points: Buy 🟡 - Good fundamentals with solid potential
40-59 points: Hold ⚪ - Neutral, monitor for changes
0-39 points: Avoid 🔴 - Significant concerns identified

🛠️ Technical Architecture & Data Sources

AI & Processing Stack

Google Gemini 2.0 Flash Yahoo Finance API Tavily Web Search Python 3.8+ Google Colab

Data Analysis Libraries

Pandas yfinance Matplotlib Seaborn JSON Processing

Multi-Agent Workflow

Sequential Agent Execution:

Stage 1: Stock Screener validates against investment criteria (pass/fail)
Stage 2: Fundamental Analyst scores profitability, health, and valuation (55 points)
Stage 3: Business Moat Analyst researches competitive advantages via web (15 points)
Stage 4: Dividend Analyst evaluates cash flow and sustainability (15 points)
Stage 5: Report Generator compiles analysis and creates visualizations

Data Sources & Integration

Yahoo Finance (yfinance): Real-time stock prices, financial ratios, dividend history
Tavily API: Web search for business moat research and competitive analysis
Malaysian Stock Market: 50+ major stocks (KLCI components + liquid stocks)

📖 Usage Guide & Examples

Analyze a Single Stock

# Analyze Bursa Malaysia (1818.KL)
results = run_stock_analysis_pipeline('1818.KL')

# View generated report and visualization
print(f"Report: {results['report_path']}")
print(f"Chart: {results['chart_path']}")

# Opens markdown report with:
# - Screening results
# - 7-category yardstick scores
# - Buy/Hold/Avoid recommendation
            

Stock Discovery (Batch Screening)

# Screen 50 Malaysian stocks and analyze top 3
discovery_results = discover_stocks(
    criteria={
        'max_price': 1.00,              # Price ≤ RM 1.00
        'min_pe': 4, 'max_pe': 15,     # PE ratio 4-15
        'min_roe': 5,                   # ROE ≥ 5%
        'min_dividend_yield': 1,        # Dividend yield ≥ 1%
        'min_market_cap': 50_000_000,   # Market cap ≥ RM50M
        'min_volume': 50_000            # Volume ≥ 50K/day
    },
    max_stocks_to_scan=50,
    analyze_top_n=3
)

# View passing stocks
print(discovery_results['passing_stocks'])
            

Supported Malaysian Stocks

50+ Major Stocks Including:

Banking: Maybank (1155.KL), Public Bank (1295.KL), CIMB (1023.KL)
Telecommunications: Axiata (6888.KL), Maxis (6033.KL), DIGI (4197.KL)
Plantation: Sime Darby (5296.KL), IOI Corp (2445.KL), KLK (5285.KL)
Oil & Gas: Petronas Gas (5222.KL), MISC (3816.KL)
Consumer: Nestle (3689.KL), BAT (5225.KL), Dutch Lady (7277.KL)

🚀 Getting Started with Google Colab

Quick Start (3 Steps)

Step 1: Open Google Colab Notebook
Step 2: Add API keys to Colab Secrets (🔑 icon in sidebar):
- GOOGLE_API_KEY - Get from Google AI Studio
- TAVILY_API_KEY - Get from Tavily
Step 3: Run all cells and start analyzing stocks!

Example Analysis Output

Investment Report Contents:

Executive summary with total score and recommendation
Screening results table (pass/fail for each criterion)
7-category yardstick breakdown with detailed analysis
Business moat assessment with strengths/weaknesses
Dividend sustainability evaluation
Visualization: Bar chart of category scores

📊 Performance Metrics & Capabilities

50+

Stocks Screened

5

Specialized AI Agents

7

Analysis Categories

100

Point Scoring Scale

Analysis Speed & Efficiency

Single Stock Analysis: 2-3 minutes for complete 5-agent workflow
Batch Screening: 50 stocks in ~5 minutes
Data Freshness: Real-time Yahoo Finance data (live prices and ratios)
Report Format: Markdown + PNG visualization

Investment Criteria Supported

Price Range: Maximum price filtering for budget constraints
PE Ratio: Min/Max range to avoid overvalued or loss-making stocks
ROE Threshold: Minimum profitability requirement
Dividend Yield: Minimum passive income potential
Market Cap: Filter by company size and stability
Trading Volume: Ensure adequate liquidity

⚠️ Important Disclaimer

FOR EDUCATIONAL PURPOSES ONLY

This tool is designed for educational and research purposes. It is NOT financial advice. Stock market investing involves risk, and you could lose money.

User Responsibilities

Do Your Own Research: Always conduct additional due diligence
Consult Professionals: Seek advice from licensed financial advisors
Understand Risks: Past performance does not guarantee future results
Risk Management: Never invest more than you can afford to lose
Diversification: Don't rely on a single analysis tool

The AI agents provide analytical insights based on publicly available data, but investment decisions should always be made with professional guidance and personal risk assessment.

📈 Stock Analysis Agent