{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["CALCULADORA","DATOS"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"CALCULADORA","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"merged":[[0,9,0,10]]}
[{"$nulls":9},"CONVENCIONES"]
[null,"CAPITAL A INVERTIR",0,{"$nulls":6},">>>>>","Celdas que se pueden cambiar y digitar valores numericos."]
[{"$nulls":9},">>>>>","Celdas para elejir opciones que estan listadas.  No digitar nada"]
[null,"PORTAFOLIOS","VALOR"]
[null,"BAJO RIESGO",{"$f":"IF(C2>=3000,ROUND(C2*66.6667%,0),IF(C2<100,0,C2))","v":0}]
[null,"ALTO RIESGO",{"$f":"IF(C2>=3000,C2-C5,0)","v":0}]
[]
[]
[null,"PORT. BAJO RIESGO "]
[null,"PORTAFOLIO",{"$nulls":5},"#","PORTAFOLIO","NOMBRE","CAPITAL","UTILIDAD ANUAL ","DROWDOWN"]
[null,"CAPITAL",0]
[null,"UTILIDAD ANUAL",{"$nulls":5},"Total",null,null,{"$f":"SUBTOTAL(109,folios[CAPITAL])","v":0},{"$f":"SUBTOTAL(109,folios[[UTILIDAD ANUAL ]])","v":0},{"$f":"SUBTOTAL(109,folios[DROWDOWN])","v":0}]
[null,"TIPO PORTAFOLIO",{"$nulls":7},"RELACION PORTAFOLIO","CAPITAL INVERTIDO","U. PROM. MES","PROM. DROWDOWN"]
[null,"DROWDOWN ANUAL",{"$nulls":7},{"$f":"IF(folios[[#Totals],[CAPITAL]]=0,0 & \" x\",ROUND(folios[[#Totals],[UTILIDAD ANUAL ]]/folios[[#Totals],[DROWDOWN]],2) & \" X\")","v":"0 x"},{"$f":"folios[[#Totals],[CAPITAL]]","v":0},{"$f":"folios[[#Totals],[UTILIDAD ANUAL ]]/10","v":0},{"$f":"IF(folios[[#Totals],[CAPITAL]]=0,0,folios[[#Totals],[DROWDOWN]]/folios[[#Totals],[CAPITAL]])","v":{"v":0,"d":"0.00%"}}]
[null,"STOP OUT"]
[null,"INVERSIÓN MINIMA"]
[]
[null,"PORT. ALTO RIESGO "]
[null,"PORTAFOLIO"]
[null,"CAPITAL",0]
[null,"UTILIDAD ANUAL"]
[null,"TIPO PORTAFOLIO"]
[null,"DROWDOWN ANUAL"]
[null,"STOP OUT"]
[null,"INVERSIÓN MINIMA"]

{"sheet":"DATOS","index":1,"n_rows":12,"n_cols":12,"rows_kept":12,"hidden":true,"merged":[[0,9,0,11],[1,9,2,9],[3,9,4,9]]}
["PORTAFOLIO","RIESGO","TIPO","NOMBRE","CAP. MINIMO","U ANUAL","DROW ANUAL","SO",null,"CONVENCIONES"]
[1,1,1,"METALES: ORO LR / 2.5K",{"v":2500,"d":"USD 2,500"},{"v":1.298,"d":"129.80%"},{"v":0.1811,"d":"18.11%"},{"v":0.4,"d":"40.00%"},null,"RIESGO",1,"BAJO"]
[2,1,1,"METALES: ORO LR / 10K",{"v":10000,"d":"USD 10,000"},{"v":1.937,"d":"193.70%"},{"v":0.2472,"d":"24.72%"},{"v":0.4,"d":"40.00%"},null,null,2,"ALTO"]
[3,1,1,"METALES: ORO LR / 25K",{"v":25000,"d":"USD 25,000"},{"v":0.3876,"d":"38.76%"},{"v":0.063,"d":"6.30%"},{"v":0.15,"d":"15.00%"},null,"TIPO",1,"ALGORITMICOS"]
[4,2,1,"METALES: ORO HR / 1K",{"v":1000,"d":"USD 1,000"},{"v":3.229,"d":"322.90%"},{"v":0.3492,"d":"34.92%"},{"v":0.8,"d":"80.00%"},null,null,2,"COPY"]
[5,2,1,"METALES: ORO HR / 10K",{"v":10000,"d":"USD 10,000"},{"v":4.844,"d":"484.40%"},{"v":0.4401,"d":"44.01%"},{"v":0.8,"d":"80.00%"}]
[6,1,1,"FOREX: EURJPY LR / 2K",{"v":2000,"d":"USD 2,000"},{"v":0.82,"d":"82.00%"},{"v":0.1863,"d":"18.63%"},{"v":0.4,"d":"40.00%"}]
[7,1,1,"FOREX: EURJPY LR / 10K",{"v":10000,"d":"USD 10,000"},{"v":0.9859,"d":"98.59%"},{"v":0.2186,"d":"21.86%"},{"v":0.4,"d":"40.00%"}]
[8,1,1,"FOREX: EURJPY LR / 25K",{"v":25000,"d":"USD 25,000"},{"v":0.263,"d":"26.30%"},{"v":0.0635,"d":"6.35%"},{"v":0.15,"d":"15.00%"}]
[9,2,1,"FOREX: EURJPY HR / 1K",{"v":1000,"d":"USD 1,000"},{"v":1.6425,"d":"164.25%"},{"v":0.3391,"d":"33.91%"},{"v":0.8,"d":"80.00%"}]
[10,2,1,"FOREX: EURJPY HR / 10K",{"v":10000,"d":"USD 10,000"},{"v":2.1364,"d":"213.64%"},{"v":0.4191,"d":"41.91%"},{"v":0.8,"d":"80.00%"}]
[11,1,2,"FOREX: INVICTUXTRADE",{"v":100,"d":"USD 100"},{"v":0.7,"d":"70.00%"},{"v":0.15,"d":"15.00%"},{"v":0.4,"d":"40.00%"}]