OmmAlpha Dashboard Diagnostic
PHP: 8.2.33

----------------------------------------
Nifty 500 stock count
PASS
Array
(
    [0] => Array
        (
            [COUNT(*)] => 501
        )

)

----------------------------------------
Price count
PASS
Array
(
    [0] => Array
        (
            [COUNT(*)] => 353672
        )

)

----------------------------------------
Latest price date
PASS
Array
(
    [0] => Array
        (
            [MAX(trade_date)] => 2026-09-29
        )

)

----------------------------------------
Latest VCP scan
PASS
Array
(
    [0] => Array
        (
            [MAX(scan_date)] => 2026-09-29
        )

)

----------------------------------------
VCP dashboard totals
PASS
Array
(
    [0] => Array
        (
            [SUM(watch_candidate = 1)] => 277
            [SUM(vcp_status = 'PRE_BREAKOUT')] => 32
            [SUM(vcp_status = 'DEVELOPING')] => 1821
            [SUM(vcp_status = 'BREAKOUT')] => 124
        )

)

----------------------------------------
Market regime
PASS
Array
(
    [0] => Array
        (
            [id] => 24
            [trade_date] => 2026-09-29
            [universe_count] => 501
            [priced_count] => 498
            [indicator_count] => 490
            [above_50_count] => 92
            [above_50_pct] => 18.78
            [above_200_count] => 203
            [above_200_pct] => 41.43
            [trend_template_count] => 63
            [trend_template_pct] => 12.86
            [near_52w_high_count] => 20
            [near_52w_low_count] => 159
            [median_rs_percentile] => 50.00
            [market_score] => 25.52
            [regime] => WEAK
            [created_at] => 2026-09-29 10:19:09
            [updated_at] => 2026-09-29 10:19:09
        )

)

----------------------------------------
v2 signals
PASS
Array
(
    [0] => Array
        (
            [COUNT(*)] => 7466
        )

)

----------------------------------------
v2 outcomes
PASS
Array
(
    [0] => Array
        (
            [COUNT(*)] => 7466
        )

)

----------------------------------------
Backtest runs
PASS
Array
(
    [0] => Array
        (
            [COUNT(*)] => 4
        )

)

========================================
COLUMN CHECK
========================================

STOCKS
OK      id
OK      symbol
OK      index_name
OK      active

STOCK_PRICES
OK      stock_id
OK      trade_date
OK      open
OK      high
OK      low
OK      close
OK      volume

VCP_SCANS
OK      stock_id
OK      scan_date
OK      vcp_status
OK      watch_candidate
OK      gate_json
OK      reason_json

MARKET_REGIME
OK      trade_date
MISSING above50_pct
MISSING above200_pct
OK      regime