{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["- AYUDA -","VaR Monte Carlo","VaR Paramétrico"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":2,"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":"- AYUDA -","index":0,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Ayuda"]

{"sheet":"VaR Monte Carlo","index":1,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[3,1,3,2],[3,3,3,4],[6,5,7,5]]}
[]
[]
[null,"Ingrese los datos de abajo para obtener el valor en riesgo"]
[null,"Simulación Montecarlo"]
[]
[null,"Valor de la acción",10000]
[null,"Desvío estándar",0.1,null,null,{"$f":"Valor_Riesgo(C8,C9,C10,C7,C6)","v":{"$error":"#NAME?"}}]
[null,"Nivel de confianza",0.99]
[null,"Horizonte temporal",22,null,null,"Valor en Riesgo"]
[null,"Tasa libre de riesgo",0.04]
[]
[]
[null,{"$f":"\"Partiendo de una inversión inicial de \"&TEXT(C6,\"$0.00\")& \" en el plazo de \"&C9&\" días tienes un \"&TEXT(1-C8,\"0,00%\")&\" de probabilidad de perder \"&TEXT(F7,\"$0.00\")","v":{"$error":"#NAME?"}}]

{"sheet":"VaR Paramétrico","index":2,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[3,1,3,2],[3,3,3,4]]}
[]
[]
[null,"Ingrese los datos de abajo para obtener el valor en riesgo"]
[null,"Paramétrico"]
[null,"Valor del portafolio",10000,null,"Mínimo retorno esperado",{"$f":"_xlfn.NORM.INV(1-C8,C6,C7)","v":-0.18263478740408406}]
[null,"Retorno Esperado",0.05,null,"Valor del portafolio",{"$f":"C5*(1+F5)","v":8173.6521259591591}]
[null,"Desviación estándar",0.1,null,"Valor en Riesgo",{"$f":"(C5-F6)*SQRT(C9)","v":8566.3308513211759}]
[null,"Nivel de confianza",0.99]
[null,"Días",22]
[]
[null,{"$f":"\"Partiendo de una inversión inicial de \"&TEXT(C5,\"$0.00\")& \" en el plazo de \"&C9&\" días tienes un \"&TEXT(1-C8,\"0,00%\")&\" de probabilidad de perder \"&TEXT(F7,\"$0.00\")","v":"Partiendo de una inversión inicial de $10.000 en el plazo de 22 días tienes un 1,00% de probabilidad de perder $8.566"}]