Yahoo Finance Analyzer: Stock Data to AI-Powered Reports

Pull stock data, perform technical analysis, and generate AI reports:

• Pull stock profiles from Yahoo Finance
• Retrieve historical prices and financials
• Compute technical indicators (EMA, RSI, MACD, Bollinger)
• AI-powered analysis via Gemini
• Generate styled PDF reports
• Financial statements (P&L, Balance Sheet, Cash Flow)

1. Download & Install: get the app above and install xlwings Lite
2. Get Gemini API key: free at aistudio.google.com
3. Built-in Functions:
   • get_profile - company info
   • get_prices - historical prices
   • create_technicals - calculate indicators
   • get_technical_analysis_from_gemini
4. Enter tickers: Yahoo symbols (AAPL, ^NSEI, etc.)

Data Retrieval

• xlwings Lite calls a custom FastAPI server
• FastAPI uses yfinance to fetch Yahoo Finance data
• Server handles CORS issues from the browser environment

Technical Analysis

• finta package calculates EMA, RSI, MACD
• Indicators added as new columns to price data
• Data prepared for AI analysis

AI Reporting

• Price data + indicators sent to Gemini
• Markdown output styled via FastAPI server
• Converted to PDF via the md2pdf service