{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sec. 9.5 Ex2","Portfolio Frontier","E(r), s.d., and correlation"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":68,"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":"Sec. 9.5 Ex2","index":0,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"coef. for x_1","coef. for x_2","coef. for x_3","Result"]
["Objective Function",4,2,1,{"$f":"SUMPRODUCT(B3:D3,$B$8:$D$8)","v":1.9999999999999996}]
["C1",2,3,4,{"$f":"SUMPRODUCT(B4:D4,$B$8:$D$8)","v":7.9999999999999982},"<=",14,null,null,"s_1 =",{"$f":"G4-E4","v":6.0000000000000018}]
["C2",3,1,5,{"$f":"SUMPRODUCT(B5:D5,$B$8:$D$8)","v":9.9999999999999982},">=",4,null,null,"s_2 = ",{"$f":"E5-G5","v":5.9999999999999982}]
["C3",1,4,3,{"$f":"SUMPRODUCT(B6:D6,$B$8:$D$8)","v":5.9999999999999982},">=",6,null,null,"s_3 =",{"$f":"E6-G6","v":0}]
[]
["Solutions for x_1, x_2, and x_3",0,0,1.9999999999999996]

{"sheet":"Portfolio Frontier","index":1,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,"E(r_i) = ",0.1,0.06,0.2]
[null,"coef. 1","coef.2","coef. 3","Result",null,null,null,"sigma(r_i) =",0.2,0.1,0.3]
["Objectinve Function",null,null,null,{"$f":"(B7*B7*B9+C7*C7*C10+D7*D7*D11+2*B7*C7*C9+2*B7*D7*D9+2*C7*D7*D10)^0.5","v":0.29538200520139157},null,null,null,"correlation =",1,0.5,0.8]
["C1",0.1,0.06,0.2,{"$f":"SUMPRODUCT(B4:D4,$B$7:$D$7)","v":0.20000000049012623},"=",0.2,null,null,null,1,0.7]
["C2",1,1,1,{"$f":"SUMPRODUCT(B5:D5,$B$7:$D$7)","v":0.99999999999999978},"=",1,null,null,null,null,1]
[null,null,null,null,null,null,null,null,"(derived according to the annualized adjusted returns in the historical data)"]
["Solution Value (weights)",-0.37737839897376457,0.26955599576607281,1.1078224032076915]
[]
["variance-covariance",{"$f":"0.2^2","v":4.0000000000000008E-2},{"$f":"0.5*0.2*0.1","v":1.0000000000000002E-2},{"$f":"0.8*0.2*0.3","v":4.8000000000000008E-2}]
[null,{"$f":"C9","v":1.0000000000000002E-2},{"$f":"0.1^2","v":1.0000000000000002E-2},{"$f":"0.7*0.1*0.3","v":2.0999999999999998E-2}]
[null,{"$f":"D9","v":4.8000000000000008E-2},{"$f":"D10","v":2.0999999999999998E-2},{"$f":"0.3^2","v":0.09}]
[]
[]
[]
[]
[]
[]
[null,"E(r_p)","sigma(r_p)"]
[null,0,9.0681003164502463E-2]
[null,0.01,8.4249980738170888E-2]
[null,0.02,8.0668538908602067E-2]
[null,0.03,8.031880195252096E-2]
[null,0.04,8.3241669337317831E-2]
[null,0.05,8.9115688260062567E-2]
[null,0.06,9.7408318340964459E-2]
[null,7.0000000000000007E-2,0.10756162548744402]
[null,0.08,0.11910075383616477]
[null,0.09,0.13166180537443323]
[null,0.1,0.14497941358510164]
[null,0.11,0.15886339864255555]
[null,0.12,0.1731776147762672]
[null,0.13,0.18782371726750957]
[null,0.14000000000000001,0.20272978598519031]
[null,0.15,0.21784246277174515]
[null,0.16,0.23312156994327679]
[null,0.17,0.24853641418644526]
[null,0.18,0.26406322600824739]
[null,0.19,0.27968335770046787]
[null,0.2,0.29538200520139157]

{"sheet":"E(r), s.d., and correlation","index":2,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["daily return","r1","r2","r3"]
[null,1E-3,-0.03,3.0000000000000001E-3]
[null,-0.03,7.0000000000000001E-3,-3.5000000000000003E-2]
[null,0.04,7.0000000000000001E-3,1.4999999999999999E-2]
[null,1.4999999999999999E-2,3.0000000000000001E-3,6.0000000000000001E-3]
[null,-0.04,0.02,1E-3]
[]
["annual E(r_i)",{"$f":"AVERAGE(B2:B6)*250","v":-0.69999999999999984},{"$f":"AVERAGE(C2:C6)*250","v":0.34999999999999992},{"$f":"AVERAGE(D2:D6)*250","v":-0.50000000000000011}]
["annual sigma_i",{"$f":"STDEV(B2:B6)*SQRT(250)","v":0.51761472158353461},{"$f":"STDEV(C2:C6)*SQRT(250)","v":0.29550803711574408},{"$f":"STDEV(D2:D6)*SQRT(205)","v":0.2750363612324741}]
["correlation_ij",{"$f":"CORREL(B2:B6,B2:B6)","v":1},{"$f":"CORREL(B2:B6,C2:C6)","v":-0.28414419428577098},{"$f":"CORREL(B2:B6,D2:D6)","v":0.66589387716095161}]
[null,{"$f":"C10","v":-0.28414419428577098},{"$f":"CORREL(C2:C6,C2:C6)","v":0.99999999999999978},{"$f":"CORREL(C2:C6,D2:D6)","v":-0.1239502865413068}]
[null,{"$f":"D10","v":0.66589387716095161},{"$f":"D11","v":-0.1239502865413068},{"$f":"CORREL(D2:D6,D2:D6)","v":1}]