import sys
import pandas as pd
sys.path.insert(0, r"C:\Users\paul_\OneDrive\fx_macro_intraday\src")

from features.spot_lag_v3 import get_model_ready_spot_lag_v3

df = get_model_ready_spot_lag_v3()

# From our earlier diagnostic: backtest fired EU LONG at 2026-03-03 09:45 with z=+2.789
# Does the current backtest agree?
print("=== 2026-03-03 09:45 — earlier diagnostic said z=+2.789 ===")
target = df[(df['datetime'] >= '2026-03-03 09:30:00') & 
            (df['datetime'] <= '2026-03-03 10:00:00')]
print(target[['datetime', 'lag_zscore_24h_v3']].to_string())

# Also: 2026-02-23 07:45 z=+2.975
print("\n=== 2026-02-23 07:45 — earlier diagnostic said z=+2.975 ===")
target = df[(df['datetime'] >= '2026-02-23 07:30:00') & 
            (df['datetime'] <= '2026-02-23 08:00:00')]
print(target[['datetime', 'lag_zscore_24h_v3']].to_string())

# And the very strongest signal we saw: 2025-09-05 15:30 z=-5.488
print("\n=== 2025-09-05 15:30 — earlier diagnostic said z=-5.488 ===")
target = df[(df['datetime'] >= '2025-09-05 15:00:00') & 
            (df['datetime'] <= '2025-09-05 16:00:00')]
print(target[['datetime', 'lag_zscore_24h_v3']].to_string())