{"text_format":"2","workbook":"xlsx","n_sheets":9,"sheets":["Portafolio","Plan de Trading","RESULTADOS_MC","Calculadora PS","HOLD","Largo Plazo","Spot X","Futuros","PLANTILLA"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":7,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Portafolio","index":0,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[9,9,9,11],[4,9,4,11],[5,9,5,11],[6,9,6,11],[7,9,7,11],[8,9,8,11],[10,9,10,11],[11,9,11,11],[12,9,12,11],[13,9,13,11],[14,9,14,11]]}
["CENTRO DE MANDO — GESTIÓN DE CAPITAL"]
["Capital Inicial (depósito)",2000,null,"Capital Actual (real)",{"$f":"SUM(E7:E14)","v":2000},null,"Retorno Total",{"$f":"(E2-B2)/B2","v":0}]
[null,null,null,"P&L ($)",{"$f":"E2-B2","v":0},null,"% Invertido",{"$f":"IF(E2=0,0,SUM(F7:F14)/E2)","v":0}]
[]
["ASIGNACIÓN DE CAPITAL POR ESTRATEGIA",{"$nulls":8},"📋 CÓMO AGREGAR UNA NUEVA ESTRATEGIA"]
["Estrategia","% Target","Capital Target","Capital Disponible","Capital Real","Capital Invertido","% Real","Desviación",null,"① Escribe el nombre en la columna A (filas 11-14)"]
["HOLD",0.4,{"$f":"B7*$B$2","v":800},{"$f":"HOLD!C4","v":800},{"$f":"HOLD!C3","v":800},{"$f":"HOLD!C5","v":0},{"$f":"IF($E$2=0,0,E7/$E$2)","v":0.4},{"$f":"G7-B7","v":0},null,"② Asigna el % Target en la columna B"]
["Largo Plazo",0.3,600,{"$f":"'Largo Plazo'!C3","v":600},{"$f":"'Largo Plazo'!C3","v":600},{"$f":"'Largo Plazo'!C4","v":0},0.3,0,null,"③ Clic derecho en pestaña → Mostrar → PLANTILLA"]
["Spot X",0.2,400,{"$f":"'Spot X'!C3","v":400},{"$f":"'Spot X'!C3","v":400},{"$f":"'Spot X'!C4","v":0},0.2,0,null,"④ Duplica PLANTILLA y renómbrala"]
["Futuros",0.1,200,{"$f":"Futuros!C3","v":200},{"$f":"Futuros!C3","v":200},{"$f":"Futuros!C4","v":0},0.1,0,null,"⑤ En la nueva hoja, vincula C1:"]
[null,0,0,null,null,null,0,0,null,"     =Portafolio!C[FILA]  (ej: =Portafolio!C11)"]
[null,null,0,null,null,null,0,0,null,"⑥ Aquí en Portafolio, vincula estas 3 celdas:"]
[null,null,0,null,null,null,0,0,null,"     D[FILA] = ='NuevaHoja'!C2  (Ganancias)"]
[null,null,0,null,null,null,0,0,null,"     E[FILA] = ='NuevaHoja'!C3  (Capital Real)"]
["TOTAL",{"$f":"SUM(B7:B14)","v":0.99999999999999989},2000,2000,2000,0,0.99999999999999989,{"$f":"IF(B15>1,\"⚠️ >\"&TEXT(B15,\"0%\")&\" — Excede!\",IF(B15<1,\"⚠️ \"&TEXT(B15,\"0%\")&\" — Falta \"&TEXT(1-B15,\"0%\"),\"✅ 100%\"))","v":"✅ 100%"},null,"     F[FILA] = ='NuevaHoja'!C4  (Cap. Invertido)"]
[]
["CARACTERÍSTICAS POR ESTRATEGIA"]
["Variable","HOLD","Largo Plazo","Spot X","Futuros"]
["Temporalidad","1 mes","1 semana","1 día","4h – 1h"]
["Tipo de análisis","Por activo","Fundamental + técnico","Técnico","Técnico"]
["Regla de salida","Nunca se vende","Patrón de venta (3–6 meses)","10 días por patrón","1–3 días"]
["Almacenamiento","Cold wallet","Cold wallet","Exchange","Exchange"]
[]
["REGLAS DE RIESGO POR TRADE"]
["Regla",null,"Input",null,"Spot X",null,"Futuros"]
["% Máx. riesgo por trade (del capital total)",null,1.4999999999999999E-2]
["Riesgo máx. por trade ($)",null,{"$f":"E2*C26","v":30},null,{"$f":"C27","v":30},null,{"$f":"C27","v":30}]
["Capital disponible para operar",null,null,null,{"$f":"D9","v":400},null,{"$f":"D10","v":200}]
["Máx. trades abiertos simultáneos",null,3]
["Riesgo total máx. simultáneo ($)",null,{"$f":"C27*C29","v":90},null,{"$f":"C30","v":90},null,{"$f":"C30","v":90}]
["Máx. pérdidas consecutivas antes de STOP",null,5]
["Límite pérdida semanal ($)",null,{"$f":"C27*C31","v":150}]
["    como % del capital total",null,{"$f":"C32/E2","v":7.4999999999999997E-2}]
[]
["POSITION SIZING MÁXIMO POR TRADE"]
["Apalancamiento disponible",null,null,null,1,null,10]
["Distancia SL asumida (%)",null,null,null,0.03,null,1.4999999999999999E-2]
["⭐ Position Size Máx. (nocional $)",null,null,null,{"$f":"C27/E37","v":1000},null,{"$f":"C27/G37","v":2000}]
["    Margen requerido",null,null,null,{"$f":"E38/E36","v":1000},null,{"$f":"G38/G36","v":200}]
["    ¿Cabe en capital disponible?",null,null,null,{"$f":"IF(E39<=E28,\"✅ OK\",\"❌ NO\")","v":"❌ NO"},null,{"$f":"IF(G39<=G28,\"✅ OK\",\"❌ NO\")","v":"✅ OK"}]
["    Detalle",null,null,null,{"$f":"IF(E39<=E28,\"Margen $\"&FIXED(E39,0)&\" ≤ Disp. $\"&FIXED(E28,0),\"Necesitas $\"&FIXED(E39,0)&\" | Tienes $\"&FIXED(E28,0))","v":"Necesitas $1.000 | Tienes $400"},null,{"$f":"IF(G39<=G28,\"Margen $\"&FIXED(G39,0)&\" ≤ Disp. $\"&FIXED(G28,0),\"Necesitas $\"&FIXED(G39,0)&\" | Tienes $\"&FIXED(G28,0))","v":"Margen $200 ≤ Disp. $200"}]
["ALERTAS DE REBALANCEO"]
["Umbral de rebalanceo",null,0.05]
[null,"% Real","% Target","Desviación","Acción Sugerida","Monto a Mover ($)"]
["HOLD",{"$f":"G7","v":0.4},{"$f":"B7","v":0.4},{"$f":"H7","v":0},{"$f":"IF(ABS(H7)>$C$43,IF(H7>0,\"⚠️ Reducir\",\"⚠️ Aumentar\"),\"✅ OK\")","v":"✅ OK"},{"$f":"IF(ABS(H7)>$C$43,ABS(H7)*E2,0)","v":0}]
["Largo Plazo",0.3,0.3,0,{"$f":"IF(ABS(H8)>$C$43,IF(H8>0,\"⚠️ Reducir\",\"⚠️ Aumentar\"),\"✅ OK\")","v":"✅ OK"},{"$f":"IF(ABS(H8)>$C$43,ABS(H8)*E2,0)","v":0}]
["Spot X",0.2,0.2,0,{"$f":"IF(ABS(H9)>$C$43,IF(H9>0,\"⚠️ Reducir\",\"⚠️ Aumentar\"),\"✅ OK\")","v":"✅ OK"},{"$f":"IF(ABS(H9)>$C$43,ABS(H9)*E2,0)","v":0}]
["Futuros",0.1,0.1,0,{"$f":"IF(ABS(H10)>$C$43,IF(H10>0,\"⚠️ Reducir\",\"⚠️ Aumentar\"),\"✅ OK\")","v":"✅ OK"},{"$f":"IF(ABS(H10)>$C$43,ABS(H10)*E2,0)","v":0}]
[{"$f":"IF(A11=\"\",\"\",A11)","v":""},0,0,0,{"$f":"IF(A11=\"\",\"\",IF(ABS(H11)>$C$43,IF(H11>0,\"⚠️ Reducir\",\"⚠️ Aumentar\"),\"✅ OK\"))","v":""},{"$f":"IF(A11=\"\",0,IF(ABS(H11)>$C$43,ABS(H11)*E2,0))","v":0}]
[{"$f":"IF(A12=\"\",\"\",A12)","v":""},0,0,0,{"$f":"IF(A12=\"\",\"\",IF(ABS(H12)>$C$43,IF(H12>0,\"⚠️ Reducir\",\"⚠️ Aumentar\"),\"✅ OK\"))","v":""},{"$f":"IF(A12=\"\",0,IF(ABS(H12)>$C$43,ABS(H12)*E2,0))","v":0}]
[{"$f":"IF(A13=\"\",\"\",A13)","v":""},0,0,0,{"$f":"IF(A13=\"\",\"\",IF(ABS(H13)>$C$43,IF(H13>0,\"⚠️ Reducir\",\"⚠️ Aumentar\"),\"✅ OK\"))","v":""},{"$f":"IF(A13=\"\",0,IF(ABS(H13)>$C$43,ABS(H13)*E2,0))","v":0}]
[{"$f":"IF(A14=\"\",\"\",A14)","v":""},0,0,0,{"$f":"IF(A14=\"\",\"\",IF(ABS(H14)>$C$43,IF(H14>0,\"⚠️ Reducir\",\"⚠️ Aumentar\"),\"✅ OK\"))","v":""},{"$f":"IF(A14=\"\",0,IF(ABS(H14)>$C$43,ABS(H14)*E2,0))","v":0}]

