#!/usr/bin/env python3 """ generar_dashboard.py ──────────────────── Genera un dashboard HTML interactivo comparando dos estrategias de opciones (IronCondor vs Vertical) a partir de dos archivos CSV. Uso: 1. Completá archivoIC y archivoVer con las rutas de tus CSVs 2. Ejecutá: python generar_dashboard.py El HTML se guarda en el mismo directorio donde se ejecuta el script. Formato esperado del nombre de archivo: P_L_IronCondor_XSP_HORA_1020_20250512_20260302_inte_CT_50.csv P_L_Vertical_XSP_HORA_1020_20250512_20260302_agre_CT_50.csv """ # ══════════════════════════════════════════════ # ARCHIVOS DE ENTRADA — completá las rutas aquí # ══════════════════════════════════════════════ archivoIC = "resultados/P&L_IronCondor_SPX_HORA_1020_20250512_20260305_agre_CT_250.csv" archivoVer = "resultados/P&L_Vertical_SPX_HORA_DINAMICA_20250512_20260305_ultr_CT_250.csv" # ══════════════════════════════════════════════ import sys import os import re import json import pandas as pd from datetime import datetime from pathlib import Path RISK_NAMES = { 'ultr': 'Ultra Agresivo', 'agre': 'Agresivo', 'inte': 'Intermedio', 'cons': 'Conservador', } MONTH_NAMES_ES = { '01': 'Ene', '02': 'Feb', '03': 'Mar', '04': 'Abr', '05': 'May', '06': 'Jun', '07': 'Jul', '08': 'Ago', '09': 'Sep', '10': 'Oct', '11': 'Nov', '12': 'Dic', } def parse_filename(path): name = Path(path).stem info = { 'estrategia': 'Estrategia', 'simbolo': 'SYM', 'hora': '--:--', 'hora_raw': '----', 'fecha_desde': '', 'fecha_hasta': '', 'riesgo': '', 'riesgo_full': '', 'ct': '0', } pat = re.compile( r'P[_\-&]L[_\-](?P.+?)[_\-](?P[A-Z0-9]{2,6})[_\-]HORA[_\-]' r'(?P[0-9A-Z]+)[_\-](?P\d{8})[_\-](?P\d{8})[_\-]' r'(?P[a-z]+)[_\-]CT[_\-](?P\d+)', re.IGNORECASE ) m = pat.search(name) if m: info['estrategia'] = m.group('strat').replace('_', ' ').replace('-', ' ') info['simbolo'] = m.group('sym').upper() hora_raw = m.group('hora').upper() info['hora_raw'] = hora_raw if hora_raw == 'DINAMICA': info['hora'] = 'Mejores Horarios' else: try: info['hora'] = f"{hora_raw[:2]}:{hora_raw[2:4]}" except Exception: info['hora'] = hora_raw d1 = m.group('d1') d2 = m.group('d2') info['fecha_desde'] = f"{d1[:4]}-{d1[4:6]}-{d1[6:8]}" info['fecha_hasta'] = f"{d2[:4]}-{d2[4:6]}-{d2[6:8]}" risk = m.group('risk').lower() info['riesgo'] = risk info['riesgo_full'] = RISK_NAMES.get(risk, risk.capitalize()) info['ct'] = m.group('ct') return info def fmt_date_es(date_str): try: d = datetime.strptime(date_str, '%Y-%m-%d') return f"{d.day} {MONTH_NAMES_ES[f'{d.month:02d}']} {d.year}" except Exception: return date_str def process_csvs(ic_path, vt_path): date_re = re.compile(r'^\d{4}-\d{2}-\d{2}$') ic_df = pd.read_csv(ic_path) vt_df = pd.read_csv(vt_path) ic_df = ic_df[ic_df['Day'].astype(str).str.match(date_re)].copy() vt_df = vt_df[vt_df['Day'].astype(str).str.match(date_re)].copy() ic_df['P/L'] = pd.to_numeric(ic_df['P/L'], errors='coerce').fillna(0) vt_df['P/L'] = pd.to_numeric(vt_df['P/L'], errors='coerce').fillna(0) ic_df['month'] = pd.to_datetime(ic_df['Day']).dt.to_period('M').astype(str) vt_df['month'] = pd.to_datetime(vt_df['Day']).dt.to_period('M').astype(str) ic_m_ser = ic_df.groupby('month')['P/L'].sum() vt_m_ser = vt_df.groupby('month')['P/L'].sum() months = sorted(set(ic_m_ser.index) | set(vt_m_ser.index)) month_labels = [ MONTH_NAMES_ES.get(m.split('-')[1], m.split('-')[1]) + ' ' + m.split('-')[0][-2:] for m in months ] ic_m = [round(float(ic_m_ser.get(m, 0)), 2) for m in months] vt_m = [round(float(vt_m_ser.get(m, 0)), 2) for m in months] ic_d = ic_df[['Day', 'P/L', 'Exit']].rename(columns={'P/L': 'ic_pl', 'Exit': 'ic_exit'}) vt_d = vt_df[['Day', 'P/L', 'Exit']].rename(columns={'P/L': 'vt_pl', 'Exit': 'vt_exit'}) daily = ( pd.merge(ic_d, vt_d, on='Day', how='outer') .sort_values('Day') .fillna({'ic_pl': 0, 'vt_pl': 0, 'ic_exit': 'NO_ENTRY', 'vt_exit': 'NO_ENTRY'}) ) daily['ic_cum'] = daily['ic_pl'].cumsum().round(2) daily['vt_cum'] = daily['vt_pl'].cumsum().round(2) daily['both_cum'] = (daily['ic_pl'] + daily['vt_pl']).cumsum().round(2) table = [] for _, r in daily.iterrows(): io = 0 if str(r['ic_exit']) == 'NO_ENTRY' else 1 vo = 0 if str(r['vt_exit']) == 'NO_ENTRY' else 1 table.append([ str(r['Day']), io, round(float(r['ic_pl']), 2) if io else None, vo, round(float(r['vt_pl']), 2) if vo else None, ]) all_days = sorted(daily['Day'].tolist()) return { 'month_labels': month_labels, 'ic_m': ic_m, 'vt_m': vt_m, 'days': list(daily['Day']), 'ic_cum': list(daily['ic_cum']), 'vt_cum': list(daily['vt_cum']), 'both_cum': list(daily['both_cum']), 'table': table, 'date_desde': fmt_date_es(all_days[0]), 'date_hasta': fmt_date_es(all_days[-1]), 'total_days': len(table), } def build_html(ic_info, vt_info, data): simbolo = ic_info['simbolo'] ic_hora = ic_info['hora'] vt_hora = vt_info['hora'] horas_iguales = ic_hora == vt_hora if horas_iguales: ic_name = f"{ic_info['estrategia']} {ic_info['riesgo_full']}" vt_name = f"{vt_info['estrategia']} {vt_info['riesgo_full']}" hora_str = f"Hora {ic_hora}" else: ic_name = f"{ic_info['estrategia']} {ic_info['riesgo_full']} ({ic_hora})" vt_name = f"{vt_info['estrategia']} {vt_info['riesgo_full']} ({vt_hora})" hora_str = f"IC {ic_hora} · VT {vt_hora}" ct = ic_info['ct'] titulo = f"Dashboard — {ic_info['estrategia']} {ic_info['riesgo_full']} vs {vt_info['estrategia']} {vt_info['riesgo_full']}" subtitulo = f"{simbolo} · {hora_str} · Credit Target ${ct} · {data['date_desde']} – {data['date_hasta']}" def js(v): return json.dumps(v) def js_table(rows): return '[\n ' + ',\n '.join(json.dumps(r) for r in rows) + '\n]' return f""" {titulo}

