{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Año1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Año1","index":0,"n_rows":47,"n_cols":50,"rows_kept":47,"cut":false,"hidden":false,"merged":[[27,1,27,2],[1,1,1,2],[3,1,3,5],[3,6,3,9],[3,10,3,13],[3,14,3,17],[25,1,25,4],[25,6,25,8],[25,10,25,12],[25,14,25,16],[3,18,3,21],[25,18,25,20],[3,22,3,25],[25,22,25,24],[3,26,3,29],[25,26,25,28],[3,42,3,45],[25,42,25,44],[3,46,3,49],[25,46,25,48],[3,30,3,33],[25,30,25,32],[3,34,3,37],[25,34,25,36],[3,38,3,41],[25,38,25,40]]}
[]
[null,"MONTO DEL PORTAFOLIO",null,null,1000]
[]
[null,"MES 1",null,null,null,null,"MES 2",null,null,null,"MES 3",null,null,null,"MES 4",null,null,null,"MES 5",null,null,null,"MES 6",null,null,null,"MES 7",null,null,null,"MES 8",null,null,null,"MES 9",null,null,null,"MES 10",null,null,null,"MES 11",null,null,null,"MES 12"]
[null,"Cantidad Invertida","Utilidad",null,"Peso de la transacción","Índice Retorno","Cantidad Invertida","Utilidad","Peso de la transacción","Índice Retorno","Cantidad Invertida","Utilidad","Peso de la transacción","Índice Retorno","Cantidad Invertida","Utilidad","Peso de la transacción","Índice Retorno","Cantidad Invertida","Utilidad","Peso de la transacción","Índice Retorno","Cantidad Invertida","Utilidad","Peso de la transacción","Índice Retorno","Cantidad Invertida","Utilidad","Peso de la transacción","Índice Retorno","Cantidad Invertida","Utilidad","Peso de la transacción","Índice Retorno","Cantidad Invertida","Utilidad","Peso de la transacción","Índice Retorno","Cantidad Invertida","Utilidad","Peso de la transacción","Índice Retorno","Cantidad Invertida","Utilidad","Peso de la transacción","Índice Retorno","Cantidad Invertida","Utilidad","Peso de la transacción","Índice Retorno"]
[1,null,null,null,{"$f":"(IF(B6=0,0,B6/$E$2))","v":0},{"$f":"IF(C6=0,0,C6*E6)","v":0},null,null,{"$f":"(IF(G6=0,0,G6/$E$2))","v":0},{"$f":"IF(H6=0,0,H6*I6)","v":0},null,null,{"$f":"(IF(K6=0,0,K6/$E$2))","v":0},{"$f":"IF(L6=0,0,L6*M6)","v":0},null,null,{"$f":"(IF(O6=0,0,O6/$E$2))","v":0},{"$f":"IF(P6=0,0,P6*Q6)","v":0},null,null,{"$f":"(IF(S6=0,0,S6/$E$2))","v":0},{"$f":"IF(T6=0,0,T6*U6)","v":0},null,null,{"$f":"(IF(W6=0,0,W6/$E$2))","v":0},{"$f":"IF(X6=0,0,X6*Y6)","v":0},null,null,{"$f":"(IF(AA6=0,0,AA6/$E$2))","v":0},{"$f":"IF(AB6=0,0,AB6*AC6)","v":0},null,null,{"$f":"(IF(AE6=0,0,AE6/$E$2))","v":0},{"$f":"IF(AF6=0,0,AF6*AG6)","v":0},null,null,{"$f":"(IF(AI6=0,0,AI6/$E$2))","v":0},{"$f":"IF(AJ6=0,0,AJ6*AK6)","v":0},null,null,{"$f":"(IF(AM6=0,0,AM6/$E$2))","v":0},{"$f":"IF(AN6=0,0,AN6*AO6)","v":0},null,null,{"$f":"(IF(AQ6=0,0,AQ6/$E$2))","v":0},{"$f":"IF(AR6=0,0,AR6*AS6)","v":0},null,null,{"$f":"(IF(AU6=0,0,AU6/$E$2))","v":0},{"$f":"IF(AV6=0,0,AV6*AW6)","v":0}]
[2,null,null,null,{"$f":"(IF(B7=0,0,B7/$E$2))","v":0},{"$f":"IF(C7=0,0,C7*E7)","v":0},null,null,{"$f":"(IF(G7=0,0,G7/$E$2))","v":0},{"$f":"IF(H7=0,0,H7*I7)","v":0},null,null,{"$f":"(IF(K7=0,0,K7/$E$2))","v":0},{"$f":"IF(L7=0,0,L7*M7)","v":0},null,null,{"$f":"(IF(O7=0,0,O7/$E$2))","v":0},{"$f":"IF(P7=0,0,P7*Q7)","v":0},null,null,{"$f":"(IF(S7=0,0,S7/$E$2))","v":0},{"$f":"IF(T7=0,0,T7*U7)","v":0},null,null,{"$f":"(IF(W7=0,0,W7/$E$2))","v":0},{"$f":"IF(X7=0,0,X7*Y7)","v":0},null,null,{"$f":"(IF(AA7=0,0,AA7/$E$2))","v":0},{"$f":"IF(AB7=0,0,AB7*AC7)","v":0},null,null,{"$f":"(IF(AE7=0,0,AE7/$E$2))","v":0},{"$f":"IF(AF7=0,0,AF7*AG7)","v":0},null,null,{"$f":"(IF(AI7=0,0,AI7/$E$2))","v":0},{"$f":"IF(AJ7=0,0,AJ7*AK7)","v":0},null,null,{"$f":"(IF(AM7=0,0,AM7/$E$2))","v":0},{"$f":"IF(AN7=0,0,AN7*AO7)","v":0},null,null,{"$f":"(IF(AQ7=0,0,AQ7/$E$2))","v":0},{"$f":"IF(AR7=0,0,AR7*AS7)","v":0},null,null,{"$f":"(IF(AU7=0,0,AU7/$E$2))","v":0},{"$f":"IF(AV7=0,0,AV7*AW7)","v":0}]
[3,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[4,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[5,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[6,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[7,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[8,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[9,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[10,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[11,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[12,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[13,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[14,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[15,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[16,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[17,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[18,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[19,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[20,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[null,"TOTAL MES 1",null,null,null,{"$f":"SUM(F6:F25)","v":0},"TOTAL MES 2",null,null,{"$f":"SUM(J6:J25)","v":0},"TOTAL MES 3",null,null,{"$f":"SUM(N6:N25)","v":0},"TOTAL MES 4",null,null,{"$f":"SUM(R6:R25)","v":0},"TOTAL MES 5",null,null,{"$f":"SUM(V6:V25)","v":0},"TOTAL MES 6",null,null,{"$f":"SUM(Z6:Z25)","v":0},"TOTAL MES 7",null,null,{"$f":"SUM(AD6:AD25)","v":0},"TOTAL MES 8",null,null,{"$f":"SUM(AH6:AH25)","v":0},"TOTAL MES 9",null,null,{"$f":"SUM(AL6:AL25)","v":0},"TOTAL MES 10",null,null,{"$f":"SUM(AP6:AP25)","v":0},"TOTAL MES 11",null,null,{"$f":"SUM(AT6:AT25)","v":0},"TOTAL MES 12",null,null,{"$f":"SUM(AX6:AX25)","v":0}]
[]
[null,"ÍNDICE TOTAL ANUAL",null,null,{"$f":"F26+J26+N26+R26+V26+Z26+AD26+AH26+AL26+AP26+AT26+AX26","v":0}]
[]
["Calculando la tasa Sortino"]
[]
[]
["Mes","Retorno","Exceso de Retorno","Exceso de Retorno Negativo"]
[1,{"$f":"F26","v":0},{"$f":"B34-$G$37","v":-0.05},{"$f":"IF(C34<0,C34,0)","v":-0.05}]
[2,{"$f":"J26","v":0},-0.05,-0.05]
[3,{"$f":"N26","v":0},-0.05,-0.05]
[4,{"$f":"R26","v":0},-0.05,-0.05,null,"Retorno mínimo deseado",0.05]
[5,{"$f":"V26","v":0},-0.05,-0.05,null,"Riesgo Negativo",{"$f":"(SUMSQ(D34:D45)/12)^0.5","v":5.000000000000001E-2}]
[6,{"$f":"Z26","v":0},-0.05,-0.05,null,"Exceso de retorno",{"$f":"AVERAGE(C34:C45)","v":-4.9999999999999996E-2}]
[7,{"$f":"AD26","v":0},-0.05,-0.05,null,"Sortino Ratio",{"$f":"G39/G38","v":-0.99999999999999978}]
[8,{"$f":"AH26","v":0},-0.05,-0.05]
[9,{"$f":"AL26","v":0},-0.05,-0.05]
[10,{"$f":"AP26","v":0},-0.05,-0.05]
[11,{"$f":"AT26","v":0},-0.05,-0.05]
[12,{"$f":"AX26","v":0},-0.05,-0.05]
[]
["www.SubmarinoBursatil.com"]