{"sheet":"Plan de Trading","index":1,"n_rows":342,"n_cols":22,"rows_kept":342,"cut":false,"hidden":false,"merged":[]}
["FECHA","DIA","DISPONIBLE","CAPITAL FUTUROS","CAPITAL SPOT","ESTADO SPOT","RESULTADO FUT.","RESULTADO SPOT","RIESGO $ FUT.","RIESGO $ SPOT","GAN. FUTUROS","GAN. SPOT","GAN. TOTAL","GAN. TOTAL %","EQUITY PEAK","DRAWDOWN %","RACHA FUT.",null,"PANEL DE CONTROL",null,null,1209]
["2026-02-01",1,{"$f":"T5","v":600},{"$f":"C2*($T$3/$T$5)","v":200},{"$f":"C2*($T$4/$T$5)","v":400},{"$f":"IF(MOD(B2-1,$T$10)=0,\"APERTURA\",\"—\")","v":"APERTURA"},{"$f":"IF(RAND()+0*$V$1<=$T$6,\"WIN\",\"LOSS\")","v":"LOSS"},{"$f":"IF(F2=\"CIERRE\",IF(RAND()+0*$V$1<=$T$6,\"WIN\",\"LOSS\"),\"—\")","v":"—"},{"$f":"D2*$T$8","v":3},{"$f":"IF(F2=\"APERTURA\",E2*$T$9,0)","v":6},{"$f":"IF(G2=\"WIN\",I2*$T$7,-I2)","v":-3},{"$f":"IF(F2=\"CIERRE\",IF(H2=\"WIN\",J2*$T$7,-J2),0)","v":0},{"$f":"K2+L2","v":-3},{"$f":"(C2/C$2-1)","v":0},{"$f":"MAX(C$2:C2)","v":600},{"$f":"C2/O2-1","v":0},{"$f":"IF(G2=\"LOSS\",-1,1)","v":-1},null,"Parámetro","Valor","Nota"]
["2026-02-02",2,{"$f":"C2+M2","v":597},199,398,{"$f":"IF(MOD(B3-1,$T$10)=0,\"APERTURA\",IF(MOD(B3,$T$10)=0,\"CIERRE\",IF(OR(F2=\"APERTURA\",F2=\"ABIERTO\"),\"ABIERTO\",\"—\")))","v":"ABIERTO"},"LOSS","—",{"$f":"D3*$T$8","v":2.9849999999999999},{"$f":"IF(F3=\"APERTURA\",E3*$T$9,IF(OR(F3=\"ABIERTO\",F3=\"CIERRE\"),J2,0))","v":6},{"$f":"IF(G3=\"WIN\",I3*$T$7,-I3)","v":-2.9849999999999999},{"$f":"IF(F3=\"CIERRE\",IF(H3=\"WIN\",J3*$T$7,-J3),0)","v":0},{"$f":"K3+L3","v":-2.9849999999999999},{"$f":"(C3/C$2-1)","v":-5.0000000000000044E-3},{"$f":"MAX(C$2:C3)","v":600},{"$f":"C3/O3-1","v":-5.0000000000000044E-3},{"$f":"IF(G3=G2,IF(G3=\"WIN\",Q2+1,Q2-1),IF(G3=\"WIN\",1,-1))","v":-2},null,"Capital Inicial Futuros",{"$f":"Portafolio!C10","v":200},"← Portafolio: Capital Futuros"]
["2026-02-03",3,{"$f":"C3+M3","v":594.01499999999999},198.005,396.01,"ABIERTO","LOSS","—",{"$f":"D4*$T$8","v":2.970075},6,{"$f":"IF(G4=\"WIN\",I4*$T$7,-I4)","v":-2.970075},{"$f":"IF(F4=\"CIERRE\",IF(H4=\"WIN\",J4*$T$7,-J4),0)","v":0},{"$f":"K4+L4","v":-2.970075},{"$f":"(C4/C$2-1)","v":-9.9750000000000671E-3},{"$f":"MAX(C$2:C4)","v":600},{"$f":"C4/O4-1","v":-9.9750000000000671E-3},{"$f":"IF(G4=G3,IF(G4=\"WIN\",Q3+1,Q3-1),IF(G4=\"WIN\",1,-1))","v":-3},null,"Capital Inicial Spot",{"$f":"Portafolio!C9","v":400},"← Portafolio: Capital Spot X"]
["2026-02-04",4,591.04492500000003,197.01497499999999,394.02994999999999,"ABIERTO","LOSS","—",2.9552246249999996,6,-2.9552246249999996,0,-2.9552246249999996,-1.4925124999999984E-2,{"$f":"MAX(C$2:C5)","v":600},-1.4925124999999984E-2,{"$f":"IF(G5=G4,IF(G5=\"WIN\",Q4+1,Q4-1),IF(G5=\"WIN\",1,-1))","v":-4},null,"Capital Inicial Total",{"$f":"T3+T4","v":600},"= Futuros + Spot"]
["2026-02-05",5,588.08970037500001,196.02990012499998,392.05980024999997,"ABIERTO","WIN","—",2.9404485018749997,6,7.3511212546874996,0,7.3511212546874996,-1.9850499374999941E-2,{"$f":"MAX(C$2:C6)","v":600},-1.9850499374999941E-2,1,null,"Win Rate",0.4,"Probabilidad de WIN"]
["2026-02-06",6,595.44082162968755,198.48027387656251,396.96054775312501,"CIERRE","LOSS","WIN",2.9772041081484373,6,-2.9772041081484373,15,12.022795891851562,-7.5986306171874629E-3,{"$f":"MAX(C$2:C7)","v":600},-7.5986306171874629E-3,-1,null,"R:R (multiplicador)",2.5,"R:R ratio — ganancia por $1 arriesgado"]
["2026-02-07",7,607.46361752153916,202.4878725071797,404.9757450143594,"APERTURA","LOSS","—",3.0373180876076953,6.0746361752153906,-3.0373180876076953,0,-3.0373180876076953,1.2439362535898502E-2,{"$f":"MAX(C$2:C8)","v":607.46361752153916},0,-2,null,"% Riesgo Futuros",1.4999999999999999E-2,"INPUT — simula y ajusta"]
["2026-02-08",8,604.42629943393149,201.47543314464383,402.95086628928766,"ABIERTO","WIN","—",3.0221314971696573,6.0746361752153906,7.5553287429241429,0,7.5553287429241429,7.3771657232191146E-3,{"$f":"MAX(C$2:C9)","v":607.46361752153916},-5.0000000000000044E-3,1,null,"% Riesgo Spot",1.4999999999999999E-2,"INPUT — simula y ajusta"]
["2026-02-09",9,611.98162817685568,203.99387605895188,407.98775211790377,"ABIERTO","LOSS","—",3.0599081408842781,6.0746361752153906,-3.0599081408842781,0,-3.0599081408842781,1.9969380294759365E-2,{"$f":"MAX(C$2:C10)","v":611.98162817685568},0,-1,null,"Frecuencia Spot (cada N días)",6,"Patrón actual: cada 6"]
["2026-02-10",10,608.92172003597136,202.9739066786571,405.9478133573142,"ABIERTO","WIN","—",3.0446086001798562,6.0746361752153906,7.6115215004496406,0,7.6115215004496406,1.4869533393285561E-2,{"$f":"MAX(C$2:C11)","v":611.98162817685568},-5.0000000000001155E-3,1]
["2026-02-11",11,616.53324153642097,205.51108051214032,411.02216102428065,"ABIERTO","WIN","—",3.082666207682105,6.0746361752153906,7.7066655192052629,0,7.7066655192052629,2.7555402560701658E-2,{"$f":"MAX(C$2:C12)","v":616.53324153642097},0,2,null,"MÉTRICAS DE RENDIMIENTO"]
["2026-02-12",12,624.23990705562619,208.07996901854204,416.15993803708409,"CIERRE","WIN","WIN",3.1211995352781305,6.0746361752153906,7.8029988381953261,15.186590438038476,22.989589276233801,4.0399845092710329E-2,{"$f":"MAX(C$2:C13)","v":624.23990705562619},0,3,null,"Métrica","Futuros","Spot"]
["2026-02-13",13,647.22949633185999,215.74316544395333,431.48633088790666,"APERTURA","LOSS","—",3.2361474816592999,6.4722949633185998,-3.2361474816592999,0,-3.2361474816592999,7.8715827219766554E-2,{"$f":"MAX(C$2:C14)","v":647.22949633185999},0,-1,null,"Equity Final",{"$f":"C335","v":1649.4925708799994}]
["2026-02-14",14,643.99334885020073,214.66444961673358,429.32889923346715,"ABIERTO","LOSS","—",3.2199667442510034,6.4722949633185998,-3.2199667442510034,0,-3.2199667442510034,7.332224808366794E-2,{"$f":"MAX(C$2:C15)","v":647.22949633185999},-4.9999999999998934E-3,-2,null,"Retorno Total %",{"$f":"N335","v":1.749154284799999}]
["2026-02-15",15,640.77338210594974,213.59112736864989,427.18225473729979,"ABIERTO","WIN","—",3.2038669105297481,6.4722949633185998,8.0096672763243699,0,8.0096672763243699,6.7955636843249456E-2,{"$f":"MAX(C$2:C16)","v":647.22949633185999},-9.9749999999999561E-3,1,null,"Win Rate Real",{"$f":"COUNTIF(G2:G335,\"WIN\")/COUNTA(G2:G335)","v":0.39520958083832336},{"$f":"COUNTIF(H2:H335,\"WIN\")/(COUNTIF(H2:H335,\"WIN\")+COUNTIF(H2:H335,\"LOSS\"))","v":0.49090909090909091}]
["2026-02-16",16,648.78304938227416,216.26101646075804,432.52203292151609,"ABIERTO","LOSS","—",3.2439152469113703,6.4722949633185998,-3.2439152469113703,0,-3.2439152469113703,8.1305082303790188E-2,{"$f":"MAX(C$2:C17)","v":648.78304938227416},0,-1,null,"Expectativa $ (combinada)",{"$f":"AVERAGE(M2:M335)","v":3.1175003234299368},{"$f":"IF(T17>0,\"✅ Expectativa positiva: ganas $\"&FIXED(T17,2)&\" por trade en promedio\",\"❌ Expectativa negativa\")","v":"✅ Expectativa positiva: ganas $3,12 por trade en promedio"}]
["2026-02-17",17,645.53913413536281,215.17971137845427,430.35942275690854,"ABIERTO","LOSS","—",3.2276956706768138,6.4722949633185998,-3.2276956706768138,0,-3.2276956706768138,7.5898556892271429E-2,{"$f":"MAX(C$2:C18)","v":648.78304938227416},-5.0000000000000044E-3,-2,null,"Profit Factor",{"$f":"SUMIF(M2:M335,\">0\")/ABS(SUMIF(M2:M335,\"<0\"))","v":1.7971751797532149},{"$f":"IF(T18>=1.5,\"✅ Saludable (>1.5)\",IF(T18>=1,\"⚠️ Marginal (1-1.5)\",\"❌ Perdiendo (<1)\"))","v":"✅ Saludable (>1.5)"}]
["2026-02-18",18,642.31143846468603,214.103812821562,428.207625643124,"CIERRE","LOSS","LOSS",3.2115571923234301,6.4722949633185998,-3.2115571923234301,-6.4722949633185998,-9.6838521556420289,7.0519064107809948E-2,{"$f":"MAX(C$2:C19)","v":648.78304938227416},-9.9749999999999561E-3,-3,null,"Ganancia Promedio (WIN)",{"$f":"AVERAGEIF(G2:G335,\"WIN\",K2:K335)","v":14.169511051774263},{"$f":"IFERROR(AVERAGEIF(H2:H335,\"WIN\",L2:L335),0)","v":26.681115490278696}]
["2026-02-19",19,632.62758630904398,210.87586210301464,421.75172420602928,"APERTURA","WIN","—",3.1631379315452195,6.326275863090439,7.9078448288630483,0,7.9078448288630483,5.4379310515073387E-2,{"$f":"MAX(C$2:C20)","v":648.78304938227416},-2.4901179352038061E-2,1,null,"Pérdida Promedio (LOSS)",{"$f":"AVERAGEIF(G2:G335,\"LOSS\",K2:K335)","v":-5.9492085451944332},{"$f":"IFERROR(AVERAGEIF(H2:H335,\"LOSS\",L2:L335),0)","v":-12.420726532744791}]
["2026-02-20",20,640.53543113790704,213.51181037930235,427.02362075860469,"ABIERTO","WIN","—",3.202677155689535,6.326275863090439,8.0066928892238369,0,8.0066928892238369,6.7559051896511679E-2,{"$f":"MAX(C$2:C21)","v":648.78304938227416},-1.2712444093938569E-2,2,null,"R:R Real",{"$f":"ABS(T19/T20)","v":2.3817472432059739},{"$f":"IFERROR(ABS(U19/U20),0)","v":2.1481123040539702}]
["2026-02-21",21,648.54212402713085,216.1807080090436,432.3614160180872,"ABIERTO","WIN","—",3.2427106201356537,6.326275863090439,8.1067765503391342,0,8.1067765503391342,8.0903540045218048E-2,{"$f":"MAX(C$2:C22)","v":648.78304938227416},-3.7134964511276181E-4,3,null,"Max Drawdown %",{"$f":"MIN(P2:P335)","v":-6.6758298801171123E-2},{"$f":"IF(T22>-0.2,\"✅ Controlado (<20%)\",IF(T22>-0.5,\"⚠️ Significativo (20-50%)\",\"❌ Severo (>50%)\"))","v":"✅ Controlado (<20%)"}]
["2026-02-22",22,656.64890057746993,218.88296685915662,437.76593371831325,"ABIERTO","LOSS","—",3.2832445028873494,6.326275863090439,-3.2832445028873494,0,-3.2832445028873494,9.4414834295783123E-2,{"$f":"MAX(C$2:C23)","v":656.64890057746993},0,-1,null,"Racha Máx Ganancias (Futuros)",{"$f":"MAX(Q2:Q335)","v":6}]
["2026-02-23",23,653.3656560745826,217.78855202486085,435.5771040497217,"ABIERTO","LOSS","—",3.2668282803729127,6.326275863090439,-3.2668282803729127,0,-3.2668282803729127,8.8942760124304243E-2,{"$f":"MAX(C$2:C24)","v":656.64890057746993},-5.0000000000000044E-3,-2,null,"Racha Máx Pérdidas (Futuros)",{"$f":"ABS(MIN(Q2:Q335))","v":8},{"$f":"IF(T24<=8,\"✅ Normal para WR 40%\",\"⚠️ Prepárate mentalmente\")","v":"✅ Normal para WR 40%"}]
["2026-02-24",24,650.09882779420968,216.69960926473655,433.3992185294731,"CIERRE","WIN","WIN",3.2504941389710482,6.326275863090439,8.1262353474276203,15.815689657726097,23.941925005153717,8.349804632368274E-2,{"$f":"MAX(C$2:C25)","v":656.64890057746993},-9.9749999999999561E-3,1,null,"Total Trades",{"$f":"COUNTA(G2:G335)","v":334},{"$f":"COUNTIF(H2:H335,\"WIN\")+COUNTIF(H2:H335,\"LOSS\")","v":55}]
["2026-02-25",25,674.04075279936342,224.68025093312113,449.36050186624226,"APERTURA","WIN","—",3.370203763996817,6.740407527993634,8.425509409992042,0,8.425509409992042,0.12340125466560559,{"$f":"MAX(C$2:C26)","v":674.04075279936342},0,2]
["2026-02-26",26,682.46626220935548,227.48875406978516,454.97750813957032,"ABIERTO","LOSS","—",3.4123313110467772,6.740407527993634,-3.4123313110467772,0,-3.4123313110467772,0.13744377034892574,{"$f":"MAX(C$2:C27)","v":682.46626220935548},0,-1,null,"MÉTRICAS AVANZADAS"]
["2026-02-27",27,679.05393089830875,226.35131029943625,452.7026205988725,"ABIERTO","WIN","—",3.3952696544915435,6.740407527993634,8.4881741362288583,0,8.4881741362288583,0.13175655149718124,{"$f":"MAX(C$2:C28)","v":682.46626220935548},-4.9999999999998934E-3,1,null,"Métrica","Valor","Interpretación"]
["2026-02-28",28,687.5421050345376,229.18070167817919,458.36140335635838,"ABIERTO","LOSS","—",3.4377105251726876,6.740407527993634,-3.4377105251726876,0,-3.4377105251726876,0.14590350839089594,{"$f":"MAX(C$2:C29)","v":687.5421050345376},0,-1,null,"Retorno Diario Promedio (%)",{"$f":"AVERAGE(M2:M335)/C$2","v":5.1958338723832277E-3}]
["2026-03-01",29,684.10439450936497,228.0347981697883,456.06959633957661,"ABIERTO","WIN","—",3.4205219725468243,6.740407527993634,8.5513049313670599,0,8.5513049313670599,0.14017399084894167,{"$f":"MAX(C$2:C30)","v":687.5421050345376},-4.9999999999998934E-3,1,null,"Volatilidad Diaria (Desv.Est.)",{"$f":"STDEV(M2:M335)/C$2","v":2.1909502240270592E-2}]
["2026-03-02",30,{"$f":"C30+M30","v":692.65569944073206},230.88523314691068,461.77046629382136,"CIERRE","LOSS","LOSS",3.4632784972036599,6.740407527993634,-3.4632784972036599,-6.740407527993634,-10.203686025197294,0.15442616573455337,{"$f":"MAX(C$2:C31)","v":692.65569944073206},0,-1,null,"Downside Deviation (solo pérdidas)",{"$f":"SQRT(SUMPRODUCT((IF(M2:M335<0,M2:M335/C$2,0))^2)/COUNT(M2:M335))","v":1.0170593319224763E-2}]
["2026-03-03",31,{"$f":"C31+M31","v":682.45201341553479},227.48400447184491,454.96800894368982,"APERTURA","LOSS","—",3.4122600670776735,6.824520134155347,-3.4122600670776735,0,-3.4122600670776735,0.13742002235922457,{"$f":"MAX(C$2:C32)","v":692.65569944073206},-1.4731252530566064E-2,-2]
["2026-03-04",32,679.03975334845711,226.3465844494857,452.69316889897141,"ABIERTO","LOSS","—",3.3951987667422854,6.824520134155347,-3.3951987667422854,0,-3.3951987667422854,0.13173292224742861,{"$f":"MAX(C$2:C33)","v":692.65569944073206},-1.9657596267913191E-2,-3,null,"⭐ Ratio de Sharpe (anualizado)",{"$f":"IF(T30=0,0,(T29/T30)*SQRT(365))","v":4.530740391208286},{"$f":"IF(T33>=2,\"✅ Excelente (>2)\",IF(T33>=1,\"✅ Bueno (1-2)\",IF(T33>=0,\"⚠️ Bajo (0-1)\",\"❌ Negativo\")))","v":"✅ Excelente (>2)"}]
["2026-03-05",33,675.64455458171483,225.21485152723827,450.42970305447653,"ABIERTO","LOSS","—",3.3782227729085741,6.824520134155347,-3.3782227729085741,0,-3.3782227729085741,0.12607425763619129,{"$f":"MAX(C$2:C34)","v":692.65569944073206},-2.45593082865736E-2,-4,null,"    Sharpe = Retorno / Volatilidad × √365"]
["2026-03-06",34,672.26633180880629,224.08877726960208,448.17755453920415,{"$f":"IF(MOD(B35-1,$T$10)=0,\"APERTURA\",IF(MOD(B35,$T$10)=0,\"CIERRE\",IF(OR(F34=\"APERTURA\",F34=\"ABIERTO\"),\"ABIERTO\",\"—\")))","v":"ABIERTO"},"WIN","—",3.3613316590440312,{"$f":"IF(F35=\"APERTURA\",E35*$T$9,IF(OR(F35=\"ABIERTO\",F35=\"CIERRE\"),J34,0))","v":6.824520134155347},8.4033291476100782,0,8.4033291476100782,0.1204438863480104,{"$f":"MAX(C$2:C35)","v":692.65569944073206},-2.9436511745140725E-2,1]
["2026-03-07",35,680.66966095641635,226.88988698547212,453.77977397094423,"ABIERTO","LOSS","—",3.4033483047820816,6.824520134155347,-3.4033483047820816,0,-3.4033483047820816,0.13444943492736061,{"$f":"MAX(C$2:C36)","v":692.65569944073206},-1.7304468141954965E-2,-1,null,"⭐ Ratio de Sortino (anualizado)",{"$f":"IF(T31=0,0,(T29/T31)*SQRT(365))","v":9.7601254553779384},{"$f":"IF(T36>=2,\"✅ Excelente (>2)\",IF(T36>=1,\"✅ Bueno (1-2)\",IF(T36>=0,\"⚠️ Bajo (0-1)\",\"❌ Negativo\")))","v":"✅ Excelente (>2)"}]
["2026-03-08",36,677.26631265163428,225.75543755054474,451.51087510108948,"CIERRE","WIN","WIN",3.386331563258171,6.824520134155347,8.4658289081454274,17.061300335388367,25.527129243533793,0.12877718775272373,{"$f":"MAX(C$2:C37)","v":692.65569944073206},-2.2217945801245254E-2,1,null,"    Sortino = Retorno / Downside Dev × √365"]
["2026-03-09",37,702.79344189516803,234.26448063172268,468.52896126344535,"APERTURA","LOSS","—",3.5139672094758398,7.0279344189516797,-3.5139672094758398,0,-3.5139672094758398,0.17132240315861336,{"$f":"MAX(C$2:C38)","v":702.79344189516803},0,-1,null,"    Sortino > Sharpe = las ganancias son más volátiles que las pérdidas (✅ bueno)"]
["2026-03-10",38,699.27947468569221,233.09315822856405,466.1863164571281,"ABIERTO","LOSS","—",3.4963973734284606,7.0279344189516797,-3.4963973734284606,0,-3.4963973734284606,0.16546579114282034,{"$f":"MAX(C$2:C39)","v":702.79344189516803},-5.0000000000000044E-3,-2]
["2026-03-11",39,695.7830773122638,231.92769243742126,463.85538487484251,"ABIERTO","WIN","—",3.4789153865613187,7.0279344189516797,8.6972884664032968,0,8.6972884664032968,0.15963846218710631,{"$f":"MAX(C$2:C40)","v":702.79344189516803},-9.9749999999998451E-3,1,null,"💡 SHARPE vs SORTINO:"]
["2026-03-12",40,704.48036577866708,234.82678859288902,469.65357718577803,"ABIERTO","LOSS","—",3.5224018288933352,7.0279344189516797,-3.5224018288933352,0,-3.5224018288933352,0.17413394296444507,{"$f":"MAX(C$2:C41)","v":704.48036577866708},0,-1,null,"Sharpe castiga TODA la volatilidad (ganancias grandes también bajan el ratio)."]
["2026-03-13",41,700.95796394977378,233.65265464992459,467.30530929984917,"ABIERTO","WIN","—",3.5047898197488685,7.0279344189516797,8.7619745493721712,0,8.7619745493721712,0.16826327324962298,{"$f":"MAX(C$2:C42)","v":704.48036577866708},-4.9999999999998934E-3,1,null,"Sortino solo castiga la volatilidad NEGATIVA. Más justo para traders."]
["2026-03-14",42,709.719938499146,236.57331283304865,473.14662566609729,"CIERRE","LOSS","WIN",3.5485996924957295,7.0279344189516797,-3.5485996924957295,17.569836047379198,14.021236354883468,0.18286656416524338,{"$f":"MAX(C$2:C43)","v":709.719938499146},0,-1,null,"Si Sortino > Sharpe, tus ganancias son más \"explosivas\" que tus pérdidas. ✅"]
["2026-03-15",43,723.74117485402951,241.24705828467648,482.49411656935297,"APERTURA","LOSS","—",3.6187058742701472,7.2374117485402945,-3.6187058742701472,0,-3.6187058742701472,0.20623529142338248,{"$f":"MAX(C$2:C44)","v":723.74117485402951},0,-2]
["2026-03-16",44,720.12246897975933,240.0408229932531,480.0816459865062,"ABIERTO","WIN","—",3.6006123448987966,7.2374117485402945,9.0015308622469909,0,9.0015308622469909,0.20020411496626545,{"$f":"MAX(C$2:C45)","v":723.74117485402951},-5.0000000000000044E-3,1,null,"PROBABILIDAD DE RUINA — \"La Ruina del Jugador\""]
["2026-03-17",45,729.12399984200636,243.04133328066877,486.08266656133753,"ABIERTO","WIN","—",3.6456199992100315,7.2374117485402945,9.1140499980250791,0,9.1140499980250791,0.21520666640334385,{"$f":"MAX(C$2:C46)","v":729.12399984200636},0,2,null,"Si WR < 50% y ganancias = pérdidas (R:R 1:1), la ruina es MATEMÁTICAMENTE SEGURA."]
["2026-03-18",46,738.23804984003141,246.07934994667713,492.15869989335425,"ABIERTO","WIN","—",3.6911902492001567,7.2374117485402945,9.2279756230003915,0,9.2279756230003915,0.23039674973338564,{"$f":"MAX(C$2:C47)","v":738.23804984003141},0,3]
["2026-03-19",47,747.46602546303177,249.15534182101058,498.31068364202116,"ABIERTO","WIN","—",3.7373301273151585,7.2374117485402945,9.3433253182878957,0,9.3433253182878957,0.24577670910505289,{"$f":"MAX(C$2:C48)","v":747.46602546303177},0,4,null,"ESCENARIO A: Mundo SIN R:R (apuestas 1:1)"]
["2026-03-20",48,756.80935078131961,252.26978359377318,504.53956718754637,"CIERRE","WIN","LOSS",3.7840467539065976,7.2374117485402945,9.460116884766494,-7.2374117485402945,2.2227051362261996,0.26134891796886595,{"$f":"MAX(C$2:C49)","v":756.80935078131961},0,5,null,"Win Rate",{"$f":"T6","v":0.4},"Pierdes 6 de cada 10 trades."]
["2026-03-21",49,759.03205591754579,253.0106853058486,506.02137061169719,"APERTURA","WIN","—",3.7951602795877286,7.5903205591754572,9.4879006989693213,0,9.4879006989693213,0.26505342652924302,{"$f":"MAX(C$2:C50)","v":759.03205591754579},0,6,null,"Ratio Pérdida/Ganancia (sin R:R)",{"$f":"(1-T6)/T6","v":1.4999999999999998},{"$f":"IF(T50>=1,\"❌ ≥1 → sin ventaja estadística\",\"✅ <1 → tienes edge\")","v":"❌ ≥1 → sin ventaja estadística"}]
["2026-03-22",50,768.51995661651506,256.17331887217165,512.3466377443433,"ABIERTO","LOSS","—",3.8425997830825747,7.5903205591754572,-3.8425997830825747,0,-3.8425997830825747,0.28086659436085837,{"$f":"MAX(C$2:C51)","v":768.51995661651506},0,-1,null,"⭐ P(Ruina) sin R:R",{"$f":"IF(T50>=1,1,POWER(T50,1/T8))","v":1},"💣 100% = RUINA GARANTIZADA si no usas R:R favorable."]
["2026-03-23",51,764.67735683343244,254.8924522778108,509.78490455562161,"ABIERTO","WIN","—",3.823386784167162,7.5903205591754572,9.5584669604179044,0,9.5584669604179044,0.27446226138905416,{"$f":"MAX(C$2:C52)","v":768.51995661651506},-5.0000000000000044E-3,1]
["2026-03-24",52,774.23582379385039,258.07860793128344,516.15721586256689,"ABIERTO","WIN","—",3.8711791189692515,7.5903205591754572,9.6779477974231281,0,9.6779477974231281,0.29039303965641738,{"$f":"MAX(C$2:C53)","v":774.23582379385039},0,2,null,"ESCENARIO B: Mundo CON R:R de 1:2.5"]
["2026-03-25",53,783.91377159127353,261.30459053042449,522.60918106084898,"ABIERTO","WIN","—",3.9195688579563672,7.5903205591754572,9.7989221448909181,0,9.7989221448909181,0.30652295265212248,{"$f":"MAX(C$2:C54)","v":783.91377159127353},0,3,null,"Win Rate",{"$f":"T6","v":0.4}]
["2026-03-26",54,793.7126937361644,264.57089791205476,529.14179582410952,"CIERRE","LOSS","WIN",3.9685634686808213,7.5903205591754572,-3.9685634686808213,18.975801397938643,15.007237929257821,0.32285448956027407,{"$f":"MAX(C$2:C55)","v":793.7126937361644},0,-1,null,"R:R",{"$f":"T7","v":2.5},{"$f":"IF(T55<0.0001,\"✅ Prácticamente imposible\",IF(T55<0.01,\"✅ Muy baja (<1%)\",IF(T55<0.05,\"⚠️ Baja pero real\",\"❌ PELIGRO\")))","v":"❌ PELIGRO"}]
["2026-03-27",55,808.71993166542222,269.57331055514072,539.14662111028144,"APERTURA","LOSS","—",4.0435996583271105,8.0871993166542211,-4.0435996583271105,0,-4.0435996583271105,0.34786655277570366,{"$f":"MAX(C$2:C56)","v":808.71993166542222},0,-2,null,"Ratio Pérdida/Ganancia (con R:R)",{"$f":"(1-T6)/(T6*T7)","v":0.6},{"$f":"IF(T56>=1,\"❌ ≥1 → sin ventaja\",\"✅ \"&FIXED(T56,2)&\" < 1 → TIENES EDGE (ventaja)\")","v":"✅ 0,60 < 1 → TIENES EDGE (ventaja)"}]
["2026-03-28",56,804.67633200709508,268.22544400236501,536.45088800473002,"ABIERTO","LOSS","—",4.0233816600354748,8.0871993166542211,-4.0233816600354748,0,-4.0233816600354748,0.34112722001182516,{"$f":"MAX(C$2:C57)","v":808.71993166542222},-5.0000000000000044E-3,-3,null,"Unidades de riesgo en cuenta",{"$f":"1/T8","v":66.666666666666671},{"$f":"\"Capital = \"&FIXED(T57,0)&\" apuestas\"","v":"Capital = 67 apuestas"}]
["2026-03-29",57,800.65295034705957,266.88431678235315,533.76863356470631,"ABIERTO","WIN","—",4.0032647517352968,8.0871993166542211,10.008161879338243,0,10.008161879338243,0.33442158391176591,{"$f":"MAX(C$2:C58)","v":808.71993166542222},-9.9750000000000671E-3,1,null,"⭐ P(Ruina) CON R:R",{"$f":"IF(T56>=1,1,POWER(T56,T57))","v":1.6221214190592713E-15},"🛡️ Prácticamente IMPOSIBLE. El R:R te salva."]
["2026-03-30",58,810.66111222639779,270.22037074213256,540.44074148426512,"ABIERTO","LOSS","—",4.0533055611319879,8.0871993166542211,-4.0533055611319879,0,-4.0533055611319879,0.35110185371066294,{"$f":"MAX(C$2:C59)","v":810.66111222639779},0,-1]
["2026-03-31",59,806.6078066652658,268.86926888842191,537.73853777684383,"ABIERTO","WIN","—",4.0330390333263288,8.0871993166542211,10.082597583315822,0,10.082597583315822,0.34434634444210976,{"$f":"MAX(C$2:C60)","v":810.66111222639779},-5.0000000000000044E-3,1,null,"🎯 LA LECCIÓN CENTRAL:"]
["2026-04-01",60,816.69040424858167,272.23013474952722,544.46026949905445,"CIERRE","WIN","LOSS",4.0834520212429082,8.0871993166542211,10.208630053107271,-8.0871993166542211,2.1214307364530498,0.36115067374763621,{"$f":"MAX(C$2:C61)","v":816.69040424858167},0,2,null,"Con WR 40% y apuestas 1:1, estás CONDENADO a quebrar (100% de probabilidad)."]
["2026-04-02",61,818.81183498503469,272.93727832834486,545.87455665668972,"APERTURA","LOSS","—",4.0940591749251727,8.1881183498503454,-4.0940591749251727,0,-4.0940591749251727,0.36468639164172445,{"$f":"MAX(C$2:C62)","v":818.81183498503469},0,-1,null,"Con WR 40% pero R:R 1:2.5, la ruina es prácticamente IMPOSIBLE (0.0000000000%)."]
["2026-04-03",62,814.71777581010952,271.57259193670313,543.14518387340627,"ABIERTO","WIN","—",4.073588879050547,8.1881183498503454,10.183972197626368,0,10.183972197626368,0.35786295968351589,{"$f":"MAX(C$2:C63)","v":818.81183498503469},-5.0000000000000044E-3,1,null,"El R:R NO es un \"nice to have\". Es la DIFERENCIA entre sobrevivir y quebrar."]
["2026-04-04",63,824.90174800773593,274.96724933591196,549.93449867182392,"ABIERTO","WIN","—",4.1245087400386788,8.1881183498503454,10.311271850096697,0,10.311271850096697,0.37483624667955984,{"$f":"MAX(C$2:C64)","v":824.90174800773593},0,2,null,"REGLAS DE STOP-TRADING — \"Control Emocional\""]
["2026-04-05",64,835.21301985783259,278.40433995261083,556.80867990522165,"ABIERTO","LOSS","—",4.1760650992891621,8.1881183498503454,-4.1760650992891621,0,-4.1760650992891621,0.39202169976305434,{"$f":"MAX(C$2:C65)","v":835.21301985783259},0,-1,null,"PRUEBA DE ESTRÉS: ¿Cuántas pérdidas seguidas para -50%?"]
["2026-04-06",65,831.0369547585434,{"$f":"C66*($T$3/$T$5)","v":277.01231825284776},{"$f":"C66*($T$4/$T$5)","v":554.02463650569553},"ABIERTO",{"$f":"IF(RAND()+0*$V$1<=$T$6,\"WIN\",\"LOSS\")","v":"LOSS"},{"$f":"IF(F66=\"CIERRE\",IF(RAND()+0*$V$1<=$T$6,\"WIN\",\"LOSS\"),\"—\")","v":"—"},4.1551847737927163,8.1881183498503454,-4.1551847737927163,0,-4.1551847737927163,0.385061591264239,{"$f":"MAX(C$2:C66)","v":835.21301985783259},-5.0000000000000044E-3,-2,null,"    Con tu riesgo de 1.5%:",{"$f":"ROUND(LN(0.5)/LN(1-T8),0)","v":46},{"$f":"\"Necesitas \"&T66&\" pérdidas SEGUIDAS para perder 50%\"","v":"Necesitas 46 pérdidas SEGUIDAS para perder 50%"}]
["2026-04-07",66,{"$f":"C66+M66","v":826.88176998475069},275.62725666158354,551.25451332316709,"CIERRE","WIN","LOSS",4.1344088499237532,8.1881183498503454,10.336022124809382,-8.1881183498503454,2.1479037749590368,0.37813628330791782,{"$f":"MAX(C$2:C67)","v":835.21301985783259},-9.9750000000000671E-3,1,null,"    Probabilidad de esa racha:",{"$f":"POWER(1-T6,T66)","v":6.2367382520429253E-11},"✅ Virtualmente imposible."]
["2026-04-08",67,829.02967375970968,276.34322458656987,552.68644917313975,{"$f":"IF(MOD(B68-1,$T$10)=0,\"APERTURA\",IF(MOD(B68,$T$10)=0,\"CIERRE\",IF(OR(F67=\"APERTURA\",F67=\"ABIERTO\"),\"ABIERTO\",\"—\")))","v":"APERTURA"},"WIN","—",{"$f":"D68*$T$8","v":4.145148368798548},{"$f":"IF(F68=\"APERTURA\",E68*$T$9,IF(OR(F68=\"ABIERTO\",F68=\"CIERRE\"),J67,0))","v":8.290296737597096},{"$f":"IF(G68=\"WIN\",I68*$T$7,-I68)","v":10.36287092199637},{"$f":"IF(F68=\"CIERRE\",IF(H68=\"WIN\",J68*$T$7,-J68),0)","v":0},{"$f":"K68+L68","v":10.36287092199637},{"$f":"(C68/C$2-1)","v":0.3817161229328494},{"$f":"MAX(C$2:C68)","v":835.21301985783259},{"$f":"C68/O68-1","v":-7.4033162212622239E-3},{"$f":"IF(G68=G67,IF(G68=\"WIN\",Q67+1,Q67-1),IF(G68=\"WIN\",1,-1))","v":2},null,"🛑 Max DD diario para PAUSA",-0.1,{"$f":"IF(T22<T68,\"🚨 DD simulado \"&FIXED(T22*100,1)&\"% EXCEDE límite\",\"✅ DD \"&FIXED(T22*100,1)&\"% dentro del límite\")","v":"✅ DD -6,7% dentro del límite"}]
["2026-04-09",68,839.392544681706,279.79751489390196,559.59502978780392,"ABIERTO","LOSS","—",4.1969627234085296,8.290296737597096,-4.1969627234085296,0,-4.1969627234085296,0.39898757446950994,{"$f":"MAX(C$2:C69)","v":839.392544681706},0,-1,null,"    ⚠️ PERO si subieras el riesgo a 10%:",{"$f":"ROUND(LN(0.5)/LN(1-0.1),0)","v":7},{"$f":"\"Solo \"&T69&\" pérdidas seguidas para -50%\"","v":"Solo 7 pérdidas seguidas para -50%"}]
["2026-04-10",69,835.19558195829745,278.39852731943245,556.79705463886489,"ABIERTO","LOSS","—",4.1759779097914862,8.290296737597096,-4.1759779097914862,0,-4.1759779097914862,0.39199263659716244,{"$f":"MAX(C$2:C70)","v":839.392544681706},-5.0000000000000044E-3,-2,null,"    Probabilidad de 7 losses seguidos:",{"$f":"POWER(1-T6,T69)","v":2.7993599999999997E-2},"❌ ESO SÍ PASA. Por eso el sizing importa."]
["2026-04-11",70,831.01960404850593,277.00653468283531,554.01306936567062,"ABIERTO","WIN","—",4.1550980202425292,8.290296737597096,10.387745050606323,0,10.387745050606323,0.38503267341417646,{"$f":"MAX(C$2:C71)","v":839.392544681706},-9.9750000000000671E-3,1,null,"🛑 Max trades por día",3,"Anti-overtrading: calidad > cantidad."]
["2026-04-12",71,841.40734909911225,280.46911636637071,560.93823273274143,"ABIERTO","LOSS","—",4.2070367454955608,8.290296737597096,-4.2070367454955608,0,-4.2070367454955608,0.40234558183185376,{"$f":"MAX(C$2:C72)","v":841.40734909911225},0,-1]
["2026-04-13",72,837.20031235361671,279.0667707845389,558.13354156907781,"CIERRE","LOSS","WIN",4.1860015617680837,8.290296737597096,-4.1860015617680837,20.72574184399274,16.539740282224656,0.39533385392269449,{"$f":"MAX(C$2:C73)","v":841.40734909911225},-5.0000000000000044E-3,-2,null,"🧠 PSICOLOGÍA DEL RIESGO — Notas de Clase"]
["2026-04-14",73,853.74005263584138,284.58001754528044,569.16003509056088,"APERTURA","WIN","—",4.2687002631792064,8.5374005263584127,10.671750657948015,0,10.671750657948015,0.4229000877264022,{"$f":"MAX(C$2:C74)","v":853.74005263584138},0,1]
["2026-04-15",74,864.41180329378938,288.13726776459646,576.27453552919292,"ABIERTO","WIN","—",4.3220590164689465,8.5374005263584127,10.805147541172367,0,10.805147541172367,0.44068633882298225,{"$f":"MAX(C$2:C75)","v":864.41180329378938},0,2,null,"Sesgo","Dónde aparece en este modelo","Antidoto"]
["2026-04-16",75,875.21695083496172,291.73898361165391,583.47796722330781,"ABIERTO","WIN","—",4.3760847541748085,8.5374005263584127,10.940211885437021,0,10.940211885437021,0.45869491805826956,{"$f":"MAX(C$2:C76)","v":875.21695083496172},0,3,null,"🧠 Aversión a la Pérdida","Cuando el DD baja y quieres cerrar ANTES del SL, o no tomar el trade por miedo.","Mira la col P (DD%): las caídas SON normales. Revisa la tabla de Asimetría."]
["2026-04-17",76,886.15716272039879,295.38572090679958,590.77144181359915,"ABIERTO","LOSS","—",4.4307858136019931,8.5374005263584127,-4.4307858136019931,0,-4.4307858136019931,0.47692860453399799,{"$f":"MAX(C$2:C77)","v":886.15716272039879},0,-1,null,"🧠 Sesgo de Recencia","Después de 3 wins seguidos crees que \"todo sube\". Después de 3 losses crees que \"todo baja\".","Mira la col Q (rachas): los streaks son NORMALES con 40% WR. No predicen nada."]
["2026-04-18",77,881.72637690679676,293.90879230226557,587.81758460453113,"ABIERTO","LOSS","—",4.4086318845339836,8.5374005263584127,-4.4086318845339836,0,-4.4086318845339836,0.46954396151132793,{"$f":"MAX(C$2:C78)","v":886.15716272039879},-5.0000000000000044E-3,-2,null,"🧠 Falacia del Apostador","\"Ya llevo 5 losses, TOCA ganar\". NO. Cada trade es independiente.","Cada RAND() es independiente. 6 losses seguidos NO aumenta el WR del séptimo."]
["2026-04-19",78,877.31774502226278,292.43924834075426,584.87849668150852,"CIERRE","WIN","WIN",4.3865887251113138,8.5374005263584127,10.966471812778284,21.343501315896031,32.309973128674315,0.46219624170377127,{"$f":"MAX(C$2:C79)","v":886.15716272039879},-9.9750000000000671E-3,1,null,"🧠 Overtrading","Después de perder quieres \"recuperar\" con más trades. Resultado: más pérdidas.","Regla Stop-Trading: máx 3 trades/día. Si pierdes el límite, APAGA la pantalla."]
["2026-04-20",79,909.62771815093708,303.20923938364569,606.41847876729139,"APERTURA","LOSS","—",4.548138590754685,9.0962771815093699,-4.548138590754685,0,-4.548138590754685,0.51604619691822839,{"$f":"MAX(C$2:C80)","v":909.62771815093708},0,-1]
["2026-04-21",80,905.07957956018242,301.69319318672746,603.38638637345491,"ABIERTO","LOSS","—",4.5253978978009117,9.0962771815093699,-4.5253978978009117,0,-4.5253978978009117,0.50846596593363746,{"$f":"MAX(C$2:C81)","v":909.62771815093708},-5.0000000000000044E-3,-2,null,"💡 Regla de oro: El simulador Monte Carlo demuestra que un sistema con edge GANA a largo plazo."]
["2026-04-22",81,900.55418166238155,300.18472722079383,600.36945444158766,"ABIERTO","LOSS","—",4.5027709083119074,9.0962771815093699,-4.5027709083119074,0,-4.5027709083119074,0.50092363610396928,{"$f":"MAX(C$2:C82)","v":909.62771815093708},-9.9749999999999561E-3,-3,null,"Tu TRABAJO como trader no es ganar cada trade. Es SEGUIR EL PLAN trade tras trade."]
["2026-04-23",82,896.05141075406959,298.68380358468983,597.36760716937965,"ABIERTO","LOSS","—",4.4802570537703472,9.0962771815093699,-4.4802570537703472,0,-4.4802570537703472,0.49341901792344922,{"$f":"MAX(C$2:C83)","v":909.62771815093708},-1.4925124999999984E-2,-4,null,"Los sesgos te empujan a cambiar el plan. Las reglas te protegen de ti mismo."]
["2026-04-24",83,891.57115370029919,297.1903845667664,594.38076913353279,"ABIERTO","WIN","—",4.4578557685014957,9.0962771815093699,11.144639421253739,0,11.144639421253739,0.48595192283383204,{"$f":"MAX(C$2:C84)","v":909.62771815093708},-1.9850499375000052E-2,1]
["2026-04-25",84,902.71579312155291,300.90526437385097,601.81052874770194,"CIERRE","LOSS","WIN",4.5135789656077643,9.0962771815093699,-4.5135789656077643,22.740692953773426,18.227113988165662,0.50452632186925483,{"$f":"MAX(C$2:C85)","v":909.62771815093708},-7.5986306171875739E-3,-1]
["2026-04-26",85,920.94290710971859,306.98096903657284,613.96193807314569,"APERTURA","LOSS","—",4.6047145355485926,9.2094290710971851,-4.6047145355485926,0,-4.6047145355485926,0.53490484518286441,{"$f":"MAX(C$2:C86)","v":920.94290710971859},0,-2]
["2026-04-27",86,916.33819257416997,305.44606419138995,610.8921283827799,"ABIERTO","WIN","—",4.5816909628708489,9.2094290710971851,11.454227407177122,0,11.454227407177122,0.52723032095694999,{"$f":"MAX(C$2:C87)","v":920.94290710971859},-5.0000000000000044E-3,1]
["2026-04-28",87,927.79241998134705,309.26413999378235,618.5282799875647,"ABIERTO","LOSS","—",4.6389620999067347,9.2094290710971851,-4.6389620999067347,0,-4.6389620999067347,0.54632069996891186,{"$f":"MAX(C$2:C88)","v":927.79241998134705},0,-1]
["2026-04-29",88,923.15345788144032,307.71781929381342,615.43563858762684,"ABIERTO","LOSS","—",4.6157672894072013,9.2094290710971851,-4.6157672894072013,0,-4.6157672894072013,0.53858909646906716,{"$f":"MAX(C$2:C89)","v":927.79241998134705},-5.0000000000000044E-3,-2]
["2026-04-30",89,918.53769059203307,306.17923019734434,612.35846039468868,"ABIERTO","WIN","—",4.5926884529601653,9.2094290710971851,11.481721132400413,0,11.481721132400413,0.53089615098672183,{"$f":"MAX(C$2:C90)","v":927.79241998134705},-9.9750000000000671E-3,1]
["2026-05-01",90,930.01941172443344,310.00647057481115,620.01294114962229,"CIERRE","WIN","WIN",4.6500970586221673,9.2094290710971851,11.625242646555417,23.023572677742962,34.648815324298383,0.55003235287405583,{"$f":"MAX(C$2:C91)","v":930.01941172443344},0,2]
["2026-05-02",91,964.66822704873186,321.5560756829106,643.11215136582121,"APERTURA","LOSS","—",4.823341135243659,9.6466822704873181,-4.823341135243659,0,-4.823341135243659,0.60778037841455301,{"$f":"MAX(C$2:C92)","v":964.66822704873186},0,-1]
["2026-05-03",92,959.84488591348816,319.94829530449601,639.89659060899203,"ABIERTO","WIN","—",4.79922442956744,9.6466822704873181,11.998061073918599,0,11.998061073918599,0.59974147652248022,{"$f":"MAX(C$2:C93)","v":964.66822704873186},-5.0000000000000044E-3,1]
["2026-05-04",93,971.84294698740678,323.94764899580224,647.89529799160448,"ABIERTO","WIN","—",4.8592147349370336,9.6466822704873181,12.148036837342584,0,12.148036837342584,0.6197382449790112,{"$f":"MAX(C$2:C94)","v":971.84294698740678},0,2]
["2026-05-05",94,983.99098382474938,327.99699460824979,655.99398921649959,"ABIERTO","WIN","—",4.9199549191237466,9.6466822704873181,12.299887297809367,0,12.299887297809367,0.63998497304124902,{"$f":"MAX(C$2:C95)","v":983.99098382474938},0,3]
["2026-05-06",95,996.29087112255877,332.09695704085289,664.19391408170577,"ABIERTO","LOSS","—",4.9814543556127928,9.6466822704873181,-4.9814543556127928,0,-4.9814543556127928,0.66048478520426457,{"$f":"MAX(C$2:C96)","v":996.29087112255877},0,-1]
["2026-05-07",96,991.30941676694601,330.43647225564865,660.87294451129731,"CIERRE","WIN","LOSS",4.9565470838347299,9.6466822704873181,12.391367709586824,-9.6466822704873181,2.7446854390995057,0.65218236127824336,{"$f":"MAX(C$2:C97)","v":996.29087112255877},-5.0000000000000044E-3,1]
["2026-05-08",97,994.05410220604551,331.35136740201517,662.70273480403034,"APERTURA","LOSS","—",4.9702705110302272,9.9405410220604544,-4.9702705110302272,0,-4.9702705110302272,0.65675683701007581,{"$f":"MAX(C$2:C98)","v":996.29087112255877},-2.2450962679132491E-3,-1]
["2026-05-09",98,989.08383169501531,329.69461056500506,659.38922113001013,"ABIERTO","LOSS","—",4.945419158475076,9.9405410220604544,-4.945419158475076,0,-4.945419158475076,0.64847305282502554,{"$f":"MAX(C$2:C99)","v":996.29087112255877},-7.2338707865736707E-3,-2]
["2026-05-10",99,984.13841253654027,328.04613751218005,656.09227502436011,"ABIERTO","WIN","—",4.9206920626827007,9.9405410220604544,12.301730156706752,0,12.301730156706752,0.64023068756090051,{"$f":"MAX(C$2:C100)","v":996.29087112255877},-1.2197701432640762E-2,1]
["2026-05-11",100,996.44014269324703,332.14671423108234,664.29342846216468,"ABIERTO","WIN","—",4.9822007134662352,9.9405410220604544,12.455501783665587,0,12.455501783665587,0.66073357115541165,{"$f":"MAX(C$2:C101)","v":996.44014269324703},0,2]
["2026-05-12",101,1008.8956444769126,336.29854815897085,672.59709631794169,"ABIERTO","WIN","—",5.0444782223845621,9.9405410220604544,12.611195555961405,0,12.611195555961405,0.68149274079485433,{"$f":"MAX(C$2:C102)","v":1008.8956444769126},0,3]
["2026-05-13",102,1021.506840032874,340.50228001095797,681.00456002191595,"CIERRE","LOSS","WIN",5.1075342001643698,9.9405410220604544,-5.1075342001643698,24.851352555151138,19.743818354986768,0.70251140005479007,{"$f":"MAX(C$2:C103)","v":1021.506840032874},0,-1]
["2026-05-14",103,1041.2506583878608,347.08355279595355,694.1671055919071,"APERTURA","WIN","—",5.2062532919393032,10.412506583878606,13.015633229848259,0,13.015633229848259,0.73541776397976788,{"$f":"MAX(C$2:C104)","v":1041.2506583878608},0,1]
["2026-05-15",104,1054.2662916177089,351.42209720590296,702.84419441180592,"ABIERTO","LOSS","—",5.271331458088544,10.412506583878606,-5.271331458088544,0,-5.271331458088544,0.75711048602951481,{"$f":"MAX(C$2:C105)","v":1054.2662916177089},0,-1]
["2026-05-16",105,1048.9949601596204,349.66498671987347,699.32997343974694,"ABIERTO","WIN","—",5.2449748007981016,10.412506583878606,13.112437001995254,0,13.112437001995254,0.74832493359936736,{"$f":"MAX(C$2:C106)","v":1054.2662916177089},-5.0000000000000044E-3,1]
["2026-05-17",106,1062.1073971616156,354.03579905387187,708.07159810774374,"ABIERTO","WIN","—",5.3105369858080778,10.412506583878606,13.276342464520194,0,13.276342464520194,0.7701789952693594,{"$f":"MAX(C$2:C107)","v":1062.1073971616156},0,2]
["2026-05-18",107,1075.3837396261358,358.46124654204527,716.92249308409055,"ABIERTO","LOSS","—",5.3769186981306785,10.412506583878606,-5.3769186981306785,0,-5.3769186981306785,0.79230623271022638,{"$f":"MAX(C$2:C108)","v":1075.3837396261358},0,-1]
["2026-05-19",108,1070.0068209280053,356.66894030933508,713.33788061867017,"CIERRE","LOSS","WIN",5.3500341046400264,10.412506583878606,-5.3500341046400264,26.031266459696518,20.68123235505649,0.78334470154667546,{"$f":"MAX(C$2:C109)","v":1075.3837396261358},-4.9999999999998934E-3,-2]
["2026-05-20",109,1090.6880532830617,363.5626844276872,727.1253688553744,"APERTURA","LOSS","—",5.4534402664153081,10.906880532830616,-5.4534402664153081,0,-5.4534402664153081,0.81781342213843611,{"$f":"MAX(C$2:C110)","v":1090.6880532830617},0,-3]
["2026-05-21",110,1085.2346130166463,361.74487100554876,723.48974201109752,"ABIERTO","WIN","—",5.4261730650832316,10.906880532830616,13.56543266270808,0,13.56543266270808,0.80872435502774387,{"$f":"MAX(C$2:C111)","v":1090.6880532830617},-5.0000000000000044E-3,1]
["2026-05-22",111,1098.8000456793545,366.26668189311818,732.53336378623635,"ABIERTO","LOSS","—",5.4940002283967724,10.906880532830616,-5.4940002283967724,0,-5.4940002283967724,0.83133340946559087,{"$f":"MAX(C$2:C112)","v":1098.8000456793545},0,-1]
["2026-05-23",112,1093.3060454509578,364.43534848365255,728.87069696730509,"ABIERTO","LOSS","—",5.466530227254788,10.906880532830616,-5.466530227254788,0,-5.466530227254788,0.82217674241826288,{"$f":"MAX(C$2:C113)","v":1098.8000456793545},-5.0000000000000044E-3,-2]
["2026-05-24",113,1087.8395152237031,362.61317174123434,725.22634348246868,"ABIERTO","LOSS","—",5.4391975761185147,10.906880532830616,-5.4391975761185147,0,-5.4391975761185147,0.81306585870617187,{"$f":"MAX(C$2:C114)","v":1098.8000456793545},-9.9749999999998451E-3,-3]
["2026-05-25",114,1082.4003176475846,360.80010588252821,721.60021176505643,"CIERRE","LOSS","LOSS",5.4120015882379233,10.906880532830616,-5.4120015882379233,-10.906880532830616,-16.31888212106854,0.80400052941264111,{"$f":"MAX(C$2:C115)","v":1098.8000456793545},-1.4925124999999873E-2,-4]
["2026-05-26",115,1066.0814355265161,355.3604785088387,710.72095701767739,"APERTURA","LOSS","—",5.3304071776325799,10.66081435526516,-5.3304071776325799,0,-5.3304071776325799,0.77680239254419359,{"$f":"MAX(C$2:C116)","v":1098.8000456793545},-2.9776673455277791E-2,-5]
["2026-05-27",116,1060.7510283488834,353.58367611629444,707.16735223258888,"ABIERTO","WIN","—",5.303755141744416,10.66081435526516,13.259387854361041,0,13.259387854361041,0.76791838058147244,{"$f":"MAX(C$2:C117)","v":1098.8000456793545},-3.4627790088001431E-2,1]
["2026-05-28",117,1074.0104162032444,358.00347206774813,716.00694413549627,"ABIERTO","LOSS","—",5.3700520810162216,10.66081435526516,-5.3700520810162216,0,-5.3700520810162216,0.79001736033874059,{"$f":"MAX(C$2:C118)","v":1098.8000456793545},-2.2560637464101529E-2,-1]
["2026-05-29",118,1068.6403641222282,356.21345470740937,712.42690941481874,"ABIERTO","LOSS","—",5.3432018206111405,10.66081435526516,-5.3432018206111405,0,-5.3432018206111405,0.78106727353704697,{"$f":"MAX(C$2:C119)","v":1098.8000456793545},-2.7447834276780991E-2,-2]
["2026-05-30",119,1063.2971623016172,354.43238743387235,708.8647748677447,"ABIERTO","WIN","—",5.3164858115080849,10.66081435526516,13.291214528770212,0,13.291214528770212,0.77216193716936199,{"$f":"MAX(C$2:C120)","v":1098.8000456793545},-3.2310595105397022E-2,1]
["2026-05-31",120,1076.5883768303875,358.8627922767958,717.7255845535916,"CIERRE","LOSS","WIN",5.3829418841519372,10.66081435526516,-5.3829418841519372,26.652035888162899,21.269094004010963,0.79431396138397914,{"$f":"MAX(C$2:C121)","v":1098.8000456793545},-2.0214477544214349E-2,-1]
["2026-06-01",121,1097.8574708343983,365.95249027813276,731.90498055626551,"APERTURA","LOSS","—",5.4892873541719913,10.978574708343983,-5.4892873541719913,0,-5.4892873541719913,0.82976245139066385,{"$f":"MAX(C$2:C122)","v":1098.8000456793545},-8.5782199287531835E-4,-2]
["2026-06-02",122,1092.3681834802264,364.12272782674211,728.24545565348421,"ABIERTO","LOSS","—",5.4618409174011315,10.978574708343983,-5.4618409174011315,0,-5.4618409174011315,0.82061363913371066,{"$f":"MAX(C$2:C123)","v":1098.8000456793545},-5.8535328829109057E-3,-3]
["2026-06-03",123,1086.9063425628253,362.30211418760842,724.60422837521685,"ABIERTO","LOSS","—",5.4345317128141257,10.978574708343983,-5.4345317128141257,0,-5.4345317128141257,0.81151057093804213,{"$f":"MAX(C$2:C124)","v":1098.8000456793545},-1.0824265218496332E-2,-4]
["2026-06-04",124,1081.4718108500113,360.4906036166704,720.9812072333408,"ABIERTO","LOSS","—",5.4073590542500556,10.978574708343983,-5.4073590542500556,0,-5.4073590542500556,0.80245301808335201,{"$f":"MAX(C$2:C125)","v":1098.8000456793545},-1.5770143892403832E-2,-5]
["2026-06-05",125,1076.0644517957612,358.68815059858707,717.37630119717414,"ABIERTO","WIN","—",5.380322258978806,10.978574708343983,13.450805647447016,0,13.450805647447016,0.79344075299293526,{"$f":"MAX(C$2:C126)","v":1098.8000456793545},-2.0691293172941716E-2,1]
["2026-06-06",126,1089.5152574432082,363.17175248106935,726.3435049621387,"CIERRE","WIN","LOSS",5.44757628721604,10.978574708343983,13.618940718040101,-10.978574708343983,2.6403660096961179,0.81585876240534683,{"$f":"MAX(C$2:C127)","v":1098.8000456793545},-8.4499343376035485E-3,2]
["2026-06-07",127,1092.1556234529044,364.05187448430144,728.10374896860287,"APERTURA","LOSS","—",5.4607781172645211,10.921556234529042,-5.4607781172645211,0,-5.4607781172645211,0.82025937242150726,{"$f":"MAX(C$2:C128)","v":1098.8000456793545},-6.0469802968947661E-3,-1]
["2026-06-08",128,1086.6948453356399,362.23161511187993,724.46323022375987,"ABIERTO","LOSS","—",5.4334742266781983,10.921556234529042,-5.4334742266781983,0,-5.4334742266781983,0.81115807555939989,{"$f":"MAX(C$2:C129)","v":1098.8000456793545},-1.101674539541031E-2,-2]
["2026-06-09",129,1081.2613711089616,{"$f":"C130*($T$3/$T$5)","v":360.4204570363205},{"$f":"C130*($T$4/$T$5)","v":720.840914072641},"ABIERTO",{"$f":"IF(RAND()+0*$V$1<=$T$6,\"WIN\",\"LOSS\")","v":"LOSS"},{"$f":"IF(F130=\"CIERRE\",IF(RAND()+0*$V$1<=$T$6,\"WIN\",\"LOSS\"),\"—\")","v":"—"},5.4063068555448073,10.921556234529042,-5.4063068555448073,0,-5.4063068555448073,0.80210228518160265,{"$f":"MAX(C$2:C130)","v":1098.8000456793545},-1.5961661668433269E-2,-3]
["2026-06-10",130,{"$f":"C130+M130","v":1075.8550642534169},358.61835475113895,717.2367095022779,"ABIERTO","LOSS","—",5.3792753212670839,10.921556234529042,-5.3792753212670839,0,-5.3792753212670839,0.79309177375569484,{"$f":"MAX(C$2:C131)","v":1098.8000456793545},-2.0881853360091074E-2,-4]
["2026-06-11",131,1070.4757889321497,356.8252629773832,713.65052595476641,{"$f":"IF(MOD(B132-1,$T$10)=0,\"APERTURA\",IF(MOD(B132,$T$10)=0,\"CIERRE\",IF(OR(F131=\"APERTURA\",F131=\"ABIERTO\"),\"ABIERTO\",\"—\")))","v":"ABIERTO"},"WIN","—",{"$f":"D132*$T$8","v":5.3523789446607477},{"$f":"IF(F132=\"APERTURA\",E132*$T$9,IF(OR(F132=\"ABIERTO\",F132=\"CIERRE\"),J131,0))","v":10.921556234529042},{"$f":"IF(G132=\"WIN\",I132*$T$7,-I132)","v":13.38094736165187},{"$f":"IF(F132=\"CIERRE\",IF(H132=\"WIN\",J132*$T$7,-J132),0)","v":0},{"$f":"K132+L132","v":13.38094736165187},{"$f":"(C132/C$2-1)","v":0.7841263148869162},{"$f":"MAX(C$2:C132)","v":1098.8000456793545},{"$f":"C132/O132-1","v":-2.5777444093290636E-2},{"$f":"IF(G132=G131,IF(G132=\"WIN\",Q131+1,Q131-1),IF(G132=\"WIN\",1,-1))","v":1}]
["2026-06-12",132,1083.8567362938015,361.28557876460047,722.57115752920095,"CIERRE","LOSS","WIN",5.4192836814690066,10.921556234529042,-5.4192836814690066,27.303890586322606,21.884606904853598,0.80642789382300251,{"$f":"MAX(C$2:C133)","v":1098.8000456793545},-1.3599662144456848E-2,-1]
["2026-06-13",133,1105.7413431986552,368.58044773288503,737.16089546577007,"APERTURA","WIN","—",5.528706715993275,11.05741343198655,13.821766789983187,0,13.821766789983187,0.84290223866442537,{"$f":"MAX(C$2:C134)","v":1105.7413431986552},0,1]
["2026-06-14",134,1119.5631099886384,373.18770332954614,746.37540665909228,"ABIERTO","LOSS","—",5.5978155499431921,11.05741343198655,-5.5978155499431921,0,-5.5978155499431921,0.86593851664773069,{"$f":"MAX(C$2:C135)","v":1119.5631099886384},0,-1]
["2026-06-15",135,1113.9652944386953,371.32176481289844,742.64352962579687,"ABIERTO","WIN","—",5.5698264721934763,11.05741343198655,13.924566180483691,0,13.924566180483691,0.85660882406449224,{"$f":"MAX(C$2:C136)","v":1119.5631099886384},-4.9999999999998934E-3,1]
["2026-06-16",136,1127.889860619179,375.96328687305964,751.92657374611929,"ABIERTO","LOSS","—",5.6394493030958941,11.05741343198655,-5.6394493030958941,0,-5.6394493030958941,0.87981643436529833,{"$f":"MAX(C$2:C137)","v":1127.889860619179},0,-1]
["2026-06-17",137,1122.250411316083,374.08347043869435,748.1669408773887,"ABIERTO","WIN","—",5.6112520565804154,11.05741343198655,14.028130141451038,0,14.028130141451038,0.87041735219347172,{"$f":"MAX(C$2:C138)","v":1127.889860619179},-5.0000000000000044E-3,1]
["2026-06-18",138,1136.2785414575342,378.75951381917804,757.51902763835608,"CIERRE","LOSS","WIN",5.68139270728767,11.05741343198655,-5.68139270728767,27.643533579966373,21.962140872678702,0.89379756909589037,{"$f":"MAX(C$2:C139)","v":1136.2785414575342},0,-1]
["2026-06-19",139,1158.2406823302128,386.08022744340428,772.16045488680857,"APERTURA","LOSS","—",5.7912034116510638,11.582406823302128,-5.7912034116510638,0,-5.7912034116510638,0.93040113721702133,{"$f":"MAX(C$2:C140)","v":1158.2406823302128},0,-2]
["2026-06-20",140,1152.4494789185617,384.14982630618721,768.29965261237442,"ABIERTO","LOSS","—",5.7622473945928077,11.582406823302128,-5.7622473945928077,0,-5.7622473945928077,0.92074913153093618,{"$f":"MAX(C$2:C141)","v":1158.2406823302128},-5.0000000000001155E-3,-3]
["2026-06-21",141,1146.6872315239689,382.22907717465625,764.45815434931251,"ABIERTO","WIN","—",5.7334361576198436,11.582406823302128,14.333590394049608,0,14.333590394049608,0.91114538587328142,{"$f":"MAX(C$2:C142)","v":1158.2406823302128},-9.9750000000000671E-3,1]
["2026-06-22",142,1161.0208219180186,387.00694063933952,774.01388127867904,"ABIERTO","LOSS","—",5.8051041095900926,11.582406823302128,-5.8051041095900926,0,-5.8051041095900926,0.93503470319669768,{"$f":"MAX(C$2:C143)","v":1161.0208219180186},0,-1]
["2026-06-23",143,1155.2157178084285,385.0719059361428,770.1438118722856,"ABIERTO","LOSS","—",5.7760785890421413,11.582406823302128,-5.7760785890421413,0,-5.7760785890421413,0.92535952968071422,{"$f":"MAX(C$2:C144)","v":1161.0208219180186},-5.0000000000000044E-3,-2]
["2026-06-24",144,1149.4396392193864,383.14654640646211,766.29309281292421,"CIERRE","LOSS","WIN",5.7471981960969316,11.582406823302128,-5.7471981960969316,28.95601705825532,23.208818862158388,0.91573273203231076,{"$f":"MAX(C$2:C145)","v":1161.0208219180186},-9.9749999999998451E-3,-3]
["2026-06-25",145,1172.6484580815447,390.88281936051487,781.76563872102975,"APERTURA","LOSS","—",5.8632422904077233,11.726484580815447,-5.8632422904077233,0,-5.8632422904077233,0.9544140968025745,{"$f":"MAX(C$2:C146)","v":1172.6484580815447},0,-4]
["2026-06-26",146,1166.785215791137,388.92840526371231,777.85681052742461,"ABIERTO","LOSS","—",5.8339260789556846,11.726484580815447,-5.8339260789556846,0,-5.8339260789556846,0.94464202631856176,{"$f":"MAX(C$2:C147)","v":1172.6484580815447},-5.0000000000000044E-3,-5]
["2026-06-27",147,1160.9512897121813,386.98376323739376,773.96752647478752,"ABIERTO","LOSS","—",5.804756448560906,11.726484580815447,-5.804756448560906,0,-5.804756448560906,0.93491881618696882,{"$f":"MAX(C$2:C148)","v":1172.6484580815447},-9.9750000000000671E-3,-6]
["2026-06-28",148,1155.1465332636203,385.04884442120675,770.0976888424135,"ABIERTO","WIN","—",5.7757326663181008,11.726484580815447,14.439331665795251,0,14.439331665795251,0.92524422210603396,{"$f":"MAX(C$2:C149)","v":1172.6484580815447},-1.4925125000000095E-2,1]
["2026-06-29",149,1169.5858649294155,389.86195497647179,779.72390995294359,"ABIERTO","WIN","—",5.8479293246470769,11.726484580815447,14.619823311617692,0,14.619823311617692,0.94930977488235913,{"$f":"MAX(C$2:C150)","v":1172.6484580815447},-2.6116890625001998E-3,2]
["2026-06-30",150,1184.2056882410332,394.7352294136777,789.4704588273554,"CIERRE","LOSS","LOSS",5.9210284412051655,11.726484580815447,-5.9210284412051655,-11.726484580815447,-17.647513022020611,0.97367614706838856,{"$f":"MAX(C$2:C151)","v":1184.2056882410332},0,-1]
["2026-07-01",151,1166.5581752190126,388.85272507300419,777.70545014600839,"APERTURA","WIN","—",5.8327908760950624,11.665581752190125,14.581977190237655,0,14.581977190237655,0.94426362536502095,{"$f":"MAX(C$2:C152)","v":1184.2056882410332},-1.4902405213264469E-2,1]
["2026-07-02",152,1181.1401524092503,393.71338413641672,787.42676827283344,"ABIERTO","LOSS","—",5.9057007620462505,11.665581752190125,-5.9057007620462505,0,-5.9057007620462505,0.96856692068208372,{"$f":"MAX(C$2:C153)","v":1184.2056882410332},-2.5886852784302583E-3,-1]
["2026-07-03",153,1175.234451647204,391.74481721573466,783.48963443146931,"ABIERTO","LOSS","—",5.8761722582360196,11.665581752190125,-5.8761722582360196,0,-5.8761722582360196,0.95872408607867321,{"$f":"MAX(C$2:C154)","v":1184.2056882410332},-7.5757418520381314E-3,-2]
["2026-07-04",154,1169.358279388968,389.78609312965597,779.57218625931193,"ABIERTO","LOSS","—",5.8467913969448393,11.665581752190125,-5.8467913969448393,0,-5.8467913969448393,0.94893046564827999,{"$f":"MAX(C$2:C155)","v":1184.2056882410332},-1.2537863142777939E-2,-3]
["2026-07-05",155,1163.5114879920231,387.83716266400768,775.67432532801536,"ABIERTO","LOSS","—",5.8175574399601153,11.665581752190125,-5.8175574399601153,0,-5.8175574399601153,0.93918581332003859,{"$f":"MAX(C$2:C156)","v":1184.2056882410332},-1.7475173827063983E-2,-4]
["2026-07-06",156,1157.693930552063,385.89797685068766,771.79595370137531,"CIERRE","LOSS","LOSS",5.7884696527603143,11.665581752190125,-5.7884696527603143,-11.665581752190125,-17.454051404950441,0.92948988425343826,{"$f":"MAX(C$2:C157)","v":1184.2056882410332},-2.2387797957928779E-2,-5]
["2026-07-07",157,1140.2398791471126,380.07995971570415,760.1599194314083,"APERTURA","LOSS","—",5.7011993957355624,11.402398791471125,-5.7011993957355624,0,-5.7011993957355624,0.90039979857852104,{"$f":"MAX(C$2:C158)","v":1184.2056882410332},-3.7126834916006435E-2,-6]
["2026-07-08",158,1134.538679751377,378.17955991712563,756.35911983425126,"ABIERTO","LOSS","—",5.6726933987568842,11.402398791471125,-5.6726933987568842,0,-5.6726933987568842,0.89089779958562842,{"$f":"MAX(C$2:C159)","v":1184.2056882410332},-4.1941200741426377E-2,-7]
["2026-07-09",159,1128.8659863526202,376.28866211754007,752.57732423508014,"ABIERTO","LOSS","—",5.6443299317631013,11.402398791471125,-5.6443299317631013,0,-5.6443299317631013,0.88144331058770042,{"$f":"MAX(C$2:C160)","v":1184.2056882410332},-4.6731494737719204E-2,-8]
["2026-07-10",160,1123.221656420857,374.4072188069523,748.8144376139046,"ABIERTO","WIN","—",5.6161082821042845,11.402398791471125,14.040270705260712,0,14.040270705260712,0.87203609403476179,{"$f":"MAX(C$2:C161)","v":1184.2056882410332},-5.1497837264030677E-2,1]
["2026-07-11",161,1137.2619271261178,379.08730904203924,758.17461808407847,"ABIERTO","LOSS","—",5.6863096356305887,11.402398791471125,-5.6863096356305887,0,-5.6863096356305887,0.89543654521019644,{"$f":"MAX(C$2:C162)","v":1184.2056882410332},-3.9641560229831008E-2,-1]
["2026-07-12",162,1131.5756174904873,377.19187249682909,754.38374499365818,"CIERRE","LOSS","LOSS",5.6578780874524366,11.402398791471125,-5.6578780874524366,-11.402398791471125,-17.06027687892356,0.88595936248414553,{"$f":"MAX(C$2:C163)","v":1184.2056882410332},-4.4443352428681804E-2,-2]
["2026-07-13",163,1114.5153406115637,371.50511353718787,743.01022707437573,"APERTURA","WIN","—",5.5725767030578179,11.145153406115636,13.931441757644546,0,13.931441757644546,0.85752556768593946,{"$f":"MAX(C$2:C164)","v":1184.2056882410332},-5.884986731737829E-2,1]
["2026-07-14",164,1128.4467823692082,376.1489274564027,752.29785491280541,"ABIERTO","WIN","—",5.6422339118460405,11.145153406115636,14.105584779615102,0,14.105584779615102,0.8807446372820138,{"$f":"MAX(C$2:C165)","v":1184.2056882410332},-4.7085490658845597E-2,2]
["2026-07-15",165,1142.5523671488234,380.85078904960778,761.70157809921557,"ABIERTO","LOSS","—",5.7127618357441161,11.145153406115636,-5.7127618357441161,0,-5.7127618357441161,0.90425394524803893,{"$f":"MAX(C$2:C166)","v":1184.2056882410332},-3.5174059292081061E-2,-1]
["2026-07-16",166,1136.8396053130793,378.94653510435978,757.89307020871956,"ABIERTO","WIN","—",5.6841980265653964,11.145153406115636,14.210495066413491,0,14.210495066413491,0.8947326755217988,{"$f":"MAX(C$2:C167)","v":1184.2056882410332},-3.9998188995620576E-2,1]
["2026-07-17",167,1151.0501003794927,383.68336679316423,767.36673358632845,"ABIERTO","LOSS","—",5.7552505018974633,11.145153406115636,-5.7552505018974633,0,-5.7552505018974633,0.91841683396582119,{"$f":"MAX(C$2:C168)","v":1184.2056882410332},-2.7998166358065957E-2,-1]
["2026-07-18",168,1145.2948498775952,381.76494995919836,763.52989991839672,"CIERRE","LOSS","LOSS",5.7264742493879748,11.145153406115636,-5.7264742493879748,-11.145153406115636,-16.871627655503609,0.90882474979599204,{"$f":"MAX(C$2:C169)","v":1184.2056882410332},-3.2858175526275679E-2,-2]
["2026-07-19",169,1128.4232222220917,376.14107407403054,752.28214814806108,"APERTURA","WIN","—",5.6421161111104583,11.284232222220917,14.105290277776145,0,14.105290277776145,0.88070537037015284,{"$f":"MAX(C$2:C170)","v":1184.2056882410332},-4.7105385975470426E-2,1]
["2026-07-20",170,1142.5285124998679,380.84283749995598,761.68567499991195,"ABIERTO","LOSS","—",5.7126425624993393,11.284232222220917,-5.7126425624993393,0,-5.7126425624993393,0.90421418749977978,{"$f":"MAX(C$2:C171)","v":1184.2056882410332},-3.5194203300163762E-2,-1]
["2026-07-21",171,1136.8158699373687,378.93862331245623,757.87724662491246,"ABIERTO","WIN","—",5.6840793496868436,11.284232222220917,14.210198374217109,0,14.210198374217109,0.89469311656228112,{"$f":"MAX(C$2:C172)","v":1184.2056882410332},-4.0018232283662858E-2,1]
["2026-07-22",172,1151.0260683115857,383.67535610386187,767.35071220772375,"ABIERTO","WIN","—",5.755130341557928,11.284232222220917,14.387825853894821,0,14.387825853894821,0.91837678051930949,{"$f":"MAX(C$2:C173)","v":1184.2056882410332},-2.801846018720866E-2,2]
["2026-07-23",173,1165.4138941654805,388.47129805516016,776.94259611032032,"ABIERTO","LOSS","—",5.8270694708274018,11.284232222220917,-5.8270694708274018,0,-5.8270694708274018,0.94235649027580082,{"$f":"MAX(C$2:C174)","v":1184.2056882410332},-1.5868690939548791E-2,-1]
["2026-07-24",174,1159.5868246946532,386.52894156488435,773.0578831297687,"CIERRE","LOSS","WIN",5.7979341234732651,11.284232222220917,-5.7979341234732651,28.210580555552291,22.412646432079026,0.93264470782442199,{"$f":"MAX(C$2:C175)","v":1184.2056882410332},-2.0789347484851062E-2,-2]
["2026-07-25",175,1181.9994711267323,393.99982370891075,787.99964741782151,"APERTURA","WIN","—",5.9099973556336609,11.819994711267322,14.774993389084152,0,14.774993389084152,0.96999911854455378,{"$f":"MAX(C$2:C176)","v":1184.2056882410332},-1.8630353968134283E-3,1]
["2026-07-26",176,1196.7744645158164,398.92482150527212,797.84964301054424,"ABIERTO","LOSS","—",5.9838723225790815,11.819994711267322,-5.9838723225790815,0,-5.9838723225790815,0.99462410752636066,{"$f":"MAX(C$2:C177)","v":1196.7744645158164},0,-1]
["2026-07-27",177,1190.7905921932372,396.9301973977457,793.8603947954914,"ABIERTO","LOSS","—",5.953952960966185,11.819994711267322,-5.953952960966185,0,-5.953952960966185,0.98465098698872877,{"$f":"MAX(C$2:C178)","v":1196.7744645158164},-5.0000000000000044E-3,-2]
["2026-07-28",178,1184.836639232271,394.94554641075695,789.89109282151389,"ABIERTO","LOSS","—",5.924183196161354,11.819994711267322,-5.924183196161354,0,-5.924183196161354,0.97472773205378482,{"$f":"MAX(C$2:C179)","v":1196.7744645158164},-9.9750000000000671E-3,-3]
["2026-07-29",179,1178.9124560361097,392.97081867870321,785.94163735740642,"ABIERTO","LOSS","—",5.8945622801805477,11.819994711267322,-5.8945622801805477,0,-5.8945622801805477,0.96485409339351613,{"$f":"MAX(C$2:C180)","v":1196.7744645158164},-1.4925125000000095E-2,-4]
["2026-07-30",180,1173.0178937559292,391.0059645853097,782.0119291706194,"CIERRE","LOSS","WIN",5.8650894687796455,11.819994711267322,-5.8650894687796455,29.549986778168304,23.68489730938866,0.95502982292654859,{"$f":"MAX(C$2:C181)","v":1196.7744645158164},-1.9850499374999941E-2,-5]
["2026-07-31",181,1196.7027910653178,398.90093035510591,797.80186071021183,"APERTURA","WIN","—",5.9835139553265888,11.967027910653178,14.958784888316472,0,14.958784888316472,0.9945046517755296,{"$f":"MAX(C$2:C182)","v":1196.7744645158164},-5.9888853433665012E-5,1]
["2026-08-01",182,1211.6615759536344,403.88719198454476,807.77438396908951,"ABIERTO","LOSS","—",6.0583078797681713,11.967027910653178,-6.0583078797681713,0,-6.0583078797681713,1.0194359599227241,{"$f":"MAX(C$2:C183)","v":1211.6615759536344},0,-1]
["2026-08-02",183,1205.6032680738663,401.86775602462205,803.73551204924411,"ABIERTO","WIN","—",6.028016340369331,11.967027910653178,15.070040850923327,0,15.070040850923327,1.0093387801231106,{"$f":"MAX(C$2:C184)","v":1211.6615759536344},-4.9999999999998934E-3,1]
["2026-08-03",184,1220.6733089247896,406.89110297492982,813.78220594985964,"ABIERTO","WIN","—",6.1033665446239471,11.967027910653178,15.258416361559867,0,15.258416361559867,1.0344555148746495,{"$f":"MAX(C$2:C185)","v":1220.6733089247896},0,2]
["2026-08-04",185,1235.9317252863495,411.97724176211648,823.95448352423296,"ABIERTO","LOSS","—",6.1796586264317472,11.967027910653178,-6.1796586264317472,0,-6.1796586264317472,1.0598862088105827,{"$f":"MAX(C$2:C186)","v":1235.9317252863495},0,-1]
["2026-08-05",186,1229.7520666599178,409.91735555330592,819.83471110661185,"CIERRE","LOSS","WIN",6.148760333299589,11.967027910653178,-6.148760333299589,29.917569776632945,23.768809443333357,1.0495867777665295,{"$f":"MAX(C$2:C187)","v":1235.9317252863495},-5.0000000000000044E-3,-2]
["2026-08-06",187,1253.5208761032511,417.84029203441702,835.68058406883404,"APERTURA","LOSS","—",6.2676043805162553,12.535208761032511,-6.2676043805162553,0,-6.2676043805162553,1.089201460172085,{"$f":"MAX(C$2:C188)","v":1253.5208761032511},0,-3]
["2026-08-07",188,1247.2532717227348,415.75109057424493,831.50218114848985,"ABIERTO","LOSS","—",6.2362663586136735,12.535208761032511,-6.2362663586136735,0,-6.2362663586136735,1.0787554528712247,{"$f":"MAX(C$2:C189)","v":1253.5208761032511},-5.0000000000001155E-3,-4]
["2026-08-08",189,1241.0170053641211,413.67233512137369,827.34467024274738,"ABIERTO","LOSS","—",6.2050850268206048,12.535208761032511,-6.2050850268206048,0,-6.2050850268206048,1.0683616756068686,{"$f":"MAX(C$2:C190)","v":1253.5208761032511},-9.9750000000000671E-3,-5]
["2026-08-09",190,1234.8119203373005,411.60397344576683,823.20794689153365,"ABIERTO","WIN","—",6.1740596016865021,12.535208761032511,15.435149004216255,0,15.435149004216255,1.0580198672288343,{"$f":"MAX(C$2:C191)","v":1253.5208761032511},-1.4925124999999984E-2,1]
["2026-08-10",191,1250.2470693415169,416.74902311383892,833.49804622767783,"ABIERTO","WIN","—",6.2512353467075839,12.535208761032511,15.62808836676896,0,15.62808836676896,1.0837451155691946,{"$f":"MAX(C$2:C192)","v":1253.5208761032511},-2.6116890624999778E-3,2]
["2026-08-11",192,1265.8751577082858,421.9583859027619,843.91677180552381,"CIERRE","WIN","WIN",6.3293757885414283,12.535208761032511,15.82343947135357,31.338021902581275,47.161461373934841,1.1097919295138094,{"$f":"MAX(C$2:C193)","v":1265.8751577082858},0,3]
["2026-08-12",193,1313.0366190822206,{"$f":"C194*($T$3/$T$5)","v":437.67887302740684},{"$f":"C194*($T$4/$T$5)","v":875.35774605481367},"APERTURA",{"$f":"IF(RAND()+0*$V$1<=$T$6,\"WIN\",\"LOSS\")","v":"WIN"},{"$f":"IF(F194=\"CIERRE\",IF(RAND()+0*$V$1<=$T$6,\"WIN\",\"LOSS\"),\"—\")","v":"—"},6.5651830954111023,13.130366190822205,16.412957738527755,0,16.412957738527755,1.1883943651370341,{"$f":"MAX(C$2:C194)","v":1313.0366190822206},0,4]
["2026-08-13",194,{"$f":"C194+M194","v":1329.4495768207482},443.14985894024937,886.29971788049875,"ABIERTO","LOSS","—",6.6472478841037406,13.130366190822205,-6.6472478841037406,0,-6.6472478841037406,1.2157492947012472,{"$f":"MAX(C$2:C195)","v":1329.4495768207482},0,-1]
["2026-08-14",195,1322.8023289366445,440.93410964554812,881.86821929109624,{"$f":"IF(MOD(B196-1,$T$10)=0,\"APERTURA\",IF(MOD(B196,$T$10)=0,\"CIERRE\",IF(OR(F195=\"APERTURA\",F195=\"ABIERTO\"),\"ABIERTO\",\"—\")))","v":"ABIERTO"},"WIN","—",{"$f":"D196*$T$8","v":6.6140116446832211},{"$f":"IF(F196=\"APERTURA\",E196*$T$9,IF(OR(F196=\"ABIERTO\",F196=\"CIERRE\"),J195,0))","v":13.130366190822205},{"$f":"IF(G196=\"WIN\",I196*$T$7,-I196)","v":16.535029111708052},{"$f":"IF(F196=\"CIERRE\",IF(H196=\"WIN\",J196*$T$7,-J196),0)","v":0},{"$f":"K196+L196","v":16.535029111708052},{"$f":"(C196/C$2-1)","v":1.2046705482277407},{"$f":"MAX(C$2:C196)","v":1329.4495768207482},{"$f":"C196/O196-1","v":-5.0000000000000044E-3},{"$f":"IF(G196=G195,IF(G196=\"WIN\",Q195+1,Q195-1),IF(G196=\"WIN\",1,-1))","v":1}]
["2026-08-15",196,1339.3373580483526,446.44578601611749,892.89157203223499,"ABIERTO","LOSS","—",6.6966867902417624,13.130366190822205,-6.6966867902417624,0,-6.6966867902417624,1.2322289300805878,{"$f":"MAX(C$2:C197)","v":1339.3373580483526},0,-1]
["2026-08-16",197,1332.6406712581108,444.21355708603693,888.42711417207386,"ABIERTO","LOSS","—",6.6632033562905537,13.130366190822205,-6.6632033562905537,0,-6.6632033562905537,1.2210677854301846,{"$f":"MAX(C$2:C198)","v":1339.3373580483526},-5.0000000000000044E-3,-2]
["2026-08-17",198,1325.9774679018203,441.99248930060674,883.98497860121347,"CIERRE","WIN","LOSS",6.6298873395091009,13.130366190822205,16.574718348772752,-13.130366190822205,3.4443521579505472,1.2099624465030341,{"$f":"MAX(C$2:C199)","v":1339.3373580483526},-9.9749999999999561E-3,1]
["2026-08-18",199,1329.4218200597709,443.14060668659027,886.28121337318055,"APERTURA","WIN","—",6.647109100298854,13.294218200597708,16.617772750747136,0,16.617772750747136,1.2157030334329515,{"$f":"MAX(C$2:C200)","v":1339.3373580483526},-7.4033162212621129E-3,2]
["2026-08-19",200,1346.0395928105181,448.67986427017269,897.35972854034537,"ABIERTO","LOSS","—",6.7301979640525902,13.294218200597708,-6.7301979640525902,0,-6.7301979640525902,1.2433993213508634,{"$f":"MAX(C$2:C201)","v":1346.0395928105181},0,-1]
["2026-08-20",201,1339.3093948464655,446.43646494882182,892.87292989764364,"ABIERTO","WIN","—",6.6965469742323274,13.294218200597708,16.74136743558082,0,16.74136743558082,1.2321823247441093,{"$f":"MAX(C$2:C202)","v":1346.0395928105181},-5.0000000000000044E-3,1]
["2026-08-21",202,1356.0507622820462,452.01692076068207,904.03384152136414,"ABIERTO","LOSS","—",6.7802538114102306,13.294218200597708,-6.7802538114102306,0,-6.7802538114102306,1.2600846038034104,{"$f":"MAX(C$2:C203)","v":1356.0507622820462},0,-1]
["2026-08-22",203,1349.2705084706361,449.75683615687865,899.5136723137573,"ABIERTO","LOSS","—",6.7463525423531792,13.294218200597708,-6.7463525423531792,0,-6.7463525423531792,1.2487841807843933,{"$f":"MAX(C$2:C204)","v":1356.0507622820462},-4.9999999999998934E-3,-2]
["2026-08-23",204,1342.5241559282829,447.50805197609429,895.01610395218859,"CIERRE","LOSS","LOSS",6.7126207796414139,13.294218200597708,-6.7126207796414139,-13.294218200597708,-20.006838980239124,1.2375402598804714,{"$f":"MAX(C$2:C205)","v":1356.0507622820462},-9.9749999999999561E-3,-3]
["2026-08-24",205,1322.5173169480438,440.83910564934791,881.67821129869583,"APERTURA","LOSS","—",6.6125865847402183,13.225173169480437,-6.6125865847402183,0,-6.6125865847402183,1.2041955282467396,{"$f":"MAX(C$2:C206)","v":1356.0507622820462},-2.4728753721262042E-2,-4]
["2026-08-25",206,1315.9047303633035,438.63491012110114,877.26982024220229,"ABIERTO","LOSS","—",6.5795236518165172,13.225173169480437,-6.5795236518165172,0,-6.5795236518165172,1.193174550605506,{"$f":"MAX(C$2:C207)","v":1356.0507622820462},-2.960510995265575E-2,-5]
["2026-08-26",207,1309.325206711487,436.44173557049567,872.88347114099133,"ABIERTO","LOSS","—",6.5466260335574349,13.225173169480437,-6.5466260335574349,0,-6.5466260335574349,1.1822086778524783,{"$f":"MAX(C$2:C208)","v":1356.0507622820462},-3.4457084402892524E-2,-6]
["2026-08-27",208,1302.7785806779295,434.25952689264318,868.51905378528636,"ABIERTO","LOSS","—",6.5138929033896478,13.225173169480437,-6.5138929033896478,0,-6.5138929033896478,1.1712976344632158,{"$f":"MAX(C$2:C209)","v":1356.0507622820462},-3.9284798980878111E-2,-7]
["2026-08-28",209,1296.2646877745399,432.08822925817992,864.17645851635984,"ABIERTO","WIN","—",6.4813234388726988,13.225173169480437,16.203308597181746,0,16.203308597181746,1.1604411462908999,{"$f":"MAX(C$2:C210)","v":1356.0507622820462},-4.4088374985973733E-2,1]
["2026-08-29",210,1312.4679963717217,437.48933212390722,874.97866424781444,"CIERRE","LOSS","LOSS",6.5623399818586083,13.225173169480437,-6.5623399818586083,-13.225173169480437,-19.787513151339045,1.187446660619536,{"$f":"MAX(C$2:C211)","v":1356.0507622820462},-3.2139479673298332E-2,-1]
["2026-08-30",211,1292.6804832203827,430.89349440679422,861.78698881358844,"APERTURA","WIN","—",6.4634024161019132,12.926804832203826,16.158506040254782,0,16.158506040254782,1.1544674720339714,{"$f":"MAX(C$2:C212)","v":1356.0507622820462},-4.6731494737719204E-2,1]
["2026-08-31",212,1308.8389892606374,436.27966308687911,872.55932617375822,"ABIERTO","WIN","—",6.5441949463031861,12.926804832203826,16.360487365757965,0,16.360487365757965,1.1813983154343957,{"$f":"MAX(C$2:C213)","v":1356.0507622820462},-3.4815638421940687E-2,2]
["2026-09-01",213,1325.1994766263954,441.73315887546511,883.46631775093022,"ABIERTO","LOSS","—",6.6259973831319767,12.926804832203826,-6.6259973831319767,0,-6.6259973831319767,1.2086657943773256,{"$f":"MAX(C$2:C214)","v":1356.0507622820462},-2.2750833902214995E-2,-1]
["2026-09-02",214,1318.5734792432634,439.52449308108777,879.04898616217554,"ABIERTO","WIN","—",6.5928673962163167,12.926804832203826,16.482168490540793,0,16.482168490540793,1.197622465405439,{"$f":"MAX(C$2:C215)","v":1356.0507622820462},-2.7637079732703906E-2,1]
["2026-09-03",215,1335.0556477338041,445.01854924460133,890.03709848920266,"ABIERTO","LOSS","—",6.6752782386690201,12.926804832203826,-6.6752782386690201,0,-6.6752782386690201,1.225092746223007,{"$f":"MAX(C$2:C216)","v":1356.0507622820462},-1.5482543229362711E-2,-1]
["2026-09-04",216,1328.380369495135,442.7934564983783,885.58691299675661,"CIERRE","WIN","LOSS",6.6419018474756744,12.926804832203826,16.604754618689185,-12.926804832203826,3.6779497864853585,1.2139672824918919,{"$f":"MAX(C$2:C217)","v":1356.0507622820462},-2.0405130513216019E-2,1]
["2026-09-05",217,1332.0583192816205,444.01943976054014,888.03887952108028,"APERTURA","LOSS","—",6.6602915964081015,13.320583192816203,-6.6602915964081015,0,-6.6602915964081015,1.220097198802701,{"$f":"MAX(C$2:C218)","v":1356.0507622820462},-1.7692879697253971E-2,-1]
["2026-09-06",218,1325.3980276852124,441.79934256173743,883.59868512347487,"ABIERTO","WIN","—",6.626990138426061,13.320583192816203,16.567475346065152,0,16.567475346065152,1.2089967128086871,{"$f":"MAX(C$2:C219)","v":1356.0507622820462},-2.2604415298767666E-2,1]
["2026-09-07",219,1341.9655030312774,447.32183434375912,894.64366868751824,"ABIERTO","WIN","—",6.7098275151563866,13.320583192816203,16.774568787890967,0,16.774568787890967,1.2366091717187957,{"$f":"MAX(C$2:C220)","v":1356.0507622820462},-1.0386970490002367E-2,2]
["2026-09-08",220,1358.7400718191684,452.91335727305614,905.82671454611227,"ABIERTO","LOSS","—",6.7937003590958414,13.320583192816203,-6.7937003590958414,0,-6.7937003590958414,1.2645667863652807,{"$f":"MAX(C$2:C221)","v":1358.7400718191684},0,-1]
["2026-09-09",221,1351.9463714600727,450.64879048669087,901.29758097338174,"ABIERTO","LOSS","—",6.7597318573003626,13.320583192816203,-6.7597318573003626,0,-6.7597318573003626,1.2532439524334547,{"$f":"MAX(C$2:C222)","v":1358.7400718191684},-4.9999999999998934E-3,-2]
["2026-09-10",222,1345.1866396027724,448.39554653425745,896.7910930685149,"CIERRE","LOSS","WIN",6.7259331980138617,13.320583192816203,-6.7259331980138617,33.30145798204051,26.575524784026648,1.2419777326712875,{"$f":"MAX(C$2:C223)","v":1358.7400718191684},-9.9749999999998451E-3,-3]
["2026-09-11",223,1371.762164386799,457.25405479559964,914.50810959119929,"APERTURA","LOSS","—",6.8588108219339947,13.717621643867989,-6.8588108219339947,0,-6.8588108219339947,1.2862702739779981,{"$f":"MAX(C$2:C224)","v":1371.762164386799},0,-4]
["2026-09-12",224,1364.903353564865,454.96778452162164,909.93556904324328,"ABIERTO","LOSS","—",6.8245167678243241,13.717621643867989,-6.8245167678243241,0,-6.8245167678243241,1.2748389226081085,{"$f":"MAX(C$2:C225)","v":1371.762164386799},-5.0000000000000044E-3,-5]
["2026-09-13",225,1358.0788367970406,452.69294559901351,905.38589119802702,"ABIERTO","LOSS","—",6.7903941839852022,13.717621643867989,-6.7903941839852022,0,-6.7903941839852022,1.2634647279950677,{"$f":"MAX(C$2:C226)","v":1371.762164386799},-9.9750000000000671E-3,-6]
["2026-09-14",226,1351.2884426130554,450.42948087101843,900.85896174203685,"ABIERTO","LOSS","—",6.7564422130652764,13.717621643867989,-6.7564422130652764,0,-6.7564422130652764,1.2521474043550924,{"$f":"MAX(C$2:C227)","v":1371.762164386799},-1.4925125000000095E-2,-7]
["2026-09-15",227,1344.53200039999,448.1773334666633,896.3546669333266,"ABIERTO","WIN","—",6.722660001999949,13.717621643867989,16.806650004999874,0,16.806650004999874,1.2408866673333168,{"$f":"MAX(C$2:C228)","v":1371.762164386799},-1.9850499375000163E-2,1]
["2026-09-16",228,1361.3386504049899,453.77955013499661,907.55910026999322,"CIERRE","LOSS","LOSS",6.8066932520249486,13.717621643867989,-6.8066932520249486,-13.717621643867989,-20.524314895892939,1.2688977506749834,{"$f":"MAX(C$2:C229)","v":1371.762164386799},-7.5986306171875739E-3,-1]
["2026-09-17",229,1340.814335509097,446.93811183636564,893.87622367273127,"APERTURA","WIN","—",6.7040716775454845,13.408143355090969,16.76017919386371,0,16.76017919386371,1.2346905591818285,{"$f":"MAX(C$2:C230)","v":1371.762164386799},-2.2560637464101641E-2,1]
["2026-09-18",230,1357.5745147029606,452.52483823432021,905.04967646864043,"ABIERTO","WIN","—",6.7878725735148029,13.408143355090969,16.969681433787006,0,16.969681433787006,1.262624191171601,{"$f":"MAX(C$2:C231)","v":1371.762164386799},-1.034264543240293E-2,2]
["2026-09-19",231,1374.5441961367476,458.18139871224918,916.36279742449835,"ABIERTO","LOSS","—",6.872720980683737,13.408143355090969,-6.872720980683737,0,-6.872720980683737,1.2909069935612458,{"$f":"MAX(C$2:C232)","v":1374.5441961367476},0,-1]
["2026-09-20",232,1367.6714751560639,455.89049171868794,911.78098343737588,"ABIERTO","LOSS","—",6.8383573757803191,13.408143355090969,-6.8383573757803191,0,-6.8383573757803191,1.2794524585934397,{"$f":"MAX(C$2:C233)","v":1374.5441961367476},-4.9999999999998934E-3,-2]
["2026-09-21",233,1360.8331177802836,453.61103926009451,907.22207852018903,"ABIERTO","WIN","—",6.8041655889014176,13.408143355090969,17.010413972253545,0,17.010413972253545,1.2680551963004727,{"$f":"MAX(C$2:C234)","v":1374.5441961367476},-9.9749999999999561E-3,1]
["2026-09-22",234,1377.843531752537,459.28117725084564,918.56235450169129,"CIERRE","LOSS","WIN",6.8892176587626848,13.408143355090969,-6.8892176587626848,33.52035838772742,26.631140728964734,1.2964058862542283,{"$f":"MAX(C$2:C235)","v":1377.843531752537},0,-1]
["2026-09-23",235,1404.4746724815018,468.15822416050059,936.31644832100119,"APERTURA","LOSS","—",7.0223733624075084,14.044746724815017,-7.0223733624075084,0,-7.0223733624075084,1.340791120802503,{"$f":"MAX(C$2:C236)","v":1404.4746724815018},0,-2]
["2026-09-24",236,1397.4522991190943,465.81743303969807,931.63486607939615,"ABIERTO","LOSS","—",6.9872614955954706,14.044746724815017,-6.9872614955954706,0,-6.9872614955954706,1.3290871651984904,{"$f":"MAX(C$2:C237)","v":1404.4746724815018},-5.0000000000000044E-3,-3]
["2026-09-25",237,1390.4650376234988,463.4883458744996,926.9766917489992,"ABIERTO","WIN","—",6.9523251881174941,14.044746724815017,17.380812970293736,0,17.380812970293736,1.317441729372498,{"$f":"MAX(C$2:C238)","v":1404.4746724815018},-9.9749999999999561E-3,1]
["2026-09-26",238,1407.8458505937926,469.28195019793088,938.56390039586176,"ABIERTO","LOSS","—",7.0392292529689628,14.044746724815017,-7.0392292529689628,0,-7.0392292529689628,1.3464097509896544,{"$f":"MAX(C$2:C239)","v":1407.8458505937926},0,-1]
["2026-09-27",239,1400.8066213408238,466.93554044694122,933.87108089388244,"ABIERTO","LOSS","—",7.0040331067041182,14.044746724815017,-7.0040331067041182,0,-7.0040331067041182,1.3346777022347065,{"$f":"MAX(C$2:C240)","v":1407.8458505937926},-4.9999999999998934E-3,-2]
["2026-09-28",240,1393.8025882341196,464.60086274470655,929.20172548941309,"CIERRE","WIN","LOSS",6.9690129411705977,14.044746724815017,17.422532352926495,-14.044746724815017,3.3777856281114786,1.3230043137235326,{"$f":"MAX(C$2:C241)","v":1407.8458505937926},-9.9749999999999561E-3,1]
["2026-09-29",241,1397.1803738622311,465.72679128741038,931.45358257482076,"APERTURA","LOSS","—",6.9859018693111556,13.971803738622311,-6.9859018693111556,0,-6.9859018693111556,1.3286339564370517,{"$f":"MAX(C$2:C242)","v":1407.8458505937926},-7.5757418520380204E-3,-1]
["2026-09-30",242,1390.1944719929199,463.39815733097328,926.79631466194655,"ABIERTO","LOSS","—",6.9509723599645987,13.971803738622311,-6.9509723599645987,0,-6.9509723599645987,1.3169907866548667,{"$f":"MAX(C$2:C243)","v":1407.8458505937926},-1.2537863142777939E-2,-2]
["2026-10-01",243,1383.2434996329553,461.08116654431842,922.16233308863684,"ABIERTO","LOSS","—",6.9162174981647757,13.971803738622311,-6.9162174981647757,0,-6.9162174981647757,1.3054058327215921,{"$f":"MAX(C$2:C244)","v":1407.8458505937926},-1.7475173827064094E-2,-3]
["2026-10-02",244,1376.3272821347905,458.77576071159683,917.55152142319366,"ABIERTO","LOSS","—",6.881636410673952,13.971803738622311,-6.881636410673952,0,-6.881636410673952,1.293878803557984,{"$f":"MAX(C$2:C245)","v":1407.8458505937926},-2.2387797957928779E-2,-4]
["2026-10-03",245,1369.4456457241165,456.48188190803882,912.96376381607763,"ABIERTO","WIN","—",6.8472282286205823,13.971803738622311,17.118070571551456,0,17.118070571551456,1.2824094095401941,{"$f":"MAX(C$2:C246)","v":1407.8458505937926},-2.7275858968139111E-2,1]
["2026-10-04",246,1386.563716295668,462.18790543188931,924.37581086377861,"CIERRE","WIN","WIN",6.9328185814783394,13.971803738622311,17.332046453695849,34.929509346555776,52.261555800251628,1.3109395271594466,{"$f":"MAX(C$2:C247)","v":1407.8458505937926},-1.511680720524089E-2,2]
["2026-10-05",247,1438.8252720959197,479.60842403197319,959.21684806394637,"APERTURA","LOSS","—",7.194126360479598,14.388252720959196,-7.194126360479598,0,-7.194126360479598,1.3980421201598663,{"$f":"MAX(C$2:C248)","v":1438.8252720959197},0,-1]
["2026-10-06",248,1431.63114573544,477.21038191181333,954.42076382362666,"ABIERTO","LOSS","—",7.1581557286771993,14.388252720959196,-7.1581557286771993,0,-7.1581557286771993,1.3860519095590664,{"$f":"MAX(C$2:C249)","v":1438.8252720959197},-5.0000000000001155E-3,-2]
["2026-10-07",249,1424.4729900067628,474.82433000225421,949.64866000450843,"ABIERTO","LOSS","—",7.1223649500338126,14.388252720959196,-7.1223649500338126,0,-7.1223649500338126,1.3741216500112712,{"$f":"MAX(C$2:C250)","v":1438.8252720959197},-9.9750000000000671E-3,-3]
["2026-10-08",250,1417.3506250567289,472.45020835224295,944.90041670448591,"ABIERTO","LOSS","—",7.0867531252836438,14.388252720959196,-7.0867531252836438,0,-7.0867531252836438,1.3622510417612146,{"$f":"MAX(C$2:C251)","v":1438.8252720959197},-1.4925125000000095E-2,-4]
["2026-10-09",251,1410.2638719314452,470.08795731048173,940.17591462096345,"ABIERTO","WIN","—",7.0513193596572252,14.388252720959196,17.628298399143063,0,17.628298399143063,1.3504397865524087,{"$f":"MAX(C$2:C252)","v":1438.8252720959197},-1.9850499375000163E-2,1]
["2026-10-10",252,1427.8921703305882,475.96405677686272,951.92811355372544,"CIERRE","LOSS","WIN",7.1394608516529408,14.388252720959196,-7.1394608516529408,35.970631802397989,28.831170950745047,1.3798202838843139,{"$f":"MAX(C$2:C253)","v":1438.8252720959197},-7.598630617187685E-3,-1]
["2026-10-11",253,1456.7233412813332,485.57444709377774,971.14889418755547,"APERTURA","WIN","—",7.2836167064066659,14.567233412813332,18.209041766016664,0,18.209041766016664,1.4278722354688886,{"$f":"MAX(C$2:C254)","v":1456.7233412813332},0,1]
["2026-10-12",254,1474.93238304735,491.64412768244995,983.2882553648999,"ABIERTO","LOSS","—",7.3746619152367492,14.567233412813332,-7.3746619152367492,0,-7.3746619152367492,1.45822063841225,{"$f":"MAX(C$2:C255)","v":1474.93238304735},0,-1]
["2026-10-13",255,1467.5577211321131,489.18590704403766,978.37181408807533,"ABIERTO","LOSS","—",7.337788605660565,14.567233412813332,-7.337788605660565,0,-7.337788605660565,1.4459295352201886,{"$f":"MAX(C$2:C256)","v":1474.93238304735},-5.0000000000001155E-3,-2]
["2026-10-14",256,1460.2199325264526,486.7399775088175,973.47995501763501,"ABIERTO","WIN","—",7.3010996626322626,14.567233412813332,18.252749156580656,0,18.252749156580656,1.4336998875440874,{"$f":"MAX(C$2:C257)","v":1474.93238304735},-9.9750000000000671E-3,1]
["2026-10-15",257,1478.4726816830332,{"$f":"C258*($T$3/$T$5)","v":492.82422722767774},{"$f":"C258*($T$4/$T$5)","v":985.64845445535548},"ABIERTO",{"$f":"IF(RAND()+0*$V$1<=$T$6,\"WIN\",\"LOSS\")","v":"WIN"},{"$f":"IF(F258=\"CIERRE\",IF(RAND()+0*$V$1<=$T$6,\"WIN\",\"LOSS\"),\"—\")","v":"—"},7.3923634084151661,14.567233412813332,18.480908521037914,0,18.480908521037914,1.4641211361383886,{"$f":"MAX(C$2:C258)","v":1478.4726816830332},0,2]
["2026-10-16",258,{"$f":"C258+M258","v":1496.9535902040711},498.98453006802367,997.96906013604735,"CIERRE","LOSS","LOSS",7.4847679510203546,14.567233412813332,-7.4847679510203546,-14.567233412813332,-22.052001363833686,1.4949226503401185,{"$f":"MAX(C$2:C259)","v":1496.9535902040711},0,-1]
["2026-10-17",259,1474.9015888402375,491.63386294674581,983.26772589349162,{"$f":"IF(MOD(B260-1,$T$10)=0,\"APERTURA\",IF(MOD(B260,$T$10)=0,\"CIERRE\",IF(OR(F259=\"APERTURA\",F259=\"ABIERTO\"),\"ABIERTO\",\"—\")))","v":"APERTURA"},"WIN","—",{"$f":"D260*$T$8","v":7.3745079442011869},{"$f":"IF(F260=\"APERTURA\",E260*$T$9,IF(OR(F260=\"ABIERTO\",F260=\"CIERRE\"),J259,0))","v":14.749015888402374},{"$f":"IF(G260=\"WIN\",I260*$T$7,-I260)","v":18.436269860502968},{"$f":"IF(F260=\"CIERRE\",IF(H260=\"WIN\",J260*$T$7,-J260),0)","v":0},{"$f":"K260+L260","v":18.436269860502968},{"$f":"(C260/C$2-1)","v":1.4581693147337291},{"$f":"MAX(C$2:C260)","v":1496.9535902040711},{"$f":"C260/O260-1","v":-1.4731252530566064E-2},{"$f":"IF(G260=G259,IF(G260=\"WIN\",Q259+1,Q259-1),IF(G260=\"WIN\",1,-1))","v":1}]
["2026-10-18",260,1493.3378587007405,497.77928623358014,995.55857246716027,"ABIERTO","WIN","—",7.4666892935037019,14.749015888402374,18.666723233759257,0,18.666723233759257,1.4888964311679009,{"$f":"MAX(C$2:C261)","v":1496.9535902040711},-2.4153931871980783E-3,2]
["2026-10-19",261,1512.0045819344998,504.0015273114999,1008.0030546229998,"ABIERTO","WIN","—",7.5600229096724982,14.749015888402374,18.900057274181247,0,18.900057274181247,1.5200076365574997,{"$f":"MAX(C$2:C262)","v":1512.0045819344998},0,3]
["2026-10-20",262,1530.9046392086811,510.30154640289368,1020.6030928057874,"ABIERTO","LOSS","—",7.6545231960434048,14.749015888402374,-7.6545231960434048,0,-7.6545231960434048,1.5515077320144686,{"$f":"MAX(C$2:C263)","v":1530.9046392086811},0,-1]
["2026-10-21",263,1523.2501160126378,507.75003867087923,1015.5000773417585,"ABIERTO","LOSS","—",7.6162505800631886,14.749015888402374,-7.6162505800631886,0,-7.6162505800631886,1.5387501933543963,{"$f":"MAX(C$2:C264)","v":1530.9046392086811},-5.0000000000000044E-3,-2]
["2026-10-22",264,1515.6338654325746,505.21128847752482,1010.4225769550496,"CIERRE","WIN","LOSS",7.5781693271628718,14.749015888402374,18.945423317907178,-14.749015888402374,4.1964074295048039,1.5260564423876244,{"$f":"MAX(C$2:C265)","v":1530.9046392086811},-9.9749999999999561E-3,1]
["2026-10-23",265,1519.8302728620795,506.61009095402648,1013.220181908053,"APERTURA","LOSS","—",7.5991513643103969,15.198302728620794,-7.5991513643103969,0,-7.5991513643103969,1.5330504547701325,{"$f":"MAX(C$2:C266)","v":1530.9046392086811},-7.2338707865735596E-3,-1]
["2026-10-24",266,1512.231121497769,504.07704049925633,1008.1540809985127,"ABIERTO","LOSS","—",7.5611556074888444,15.198302728620794,-7.5611556074888444,0,-7.5611556074888444,1.5203852024962816,{"$f":"MAX(C$2:C267)","v":1530.9046392086811},-1.2197701432640762E-2,-2]
["2026-10-25",267,1504.6699658902801,501.55665529676003,1003.1133105935201,"ABIERTO","LOSS","—",7.5233498294514005,15.198302728620794,-7.5233498294514005,0,-7.5233498294514005,1.5077832764838002,{"$f":"MAX(C$2:C268)","v":1530.9046392086811},-1.7136712925477582E-2,-3]
["2026-10-26",268,1497.1466160608286,499.04887202027618,998.09774404055236,"ABIERTO","WIN","—",7.4857330803041426,15.198302728620794,18.714332700760355,0,18.714332700760355,1.4952443601013812,{"$f":"MAX(C$2:C269)","v":1530.9046392086811},-2.2051029360850349E-2,1]
["2026-10-27",269,1515.860948761589,505.28698292052968,1010.5739658410594,"ABIERTO","WIN","—",7.5793047438079446,15.198302728620794,18.94826185951986,0,18.94826185951986,1.5264349146026484,{"$f":"MAX(C$2:C270)","v":1530.9046392086811},-9.8266672278608524E-3,2]
["2026-10-28",270,1534.8092106211088,511.60307020703624,1023.2061404140725,"CIERRE","LOSS","LOSS",7.6740460531055437,15.198302728620794,-7.6740460531055437,-15.198302728620794,-22.872348781726338,1.5580153510351815,{"$f":"MAX(C$2:C271)","v":1534.8092106211088},0,-1]
["2026-10-29",271,1511.9368618393826,503.97895394646082,1007.9579078929216,"APERTURA","WIN","—",7.5596843091969124,15.119368618393825,18.89921077299228,0,18.89921077299228,1.5198947697323044,{"$f":"MAX(C$2:C272)","v":1534.8092106211088},-1.4902405213264469E-2,1]
["2026-10-30",272,1530.8360726123749,510.27869087079159,1020.5573817415832,"ABIERTO","WIN","—",7.6541803630618732,15.119368618393825,19.135450907654683,0,19.135450907654683,1.551393454353958,{"$f":"MAX(C$2:C273)","v":1534.8092106211088},-2.5886852784301473E-3,2]
["2026-10-31",273,1549.9715235200297,516.65717450667648,1033.314349013353,"ABIERTO","WIN","—",7.7498576176001466,15.119368618393825,19.374644044000366,0,19.374644044000366,1.5832858725333829,{"$f":"MAX(C$2:C274)","v":1549.9715235200297},0,3]
["2026-11-01",274,1569.3461675640301,523.11538918801,1046.23077837602,"ABIERTO","LOSS","—",7.8467308378201501,15.119368618393825,-7.8467308378201501,0,-7.8467308378201501,1.6155769459400502,{"$f":"MAX(C$2:C275)","v":1569.3461675640301},0,-1]
["2026-11-02",275,1561.49943672621,520.49981224206999,1040.99962448414,"ABIERTO","LOSS","—",7.8074971836310496,15.119368618393825,-7.8074971836310496,0,-7.8074971836310496,1.60249906121035,{"$f":"MAX(C$2:C276)","v":1569.3461675640301},-5.0000000000000044E-3,-2]
["2026-11-03",276,1553.6919395425789,517.89731318085956,1035.7946263617191,"CIERRE","WIN","WIN",7.7684596977128928,15.119368618393825,19.421149244282233,37.79842154598456,57.219570790266793,1.589486565904298,{"$f":"MAX(C$2:C277)","v":1569.3461675640301},-9.9749999999999561E-3,1]
["2026-11-04",277,1610.9115103328456,536.9705034442818,1073.9410068885636,"APERTURA","LOSS","—",8.0545575516642263,16.109115103328453,-8.0545575516642263,0,-8.0545575516642263,1.6848525172214095,{"$f":"MAX(C$2:C278)","v":1610.9115103328456},0,-1]
["2026-11-05",278,1602.8569527811815,534.28565092706049,1068.571301854121,"ABIERTO","LOSS","—",8.0142847639059074,16.109115103328453,-8.0142847639059074,0,-8.0142847639059074,1.6714282546353023,{"$f":"MAX(C$2:C279)","v":1610.9115103328456},-5.0000000000000044E-3,-2]
["2026-11-06",279,1594.8426680172756,531.61422267242517,1063.2284453448503,"ABIERTO","LOSS","—",7.9742133400863775,16.109115103328453,-7.9742133400863775,0,-7.9742133400863775,1.658071113362126,{"$f":"MAX(C$2:C280)","v":1610.9115103328456},-9.9749999999999561E-3,-3]
["2026-11-07",280,1586.8684546771892,528.95615155906307,1057.9123031181261,"ABIERTO","LOSS","—",7.9343422733859459,16.109115103328453,-7.9343422733859459,0,-7.9343422733859459,1.6447807577953153,{"$f":"MAX(C$2:C281)","v":1610.9115103328456},-1.4925124999999984E-2,-4]
["2026-11-08",281,1578.9341124038033,526.31137080126769,1052.6227416025354,"ABIERTO","LOSS","—",7.894670562019015,16.109115103328453,-7.894670562019015,0,-7.894670562019015,1.6315568540063388,{"$f":"MAX(C$2:C282)","v":1610.9115103328456},-1.9850499374999941E-2,-5]
["2026-11-09",282,1571.0394418417843,523.67981394726144,1047.3596278945229,"CIERRE","LOSS","LOSS",7.8551972092089208,16.109115103328453,-7.8551972092089208,-16.109115103328453,-23.964312312537373,1.6183990697363071,{"$f":"MAX(C$2:C283)","v":1610.9115103328456},-2.4751246878124911E-2,-6]
["2026-11-10",283,1547.0751295292469,515.69170984308221,1031.3834196861644,"APERTURA","WIN","—",7.735375647646233,15.470751295292466,19.338439119115584,0,19.338439119115584,1.5784585492154113,{"$f":"MAX(C$2:C284)","v":1610.9115103328456},-3.9627490643734387E-2,1]
["2026-11-11",284,1566.4135686483623,522.13785621612078,1044.2757124322416,"ABIERTO","LOSS","—",7.8320678432418118,15.470751295292466,-7.8320678432418118,0,-7.8320678432418118,1.6106892810806039,{"$f":"MAX(C$2:C285)","v":1610.9115103328456},-2.7622834276781028E-2,-1]
["2026-11-12",285,1558.5815008051206,519.52716693504021,1039.0543338700804,"ABIERTO","LOSS","—",7.7929075040256031,15.470751295292466,-7.7929075040256031,0,-7.7929075040256031,1.5976358346752009,{"$f":"MAX(C$2:C286)","v":1610.9115103328456},-3.2484720105397047E-2,-2]
["2026-11-13",286,1550.788593301095,516.92953110036501,1033.85906220073,"ABIERTO","WIN","—",7.7539429665054751,15.470751295292466,19.384857416263689,0,19.384857416263689,1.5846476555018252,{"$f":"MAX(C$2:C287)","v":1610.9115103328456},-3.7322296504870067E-2,1]
["2026-11-14",287,1570.1734507173587,523.3911502391195,1046.782300478239,"ABIERTO","LOSS","—",7.8508672535867925,15.470751295292466,-7.8508672535867925,0,-7.8508672535867925,1.6169557511955976,{"$f":"MAX(C$2:C288)","v":1610.9115103328456},-2.5288825211181032E-2,-1]
["2026-11-15",288,1562.3225834637719,520.77419448792398,1041.548388975848,"CIERRE","WIN","LOSS",7.8116129173188593,15.470751295292466,19.529032293297149,-15.470751295292466,4.0582809980046832,1.6038709724396201,{"$f":"MAX(C$2:C289)","v":1610.9115103328456},-3.0162381085125034E-2,1]
["2026-11-16",289,1566.3808644617766,522.12695482059212,1044.2539096411842,"APERTURA","WIN","—",7.8319043223088816,15.663808644617763,19.579760805772203,0,19.579760805772203,1.610634774102961,{"$f":"MAX(C$2:C290)","v":1610.9115103328456},-2.7643135942251873E-2,2]
["2026-11-17",290,1585.9606252675487,528.65354175584957,1057.3070835116991,"ABIERTO","LOSS","—",7.9298031263377435,15.663808644617763,-7.9298031263377435,0,-7.9298031263377435,1.643267708779248,{"$f":"MAX(C$2:C291)","v":1610.9115103328456},-1.5488675141529962E-2,-1]
["2026-11-18",291,1578.030822141211,526.01027404707031,1052.0205480941406,"ABIERTO","LOSS","—",7.890154110706054,15.663808644617763,-7.890154110706054,0,-7.890154110706054,1.6300513702353516,{"$f":"MAX(C$2:C292)","v":1610.9115103328456},-2.0411231765822269E-2,-2]
["2026-11-19",292,1570.1406680305049,523.38022267683493,1046.7604453536699,"ABIERTO","LOSS","—",7.8507033401525241,15.663808644617763,-7.8507033401525241,0,-7.8507033401525241,1.6169011133841749,{"$f":"MAX(C$2:C293)","v":1610.9115103328456},-2.5309175606993306E-2,-3]
["2026-11-20",293,1562.2899646903525,520.76332156345075,1041.5266431269015,"ABIERTO","LOSS","—",7.8114498234517606,15.663808644617763,-7.8114498234517606,0,-7.8114498234517606,1.603816607817254,{"$f":"MAX(C$2:C294)","v":1610.9115103328456},-3.0182629728958243E-2,-4]
["2026-11-21",294,1554.4785148669007,518.15950495563357,1036.3190099112671,"CIERRE","LOSS","LOSS",7.7723925743345035,15.663808644617763,-7.7723925743345035,-15.663808644617763,-23.436201218952267,1.5907975247781678,{"$f":"MAX(C$2:C295)","v":1610.9115103328456},-3.5031716580313454E-2,-5]
["2026-11-22",295,1531.0423136479485,510.3474378826495,1020.694875765299,"APERTURA","WIN","—",7.6552115682397419,15.310423136479484,19.138028920599353,0,19.138028920599353,1.5517371894132475,{"$f":"MAX(C$2:C296)","v":1610.9115103328456},-4.9580126637989275E-2,1]
["2026-11-23",296,1550.1803425685478,516.72678085618259,1033.4535617123652,"ABIERTO","LOSS","—",7.7509017128427384,15.310423136479484,-7.7509017128427384,0,-7.7509017128427384,1.5836339042809131,{"$f":"MAX(C$2:C297)","v":1610.9115103328456},-3.7699878220964211E-2,-1]
["2026-11-24",297,1542.429440855705,514.1431469519016,1028.2862939038032,"ABIERTO","WIN","—",7.7121472042785237,15.310423136479484,19.280368010696311,0,19.280368010696311,1.5707157347595082,{"$f":"MAX(C$2:C298)","v":1610.9115103328456},-4.2511378829859447E-2,1]
["2026-11-25",298,1561.7098088664013,520.56993628880036,1041.1398725776007,"ABIERTO","LOSS","—",7.8085490443320049,15.310423136479484,-7.8085490443320049,0,-7.8085490443320049,1.6028496814440021,{"$f":"MAX(C$2:C299)","v":1610.9115103328456},-3.0542771065232732E-2,-1]
["2026-11-26",299,1553.9012598220693,517.96708660735635,1035.9341732147127,"ABIERTO","LOSS","—",7.7695062991103452,15.310423136479484,-7.7695062991103452,0,-7.7695062991103452,1.5898354330367823,{"$f":"MAX(C$2:C300)","v":1610.9115103328456},-3.5390057209906511E-2,-2]
["2026-11-27",300,1546.1317535229589,515.37725117431955,1030.7545023486391,"CIERRE","WIN","LOSS",7.7306587676147931,15.310423136479484,19.326646919036982,-15.310423136479484,4.016223782557498,1.5768862558715981,{"$f":"MAX(C$2:C301)","v":1610.9115103328456},-4.0213106923857045E-2,1]
["2026-11-28",301,1550.1479773055164,516.7159924351721,1033.4319848703442,"APERTURA","LOSS","—",7.7507398865275814,15.501479773055163,-7.7507398865275814,0,-7.7507398865275814,1.5835799621758606,{"$f":"MAX(C$2:C302)","v":1610.9115103328456},-3.771996949402534E-2,-1]
["2026-11-29",302,1542.3972374189889,514.13241247299629,1028.2648249459926,"ABIERTO","LOSS","—",7.7119861870949444,15.501479773055163,-7.7119861870949444,0,-7.7119861870949444,1.5706620623649816,{"$f":"MAX(C$2:C303)","v":1610.9115103328456},-4.2531369646555128E-2,-2]
["2026-11-30",303,1534.685251231894,511.5617504106313,1023.1235008212626,"ABIERTO","LOSS","—",7.6734262561594697,15.501479773055163,-7.6734262561594697,0,-7.6734262561594697,1.5578087520531567,{"$f":"MAX(C$2:C304)","v":1610.9115103328456},-4.7318712798322338E-2,-3]
["2026-12-01",304,1527.0118249757345,509.00394165857813,1018.0078833171563,"ABIERTO","LOSS","—",7.6350591248786719,15.501479773055163,-7.6350591248786719,0,-7.6350591248786719,1.5450197082928909,{"$f":"MAX(C$2:C305)","v":1610.9115103328456},-5.2082119234330815E-2,-4]
["2026-12-02",305,1519.3767658508559,506.45892195028529,1012.9178439005706,"ABIERTO","WIN","—",7.5968838292542786,15.501479773055163,18.992209573135696,0,18.992209573135696,1.5322946097514265,{"$f":"MAX(C$2:C306)","v":1610.9115103328456},-5.6821708638159052E-2,1]
["2026-12-03",306,1538.3689754239915,512.78965847466384,1025.5793169493277,"CIERRE","LOSS","LOSS",7.6918448771199577,15.501479773055163,-7.6918448771199577,-15.501479773055163,-23.193324650175121,1.5639482923733192,{"$f":"MAX(C$2:C307)","v":1610.9115103328456},-4.5031979996136062E-2,-1]
["2026-12-04",307,1515.1756507738164,505.0585502579388,1010.1171005158776,"APERTURA","WIN","—",7.5758782538690816,15.151756507738163,18.939695634672702,0,18.939695634672702,1.5252927512896939,{"$f":"MAX(C$2:C308)","v":1610.9115103328456},-5.9429620401215133E-2,1]
["2026-12-05",308,1534.1153464084891,511.37178213616301,1022.743564272326,"ABIERTO","LOSS","—",7.6705767320424449,15.151756507738163,-7.6705767320424449,0,-7.6705767320424449,1.5568589106808153,{"$f":"MAX(C$2:C309)","v":1610.9115103328456},-4.767249065623036E-2,-1]
["2026-12-06",309,1526.4447696764466,508.81492322548218,1017.6298464509644,"ABIERTO","LOSS","—",7.6322238483822327,15.151756507738163,-7.6322238483822327,0,-7.6322238483822327,1.544074616127411,{"$f":"MAX(C$2:C310)","v":1610.9115103328456},-5.2434128202949237E-2,-2]
["2026-12-07",310,1518.8125458280645,506.2708486093548,1012.5416972187096,"ABIERTO","LOSS","—",7.5940627291403215,15.151756507738163,-7.5940627291403215,0,-7.5940627291403215,1.5313542430467741,{"$f":"MAX(C$2:C311)","v":1610.9115103328456},-5.7171957561934494E-2,-3]
["2026-12-08",311,1511.218483098924,503.73949436630801,1007.478988732616,"ABIERTO","WIN","—",7.5560924154946196,15.151756507738163,18.890231038736548,0,18.890231038736548,1.51869747183154,{"$f":"MAX(C$2:C312)","v":1610.9115103328456},-6.1886097774124793E-2,1]
["2026-12-09",312,1530.1087141376606,510.03623804588688,1020.0724760917738,"CIERRE","LOSS","LOSS",7.6505435706883027,15.151756507738163,-7.6505435706883027,-15.151756507738163,-22.802300078426466,1.5501811902294342,{"$f":"MAX(C$2:C313)","v":1610.9115103328456},-5.015967399630139E-2,-1]
["2026-12-10",313,1507.3064140592342,502.43547135307801,1004.870942706156,"APERTURA","WIN","—",7.53653207029617,15.07306414059234,18.841330175740424,0,18.841330175740424,1.5121773567653904,{"$f":"MAX(C$2:C314)","v":1610.9115103328456},-6.4314579422307672E-2,1]
["2026-12-11",314,1526.1477442349747,508.71591474499155,1017.4318294899831,"ABIERTO","LOSS","—",7.6307387211748727,15.07306414059234,-7.6307387211748727,0,-7.6307387211748727,1.5435795737249576,{"$f":"MAX(C$2:C315)","v":1610.9115103328456},-5.2618511665086576E-2,-1]
["2026-12-12",315,1518.5170055137999,506.17233517126658,1012.3446703425332,"ABIERTO","LOSS","—",7.5925850275689983,15.07306414059234,-7.5925850275689983,0,-7.5925850275689983,1.5308616758563329,{"$f":"MAX(C$2:C316)","v":1610.9115103328456},-5.7355419106761008E-2,-2]
["2026-12-13",316,1510.9244204862309,503.64147349541031,1007.2829469908206,"ABIERTO","LOSS","—",7.5546221024311544,15.07306414059234,-7.5546221024311544,0,-7.5546221024311544,1.5182073674770518,{"$f":"MAX(C$2:C317)","v":1610.9115103328456},-6.2068642011227193E-2,-3]
["2026-12-14",317,1503.3697983837997,501.12326612793322,1002.2465322558664,"ABIERTO","WIN","—",7.516848991918998,15.07306414059234,18.792122479797495,0,18.792122479797495,1.5056163306396662,{"$f":"MAX(C$2:C318)","v":1610.9115103328456},-6.6758298801171123E-2,1]
["2026-12-15",318,1522.1619208635971,507.38730695453233,1014.7746139090647,"CIERRE","LOSS","WIN",7.6108096043179847,15.07306414059234,-7.6108096043179847,37.682660351480848,30.071850747162863,1.5369365347726616,{"$f":"MAX(C$2:C319)","v":1610.9115103328456},-5.50927775361858E-2,-1]
["2026-12-16",319,1552.23377161076,517.41125720358662,1034.8225144071732,"APERTURA","LOSS","—",7.7611688580537992,15.522337716107598,-7.7611688580537992,0,-7.7611688580537992,1.5870562860179334,{"$f":"MAX(C$2:C320)","v":1610.9115103328456},-3.6425178134062541E-2,-2]
["2026-12-17",320,1544.4726027527061,514.82420091756865,1029.6484018351373,"ABIERTO","WIN","—",7.7223630137635295,15.522337716107598,19.305907534408824,0,19.305907534408824,1.5741210045878433,{"$f":"MAX(C$2:C321)","v":1610.9115103328456},-4.1243052243392309E-2,1]
["2026-12-18",321,1563.7785102871148,{"$f":"C322*($T$3/$T$5)","v":521.2595034290382},{"$f":"C322*($T$4/$T$5)","v":1042.5190068580764},"ABIERTO",{"$f":"IF(RAND()+0*$V$1<=$T$6,\"WIN\",\"LOSS\")","v":"WIN"},{"$f":"IF(F322=\"CIERRE\",IF(RAND()+0*$V$1<=$T$6,\"WIN\",\"LOSS\"),\"—\")","v":"—"},7.8188925514355727,15.522337716107598,19.547231378588933,0,19.547231378588933,1.6062975171451912,{"$f":"MAX(C$2:C322)","v":1610.9115103328456},-2.9258590396434747E-2,2]
["2026-12-19",322,{"$f":"C322+M322","v":1583.3257416657038},527.77524722190128,1055.5504944438026,"ABIERTO","LOSS","—",7.9166287083285187,15.522337716107598,-7.9166287083285187,0,-7.9166287083285187,1.6388762361095064,{"$f":"MAX(C$2:C323)","v":1610.9115103328456},-1.7124322776390088E-2,-1]
["2026-12-20",323,1575.4091129573753,525.1363709857917,1050.2727419715834,{"$f":"IF(MOD(B324-1,$T$10)=0,\"APERTURA\",IF(MOD(B324,$T$10)=0,\"CIERRE\",IF(OR(F323=\"APERTURA\",F323=\"ABIERTO\"),\"ABIERTO\",\"—\")))","v":"ABIERTO"},"LOSS","—",{"$f":"D324*$T$8","v":7.8770455647868749},{"$f":"IF(F324=\"APERTURA\",E324*$T$9,IF(OR(F324=\"ABIERTO\",F324=\"CIERRE\"),J323,0))","v":15.522337716107598},{"$f":"IF(G324=\"WIN\",I324*$T$7,-I324)","v":-7.8770455647868749},{"$f":"IF(F324=\"CIERRE\",IF(H324=\"WIN\",J324*$T$7,-J324),0)","v":0},{"$f":"K324+L324","v":-7.8770455647868749},{"$f":"(C324/C$2-1)","v":1.6256818549289589},{"$f":"MAX(C$2:C324)","v":1610.9115103328456},{"$f":"C324/O324-1","v":-2.2038701162508167E-2},{"$f":"IF(G324=G323,IF(G324=\"WIN\",Q323+1,Q323-1),IF(G324=\"WIN\",1,-1))","v":-2}]
["2026-12-21",324,1567.5320673925885,522.51068913086283,1045.0213782617257,"CIERRE","WIN","LOSS",7.8376603369629425,15.522337716107598,19.594150842407355,-15.522337716107598,4.071813126299757,1.612553445654314,{"$f":"MAX(C$2:C325)","v":1610.9115103328456},-2.6928507656695633E-2,1]
["2026-12-22",325,1571.6038805188882,523.86796017296274,1047.7359203459255,"APERTURA","LOSS","—",7.858019402594441,15.716038805188882,-7.858019402594441,0,-7.858019402594441,1.6193398008648137,{"$f":"MAX(C$2:C326)","v":1610.9115103328456},-2.4400862221063746E-2,-1]
["2026-12-23",326,1563.7458611162938,521.24862037209789,1042.4972407441958,"ABIERTO","WIN","—",7.8187293055814679,15.716038805188882,19.546823263953669,0,19.546823263953669,1.6062431018604895,{"$f":"MAX(C$2:C327)","v":1610.9115103328456},-2.9278857909958433E-2,1]
["2026-12-24",327,1583.2926843802475,527.76422812674912,1055.5284562534982,"ABIERTO","WIN","—",7.9164634219012369,15.716038805188882,19.791158554753093,0,19.791158554753093,1.6388211406337456,{"$f":"MAX(C$2:C328)","v":1610.9115103328456},-1.714484363383284E-2,2]
["2026-12-25",328,1603.0838429350006,534.36128097833353,1068.7225619566671,"ABIERTO","WIN","—",8.0154192146750027,15.716038805188882,20.038548036687509,0,20.038548036687509,1.6718064048916674,{"$f":"MAX(C$2:C329)","v":1610.9115103328456},-4.8591541792557535E-3,3]
["2026-12-26",329,1623.122390971688,541.04079699056263,1082.0815939811253,"ABIERTO","LOSS","—",8.1156119548584389,15.716038805188882,-8.1156119548584389,0,-8.1156119548584389,1.7052039849528131,{"$f":"MAX(C$2:C330)","v":1623.122390971688},0,-1]
["2026-12-27",330,1615.0067790168296,538.33559300560978,1076.6711860112196,"CIERRE","WIN","WIN",8.0750338950841467,15.716038805188882,20.187584737710367,39.290097012972204,59.477681750682571,1.6916779650280493,{"$f":"MAX(C$2:C331)","v":1623.122390971688},-5.0000000000000044E-3,1]
["2026-12-28",331,1674.4844607675122,558.16148692250408,1116.3229738450082,"APERTURA","LOSS","—",8.3724223038375616,16.744844607675123,-8.3724223038375616,0,-8.3724223038375616,1.7908074346125202,{"$f":"MAX(C$2:C332)","v":1674.4844607675122},0,-1]
["2026-12-29",332,1666.1120384636747,555.37067948789149,1110.741358975783,"ABIERTO","LOSS","—",8.330560192318373,16.744844607675123,-8.330560192318373,0,-8.330560192318373,1.7768533974394578,{"$f":"MAX(C$2:C333)","v":1674.4844607675122},-5.0000000000000044E-3,-2]
["2026-12-30",333,1657.7814782713563,552.59382609045201,1105.187652180904,"ABIERTO","LOSS","—",8.2889073913567799,16.744844607675123,-8.2889073913567799,0,-8.2889073913567799,1.7629691304522606,{"$f":"MAX(C$2:C334)","v":1674.4844607675122},-9.9750000000000671E-3,-3]
["2026-12-31",334,1649.4925708799994,549.83085695999978,1099.6617139199996,"ABIERTO","LOSS","—",8.2474628543999966,16.744844607675123,-8.2474628543999966,0,-8.2474628543999966,1.749154284799999,{"$f":"MAX(C$2:C335)","v":1674.4844607675122},-1.4925125000000095E-2,-4]
[]
[]
[]
[]
[]
[]
[{"$nulls":9},235]

