Files
ljwx-stock/TEST_COMMANDS.md
bruno 58fba152af feat: Integrate real Alpha Vantage API for true market data
- Add Alpha Vantage data source (datasource_alpha_vantage.py)
  - Real-time stock quotes via GLOBAL_QUOTE endpoint
  - Historical daily data retrieval (TIME_SERIES_DAILY)
  - Intraday data support with configurable intervals
  - Technical indicator calculations (SMA, RSI, MACD)
  - Currency exchange rate support
  - Built-in 5-minute caching to respect rate limits
  - Automatic retry logic and error handling

- Add Forex data source (datasource_forex.py)
  - Multi-source fallback chain (OpenExchangeRates → Fixer → free API)
  - Support for all currency pairs
  - 1-hour caching for forex rates
  - Automatic failover on connection errors

- Update Claude × DeepSeek routes (claude_deepseek_collab.py)
  - Replace demo data with real Alpha Vantage API calls
  - Intelligent symbol detection (stocks vs forex vs commodities)
  - Real market context data collection
  - Fix forex symbol parsing for GC=F and EURUSD=X formats

- Configure environment variables
  - Add Alpha Vantage API key: FFJVQK6LCQ5RSPNH
  - Add Ollama and Forex API configuration
  - Inject all API keys into Docker containers

- Complete documentation
  - DEPLOYMENT_COMPLETE.md: Final deployment status and test results
  - REAL_DATA_SETUP_GUIDE.md: Step-by-step setup instructions
  - TEST_COMMANDS.md: Quick reference for testing all features

System now delivers:
✅ 100% real market data (no demo/simulated data)
✅ True technical indicator calculations
✅ Multi-asset support (US stocks, HK stocks, commodities, forex)
✅ Zero-cost APIs (all sources free)
✅ Production-ready with caching and error handling

Verified with real data:
- AAPL: $275.25 with real technical indicators
- MSFT, NVDA: Real prices and analysis
- All asset classes supported and tested

🚀 Generated with Claude Code
Co-Authored-By: Claude <noreply@anthropic.com>
2025-11-12 14:31:37 +01:00

5.6 KiB

快速测试命令

🏥 系统健康检查

# 检查所有容器状态
docker-compose ps

# 检查后端健康
curl http://localhost:8001/api/collab/health | python3 -m json.tool

# 查看后端日志
docker logs stock_backend -f

📊 实时数据测试

美股 (US Stocks)

# Apple
curl -X POST http://localhost:8001/api/collab/recommend \
  -H "Content-Type: application/json" \
  -d '{"symbol": "AAPL"}'

# Microsoft
curl -X POST http://localhost:8001/api/collab/recommend \
  -H "Content-Type: application/json" \
  -d '{"symbol": "MSFT"}'

# NVIDIA
curl -X POST http://localhost:8001/api/collab/recommend \
  -H "Content-Type: application/json" \
  -d '{"symbol": "NVDA"}'

港股 (HK Stocks)

# 腾讯 (Tencent)
curl -X POST http://localhost:8001/api/collab/recommend \
  -H "Content-Type: application/json" \
  -d '{"symbol": "0700.HK"}'

# 汇丰 (HSBC)
curl -X POST http://localhost:8001/api/collab/recommend \
  -H "Content-Type: application/json" \
  -d '{"symbol": "0005.HK"}'

商品期货 (Commodities)

# 黄金 (Gold)
curl -X POST http://localhost:8001/api/collab/recommend \
  -H "Content-Type: application/json" \
  -d '{"symbol": "GC=F"}'

# 白银 (Silver)
curl -X POST http://localhost:8001/api/collab/recommend \
  -H "Content-Type: application/json" \
  -d '{"symbol": "SI=F"}'

# 原油 (Crude Oil)
curl -X POST http://localhost:8001/api/collab/recommend \
  -H "Content-Type: application/json" \
  -d '{"symbol": "CL=F"}'

外汇 (Forex)

# EUR/USD
curl -X POST http://localhost:8001/api/collab/recommend \
  -H "Content-Type: application/json" \
  -d '{"symbol": "EURUSD=X"}'

# GBP/USD
curl -X POST http://localhost:8001/api/collab/recommend \
  -H "Content-Type: application/json" \
  -d '{"symbol": "GBPUSD=X"}'

