Stock Market Analysis Dashboard

🌐

Market Cap

$0

0.00%

📊

Trading Volume

0

0.00%

📈

Top Gainers

0

+0.00%

📉

Top Losers

0

-0.00%

📈 Market Indices Performance

👁️ Stock Watchlist

Symbol	Company	Price	Change	% Change	Volume	Market Cap	Action

💰 Total Portfolio Value

$0.00

$0.00 (0.00%)

📊 Today's Change

$0.00

0.00%

📈 Total Holdings

0

Stocks

🥧 Portfolio Allocation

📊 My Holdings

Symbol	Shares	Avg. Cost	Current Price	Market Value	Gain/Loss	% Gain/Loss	Action

📈 Stock Price Analysis

RSI (14)

0.00

Neutral

MACD

0.00

Neutral

SMA (50)

$0.00

Above

Volume Trend

Normal

Stable

🗄️ SQL Queries for Stock Market Analysis

Explore the SQL queries powering this financial dashboard

📊 Market Analysis Queries

Top Performing Stocks

SELECT 
    s.symbol,
    s.company_name,
    s.current_price,
    s.previous_close,
    ((s.current_price - s.previous_close) / s.previous_close) * 100 as change_percent,
    s.volume,
    s.market_cap
FROM stocks s
WHERE s.trading_date = CURDATE()
ORDER BY change_percent DESC
LIMIT 10;

Market Indices Performance

SELECT 
    i.index_name,
    i.current_value,
    i.open_value,
    i.high_value,
    i.low_value,
    ((i.current_value - i.open_value) / i.open_value) * 100 as daily_change
FROM market_indices i
WHERE i.trading_date = CURDATE()
ORDER BY daily_change DESC;

💼 Portfolio Management Queries

Portfolio Performance

SELECT 
    p.symbol,
    p.shares,
    p.avg_cost,
    s.current_price,
    (p.shares * s.current_price) as market_value,
    (p.shares * s.current_price) - (p.shares * p.avg_cost) as unrealized_gain_loss,
    (((s.current_price - p.avg_cost) / p.avg_cost) * 100) as return_percent
FROM portfolio p
JOIN stocks s ON p.symbol = s.symbol
WHERE p.user_id = 1
ORDER BY market_value DESC;

📈 Technical Analysis Queries

Moving Averages

SELECT 
    symbol,
    trading_date,
    close_price,
    AVG(close_price) OVER (
        PARTITION BY symbol 
        ORDER BY trading_date 
        ROWS BETWEEN 19 PRECEDING AND CURRENT ROW
    ) as sma_20,
    AVG(close_price) OVER (
        PARTITION BY symbol 
        ORDER BY trading_date 
        ROWS BETWEEN 49 PRECEDING AND CURRENT ROW
    ) as sma_50
FROM stock_prices
WHERE symbol = 'AAPL'
ORDER BY trading_date DESC
LIMIT 30;

📊 Performance Metrics Queries

Risk Analysis

SELECT 
    symbol,
    STDDEV(daily_return) as volatility,
    AVG(daily_return) as avg_return,
    MAX(daily_return) as max_return,
    MIN(daily_return) as min_return
FROM (
    SELECT 
        symbol,
        trading_date,
        ((close_price - LAG(close_price) OVER (PARTITION BY symbol ORDER BY trading_date)) 
         / LAG(close_price) OVER (PARTITION BY symbol ORDER BY trading_date)) * 100 as daily_return
    FROM stock_prices
    WHERE trading_date >= DATE_SUB(CURDATE(), INTERVAL 30 DAY)
) daily_returns
GROUP BY symbol
ORDER BY volatility DESC;

📋 Query Results

Select a query to see results...