{"sheet":"RESULTADOS_MC","index":2,"n_rows":101,"n_cols":14,"rows_kept":101,"cut":false,"hidden":false,"merged":[[16,6,16,10],[6,6,6,8],[1,6,1,8],[2,6,2,8],[3,6,3,8],[4,6,4,8],[5,6,5,8]]}
["Run","Equity Final","Return %","Max Drawdown %","Win Rate",null,"PANEL DE RESULTADOS — MONTE CARLO (100 SIMULACIONES)",{"$nulls":5},"Rango Retorno","Frecuencia"]
[1,0,-1,-1,6.2874251497005984E-2,null,"Probabilidad de perder dinero",null,null,{"$f":"COUNTIF(C2:C101,\"<0\")/COUNTA(C2:C101)","v":1},{"$f":"IF(J2<=0.05,\"✅ Excelente (<5%)\",IF(J2<=0.15,\"⚠️ Moderado (5-15%)\",\"❌ Alto (>15%)\"))","v":"❌ Alto (>15%)"},null,"< 0%",{"$f":"COUNTIFS(C2:C101,\"<0\")","v":100}]
[2,0,-1,-1,7.7844311377245512E-2,null,"Retorno mediano",null,null,{"$f":"MEDIAN(C2:C101)","v":-1},{"$f":"IF(J3>=1,\"✅ Duplicas capital\",IF(J3>=0.5,\"✅ >50% retorno\",IF(J3>=0.1,\"✅ >10% retorno\",\"⚠️ Retorno bajo\")))","v":"⚠️ Retorno bajo"},null,"0-50%",{"$f":"COUNTIFS(C2:C101,\">=0\",C2:C101,\"<0.5\")","v":0}]
[3,0,-1,-1,5.089820359281437E-2,null,"Percentil 10% (escenario malo)",null,null,{"$f":"_xlfn.PERCENTILE.INC(C2:C101,0.1)","v":-1},{"$f":"IF(J4>0,\"✅ Incluso el peor 10% gana\",\"❌ 10% de veces pierdes\")","v":"❌ 10% de veces pierdes"},null,"50-100%",{"$f":"COUNTIFS(C2:C101,\">=0.5\",C2:C101,\"<1\")","v":0}]
[4,0,-1,-1,6.2874251497005984E-2,null,"Percentil 90% (escenario bueno)",null,null,{"$f":"_xlfn.PERCENTILE.INC(C2:C101,0.9)","v":-1},{"$f":"\"⭐ El mejor 10% gana >\"&FIXED(J5*100,0)&\"%\"","v":"⭐ El mejor 10% gana >-100%"},null,"100-150%",{"$f":"COUNTIFS(C2:C101,\">=1\",C2:C101,\"<1.5\")","v":0}]
[5,0,-1,-1,5.089820359281437E-2,null,"Drawdown típico (mediana)",null,null,{"$f":"MEDIAN(D2:D101)","v":-1},{"$f":"IF(J6>-0.15,\"✅ DD controlado (<15%)\",IF(J6>-0.3,\"⚠️ DD significativo\",\"❌ DD severo (>30%)\"))","v":"❌ DD severo (>30%)"},null,"150-200%",{"$f":"COUNTIFS(C2:C101,\">=1.5\",C2:C101,\"<2\")","v":0}]
[6,0,-1,-1,5.9880239520958084E-2,null,"Drawdown malo (P90)",null,null,{"$f":"_xlfn.PERCENTILE.INC(D2:D101,0.9)","v":-1},{"$f":"IF(ABS(J7)<0.2,\"✅ Tolerable\",IF(ABS(J7)<0.4,\"⚠️ Doloroso\",\"❌ Muy severo\"))","v":"❌ Muy severo"},null,"200-250%",{"$f":"COUNTIFS(C2:C101,\">=2\",C2:C101,\"<2.5\")","v":0}]
[7,0,-1,-1,7.7844311377245512E-2,{"$nulls":7},"250-300%",{"$f":"COUNTIFS(C2:C101,\">=2.5\",C2:C101,\"<3\")","v":0}]
[8,0,-1,-1,5.3892215568862277E-2,null,"ESTADÍSTICAS ADICIONALES",{"$nulls":5},"300-400%",{"$f":"COUNTIFS(C2:C101,\">=3\",C2:C101,\"<4\")","v":0}]
[9,0,-1,-1,6.8862275449101798E-2,null,"Retorno Promedio",null,null,{"$f":"AVERAGE(C2:C101)","v":-1},null,null,">400%",{"$f":"COUNTIFS(C2:C101,\">=4\")","v":0}]
[10,0,-1,-1,6.8862275449101798E-2,null,"Desviación Estándar",null,null,{"$f":"STDEV(C2:C101)","v":0},"Dispersión de resultados"]
[11,0,-1,-1,8.3832335329341312E-2,null,"Retorno Mínimo",null,null,{"$f":"MIN(C2:C101)","v":-1},"Peor simulación posible"]
[12,0,-1,-1,6.5868263473053898E-2,null,"Retorno Máximo",null,null,{"$f":"MAX(C2:C101)","v":-1},"Mejor simulación posible"]
[13,0,-1,-1,5.9880239520958084E-2,null,"Win Rate Promedio",null,null,{"$f":"AVERAGE(E2:E101)","v":6.550898203592824E-2},"Debería converger al input"]
[14,0,-1,-1,6.8862275449101798E-2,null,"Equity Final Promedio",null,null,{"$f":"AVERAGE(B2:B101)","v":0}]
[15,0,-1,-1,5.9880239520958084E-2,null,"Equity Final Mediana",null,null,{"$f":"MEDIAN(B2:B101)","v":0}]
[16,0,-1,-1,6.2874251497005984E-2,null,"⚠️ Para actualizar: ejecuta la macro Monte Carlo desde VBA (Alt+F8 → RunMonteCarlo). Los datos de arriba son de la última ejecución."]
[17,0,-1,-1,6.8862275449101798E-2,null,"INTERPRETACIÓN DE RESULTADOS"]
[18,0,-1,-1,5.089820359281437E-2,null,"🎲 ¿Qué significa esta simulación?"]
[19,0,-1,-1,5.6886227544910177E-2,null,{"$f":"\"Corrimos tu plan de trading \"&COUNTA(A2:A101)&\" veces con diferentes secuencias aleatorias de\"","v":"Corrimos tu plan de trading 100 veces con diferentes secuencias aleatorias de"}]
[20,0,-1,-1,7.7844311377245512E-2,null,{"$f":"\"wins y losses. Cada corrida simula \"&'Plan de Trading'!T25&\" días de trading (Feb-Dic 2026).\"","v":"wins y losses. Cada corrida simula 334 días de trading (Feb-Dic 2026)."}]
[21,0,-1,-1,6.2874251497005984E-2]
[22,0,-1,-1,9.2814371257485026E-2,null,"💰 Sobre tu dinero:"]
[23,0,-1,-1,5.9880239520958084E-2,null,{"$f":"IF(J2=0,\"✅ En 100 simulaciones, NINGUNA perdió dinero. Tu plan tiene ventaja estadística.\",\"⚠️ En \"&FIXED(J2*100,0)&\" de 100 simulaciones se perdió dinero.\")","v":"⚠️ En 100 de 100 simulaciones se perdió dinero."}]
[24,0,-1,-1,4.790419161676647E-2,null,{"$f":"\"• En el peor escenario (P10), tu retorno fue \"&FIXED(J4*100,1)&\"% — aun así ganaste dinero\"","v":"• En el peor escenario (P10), tu retorno fue -100,0% — aun así ganaste dinero"}]
[25,0,-1,-1,5.3892215568862277E-2,null,{"$f":"\"• En el escenario típico (mediana), tu retorno fue \"&FIXED(J3*100,1)&\"% (equity final $\"&FIXED(J16,0)&\")\"","v":"• En el escenario típico (mediana), tu retorno fue -100,0% (equity final $0)"}]
[26,0,-1,-1,7.7844311377245512E-2,null,{"$f":"\"• En el mejor 10% de los casos, ganaste más de \"&FIXED(J5*100,0)&\"% de retorno\"","v":"• En el mejor 10% de los casos, ganaste más de -100% de retorno"}]
[27,0,-1,-1,6.8862275449101798E-2]
[28,0,-1,-1,7.1856287425149698E-2,null,"📉 Sobre el dolor del camino:"]
[29,0,-1,-1,6.2874251497005984E-2,null,{"$f":"\"• El drawdown típico fue \"&FIXED(ABS(J6)*100,1)&\"% — en algún momento tu cuenta cayó ~\"&FIXED(ABS(J6)*100,0)&\"% desde su máximo\"","v":"• El drawdown típico fue 100,0% — en algún momento tu cuenta cayó ~100% desde su máximo"}]
[30,0,-1,-1,5.6886227544910177E-2,null,"• Esto es NORMAL incluso en sistemas ganadores. No significa que el plan falló."]
[31,0,-1,-1,8.0838323353293412E-2,null,{"$f":"\"• En el peor 10% de simulaciones, el DD llegó a \"&FIXED(ABS(J7)*100,1)&\"%\"","v":"• En el peor 10% de simulaciones, el DD llegó a 100,0%"}]
[32,0,-1,-1,6.2874251497005984E-2]
[33,0,-1,-1,5.6886227544910177E-2,null,"🎯 Conclusión:"]
[34,0,-1,-1,6.5868263473053898E-2,null,{"$f":"IF(AND(J2<=0.05,J3>=0.3,J6>-0.3),\"✅ SISTEMA VIABLE — Tu plan tiene ventaja matemática. La clave es ejecutarlo con disciplina\",IF(AND(J2<=0.15,J3>=0.1),\"⚠️ SISTEMA MARGINAL — Funciona pero con márgenes estrechos. Revisa parámetros.\",\"❌ SISTEMA NO VIABLE — Los números no favorecen este plan. Ajusta WR, R:R o riesgo.\"))","v":"❌ SISTEMA NO VIABLE — Los números no favorecen este plan. Ajusta WR, R:R o riesgo."}]
[35,0,-1,-1,5.6886227544910177E-2,null,"    sin importar la emoción del momento. Respeta el Stop Loss y el Position Sizing."]
[36,0,-1,-1,5.6886227544910177E-2]
[37,0,-1,-1,7.1856287425149698E-2,null,"💡 Nota didáctica:"]
[38,0,-1,-1,6.5868263473053898E-2,null,"Presiona F9 para regenerar las 100 simulaciones. Verás que los números cambian"]
[39,0,-1,-1,6.5868263473053898E-2,null,"pero la TENDENCIA se mantiene: un sistema con ventaja matemática gana a largo plazo."]
[40,0,-1,-1,8.3832335329341312E-2,null,"La gestión del riesgo NO elimina las pérdidas — las hace SOBREVIVIBLES."]
[41,0,-1,-1,7.4850299401197598E-2]
[42,0,-1,-1,6.8862275449101798E-2]
[43,0,-1,-1,7.4850299401197598E-2]
[44,0,-1,-1,7.7844311377245512E-2]
[45,0,-1,-1,6.5868263473053898E-2]
[46,0,-1,-1,6.2874251497005984E-2]
[47,0,-1,-1,4.4910179640718563E-2]
[48,0,-1,-1,7.4850299401197598E-2]
[49,0,-1,-1,4.1916167664670656E-2]
[50,0,-1,-1,6.5868263473053898E-2]
[51,0,-1,-1,7.4850299401197598E-2]
[52,0,-1,-1,6.8862275449101798E-2]
[53,0,-1,-1,6.8862275449101798E-2]
[54,0,-1,-1,8.3832335329341312E-2]
[55,0,-1,-1,5.9880239520958084E-2]
[56,0,-1,-1,7.1856287425149698E-2]
[57,0,-1,-1,4.790419161676647E-2]
[58,0,-1,-1,6.2874251497005984E-2]
[59,0,-1,-1,7.4850299401197598E-2]
[60,0,-1,-1,7.4850299401197598E-2]
[61,0,-1,-1,6.5868263473053898E-2]
[62,0,-1,-1,7.1856287425149698E-2]
[63,0,-1,-1,5.9880239520958084E-2]
[64,0,-1,-1,6.5868263473053898E-2]
[65,0,-1,-1,5.9880239520958084E-2]
[66,0,-1,-1,5.089820359281437E-2]
[67,0,-1,-1,6.5868263473053898E-2]
[68,0,-1,-1,4.4910179640718563E-2]
[69,0,-1,-1,6.8862275449101798E-2]
[70,0,-1,-1,5.3892215568862277E-2]
[71,0,-1,-1,7.1856287425149698E-2]
[72,0,-1,-1,6.5868263473053898E-2]
[73,0,-1,-1,8.0838323353293412E-2]
[74,0,-1,-1,8.3832335329341312E-2]
[75,0,-1,-1,5.3892215568862277E-2]
[76,0,-1,-1,6.5868263473053898E-2]
[77,0,-1,-1,6.8862275449101798E-2]
[78,0,-1,-1,5.6886227544910177E-2]
[79,0,-1,-1,6.5868263473053898E-2]
[80,0,-1,-1,5.3892215568862277E-2]
[81,0,-1,-1,6.5868263473053898E-2]
[82,0,-1,-1,6.8862275449101798E-2]
[83,0,-1,-1,4.1916167664670656E-2]
[84,0,-1,-1,6.5868263473053898E-2]
[85,0,-1,-1,6.8862275449101798E-2]
[86,0,-1,-1,7.4850299401197598E-2]
[87,0,-1,-1,5.9880239520958084E-2]
[88,0,-1,-1,5.3892215568862277E-2]
[89,0,-1,-1,6.2874251497005984E-2]
[90,0,-1,-1,8.0838323353293412E-2]
[91,0,-1,-1,6.5868263473053898E-2]
[92,0,-1,-1,6.8862275449101798E-2]
[93,0,-1,-1,5.089820359281437E-2]
[94,0,-1,-1,7.1856287425149698E-2]
[95,0,-1,-1,7.4850299401197598E-2]
[96,0,-1,-1,7.7844311377245512E-2]
[97,0,-1,-1,7.1856287425149698E-2]
[98,0,-1,-1,5.6886227544910177E-2]
[99,0,-1,-1,7.4850299401197598E-2]
[100,0,-1,-1,6.2874251497005984E-2]

