{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Data","operating"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":43,"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":"Data","index":0,"n_rows":57,"n_cols":12,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["البيانات","Stock1","Stock2","Stock3","Stock4","Stock5","Stock6","Stock7","Stock8","Stock9","Stock10","عائد الفترة"]
[1,0.16,0.3,0.26,0.22,-0.25,null,null,null,null,null,{"$f":"+SUMPRODUCT(B2:K2,$B$26:$K$26)","v":0.13800000000000001}]
[{"$f":"+A2+1","v":2},-0.05,0.1,0.18,-0.03,0.3,null,null,null,null,null,{"$f":"+SUMPRODUCT(B3:K3,$B$26:$K$26)","v":0.1}]
[{"$f":"+A3+1","v":3},0.18,0.18,0.12,0.3,0.22,null,null,null,null,null,0.2]
[4,0.2,0.22,0.3,0.12,0.2,null,null,null,null,null,0.20800000000000002]
[5,0.1,0,0.18,-0.1,0.14000000000000001,null,null,null,null,null,6.4000000000000001E-2]
[6,0.26,0.18,0.22,0.2,0.2,null,null,null,null,null,0.21200000000000002]
[7,null,null,null,null,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,null,null,null,null,0]
[12,null,null,null,null,null,null,null,null,null,null,0]
[13,null,null,null,null,null,null,null,null,null,null,0]
[14,null,null,null,null,null,null,null,null,null,null,0]
[15,null,null,null,null,null,null,null,null,null,null,0]
[16,null,null,null,null,null,null,null,null,null,null,0]
[17,null,null,null,null,null,null,null,null,null,null,0]
[18,null,null,null,null,null,null,null,null,null,null,0]
[19,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"+A20+1","v":20},null,null,null,null,null,null,null,null,null,null,0]
["متوسط العوائد",{"$f":"IFERROR(AVERAGE(B2:B21),0)","v":0.14166666666666666},0.16333333333333333,0.21,0.11833333333333333,0.13500000000000001,0,0,0,0,0]
[]
[null,{"$f":"+IF(B22<>0,1,0)","v":1},{"$f":"+IF(C22<>0,1,0)","v":1},1,1,1,0,0,0,0,0,{"$f":"SUM(B24:K24)","v":5}]
[]
["الاوزان",{"$f":"IFERROR(1*B24/($L$24),0)","v":0.2},{"$f":"IFERROR(1*C24/($L$24),0)","v":0.2},0.2,0.2,0.2,0,0,0,0,0,{"$f":"SUM(B26:K26)","v":1}]
["المخاطر",{"$f":"+IFERROR(_xlfn.STDEV.P(B2:B21),0)","v":9.8050440533884897E-2},{"$f":"+IFERROR(_xlfn.STDEV.P(C2:C21),0)","v":9.4103961423287349E-2},5.8594652770823138E-2,0.14123463534920258,0.17848902860773636,0,0,0,0,0]
[]
["مصفوفة الاوزان الافقية",{"$f":"B26","v":0.2},0.2,0.2,0.2,0.2,0,0,0,0,0]
[]
["مصفوفة الاوزان الرأسية"]
[{"$f":"TRANSPOSE(B26:K26)","v":0.2}]
[0.2]
[0.2]
[0.2]
[0.2]
[0]
[0]
[0]
[0]
[0]
[]
["مصفوفة التغاير (التباين)",{"$f":"B1","v":"Stock1"},"Stock2","Stock3","Stock4","Stock5","Stock6","Stock7","Stock8","Stock9","Stock10"]
[{"$f":"TRANSPOSE(B1:K1)","v":"Stock1"},{"$f":"+IFERROR(_xlfn.COVARIANCE.P(INDIRECT(B$43),INDIRECT($A44)),0)","v":9.6138888888888906E-3},{"$f":"+IFERROR(_xlfn.COVARIANCE.P(INDIRECT(C$43),INDIRECT($A44)),0)","v":4.5611111111111104E-3},1.816666666666667E-3,9.3527777777777776E-3,-4.0249999999999999E-3,0,0,0,0,0]
["Stock2",{"$f":"+IFERROR(_xlfn.COVARIANCE.P(INDIRECT(B$43),INDIRECT($A45)),0)","v":4.5611111111111104E-3},8.8555555555555557E-3,2.9000000000000002E-3,1.0572222222222221E-2,-9.6166666666666675E-3,0,0,0,0,0]
["Stock3",1.816666666666667E-3,2.9000000000000002E-3,3.4333333333333334E-3,1.1666666666666749E-4,-4.2500000000000003E-3,0,0,0,0,0]
["Stock4",9.3527777777777776E-3,1.0572222222222221E-2,1.1666666666666749E-4,1.9947222222222224E-2,-7.3083333333333342E-3,0,0,0,0,0]
["Stock5",-4.0249999999999999E-3,-9.6166666666666675E-3,-4.2500000000000003E-3,-7.3083333333333342E-3,3.1858333333333336E-2,0,0,0,0,0]
["Stock6",0,0,0,0,0,0,0,0,0,0]
["Stock7",0,0,0,0,0,0,0,0,0,0]
["Stock8",0,0,0,0,0,0,0,0,0,0]
["Stock9",0,0,0,0,0,0,0,0,0,0]
["Stock10",0,0,0,0,0,0,0,0,0,0]
[]
["العوائد",{"$f":"SUMPRODUCT(B22:K22,B26:K26)","v":0.15366666666666667}]
["المخاطرة",{"$f":"+MMULT(MMULT(B29:K29,B44:K53),A32:A41)^0.5","v":5.7252850487018454E-2}]
["تسعير وحدة الخطر",{"$f":"IFERROR(B55/B56,0)","v":2.6840002787548394}]

