{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["兩種","三種"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":26,"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":"兩種","index":0,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,"報酬率","標準差",null,null,"Stock A權數","Stock B權數","投資組合標準差","投資組合報酬率"]
["Stock A",0.11,0.14000000000000001,null,null,0,{"$f":"1-F2","v":1},{"$f":"SQRT((F2*$C$2)^2+(G2*$C$3)^2+2*$B$4*F2*$C$2*G2*$C$3)","v":0.08},{"$f":"F2*$B$2+G2*$B$3","v":7.0000000000000007E-2}]
["Stock B",7.0000000000000007E-2,0.08,null,null,0.05,{"$f":"1-F3","v":0.95},{"$f":"SQRT((F3*$C$2)^2+(G3*$C$3)^2+2*$B$4*F3*$C$2*G3*$C$3)","v":7.6321687612368738E-2},{"$f":"F3*$B$2+G3*$B$3","v":7.2000000000000008E-2}]
["相關係數",{"$f":"(C4-100)/100","v":0},100,null,null,0.1,0.9,7.3348483283568994E-2,7.400000000000001E-2]
[null,null,null,null,null,0.15,0.85,7.1168813394632352E-2,7.6000000000000012E-2]
[null,null,null,null,null,0.2,0.8,6.9856996786291925E-2,7.8000000000000014E-2]
[null,null,null,null,null,0.25,0.75,6.9462219947249021E-2,0.08]
[null,null,null,null,null,0.3,0.7,6.9999999999999993E-2,8.2000000000000003E-2]
[null,null,null,null,null,0.35,0.65,7.1449282711585016E-2,8.4000000000000005E-2]
[null,null,null,null,null,0.4,0.6,7.3756355658343098E-2,8.6000000000000007E-2]
[null,null,null,null,null,0.45,0.55000000000000004,7.6843997813752521E-2,8.8000000000000009E-2]
[null,null,null,null,null,0.5,0.5,8.06225774829855E-2,0.09]
[null,null,null,null,null,0.55000000000000004,0.44999999999999996,8.500000000000002E-2,9.1999999999999998E-2]
[null,null,null,null,null,0.6,0.4,8.9888820216976931E-2,9.4E-2]
[null,null,null,null,null,0.65,0.35,9.5210293561148115E-2,9.6000000000000002E-2]
[null,null,null,null,null,0.7,0.30000000000000004,0.10089598604503551,9.8000000000000004E-2]
[null,null,null,null,null,0.75,0.25,0.10688779163215975,0.1]
[null,null,null,null,null,0.8,0.19999999999999996,0.11313708498984762,0.10200000000000001]
[null,null,null,null,null,0.85,0.15000000000000002,0.11960351165413163,0.10400000000000001]
[null,null,null,null,null,0.9,9.9999999999999978E-2,0.12625371281669306,0.10600000000000001]
[null,null,null,null,null,0.95,5.0000000000000044E-2,0.13306013678032952,0.108]
[null,null,null,null,null,1,0,0.14000000000000001,0.11]

{"sheet":"三種","index":1,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["變異數共變數矩陣","Stock A","Stock B","Stock C",null,"預期報酬率","個股標準差"]
["Stock A",{"$f":"G2^2","v":8.0999999999999996E-3},{"$f":"B7*G2*G3","v":0},{"$f":"B8*G2*G4","v":0},"Stock A",0.08,0.09]
["Stock B",{"$f":"C2","v":0},{"$f":"G3^2","v":1.0000000000000002E-2},{"$f":"B9*G3*G4","v":0},"Stock B",0.09,0.1]
["Stock C",{"$f":"D2","v":0},{"$f":"D3","v":0},{"$f":"G4^2","v":1.21E-2},"Stock C",0.1,0.11]
[]
[null,"相關係數"]
["Stock AB",{"$f":"(C7-100)/100","v":0},100]
["Stock AC",{"$f":"(C8-100)/100","v":0},100]
["Stock BC",0,100,null,null,"Min"]
["Stock A權重","Stock B權重","Stock C權重","權重加總","最低報酬","投資組合標準差","投資組合預期報酬"]
[0.40331982758506124,0.32668928107831313,0.26999089133662535,{"$f":"SUM(A11:C11)","v":0.99999999999999978},0.08,{"$f":"SQRT(A11^2*$B$2+B11^2*$C$3+C11^2*$D$4+2*A11*B11*$C$2+2*A11*C11*$D$2+2*B11*C11*$D$3)","v":5.7156724045647887E-2},{"$f":"A11*$F$2+B11*$F$3+C11*$F$4","v":8.8666710637515606E-2}]
[0.40331982758506124,0.32668928107831313,0.26999089133662535,{"$f":"SUM(A12:C12)","v":0.99999999999999978},8.1000000000000003E-2,{"$f":"SQRT(A12^2*$B$2+B12^2*$C$3+C12^2*$D$4+2*A12*B12*$C$2+2*A12*C12*$D$2+2*B12*C12*$D$3)","v":5.7156724045647887E-2},8.8666710637515606E-2]
[0.40331982758506124,0.32668928107831313,0.26999089133662535,0.99999999999999978,8.2000000000000003E-2,5.7156724045647887E-2,8.8666710637515606E-2]
[0.40331982758506124,0.32668928107831313,0.26999089133662535,0.99999999999999978,8.3000000000000004E-2,5.7156724045647887E-2,8.8666710637515606E-2]
[0.40331982758506124,0.32668928107831313,0.26999089133662535,0.99999999999999978,8.4000000000000005E-2,5.7156724045647887E-2,8.8666710637515606E-2]
[0.40331982758506124,0.32668928107831313,0.26999089133662535,{"$f":"SUM(A16:C16)","v":0.99999999999999978},8.5000000000000006E-2,5.7156724045647887E-2,8.8666710637515606E-2]
[0.40331982758506124,0.32668928107831313,0.26999089133662535,0.99999999999999978,8.5999999999999993E-2,5.7156724045647887E-2,8.8666710637515606E-2]
[0.40331982758506124,0.32668928107831313,0.26999089133662535,0.99999999999999978,8.6999999999999994E-2,5.7156724045647887E-2,8.8666710637515606E-2]
[0.40332028846713008,0.32668945145709893,0.26999126007577084,1.0000009999999999,8.7999999999999995E-2,5.715678120236789E-2,8.8666799716086403E-2]
[0.38555330507347885,0.3289033957477524,0.28554429917876867,1.0000009999999999,8.8999999999999996E-2,5.7205161454848448E-2,8.8999999941052885E-2]
[0.33223103735396509,0.33554792655242599,0.33222203609360867,1.0000009999999997,0.09,5.7926474751408795E-2,8.9999999987396412E-2]
[0.27890876951351284,0.34219245757080208,0.378899772915685,1.0000009999999999,9.0999999999999998E-2,5.9482716505092376E-2,9.1000000034021727E-2]
[0.22558749454621513,0.34883500301096237,0.42557850244282242,1.0000009999999999,9.1999999999999998E-2,6.1810854658895527E-2,9.2000000078966068E-2]
[0.17226793489212736,0.35547412014611945,0.47225894496175314,1.0000009999999999,9.2999999999999999E-2,6.4827779851527073E-2,9.3000000100696256E-2]
[0.11894196646481443,0.36212605029246164,0.51893298324272386,1.0000009999999999,9.4E-2,6.8442468179566771E-2,9.4000000167779096E-2]
[6.56145788754387E-2,0.3687708422444203,0.56561457888014088,0.99999999999999989,9.5000000000000001E-2,7.2565985552226778E-2,9.5000000000047019E-2]
[1.2292310088263392E-2,0.37541537329080404,0.61229231662093253,1,9.6000000000000002E-2,7.7116170173534671E-2,9.6000000065326691E-2]
[0,0.30000000000000016,0.69999999999999984,1,9.7000000000000003E-2,8.2637763764516273E-2,9.7000000000000003E-2]
[0,0.20000000000000057,0.79999999999999949,1,9.8000000000000004E-2,9.0244113381427779E-2,9.8000000000000004E-2]
[0,0.10000000000000014,0.89999999999999991,1,9.9000000000000005E-2,9.9503768772845974E-2,9.9000000000000005E-2]
[0,9.7214889221324349E-5,0.99990278511077879,1.0000000000000002,0.1,0.10998930679180628,9.9999027851107813E-2]