{"sheet":"Calculadora PS","index":3,"n_rows":112,"n_cols":9,"rows_kept":112,"cut":false,"hidden":false,"merged":[]}
[null,"CALCULADORA DE POSITION SIZING"]
[null,"Gestión de Riesgo por Posición — Herramienta Didáctica y Operativa"]
[]
[null,"SECCIÓN 1 — LOS 5 PILARES DE UNA POSICIÓN",null,null,null,"SECCIÓN 3 — EL JUEGO DE PESAS"]
[null,"Concepto","Valor","Explicación",null,"\"Si mueves una pieza, las demás se ajustan\""]
[null,"① Capital Total (Futuros)",{"$f":"Portafolio!E10","v":200},"Tu saldo total. Es el límite de supervivencia."]
[null,"② Precio de Entrada (Entry)",75456,"Nivel donde ejecutas la orden.",null,"Variable","🟢 SL Ajustado","🟡 Caso Base","🔴 SL Amplio"]
[null,"③ Stop Loss (SL)",74281,"Tu tesis queda invalidada. Salida de emergencia.",null,"Entrada",{"$f":"C7","v":75456},{"$f":"C7","v":75456},{"$f":"C7","v":75456}]
[null,"④ Take Profit (TP)",79200,"Objetivo de ganancias. Determina la recompensa.",null,"Stop Loss",{"$f":"C7*(1-C20*0.5)","v":74868.5},{"$f":"C8","v":74281},{"$f":"C7*(1-C20*2)","v":73106}]
[null,"⑤ Dirección (Long / Short)","LONG","LONG = compra, SHORT = venta en corto.",null,"Take Profit",{"$f":"C9","v":79200},{"$f":"C9","v":79200},{"$f":"C9","v":79200}]
[{"$nulls":5},"Distancia SL (%)",{"$f":"ABS(G8-G9)/G8","v":7.7859944868532652E-3},{"$f":"C20","v":1.557198897370653E-2},{"$f":"ABS(I8-I9)/I8","v":3.1143977947413061E-2}]
[null,"Parámetros de Riesgo",null,null,null,"Riesgo Monetario ($)",{"$f":"C24","v":3.1199999999999997},{"$f":"C24","v":3.1199999999999997},{"$f":"C24","v":3.1199999999999997}]
[null,"% Riesgo por Trade",1.5599999999999999E-2,"Regla de oro: definir ANTES de abrir posición.",null,"R:R",{"$f":"ABS(G10-G8)/ABS(G8-G9)","v":6.3727659574468083},{"$f":"C27","v":3.1863829787234041},{"$f":"ABS(I10-I8)/ABS(I8-I9)","v":1.5931914893617021}]
[null,"Capital Asignado a Estrategia",56,"Capital destinado a esta estrategia."]
[null,"Apalancamiento Disponible",10,"Máximo apalancamiento del exchange/broker.",null,"⭐ Position Size (nocional)",{"$f":"G12/G11","v":400.71952340425531},{"$f":"C34","v":200.35976170212766},{"$f":"I12/I11","v":100.17988085106383}]
[{"$nulls":5},"    Apalancamiento Requerido",{"$f":"IF(G15<=C14,1,G15/C14)","v":7.1557057750759876},{"$f":"C30","v":3.5778528875379938},{"$f":"IF(I15<=C14,1,I15/C14)","v":1.7889264437689969}]
[null,"SECCIÓN 2 — LA TRÍADA DEL RIESGO",null,null,null,"    Pérdida si SL se activa",{"$f":"(G15/G8)*ABS(G8-G9)","v":3.1199999999999997},{"$f":"C38","v":3.1199999999999997},{"$f":"(I15/I8)*ABS(I8-I9)","v":3.1199999999999997}]
[null,"Concepto Derivado","Valor","Cómo se interpreta",null,"    Ganancia si TP se alcanza",{"$f":"(G15/G8)*ABS(G10-G8)","v":19.88302978723404},{"$f":"C39","v":9.9415148936170201},{"$f":"(I15/I8)*ABS(I10-I8)","v":4.9707574468085101}]
[null,"A. Distancia al SL (precio)",{"$f":"ABS(C7-C8)","v":1175},"Diferencia absoluta entre Entry y SL."]
[null,"    Distancia al SL (%)",{"$f":"ABS(C7-C8)/C7","v":1.557198897370653E-2},"Qué tanto se mueve el precio hasta tu SL.",null,"💡 LECCIÓN CLAVE:"]
[null,"    Distancia al TP (precio)",{"$f":"ABS(C9-C7)","v":3744},"Diferencia absoluta entre Entry y TP.",null,"En los 3 escenarios pierdes EXACTAMENTE lo mismo ($)."]
[null,"    Distancia al TP (%)",{"$f":"ABS(C9-C7)/C7","v":4.9618320610687022E-2},"Qué tanto se mueve el precio hasta tu TP.",null,"Lo que cambia es el TAMAÑO de la posición y el apalancamiento."]
[{"$nulls":5},"SL amplio → posición pequeña. SL ajustado → posición grande."]
[null,"A. Riesgo Monetario (Risk $)",{"$f":"C6*C13","v":3.1199999999999997},"Dinero exacto que pierdes si se activa el SL.",null,"El riesgo monetario SIEMPRE se mantiene controlado."]
[null,"    Fórmula: Capital × % Riesgo"]
[{"$nulls":5},"SECCIÓN 4 — VALIDACIÓN Y ALERTAS"]
[null,"B. Ratio Riesgo / Beneficio (R:R)",{"$f":"ABS(C9-C7)/ABS(C7-C8)","v":3.1863829787234041},{"$f":"\"1 : \"&FIXED(C27,2)","v":"1 : 3,19"}]
[null,"    Fórmula: Distancia TP ÷ Distancia SL",null,null,null,"⚠️ Panel de Alertas"]
[{"$nulls":5},"¿Riesgo dentro del límite?",{"$f":"IF(C13<=0.02,\"✅ OK (≤2%)\",\"❌ EXCEDE 2% del capital\")","v":"✅ OK (≤2%)"}]
[null,"C. Apalancamiento Requerido",{"$f":"IF(C34<=C14,1,C34/C14)","v":3.5778528875379938},"Apalancamiento mínimo para el sizing calculado.",null,"¿Apalancamiento seguro?",{"$f":"IF(C30<=C15,\"✅ OK (\"&FIXED(C30,1)&\"x ≤ \"&FIXED(C15,0)&\"x)\",\"❌ NECESITAS \"&FIXED(C30,1)&\"x pero solo tienes \"&FIXED(C15,0)&\"x\")","v":"✅ OK (3,6x ≤ 10x)"}]
[null,"    Si es 1x = no necesitas apalancamiento",null,null,null,"¿R:R favorable?",{"$f":"IF(C27>=2,\"✅ R:R ≥1:2 (favorable)\",IF(C27>=1,\"⚠️ R:R entre 1:1 y 1:2 (marginal)\",\"❌ R:R < 1:1 (desfavorable)\"))","v":"✅ R:R ≥1:2 (favorable)"}]
[{"$nulls":5},"¿Margen cabe en capital asignado?",{"$f":"IF(C36<=C14,\"✅ Margen $\"&FIXED(C36,2)&\" ≤ Capital $\"&FIXED(C14,2),\"❌ Margen $\"&FIXED(C36,2)&\" EXCEDE capital $\"&FIXED(C14,2))","v":"✅ Margen $20,04 ≤ Capital $56,00"}]
[null,"RESULTADO — POSITION SIZE CALCULADO"]
[null,"⑤ Tamaño de Posición (USD nocional)",{"$f":"C24/C20","v":200.35976170212766},"Fórmula: Riesgo$ ÷ Distancia SL%",null,"🎯 INSTINTO vs FÓRMULA"]
[null,"    Tamaño en Unidades (contratos/tokens)",{"$f":"C34/C7","v":2.65531914893617E-3},"Nocional ÷ Precio de Entrada",null,null,"🧠 Por Fórmula","💥 Por Instinto","Diferencia"]
[null,"    Margen Requerido (con apalancamiento)",{"$f":"C34/C15","v":20.035976170212766},"Nocional ÷ Apalancamiento disponible",null,"Tamaño posición elegido ($)",{"$f":"C34","v":200.35976170212766},200,{"$f":"H36-G36","v":-0.35976170212765624}]
[{"$nulls":5},"Pérdida si SL se activa ($)",{"$f":"C38","v":3.1199999999999997},{"$f":"(H36/C7)*C19","v":3.114397794741306},{"$f":"H37-G37","v":-5.6022052586937043E-3}]
[null,"Verificación: Pérdida si SL se activa",{"$f":"C35*C19","v":3.1199999999999997},{"$f":"IF(ABS(C38-C24)<0.01,\"✅ Coincide con Riesgo$ (\"&FIXED(C24,2)&\")\",\"❌ NO coincide con Riesgo$\")","v":"✅ Coincide con Riesgo$ (3,12)"},null,"% del Capital perdido",{"$f":"C13","v":1.5599999999999999E-2},{"$f":"H37/C6","v":1.557198897370653E-2},{"$f":"H38-G38","v":-2.8011026293468799E-5}]
[null,"Verificación: Ganancia si TP se alcanza",{"$f":"C35*C21","v":9.9415148936170201},{"$f":"\"✅ Ganancia potencial = \"&FIXED(C39/C24,2)&\"x tu riesgo\"","v":"✅ Ganancia potencial = 3,19x tu riesgo"},null,"Apalancamiento real usado",{"$f":"C30","v":3.5778528875379938},{"$f":"H36/C14","v":3.5714285714285716},{"$f":"H39-G39","v":-6.424316109422179E-3}]
[]
[{"$nulls":5},{"$f":"IF(H37>G37,\"❌ Por instinto pierdes $\"&FIXED(H37-G37,2)&\" MÁS (\"&FIXED((H38-G38)*100,2)&\"% extra de tu capital)\",\"✅ El instinto resultó más conservador que la fórmula\")","v":"✅ El instinto resultó más conservador que la fórmula"}]
[{"$nulls":5},{"$f":"IF(H37>G37,\"💡 Estarías arriesgando \"&FIXED(H37/G37,1)&\"x lo que deberías según tu regla de \"&FIXED(C13*100,2)&\"%\",\"\")","v":""}]
[]
[null,"TABLA DE SENSIBILIDAD — EXPECTATIVA MATEMÁTICA"]
[null,"E = (WR × R:R) - (1 - WR).  Si E > 0 → sistema rentable a largo plazo"]
[]
[null,"Win Rate ↓ / R:R →",1,1.5,2,2.5,3,3.5,4]
[null,0.25,{"$f":"($B48*C$47)-(1-$B48)","v":-0.5},-0.375,-0.25,-0.125,0,0.125,0.25]
[null,0.3,-0.39999999999999997,-0.25,-9.9999999999999978E-2,5.0000000000000044E-2,0.19999999999999996,0.35000000000000009,0.5]
[null,0.35,-0.30000000000000004,-0.12500000000000011,4.9999999999999933E-2,0.22499999999999998,0.3999999999999998,0.57499999999999984,0.74999999999999989]
[null,0.4,-0.19999999999999996,0,0.20000000000000007,0.4,0.6000000000000002,0.80000000000000016,1]
[null,0.45,-0.10000000000000003,0.125,0.35,0.57499999999999996,0.8,1.0249999999999999,1.25]
[null,0.5,0,0.25,0.5,0.75,1,1.25,1.5]
[null,0.55000000000000004,0.10000000000000009,0.37500000000000011,0.65000000000000013,0.92500000000000004,1.2000000000000002,1.4750000000000003,1.7500000000000002]
[]
[null,"🟢 Verde = Rentable    🔴 Rojo = No rentable    🟡 Borde amarillo = Tu caso base (WR 40%, R:R 2.5)"]
[null,"Tu expectativa: 0.40 → Por cada $1 arriesgado, esperas ganar $0.40 en promedio"]
[null,"💡 Puedes bajar a WR 29% y seguir rentable con R:R 2.5, o bajar R:R a 1.5 y necesitar WR 47%+"]
[]
[]
[null,"ASIMETRÍA DE LA PÉRDIDA — \"La Trampa del Porcentaje\"",null,null,null,"FÓRMULA DE KELLY — \"El Porcentaje Óptimo\""]
[null,"Si tu capital de $1,000 cae un 50%, te quedan $500. Para volver a $1,000 necesitas ganar 100%, no 50%.",null,null,null,"Kelly% = (WR × R:R - (1-WR)) / R:R = Expectativa / R:R"]
[]
[null,"Pérdida %","Capital Restante","Ganancia Necesaria para Recuperar","Factor de Dificultad","Variable","Valor"]
[null,-0.05,{"$f":"1+B65","v":0.95},{"$f":"(1/(1+B65))-1","v":5.2631578947368363E-2},{"$f":"D65/ABS(B65)","v":1.0526315789473673},"Win Rate (WR del Plan)",{"$f":"'Plan de Trading'!T6","v":0.4}]
[null,-0.1,{"$f":"1+B66","v":0.9},{"$f":"(1/(1+B66))-1","v":0.11111111111111116},{"$f":"D66/ABS(B66)","v":1.1111111111111116},"R:R (de esta posición)",{"$f":"C27","v":3.1863829787234041}]
[null,-0.15,0.85,0.17647058823529416,1.1764705882352944]
[null,-0.2,0.8,0.25,1.25,"⭐ Kelly% Óptimo",{"$f":"(G65*G66-(1-G65))/G66","v":0.21169871794871797},{"$f":"IF(G68>0,\"✅ Sistema rentable\",\"❌ NO apuestes — expectativa negativa\")","v":"✅ Sistema rentable"}]
[null,-0.25,0.75,0.33333333333333326,1.333333333333333]
[null,-0.3,0.7,0.4285714285714286,1.4285714285714288,"Tu % Riesgo Actual",{"$f":"C13","v":1.5599999999999999E-2}]
[null,-0.4,0.6,0.66666666666666674,1.6666666666666667,"Half Kelly (recomendado)",{"$f":"G68/2","v":0.10584935897435899}]
[null,-0.5,0.5,1,2,"Quarter Kelly (conservador)",{"$f":"G68/4","v":5.2924679487179493E-2}]
[null,-0.6,0.4,1.5,2.5]
[null,-0.75,0.25,3,4,"¿Dónde estás tú?",{"$f":"IF(G70>G68,\"🚨 POR ENCIMA de Kelly — sobreexpuesto\",IF(G70>G71,\"⚠️ Entre Kelly y Half Kelly\",IF(G70>G72,\"✅ Entre Half y Quarter Kelly (zona óptima)\",\"🛡️ Por debajo de Quarter Kelly (muy conservador)\")))","v":"🛡️ Por debajo de Quarter Kelly (muy conservador)"}]
[null,-0.9,9.9999999999999978E-2,9.0000000000000018,10.000000000000002]
[{"$nulls":5},"💡 LECCIÓN: Kelly dice el MÁXIMO óptimo, no el recomendado."]
[null,"💡 LECCIÓN: Una pérdida del 50% necesita una ganancia del 100% para recuperarse.",null,null,null,"En la práctica se usa Half Kelly (50%) porque el WR real fluctuúa."]
[null,"Por eso el Position Sizing es la PRIMERA línea de defensa: limitar pérdidas al 1-2% mantiene la recuperación fácil.",null,null,null,"Apostar más que Kelly GARANTIZA peor rendimiento a largo plazo."]
[null,"Con tu regla de 1.56%, necesitarías ~44 pérdidas SEGUIDAS para perder 50%. La probabilidad es prácticamente 0."]
[]
[]
[null,"STOP LOSS POR VOLATILIDAD (ATR) — \"Paradas Inteligentes\"",null,null,null,"BREAKEVEN Y GESTIÓN DE PARCIALES"]
[null,"El ATR mide cuánto se mueve el precio en promedio. Un SL basado en ATR respeta la volatilidad real.",null,null,null,"Cómo \"eliminar el riesgo\" de un trade ganador en marcha."]
[]
[null,"ATR del activo (14 períodos)",1850,"Busca este valor en tu gráfico (ATR 14).",null,"Escenario de Gestión Parcial:"]
[null,"Multiplicador ATR",1.5,"1x=ajustado, 1.5x=estándar, 2x=amplio.",null,"% a cerrar en +1R (parcial)",0.5]
[{"$nulls":5},"% restante (corre con SL en BE)",{"$f":"1-G86","v":0.5}]
[null,"SL por ATR (precio)",{"$f":"IF(C10=\"LONG\",C7-C85*C86,C7+C85*C86)","v":72681},"Entry ± (ATR × Multiplicador)"]
[null,"Distancia ATR-SL (%)",{"$f":"ABS(C7-C88)/C7","v":3.6776399491094146E-2},null,null,"Nivel +1R (precio)",{"$f":"IF(C10=\"LONG\",C7+C19,C7-C19)","v":76631},"Entry + 1× distancia SL"]
[{"$nulls":5},"Nivel +2R (precio)",{"$f":"IF(C10=\"LONG\",C7+C19*2,C7-C19*2)","v":77806}]
[null,"Comparación:","Tu SL Manual","SL por ATR",null,"Nivel +3R (precio)",{"$f":"IF(C10=\"LONG\",C7+C19*3,C7-C19*3)","v":78981}]
[null,"Precio SL",{"$f":"C8","v":74281},{"$f":"C88","v":72681}]
[null,"Distancia %",{"$f":"C20","v":1.557198897370653E-2},{"$f":"C89","v":3.6776399491094146E-2},null,"Resultado","Precio toca +1R","Luego vuelve a Entry (BE)","Llega a TP original"]
[null,"Position Size",{"$f":"C34","v":200.35976170212766},{"$f":"C24/C89","v":84.837016216216213},null,"Ganancia del parcial",{"$f":"C24*G86","v":1.5599999999999998},{"$f":"G94","v":1.5599999999999998},{"$f":"G94","v":1.5599999999999998}]
[null,"Veredicto",{"$f":"IF(C93<C89,\"⚠️ Más ajustado que ATR\",\"✅ Respeta volatilidad\")","v":"⚠️ Más ajustado que ATR"},{"$f":"\"🎯 Basado en volatilidad real\"","v":"🎯 Basado en volatilidad real"},null,"Resultado del restante","$0 (aún abierto)",{"$f":"0","v":0},{"$f":"C35*G87*ABS(C9-C7)","v":4.9707574468085101}]
[{"$nulls":5},"⭐ Total Ganancia",{"$f":"G94","v":1.5599999999999998},{"$f":"H94+H95","v":1.5599999999999998},{"$f":"I94+I95","v":6.5307574468085097}]
[null,"💡 Si tu SL manual está MUY dentro del ATR, el ruido del mercado te va a sacar constantemente (\"stop hunting\").",null,null,null,"    vs Pérdida original",{"$f":"\"+\"&FIXED(G96/C24,2)&\"R\"","v":"+0,50R"},{"$f":"\"+\"&FIXED(H96/C24,2)&\"R\"","v":"+0,50R"},{"$f":"\"+\"&FIXED(I96/C24,2)&\"R\"","v":"+2,09R"}]
[]
[{"$nulls":5},"💡 LECCIÓN: Al cerrar 50% en +1R y mover el SL a breakeven:"]
[null,"CHECKLIST PRE-OPERATIVO — GO / NO-GO",null,null,null,"YA ganaste 0.5R y el restante corre \"gratis\" — riesgo eliminado."]
[null,"Antes de abrir CUALQUIER posición, TODOS los checks deben ser ✅.",null,null,null,"El peor escenario ya no es pérdida, sino ganancia de 0.5R. Psicológicamente liberador."]
[]
[null,"#","Requisito","Estado","Regla"]
[null,1,"¿Riesgo ≤ 2% del capital?",{"$f":"IF(C13<=0.02,\"✅ GO\",\"❌ NO-GO\")","v":"✅ GO"},{"$f":"\"Actual: \"&FIXED(C13*100,2)&\"%\"","v":"Actual: 1,56%"}]
[null,2,"¿R:R ≥ 1:2?",{"$f":"IF(C27>=2,\"✅ GO\",\"❌ NO-GO\")","v":"✅ GO"},{"$f":"\"Actual: 1:\"&FIXED(C27,2)","v":"Actual: 1:3,19"}]
[null,3,"¿SL definido ANTES de entrar?",{"$f":"IF(AND(C8<>0,C8<>C7),\"✅ GO\",\"❌ NO-GO\")","v":"✅ GO"},"SL debe estar puesto, no \"mental\"."]
[null,4,"¿Apalancamiento ≤ disponible?",{"$f":"IF(C30<=C15,\"✅ GO\",\"❌ NO-GO\")","v":"✅ GO"},{"$f":"\"Necesitas \"&FIXED(C30,1)&\"x, tienes \"&FIXED(C15,0)&\"x\"","v":"Necesitas 3,6x, tienes 10x"}]
[null,5,"¿Margen cabe en capital asignado?",{"$f":"IF(C36<=C14,\"✅ GO\",\"❌ NO-GO\")","v":"✅ GO"},{"$f":"\"Margen $\"&FIXED(C36,0)&\" vs Capital $\"&FIXED(C14,0)","v":"Margen $20 vs Capital $56"}]
[null,6,"¿SL respeta volatilidad (ATR)?",{"$f":"IF(C20>=C89,\"✅ GO\",\"⚠️ REVISAR\")","v":"⚠️ REVISAR"},{"$f":"\"SL \"&FIXED(C20*100,2)&\"% vs ATR \"&FIXED(C89*100,2)&\"%\"","v":"SL 1,56% vs ATR 3,68%"}]
[null,7,"¿Expectativa matemática positiva?",{"$f":"IF(G68>0,\"✅ GO\",\"❌ NO-GO\")","v":"✅ GO"},{"$f":"\"Kelly=\"&FIXED(G68*100,2)&\"%\"","v":"Kelly=21,17%"}]
[]
[null,null,"VEREDICTO FINAL:",{"$f":"IF(COUNTIF(D104:D110,\"❌ NO-GO\")>0,\"❌ NO-GO (\"&COUNTIF(D104:D110,\"❌ NO-GO\")&\" fallas)\",IF(COUNTIF(D104:D110,\"⚠️ REVISAR\")>0,\"⚠️ GO con precaución\",\"✅ GO — EJECUTAR\"))","v":"⚠️ GO con precaución"}]

