{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Video","Formula","VBA"],"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":"Video","index":0,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Use of Formula"]
[]
[null,"Months","Actual Returns\nRp","Excess Return","Negative Excess Return","(Negative Excess Return)2"]
[null,1,0.05,{"$f":"C5-$C$13","v":-2.0000000000000004E-2},{"$f":"IF(D5<0,D5,0)","v":-2.0000000000000004E-2},{"$f":"E5^2","v":4.0000000000000018E-4}]
[null,2,-0.1,-0.17,{"$f":"IF(D6<0,D6,0)","v":-0.17},{"$f":"E6^2","v":2.8900000000000006E-2}]
[null,3,0.09,1.999999999999999E-2,0,0]
[null,4,0.17,0.1,0,0]
[null,5,-0.03,-0.1,-0.1,1.0000000000000002E-2]
[null,6,-0.02,-9.0000000000000011E-2,-9.0000000000000011E-2,8.1000000000000013E-3]
[null,"Total",null,null,null,{"$f":"SUM(F5:F10)","v":4.7400000000000012E-2}]
[]
[null,"Risk Free\nReturn, Rf",7.0000000000000007E-2]
[null,"Downside Variance (DV)",{"$f":"F11/6","v":7.9000000000000025E-3}]
[null,"Downside Deviation (DD)",{"$f":"SQRT(C14)","v":8.8881944173155897E-2}]
[null,"Sortino Ration",{"$f":"(C7-C13)/C15","v":0.22501758018520465}]

{"sheet":"Formula","index":1,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Use of Formula"]
[]
[null,"Months","Actual Returns\nRp","Excess Return","Negative Excess Return","(Negative Excess Return)2"]
[null,1,0.05,{"$f":"C5-$C$13","v":-2.0000000000000004E-2},{"$f":"IF(D5<0,D5,0)","v":-2.0000000000000004E-2},{"$f":"E5^2","v":4.0000000000000018E-4}]
[null,2,-0.1,-0.17,{"$f":"IF(D6<0,D6,0)","v":-0.17},{"$f":"E6^2","v":2.8900000000000006E-2}]
[null,3,0.09,1.999999999999999E-2,0,0]
[null,4,0.17,0.1,0,0]
[null,5,-0.03,-0.1,-0.1,1.0000000000000002E-2]
[null,6,-0.02,-9.0000000000000011E-2,-9.0000000000000011E-2,8.1000000000000013E-3]
[null,"Total",null,{"$f":"SUM(D5:D10)","v":-0.26},{"$f":"SUM(E5:E10)","v":-0.38000000000000006},{"$f":"SUM(F5:F10)","v":4.7400000000000012E-2}]
[]
[null,"Risk Free\nReturn, Rf",7.0000000000000007E-2]
[null,"Downside Variance (DV)",{"$f":"D11/6","v":-4.3333333333333335E-2}]
[null,"Downside Deviation (DD)",{"$f":"SQRT(F11/6)","v":8.8881944173155897E-2}]
[null," Sortino Ration",{"$f":"C14/C15","v":-0.48753809040127699}]

{"sheet":"VBA","index":2,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of VBA"]
[]
[null,"Month","Actual Return\nRp"]
[null,1,0.05]
[null,2,-0.1]
[null,3,0.09]
[null,4,0.17]
[null,5,-0.03]
[null,6,-0.02]
[]
[null,"Expected Return",7.0000000000000007E-2]
[null,"Sortino Ration",{"$f":"SortinoRatio(C5:C10,C12)","v":-0.48753809040127699}]