{"sheet":"operating","index":1,"n_rows":57,"n_cols":14,"rows_kept":57,"cut":false,"hidden":false,"merged":[[5,13,9,13],[10,13,13,13]]}
["البيانات","Stock1","Stock2","Stock3","Stock4","Stock5","Stock6","Stock7","Stock8","Stock9","Stock10","عائد الفترة"]
[1,{"$f":"+IF(Data!B2<>\"\",Data!B2,\"\")","v":0.16},{"$f":"+IF(Data!C2<>\"\",Data!C2,\"\")","v":0.3},{"$f":"+IF(Data!D2<>\"\",Data!D2,\"\")","v":0.26},{"$f":"+IF(Data!E2<>\"\",Data!E2,\"\")","v":0.22},{"$f":"+IF(Data!F2<>\"\",Data!F2,\"\")","v":-0.25},{"$f":"+IF(Data!G2<>\"\",Data!G2,\"\")","v":""},{"$f":"+IF(Data!H2<>\"\",Data!H2,\"\")","v":""},{"$f":"+IF(Data!I2<>\"\",Data!I2,\"\")","v":""},{"$f":"+IF(Data!J2<>\"\",Data!J2,\"\")","v":""},{"$f":"+IF(Data!K2<>\"\",Data!K2,\"\")","v":""},{"$f":"+SUMPRODUCT(B2:K2,$B$26:$K$26)","v":0.13800000000000001}]
[{"$f":"+A2+1","v":2},{"$f":"+IF(Data!B3<>\"\",Data!B3,\"\")","v":-0.05},{"$f":"+IF(Data!C3<>\"\",Data!C3,\"\")","v":0.1},{"$f":"+IF(Data!D3<>\"\",Data!D3,\"\")","v":0.18},{"$f":"+IF(Data!E3<>\"\",Data!E3,\"\")","v":-0.03},{"$f":"+IF(Data!F3<>\"\",Data!F3,\"\")","v":0.3},{"$f":"+IF(Data!G3<>\"\",Data!G3,\"\")","v":""},{"$f":"+IF(Data!H3<>\"\",Data!H3,\"\")","v":""},{"$f":"+IF(Data!I3<>\"\",Data!I3,\"\")","v":""},{"$f":"+IF(Data!J3<>\"\",Data!J3,\"\")","v":""},{"$f":"+IF(Data!K3<>\"\",Data!K3,\"\")","v":""},{"$f":"+SUMPRODUCT(B3:K3,$B$26:$K$26)","v":0.1}]
[{"$f":"+A3+1","v":3},{"$f":"+IF(Data!B4<>\"\",Data!B4,\"\")","v":0.18},{"$f":"+IF(Data!C4<>\"\",Data!C4,\"\")","v":0.18},{"$f":"+IF(Data!D4<>\"\",Data!D4,\"\")","v":0.12},{"$f":"+IF(Data!E4<>\"\",Data!E4,\"\")","v":0.3},{"$f":"+IF(Data!F4<>\"\",Data!F4,\"\")","v":0.22},{"$f":"+IF(Data!G4<>\"\",Data!G4,\"\")","v":""},{"$f":"+IF(Data!H4<>\"\",Data!H4,\"\")","v":""},{"$f":"+IF(Data!I4<>\"\",Data!I4,\"\")","v":""},{"$f":"+IF(Data!J4<>\"\",Data!J4,\"\")","v":""},{"$f":"+IF(Data!K4<>\"\",Data!K4,\"\")","v":""},0.2]
[4,{"$f":"+IF(Data!B5<>\"\",Data!B5,\"\")","v":0.2},{"$f":"+IF(Data!C5<>\"\",Data!C5,\"\")","v":0.22},{"$f":"+IF(Data!D5<>\"\",Data!D5,\"\")","v":0.3},{"$f":"+IF(Data!E5<>\"\",Data!E5,\"\")","v":0.12},{"$f":"+IF(Data!F5<>\"\",Data!F5,\"\")","v":0.2},{"$f":"+IF(Data!G5<>\"\",Data!G5,\"\")","v":""},{"$f":"+IF(Data!H5<>\"\",Data!H5,\"\")","v":""},{"$f":"+IF(Data!I5<>\"\",Data!I5,\"\")","v":""},{"$f":"+IF(Data!J5<>\"\",Data!J5,\"\")","v":""},{"$f":"+IF(Data!K5<>\"\",Data!K5,\"\")","v":""},0.20800000000000002]
[5,{"$f":"+IF(Data!B6<>\"\",Data!B6,\"\")","v":0.1},{"$f":"+IF(Data!C6<>\"\",Data!C6,\"\")","v":0},{"$f":"+IF(Data!D6<>\"\",Data!D6,\"\")","v":0.18},{"$f":"+IF(Data!E6<>\"\",Data!E6,\"\")","v":-0.1},{"$f":"+IF(Data!F6<>\"\",Data!F6,\"\")","v":0.14000000000000001},{"$f":"+IF(Data!G6<>\"\",Data!G6,\"\")","v":""},{"$f":"+IF(Data!H6<>\"\",Data!H6,\"\")","v":""},{"$f":"+IF(Data!I6<>\"\",Data!I6,\"\")","v":""},{"$f":"+IF(Data!J6<>\"\",Data!J6,\"\")","v":""},{"$f":"+IF(Data!K6<>\"\",Data!K6,\"\")","v":""},6.4000000000000001E-2,null,"قمت بتسجيل ماكرو للأداة سولفر ولكن عند استدعائه مرة اخرى لا يعمل ويعطيني خطأ"]
[6,{"$f":"+IF(Data!B7<>\"\",Data!B7,\"\")","v":0.26},{"$f":"+IF(Data!C7<>\"\",Data!C7,\"\")","v":0.18},{"$f":"+IF(Data!D7<>\"\",Data!D7,\"\")","v":0.22},{"$f":"+IF(Data!E7<>\"\",Data!E7,\"\")","v":0.2},{"$f":"+IF(Data!F7<>\"\",Data!F7,\"\")","v":0.2},{"$f":"+IF(Data!G7<>\"\",Data!G7,\"\")","v":""},{"$f":"+IF(Data!H7<>\"\",Data!H7,\"\")","v":""},{"$f":"+IF(Data!I7<>\"\",Data!I7,\"\")","v":""},{"$f":"+IF(Data!J7<>\"\",Data!J7,\"\")","v":""},{"$f":"+IF(Data!K7<>\"\",Data!K7,\"\")","v":""},0.21200000000000002]
[7,{"$f":"+IF(Data!B8<>\"\",Data!B8,\"\")","v":""},{"$f":"+IF(Data!C8<>\"\",Data!C8,\"\")","v":""},{"$f":"+IF(Data!D8<>\"\",Data!D8,\"\")","v":""},{"$f":"+IF(Data!E8<>\"\",Data!E8,\"\")","v":""},{"$f":"+IF(Data!F8<>\"\",Data!F8,\"\")","v":""},{"$f":"+IF(Data!G8<>\"\",Data!G8,\"\")","v":""},{"$f":"+IF(Data!H8<>\"\",Data!H8,\"\")","v":""},{"$f":"+IF(Data!I8<>\"\",Data!I8,\"\")","v":""},{"$f":"+IF(Data!J8<>\"\",Data!J8,\"\")","v":""},{"$f":"+IF(Data!K8<>\"\",Data!K8,\"\")","v":""},0]
[8,{"$f":"+IF(Data!B9<>\"\",Data!B9,\"\")","v":""},{"$f":"+IF(Data!C9<>\"\",Data!C9,\"\")","v":""},{"$f":"+IF(Data!D9<>\"\",Data!D9,\"\")","v":""},{"$f":"+IF(Data!E9<>\"\",Data!E9,\"\")","v":""},{"$f":"+IF(Data!F9<>\"\",Data!F9,\"\")","v":""},{"$f":"+IF(Data!G9<>\"\",Data!G9,\"\")","v":""},{"$f":"+IF(Data!H9<>\"\",Data!H9,\"\")","v":""},{"$f":"+IF(Data!I9<>\"\",Data!I9,\"\")","v":""},{"$f":"+IF(Data!J9<>\"\",Data!J9,\"\")","v":""},{"$f":"+IF(Data!K9<>\"\",Data!K9,\"\")","v":""},0]
[9,{"$f":"+IF(Data!B10<>\"\",Data!B10,\"\")","v":""},{"$f":"+IF(Data!C10<>\"\",Data!C10,\"\")","v":""},{"$f":"+IF(Data!D10<>\"\",Data!D10,\"\")","v":""},{"$f":"+IF(Data!E10<>\"\",Data!E10,\"\")","v":""},{"$f":"+IF(Data!F10<>\"\",Data!F10,\"\")","v":""},{"$f":"+IF(Data!G10<>\"\",Data!G10,\"\")","v":""},{"$f":"+IF(Data!H10<>\"\",Data!H10,\"\")","v":""},{"$f":"+IF(Data!I10<>\"\",Data!I10,\"\")","v":""},{"$f":"+IF(Data!J10<>\"\",Data!J10,\"\")","v":""},{"$f":"+IF(Data!K10<>\"\",Data!K10,\"\")","v":""},0]
[10,{"$f":"+IF(Data!B11<>\"\",Data!B11,\"\")","v":""},{"$f":"+IF(Data!C11<>\"\",Data!C11,\"\")","v":""},{"$f":"+IF(Data!D11<>\"\",Data!D11,\"\")","v":""},{"$f":"+IF(Data!E11<>\"\",Data!E11,\"\")","v":""},{"$f":"+IF(Data!F11<>\"\",Data!F11,\"\")","v":""},{"$f":"+IF(Data!G11<>\"\",Data!G11,\"\")","v":""},{"$f":"+IF(Data!H11<>\"\",Data!H11,\"\")","v":""},{"$f":"+IF(Data!I11<>\"\",Data!I11,\"\")","v":""},{"$f":"+IF(Data!J11<>\"\",Data!J11,\"\")","v":""},{"$f":"+IF(Data!K11<>\"\",Data!K11,\"\")","v":""},0,null,"ارجو من حضراتكم تعديل الكود ليعمل بكفاءة عند استدعاؤه"]
[11,{"$f":"+IF(Data!B12<>\"\",Data!B12,\"\")","v":""},{"$f":"+IF(Data!C12<>\"\",Data!C12,\"\")","v":""},{"$f":"+IF(Data!D12<>\"\",Data!D12,\"\")","v":""},{"$f":"+IF(Data!E12<>\"\",Data!E12,\"\")","v":""},{"$f":"+IF(Data!F12<>\"\",Data!F12,\"\")","v":""},{"$f":"+IF(Data!G12<>\"\",Data!G12,\"\")","v":""},{"$f":"+IF(Data!H12<>\"\",Data!H12,\"\")","v":""},{"$f":"+IF(Data!I12<>\"\",Data!I12,\"\")","v":""},{"$f":"+IF(Data!J12<>\"\",Data!J12,\"\")","v":""},{"$f":"+IF(Data!K12<>\"\",Data!K12,\"\")","v":""},0]
[12,{"$f":"+IF(Data!B13<>\"\",Data!B13,\"\")","v":""},{"$f":"+IF(Data!C13<>\"\",Data!C13,\"\")","v":""},{"$f":"+IF(Data!D13<>\"\",Data!D13,\"\")","v":""},{"$f":"+IF(Data!E13<>\"\",Data!E13,\"\")","v":""},{"$f":"+IF(Data!F13<>\"\",Data!F13,\"\")","v":""},{"$f":"+IF(Data!G13<>\"\",Data!G13,\"\")","v":""},{"$f":"+IF(Data!H13<>\"\",Data!H13,\"\")","v":""},{"$f":"+IF(Data!I13<>\"\",Data!I13,\"\")","v":""},{"$f":"+IF(Data!J13<>\"\",Data!J13,\"\")","v":""},{"$f":"+IF(Data!K13<>\"\",Data!K13,\"\")","v":""},0]
[13,{"$f":"+IF(Data!B14<>\"\",Data!B14,\"\")","v":""},{"$f":"+IF(Data!C14<>\"\",Data!C14,\"\")","v":""},{"$f":"+IF(Data!D14<>\"\",Data!D14,\"\")","v":""},{"$f":"+IF(Data!E14<>\"\",Data!E14,\"\")","v":""},{"$f":"+IF(Data!F14<>\"\",Data!F14,\"\")","v":""},{"$f":"+IF(Data!G14<>\"\",Data!G14,\"\")","v":""},{"$f":"+IF(Data!H14<>\"\",Data!H14,\"\")","v":""},{"$f":"+IF(Data!I14<>\"\",Data!I14,\"\")","v":""},{"$f":"+IF(Data!J14<>\"\",Data!J14,\"\")","v":""},{"$f":"+IF(Data!K14<>\"\",Data!K14,\"\")","v":""},0]
[14,{"$f":"+IF(Data!B15<>\"\",Data!B15,\"\")","v":""},{"$f":"+IF(Data!C15<>\"\",Data!C15,\"\")","v":""},{"$f":"+IF(Data!D15<>\"\",Data!D15,\"\")","v":""},{"$f":"+IF(Data!E15<>\"\",Data!E15,\"\")","v":""},{"$f":"+IF(Data!F15<>\"\",Data!F15,\"\")","v":""},{"$f":"+IF(Data!G15<>\"\",Data!G15,\"\")","v":""},{"$f":"+IF(Data!H15<>\"\",Data!H15,\"\")","v":""},{"$f":"+IF(Data!I15<>\"\",Data!I15,\"\")","v":""},{"$f":"+IF(Data!J15<>\"\",Data!J15,\"\")","v":""},{"$f":"+IF(Data!K15<>\"\",Data!K15,\"\")","v":""},0]
[15,{"$f":"+IF(Data!B16<>\"\",Data!B16,\"\")","v":""},{"$f":"+IF(Data!C16<>\"\",Data!C16,\"\")","v":""},{"$f":"+IF(Data!D16<>\"\",Data!D16,\"\")","v":""},{"$f":"+IF(Data!E16<>\"\",Data!E16,\"\")","v":""},{"$f":"+IF(Data!F16<>\"\",Data!F16,\"\")","v":""},{"$f":"+IF(Data!G16<>\"\",Data!G16,\"\")","v":""},{"$f":"+IF(Data!H16<>\"\",Data!H16,\"\")","v":""},{"$f":"+IF(Data!I16<>\"\",Data!I16,\"\")","v":""},{"$f":"+IF(Data!J16<>\"\",Data!J16,\"\")","v":""},{"$f":"+IF(Data!K16<>\"\",Data!K16,\"\")","v":""},0]
[16,{"$f":"+IF(Data!B17<>\"\",Data!B17,\"\")","v":""},{"$f":"+IF(Data!C17<>\"\",Data!C17,\"\")","v":""},{"$f":"+IF(Data!D17<>\"\",Data!D17,\"\")","v":""},{"$f":"+IF(Data!E17<>\"\",Data!E17,\"\")","v":""},{"$f":"+IF(Data!F17<>\"\",Data!F17,\"\")","v":""},{"$f":"+IF(Data!G17<>\"\",Data!G17,\"\")","v":""},{"$f":"+IF(Data!H17<>\"\",Data!H17,\"\")","v":""},{"$f":"+IF(Data!I17<>\"\",Data!I17,\"\")","v":""},{"$f":"+IF(Data!J17<>\"\",Data!J17,\"\")","v":""},{"$f":"+IF(Data!K17<>\"\",Data!K17,\"\")","v":""},0]
[17,{"$f":"+IF(Data!B18<>\"\",Data!B18,\"\")","v":""},{"$f":"+IF(Data!C18<>\"\",Data!C18,\"\")","v":""},{"$f":"+IF(Data!D18<>\"\",Data!D18,\"\")","v":""},{"$f":"+IF(Data!E18<>\"\",Data!E18,\"\")","v":""},{"$f":"+IF(Data!F18<>\"\",Data!F18,\"\")","v":""},{"$f":"+IF(Data!G18<>\"\",Data!G18,\"\")","v":""},{"$f":"+IF(Data!H18<>\"\",Data!H18,\"\")","v":""},{"$f":"+IF(Data!I18<>\"\",Data!I18,\"\")","v":""},{"$f":"+IF(Data!J18<>\"\",Data!J18,\"\")","v":""},{"$f":"+IF(Data!K18<>\"\",Data!K18,\"\")","v":""},0]
[18,{"$f":"+IF(Data!B19<>\"\",Data!B19,\"\")","v":""},{"$f":"+IF(Data!C19<>\"\",Data!C19,\"\")","v":""},{"$f":"+IF(Data!D19<>\"\",Data!D19,\"\")","v":""},{"$f":"+IF(Data!E19<>\"\",Data!E19,\"\")","v":""},{"$f":"+IF(Data!F19<>\"\",Data!F19,\"\")","v":""},{"$f":"+IF(Data!G19<>\"\",Data!G19,\"\")","v":""},{"$f":"+IF(Data!H19<>\"\",Data!H19,\"\")","v":""},{"$f":"+IF(Data!I19<>\"\",Data!I19,\"\")","v":""},{"$f":"+IF(Data!J19<>\"\",Data!J19,\"\")","v":""},{"$f":"+IF(Data!K19<>\"\",Data!K19,\"\")","v":""},0]
[19,{"$f":"+IF(Data!B20<>\"\",Data!B20,\"\")","v":""},{"$f":"+IF(Data!C20<>\"\",Data!C20,\"\")","v":""},{"$f":"+IF(Data!D20<>\"\",Data!D20,\"\")","v":""},{"$f":"+IF(Data!E20<>\"\",Data!E20,\"\")","v":""},{"$f":"+IF(Data!F20<>\"\",Data!F20,\"\")","v":""},{"$f":"+IF(Data!G20<>\"\",Data!G20,\"\")","v":""},{"$f":"+IF(Data!H20<>\"\",Data!H20,\"\")","v":""},{"$f":"+IF(Data!I20<>\"\",Data!I20,\"\")","v":""},{"$f":"+IF(Data!J20<>\"\",Data!J20,\"\")","v":""},{"$f":"+IF(Data!K20<>\"\",Data!K20,\"\")","v":""},0]
[{"$f":"+A20+1","v":20},{"$f":"+IF(Data!B21<>\"\",Data!B21,\"\")","v":""},{"$f":"+IF(Data!C21<>\"\",Data!C21,\"\")","v":""},{"$f":"+IF(Data!D21<>\"\",Data!D21,\"\")","v":""},{"$f":"+IF(Data!E21<>\"\",Data!E21,\"\")","v":""},{"$f":"+IF(Data!F21<>\"\",Data!F21,\"\")","v":""},{"$f":"+IF(Data!G21<>\"\",Data!G21,\"\")","v":""},{"$f":"+IF(Data!H21<>\"\",Data!H21,\"\")","v":""},{"$f":"+IF(Data!I21<>\"\",Data!I21,\"\")","v":""},{"$f":"+IF(Data!J21<>\"\",Data!J21,\"\")","v":""},{"$f":"+IF(Data!K21<>\"\",Data!K21,\"\")","v":""},0]
["متوسط العوائد",{"$f":"IFERROR(AVERAGE(B2:B21),0)","v":0.14166666666666666},{"$f":"IFERROR(AVERAGE(C2:C21),0)","v":0.16333333333333333},0.21,0.11833333333333333,0.13500000000000001,0,0,0,0,0]
[]
[null,{"$f":"+IF(B22<>0,1,0)","v":1},{"$f":"+IF(C22<>0,1,0)","v":1},1,1,1,0,0,0,0,0,{"$f":"SUM(B24:K24)","v":5}]
[]
["الاوزان",{"$f":"Data!B26","v":0.2},{"$f":"Data!C26","v":0.2},{"$f":"Data!D26","v":0.2},{"$f":"Data!E26","v":0.2},{"$f":"Data!F26","v":0.2},{"$f":"Data!G26","v":0},{"$f":"Data!H26","v":0},{"$f":"Data!I26","v":0},{"$f":"Data!J26","v":0},{"$f":"Data!K26","v":0},{"$f":"SUM(B26:K26)","v":1}]
["المخاطر",{"$f":"+IFERROR(_xlfn.STDEV.P(B2:B21),0)","v":9.8050440533884897E-2},{"$f":"+IFERROR(_xlfn.STDEV.P(C2:C21),0)","v":9.4103961423287349E-2},5.8594652770823138E-2,0.14123463534920258,0.17848902860773636,0,0,0,0,0]
[]
["مصفوفة الاوزان الافقية",{"$f":"B26","v":0.2},0.2,0.2,0.2,0.2,0,0,0,0,0]
[]
["مصفوفة الاوزان الرأسية"]
[{"$f":"TRANSPOSE(B26:K26)","v":0.2}]
[0.2]
[0.2]
[0.2]
[0.2]
[0]
[0]
[0]
[0]
[0]
[]
["مصفوفة التغاير (التباين)",{"$f":"B1","v":"Stock1"},"Stock2","Stock3","Stock4","Stock5","Stock6","Stock7","Stock8","Stock9","Stock10"]
[{"$f":"TRANSPOSE(B1:K1)","v":"Stock1"},{"$f":"+IFERROR(_xlfn.COVARIANCE.P(INDIRECT(B$43),INDIRECT($A44)),0)","v":9.6138888888888906E-3},{"$f":"+IFERROR(_xlfn.COVARIANCE.P(INDIRECT(C$43),INDIRECT($A44)),0)","v":4.5611111111111104E-3},1.816666666666667E-3,9.3527777777777776E-3,-4.0249999999999999E-3,0,0,0,0,0]
["Stock2",{"$f":"+IFERROR(_xlfn.COVARIANCE.P(INDIRECT(B$43),INDIRECT($A45)),0)","v":4.5611111111111104E-3},8.8555555555555557E-3,2.9000000000000002E-3,1.0572222222222221E-2,-9.6166666666666675E-3,0,0,0,0,0]
["Stock3",1.816666666666667E-3,2.9000000000000002E-3,3.4333333333333334E-3,1.1666666666666749E-4,-4.2500000000000003E-3,0,0,0,0,0]
["Stock4",9.3527777777777776E-3,1.0572222222222221E-2,1.1666666666666749E-4,1.9947222222222224E-2,-7.3083333333333342E-3,0,0,0,0,0]
["Stock5",-4.0249999999999999E-3,-9.6166666666666675E-3,-4.2500000000000003E-3,-7.3083333333333342E-3,3.1858333333333336E-2,0,0,0,0,0]
["Stock6",0,0,0,0,0,0,0,0,0,0]
["Stock7",0,0,0,0,0,0,0,0,0,0]
["Stock8",0,0,0,0,0,0,0,0,0,0]
["Stock9",0,0,0,0,0,0,0,0,0,0]
["Stock10",0,0,0,0,0,0,0,0,0,0]
[]
["العوائد",{"$f":"SUMPRODUCT(B22:K22,B26:K26)","v":0.15366666666666667}]
["المخاطرة",{"$f":"+MMULT(MMULT(B29:K29,B44:K53),A32:A41)^0.5","v":5.7252850487018454E-2}]
["تسعير وحدة الخطر",{"$f":"IFERROR(B55/B56,0)","v":2.6840002787548394}]