{"sheet":"HOLD","index":4,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[[7,0,7,11]]}
["Capital inicial",null,{"$f":"Portafolio!C7","v":800},null,"Retorno Total",null,"Estrategia"]
["Ganancias / Pérdidas",null,{"$f":"C3-C1","v":0},null,{"$f":"IF(C1=0,0,C2/C1)","v":0},{"$f":"C2","v":0},"No rotativa"]
["Valor Actual Portafolio",null,{"$f":"J12+C4","v":800},null,null,null,"Temporalidad"]
["Capital disponible",null,{"$f":"C1-C5","v":800},null,null,null,"1 mes+"]
["Capital invertido",null,{"$f":"E12","v":0}]
["% capital invertido",null,{"$f":"IF(C1=0,0,C5/C1)","v":0}]
[]
["HOLD (no rotativa)"]
["MERCADO","TIPO","ACTIVO","FECHA COMPRA","CAPITAL ASIGNADO","PRECIO ENTRADA","CANTIDAD","PRECIO ACTUAL","P&L (%)","VALOR ACTUAL","P&L ($)","TESIS"]
["CRIPTO","TOKEN","BTC",null,null,null,{"$f":"IFERROR(E10/F10,\"\")","v":""},null,{"$f":"IFERROR((H10-F10)/F10,\"\")","v":""},{"$f":"IFERROR(G10*H10,0)","v":0},{"$f":"IFERROR(J10-E10,\"\")","v":0},"Store of value"]
["CRIPTO","TOKEN","ETH",null,null,null,{"$f":"IFERROR(E11/F11,\"\")","v":""},null,{"$f":"IFERROR((H11-F11)/F11,\"\")","v":""},{"$f":"IFERROR(G11*H11,0)","v":0},{"$f":"IFERROR(J11-E11,\"\")","v":0},"Infraestructura"]
["TOTAL",null,null,null,{"$f":"SUM(E10:E11)","v":0},null,null,null,{"$f":"IFERROR(K12/E12,\"\")","v":""},{"$f":"SUM(J10:J11)","v":0},{"$f":"SUM(K10:K11)","v":0}]