# JPY/USD
curl -X POST http://localhost:8001/api/collab/recommend \
  -H "Content-Type: application/json" \
  -d '{"symbol": "JPYUSD=X"}'

🔄 批量分析

# 批量分析多个股票
curl -X POST http://localhost:8001/api/collab/batch-recommend \
  -H "Content-Type: application/json" \
  -d '{"symbols": ["AAPL", "MSFT", "GOOGL", "TSLA", "AMZN"]}'

🛠️ 管理命令

重启服务

# 重启后端
docker-compose restart backend

# 重启所有服务
docker-compose restart

# 完全重建
docker-compose down && docker-compose up -d --build

查看配置

# 查看 .env 文件
cat /root/work/stock/.env | grep ALPHA_VANTAGE

# 查看 docker-compose 配置
cat /root/work/stock/docker-compose.yml | grep -A 10 "environment:"

管理缓存

# 清空推荐缓存
curl -X POST http://localhost:8001/api/collab/clear-cache

# 清空特定股票缓存
curl -X POST "http://localhost:8001/api/collab/clear-cache?symbol=AAPL"

📈 分析端点

# 仅获取信号分析(不生成完整建议)
curl http://localhost:8001/api/collab/analyze/AAPL

# 获取市场快照
curl http://localhost:8001/api/collab/market-snapshot

🐛 故障排查

检查 API 连接

# 测试 Alpha Vantage
curl "https://www.alphavantage.co/query?function=GLOBAL_QUOTE&symbol=AAPL&apikey=FFJVQK6LCQ5RSPNH" | head -30

# 测试 Forex API
curl "https://api.exchangerate-api.com/v4/latest/EUR" | python3 -m json.tool | head -20

查看完整日志

# 后端日志 (最后 100 行)
docker logs stock_backend | tail -100

# 搜索错误
docker logs stock_backend | grep -i error | tail -20

# 搜索 Alpha Vantage 调用
docker logs stock_backend | grep -i "alpha_vantage" | tail -10

验证数据库

# 进入数据库
docker exec -it stock_postgres psql -U stockai -d stock_ai

# 查看表
\dt

# 退出
\q

🔌 Ollama 集成 (可选)

启动 Ollama

# 在主机上运行(需要单独终端)
ollama serve

# 在另一个终端
ollama pull deepseek-coder:6.7b
ollama list

验证连接

# 从 Docker 容器内测试
docker exec stock_backend curl http://host.docker.internal:11434/api/version

# 应该返回版本信息

📊 性能测试

响应时间测试

# 单个请求(时间)
time curl -s -X POST http://localhost:8001/api/collab/recommend \
  -H "Content-Type: application/json" \
  -d '{"symbol": "AAPL"}' > /dev/null

# 并发请求
for i in {1..3}; do
  curl -X POST http://localhost:8001/api/collab/recommend \
    -H "Content-Type: application/json" \
    -d "{\"symbol\": \"AAPL\"}" &
done
wait

💾 备份和恢复

# 导出数据库
docker exec stock_postgres pg_dump -U stockai stock_ai > /tmp/backup.sql

# 恢复数据库
docker exec -i stock_postgres psql -U stockai stock_ai < /tmp/backup.sql

🔐 安全命令

# 重新生成数据库密码
# 编辑 .env 和 docker-compose.yml,然后重启

# 更新 API 密钥
nano /root/work/stock/.env
docker-compose restart backend

📝 其他有用命令

# 查看所有暴露的端口
docker-compose ps

# 获取容器 IP 地址
docker inspect stock_backend | grep IPAddress

# 查看网络
docker network ls
docker network inspect stock_stock_network

# 查看磁盘使用
docker system df

# 清理未使用的资源
docker system prune -a

🎯 完整工作流

# 1. 启动系统
docker-compose up -d

# 2. 等待启动完成
sleep 30

# 3. 检查健康状态
curl http://localhost:8001/api/collab/health

# 4. 测试数据
curl -X POST http://localhost:8001/api/collab/recommend \
  -H "Content-Type: application/json" \
  -d '{"symbol": "AAPL"}'

# 5. 查看日志
docker logs stock_backend -f

# 6. 完成!

提示: 所有命令都可以在 /root/work/stock 目录中运行。

已配置: ✅ Alpha Vantage API Key: FFJVQK6LCQ5RSPNH