import json
from pathlib import Path
from collections import defaultdict

p = Path(r"C:\Users\Administrator\OneDrive\fx_macro_intraday\data\logs\trade_history_usdjpy.json")
trades = json.loads(p.read_text(encoding="utf-8"))

print(f"Total UJ trades in JSON: {len(trades)}")
print("=" * 70)
for x in trades:
    print(f"  ticket={x['ticket']}  pnl={x['net_pnl']:>10}  "
          f"dir={'LONG' if x['direction']==1 else 'SHORT'}  "
          f"closed={x['closed_at'][:16]}")
print("=" * 70)

# Bucket UJ by close month
monthly = defaultdict(float)
monthly_count = defaultdict(int)
for x in trades:
    m = x["closed_at"][:7]
    monthly[m] += x["net_pnl"]
    monthly_count[m] += 1

print("UJ by close month:")
for m in sorted(monthly.keys()):
    sign = "+" if monthly[m] >= 0 else ""
    print(f"  {m}:  {sign}{monthly[m]:.2f}  ({monthly_count[m]} trades)")

print()
print("Sum all UJ:", round(sum(x["net_pnl"] for x in trades), 2))