{"sheet":"Largo Plazo","index":5,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[9,0,9,12]]}
["Capital inicial",null,{"$f":"Portafolio!C8","v":600},null,"Meta Ganancia",null,"Maxi pérdida",null,"R:R"]
["Ganancias Mes",null,0,null,{"$f":"C5*2.5","v":3.7499999999999999E-2},{"$f":"E2*C3","v":22.5},{"$f":"C5","v":1.4999999999999999E-2},{"$f":"G2*C3","v":9}]
["Capital disponible",null,{"$f":"C1+C2","v":600}]
["Capital invertido",null,{"$f":"C1-C3","v":0}]
["% Riesgo por trade",null,1.4999999999999999E-2]
["Entrada Pequeña",null,{"$f":"20%","v":0.2},{"$f":"C6*C$3","v":120},{"$f":"D6*E$2","v":4.5},null,{"$f":"D6*G$2","v":1.7999999999999998}]
["Entrada Media",null,{"$f":"40%","v":0.4},{"$f":"C7*C$3","v":240},{"$f":"D7*E$2","v":9},null,{"$f":"D7*G$2","v":3.5999999999999996}]
["Entrada Fuerte",null,{"$f":"60%","v":0.6},{"$f":"C8*C$3","v":360},{"$f":"D8*E$2","v":13.5},null,{"$f":"D8*G$2","v":5.3999999999999995}]
[]
["LARGO PLAZO (ROTACIÓN LENTA)"]
["ACTIVO","FECHA","CAPITAL","ENTRADA","STOP LOSS","TAKE PROFIT","R/R","PRECIO SALIDA","RETORNO %","P&L ($)","DÍAS","ESTADO","TESIS"]
["SOL",{"$nulls":5},{"$f":"IFERROR((F12-D12)/(D12-E12),\"\")","v":""},null,{"$f":"IFERROR((H12-D12)/D12,\"\")","v":""},{"$f":"IFERROR(C12*I12,\"\")","v":""},{"$f":"IF(B12=\"\",\"\",TODAY()-B12)","v":""},"Abierto"]