{titulo}

{subtitulo}

Modo oscuro

✅ Ambos

⚠️ Solo {vt_info['estrategia']}

⚠️ Solo IC

❌ Ninguno

P&L Total — {ic_name}

$0.00

Todos los días

P&L Total — {vt_name}

$0.00

Todos los días

P&L Total — Combinado

$0.00

Todos los días

P&L Mensual

Curva de Rendimiento (Acumulado)

Fecha	{ic_name}	{vt_name}	Estado

""" def main(): print("=" * 60) print(" Dashboard Generator — IC vs Vertical") print("=" * 60) ic_path = archivoIC vt_path = archivoVer if not ic_path or not vt_path: print("\n❌ Completá archivoIC y archivoVer al inicio del script.") sys.exit(1) for p in [ic_path, vt_path]: if not os.path.isfile(p): print(f"\n❌ Archivo no encontrado: {p}") sys.exit(1) print(f"\n📂 IC : {Path(ic_path).name}") print(f"📂 Vertical: {Path(vt_path).name}") ic_info = parse_filename(ic_path) vt_info = parse_filename(vt_path) print(f"\n🔍 Detectado:") print(f" Estrategia IC : {ic_info['estrategia']}") print(f" Estrategia VT : {vt_info['estrategia']} {vt_info['riesgo_full']}") print(f" Símbolo : {ic_info['simbolo']}") print(f" Hora : {ic_info['hora']}") print(f" CT : ${ic_info['ct']}") print("\n⚙️ Procesando datos...") data = process_csvs(ic_path, vt_path) print(f" Días totales : {data['total_days']}") print(f" Período : {data['date_desde']} → {data['date_hasta']}") print(f" Meses : {len(data['month_labels'])}") html = build_html(ic_info, vt_info, data) sym = ic_info['simbolo'] strat = f"{ic_info['estrategia'].replace(' ','')}{ic_info['riesgo_full'].replace(' ','')}_vs_{vt_info['estrategia'].replace(' ','')}{vt_info['riesgo_full'].replace(' ','')}" d1 = ic_info['fecha_desde'].replace('-','') d2 = ic_info['fecha_hasta'].replace('-','') out_name = f"dashboard_{sym}_{strat}_{d1}_{d2}.html" out_path = Path.cwd() / out_name with open(out_path, 'w', encoding='utf-8') as f: f.write(html) print(f"\n✅ Dashboard generado:") print(f" {out_path}") print(f"\n🌐 Abrí el archivo en tu navegador para verlo.") if __name__ == '__main__': main()