S&P 500 Dashboard Pro

A modern, serverless stock market dashboard providing real-time analytics, technical indicators, and AI-powered sentiment analysis for top S&P 500 companies.

Key Features

Real-Time Stock Data

Live prices, volume, and market metrics with permanent historical storage and incremental updates.

Technical Indicators

Advanced indicators including SMA (20/50), RSI, MACD, Bollinger Bands, and Garman-Klass Volatility.

News Sentiment Analysis

AI-powered sentiment scoring using TextBlob with real-time news aggregation and analysis.

Interactive Charts

Multi-panel Plotly charts with zoom, pan, and hover interactions across multiple timeframes.

Company Comparison

Side-by-side metrics and performance visualization for up to 4 companies simultaneously.

Smart Caching

PostgreSQL permanent storage with incremental updates - historical data never re-fetched.

Technology Stack

Backend

Python 3.11+ Flask framework
PostgreSQL Neon serverless database
psycopg2 Connection pooling
yfinance Yahoo Finance API
NewsAPI Company news feeds

Frontend

Jinja2 Template engine
Bootstrap 5.3 UI framework
Plotly.js Interactive charts
Feather Icons Icon library
Custom CSS Dark navy theme

Data & Analytics

Pandas Data manipulation
NumPy Numerical computing
pandas-ta Technical indicators
TextBlob Sentiment analysis

Deployment

Vercel Serverless platform
Neon Cloud PostgreSQL
Python Dotenv Config management
Gunicorn WSGI server

Key Metrics Explained

Total market value of a company's outstanding shares. Calculated as: Share Price × Total Outstanding Shares. Large-cap companies (>$10B) are typically more stable, while small-cap (<$2B) may offer higher growth potential.

Price-to-Earnings ratio measures how much investors are willing to pay per dollar of earnings. Higher P/E may indicate growth expectations or overvaluation. Industry averages vary - tech companies often have higher P/E ratios than utilities.

Momentum indicator ranging from 0-100. RSI > 70 suggests overbought conditions (potential sell signal), RSI < 30 suggests oversold conditions (potential buy signal). Default period is 14 days.

Moving Average Convergence Divergence shows the relationship between two moving averages (12-day and 26-day EMAs). When MACD crosses above the signal line, it's a bullish signal. When it crosses below, it's bearish.

Volatility bands plotted at standard deviation levels above and below a moving average. When price touches the upper band, it may be overbought. When it touches the lower band, it may be oversold.

Advanced volatility measure that uses high, low, open, and close prices. More efficient than standard deviation-based volatility as it captures intraday price movements.

Important Disclaimer

This dashboard is for informational and educational purposes only. It is NOT financial advice, investment recommendation, or a suggestion to buy or sell any security.

Always conduct your own research and consult with a qualified financial advisor before making investment decisions. Past performance does not guarantee future results. Stock market investments carry risk, including possible loss of principal.