{"sheet":"Spot X","index":6,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[9,0,9,12]]}
["Capital inicial",null,{"$f":"Portafolio!C9","v":400},null,"Meta Ganancia",null,"Maxi pérdida",null,"R:R"]
["Ganancias Mes",null,0,null,{"$f":"C5*2.5","v":3.7499999999999999E-2},{"$f":"E2*C3","v":15},{"$f":"C5","v":1.4999999999999999E-2},{"$f":"G2*C3","v":6}]
["Capital disponible",null,{"$f":"C1+C2","v":400}]
["Capital invertido",null,{"$f":"C1-C3","v":0}]
["% Riesgo por trade",null,1.4999999999999999E-2]
["Entrada Pequeña",null,{"$f":"20%","v":0.2},{"$f":"C6*C$3","v":80},{"$f":"D6*E$2","v":3},null,{"$f":"D6*G$2","v":1.2}]
["Entrada Media",null,{"$f":"40%","v":0.4},{"$f":"C7*C$3","v":160},{"$f":"D7*E$2","v":6},null,{"$f":"D7*G$2","v":2.4}]
["Entrada Fuerte",null,{"$f":"60%","v":0.6},{"$f":"C8*C$3","v":240},{"$f":"D8*E$2","v":9},null,{"$f":"D8*G$2","v":3.5999999999999996}]
[]
["SPOT X (TRADING SIN APALANCAMIENTO)"]
["ACTIVO","FECHA","CAPITAL","ENTRADA","STOP LOSS","TAKE PROFIT","R/R","SALIDA","RESULTADO %","P&L ($)","DÍAS","CAP. ARRIESGADO","ESTADO"]
["ETH",{"$nulls":5},{"$f":"IFERROR((F12-D12)/(D12-E12),\"\")","v":""},null,{"$f":"IFERROR((H12-D12)/D12,\"\")","v":""},{"$f":"IFERROR(C12*I12,\"\")","v":""},{"$f":"IF(B12=\"\",\"\",TODAY()-B12)","v":""},{"$f":"IFERROR(C12*ABS((D12-E12)/D12),\"\")","v":""},"Abierto"]

