{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["TwoAssets"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"TwoAssets","index":0,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[[8,1,8,2]]}
["2 Asset Portfolio"]
["Corelation",1]
[null,"StDev of Return","Mean Return","Portfolio Weight"]
["Stock A",0.08,0.04,0.4]
["Stock B",0.24,0.15,"xxxxxx"]
["Portfolio","xxxxxx","xxxxxx"]
[]
[]
[null,"Portfolio"]
["Weight A","StDev","Expected",null,null,null,null,null,null,null,null,null,"Note:"]
[null,"xxxxxx","xxxxxx",null,null,null,null,null,null,null,null,null,null,"COV(i,j) = Stdev(i)*Stdev(j)*CORR(i,j)"]
[0,"xxxxxx","xxxxxx",null,null,null,null,null,null,null,null,null,null,"COV(i,i) = VAR(i) = Stdev(i)^2"]
[{"$f":"A12+0.1","v":0.1},"xxxxxx","xxxxxx",null,null,null,null,null,null,null,null,null,"ρ(i,j) = Correlation of returns between assets i and j"]
[{"$f":"A13+0.1","v":0.2},"xxxxxx","xxxxxx",null,null,null,null,null,null,null,null,null,"σ(i) = Standard deviation of returns of asset i"]
[0.30000000000000004,"xxxxxx","xxxxxx",null,null,null,null,null,null,null,null,null,"σ(i,j) = Covaraince of returns of assets i and j"]
[0.4,"xxxxxx","xxxxxx",null,null,null,null,null,null,null,null,null,"σ(i,j) = ρ(i,j) * σ(i) * σ(j)"]
[0.5,"xxxxxx","xxxxxx"]
[0.6,"xxxxxx","xxxxxx"]
[0.7,"xxxxxx","xxxxxx"]
[0.79999999999999993,"xxxxxx","xxxxxx"]
[0.89999999999999991,"xxxxxx","xxxxxx"]
[0.99999999999999989,"xxxxxx","xxxxxx"]