Content
# Stock News Automation Service
An intelligent MCP (Model Context Protocol) server that automates stock analysis and news updates in Google Sheets using AI-powered insights.
## 🚀 Features
### Core Capabilities
- **Google Sheets Integration**: Seamlessly connects to your Google Sheets for real-time stock data management
- **AI-Powered Analysis**: Uses Google Gemini to generate comprehensive stock analysis
- **Multi-Type Analysis**: Supports 5 different analysis types for comprehensive coverage
- **Institutional Data Visualization**: Creates charts for institutional ownership data
- **Automated News Updates**: Fetches and summarizes latest stock news
### Analysis Types Available
1. **📰 News Analysis + Market Context** (Column D)
- Company-specific news and earnings
- Broader market trends and economic factors
- Geopolitical impact and industry disruption
2. **🤖 AI-Powered Insights** (Column E)
- Predictive modeling and pattern recognition
- Scenario analysis with probability assessments
- Market timing indicators
3. **📊 Investor Insights** (Column F)
- Technical and fundamental analysis
- Risk assessment and competitive analysis
- Sector dynamics and catalyst calendar
4. **💰 Quick Financials Overview** (Column G)
- Key financial metrics and ratios
- Growth rates and profitability analysis
- Liquidity and valuation metrics
5. **🏢 Institutional Information** (Column H)
- Institutional ownership data
- Hedge fund and mutual fund activity
- Insider trading and analyst coverage
## 🛠️ Setup Instructions
### Prerequisites
- Python 3.8+
- Google Cloud Console account
- Google Sheets API access
### 1. Google Sheets API Setup
Follow the official Google guide to set up API access:
**[Google Sheets API Quickstart](https://developers.google.com/workspace/sheets/api/quickstart/python)**
### 2. Installation
```bash
# Clone the repository
git clone <your-repo-url>
cd stocks
# Create virtual environment
python -m venv stocks
source stocks/bin/activate # On Windows: stocks\Scripts\activate
# Install dependencies
pip install -r requirements.txt
```
### 3. Configuration
1. Download `credentials.json` from Google Cloud Console
2. Place it in the project root directory
3. Create `.env` file with:
```env
GOOGLE_API_KEY=your_gemini_api_key
SPREADSHEET_ID=your_google_sheets_id
RANGE_NAME=Sheet1!A6:C9
```
### 4. Usage
#### Option A: Standalone Mode
```bash
# Start the MCP Server
python server.py
# Run the Client
python client.py server.py
```
#### Option B: MCP Client Integration
Add to your MCP client configuration:
```json
{
"mcpServers": {
"stonks-server": {
"command": "path to your python bin",
"args": ["path to server.py"]
}
}
}
```
**Note**: Update the paths to match your actual installation directory.
## 🎯 How It Works
1. **Initialize**: Authenticate with Google Sheets API
2. **Get Stocks**: Retrieve stock data from your spreadsheet
3. **Analyze**: Generate AI-powered analysis for each stock
4. **Update**: Automatically populate analysis in designated columns
5. **Visualize**: Create institutional ownership charts
## 📋 Available MCP Tools
- **`initialize()`**: Set up Google Sheets authentication
- **`get_stocks()`**: Fetch stock data from spreadsheet
- **`update()`**: Add analysis to specific cells with multiple analysis types
- **`search_news()`**: Generate news summaries using Gemini AI
- **`plot_institutional_chart()`**: Create ownership visualization charts
These tools are available through any MCP-compatible client (Claude Desktop, etc.)
## 🔧 Technical Architecture
- **MCP Server**: FastMCP framework for tool orchestration
- **AI Integration**: Google Gemini for intelligent analysis
- **Data Visualization**: Matplotlib for institutional charts
- **Authentication**: OAuth2 for secure Google Sheets access
- **Client Interface**: LangGraph with React agent for natural language interaction
## 📊 Sample Workflow
```
User: "Update all stocks with latest news and analysis"
↓
Agent:
1. Initializes Google Sheets connection
2. Retrieves stock symbols from spreadsheet
3. Generates news analysis for each stock
4. Updates respective columns with AI insights
5. Creates institutional ownership charts
```
## 🚨 Important Notes
- Analysis is based on last 10 days of data
- Includes references to SeekingAlpha, TradingTerminal, and TradingView
- Not financial advice - for informational purposes only
- Requires valid Google API credentials
## 📈 Future Enhancements
- Real-time data integration
- Advanced charting capabilities
- Portfolio performance tracking
- Custom analysis templates
- Multi-exchange support
---
**Setup Guide**: [Google Sheets API Quickstart](https://developers.google.com/workspace/sheets/api/quickstart/python)