{"sheet":"Futuros","index":7,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[9,0,9,12],[1,0,1,1],[5,4,5,5],[6,4,6,5],[7,4,7,5],[5,6,5,7],[6,6,6,7],[7,6,7,7],[2,0,2,1],[3,0,3,1],[4,0,4,1],[0,4,0,5],[0,6,0,7],[6,0,6,1],[7,0,7,1],[5,0,5,1],[0,0,0,1]]}
["Capital inicial",null,{"$f":"Portafolio!C10","v":200},null,"Meta Ganancia Diaria",null,"Maxi perdida Diaria",null,null,"R:R"]
["Ganancias Mes",null,0,null,{"$f":"C5*2.5","v":3.9E-2},{"$f":"E2*C3","v":7.8},{"$f":"C5","v":1.5599999999999999E-2},{"$f":"G2*C3","v":3.1199999999999997},null,"1 : 2.5"]
["Capital disponible",null,{"$f":"C1+C2","v":200},{"$nulls":6},"Win rate"]
["Capital invertido",null,{"$f":"C1-C3","v":0},{"$nulls":6},0.4]
["% Riesgo diario",null,1.5599999999999999E-2]
["Entrada Pequeña",null,{"$f":"20%","v":0.2},{"$f":"C6*C$3","v":40},{"$f":"D6*E$2","v":1.56},null,{"$f":"D6*G$2","v":0.624}]
["Entrada Media",null,{"$f":"40%","v":0.4},{"$f":"C7*C$3","v":80},{"$f":"D7*E$2","v":3.12},null,{"$f":"D7*G$2","v":1.248}]
["Entrada Fuerte",null,{"$f":"60%","v":0.6},{"$f":"C8*C$3","v":120},4.68,null,1.8719999999999999]
[]
["FUTUROS APALANCADO"]
["ACTIVO","TIMEFRAME","RIESGO %","CAPITAL","ENTRADA","STOP LOSS","TAKE PROFIT","R/R"]
["BTC","1h",1.55E-2,{"$f":"C1*C7","v":80},75456,74281,79200,{"$f":"(G12-E12)/(E12-F12)","v":3.1863829787234041},{"$f":"D12*10","v":800},{"$f":"I12*C12","v":12.4},{"$f":"I12*C12*2.5","v":31}]
[]
["Activo","Dirección\nLong / Short","Capital usado (%)\n20%, 40%, 60%","Capital usado (USD)","Precio entrada","Stop Loss","Take Profit","Distancia al SL (%)","Capital Arriesgado (USD)","Tamaño posición (USD nocional)","Tamaño posición (contrato/USD)","Apalancamiento requerido","R/R"]
["BTC","Long",0.4,{"$f":"C15*C3","v":80},75456,74281,79200,{"$f":"IF(B15=\"LONG\", (E15-F15)/E15, (F15-E15)/E15)","v":1.557198897370653E-2},{"$f":"D15*H15","v":1.2457591178965224},{"$f":"H2/H15","v":200.35976170212766},{"$f":"J15/D15","v":2.5044970212765958},{"$f":"J15/D15","v":2.5044970212765958}]

{"sheet":"PLANTILLA","index":8,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Capital inicial",null,0,null,"Meta Ganancia",null,"Maxi pérdida",null,"R:R"]
["Ganancias Mes",null,0,null,{"$f":"C5*2.5","v":3.7499999999999999E-2},{"$f":"E2*C3","v":0},{"$f":"C5","v":1.4999999999999999E-2},{"$f":"G2*C3","v":0},7.2337962962963002E-4]
["Capital disponible",null,{"$f":"C1+C2","v":0},{"$nulls":5},"Win rate"]
["Capital invertido",null,{"$f":"C1-C3","v":0},{"$nulls":5},0.4]
["% Riesgo por trade",null,1.4999999999999999E-2]
["Entrada Pequeña",null,{"$f":"20%","v":0.2},{"$f":"C6*C$3","v":0},{"$f":"D6*E$2","v":0},null,{"$f":"D6*G$2","v":0}]
["Entrada Media",null,{"$f":"40%","v":0.4},{"$f":"C7*C$3","v":0},{"$f":"D7*E$2","v":0},null,{"$f":"D7*G$2","v":0}]
["Entrada Fuerte",null,{"$f":"60%","v":0.6},{"$f":"C8*C$3","v":0},{"$f":"D8*E$2","v":0},null,{"$f":"D8*G$2","v":0}]
[]
["NUEVA ESTRATEGIA (NOMBRE)"]
["ACTIVO","FECHA","CAPITAL","ENTRADA","STOP LOSS","TAKE PROFIT","R/R","SALIDA","RESULTADO %","P&L ($)","DÍAS","CAP. ARRIESGADO","ESTADO"]
[{"$nulls":6},{"$f":"IFERROR((F12-D12)/(D12-E12),\"\")","v":""},null,{"$f":"IFERROR((H12-D12)/D12,\"\")","v":""},{"$f":"IFERROR(C12*I12,\"\")","v":""},{"$f":"IF(B12=\"\",\"\",TODAY()-B12)","v":""},{"$f":"IFERROR(C12*ABS((D12-E12)/D12),\"\")","v":""},"Abierto"]