{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["Accueil","Données","Résultats","Matrice Variance.Covariance"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Accueil","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[]
[{"$nulls":5},"             "]
[{"$nulls":5},"GESTION DE PORTEFEUILLE"]
[]
[]
[]
[null,null,"Le portefeuille de titre est composé de 11 titres (Accor, Axa, BNP-Paribas, Bouygues, Carrefour, Crédit Agricole, Danone, Sanofi, Société Générale, Total et Vivendi). "]
[null,null,"Dans ce projet nous prenons comme référence une plage de 5 années. Nous allons mettre en place un classeur muni de boutons afin de pouvoir calculer automatiquement "]
[null,null,"la moyenne pour chaque titre, ainsi que l'ecart-type, la skewness, la kurtosis, le β et la matrice de Variance/covariance."]
[null,null,"Nous allons également montrer s'il est judicieux d'acheter ou non telle action en fonction de sa moyenne sur les 5 dernières années."]

{"sheet":"Données","index":1,"n_rows":64,"n_cols":26,"rows_kept":64,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[{"$nulls":5},"Evolution des cours des actions",{"$nulls":12},"                       Evolution des Rendements"]
[]
["Date","CAC40","Accor","Axa","BNP-Paribas","Bouygues","Carrefour","Crédit Agricole","Danone","Sanofi","Société Générale","Total","Vivendi",null,"CAC40","Accor","Axa","BNP-Paribas","Bouygues","Carrefour","Crédit Agricole","Danone","Sanofi","Société Générale","Total","Vivendi"]
[null,"Cours","Cours","Cours","Cours","Cours","Cours","Cours","Cours","Cours","Cours","Cours","Cours",null,"Rendement","Rendement","Rendement","Rendement","Rendement","Rendement","Rendement","Rendement","Rendement","Rendement","Rendement","Rendement"]
["2012-02-17",3439.62,25.65,12.3,36.88,25.1,17.95,5.11,49.74,56.4,24.02,41.68,16.51,null,1.0427672765305966,1.1041756349547998,1.060344827586207,1.1393265369168986,1.0563973063973064,1.0286532951289398,1.0849256900212314,1.0542602797795677,0.9987604037542057,1.1797642436149312,1.0316831683168317,1.031875]
["2012-01-31",3298.55,23.23,11.6,32.37,23.76,17.45,4.71,47.18,56.47,20.36,40.4,16,null,1.0439077033112751,1.186414708886619,1.155378486055777,1.0665568369028005,0.9761709120788825,0.9903518728717365,1.0802752293577982,0.9713815112209182,0.9950660792951541,1.1837209302325582,1.0227848101265822,0.9456264775413711]
["2011-12-30",3159.81,19.58,10.04,30.35,24.34,17.62,4.36,48.57,56.75,17.2,39.5,16.92,null,1.0016452060787036,0.9458937198067633,0.9365671641791044,1.0298608754665763,1.0041254125412542,0.8921518987341772,0.9178947368421053,0.990415986949429,1.0894605490497216,0.9513274336283186,1.0302556077203964,0.9883177570093459]
["2011-11-30",3154.62,20.7,10.72,29.47,24.24,19.75,4.75,49.04,52.09,18.08,38.34,17.12,null,0.972795450901062,0.8712121212121211,0.9107901444350044,0.8971080669710806,0.8924889543446244,1.0270410816432658,0.8362676056338029,0.9749502982107356,1.0025019245573519,0.8568720379146918,1.013749338974088,1.0535384615384615]
["2011-10-31",3242.84,23.76,11.77,32.85,27.16,19.23,5.68,50.3,51.96,21.1,37.82,16.25,null,1.0874860829789803,1.1791563275434245,1.1888888888888889,1.0931780366056572,1.0890136327185245,1.1219369894982496,1.0860420650095601,1.0887445887445886,1.0528875379939209,1.0550000000000002,1.1377858002406738,1.0593220338983051]
["2011-09-30",2981.96,20.15,9.9,30.05,24.94,17.14,5.23,46.2,49.35,20,33.24,15.34,null,0.915621660791707,0.8043912175648702,0.8855098389982111,0.837747421243379,0.9333832335329342,0.923491379310345,0.7668621700879765,0.9714045416316233,0.9741413343861035,0.8561643835616438,0.9776470588235294,0.9044811320754716]
["2011-08-31",3256.76,25.05,11.18,35.87,26.72,18.56,6.82,47.56,50.66,23.36,34,16.96,null,0.8870911507703035,0.8141046473838155,0.8527841342486652,0.7890453145622525,1.0125047366426676,0.9009708737864076,0.7911832946635732,0.9550200803212853,0.9331368576165039,0.6724237190558433,0.899947061937533,1.0155688622754493]
["2011-07-29",3671.28,30.77,13.11,45.46,26.39,20.6,8.62,49.8,54.29,34.74,37.78,16.7,null,0.9219202402685946,0.9977302204928664,0.8366305041480536,0.8540296825098629,0.8703825857519789,0.8326596604688764,0.8312439729990356,0.9679300291545189,0.9792568542568543,0.8489736070381232,0.9473420260782347,0.8706986444212721]
["2011-06-30",3982.21,30.84,15.67,53.23,30.32,24.74,10.37,51.45,55.44,40.92,39.88,19.18,null,0.9938282080590176,0.9692017598994344,1.0559299191374663,0.9817410549612688,0.9445482866043613,0.9200446262551133,0.9764595103578154,1.0098135426889108,1.0076335877862594,0.9922405431619786,0.9962528103922059,0.988659793814433]
["2011-05-31",4006.94,31.82,14.84,54.22,32.1,26.89,10.62,50.95,55.02,41.24,40.03,19.4,null,0.9756557225365967,1.0606666666666666,0.9795379537953796,1.0147857009170878,0.9547888161808449,0.9617310443490701,0.9448398576512455,1.0301253538212698,1.0303370786516854,0.913197519929141,0.9261915779731607,0.9159584513692162]
["2011-04-29",4106.92,30,15.15,53.43,33.62,27.96,11.24,49.46,53.4,45.16,43.22,21.18,null,1.029514837635805,0.9463722397476341,1.0278154681139755,1.035264483627204,0.9923258559622194,1.024551117625504,0.9706390328151986,1.0728850325379609,1.0792239288601455,0.9849509269356597,1.0060521415270018,1.0511166253101738]
["2011-03-31",3989.18,31.7,14.74,51.61,33.88,27.29,11.58,46.1,49.48,45.85,42.96,20.15,null,0.9705207585728708,0.9301643192488264,0.9684625492772667,0.9121597737716508,1.0113432835820897,0.8780566280566281,0.910377358490566,1.0147479639005064,0.9895999999999999,0.8999018645731108,0.9673496960144112,0.9753146176185865]
["2011-02-28",4110.35,34.08,15.22,56.58,33.5,31.08,12.72,45.43,50,50.95,44.41,20.66,null,1.0261765073024591,1.0203592814371258,0.9844760672703752,1.0362637362637361,0.9850044104675096,0.9942418426103646,1.1788693234476368,1.0327347124346442,1.0024057738572574,1.0787634977768368,1.039559925093633,0.9866284622731614]
["2011-01-31",4005.5,33.4,15.46,54.6,34.01,31.26,10.79,43.99,49.88,47.23,42.72,20.94,null,1.0527546927811857,1.003003003003003,1.2417670682730926,1.146817895400126,1.0542467451952884,1.1599257884972172,1.1357894736842105,0.9355593364525734,1.0424242424242425,1.1742913973147688,1.0774274905422447,1.0366336633663367]
["2010-12-31",3804.78,33.3,12.45,47.61,32.26,26.95,9.5,47.02,47.85,40.22,39.65,20.2,null,1.0538272343537076,1.0227272727272725,1.1256781193490053,1.044078947368421,1.0494469746258945,0.8850574712643678,1.00635593220339,1.0421099290780143,1.027264920566767,1.1266106442577029,1.062433011789925,1.0744680851063828]
["2010-11-30",3610.44,32.56,11.06,45.6,30.74,30.45,9.44,45.12,46.58,35.7,37.32,18.8,null,0.9418129646537107,1.1052274270196878,0.845565749235474,0.867745004757374,0.9709412507896399,0.8987603305785123,0.801358234295416,0.9920844327176781,0.9282582702271821,0.8298465829846583,0.9559426229508197,0.9170731707317074]
["2010-10-29",3833.5,29.46,13.08,52.55,31.66,33.88,11.78,45.48,50.18,43.02,39.04,20.5,null,1.0318477166651414,1.1000746825989545,1.0202808112324493,1.007283879624305,1.00571791613723,0.9840255591054314,1.0279232111692844,1.0364630811303555,1.026595744680851,1.018224852071006,1.0328042328042328,1.0224438902743143]
["2010-09-30",3715.18,26.78,12.82,52.17,31.48,34.43,11.46,43.88,48.88,42.25,37.8,20.05,null,1.0642805783218126,1.1061544816191657,1.0456769983686787,1.0567146040105329,0.9825218476903871,1.0999999999999999,1.1529175050301812,1.0349056603773585,1.0797437596642367,1.051518168242907,1.0252237591537836,1.089082020640956]
["2010-08-31",3490.79,24.21,12.26,49.37,32.04,31.3,9.94,42.4,45.27,40.18,36.87,18.41,null,0.9581816784422229,0.9738535800482704,0.867043847241867,0.9366344147220641,0.9888888888888889,1.0142579390797148,0.9457659372026641,0.9851301115241635,1.0157056315907562,0.9082278481012658,0.9524670627744768,0.9983731019522776]
["2010-07-30",3643.14,24.86,14.14,52.71,32.4,30.86,10.51,43.04,44.57,44.24,38.71,18.44,null,1.0581633453290695,0.9503058103975535,1.10989010989011,1.177350904623632,1.0150375939849623,1.079020979020979,1.2164351851851851,0.9737556561085972,0.8998586715122148,1.289795918367347,1.0473484848484849,1.0963139120095124]
["2010-06-30",3442.89,26.16,12.74,44.77,31.92,28.6,8.64,44.2,49.53,34.3,36.96,16.82,null,0.9815626817502765,0.9860535243120995,0.9465081723625557,0.9669546436285098,0.9161882893226176,0.9711375212224109,0.9729729729729729,1.0518800571156592,1.0016177957532861,0.978601997146933,0.979591836734694,0.953514739229025]
["2010-05-31",3507.56,26.53,13.46,46.3,34.84,29.45,8.88,42.02,49.45,35.05,37.73,17.64,null,0.9189335051965031,0.9023809523809525,0.8913907284768212,0.8881642048724342,0.9298105150787298,0.9151646985705407,0.8207024029574862,0.9468228931951329,0.9572202864885793,0.8675742574257426,0.9209177446912374,0.8909090909090909]
["2010-04-30",3816.99,29.4,15.1,52.13,37.47,32.18,10.82,44.38,51.66,40.4,40.97,19.8,null,0.9604882725508994,1.0496251338807567,0.9168184578020644,0.916813225466057,1.006716818914562,1.0324029515559832,0.8348765432098765,0.9950672645739911,0.9360391375249139,0.8676975945017181,0.9532340623545835,0.9989909182643795]
["2010-03-31",3974.01,28.01,16.47,56.86,37.22,31.17,12.96,44.6,55.19,46.56,42.98,19.82,null,1.0715083045729077,1.1027559055118112,1.1143437077131257,1.0702051571616789,1.1011834319526628,1.0530405405405405,1.1868131868131868,1.038416763678696,1.0273641102010425,1.1524752475247526,1.0488042947779406,1.0713513513513513]
["2010-02-26",3708.8,25.4,14.78,53.13,33.8,29.6,10.92,42.95,53.72,40.4,40.98,18.5,null,0.9918009552181332,1.014782261286456,0.9853333333333333,1.018791946308725,0.944925915571708,0.9588597343699384,0.9545454545454546,1.0364382239382242,1.0022388059701492,0.9573459715639809,0.9745541022592152,0.9814323607427055]
["2010-01-29",3739.46,25.03,15,52.15,35.77,30.87,11.44,41.44,53.6,42.2,42.05,18.85,null,0.9499864086598431,0.9568042813455658,0.9068923821039904,0.9329159212880143,0.9821526633717738,1.0528649386084583,0.9255663430420712,0.9675461125379407,0.9734834725753723,0.8621041879468846,0.9344444444444444,0.90625]
["2009-12-31",3936.33,26.16,16.54,55.9,36.42,29.32,12.36,42.83,55.06,48.95,45,20.8,null,1.0696112930179476,1.0734509643003693,1.0422180214240706,1.0163636363636364,1.0989740494870248,1.0386114063053489,0.8969521044992743,1.0758603365988444,1.0941971383147855,1.0439326082320324,1.0919679689395778,1.0838978634705576]
["2009-11-30",3680.15,24.37,15.87,55,33.14,28.23,13.78,39.81,50.32,46.89,41.21,19.19,null,1.020084874254717,1.0903803131991052,0.9324324324324325,1.0689990281827015,1.0307931570762054,1.1040281579976534,1.0519083969465648,0.971923828125,1.0116606353035786,1.0332745702952841,1.014025590551181,1.0142706131078223]
["2009-10-30",3607.69,22.35,17.02,51.45,32.15,25.57,13.1,40.96,49.74,45.38,40.64,18.92,null,0.9505402578377568,0.8589546502690238,0.9199999999999999,0.9423076923076923,0.9251798561151079,0.9442392909896603,0.9173669467787116,0.9946576007770763,0.9918245264207378,0.8705160176481872,1.000985221674877,0.8949858088930938]
["2009-09-30",3795.41,26.02,18.5,54.6,34.75,27.08,14.28,41.18,50.15,52.13,40.6,21.14,null,1.0388308325623916,1.0362405416168856,1.1649874055415617,0.9720491365497597,1.0037550548815715,0.9438828860230044,1.1052631578947367,1.0856841550224097,1.0598055790363483,0.9784159159159159,1.0157618213660247,1.0639154504277806]
["2009-08-31",3653.54,25.11,15.88,56.17,34.62,28.69,12.92,37.93,47.32,53.28,39.97,19.87,null,1.066331608425489,1.22607421875,1.0708024275118004,1.0981427174975562,1.1586345381526104,0.9972193256864791,1.2894211576846308,1.0077045696068012,1.0295909486510009,1.247775175644028,1.027242354150604,1.102663706992231]
["2009-07-31",3426.27,20.48,14.83,51.15,29.88,28.77,10.02,37.64,45.96,42.7,38.91,18.02,null,1.0910159085987952,1.060041407867495,1.1075429424943988,1.105945945945946,1.1149253731343283,1.0828001505457283,1.1283783783783783,1.069926094371802,1.0976833054693098,1.1584373304395008,1.011174636174636,1.057511737089202]
["2009-06-30",3140.44,19.32,13.39,46.25,26.8,26.57,8.88,35.18,41.87,36.86,38.48,17.04,null,0.9581376901133434,0.9015398973401774,1.021357742181541,0.9487179487179487,0.9250949257852952,0.9630300833635376,0.8596321393998064,1.0014232849416453,0.9314794215795327,0.9485331960885229,0.9442944785276073,0.9176090468497576]
["2009-05-29",3277.65,21.43,13.11,48.75,28.97,27.59,10.33,35.13,44.95,38.86,40.75,18.57,null,1.037280250644809,0.9723230490018149,1.0290423861852434,1.2111801242236024,0.8908364083640835,1.0226093402520384,0.9223214285714286,0.9720531267293858,1.0269591044094128,1.046875,1.0628586332811685,0.9071812408402541]
["2009-04-30",3159.85,22.04,12.74,40.25,32.52,26.98,11.2,36.14,43.77,37.12,38.34,20.47,null,1.1255672629606672,1.2292247629670943,1.407734806629834,1.2933804627249357,1.2080237741456168,1.0506230529595015,1.3477737665463296,0.9858156028368795,1.0327984898537046,1.3276108726752502,1.0245857830037413,1.0276104417670682]
["2009-03-31",2807.34,17.93,9.05,31.12,26.92,25.68,8.31,36.66,42.38,27.96,37.42,19.92,null,1.0388013972351322,0.9223251028806584,1.2329700272479565,1.1973836090804157,1.180701754385965,1.0979050876442924,1.0667522464698331,0.9685601056803169,1.0356793743890518,1.1822410147991544,0.9983991462113129,1.0506329113924051]
["2009-02-27",2702.48,19.44,7.34,25.99,22.8,23.39,7.79,37.85,40.92,23.65,37.48,18.96,null,0.9087265292946684,0.9169811320754718,0.6006546644844517,0.866044651782739,0.852017937219731,0.9995726495726497,0.8165618448637317,0.9403726708074535,0.928312159709619,0.7572846621837975,0.9566105155691679,0.938149430974765]
["2009-01-30",2973.92,21.2,12.22,30.01,26.76,23.4,9.54,40.25,44.08,31.23,39.18,20.21,null,0.9241602625257539,0.8829654310703873,0.7709779179810726,0.9920661157024794,0.8860927152317881,0.9733777038269551,1.1925,0.9321445113478463,0.9709251101321585,0.9152989449003518,1.0069390902081727,0.8688736027515047]
["2008-12-31",3217.97,24.01,15.85,30.25,30.2,24.04,8,43.18,45.4,34.12,38.91,23.26,null,0.9862965414934961,1.161586840832124,1.060200668896321,0.698291782086796,0.9373060211049038,0.9263969171483623,0.9174311926605504,0.9536219081272085,1.0448791714614498,1.0783817951959545,0.9478684531059683,1.0453932584269663]
["2008-11-28",3262.68,20.67,14.95,43.32,32.22,25.95,8.72,45.28,43.45,31.64,41.05,22.25,null,0.9356508472729254,0.9961445783132531,1.0067340067340067,0.7735714285714286,0.9710669077757685,0.9022948539638386,0.7758007117437723,1.0423572744014733,0.8790208375480478,0.7915936952714536,0.9586641756188696,1.090686274509804]
["2008-10-31",3487.07,20.75,14.85,56,33.18,28.76,11.24,43.44,49.43,39.97,42.82,20.4,null,0.8648272612286402,0.8118153364632238,0.648471615720524,0.8474576271186441,1.0450393700787401,0.9944674965421854,0.8388059701492537,0.8687999999999999,1.0618689581095597,0.6802246426140232,1.0056364490371066,0.9264305177111716]
["2008-09-30",4032.1,25.56,22.9,66.08,31.75,28.92,13.4,50,46.55,58.76,42.58,22.02,null,0.8995002900102618,0.8258481421647819,1.0475754803293686,1.0748210800260247,0.7698836081474296,0.9163498098859316,0.9228650137741047,1.0506408909434755,0.9576218885003085,0.9379090183559458,0.8682707993474714,0.8328290468986383]
["2008-08-29",4482.6,30.95,21.86,61.48,41.24,31.56,14.52,47.59,48.61,62.65,49.04,26.44,null,1.0205447640903753,1.0509337860780985,1.1517386722866174,0.9636363636363636,0.9880210828941064,1.0969760166840459,1.0544662309368191,0.9966492146596859,1.0785444863545595,1.1045486600846262,0.9927125506072875,0.9803485354097146]
["2008-07-31",4392.36,29.45,18.98,63.8,41.74,28.77,13.77,47.75,45.07,56.72,49.4,26.97,null,0.9904190671612342,1.014817367332874,1.0063626723223755,1.1087938825165102,0.9900379506641368,0.9159503342884432,1.0608628659476116,1.0706278026905829,1.0622201272684422,1.0822362144628888,0.9114391143911439,1.1190871369294604]
["2008-06-30",4434.85,29.02,18.86,57.54,42.16,31.41,12.98,44.6,42.43,52.41,54.2,24.1,null,0.8844440278564422,0.8649776453055142,0.8304711580801408,0.8673500150738619,0.8032006096399313,0.7978155956311913,0.7630805408583186,0.7926070730406967,0.8856188687121687,0.8278313062707312,0.966304154038153,0.8919319022945966]
["2008-05-30",5014.28,33.55,22.71,66.34,52.49,39.37,17.01,56.27,47.91,63.31,56.09,27.02,null,1.003550456916186,0.9204389574759944,0.9502092050209205,0.9579783393501805,1.0930862140774678,0.9964565932675272,0.7856812933025406,0.9899718508092892,0.9553339980059821,0.8886861313868614,1.0398591027067112,1.036440352896049]
["2008-04-30",4996.54,36.45,23.9,69.25,48.02,39.51,21.65,56.84,50.15,71.24,53.94,26.07,null,1.0614968547312873,1.1520227560050569,1.0395824271422358,1.083894193144467,1.1933399602385686,0.9255094869992972,1.1045918367346936,1.0035310734463276,1.0553451178451176,1.21197686287853,1.1466836734693877,1.0533333333333335]
["2008-03-31",4707.07,31.64,22.99,63.89,40.24,42.69,19.6,56.64,47.52,58.78,47.04,24.75,null,0.9825514647251109,0.9792633859486226,1.0226868327402134,1.0725197246936378,0.8855633802816902,1.0468366846493378,1.0864745011086476,1.0896498653328204,0.9739700758352122,0.8722362368303903,0.9409881976395279,0.9439359267734554]
["2008-02-29",4790.66,32.31,22.48,59.57,45.44,40.78,18.04,51.98,48.79,67.39,49.99,26.22,null,0.983750839358576,0.9263188073394495,0.9825174825174826,0.9049065775482303,0.8852522891096825,0.9929388848307767,0.8804294777940459,0.9620581158615583,0.8977000919963201,0.8545523712908952,1.0262779716690618,0.9765363128491619]
["2008-01-31",4869.79,34.88,22.88,65.83,51.33,41.07,20.49,54.03,54.35,78.86,48.71,26.85,null,0.8674244043547652,0.9323710237904305,0.8353413654618473,0.8869576933441121,0.9005263157894736,0.8822771213748658,0.8881664499349804,0.8799674267100978,0.862972372181645,0.8409939212967901,0.857117719514341,0.855640535372849]
["2007-12-31",5614.08,37.41,27.39,74.22,57,46.55,23.07,61.4,62.98,93.77,56.83,31.38,null,0.9900380385040658,0.9456521739130433,0.9806659505907627,0.9620220349967594,0.9310682783404116,1.00713976633492,0.9604496253122399,1.018918021905078,0.9687740347638824,0.9370440691515939,1.028969762810067,0.9996814272061165]
["2007-11-30",5670.57,39.56,27.93,77.15,61.22,46.22,24.02,60.26,65.01,100.07,55.23,31.39,null,0.9696680033174018,0.8781354051054385,0.9050550874918989,1.0139308713365751,0.9239360096589193,1.0647316286569914,0.8801758886038842,1.0184214973804293,1.0738354806739348,0.9113013386758947,0.9924528301886792,1.00997425997426]
["2007-10-31",5847.95,45.05,30.86,76.09,66.26,43.41,27.29,59.17,60.54,109.81,55.65,31.08,null,1.0231398133908591,1.0580084546735555,0.9834289356277884,0.9915298410216316,1.0953876673830385,1.0114165890027957,1.0088724584103512,1.0719202898550724,1.0195351970360391,0.9844898691052537,0.9759733426867765,1.0499999999999998]
["2007-09-28",5715.69,42.58,31.38,76.74,60.49,42.92,27.05,55.2,59.38,111.54,57.02,29.6,null,1.0093577268794038,0.9881643072638662,1.0669840190411424,0.9912167398605011,1.046358761459955,0.9563279857397504,0.9765342960288809,0.9873010194956181,0.9909879839786382,0.9942062572421785,1.0320361990950226,0.9863378873708764]
["2007-08-31",5662.7,43.09,29.41,77.42,57.81,44.88,27.7,55.91,59.92,112.19,55.25,30.01,null,0.9846324516438651,0.9953799953799954,1.0130899069927661,0.9472653860271626,0.9775109908691242,0.9814126394052046,0.9770723104056437,1.0409607149506608,0.974308943089431,0.9288020531500951,0.948009608785175,0.9581736909323116]
["2007-07-31",5751.08,43.29,29.03,81.73,59.14,45.73,28.35,53.71,61.5,120.79,58.28,31.32,null,0.9498177518154627,0.9630700778642936,0.9069040924711028,0.9249660479855139,0.9509567454574691,1.0039517014270032,0.939052666445843,0.8948683772075975,1.0232945091514143,0.9266589950134255,0.9671423830069699,0.9815104982764024]
["2007-06-29",6054.93,44.95,32.01,88.36,62.19,45.55,30.19,60.02,60.1,130.35,60.26,31.91,null,0.991961009174312,0.9511214557765554,0.9852262234533702,0.9798181414947881,0.9480182926829269,0.9627985626717395,0.9840286831812256,1.0309172105805566,0.8386826681551773,0.9497959778490235,1.0760714285714286,0.9854848672019765]
["2007-05-31",6104,47.26,32.49,90.18,65.6,47.31,30.68,58.22,71.66,137.24,56,32.38,null,1.0241542003073805,0.9945286195286194,0.9575596816976129,1.0528896672504378,1.1179277436946147,0.9563371740448757,0.9871299871299872,0.9610432485968967,1.0619442797866032,0.9252342749275264,1.0282776349614395,1.065832784726794]
["2007-04-30",5960.04,47.52,33.93,85.65,58.68,49.47,31.08,60.58,67.48,148.33,54.46,30.38,null,1.0578400329419115,0.9711833231146536,1.0689981096408319,1.0954086200281368,1.0143474503025065,1.0342881037006064,1.0647482014388487,0.9906786590351594,1.0365591397849463,1.2096721578861525,1.0383222116301238,0.9986850756081525]
["2007-03-30",5634.16,48.93,31.74,78.19,57.85,47.83,29.19,61.15,65.1,122.62,52.45,30.42]

{"sheet":"Résultats","index":2,"n_rows":12,"n_cols":21,"rows_kept":12,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Noms","Moyenne","Ecart-Type","Skewness","Kurtosis","Beta","Décision d'achat"]
["Accor",null,"                ",null,"             ",null,"            ",null,"            ",null,"         ",null,"             ",null,"               ",null,"       ",null,"               ",null,"               "]
["Axa"]
["BNP-Paribas"]
["Bouygues"]
["Carrefour"]
["Crédit Agricole"]
["Danone"]
["Sanofi"]
["Société Générale"]
["Total"]
["Vivendi"]

{"sheet":"Matrice Variance.Covariance","index":3,"n_rows":77,"n_cols":13,"rows_kept":77,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"CAC40","Accor","Axa","BNP-Paribas","Bouygues","Carrefour","Crédit Agricole","Danone","Sanofi","Société Générale","Total","Vivendi"]
["CAC40",0.003515804202374684,0.004238751319746285,0.006372145403880258,0.0049349113560616335,0.003679095426172304,0.002484900238676319,0.005906489563410444,0.0017681447159029248,0.0019658923480617417,0.007307457079085215,0.0024119363655360705,0.002857062752358237]
["Accor",0.004238751319746285,0.010161621301144562,0.007574061996018529,0.0043645664580911105,0.004975545598047469,0.002109639707287507,0.008043095200346526,0.002143147610612307,0.0021926573405098644,0.009440899711042049,0.0022159569663548514,0.003362504491757736]
["Axa",0.006372145403880258,0.007574061996018529,0.017748150784981445,0.009766001366845318,0.006246408937623022,0.00401084259587253,0.011553572285226318,0.0034005473478888625,0.0028111902174087996,0.015344664730939678,0.0031440871090031896,0.004635149159701489]
["BNP-Paribas",0.0049349113560616335,0.0043645664580911105,0.009766001366845318,0.01246158780001768,0.0047830900324096455,0.004425478588829249,0.011282062687714027,0.00213441717959972,0.0027249862677393172,0.01240382252848823,0.003029540151959446,0.0025387514383347506]
["Bouygues",0.003679095426172304,0.004975545598047469,0.006246408937623022,0.0047830900324096455,0.008175179937544753,0.002594876096263133,0.006232165947479306,0.0012701605068561291,0.00258342345714491,0.00743441222777829,0.0027195777393679644,0.004250574072517732]
["Carrefour",0.002484900238676319,0.002109639707287507,0.00401084259587253,0.004425478588829249,0.002594876096263133,0.005397916498171474,0.00499120626812354,0.0010091401705146494,0.001701864310293732,0.004745099437114407,0.001721432648495484,0.001998347790024724]
["Crédit Agricole",0.005906489563410444,0.008043095200346526,0.011553572285226318,0.011282062687714027,0.006232165947479306,0.00499120626812354,0.01792767029441097,0.002478075849366334,0.0031953594464527993,0.0157220619575697,0.0033566006547049334,0.004023664329136102]
["Danone",0.0017681447159029248,0.002143147610612307,0.0034005473478888625,0.00213441717959972,0.0012701605068561291,0.0010091401705146494,0.002478075849366334,0.003195445936508743,0.001145893875423226,0.0024610145908159566,0.000654382266783641,0.0017320695531653837]
["Sanofi",0.0019658923480617417,0.0021926573405098644,0.0028111902174087996,0.0027249862677393172,0.00258342345714491,0.001701864310293732,0.0031953594464527993,0.001145893875423226,0.0036042915413689075,0.0037004492279284315,0.0012355281329442104,0.0017918210804942487]
["Société Générale",0.007307457079085215,0.009440899711042049,0.015344664730939678,0.01240382252848823,0.00743441222777829,0.004745099437114407,0.0157220619575697,0.0024610145908159566,0.0037004492279284315,0.020616277882759576,0.0043567786111789325,0.0051306446942504]
["Total",0.0024119363655360705,0.0022159569663548514,0.0031440871090031896,0.003029540151959446,0.0027195777393679644,0.001721432648495484,0.0033566006547049334,0.000654382266783641,0.0012355281329442104,0.0043567786111789325,0.0032065671761108212,0.0019738402658255874]
["Vivendi",0.002857062752358237,0.003362504491757736,0.004635149159701489,0.0025387514383347506,0.004250574072517732,0.001998347790024724,0.004023664329136102,0.0017320695531653837,0.0017918210804942487,0.0051306446942504,0.0019738402658255874,0.004869835365495116]
[]
[]
[]
[]
["rendements :"]
[null,1.0427672765305966,1.1041756349547998,1.060344827586207,1.1393265369168986,1.0563973063973064,1.0286532951289398,1.0849256900212314,1.0542602797795677,0.9987604037542057,1.1797642436149312,1.0316831683168317,1.031875]
[null,1.0439077033112751,1.186414708886619,1.155378486055777,1.0665568369028005,0.9761709120788825,0.9903518728717365,1.0802752293577982,0.9713815112209182,0.9950660792951541,1.1837209302325582,1.0227848101265822,0.9456264775413711]
[null,1.0016452060787036,0.9458937198067633,0.9365671641791044,1.0298608754665763,1.0041254125412542,0.8921518987341772,0.9178947368421053,0.990415986949429,1.0894605490497216,0.9513274336283186,1.0302556077203964,0.9883177570093459]
[null,0.972795450901062,0.8712121212121211,0.9107901444350044,0.8971080669710806,0.8924889543446244,1.0270410816432658,0.8362676056338029,0.9749502982107356,1.0025019245573519,0.8568720379146918,1.013749338974088,1.0535384615384615]
[null,1.0874860829789803,1.1791563275434245,1.1888888888888889,1.0931780366056572,1.0890136327185245,1.1219369894982496,1.0860420650095601,1.0887445887445886,1.0528875379939209,1.0550000000000002,1.1377858002406738,1.0593220338983051]
[null,0.915621660791707,0.8043912175648702,0.8855098389982111,0.837747421243379,0.9333832335329342,0.923491379310345,0.7668621700879765,0.9714045416316233,0.9741413343861035,0.8561643835616438,0.9776470588235294,0.9044811320754716]
[null,0.8870911507703035,0.8141046473838155,0.8527841342486652,0.7890453145622525,1.0125047366426676,0.9009708737864076,0.7911832946635732,0.9550200803212853,0.9331368576165039,0.6724237190558433,0.899947061937533,1.0155688622754493]
[null,0.9219202402685946,0.9977302204928664,0.8366305041480536,0.8540296825098629,0.8703825857519789,0.8326596604688764,0.8312439729990356,0.9679300291545189,0.9792568542568543,0.8489736070381232,0.9473420260782347,0.8706986444212721]
[null,0.9938282080590176,0.9692017598994344,1.0559299191374663,0.9817410549612688,0.9445482866043613,0.9200446262551133,0.9764595103578154,1.0098135426889108,1.0076335877862594,0.9922405431619786,0.9962528103922059,0.988659793814433]
[null,0.9756557225365967,1.0606666666666666,0.9795379537953796,1.0147857009170878,0.9547888161808449,0.9617310443490701,0.9448398576512455,1.0301253538212698,1.0303370786516854,0.913197519929141,0.9261915779731607,0.9159584513692162]
[null,1.029514837635805,0.9463722397476341,1.0278154681139755,1.035264483627204,0.9923258559622194,1.024551117625504,0.9706390328151986,1.0728850325379609,1.0792239288601455,0.9849509269356597,1.0060521415270018,1.0511166253101738]
[null,0.9705207585728708,0.9301643192488264,0.9684625492772667,0.9121597737716508,1.0113432835820897,0.8780566280566281,0.910377358490566,1.0147479639005064,0.9895999999999999,0.8999018645731108,0.9673496960144112,0.9753146176185865]
[null,1.0261765073024591,1.0203592814371258,0.9844760672703752,1.0362637362637361,0.9850044104675096,0.9942418426103646,1.1788693234476368,1.0327347124346442,1.0024057738572574,1.0787634977768368,1.039559925093633,0.9866284622731614]
[null,1.0527546927811857,1.003003003003003,1.2417670682730926,1.146817895400126,1.0542467451952884,1.1599257884972172,1.1357894736842105,0.9355593364525734,1.0424242424242425,1.1742913973147688,1.0774274905422447,1.0366336633663367]
[null,1.0538272343537076,1.0227272727272725,1.1256781193490053,1.044078947368421,1.0494469746258945,0.8850574712643678,1.00635593220339,1.0421099290780143,1.027264920566767,1.1266106442577029,1.062433011789925,1.0744680851063828]
[null,0.9418129646537107,1.1052274270196878,0.845565749235474,0.867745004757374,0.9709412507896399,0.8987603305785123,0.801358234295416,0.9920844327176781,0.9282582702271821,0.8298465829846583,0.9559426229508197,0.9170731707317074]
[null,1.0318477166651414,1.1000746825989545,1.0202808112324493,1.007283879624305,1.00571791613723,0.9840255591054314,1.0279232111692844,1.0364630811303555,1.026595744680851,1.018224852071006,1.0328042328042328,1.0224438902743143]
[null,1.0642805783218126,1.1061544816191657,1.0456769983686787,1.0567146040105329,0.9825218476903871,1.0999999999999999,1.1529175050301812,1.0349056603773585,1.0797437596642367,1.051518168242907,1.0252237591537836,1.089082020640956]
[null,0.9581816784422229,0.9738535800482704,0.867043847241867,0.9366344147220641,0.9888888888888889,1.0142579390797148,0.9457659372026641,0.9851301115241635,1.0157056315907562,0.9082278481012658,0.9524670627744768,0.9983731019522776]
[null,1.0581633453290695,0.9503058103975535,1.10989010989011,1.177350904623632,1.0150375939849623,1.079020979020979,1.2164351851851851,0.9737556561085972,0.8998586715122148,1.289795918367347,1.0473484848484849,1.0963139120095124]
[null,0.9815626817502765,0.9860535243120995,0.9465081723625557,0.9669546436285098,0.9161882893226176,0.9711375212224109,0.9729729729729729,1.0518800571156592,1.0016177957532861,0.978601997146933,0.979591836734694,0.953514739229025]
[null,0.9189335051965031,0.9023809523809525,0.8913907284768212,0.8881642048724342,0.9298105150787298,0.9151646985705407,0.8207024029574862,0.9468228931951329,0.9572202864885793,0.8675742574257426,0.9209177446912374,0.8909090909090909]
[null,0.9604882725508994,1.0496251338807567,0.9168184578020644,0.916813225466057,1.006716818914562,1.0324029515559832,0.8348765432098765,0.9950672645739911,0.9360391375249139,0.8676975945017181,0.9532340623545835,0.9989909182643795]
[null,1.0715083045729077,1.1027559055118112,1.1143437077131257,1.0702051571616789,1.1011834319526628,1.0530405405405405,1.1868131868131868,1.038416763678696,1.0273641102010425,1.1524752475247526,1.0488042947779406,1.0713513513513513]
[null,0.9918009552181332,1.014782261286456,0.9853333333333333,1.018791946308725,0.944925915571708,0.9588597343699384,0.9545454545454546,1.0364382239382242,1.0022388059701492,0.9573459715639809,0.9745541022592152,0.9814323607427055]
[null,0.9499864086598431,0.9568042813455658,0.9068923821039904,0.9329159212880143,0.9821526633717738,1.0528649386084583,0.9255663430420712,0.9675461125379407,0.9734834725753723,0.8621041879468846,0.9344444444444444,0.90625]
[null,1.0696112930179476,1.0734509643003693,1.0422180214240706,1.0163636363636364,1.0989740494870248,1.0386114063053489,0.8969521044992743,1.0758603365988444,1.0941971383147855,1.0439326082320324,1.0919679689395778,1.0838978634705576]
[null,1.020084874254717,1.0903803131991052,0.9324324324324325,1.0689990281827015,1.0307931570762054,1.1040281579976534,1.0519083969465648,0.971923828125,1.0116606353035786,1.0332745702952841,1.014025590551181,1.0142706131078223]
[null,0.9505402578377568,0.8589546502690238,0.9199999999999999,0.9423076923076923,0.9251798561151079,0.9442392909896603,0.9173669467787116,0.9946576007770763,0.9918245264207378,0.8705160176481872,1.000985221674877,0.8949858088930938]
[null,1.0388308325623916,1.0362405416168856,1.1649874055415617,0.9720491365497597,1.0037550548815715,0.9438828860230044,1.1052631578947367,1.0856841550224097,1.0598055790363483,0.9784159159159159,1.0157618213660247,1.0639154504277806]
[null,1.066331608425489,1.22607421875,1.0708024275118004,1.0981427174975562,1.1586345381526104,0.9972193256864791,1.2894211576846308,1.0077045696068012,1.0295909486510009,1.247775175644028,1.027242354150604,1.102663706992231]
[null,1.0910159085987952,1.060041407867495,1.1075429424943988,1.105945945945946,1.1149253731343283,1.0828001505457283,1.1283783783783783,1.069926094371802,1.0976833054693098,1.1584373304395008,1.011174636174636,1.057511737089202]
[null,0.9581376901133434,0.9015398973401774,1.021357742181541,0.9487179487179487,0.9250949257852952,0.9630300833635376,0.8596321393998064,1.0014232849416453,0.9314794215795327,0.9485331960885229,0.9442944785276073,0.9176090468497576]
[null,1.037280250644809,0.9723230490018149,1.0290423861852434,1.2111801242236024,0.8908364083640835,1.0226093402520384,0.9223214285714286,0.9720531267293858,1.0269591044094128,1.046875,1.0628586332811685,0.9071812408402541]
[null,1.1255672629606672,1.2292247629670943,1.407734806629834,1.2933804627249357,1.2080237741456168,1.0506230529595015,1.3477737665463296,0.9858156028368795,1.0327984898537046,1.3276108726752502,1.0245857830037413,1.0276104417670682]
[null,1.0388013972351322,0.9223251028806584,1.2329700272479565,1.1973836090804157,1.180701754385965,1.0979050876442924,1.0667522464698331,0.9685601056803169,1.0356793743890518,1.1822410147991544,0.9983991462113129,1.0506329113924051]
[null,0.9087265292946684,0.9169811320754718,0.6006546644844517,0.866044651782739,0.852017937219731,0.9995726495726497,0.8165618448637317,0.9403726708074535,0.928312159709619,0.7572846621837975,0.9566105155691679,0.938149430974765]
[null,0.9241602625257539,0.8829654310703873,0.7709779179810726,0.9920661157024794,0.8860927152317881,0.9733777038269551,1.1925,0.9321445113478463,0.9709251101321585,0.9152989449003518,1.0069390902081727,0.8688736027515047]
[null,0.9862965414934961,1.161586840832124,1.060200668896321,0.698291782086796,0.9373060211049038,0.9263969171483623,0.9174311926605504,0.9536219081272085,1.0448791714614498,1.0783817951959545,0.9478684531059683,1.0453932584269663]
[null,0.9356508472729254,0.9961445783132531,1.0067340067340067,0.7735714285714286,0.9710669077757685,0.9022948539638386,0.7758007117437723,1.0423572744014733,0.8790208375480478,0.7915936952714536,0.9586641756188696,1.090686274509804]
[null,0.8648272612286402,0.8118153364632238,0.648471615720524,0.8474576271186441,1.0450393700787401,0.9944674965421854,0.8388059701492537,0.8687999999999999,1.0618689581095597,0.6802246426140232,1.0056364490371066,0.9264305177111716]
[null,0.8995002900102618,0.8258481421647819,1.0475754803293686,1.0748210800260247,0.7698836081474296,0.9163498098859316,0.9228650137741047,1.0506408909434755,0.9576218885003085,0.9379090183559458,0.8682707993474714,0.8328290468986383]
[null,1.0205447640903753,1.0509337860780985,1.1517386722866174,0.9636363636363636,0.9880210828941064,1.0969760166840459,1.0544662309368191,0.9966492146596859,1.0785444863545595,1.1045486600846262,0.9927125506072875,0.9803485354097146]
[null,0.9904190671612342,1.014817367332874,1.0063626723223755,1.1087938825165102,0.9900379506641368,0.9159503342884432,1.0608628659476116,1.0706278026905829,1.0622201272684422,1.0822362144628888,0.9114391143911439,1.1190871369294604]
[null,0.8844440278564422,0.8649776453055142,0.8304711580801408,0.8673500150738619,0.8032006096399313,0.7978155956311913,0.7630805408583186,0.7926070730406967,0.8856188687121687,0.8278313062707312,0.966304154038153,0.8919319022945966]
[null,1.003550456916186,0.9204389574759944,0.9502092050209205,0.9579783393501805,1.0930862140774678,0.9964565932675272,0.7856812933025406,0.9899718508092892,0.9553339980059821,0.8886861313868614,1.0398591027067112,1.036440352896049]
[null,1.0614968547312873,1.1520227560050569,1.0395824271422358,1.083894193144467,1.1933399602385686,0.9255094869992972,1.1045918367346936,1.0035310734463276,1.0553451178451176,1.21197686287853,1.1466836734693877,1.0533333333333335]
[null,0.9825514647251109,0.9792633859486226,1.0226868327402134,1.0725197246936378,0.8855633802816902,1.0468366846493378,1.0864745011086476,1.0896498653328204,0.9739700758352122,0.8722362368303903,0.9409881976395279,0.9439359267734554]
[null,0.983750839358576,0.9263188073394495,0.9825174825174826,0.9049065775482303,0.8852522891096825,0.9929388848307767,0.8804294777940459,0.9620581158615583,0.8977000919963201,0.8545523712908952,1.0262779716690618,0.9765363128491619]
[null,0.8674244043547652,0.9323710237904305,0.8353413654618473,0.8869576933441121,0.9005263157894736,0.8822771213748658,0.8881664499349804,0.8799674267100978,0.862972372181645,0.8409939212967901,0.857117719514341,0.855640535372849]
[null,0.9900380385040658,0.9456521739130433,0.9806659505907627,0.9620220349967594,0.9310682783404116,1.00713976633492,0.9604496253122399,1.018918021905078,0.9687740347638824,0.9370440691515939,1.028969762810067,0.9996814272061165]
[null,0.9696680033174018,0.8781354051054385,0.9050550874918989,1.0139308713365751,0.9239360096589193,1.0647316286569914,0.8801758886038842,1.0184214973804293,1.0738354806739348,0.9113013386758947,0.9924528301886792,1.00997425997426]
[null,1.0231398133908591,1.0580084546735555,0.9834289356277884,0.9915298410216316,1.0953876673830385,1.0114165890027957,1.0088724584103512,1.0719202898550724,1.0195351970360391,0.9844898691052537,0.9759733426867765,1.0499999999999998]
[null,1.0093577268794038,0.9881643072638662,1.0669840190411424,0.9912167398605011,1.046358761459955,0.9563279857397504,0.9765342960288809,0.9873010194956181,0.9909879839786382,0.9942062572421785,1.0320361990950226,0.9863378873708764]
[null,0.9846324516438651,0.9953799953799954,1.0130899069927661,0.9472653860271626,0.9775109908691242,0.9814126394052046,0.9770723104056437,1.0409607149506608,0.974308943089431,0.9288020531500951,0.948009608785175,0.9581736909323116]
[null,0.9498177518154627,0.9630700778642936,0.9069040924711028,0.9249660479855139,0.9509567454574691,1.0039517014270032,0.939052666445843,0.8948683772075975,1.0232945091514143,0.9266589950134255,0.9671423830069699,0.9815104982764024]
[null,0.991961009174312,0.9511214557765554,0.9852262234533702,0.9798181414947881,0.9480182926829269,0.9627985626717395,0.9840286831812256,1.0309172105805566,0.8386826681551773,0.9497959778490235,1.0760714285714286,0.9854848672019765]
[null,1.0241542003073805,0.9945286195286194,0.9575596816976129,1.0528896672504378,1.1179277436946147,0.9563371740448757,0.9871299871299872,0.9610432485968967,1.0619442797866032,0.9252342749275264,1.0282776349614395,1.065832784726794]
[null,1.0578400329419115,0.9711833231146536,1.0689981096408319,1.0954086200281368,1.0143474503025065,1.0342881037006064,1.0647482014388487,0.9906786590351594,1.0365591397849463,1.2096721578861525,1.0383222116301238,0.9986850756081525]