{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Tools","Matrice","Covariance","Cholesky","ValVecPropres","Halton","Calcul Matriciel","Exercice1","ExoCorrec1","Exercice2","ExoCorrec2","Rates","CalculVAR","MonteCarlo","Réponses"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":4,"defined_names":14,"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":"Tools","index":0,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["FONCTIONS EXCEL POUR LA VALUE AT RISK"]
[]
[null,"Fonction ","Calcul","Entrée","Sortie"]
[]
[null,"MInverse(M)","Inverse la matrice","Matrice carrée nxn","Matrice carrée nxn"]
[null,"MTranspose(M)","Transpose la matrice","Matrice ou Vecteur","Matrice ou Vecteur"]
[null,"MDeterminant(M)","Déterminant de la matrice","Matrice carrée nxn","Nombre"]
[null,"MProd(Mx, My)","Produit matriciel","2 Matrices compatibles","Matrice ou Nombre"]
[null,"MTProd(Mx, My)","Produit transposée x matrice: tMx My","2 Matrices compatibles","Matrice ou Nombre"]
[null,"MQuadProd(Mx, My)","Produit quadratique: tMx My Mx","2 Matrices compatibles","Nombre"]
[null,"MQuadProdBaseR(Mx, My)","Produit quadratique: Mx My inv(Mx)","2 Matrices compatibles","Nombre"]
[null,"MQuadProdBaseG(Mx, My)","Produit quadratique: inv(Mx) My Mx","2 Matrices compatibles","Nombre"]
[null,"MZero(n,m)","Matrice Zero","Tailles n et m ","Matrice nxm"]
[null,"MId(n)","Matrice Identité","Taille n","Matrice unitaire carrée nxn"]
[null,"MScal(n,k)","Matrice Scalaire de diagonale k","Taille n et k","Matrice diagonale carrée nxn"]
[null,"MDiagVP(P)","Matrice diagonale quelconque","Vecteur Colonne","Matrice diagonale nxn"]
[null,"MPlus(M,k)","Addition d'un nombre à une matrice","Matrice nxm et k","Matrice nxm"]
[null,"MMult(M,k)","Multiplication d'un nombre par une matrice","Matrice nxm et k","Matrice nxm"]
[]
[null,"MCentre(M)","Matrice Centrée","Matrice carrée nxm","Matrice carrée nxm"]
[null,"MReduit(M)","Matrice Centrée Réduite","Matrice carrée nxm","Matrice carrée nxm"]
[null,"MCovariance(M)","Matrice de Covariance de M","Matrice carrée nxm","Matrice carrée symétrique mxm"]
[null,"MCorrelation(M)","Matrice de Corrélation de M","Matrice carrée nxm","Matrice carrée symétrique mxm"]
[null,"MCholesky(M)","Matrice \"Racine Carrée\" de Cholesky ","Matrice carrée nxn","Matrice carrée triangulaire inférieure nxn"]
[]
[null,"MValP(M)","Valeurs Propres de M","Matrice carrée nxn","Vecteur horizontal n"]
[null,"MVecP(M)","Vecteurs Propres de M","Matrice carrée nxn","Matrice carrée nxn"]
[]
[null,"Halton(p,k)","Nombres de Halton","Base (p) er Rang (k)","Nombre"]

{"sheet":"Matrice","index":1,"n_rows":85,"n_cols":6,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
["FONCTIONS MATRICIELLES"]
[]
[null,"Matrice Mx"]
[null,15,-85,0,-20]
[null,3,55,6,55]
[null,-7,1,-33,0]
[null,2,-4,8,4]
[]
[null,"Déterminant de la matrice"]
[null,{"$f":"Mdeterminant($B$4:$E$7)","v":-199509.99999999991},null,null,null,{"$f":"form(B10)","v":"=Mdeterminant($B$4:$E$7)"}]
[null,"Inverse de la matrice"]
[null,{"$f":"_xludf.Minverse($B$4:$E$7)","v":7.069319833592301E-2},6.8668237181093675E-2,-0.1307202646483886,-0.59072226956042329,{"$f":"form(B12)","v":"=Minverse($B$4:$E$7)"}]
[null,1.6139541877600127E-3,1.0926770587940456E-2,-3.2479574958648699E-2,-0.14217332464538124]
[null,-1.4946619217081852E-2,-1.4234875444839857E-2,-3.5587188612099577E-3,0.12099644128113882]
[null,-3.8394065460377936E-3,5.0624028870733277E-3,3.9997995087965532E-2,0.16119492757255283]
[null,"Transpose de la matrice"]
[null,{"$f":"MTran($B$4:$E$7)","v":15},3,-7,2,{"$f":"form(B17)","v":"=MTran($B$4:$E$7)"}]
[null,-85,55,1,-4]
[null,0,6,-33,8]
[null,-20,55,0,4]
[null,"Produit de 2 matrices: Mx My"]
[null,{"$f":"MProd($B$4:$E$7,$B$4:$E$7)","v":-70},-5870,-670,-5055,{"$f":"form(B22)","v":"=MProd($B$4:$E$7;$B$4:$E$7)"}]
[null,278,2556,572,3185]
[null,129,617,1095,195]
[null,-30,-398,-256,-244]
[null,"Produit de 2 matrices: t(Mx) My"]
[null,{"$f":"MTProd($B$4:$E$7,$B$4:$E$7)","v":287},-1125,265,-127,{"$f":"form(B27)","v":"=MTProd($B$4:$E$7;$B$4:$E$7)"}]
[null,-1125,10267,265,4709]
[null,265,265,1189,362]
[null,-127,4709,362,3441]
[null,"Produit scalaire: t(Mx) Mx"]
[null,{"$f":"MSProd($B$4:$E$7)","v":287},-1125,265,-127,{"$f":"form(B32)","v":"=MSProd($B$4:$E$7)"}]
[null,-1125,10267,265,4709]
[null,265,265,1189,362]
[null,-127,4709,362,3441]
[null,"Produit quadratique 2 matrices: t(Mx) My Mx"]
[null,{"$f":"MQuadProd($B$4:$E$7,$B$4:$E$7)","v":-1179},-85497,-16511,-68123,{"$f":"form(B37)","v":"=MQuadProd($B$4:$E$7;$B$4:$E$7)"}]
[null,21489,641739,90529,606021]
[null,-2829,-8209,-34751,10723]
[null,16570,256388,43836,275299]
[null,"Produit quadratique 2 matrices: inv(Mx) My Mx"]
[null,{"$f":"MQuadProdBaseG($B$4:$E$7,$B$4:$E$7)","v":15.000000000000002},-84.999999999999957,-1.7763568394002505E-15,-19.999999999999954,{"$f":"form(B42)","v":"=MQuadProdBaseG($B$4:$E$7;$B$4:$E$7)"}]
[null,3.0000000000000013,55,6.0000000000000053,55]
[null,-7,1.0000000000000016,-33,1.4432899320127035E-15]
[null,1.9999999999999978,-4.0000000000000187,7.9999999999999929,3.9999999999999827]
[null,"Produit quadratique 2 matrices: Mx My inv(Mx)"]
[null,{"$f":"MQuadProdBaseR($B$4:$E$7,$B$4:$E$7)","v":15.000000000000002},-85,0,-20,{"$f":"form(B47)","v":"=MQuadProdBaseR($B$4:$E$7;$B$4:$E$7)"}]
[null,3,55,6.0000000000000142,55.000000000000057]
[null,-7.0000000000000036,1.0000000000000013,-33,-1.0658141036401503E-14]
[null,2,-3.9999999999999996,7.9999999999999982,4.0000000000000142]
[]
[null,"Addition à 1 matrice d'un scalaire: Mx + N ",null,null,10]
[null,{"$f":"MPlusScal($B$4:$E$7,E52)","v":25},-75,10,-10,{"$f":"form(B53)","v":"=MPlusScal($B$4:$E$7;E52)"}]
[null,13,65,16,65]
[null,3,11,-23,10]
[null,12,6,18,14]
[null,"Produit de 1 matrice par un scalaire: Mx . N ",null,null,10]
[null,{"$f":"MMultScal($B$4:$E$7,E57)","v":150},-850,0,-200,{"$f":"form(B58)","v":"=MMultScal($B$4:$E$7;E57)"}]
[null,30,550,60,550]
[null,-70,10,-330,0]
[null,20,-40,80,40]
[]
[null,"Matrice zero"]
[null,{"$f":"MZero(4,4)","v":0},0,0,0,{"$f":"form(B64)","v":"=MZero(4;4)"}]
[null,0,0,0,0]
[null,0,0,0,0]
[null,0,0,0,0]
[]
[null,"Matrice Identité"]
[null,{"$f":"_xludf.MId(4)","v":1},0,0,0,{"$f":"form(B70)","v":"=MId(4)"}]
[null,0,1,0,0]
[null,0,0,1,0]
[null,0,0,0,1]
[]
[null,"Matrice Scalaire"]
[null,{"$f":"MScal(4,5)","v":5},0,0,0,{"$f":"form(B76)","v":"=MScal(4;5)"}]
[null,0,5,0,0]
[null,0,0,5,0]
[null,0,0,0,5]
[]
[null,"Matrice Diag"]
[null,{"$f":"MDiagVP(B4:B7)","v":15},0,0,0,{"$f":"form(B82)","v":"=MDiagVP(B4:B7)"}]
[null,0,3,0,0]
[null,0,0,-7,0]
[null,0,0,0,2]

{"sheet":"Covariance","index":2,"n_rows":63,"n_cols":8,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
["FONCTIONS MCENTRE MREDUITE MCOVARIANCE MCORRELATION"]
["MATRICE DE COVARIANCE, MATRICE DE CORRELATION"]
[null,"Matrice Entrée"]
[null,null,1,2,3,4,5]
[null,1,1.0439000000000001,0.83889999999999998,1.0750999999999999,123.38,9.0623000000000005]
[null,2,1.0422,0.84140000000000004,1.0709,122.19,9.0485000000000007]
[null,3,1.0364,0.83977999999999997,1.0687,122.43,9.0343]
[null,4,1.0421,0.84240000000000004,1.0689,122.31,9.0259999999999998]
[null,5,1.0444,0.84645000000000004,1.0706,122.86,9.0975000000000001]
[null,6,1.0446,0.85277999999999998,1.0710999999999999,122.6,9.0928000000000004]
[null,7,1.0445,0.85299999999999998,1.0753999999999999,122.61,9.1077999999999992]
[null,8,1.0401,0.85128000000000004,1.0713999999999999,122.39,9.0777000000000001]
[null,9,1.0452999999999999,0.85299999999999998,1.0713999999999999,122.04,9.0757999999999992]
[null,10,1.0541,0.85618000000000005,1.0739000000000001,123.4,9.0862999999999996]
[null,"Calculs intermédiaires:"]
[null,"MOYENNE",{"$f":"AVERAGE(C5:C14)","v":1.04376},{"$f":"AVERAGE(D5:D14)","v":0.84751700000000008},{"$f":"AVERAGE(E5:E14)","v":1.0717400000000001},{"$f":"AVERAGE(F5:F14)","v":122.62100000000001},{"$f":"AVERAGE(G5:G14)","v":9.0708999999999982},{"$f":"form(C16)","v":"=MOYENNE(C5:C14)"}]
[null,"ECART TYPE",{"$f":"STDEVP(C5:C14)","v":4.2863037689832512E-3},{"$f":"STDEVP(D5:D14)","v":6.130964116678554E-3},{"$f":"STDEVP(E5:E14)","v":2.2204504047602575E-3},{"$f":"STDEVP(F5:F14)","v":0.4416435214061214},{"$f":"STDEVP(G5:G14)","v":2.6052792556652989E-2},{"$f":"form(C17)","v":"=ECARTYPEP(C5:C14)"}]
[null,"Matrice Centrée"]
[null,null,{"$f":"mcentre(MATAA)","v":1.4000000000002899E-4},-8.6170000000000968E-3,3.3599999999998076E-3,0.75899999999998613,-8.5999999999977206E-3,{"$f":"form(C19)","v":"=mcentre(MATAA)"}]
[null,null,-1.5600000000000058E-3,-6.1170000000000391E-3,-8.4000000000017394E-4,-0.4310000000000116,-2.2399999999997533E-2]
[null,null,-7.3600000000000332E-3,-7.7370000000001049E-3,-3.0400000000001537E-3,-0.1910000000000025,-3.659999999999819E-2]
[null,null,-1.6599999999999948E-3,-5.1170000000000382E-3,-2.8400000000001757E-3,-0.31100000000000705,-4.4899999999998386E-2]
[null,null,6.3999999999997392E-4,-1.0670000000000401E-3,-1.1400000000001409E-3,0.23899999999999011,2.6600000000001955E-2]
[null,null,8.399999999999519E-4,5.2629999999999066E-3,-6.4000000000019597E-4,-2.1000000000015007E-2,2.1900000000002251E-2]
[null,null,7.3999999999996291E-4,5.4829999999999046E-3,3.6599999999997745E-3,-1.1000000000009891E-2,3.6900000000001043E-2]
[null,null,-3.6599999999999966E-3,3.7629999999999608E-3,-3.4000000000022901E-4,-0.23100000000000875,6.8000000000019156E-3]
[null,null,1.5399999999998748E-3,5.4829999999999046E-3,-3.4000000000022901E-4,-0.58100000000000307,4.9000000000010147E-3]
[null,null,1.0340000000000016E-2,8.6629999999999763E-3,2.1599999999999397E-3,0.77899999999999636,1.5400000000001413E-2]
[null,"Matrice de Covariance"]
[null,null,{"$f":"MCovariance(MATAA)","v":1.8372400000000024E-5},1.6581679999999952E-5,5.3366000000001303E-6,1.0833400000000118E-3,5.8226999999999102E-5,{"$f":"form(C30)","v":"=MCovariance(MATAA)"}]
[null,null,1.6581679999999952E-5,3.758872100000004E-5,4.7722199999999936E-6,1.4330300000000564E-4,1.1991199999999831E-4]
[null,null,5.3366000000001303E-6,4.7722199999999936E-6,4.9303999999999909E-6,6.0356000000000971E-4,3.4869999999999685E-5]
[null,null,1.0833400000000118E-3,1.4330300000000564E-4,6.0356000000000971E-4,0.19504899999999925,3.7152000000000001E-3]
[null,null,5.8226999999999102E-5,1.1991199999999831E-4,3.4869999999999685E-5,3.7152000000000001E-3,6.7874799999999335E-4]
[]
[null,null,{"$f":"MMULT(TRANSPOSE(MATAA-$C$16:$G$16),(MATAA-$C$16:$G$16))/ROWS(MATAA)","v":1.8372400000000024E-5},1.6581679999999952E-5,5.3366000000001295E-6,1.0833400000000118E-3,5.8226999999999095E-5,{"$f":"form(C36)","v":"=PRODUITMAT(TRANSPOSE(MATAA-$C$16:$G$16);(MATAA-$C$16:$G$16))/LIGNES(MATAA)"}]
[null,null,1.6581679999999952E-5,3.758872100000004E-5,4.7722199999999936E-6,1.4330300000000564E-4,1.1991199999999831E-4]
[null,null,5.3366000000001295E-6,4.7722199999999936E-6,4.9303999999999909E-6,6.0356000000000971E-4,3.4869999999999685E-5]
[null,null,1.0833400000000118E-3,1.4330300000000564E-4,6.0356000000000971E-4,0.19504899999999922,3.7151999999999997E-3]
[null,null,5.8226999999999095E-5,1.1991199999999831E-4,3.4869999999999685E-5,3.7151999999999997E-3,6.7874799999999335E-4]
[null,"Matrice Réduite"]
[null,null,{"$f":"MReduit(MATAA)","v":3.2662174112312425E-2},-1.4054885717821921,1.5132065066311744,1.7185806271619133,-0.330098970428433,{"$f":"form(C42)","v":"=MReduit(MATAA)"}]
[null,null,-0.36394994010855014,-0.99772236202757658,-0.37830162665789363,-0.97590019803269845,-0.85979266716256331]
[null,null,-1.7170971533326482,-1.261954865948572,-1.3690916012378769,-0.43247549379174671,-1.4048398043817734]
[null,null,-0.38728006447448016,-0.83461587812573401,-1.2790197853669785,-0.7041878459122225,-1.7234236944465158]
[null,null,0.14931279594196264,-0.17403461832327244,-0.5134093504642413,0.54116043463990482,1.0210037922557313]
[null,null,0.19597304467382273,0.85842942477538153,-0.28822981078699511,-4.7549661621115451E-2,0.84060086655643507]
[null,null,0.17264292030789269,0.89431285123378657,1.6483142304375222,-2.4906965611065073E-2,1.4163548847456686]
[null,null,-0.85388255179313288,0.61376969892262667,-0.15312208698064741,-0.52304627783191604,0.26100848824588041]
[null,null,0.35928391523533304,0.89431285123378657,-0.15312208698064741,-1.3155406381832611,0.18807964594187038]
[null,null,2.4123348594374359,1.4129914700416573,0.97277561140578361,1.7638660191820141,0.59110745867438153]
[null,"Matrice de Corrélation"]
[null,null,{"$f":"MCorrelation(MATAA)","v":1.0000000000108988},0.63098176605476175,0.56071300412446234,0.57228184509816116,0.52141940195466907,{"$f":"form(C53)","v":"=MCorrelation(MATAA)"}]
[null,null,0.63098176605476175,0.99999999999960854,0.35055051126954628,5.2924241678386032E-2,0.75072277394114784]
[null,null,0.56071300412446234,0.35055051126954628,1.0000000000804996,0.61547087811875001,0.60277688322535772]
[null,null,0.57228184509816116,5.2924241678386032E-2,0.61547087811875001,1.0000000000003739,0.32289108367563824]
[null,null,0.52141940195466907,0.75072277394114784,0.60277688322535772,0.32289108367563824,0.99999999993929567]
[]
[null,null,{"$f":"MMULT(TRANSPOSE((MATAA-C16:G16)/C17:G17),(MATAA-C16:G16)/C17:G17)/ROWS(MATAA)","v":0.99999999999999978},0.63098176605144674,0.56071300409883817,0.57228184509493552,0.52141940196765391,{"$f":"form(C59)","v":"=PRODUITMAT(TRANSPOSE((MATAA-C16:G16)/C17:G17);(MATAA-C16:G16)/C17:G17)/LIGNES(MATAA)"}]
[null,null,0.63098176605144674,1.0000000000000002,0.35055051125550535,5.2924241678386517E-2,0.7507227739640806]
[null,null,0.56071300409883817,0.35055051125550535,0.99999999999999978,0.61547087809386247,0.6027768832193916]
[null,null,0.57228184509493552,5.2924241678386517E-2,0.61547087809386247,1.0000000000000002,0.32289108368537833]
[null,null,0.52141940196765391,0.7507227739640806,0.6027768832193916,0.32289108368537833,0.99999999999999944]

{"sheet":"Cholesky","index":3,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["FONCTION CHOLESKY"]
["MATRICE DE CHOLESKY"]
[null,"Matrice Entrée"]
[null,null,1,2,3,4,5]
[null,1,0.99999999999999978,0.63098176605144674,0.56071300409883817,0.57228184509493552,0.52141940196765391]
[null,2,0.63098176605144674,1.0000000000000002,0.35055051125550535,5.2924241678386517E-2,0.7507227739640806]
[null,3,0.56071300409883817,0.35055051125550535,0.99999999999999978,0.61547087809386247,0.6027768832193916]
[null,4,0.57228184509493552,5.2924241678386517E-2,0.61547087809386247,1.0000000000000002,0.32289108368537833]
[null,5,0.52141940196765391,0.7507227739640806,0.6027768832193916,0.32289108368537833,0.99999999999999944]
[]
[null,"Matrice Sortie"]
[null,null,{"$f":"C4","v":1},{"$f":"D4","v":2},{"$f":"E4","v":3},{"$f":"F4","v":4},{"$f":"G4","v":5}]
[null,{"$f":"+B5","v":1},{"$f":"MCholesky(C5:G9)","v":0.99999999999999989},0,0,0,0,{"$f":"form(C13)","v":"=MCholesky(C5:G9)"}]
[null,{"$f":"+B6","v":2},0.63098176605144685,0.77579766106285564,0,0,0]
[null,{"$f":"+B7","v":3},0.56071300409883829,-4.1881672011493008E-3,0.82799962940206151,0,0]
[null,{"$f":"+B8","v":4},0.57228184509493563,-0.3972365258185897,0.35376985948949735,0.62413421541131242,0]
[null,{"$f":"+B9","v":5},0.52141940196765402,0.54359101608953331,0.37764134536741339,0.17116239525208352,0.5106085224505188]
[]
[null,null,{"$f":"MMULT(C13:G17,TRANSPOSE(C13:G17))-C5:G9","v":0},0,0,0,0]
[null,null,0,0,0,-2.0816681711721685E-17,1.1102230246251565E-16]
[null,null,0,0,0,0,0]
[null,null,0,-2.0816681711721685E-17,0,0,0]
[null,null,0,1.1102230246251565E-16,0,0,0]

{"sheet":"ValVecPropres","index":4,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["FONCTIONS VALP et VECP"]
["VALEURS PROPRES ET VECTEURS PROPRES"]
[null,"Matrice Entrée"]
[null,null,1,2,3,4,5]
[null,1,1.8372400000000024E-5,1.6581679999999952E-5,5.3366000000001295E-6,1.0833400000000118E-3,5.8226999999999095E-5]
[null,2,1.6581679999999952E-5,3.758872100000004E-5,4.7722199999999936E-6,1.4330300000000564E-4,1.1991199999999831E-4]
[null,3,5.3366000000001295E-6,4.7722199999999936E-6,4.9303999999999909E-6,6.0356000000000971E-4,3.4869999999999685E-5]
[null,4,1.0833400000000118E-3,1.4330300000000564E-4,6.0356000000000971E-4,0.19504899999999922,3.7151999999999997E-3]
[null,5,5.8226999999999095E-5,1.1991199999999831E-4,3.4869999999999685E-5,3.7151999999999997E-3,6.7874799999999335E-4]
[]
[null,"Valeurs Propres"]
[null,null,{"$f":"MvalP(C5:G9)","v":0.19512799126343597},6.3434671366345921E-4,2.0571479961342754E-5,3.7536142804997724E-6,1.9764496579804553E-6,{"$f":"form(C12)","v":"=MvalP(C5:G9)"}]
[null,null,{"$f":"vprpgm(C5:G9)","v":0.1951284487959053},null,null,null,null,{"$f":"form(C13)","v":"=vprpgm(C5:G9)"}]
[null,"Vecteurs Propres"]
[null,null,{"$f":"Mvecp(C5:G9)","v":5.5571907995008215E-3},6.4042113413756666E-2,0.60358411003938084,0.75086877360914217,-0.26028836367880243,{"$f":"form(C15)","v":"=Mvecp(C5:G9)"}]
[null,null,7.4668847411716395E-4,0.19396319005940604,0.77357810796435988,-0.57370341114206791,0.18659858059625761]
[null,null,3.0961838486059344E-3,3.7682355708561065E-2,1.9760860434992378E-3,0.32298288332413183,0.94564718890155219]
[null,null,0.99979696436945487,-1.930607789525747E-2,-2.5024108422175913E-4,-5.740013267484796E-3,-5.4315836925529243E-4]
[null,null,1.9105071838105472E-2,0.97800010431289508,-0.19302633356513393,5.2053724074049394E-2,-5.6409543115072583E-2]
[]
[null,null,{"$f":"MMULT(C5:G9,C15:G19)","v":1.0843634777742432E-3},4.0624904180079058E-5,1.2416618424660021E-5,2.8184717514006283E-6,-5.1444684736926094E-7,{"$f":"form(C21)","v":"=PRODUITMAT(C5:G9;C15:G19)"}]
[null,null,1.4569982205404224E-4,1.2303991218586514E-4,1.5913646546522265E-5,-2.1534613168342975E-6,3.6880270079911441E-7]
[null,null,6.0415213496077037E-4,2.3903678506823203E-5,4.0651014445732304E-8,1.2123531632024528E-6,1.8690240630746519E-6]
[null,null,0.19508837332869275,-1.224674706658789E-5,-5.1478294498235461E-9,-2.1545795770997259E-8,-1.0735251730262501E-9]
[null,null,3.7279342907131602E-3,6.2039115213340535E-4,-3.9708373529465883E-6,1.9538960203756257E-7,-1.1149062219660967E-7]
[]
[null,null,{"$f":"C21/C15","v":0.195127991263436},6.3434671366345888E-4,2.0571479961342751E-5,3.7536142804997745E-6,1.9764496579804536E-6,{"$f":"form(C27)","v":"=C21/C15"}]
[null,null,0.19512799126343588,6.343467136634591E-4,2.0571479961342748E-5,3.7536142804997707E-6,1.9764496579804693E-6]
[null,null,0.195127991263436,6.3434671366345921E-4,2.057147996134207E-5,3.7536142804997715E-6,1.9764496579804553E-6]
[null,null,0.19512799126343591,6.3434671366348826E-4,2.0571479962345563E-5,3.753614280483774E-6,1.9764496577639541E-6]
[null,null,0.19512799126343591,6.3434671366345932E-4,2.0571479961342615E-5,3.753614280500079E-6,1.9764496579802906E-6]
[]
[null,null,{"$f":"C27-C12","v":0},{"$f":"D27-D12","v":0},{"$f":"E27-E12","v":0},{"$f":"F27-F12","v":0},{"$f":"G27-G12","v":0},{"$f":"SUM(C33:G33)","v":0}]

{"sheet":"Halton","index":5,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["FONCTION HALTON"]
["NOMBRES DE HALTON"]
[]
[null,"p","k","Halton",null,"p","k ","Halton"]
[null,3,1,{"$f":"halton(B5,C5)","v":0.33333333333333331},null,5,1,{"$f":"halton(F5,G5)","v":0.2}]
[null,3,{"$f":"C5+1","v":2},{"$f":"halton(B6,C6)","v":0.66666666666666663},null,5,{"$f":"G5+1","v":2},{"$f":"halton(F6,G6)","v":0.4}]
[null,3,{"$f":"C6+1","v":3},0.1111111111111111,null,5,{"$f":"G6+1","v":3},0.60000000000000009]
[null,3,{"$f":"C7+1","v":4},0.44444444444444442,null,5,{"$f":"G7+1","v":4},0.8]
[null,3,5,0.77777777777777768,null,5,5,0.04]
[null,3,6,0.22222222222222221,null,5,6,0.24000000000000002]
[null,3,7,0.55555555555555558,null,5,7,0.44]
[null,3,8,0.88888888888888884,null,5,8,0.64000000000000012]
[null,3,9,3.7037037037037035E-2,null,5,9,0.84000000000000008]
[null,3,10,0.37037037037037035,null,5,10,0.08]
[null,3,11,0.70370370370370372,null,5,11,0.28000000000000003]
[null,3,12,0.14814814814814814,null,5,12,0.48000000000000004]
[null,3,13,0.48148148148148145,null,5,13,0.68]

{"sheet":"Calcul Matriciel","index":6,"n_rows":97,"n_cols":13,"rows_kept":97,"cut":false,"hidden":false,"merged":[]}
["MATRICES - Exemples"]
[]
[null,"PRINCIPE DE SAISIE",null,"SI L'ARGUMENT DE SORTIE EST UNE TABLE",null,null,null,"SELECTIONNER LA ZONE DE SORTIE EN PREMIER"]
[null,null,null,null,null,null,null,"SAISIR LA FORMULE"]
[null,null,null,null,null,null,null,"PUIS SAISIR LA SEQUENCE SUIVANTE : CTRL +  MAJ  et ENTER"]
[]
[]
["ADDITION DE DEUX MATRICES",null,null,"Somme des cellules en référence relative",null,null,null,null,null,null,null,null,"Fonction"]
["FONCTION ALGEBRIQUE: PLUS (+)"]
[null,null,"A",null,"+",null,"B",null,"=",null,"S"]
[]
[null,3,-2,6,null,4,0,4,null,{"$f":"B12:D13+F12:H13","v":7},-2,10,{"$f":"form(J12)","v":"=B12:D13+F12:H13"}]
[null,2,-7,-6,null,-6,1,0,null,-4,-6,-6]
[]
["MULTIPLICATION PAR UN NOMBRE",null,null,"Multiplication des cellules en référence absolue"]
["FONCTION ALGEBRIQUE: MULTIPLICATION (*)"]
[null,null,null,"a","x",null,"A",null,"=",null,"aA"]
[]
[null,null,null,5,null,3,-2,6,null,{"$f":"D19*F19:H20","v":15},-10,30,{"$f":"form(J19)","v":"=D19*F19:H20"}]
[null,null,null,null,null,2,-7,-6,null,10,-35,-30]
[]
["DETERMINANT D'UNE MATRICE",null,null,"Fonction DETERMAT avec un argument table en entrée et un argument cellule en sortie"]
["FONCTION: DETERMAT"]
[null,null,"A",null,null,null,null,null,null,"DET(A)"]
[]
[null,3,-2,null,null,null,null,null,null,{"$f":"MDETERM(B26:C27)","v":-17},null,null,{"$f":"form(J26)","v":"=DETERMAT(B26:C27)"}]
[null,2,-7]
[]
["TRANSPOSEE D'UNE MATRICE",null,null,"Fonction TRANSPOSE avec un argument table en entrée et en sortie"]
["FONCTION MATRICIELLE: TRANSPOSE"]
[null,null,"A",null,null,null,null,null,null,"TA"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(B34:D35)","v":3},2,null,{"$f":"form(J33)","v":"=TRANSPOSE(B34:D35)"}]
[null,3,-2,6,null,null,null,null,null,-2,-7]
[null,2,-7,-6,null,null,null,null,null,6,-6]
[]
["PRODUIT DE DEUX MATRICES",null,null,"Fonction PRODUITMAT avec deux arguments Table en entrée, et un argument Table en sortie"]
["FONCTION MATRICIELLE: PRODUITMAT"]
[null,null,"A",null,null,null,"B",null,null,null,"AB"]
[]
[null,null,null,null,null,1,2,3]
[null,1,-2,3,null,-1,-2,-3,null,{"$f":"MMULT(B42:D43,F41:H43)","v":15},21,21,{"$f":"form(J42)","v":"=PRODUITMAT(B42:D43;F41:H43)"}]
[null,4,5,-6,null,4,5,4,null,-25,-32,-27]
[]
[]
["INVERSE D'UNE MATRICE",null,null,"Fonction INVERSEMAT avec un argument table en entrée et en sortie"]
["FONCTION MATRICIELLE: INVERSEMAT"]
[null,null,"A",null,null,null,null,null,null,"A-1"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"+MINVERSE(B51:D53)","v":-2.0761245674740483E-2},-6.9204152249134954E-2,0.16955017301038061,{"$f":"form(J50)","v":"=+INVERSEMAT(B51:D53)"}]
[null,3,7,6,null,null,null,null,null,9.6885813148788927E-2,-1.038062283737024E-2,-0.1245674740484429]
[null,-8,-7,8,null,null,null,null,null,6.4013840830449822E-2,4.6712802768166091E-2,6.0553633217993084E-2]
[null,3,-2,4]
[]
["PRODUIT SCALAIRE",null,null,"Fonction PRODUITMAT avec un argument table en entrée et en sortie"]
["FONCTION MATRICIELLE: PRODUITMAT"]
[null,null,"A",null,null,"B",null,null,null,"AB"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"MMULT(B60:D60,F60:F62)","v":-4},null,null,{"$f":"form(J59)","v":"=PRODUITMAT(B60:D60;F60:F62)"}]
[null,3,7,6,null,1]
[null,null,null,null,null,-1]
[null,null,null,null,null,0]
[]
["PRODUIT EXTERNE",null,null,"Fonction PRODUITMAT avec 2 arguments Table en entrée et une Table en sortie"]
["FONCTION MATRICIELLE: PRODUITMAT"]
[null,null,"B",null,null,"A",null,null,null,"BA"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"MMULT(C69:C71,E69:G69)","v":3},7,6,{"$f":"form(J68)","v":"=PRODUITMAT(C69:C71;E69:G69)"}]
[null,null,1,null,3,7,6,null,null,-3,-7,-6]
[null,null,-1,null,null,null,null,null,null,0,0,0]
[null,null,0]
[]
["PRODUIT D'UNE MATRICE",null,null,"Fonction PRODUITMAT avec deux arguments Table en entrée, et un argument Table en sortie"]
["ET DE SA TRANSPOSEE"]
["FONCTION MATRICIELLE: PRODUITMAT"]
[null,null,"A",null,null,null,"ATA",null,null,null,"TAA"]
[]
[null,13,-8,-3,null,{"$f":"MMULT(B78:D80,TRANSPOSE(B78:D80))","v":242},-181,-64,null,{"$f":"MMULT(TRANSPOSE(B78:D80),B78:D80)","v":242},-181,-64,{"$f":"form(J78)","v":"=PRODUITMAT(TRANSPOSE(B78:D80);B78:D80)"}]
[null,-8,10,-1,null,-181,165,3,null,-181,165,3]
[null,-3,-1,11,null,-64,3,131,null,-64,3,131]
[]
["TRACE D'UNE MATRICE CARREE",null,null,"Fonctions SOMME, INVERSEMAT et PRODUITMAT"]
[]
[null,null,"A",null,null,null,null,null,null,null,"Trace(A)"]
[]
[null,13,-8,-3,null,null,null,null,null,null,{"$f":"SUM(B86:D88*MMULT(B86:D88,MINVERSE(B86:D88)))","v":34},null,{"$f":"form(K86)","v":"=SOMME(B86:D88*PRODUITMAT(B86:D88;INVERSEMAT(B86:D88)))"}]
[null,-8,10,-1]
[null,-3,-1,11]
[]
["TRACE DU PRODUIT",null,null,"Fonctions SOMME et TRANSPOSE"]
["DE 2 MATRICES"]
["PRODUIT SIMPLE"]
[null,null,"A",null,null,null,"B",null,null,null,"Trace(AB)"]
[]
[null,13,-8,-3,null,34,-5,-24,null,null,{"$f":"SUM((B95:D97*TRANSPOSE(F95:H97)))","v":873},null,{"$f":"form(K95)","v":"=SOMME((B95:D97*TRANSPOSE(F95:H97)))"}]
[null,-8,10,-1,null,6,3,18]
[null,-3,-1,11,null,15,-37,33,null,null,{"$f":"SUM((TRANSPOSE(B95:D97)*(F95:H97)))","v":873},null,{"$f":"form(K97)","v":"=SOMME((TRANSPOSE(B95:D97)*(F95:H97)))"}]

{"sheet":"Exercice1","index":7,"n_rows":93,"n_cols":17,"rows_kept":93,"cut":false,"hidden":false,"merged":[]}
["MATRICES Exercices - Application avec Autocorrection"]
[]
[]
["ADDITION DE DEUX MATRICES"]
[null,"matrice A",null,null,null,"matrice B",null,null,null,null,null,"A+B"]
[null,15,-85,0,null,8,78,0,"OK",{"$f":"AND(L6:N9=ExoCorrec1!L6:N9)","v":false},null,null,null,null,{"$f":"form(L6)","v":""}]
[null,0,55,6,null,88,0,6]
[null,-7,0,-33,null,4,1,5]
[null,2,-4,8,null,-7,-22,-77]
[]
["MULTIPLICATION PAR UN NOMBRE"]
[null,"matrice A",null,null,null,"scalaire b",null,null,null,null,null,"A.b"]
[null,15,-85,0,null,8,null,null,"OK",{"$f":"AND(L13:N16=ExoCorrec1!L13:N16)","v":false},null,null,null,null,{"$f":"form(L13)","v":""}]
[null,0,55,6]
[null,-7,0,-33]
[null,2,-4,8]
[]
["DETERMINANT D'UNE MATRICE"]
[null,"matrice A",null,null,null,null,null,null,null,null,null,"determinant (A)"]
[null,15,-85,0,5,null,null,null,"OK",{"$f":"AND(L20=ExoCorrec1!L20)","v":false},null,null,null,null,{"$f":"form(L20)","v":""}]
[null,0,55,6,1]
[null,-7,0,-33,8]
[null,2,-4,8,7]
[]
["TRANSPOSEE D'UNE MATRICE"]
[null,"matrice A",null,null,null,null,null,null,null,null,null,"AT"]
[null,15,-85,0,null,null,null,null,"OK",{"$f":"AND(L27:P29=ExoCorrec1!L27:P29)","v":false},null,null,null,null,null,null,{"$f":"form(N27)","v":""}]
[null,0,55,6]
[null,-7,0,-33]
[null,2,-4,8]
[]
["PRODUIT DE DEUX MATRICES"]
[null,"matrice A",null,null,null,"matrice B",null,null,null,null,null,"A.B"]
[null,15,-85,0,null,8,78,0,"OK",{"$f":"AND(L34:N37=ExoCorrec1!L34:N37)","v":false},null,null,null,null,{"$f":"form(L34)","v":""}]
[null,0,55,6,null,88,0,6]
[null,-7,0,-33,null,4,1,5]
[null,2,-4,8]
[]
["INVERSE D'UNE MATRICE"]
[null,"matrice A",null,null,null,null,null,null,null,null,null,"A-1"]
[null,15,-85,0,null,null,null,null,"OK",{"$f":"AND(L41:N43=ExoCorrec1!L41:N43)","v":false},null,null,null,null,{"$f":"form(L41)","v":""}]
[null,5,55,6]
[null,-7,0,-33]
[]
["PRODUIT SCALAIRE"]
[null,"vecteur A",null,null,null,null,"vecteur B",null,null,null,null,"A.B"]
[null,15,8,-7,14,null,1,null,"OK",{"$f":"AND(L47=ExoCorrec1!L47)","v":false},null,null,null,null,{"$f":"form(L47)","v":""}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,5]
[null,null,null,null,null,null,3]
[]
["PRODUIT D'UNE MATRICE ET DE SA TRANSPOSEE"]
[]
[null,"matrice A",null,null,null,null,null,null,null,null,null,"A.AT"]
[null,15,-85,0,null,null,null,null,"OK",{"$f":"AND(L55:N57=ExoCorrec1!L55:N57)","v":false},null,null,null,null,{"$f":"form(L55)","v":""}]
[null,5,55,6]
[null,-7,0,-33]
[]
[null,null,null,null,null,null,null,null,null,null,null,"AT.A"]
[null,null,null,null,null,null,null,null,"OK",{"$f":"AND(L60:N62=ExoCorrec1!L60:N62)","v":false},null,null,null,null,{"$f":"form(L60)","v":""}]
[]
[]
[]
["RESOLUTION D'UN SYSTEME D'EQUATIONS"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"A-1,x"]
[null,13,"a               +",-8,"b               +",-3,"c               =",20,"OK",{"$f":"AND(M73:M75=ExoCorrec1!M73:M75)","v":false},null,"a=",null,null,{"$f":"form(M73)","v":""}]
[null,-8,"a               +",10,"b               +",-1,"c               =",-5,null,null,null,"b="]
[null,-3,"a               +",-1,"b               +",11,"c               =",0,null,null,null,"c="]
[null,null,null,null,null,null,null,null,null,null,null,"vérification","A,x"]
[null,"premier membre: A",null,13,-8,-3,"sec membre: B",20,"OK",{"$f":"AND(M77:M79=ExoCorrec1!M77:M79)","v":false},null,null,null,null,{"$f":"form(M77)","v":""}]
[null,null,null,-8,10,-1,null,-5]
[null,null,null,-3,-1,11,null,0]
[]
["CALCUL DE LA TRACE D'UNE MATRICE CARREE"]
[]
[null,"matrice A",null,null,null,null,null,null,null,null,null,"trace (A)"]
[null,15,-85,0,null,null,null,null,"OK",{"$f":"AND(L84=ExoCorrec1!L84)","v":false},null,null,null,null,{"$f":"form(L84)","v":""}]
[null,5,55,6]
[null,-7,0,-33]
[]
["CALCUL DE LA TRACE DU PRODUIT DE DEUX MATRICES CARREES"]
[]
[null,"matrice A",null,null,null,"matrice B",null,null,null,null,null,"trace (AB)"]
[null,15,-85,0,null,12,2,23,"OK",{"$f":"AND(L91=ExoCorrec1!L91)","v":false},null,null,null,null,{"$f":"form(L91)","v":""}]
[null,5,55,6,null,-34,0,5,null,null,null,"trace (BA)"]
[null,-7,0,-33,null,38,-11,3,"OK",{"$f":"AND(L93=ExoCorrec1!L93)","v":false},null,null,null,null,{"$f":"form(L93)","v":""}]

{"sheet":"ExoCorrec1","index":8,"n_rows":93,"n_cols":17,"rows_kept":93,"cut":false,"hidden":true,"merged":[]}
["MATRICES Exercices - Application avec Autocorrection"]
[]
[]
["ADDITION DE DEUX MATRICES"]
[null,"matrice A",null,null,null,"matrice B",null,null,null,null,null,"A+B"]
[null,15,-85,0,null,8,78,0,"OK",null,null,{"$f":"B6:D9+F6:H9","v":23},-7,0,{"$f":"form(L6)","v":"=B6:D9+F6:H9"}]
[null,0,55,6,null,88,0,6,null,null,null,88,55,12]
[null,-7,0,-33,null,4,1,5,null,null,null,-3,1,-28]
[null,2,-4,8,null,-7,-22,-77,null,null,null,-5,-26,-69]
[]
["MULTIPLICATION PAR UN NOMBRE"]
[null,"matrice A",null,null,null,"scalaire b",null,null,null,null,null,"A.b"]
[null,15,-85,0,null,8,null,null,"OK",null,null,{"$f":"B13:D16*F13","v":120},-680,0,{"$f":"form(L13)","v":"=B13:D16*F13"}]
[null,0,55,6,null,null,null,null,null,null,null,0,440,48]
[null,-7,0,-33,null,null,null,null,null,null,null,-56,0,-264]
[null,2,-4,8,null,null,null,null,null,null,null,16,-32,64]
[]
["DETERMINANT D'UNE MATRICE"]
[null,"matrice A",null,null,null,null,null,null,null,null,null,"determinant (A)"]
[null,15,-85,0,5,null,null,null,"OK",null,null,{"$f":"MDETERM(B20:E23)","v":-212325},null,null,{"$f":"form(L20)","v":"=DETERMAT(B20:E23)"}]
[null,0,55,6,1]
[null,-7,0,-33,8]
[null,2,-4,8,7]
[]
["TRANSPOSEE D'UNE MATRICE"]
[null,"matrice A",null,null,null,null,null,null,null,null,null,"AT"]
[null,15,-85,0,null,null,null,null,"OK",null,null,{"$f":"TRANSPOSE(B27:D30)","v":15},0,-7,2,null,{"$f":"form(N27)","v":"=TRANSPOSE(B27:D30)"}]
[null,0,55,6,null,null,null,null,null,null,null,-85,55,0,-4]
[null,-7,0,-33,null,null,null,null,null,null,null,0,6,-33,8]
[null,2,-4,8]
[]
["PRODUIT DE DEUX MATRICES"]
[null,"matrice A",null,null,null,"matrice B",null,null,null,null,null,"A.B"]
[null,15,-85,0,null,8,78,0,"OK",null,null,{"$f":"MMULT(B34:D37,F34:H36)","v":-7360},1170,-510,{"$f":"form(L34)","v":"=PRODUITMAT(B34:D37;F34:H36)"}]
[null,0,55,6,null,88,0,6,null,null,null,4864,6,360]
[null,-7,0,-33,null,4,1,5,null,null,null,-188,-579,-165]
[null,2,-4,8,null,null,null,null,null,null,null,-304,164,16]
[]
["INVERSE D'UNE MATRICE"]
[null,"matrice A",null,null,null,null,null,null,null,null,null,"A-1"]
[null,15,-85,0,null,null,null,null,"OK",null,null,{"$f":"MINVERSE(B41:D43)","v":4.8168789808917208E-2},7.444267515923568E-2,1.353503184713376E-2,{"$f":"form(L41)","v":"=INVERSEMAT(B41:D43)"}]
[null,5,55,6,null,null,null,null,null,null,null,-3.2643312101910825E-3,1.3136942675159238E-2,2.3885350318471341E-3]
[null,-7,0,-33,null,null,null,null,null,null,null,-1.0217622080679408E-2,-1.5790870488322718E-2,-3.3174097664543524E-2]
[]
["PRODUIT SCALAIRE"]
[null,"vecteur A",null,null,null,null,"vecteur B",null,null,null,null,"A.B"]
[null,15,8,-7,14,null,1,null,"OK",null,null,{"$f":"MMULT(B47:E47,G47:G50)","v":22},null,null,{"$f":"form(L47)","v":"=PRODUITMAT(B47:E47;G47:G50)"}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,5]
[null,null,null,null,null,null,3]
[]
["PRODUIT D'UNE MATRICE ET DE SA TRANSPOSEE"]
[]
[null,"matrice A",null,null,null,null,null,null,null,null,null,"A.AT"]
[null,15,-85,0,null,null,null,null,"OK",null,null,{"$f":"MMULT(B55:D57,TRANSPOSE(B55:D57))","v":7450},-4600,-105,{"$f":"form(L55)","v":"=PRODUITMAT(B55:D57;TRANSPOSE(B55:D57))"}]
[null,5,55,6,null,null,null,null,null,null,null,-4600,3086,-233]
[null,-7,0,-33,null,null,null,null,null,null,null,-105,-233,1138]
[]
[null,null,null,null,null,null,null,null,null,null,null,"AT.A"]
[null,null,null,null,null,null,null,null,"OK",null,null,{"$f":"MMULT(TRANSPOSE(B55:D57),B55:D57)","v":299},-1000,261,{"$f":"form(L60)","v":"=PRODUITMAT(TRANSPOSE(B55:D57);B55:D57)"}]
[null,null,null,null,null,null,null,null,null,null,null,-1000,10250,330]
[null,null,null,null,null,null,null,null,null,null,null,261,330,1125]
[]
["RESOLUTION D'UN SYSTEME D'EQUATIONS"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"A-1,x"]
[null,13,"a               +",-8,"b               +",-3,"c               =",20,"OK",null,null,"a=",{"$f":"MMULT(MINVERSE(D77:F79),H77:H79)","v":3},null,{"$f":"form(M73)","v":"=PRODUITMAT(INVERSEMAT(D77:F79);H77:H79)"}]
[null,-8,"a               +",10,"b               +",-1,"c               =",-5,null,null,null,"b=",2.0000000000000004]
[null,-3,"a               +",-1,"b               +",11,"c               =",0,null,null,null,"c=",0.99999999999999989]
[null,null,null,null,null,null,null,null,null,null,null,"vérification","A,x"]
[null,"premier membre: A",null,13,-8,-3,"sec membre: B",20,"OK",null,null,null,{"$f":"MMULT(D77:F79,M73:M75)","v":19.999999999999996},null,{"$f":"form(M77)","v":"=PRODUITMAT(D77:F79;M73:M75)"}]
[null,null,null,-8,10,-1,null,-5,null,null,null,null,-4.9999999999999964]
[null,null,null,-3,-1,11,null,0,null,null,null,null,-1.7763568394002505E-15]
[]
["CALCUL DE LA TRACE D'UNE MATRICE CARREE"]
[]
[null,"matrice A",null,null,null,null,null,null,null,null,null,"trace (A)"]
[null,15,-85,0,null,null,null,null,"OK",null,null,{"$f":"SUM(B84:D86*MMULT(B84:D86,MINVERSE(B84:D86)))","v":37},null,null,{"$f":"form(L84)","v":"=SOMME(B84:D86*PRODUITMAT(B84:D86;INVERSEMAT(B84:D86)))"}]
[null,5,55,6]
[null,-7,0,-33]
[]
["CALCUL DE LA TRACE DU PRODUIT DE DEUX MATRICES CARREES"]
[]
[null,"matrice A",null,null,null,"matrice B",null,null,null,null,null,"trace (AB)"]
[null,15,-85,0,null,12,2,23,"OK",null,null,{"$f":"SUM((B91:D93*TRANSPOSE(F91:H93)))","v":2754},null,null,{"$f":"form(L91)","v":"=SOMME((B91:D93*TRANSPOSE(F91:H93)))"}]
[null,5,55,6,null,-34,0,5,null,null,null,"trace (BA)"]
[null,-7,0,-33,null,38,-11,3,"OK",null,null,{"$f":"SUM((TRANSPOSE(B91:D93)*(F91:H93)))","v":2754},null,null,{"$f":"form(L93)","v":"=SOMME((TRANSPOSE(B91:D93)*(F91:H93)))"}]

{"sheet":"Exercice2","index":9,"n_rows":88,"n_cols":14,"rows_kept":88,"cut":false,"hidden":false,"merged":[]}
["MATRICES Exercices 2"]
[]
[]
["CALCUL DU PRODUIT MATRICIEL D'UNE MATRICE PAR SA TRANSPOSEE"]
[]
[]
[null,11,3,5,8,null,null,"OK",{"$f":"AND(J7:M10=ExoCorrec2!J7:M10)","v":false},null,null,null,null,{"$f":"form(K7)","v":""}]
[null,1,12,14,-6]
[null,-22,3,5,4]
[null,11,6,4,12]
[null,null,null,null,null,null,null,null,null,"matrice symétrique"]
["MATRICE DE CHOLESKY DE LA MATRICE SUIVANTE"]
[]
[]
[null,{"$f":"J7:M10","v":0},0,0,0,null,null,"OK",{"$f":"AND(J15:M18=ExoCorrec2!J15:M18)","v":{"$error":"#NAME?"}},null,null,null,null,{"$f":"form(M15)","v":""}]
[null,0,0,0,0]
[null,0,0,0,0]
[null,0,0,0,0]
[]
["VERIFICATION PAR LE CALCUL DU CARRE DE LA MATRICE DE CHOLESKY: A . TA"]
[null,null,null,null,null,null,null,null,null,"A.AT"]
[null,{"$f":"J15:M18","v":0},0,0,0,null,null,"OK",{"$f":"AND(J22:M25=ExoCorrec2!J22:M25)","v":{"$error":"#NAME?"}},null,null,null,null,{"$f":"form(M22)","v":""}]
[null,0,0,0,0]
[null,0,0,0,0]
[null,0,0,0,0]
[]
["DETERMINANT DE LA MATRICE INITIALE"]
[]
[null,{"$f":"+J7:M10","v":0},0,0,0,null,null,"OK",{"$f":"AND(J29=ExoCorrec2!J29)","v":false},null,{"$f":"form(J29)","v":""}]
[null,0,0,0,0]
[null,0,0,0,0]
[null,0,0,0,0]
[]
["DETERMINANT DE LA MATRICE DE CHOLESKY ET SON CARRE"]
[]
[null,{"$f":"+J15:M18","v":0},0,0,0,null,null,"OK",{"$f":"AND(J36=ExoCorrec2!J36)","v":{"$error":"#NAME?"}},null,{"$f":"form(J36)","v":""}]
[null,0,0,0,0,null,null,null,null,"CARRE"]
[null,0,0,0,0,null,null,"OK",{"$f":"AND(J38=ExoCorrec2!J38)","v":{"$error":"#NAME?"}},null,{"$f":"form(J38)","v":""}]
[null,0,0,0,0]
[]
["VECTEURS PROPRES et VALEURS PROPRES D'UNE MATRICE"]
[null,null,null,null,null,null,null,null,null,"Valeurs Propres"]
[null,{"$f":"B15:E18","v":0},0,0,0,null,null,"OK",{"$f":"AND(J43:M43=ExoCorrec2!J43:M43)","v":{"$error":"#NAME?"}},null,null,null,null,{"$f":"form(M43)","v":""}]
[null,0,0,0,0]
[null,0,0,0,0,null,null,null,null,"Vecteurs Propres, matrice de passage P"]
[null,0,0,0,0,null,null,"OK",{"$f":"AND(J46:M49=ExoCorrec2!J46:M49)","v":{"$error":"#NAME?"}},null,null,null,null,{"$f":"form(M46)","v":""}]
[]
[]
[]
[]
["VERIFICATION"]
[]
[null,"PRODUIT DES VALEURS PROPRES",null,null,null,null,null,"OK",{"$f":"AND(J53=ExoCorrec2!J53)","v":{"$error":"#NAME?"}},null,{"$f":"form(J53)","v":""}]
[]
[null,"DETERMINANT DE LA MATRICE DE PASSAGE",null,null,null,null,null,"OK",{"$f":"AND(J55=ExoCorrec2!J55)","v":{"$error":"#NAME?"}},null,{"$f":"form(J55)","v":""}]
[null,"(matrice de passage = matrice des vecteurs propres)"]
[null,"NORME DES VECTEURS PROPRES",null,null,null,null,null,"OK",{"$f":"AND(J57:M57=ExoCorrec2!J57:M57)","v":{"$error":"#NAME?"}},null,null,null,null,{"$f":"form(M57)","v":""}]
[null,"Utilisez la fonction SOMME.CARRES"]
[]
[null,"Produit de la matrice par le premier vecteur propre",null,null,null,null,null,"OK",{"$f":"AND(J60:J63=ExoCorrec2!J60:J63)","v":{"$error":"#NAME?"}},null,{"$f":"form(J60)","v":""}]
[]
[]
[]
[]
[null,"Division de ce produit par le vecteur propre lui même",null,null,null,null,null,"OK",{"$f":"AND(J65:J68=ExoCorrec2!J65:J68)","v":{"$error":"#NAME?"}},null,{"$f":"form(J65)","v":""}]
[]
[]
[]
[]
["COMPLEMENT: SECONDE MANIERE D'OBTENIR UNE MATRICE RACINE CARRE"]
[]
[null,"Obtenir la matrice diagonale des valeurs propres",null,null,null,null,null,null,null,"Matrice Diagonale: D"]
[null,null,null,null,null,null,null,"OK",{"$f":"AND(J73:M76=ExoCorrec2!J73:M76)","v":{"$error":"#NAME?"}},null,null,null,null,{"$f":"form(M73)","v":""}]
[]
[]
[]
[]
[null,"Prendre les racines carrés des éléments diagonaux",null,null,null,null,null,"OK",{"$f":"AND(J78:M81=ExoCorrec2!J78:M81)","v":{"$error":"#NAME?"}},null,null,null,null,{"$f":"form(M78)","v":""}]
[]
[]
[]
[]
[null,"Calculer  P D P-1 , on obtient une matrice racine carrée",null,null,null,null,null,"OK",{"$f":"AND(J83:M86=ExoCorrec2!J83:M86)","v":{"$error":"#NAME?"}},null,null,null,null,{"$f":"form(M83)","v":""}]
[]
[]
[]
[]
[null,"Vérification",null,null,null,null,null,"OK",{"$f":"AND(J88:M91=ExoCorrec2!J88:M91)","v":{"$error":"#NAME?"}},null,null,null,null,{"$f":"form(M88)","v":""}]

{"sheet":"ExoCorrec2","index":10,"n_rows":91,"n_cols":13,"rows_kept":91,"cut":false,"hidden":true,"merged":[]}
["MATRICES Exercices"]
[]
[]
["CALCUL DU PRODUIT MATRICIEL D'UNE MATRICE PAR SA TRANSPOSEE",null,null,null,null,null,"On obtient une matrice symétrique"]
[]
[]
[null,11,3,5,8,null,null,null,null,{"$f":"MMULT(B7:E10,TRANSPOSE(B7:E10))","v":219},69,-176,255]
[null,1,12,14,-6,null,null,null,null,69,377,60,67]
[null,-22,3,5,4,null,null,null,null,-176,60,534,-156]
[null,11,6,4,12,null,null,null,null,255,67,-156,317]
[]
["MATRICE DE CHOLESKY DE LA MATRICE SUIVANTE"]
[]
[]
[null,{"$f":"J7:M10","v":219},69,-176,255,null,null,null,null,{"$f":"cholesky(B15:E18)","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,69,377,60,67,null,null,null,null,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,-176,60,534,-156,null,null,null,null,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,255,67,-156,317,null,null,null,null,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[]
["VERIFICATION PAR LE CALCUL DU CARRE DE LA MATRICE DE CHOLESKY: A . TA"]
[]
[null,{"$f":"J15:M18","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,null,null,null,{"$f":"MMULT(B22:E25,TRANSPOSE(B22:E25))","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,null,null,null,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,null,null,null,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,null,null,null,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[]
["DETERMINANT DE LA MATRICE INITIALE"]
[]
[null,{"$f":"+J7:M10","v":219},69,-176,255,null,null,null,null,{"$f":"MDETERM(B29:E32)","v":320123664.00000012}]
[null,69,377,60,67]
[null,-176,60,534,-156]
[null,255,67,-156,317]
[]
["DETERMINANT DE LA MATRICE DE CHOLESKY ET SON CARRE"]
[]
[null,{"$f":"+J15:M18","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,null,null,null,{"$f":"MDETERM(B36:E39)","v":{"$error":"#NAME?"}}]
[null,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},null,null,"CARRE",null,{"$f":"J36*J36","v":{"$error":"#NAME?"}}]
[null,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[]
["VECTEURS PROPRES et VALEURS PROPRES D'UNE MATRICE"]
[null,null,null,null,null,null,null,null,null,"Valeurs Propres"]
[null,{"$f":"B15:E18","v":219},69,-176,255,null,null,null,null,{"$f":"Valp(B43:E46)","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,69,377,60,67]
[null,-176,60,534,-156,null,null,null,null,"Vecteurs Propres, matrice de passage P"]
[null,255,67,-156,317,null,null,null,null,{"$f":"Vecp(B43:E46)","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[]
["VERIFICATION"]
[]
[null,"PRODUIT DES VALEURS PROPRES",null,null,null,null,null,null,null,{"$f":"PRODUCT(J43:M43)","v":{"$error":"#NAME?"}}]
[]
[null,"DETERMINANT DE LA MATRICE DE PASSAGE",null,null,null,null,null,null,null,{"$f":"MDETERM(J46:M49)","v":{"$error":"#NAME?"}}]
[]
[null,"NORME DES VECTEURS PROPRES",null,null,null,null,null,null,null,{"$f":"SUMSQ(J46:J49)","v":{"$error":"#NAME?"}},{"$f":"SUMSQ(K46:K49)","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,"Utilisez la fonction SOMME.CARRES"]
[]
[null,"Produit de la matrice par le premier vecteur propre",null,null,null,null,null,null,null,{"$f":"MMULT(B43:E46,J46:J49)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,{"$error":"#NAME?"}]
[]
[null,"Division de ce produit par le vecteur propre lui même",null,null,null,null,null,null,null,{"$f":"J60:J63/J46:J49","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,{"$error":"#NAME?"}]
[]
["COMPLEMENT: SECONDE MANIERE D'OBTENIR UNE MATRICE RACINE CARRE"]
[]
[null,"Obtenir la matrice diagonale des valeurs propres",null,null,null,null,null,null,null,"Matrice Diagonale: D"]
[null,null,null,null,null,null,null,null,null,{"$f":"J43","v":{"$error":"#NAME?"}},0,0,0]
[null,null,null,null,null,null,null,null,null,0,{"$f":"K43","v":{"$error":"#NAME?"}},0,0]
[null,null,null,null,null,null,null,null,null,0,0,{"$f":"L43","v":{"$error":"#NAME?"}},0]
[null,null,null,null,null,null,null,null,null,0,0,0,{"$f":"M43","v":{"$error":"#NAME?"}}]
[]
[null,"Prendre les racines carrés des éléments diagonaux",null,null,null,null,null,null,null,{"$f":"SQRT(J73)","v":{"$error":"#NAME?"}},0,0,0]
[null,null,null,null,null,null,null,null,null,0,{"$f":"SQRT(K74)","v":{"$error":"#NAME?"}},0,0]
[null,null,null,null,null,null,null,null,null,0,0,{"$f":"SQRT(L75)","v":{"$error":"#NAME?"}},0]
[null,null,null,null,null,null,null,null,null,0,0,0,{"$f":"SQRT(M76)","v":{"$error":"#NAME?"}}]
[]
[null,"Calculer  P D P-1 , on obtient une matrice racine carrée",null,null,null,null,null,null,null,{"$f":"MMULT((J46:M49),MMULT(J78:M81,MINVERSE(J46:M49)))","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[]
[null,"Vérification",null,null,null,null,null,null,null,{"$f":"MMULT(J83:M86,TRANSPOSE(J83:M86))","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]
[null,null,null,null,null,null,null,null,null,{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"}]

{"sheet":"Rates","index":11,"n_rows":776,"n_cols":15,"rows_kept":776,"cut":false,"hidden":false,"merged":[]}
[null,null,"ccy pour 1 eur","USD","GBP","CHF"]
[null,null,null,1,{"$f":"D2+1","v":2},{"$f":"E2+1","v":3},null,null,null,null,null,null,null,"CENTILE"]
[null,null,"MIN",null,null,null,null,null,{"$f":"form(J3)","v":""},null,null,null,0.05]
[null,null,"MAX",null,null,null,null,null,"",null,null,null,"histo",{"$f":"PERCENTILE(N9:N775,M3)","v":-41175.624979044573},{"$f":"form(N4)","v":"=CENTILE(N9:N775;M3)"}]
[null,null,"MOY",null,null,null,null,null,"",null,null,null,"param"]
[null,null,"STD",null,null,null,null,null,"=ECARTYPEP(J9:J775)",{"$f":"STDEVP(J9:J775)","v":5.8921872678338394E-3},null,null,null,"PL HISTO"]
[null,null,null,null,null,null,null,null,null,"RETURN",null,null,null,"USD"]
[null,null,"DATES",{"$f":"D1","v":"USD"},{"$f":"E1","v":"GBP"},{"$f":"F1","v":"CHF"},null,null,{"$f":"form(J8)","v":""},null,null,null,null,{"$f":"CalculVAR!F9","v":4608681.0792693142}]
[null,1,"2015-01-02",1.2042999999999999,null,null,null,null,null,{"$f":"-LN(D10/D9)","v":1.0685467727637276E-2},null,null,null,{"$f":"$N$8*J9","v":49245.912939504786}]
[null,{"$f":"B9+1","v":2},"2015-01-05",1.1915,null,null,null,null,null,{"$f":"-LN(D11/D10)","v":8.393134420973494E-5},null,null,null,{"$f":"$N$8*J10","v":386.81279801704551}]
[null,{"$f":"B10+1","v":3},"2015-01-06",1.1914,null,null,null,null,null,6.990973934969902E-3,null,null,null,32219.169299760732]
[null,4,"2015-01-07",1.1831,null,null,null,null,null,5.3392219723893217E-3,null,null,null,24606.771282169655]
[null,5,"2015-01-08",1.1768000000000001,null,null,null,null,null,-3.8166366672463419E-3,null,null,null,-17589.661194783708]
[null,6,"2015-01-09",1.1813,null,null,null,null,null,7.621628856900605E-4,null,null,null,3512.5656706010832]
[null,7,"2015-01-12",1.1803999999999999,null,null,null,null,null,1.8655139811973192E-3,null,null,null,8597.5589882564564]
[null,8,"2015-01-13",1.1781999999999999,null,null,null,null,null,5.9430319701407586E-4,null,null,null,2738.9538994280351]
[null,9,"2015-01-14",1.1775,null,null,null,null,null,5.7062710728420065E-3,null,null,null,26298.383526588765]
[null,10,"2015-01-15",1.1708000000000001,null,null,null,null,null,1.0302288922535473E-2,null,null,null,47479.964030455085]
[null,11,"2015-01-16",1.1588000000000001,null,null,null,null,null,-1.4659598192964152E-3,null,null,null,-6756.1412821604517]
[null,12,"2015-01-19",1.1605000000000001,null,null,null,null,null,2.2429270962644817E-3,null,null,null,10336.93567073458]
[null,13,"2015-01-20",1.1578999999999999,null,null,null,null,null,-1.208355058128539E-3,null,null,null,-5568.9230934363704]
[null,14,"2015-01-21",1.1593,null,null,null,null,null,-2.1541518820764184E-3,null,null,null,-9927.7990207979728]
[null,15,"2015-01-22",1.1617999999999999,null,null,null,null,null,3.6820428643639234E-2,null,null,null,169693.61282052603]
[null,16,"2015-01-23",1.1197999999999999,null,null,null,null,null,-4.099462117583972E-3,null,null,null,-18893.113496490569]
[null,17,"2015-01-26",1.1244000000000001,null,null,null,null,null,-5.4989052088135178E-3,null,null,null,-25342.700392554336]
[null,18,"2015-01-27",1.1306,null,null,null,null,null,-3.3554115366725506E-3,null,null,null,-15464.021662224759]
[null,19,"2015-01-28",1.1344000000000001,null,null,null,null,null,2.5596907042710806E-3,null,null,null,11796.798117555674]
[null,20,"2015-01-29",1.1315,null,null,null,null,null,8.8417335556739338E-4,null,null,null,4074.8730145975055]
[null,21,"2015-01-30",1.1305000000000001,null,null,null,null,null,-4.4218439809576526E-4,null,null,null,-2037.8868690520435]
[null,22,"2015-02-02",1.131,null,null,null,null,null,-5.8185829328559705E-3,null,null,null,-26815.993070812667]
[null,23,"2015-02-03",1.1375999999999999,null,null,null,null,null,-6.1344509260255493E-3,null,null,null,-28271.72791448007]
[null,24,"2015-02-04",1.1446000000000001,null,null,null,null,null,3.1501601129262668E-3,null,null,null,14518.083309112171]
[null,25,"2015-02-05",1.141,null,null,null,null,null,-3.2375230623550078E-3,null,null,null,-14920.711281173573]
[null,26,"2015-02-06",1.1447000000000001,null,null,null,null,null,1.5139801547597302E-2,null,null,null,69774.516936303975]
[null,27,"2015-02-09",1.1274999999999999,null,null,null,null,null,-1.9493183560496789E-3,null,null,null,-8983.78662499852]
[null,28,"2015-02-10",1.1296999999999999,null,null,null,null,null,-1.5036931761723171E-3,null,null,null,-6930.0422900517378]
[null,29,"2015-02-11",1.1314,null,null,null,null,null,-1.2366400303999987E-3,null,null,null,-5699.279509971504]
[null,30,"2015-02-12",1.1328,null,null,null,null,null,-4.6677613483887105E-3,null,null,null,-21512.223408863672]
[null,31,"2015-02-13",1.1380999999999999,null,null,null,null,null,-2.369565372187566E-3,null,null,null,-10920.571096892587]
[null,32,"2015-02-16",1.1408,null,null,null,null,null,-6.1341630981864295E-4,null,null,null,-2827.0401407763834]
[null,33,"2015-02-17",1.1415,null,null,null,null,null,3.7740861930054986E-3,null,null,null,17393.559629235999]
[null,34,"2015-02-18",1.1372,null,null,null,null,null,-1.3181600397146396E-3,null,null,null,-6074.9792344817479]
[null,35,"2015-02-19",1.1387,null,null,null,null,null,7.8466349253977549E-3,null,null,null,36162.637916614418]
[null,36,"2015-02-20",1.1297999999999999,null,null,null,null,null,0,null,null,null,0]
[null,37,"2015-02-23",1.1297999999999999,null,null,null,null,null,-2.6518180482936107E-3,null,null,null,-12221.383664835645]
[null,38,"2015-02-24",1.1328,null,null,null,null,null,-1.587721953011576E-3,null,null,null,-7317.3041239849736]
[null,39,"2015-02-25",1.1346000000000001,null,null,null,null,null,2.5592389205710011E-3,null,null,null,11794.715990565195]
[null,40,"2015-02-26",1.1316999999999999,null,null,null,null,null,6.8271755182593092E-3,null,null,null,31464.274635852351]
[null,41,"2015-02-27",1.1240000000000001,null,null,null,null,null,1.157252988902707E-3,null,null,null,5333.4099538837672]
[null,42,"2015-03-02",1.1227,null,null,null,null,null,5.2690454566257415E-3,null,null,null,24283.350101761]
[null,43,"2015-03-03",1.1168,null,null,null,null,null,3.9476096482982106E-3,null,null,null,18193.273894452956]
[null,44,"2015-03-04",1.1124000000000001,null,null,null,null,null,4.9565279682315493E-3,null,null,null,22843.056666057917]
[null,45,"2015-03-05",1.1069,null,null,null,null,null,9.6224417110839216E-3,null,null,null,44346.765050244314]
[null,46,"2015-03-06",1.0963000000000001,null,null,null,null,null,9.4396521866135872E-3,null,null,null,43504.346427329248]
[null,47,"2015-03-09",1.0860000000000001,null,null,null,null,null,1.1297462505411568E-2,null,null,null,52066.401692444793]
[null,48,"2015-03-10",1.0738000000000001,null,null,null,null,null,1.5012479356589557E-2,null,null,null,69187.729563635454]
[null,49,"2015-03-11",1.0578000000000001,null,null,null,null,null,-3.3032921358970573E-3,null,null,null,-15223.819966007888]
[null,50,"2015-03-12",1.0612999999999999,null,null,null,null,null,3.8706680376426926E-3,null,null,null,17838.674549216365]
[null,51,"2015-03-13",1.0571999999999999,null,null,null,null,null,1.4198497344847856E-3,null,null,null,6543.6346067255909]
[null,52,"2015-03-16",1.0557000000000001,null,null,null,null,null,-7.3613016446424547E-3,null,null,null,-33925.891608457765]
[null,53,"2015-03-17",1.0634999999999999,null,null,null,null,null,4.0514494575480666E-3,null,null,null,18671.838458617702]
[null,54,"2015-03-18",1.0591999999999999,null,null,null,null,null,-7.9928960015131448E-3,null,null,null,-36836.708570740986]
[null,55,"2015-03-19",1.0677000000000001,null,null,null,null,null,-9.2295439118973942E-3,null,null,null,-42536.024397046807]
[null,56,"2015-03-20",1.0775999999999999,null,null,null,null,null,-1.2541661993043495E-2,null,null,null,-57800.520329930638]
[null,57,"2015-03-23",1.0911999999999999,null,null,null,null,null,-3.4763551614034834E-3,null,null,null,-16021.412257180456]
[null,58,"2015-03-24",1.095,null,null,null,null,null,-3.1912495740638197E-3,null,null,null,-14707.451531214183]
[null,59,"2015-03-25",1.0985,null,null,null,null,null,1.0929958279115384E-3,null,null,null,5037.2691918162063]
[null,60,"2015-03-26",1.0972999999999999,null,null,null,null,null,1.0719787476094079E-2,null,null,null,49404.081714862936]
[null,61,"2015-03-27",1.0855999999999999,null,null,null,null,null,1.0137782537302271E-3,null,null,null,4672.1806565411835]
[null,62,"2015-03-30",1.0845,null,null,null,null,null,7.9615306670655587E-3,null,null,null,36692.155747327444]
[null,63,"2015-03-31",1.0759000000000001,null,null,null,null,null,3.7185089207895537E-4,null,null,null,1713.7421706336972]
[null,64,"2015-04-01",1.0754999999999999,null,null,null,null,null,-6.9492982932059444E-3,null,null,null,-32027.099558096776]
[null,65,"2015-04-02",1.083,null,null,null,null,null,-1.5684830451812909E-3,null,null,null,-7228.6381334817324]
[null,66,"2015-04-07",1.0847,null,null,null,null,null,{"$f":"-LN(D75/D74)","v":-1.3819155545730416E-3},null,null,null,{"$f":"$N$8*J74","v":-6368.8080695087383}]
[null,{"$f":"B74+1","v":67},"2015-04-08",1.0862000000000001,null,null,null,null,null,8.1346353543116662E-3,null,null,null,37489.94004417141]
[null,68,"2015-04-09",1.0773999999999999,null,null,null,null,null,1.9116024376195688E-2,null,null,null,88099.659853424062]
[null,69,"2015-04-10",1.0569999999999999,null,null,null,null,null,1.7043844671328094E-3,null,null,null,7854.9644454754907]
[null,70,"2015-04-13",1.0551999999999999,null,null,null,null,null,-1.1365790198724333E-3,null,null,null,-5238.1302239805455]
[null,71,"2015-04-14",1.0564,null,null,null,null,null,-1.4189095697518576E-3,null,null,null,-6539.3016873095494]
[null,72,"2015-04-15",1.0579000000000001,null,null,null,null,null,-1.2400346777855009E-2,null,null,null,-57149.24357147859]
[null,73,"2015-04-16",1.0710999999999999,null,null,null,null,null,-9.5703401773205368E-3,null,null,null,-44106.645697388092]
[null,74,"2015-04-17",1.0813999999999999,null,null,null,null,null,8.4506237218043793E-3,null,null,null,38946.229654704279]
[null,75,"2015-04-20",1.0723,null,null,null,null,null,2.1472257701481237E-3,null,null,null,9895.8787798011381]
[null,76,"2015-04-21",1.07,null,null,null,null,null,-4.0106382165447886E-3,null,null,null,-18483.752464384394]
[null,77,"2015-04-22",1.0743,null,null,null,null,null,-2.6957952649471254E-3,null,null,null,-12424.060631145625]
[null,78,"2015-04-23",1.0771999999999999,null,null,null,null,null,-4.8157159191345644E-3,null,null,null,-22194.098839651502]
[null,79,"2015-04-24",1.0824,null,null,null,null,null,1.8479164794333439E-4,null,null,null,851.64577148344142]
[null,80,"2015-04-27",1.0822000000000001,null,null,null,null,null,-9.6556913680647012E-3,null,null,null,-44500.002115263829]
[null,81,"2015-04-28",1.0927,null,null,null,null,null,-6.8402838646580647E-3,null,null,null,-31524.686823880806]
[null,82,"2015-04-29",1.1002000000000001,null,null,null,null,null,-1.9175093518905145E-2,null,null,null,-88371.890693797803]
[null,83,"2015-04-30",1.1214999999999999,null,null,null,null,null,5.6333139540035255E-3,null,null,null,25962.147433399856]
[null,84,"2015-05-04",1.1152,null,null,null,null,null,3.1433857666901678E-3,null,null,null,14486.862507789443]
[null,85,"2015-05-05",1.1116999999999999,null,null,null,null,null,-1.0113300498873877E-2,null,null,null,-46608.97665812495]
[null,86,"2015-05-06",1.123,null,null,null,null,null,-6.6563369795814191E-3,null,null,null,-30676.934295037543]
[null,87,"2015-05-07",1.1305000000000001,null,null,null,null,null,7.4580830472039585E-3,null,null,null,34371.926227268115]
[null,88,"2015-05-08",1.1221000000000001,null,null,null,null,null,7.0652710841054575E-3,null,null,null,32561.581165225416]
[null,89,"2015-05-11",1.1142000000000001,null,null,null,null,null,-8.6681209375060238E-3,null,null,null,-39948.604957502204]
[null,90,"2015-05-12",1.1238999999999999,null,null,null,null,null,1.6028498534006671E-3,null,null,null,7387.0237922772485]
[null,91,"2015-05-13",1.1221000000000001,null,null,null,null,null,-1.7491612036781675E-2,null,null,null,-80613.2614398351]
[null,92,"2015-05-14",1.1418999999999999,null,null,null,null,null,8.0010977681469631E-3,null,null,null,36874.507897442847]
[null,93,"2015-05-15",1.1328,null,null,null,null,null,-5.3704403408500407E-3,null,null,null,-24750.64678622023]
[null,94,"2015-05-18",1.1389,null,null,null,null,null,1.8521509565260864E-2,null,null,null,85359.73069292336]
[null,95,"2015-05-19",1.1180000000000001,null,null,null,null,null,5.5610511956755305E-3,null,null,null,25629.111426357813]
[null,96,"2015-05-20",1.1117999999999999,null,null,null,null,null,-1.3482542152925122E-3,null,null,null,-6213.6736920636977]
[null,97,"2015-05-21",1.1133,null,null,null,null,null,-2.7806449275056336E-3,null,null,null,-12815.105665561407]
[null,98,"2015-05-22",1.1164000000000001,null,null,null,null,null,1.6801045546378197E-2,null,null,null,77430.660721535169]
[null,99,"2015-05-25",1.0978000000000001,null,null,null,null,null,4.7480001541716195E-3,null,null,null,21882.01847489853]
[null,100,"2015-05-26",1.0926,null,null,null,null,null,5.7827505219120827E-3,null,null,null,26650.852916470969]
[null,101,"2015-05-27",1.0863,null,null,null,null,null,-3.033229955542581E-3,null,null,null,-13979.189505181996]
[null,102,"2015-05-28",1.0895999999999999,null,null,null,null,null,-6.7685248799824061E-3,null,null,null,-31193.97254893852]
[null,103,"2015-05-29",1.097,null,null,null,null,null,2.3729134069441857E-3,null,null,null,10936.001121328156]
[null,104,"2015-06-01",1.0944,null,null,null,null,null,-7.7368064438152091E-3,null,null,null,-35656.473471580066]
[null,105,"2015-06-02",1.1029,null,null,null,null,null,-9.4753224373061388E-3,null,null,null,-43668.739236788802]
[null,106,"2015-06-03",1.1133999999999999,null,null,null,null,null,-1.6302530222488457E-2,null,null,null,-75133.162580598713]
[null,107,"2015-06-04",1.1316999999999999,null,null,null,null,null,8.7863888976593314E-3,null,null,null,40493.664267744527]
[null,108,"2015-06-05",1.1217999999999999,null,null,null,null,null,5.0044787199031524E-3,null,null,null,23064.046388023577]
[null,109,"2015-06-08",1.1162000000000001,null,null,null,null,null,-7.7640834444469365E-3,null,null,null,-35782.184468290725]
[null,110,"2015-06-09",1.1249,null,null,null,null,null,-2.6633538470909059E-3,null,null,null,-12274.548482486996]
[null,111,"2015-06-10",1.1278999999999999,null,null,null,null,null,4.1757423743243854E-3,null,null,null,19244.664872451918]
[null,112,"2015-06-11",1.1232,null,null,null,null,null,1.0689471889049331E-3,null,null,null,4926.4366842442869]
[null,113,"2015-06-12",1.1220000000000001,null,null,null,null,null,1.7826900840525519E-4,null,null,null,821.58500605740198]
[null,114,"2015-06-15",1.1217999999999999,null,null,null,null,null,2.6746311397348875E-4,null,null,null,1232.6521927720698]
[null,115,"2015-06-16",1.1214999999999999,null,null,null,null,null,-5.6904216856081963E-3,null,null,null,-26225.338755526293]
[null,116,"2015-06-17",1.1278999999999999,null,null,null,null,null,-1.1021581392645868E-2,null,null,null,-50794.953627913746]
[null,117,"2015-06-18",1.1404000000000001,null,null,null,null,null,9.2499448233164822E-3,null,null,null,42630.045691503808]
[null,118,"2015-06-19",1.1298999999999999,null,null,null,null,null,-4.0628920046960008E-3,null,null,null,-18724.573509157031]
[null,119,"2015-06-22",1.1345000000000001,null,null,null,null,null,1.2506260833942918E-2,null,null,null,57637.367677799601]
[null,120,"2015-06-23",1.1204000000000001,null,null,null,null,null,-8.0296208088142401E-4,null,null,null,-3700.5961495289357]
[null,121,"2015-06-24",1.1213,null,null,null,null,null,6.2447033565081619E-4,null,null,null,2877.9846204788746]
[null,122,"2015-06-25",1.1206,null,null,null,null,null,3.5701535545221196E-4,null,null,null,1645.3699136812181]
[null,123,"2015-06-26",1.1202000000000001,null,null,null,null,null,6.1786630410704726E-3,null,null,null,28475.487452562087]
[null,124,"2015-06-29",1.1133,null,null,null,null,null,-5.0174820790138287E-3,null,null,null,-23123.974723123894]
[null,125,"2015-06-30",1.1189,null,null,null,null,null,7.9860445072955644E-3,null,null,null,36805.132218975697]
[null,126,"2015-07-01",1.1100000000000001,null,null,null,null,null,3.0677638423705239E-3,null,null,null,14138.345175999564]
[null,127,"2015-07-02",1.1066,null,null,null,null,null,-2.7073385366122604E-3,null,null,null,-12477.259888861598]
[null,128,"2015-07-03",1.1095999999999999,null,null,null,null,null,7.9624018215425623E-3,null,null,null,36696.170620482728]
[null,129,"2015-07-06",1.1008,null,null,null,null,null,7.0194918792895068E-3,null,null,null,32350.599410166149]
[null,130,"2015-07-07",1.0931,null,null,null,null,null,{"$f":"-LN(D139/D138)","v":-8.471924959604523E-3},null,null,null,{"$f":"$N$8*J138","v":-39044.400266318815}]
[null,{"$f":"B138+1","v":131},"2015-07-08",1.1024,null,null,null,null,null,-2.7176391397683063E-3,null,null,null,-12524.732083731928]
[null,132,"2015-07-09",1.1053999999999999,null,null,null,null,null,-1.1781241531021794E-2,null,null,null,-54295.98493432199]
[null,133,"2015-07-10",1.1185,null,null,null,null,null,1.223366881105503E-2,null,null,null,56381.077979556445]
[null,134,"2015-07-13",1.1049,null,null,null,null,null,1.6304351437933214E-3,null,null,null,7514.1555981760239]
[null,135,"2015-07-14",1.1031,null,null,null,null,null,1.9963708989785287E-3,null,null,null,9200.6367893262159]
[null,136,"2015-07-15",1.1009,null,null,null,null,null,1.2982446007551517E-2,null,null,null,59831.953277638124]
[null,137,"2015-07-16",1.0867,null,null,null,null,null,-2.0224312832093365E-3,null,null,null,-9320.7407890492286]
[null,138,"2015-07-17",1.0889,null,null,null,null,null,3.4037105672386405E-3,null,null,null,15686.616490541748]
[null,139,"2015-07-20",1.0851999999999999,null,null,null,null,null,-1.3812792840292951E-3,null,null,null,-6365.8757014924777]
[null,140,"2015-07-21",1.0867,null,null,null,null,null,-3.2155845613745663E-3,null,null,null,-14819.603726797481]
[null,141,"2015-07-22",1.0902000000000001,null,null,null,null,null,-8.8581009328905762E-3,null,null,null,-40824.162167670656]
[null,142,"2015-07-23",1.0999000000000001,null,null,null,null,null,5.4699744373258533E-3,null,null,null,25209.367693390472]
[null,143,"2015-07-24",1.0939000000000001,null,null,null,null,null,-1.0819762778087308E-2,null,null,null,-49864.835997553368]
[null,144,"2015-07-27",1.1057999999999999,null,null,null,null,null,2.9887265828313836E-3,null,null,null,13774.087653404231]
[null,145,"2015-07-28",1.1025,null,null,null,null,null,-4.5341193250144246E-4,null,null,null,-2089.6309944343334]
[null,146,"2015-07-29",1.103,null,null,null,null,null,6.8228602179812598E-3,null,null,null,31444.386793109541]
[null,147,"2015-07-30",1.0954999999999999,null,null,null,null,null,-1.0947907306421633E-3,null,null,null,-5045.5413260699661]
[null,148,"2015-07-31",1.0967,null,null,null,null,null,1.4599874844497761E-3,null,null,null,6728.6166955536855]
[null,149,"2015-08-03",1.0951,null,null,null,null,null,-2.0069337150398566E-3,null,null,null,-9249.3174398518604]
[null,150,"2015-08-04",1.0972999999999999,null,null,null,null,null,8.2357712947373207E-3,null,null,null,37956.043339245232]
[null,151,"2015-08-05",1.0883,null,null,null,null,null,-1.8375597258618375E-4,null,null,null,-846.87267406067588]
[null,152,"2015-08-06",1.0885,null,null,null,null,null,-5.131505808142138E-3,null,null,null,-23649.473726145265]
[null,153,"2015-08-07",1.0941000000000001,null,null,null,null,null,-1.7350810252166927E-3,null,null,null,-7996.4350919153758]
[null,154,"2015-08-10",1.0960000000000001,null,null,null,null,null,-8.6305327895399731E-3,null,null,null,-39775.373171166291]
[null,155,"2015-08-11",1.1054999999999999,null,null,null,null,null,-9.0050135750861775E-3,null,null,null,-41501.235682062987]
[null,156,"2015-08-12",1.1154999999999999,null,null,null,null,null,4.1322372849104949E-3,null,null,null,19044.1637900182]
[null,157,"2015-08-13",1.1109,null,null,null,null,null,-5.5655439891260303E-3,null,null,null,-25649.817278526196]
[null,158,"2015-08-14",1.1171,null,null,null,null,null,6.3760262704228125E-3,null,null,null,29385.071633421707]
[null,159,"2015-08-17",1.1100000000000001,null,null,null,null,null,3.6101122240996741E-3,null,null,null,16637.855901247029]
[null,160,"2015-08-18",1.1060000000000001,null,null,null,null,null,1.7193796371887586E-3,null,null,null,7924.0724019927702]
[null,161,"2015-08-19",1.1041000000000001,null,null,null,null,null,-1.2779151589051366E-2,null,null,null,-58895.034137575421]
[null,162,"2015-08-20",1.1183000000000001,null,null,null,null,null,-8.725126576732042E-3,null,null,null,-40211.325768414805]
[null,163,"2015-08-21",1.1281000000000001,null,null,null,null,null,-1.8966237148819849E-2,null,null,null,-87409.338292700821]
[null,164,"2015-08-24",1.1496999999999999,null,null,null,null,null,-7.8250666949869084E-4,null,null,null,-3606.3236821206629]
[null,165,"2015-08-25",1.1506000000000001,null,null,null,null,null,9.0798598317115807E-3,null,null,null,41846.178208826619]
[null,166,"2015-08-26",1.1402000000000001,null,null,null,null,null,1.0402985469640297E-2,null,null,null,47944.042301844835]
[null,167,"2015-08-27",1.1284000000000001,null,null,null,null,null,1.4189431256237328E-3,null,null,null,6539.4563356213584]
[null,168,"2015-08-28",1.1268,null,null,null,null,null,4.7146820419546216E-3,null,null,null,21728.46592152708]
[null,169,"2015-08-31",1.1214999999999999,null,null,null,null,null,-1.87074126982558E-3,null,null,null,-8621.6498944534014]
[null,170,"2015-09-01",1.1235999999999999,null,null,null,null,null,-1.6895651166984455E-3,null,null,null,-7786.6667855215765]
[null,171,"2015-09-02",1.1254999999999999,null,null,null,null,null,2.3127567682938513E-3,null,null,null,10658.758358987918]
[null,172,"2015-09-03",1.1229,null,null,null,null,null,8.1370324229248295E-3,null,null,null,37500.987368934606]
[null,173,"2015-09-04",1.1137999999999999,null,null,null,null,null,-7.1800397986783991E-4,null,null,null,-3309.0513568569795]
[null,174,"2015-09-07",1.1146,null,null,null,null,null,-1.4344632188972143E-3,null,null,null,-6610.9834958393485]
[null,175,"2015-09-08",1.1162000000000001,null,null,null,null,null,2.0626885031892906E-3,null,null,null,9506.2734770748266]
[null,176,"2015-09-09",1.1138999999999999,null,null,null,null,null,-4.1211310790402918E-3,null,null,null,-18992.978829161726]
[null,177,"2015-09-10",1.1185,null,null,null,null,null,-7.3932550720331646E-3,null,null,null,-34073.154764691135]
[null,178,"2015-09-11",1.1268,null,null,null,null,null,-3.2782557158070658E-3,null,null,null,-15108.435090446506]
[null,179,"2015-09-14",1.1305000000000001,null,null,null,null,null,-1.3259670451034693E-3,null,null,null,-6110.9592325029998]
[null,180,"2015-09-15",1.1319999999999999,null,null,null,null,null,8.1604142754006966E-3,null,null,null,37608.746870038398]
[null,181,"2015-09-16",1.1228,null,null,null,null,null,-7.4534506545807519E-3,null,null,null,-34350.577007033797]
[null,182,"2015-09-17",1.1312,null,null,null,null,null,-9.4145255652939366E-3,null,null,null,-43388.545843067412]
[null,183,"2015-09-18",1.1418999999999999,null,null,null,null,null,1.49105060690818E-2,null,null,null,68717.767202907562]
[null,184,"2015-09-21",1.125,null,null,null,null,null,8.4803007659333355E-3,null,null,null,39083.001686470037]
[null,185,"2015-09-22",1.1154999999999999,null,null,null,null,null,4.4832997836804936E-4,null,null,null,2066.2098885740502]
[null,186,"2015-09-23",1.115,null,null,null,null,null,-8.1283105735322509E-3,null,null,null,-37460.791146662792]
[null,187,"2015-09-24",1.1241000000000001,null,null,null,null,null,8.038628496435286E-3,null,null,null,37047.475054796436]
[null,188,"2015-09-25",1.1151,null,null,null,null,null,-1.7024330978845804E-3,null,null,null,-7845.9712069425095]
[null,189,"2015-09-28",1.117,null,null,null,null,null,-3.0392443167527859E-3,null,null,null,-14006.907777895358]
[null,190,"2015-09-29",1.1204000000000001,null,null,null,null,null,8.925782127583971E-5,null,null,null,411.36083209076452]
[null,191,"2015-09-30",1.1203000000000001,null,null,null,null,null,4.4730795641865174E-3,null,null,null,20614.997153532633]
[null,192,"2015-10-01",1.1153,null,null,null,null,null,-6.2743694076520477E-4,null,null,null,-2891.6567573392208]
[null,193,"2015-10-02",1.1160000000000001,null,null,null,null,null,-6.7869522888322322E-3,null,null,null,-31278.898599444674]
[null,194,"2015-10-05",1.1235999999999999,null,null,null,null,null,{"$f":"-LN(D203/D202)","v":1.0685664418372996E-3},null,null,null,{"$f":"$N$8*J202","v":4924.6819424376963}]
[null,{"$f":"B202+1","v":195},"2015-10-06",1.1224000000000001,null,null,null,null,null,-3.7349976723623532E-3,null,null,null,-17213.413103731305]
[null,196,"2015-10-07",1.1266,null,null,null,null,null,1.0657194614351073E-3,null,null,null,4911.5611177250621]
[null,197,"2015-10-08",1.1254,null,null,null,null,null,-9.5508331238481365E-3,null,null,null,-44016.743909137542]
[null,198,"2015-10-09",1.1362000000000001,null,null,null,null,null,-9.6767106737229245E-4,null,null,null,-4459.6873391550262]
[null,199,"2015-10-12",1.1373,null,null,null,null,null,-8.7923682300354201E-5,null,null,null,-405.2122110373287]
[null,200,"2015-10-13",1.1374,null,null,null,null,null,-3.1601149893764695E-3,null,null,null,-14563.962159854686]
[null,201,"2015-10-14",1.141,null,null,null,null,null,-2.5384056695519999E-3,null,null,null,-11698.702180774257]
[null,202,"2015-10-15",1.1438999999999999,null,null,null,null,null,6.9301562505310627E-3,null,null,null,31938.879988202483]
[null,203,"2015-10-16",1.1359999999999999,null,null,null,null,null,2.3795895421938351E-3,null,null,null,10966.769299535857]
[null,204,"2015-10-19",1.1333,null,null,null,null,null,-3.5233014514960211E-3,null,null,null,-16237.772736071824]
[null,205,"2015-10-20",1.1373,null,null,null,null,null,1.6720204537729842E-3,null,null,null,7705.8090294548456]
[null,206,"2015-10-21",1.1354,null,null,null,null,null,3.6175978042047351E-3,null,null,null,16672.354552644581]
[null,207,"2015-10-22",1.1313,null,null,null,null,null,2.0449879943597683E-2,null,null,null,94246.974769387671]
[null,208,"2015-10-23",1.1084000000000001,null,null,null,null,null,6.6078538692779382E-3,null,null,null,30453.491101917763]
[null,209,"2015-10-26",1.1011,null,null,null,null,null,-4.5306347886632028E-3,null,null,null,-20880.25082759143]
[null,210,"2015-10-27",1.1061000000000001,null,null,null,null,null,-2.1674351481575046E-3,null,null,null,-9989.0173578567737]
[null,211,"2015-10-28",1.1085,null,null,null,null,null,1.4081540879827647E-2,null,null,null,64897.331019819045]
[null,212,"2015-10-29",1.093,null,null,null,null,null,-7.9282321694806122E-3,null,null,null,-36538.693591539602]
[null,213,"2015-10-30",1.1016999999999999,null,null,null,null,null,-1.3606061330727745E-3,null,null,null,-6270.5997418302823]
[null,214,"2015-11-02",1.1032,null,null,null,null,null,5.0890695074712932E-3,null,null,null,23453.898350169358]
[null,215,"2015-11-03",1.0975999999999999,null,null,null,null,null,3.7424168547982076E-3,null,null,null,17247.605749447077]
[null,216,"2015-11-04",1.0934999999999999,null,null,null,null,null,4.7667154148064118E-3,null,null,null,21968.271142479691]
[null,217,"2015-11-05",1.0883,null,null,null,null,null,1.7473678975843466E-3,null,null,null,8053.0613681195791]
[null,218,"2015-11-06",1.0864,null,null,null,null,null,8.1331317082775356E-3,null,null,null,37483.010219143995]
[null,219,"2015-11-09",1.0775999999999999,null,null,null,null,null,6.0501883255701877E-3,null,null,null,27883.388462071416]
[null,220,"2015-11-10",1.0710999999999999,null,null,null,null,null,-4.6670089986995797E-4,null,null,null,-2150.875606908638]
[null,221,"2015-11-11",1.0716000000000001,null,null,null,null,null,-9.3274887837094516E-4,null,null,null,-4298.7421074578497]
[null,222,"2015-11-12",1.0726,null,null,null,null,null,-3.536532303925951E-3,null,null,null,-16298.749515328247]
[null,223,"2015-11-13",1.0764,null,null,null,null,null,3.81626562665077E-3,null,null,null,17587.951187011255]
[null,224,"2015-11-16",1.0723,null,null,null,null,null,4.9549019243466689E-3,null,null,null,22835.562748371609]
[null,225,"2015-11-17",1.0669999999999999,null,null,null,null,null,3.7495313525145449E-4,null,null,null,1728.0394200460864]
[null,226,"2015-11-18",1.0666,null,null,null,null,null,-1.9669373643492224E-3,null,null,null,-9064.9870151841151]
[null,227,"2015-11-19",1.0687,null,null,null,null,null,-9.3567251530157482E-5,null,null,null,-431.22162176626955]
[null,228,"2015-11-20",1.0688,null,null,null,null,null,5.3473554878217689E-3,null,null,null,24644.256060851119]
[null,229,"2015-11-23",1.0630999999999999,null,null,null,null,null,-1.8795231545605227E-3,null,null,null,-8662.1228004716559]
[null,230,"2015-11-24",1.0650999999999999,null,null,null,null,null,6.121411025232797E-3,null,null,null,28211.631170420966]
[null,231,"2015-11-25",1.0586,null,null,null,null,null,-2.4530628396972529E-3,null,null,null,-11305.384295571384]
[null,232,"2015-11-26",1.0611999999999999,null,null,null,null,null,3.0200098453397484E-3,null,null,null,13918.262233424346]
[null,233,"2015-11-27",1.0580000000000001,null,null,null,null,null,9.4522425515802526E-5,null,null,null,435.62371404132216]
[null,234,"2015-11-30",1.0579000000000001,null,null,null,null,null,-1.9830971133839512E-3,null,null,null,-9139.4621448062098]
[null,235,"2015-12-01",1.06,null,null,null,null,null,-1.1314351574715604E-3,null,null,null,-5214.4238026592775]
[null,236,"2015-12-02",1.0611999999999999,null,null,null,null,null,-5.5443453589346372E-3,null,null,null,-25552.119552656695]
[null,237,"2015-12-03",1.0670999999999999,null,null,null,null,null,-2.1416477007661479E-2,null,null,null,-98701.712369815752]
[null,238,"2015-12-04",1.0902000000000001,null,null,null,null,null,8.5671382080233366E-3,null,null,null,39483.207762802369]
[null,239,"2015-12-07",1.0809,null,null,null,null,null,-6.0874565406819304E-3,null,null,null,-28055.145779915045]
[null,240,"2015-12-08",1.0874999999999999,null,null,null,null,null,-6.0506235199051465E-3,null,null,null,-27885.394133968748]
[null,241,"2015-12-09",1.0941000000000001,null,null,null,null,null,-1.8278194165307208E-4,null,null,null,-842.38367612862112]
[null,242,"2015-12-10",1.0943000000000001,null,null,null,null,null,-6.3947382620385196E-4,null,null,null,-2947.1309235136464]
[null,243,"2015-12-11",1.095,null,null,null,null,null,-3.0091665436990391E-3,null,null,null,-13868.288914315999]
[null,244,"2015-12-14",1.0983000000000001,null,null,null,null,null,-6.3714560932114355E-4,null,null,null,-2936.4009144178726]
[null,245,"2015-12-15",1.099,null,null,null,null,null,5.2000299631822389E-3,null,null,null,23965.279702951491]
[null,246,"2015-12-16",1.0932999999999999,null,null,null,null,null,8.4504957731929425E-3,null,null,null,38945.639980359629]
[null,247,"2015-12-17",1.0841000000000001,null,null,null,null,null,4.6131845630619509E-4,null,null,null,2126.0696410960891]
[null,248,"2015-12-18",1.0835999999999999,null,null,null,null,null,-3.132776910269571E-3,null,null,null,-14437.969671931154]
[null,249,"2015-12-21",1.087,null,null,null,null,null,-7.5153868530295704E-3,null,null,null,-34636.021192946733]
[null,250,"2015-12-22",1.0952,null,null,null,null,null,3.292485140055723E-3,null,null,null,15174.013968750189]
[null,251,"2015-12-23",1.0915999999999999,null,null,null,null,null,-2.8358432763282379E-3,null,null,null,-13069.497251387051]
[null,252,"2015-12-24",1.0947,null,null,null,null,null,-1.3693005015043586E-3,null,null,null,-6310.6693131171205]
[null,253,"2015-12-28",1.0962000000000001,null,null,null,null,null,9.1265863777699658E-4,null,null,null,4206.1525957545509]
[null,254,"2015-12-29",1.0952,null,null,null,null,null,2.3768180126218352E-3,null,null,null,10953.996203636745]
[null,255,"2015-12-30",1.0926,null,null,null,null,null,3.5758530744829059E-3,null,null,null,16479.966406616375]
[null,256,"2015-12-31",1.0887,null,null,null,null,null,-1.0098692618636198E-3,null,null,null,-4654.1653596865326]
[null,257,"2016-01-04",1.0898000000000001,null,null,null,null,null,1.4045693854276989E-2,null,null,null,64732.123511415644]
[null,258,"2016-01-05",1.0746,null,null,null,null,null,{"$f":"-LN(D267/D266)","v":3.7230082336205735E-4},null,null,null,{"$f":"$N$8*J266","v":1715.8157604251007}]
[null,{"$f":"B266+1","v":259},"2016-01-06",1.0742,null,null,null,null,null,-1.1661400080833696E-2,null,null,null,-53743.673910327903]
[null,260,"2016-01-07",1.0868,null,null,null,null,null,6.4430026620224167E-4,null,null,null,2969.3744462144537]
[null,261,"2016-01-08",1.0861000000000001,null,null,null,null,null,-2.4828740512658509E-3,null,null,null,-11442.774662277676]
[null,262,"2016-01-11",1.0888,null,null,null,null,null,4.7873411263163876E-3,null,null,null,22063.328468862182]
[null,263,"2016-01-12",1.0835999999999999,null,null,null,null,null,1.8474049222404261E-3,null,null,null,8514.1001108784512]
[null,264,"2016-01-13",1.0815999999999999,null,null,null,null,null,-7.0938617997002287E-3,null,null,null,-32693.346655229809]
[null,265,"2016-01-14",1.0892999999999999,null,null,null,null,null,-1.9259876637317882E-3,null,null,null,-8876.2629047468017]
[null,266,"2016-01-15",1.0913999999999999,null,null,null,null,null,2.0177939525270576E-3,null,null,null,9299.3688108754959]
[null,267,"2016-01-18",1.0891999999999999,null,null,null,null,null,2.205883247411832E-3,null,null,null,10166.212385424062]
[null,268,"2016-01-19",1.0868,null,null,null,null,null,-3.5820933825046557E-3,null,null,null,-16508.725996125024]
[null,269,"2016-01-20",1.0907,null,null,null,null,null,1.2844038462974528E-3,null,null,null,5919.4077045718032]
[null,270,"2016-01-21",1.0892999999999999,null,null,null,null,null,7.8337804424106535E-3,null,null,null,36103.395704087976]
[null,271,"2016-01-22",1.0808,null,null,null,null,null,-6.4745874712435897E-4,null,null,null,-2983.9308774794486]
[null,272,"2016-01-25",1.0814999999999999,null,null,null,null,null,-2.0321455358361627E-3,null,null,null,-9365.5106813297243]
[null,273,"2016-01-26",1.0837000000000001,null,null,null,null,null,-4.6950604083066281E-3,null,null,null,-21638.036069789217]
[null,274,"2016-01-27",1.0888,null,null,null,null,null,-1.3767153750798514E-3,null,null,null,-6344.8421006696681]
[null,275,"2016-01-28",1.0903,null,null,null,null,null,-1.5579895925142485E-3,null,null,null,-7180.2771567189257]
[null,276,"2016-01-29",1.0920000000000001,null,null,null,null,null,3.3021493957591107E-3,null,null,null,15218.553441155613]
[null,277,"2016-02-01",1.0884,null,null,null,null,null,-3.2105701109294039E-3,null,null,null,-14796.493723907926]
[null,278,"2016-02-02",1.0919000000000001,null,null,null,null,null,-1.2813474204184478E-3,null,null,null,-5905.3216124530436]
[null,279,"2016-02-03",1.0932999999999999,null,null,null,null,null,-2.4663610690745227E-2,null,null,null,-113666.71593690191]
[null,280,"2016-02-04",1.1206,null,null,null,null,null,3.5701535545221196E-4,null,null,null,1645.3699136812181]
[null,281,"2016-02-05",1.1202000000000001,null,null,null,null,null,9.057139437130492E-3,null,null,null,41741.467156207225]
[null,282,"2016-02-08",1.1101000000000001,null,null,null,null,null,-1.2087714891487057E-2,null,null,null,-55708.422911998328]
[null,283,"2016-02-09",1.1235999999999999,null,null,null,null,null,-1.8672481306696413E-3,null,null,null,-8605.5511301181723]
[null,284,"2016-02-10",1.1256999999999999,null,null,null,null,null,-7.9632344361854641E-3,null,null,null,-36700.007875833791]
[null,285,"2016-02-11",1.1347,null,null,null,null,null,6.3655064201104273E-3,null,null,null,29336.588998330273]
[null,286,"2016-02-12",1.1274999999999999,null,null,null,null,null,8.4614176617888292E-3,null,null,null,38995.97548168138]
[null,287,"2016-02-15",1.1180000000000001,null,null,null,null,null,1.253020838784481E-3,null,null,null,5774.773431636203]
[null,288,"2016-02-16",1.1166,null,null,null,null,null,2.6903432961049353E-3,null,null,null,12398.934245497858]
[null,289,"2016-02-17",1.1135999999999999,null,null,null,null,null,4.6804765913317651E-3,null,null,null,21570.823908433638]
[null,290,"2016-02-18",1.1084000000000001,null,null,null,null,null,-1.0820560117982953E-3,null,null,null,-4986.8510682844171]
[null,291,"2016-02-19",1.1095999999999999,null,null,null,null,null,6.3285628450385246E-3,null,null,null,29166.327842895829]
[null,292,"2016-02-22",1.1026,null,null,null,null,null,2.1790457142254315E-3,null,null,null,10042.526754013636]
[null,293,"2016-02-23",1.1002000000000001,null,null,null,null,null,1.9105678376900926E-3,null,null,null,8805.1978442228155]
[null,294,"2016-02-24",1.0981000000000001,null,null,null,null,null,-4.1803041609652248E-3,null,null,null,-19265.688692231219]
[null,295,"2016-02-25",1.1027,null,null,null,null,null,1.9062321389744202E-3,null,null,null,8785.215991586485]
[null,296,"2016-02-26",1.1006,null,null,null,null,null,1.0779313288402188E-2,null,null,null,49678.417199775453]
[null,297,"2016-02-29",1.0888,null,null,null,null,null,1.4705885003223535E-3,null,null,null,6777.4733968266664]
[null,298,"2016-03-01",1.0871999999999999,null,null,null,null,null,1.4727543162746518E-3,null,null,null,6787.4549518272033]
[null,299,"2016-03-02",1.0855999999999999,null,null,null,null,null,-4.1366056136536121E-3,null,null,null,-19064.296024044634]
[null,300,"2016-03-03",1.0901000000000001,null,null,null,null,null,-6.3097461409173028E-3,null,null,null,-29079.607654638145]
[null,301,"2016-03-04",1.097,null,null,null,null,null,1.5508829455293536E-3,null,null,null,7147.5248872225939]
[null,302,"2016-03-07",1.0952999999999999,null,null,null,null,null,-6.8241018199408114E-3,null,null,null,-31450.108940568509]
[null,303,"2016-03-08",1.1028,null,null,null,null,null,4.9997831528883017E-3,null,null,null,23042.406017165791]
[null,304,"2016-03-09",1.0972999999999999,null,null,null,null,null,1.0627676758946795E-2,null,null,null,48979.572795548323]
[null,305,"2016-03-10",1.0857000000000001,null,null,null,null,null,-2.1233768112560465E-2,null,null,null,-97859.665341949512]
[null,306,"2016-03-11",1.109,null,null,null,null,null,-2.6115553588367032E-3,null,null,null,-12035.825769735098]
[null,307,"2016-03-14",1.1119000000000001,null,null,null,null,null,8.9976612152694343E-4,null,null,null,4146.7351000487588]
[null,308,"2016-03-15",1.1109,null,null,null,null,null,4.0589962371281995E-3,null,null,null,18706.619158878075]
[null,309,"2016-03-16",1.1064000000000001,null,null,null,null,null,-2.2079109186786829E-2,null,null,null,-101755.57275626576]
[null,310,"2016-03-17",1.1311,null,null,null,null,null,2.8331138914643077E-3,null,null,null,13056.918387006612]
[null,311,"2016-03-18",1.1278999999999999,null,null,null,null,null,7.0953439783819083E-4,null,null,null,3270.0177544076164]
[null,312,"2016-03-21",1.1271,null,null,null,null,null,5.2484219573996653E-3,null,null,null,24188.302971089455]
[null,313,"2016-03-22",1.1212,null,null,null,null,null,3.6634987138305371E-3,null,null,null,16883.897206358262]
[null,314,"2016-03-23",1.1171,null,null,null,null,null,1.5229566213493259E-3,null,null,null,7018.8213653605599]
[null,315,"2016-03-24",1.1153999999999999,null,null,null,null,null,-3.5797425018058698E-3,null,null,null,-16497.891536728912]
[null,316,"2016-03-29",1.1194,null,null,null,null,null,-1.1546446780485387E-2,null,null,null,-53213.890810013087]
[null,317,"2016-03-30",1.1324000000000001,null,null,null,null,null,-5.3723322660498415E-3,null,null,null,-24759.366066091945]
[null,318,"2016-03-31",1.1385000000000001,null,null,null,null,null,-4.1197411118631955E-3,null,null,null,-18986.572913731838]
[null,319,"2016-04-01",1.1432,null,null,null,null,null,4.5590119293814554E-3,null,null,null,21011.032019103404]
[null,320,"2016-04-04",1.1379999999999999,null,null,null,null,null,1.1430079936113088E-3,null,null,null,5267.7593136100204]
[null,321,"2016-04-05",1.1367,null,null,null,null,null,2.730918316194202E-3,null,null,null,12585.931572874233]
[null,322,"2016-04-06",1.1335999999999999,null,null,null,null,null,{"$f":"-LN(D331/D330)","v":-2.4669616035622173E-3},null,null,null,{"$f":"$N$8*J330","v":-11369.439265621078}]
[null,{"$f":"B330+1","v":323},"2016-04-07",1.1364000000000001,null,null,null,null,null,8.8001056069492758E-5,null,null,null,405.56880206318931]
[null,324,"2016-04-08",1.1363000000000001,null,null,null,null,null,-2.3733145232187045E-3,null,null,null,-10937.849738313116]
[null,325,"2016-04-11",1.139,null,null,null,null,null,-5.2663917657113952E-4,null,null,null,-2427.1120086653823]
[null,326,"2016-04-12",1.1395999999999999,null,null,null,null,null,8.6366977325915435E-3,null,null,null,39803.785427562834]
[null,327,"2016-04-13",1.1297999999999999,null,null,null,null,null,4.0798282754598405E-3,null,null,null,18802.627379779722]
[null,328,"2016-04-14",1.1252,null,null,null,null,null,-2.8399025121395804E-3,null,null,null,-13088.204974667078]
[null,329,"2016-04-15",1.1284000000000001,null,null,null,null,null,-1.9477651133491844E-3,null,null,null,-8976.6282247532363]
[null,330,"2016-04-18",1.1306,null,null,null,null,null,-3.2672553238065664E-3,null,null,null,-15057.737791969259]
[null,331,"2016-04-19",1.1343000000000001,null,null,null,null,null,-3.1687377979658627E-3,null,null,null,-14603.701934650782]
[null,332,"2016-04-20",1.1378999999999999,null,null,null,null,null,2.1113758173497495E-3,null,null,null,9730.6577806465739]
[null,333,"2016-04-21",1.1355,null,null,null,null,null,8.1351584919622261E-3,null,null,null,37492.351018763402]
[null,334,"2016-04-22",1.1263000000000001,null,null,null,null,null,-8.8782350127040823E-5,null,null,null,-409.16953720355662]
[null,335,"2016-04-25",1.1264000000000001,null,null,null,null,null,-2.0398215578025969E-3,null,null,null,-9400.8870185304859]
[null,336,"2016-04-26",1.1287,null,null,null,null,null,-1.4165562351049134E-3,null,null,null,-6528.455918448989]
[null,337,"2016-04-27",1.1303000000000001,null,null,null,null,null,-4.8541642466466877E-3,null,null,null,-22371.294919186174]
[null,338,"2016-04-28",1.1357999999999999,null,null,null,null,null,-3.9541372199806942E-3,null,null,null,-18223.357390559591]
[null,339,"2016-04-29",1.1403000000000001,null,null,null,null,null,-7.8616757114000936E-3,null,null,null,-36231.956102480734]
[null,340,"2016-05-02",1.1493,null,null,null,null,null,-6.5909526601303156E-3,null,null,null,-30375.598819102339]
[null,341,"2016-05-03",1.1569,null,null,null,null,null,5.5473835594225555E-3,null,null,null,25566.121649760393]
[null,342,"2016-05-04",1.1505000000000001,null,null,null,null,null,5.7531539437930043E-3,null,null,null,26514.451726882453]
[null,343,"2016-05-05",1.1438999999999999,null,null,null,null,null,1.0495933789596331E-3,null,null,null,4837.2411465376081]
[null,344,"2016-05-06",1.1427,null,null,null,null,null,2.8043134669292085E-3,null,null,null,12924.186415376776]
[null,345,"2016-05-09",1.1395,null,null,null,null,null,1.756697860633441E-3,null,null,null,8096.0601922942224]
[null,346,"2016-05-10",1.1375,null,null,null,null,null,-2.9845527772181376E-3,null,null,null,-13754.851914445915]
[null,347,"2016-05-11",1.1409,null,null,null,null,null,1.754540322018225E-3,null,null,null,8086.1167849004833]
[null,348,"2016-05-12",1.1389,null,null,null,null,null,3.6064603456091322E-3,null,null,null,16621.025557943878]
[null,349,"2016-05-13",1.1348,null,null,null,null,null,2.1171496969517255E-3,null,null,null,9757.2677503221803]
[null,350,"2016-05-16",1.1324000000000001,null,null,null,null,null,5.2998852932117924E-4,null,null,null,2442.5481073122887]
[null,351,"2016-05-17",1.1317999999999999,null,null,null,null,null,3.4517890625523039E-3,null,null,null,15908.194942213566]
[null,352,"2016-05-18",1.1278999999999999,null,null,null,null,null,7.2967043797198131E-3,null,null,null,33628.18341583624]
[null,353,"2016-05-19",1.1196999999999999,null,null,null,null,null,-1.9628842847677539E-3,null,null,null,-9046.3076640042273]
[null,354,"2016-05-20",1.1218999999999999,null,null,null,null,null,3.5660159065592902E-4,null,null,null,1643.4630036933211]
[null,355,"2016-05-23",1.1214999999999999,null,null,null,null,null,4.1996219521548642E-3,null,null,null,19354.718230980183]
[null,356,"2016-05-24",1.1168,null,null,null,null,null,1.9718568726720268E-3,null,null,null,9087.6594601107317]
[null,357,"2016-05-25",1.1146,null,null,null,null,null,-1.9718568726720983E-3,null,null,null,-9087.659460111061]
[null,358,"2016-05-26",1.1168,null,null,null,null,null,0,null,null,null,0]
[null,359,"2016-05-27",1.1168,null,null,null,null,null,2.6000821569639953E-3,null,null,null,11982.949441345712]
[null,360,"2016-05-30",1.1138999999999999,null,null,null,null,null,-1.3457141043092423E-3,null,null,null,-6201.9671306358568]
[null,361,"2016-05-31",1.1153999999999999,null,null,null,null,null,-1.7914730695951756E-3,null,null,null,-8256.3280398638053]
[null,362,"2016-06-01",1.1173999999999999,null,null,null,null,null,-1.2521243027564122E-3,null,null,null,-5770.6415830067599]
[null,363,"2016-06-02",1.1188,null,null,null,null,null,3.043597372351351E-3,null,null,null,14026.969622869474]
[null,364,"2016-06-03",1.1153999999999999,null,null,null,null,null,-1.7331456351639941E-2,null,null,null,-79875.154963984969]
[null,365,"2016-06-06",1.1349,null,null,null,null,null,8.8117372396973376E-5,null,null,null,406.10486692085931]
[null,366,"2016-06-07",1.1348,null,null,null,null,null,-2.6401493818506497E-3,null,null,null,-12167.606502579665]
[null,367,"2016-06-08",1.1377999999999999,null,null,null,null,null,3.080852751550003E-3,null,null,null,14198.667784083304]
[null,368,"2016-06-09",1.1343000000000001,null,null,null,null,null,3.444168194679199E-3,null,null,null,15873.072792639176]
[null,369,"2016-06-10",1.1304000000000001,null,null,null,null,null,3.1897953681001494E-3,null,null,null,14700.749559704056]
[null,370,"2016-06-13",1.1268,null,null,null,null,null,3.8234163858081546E-3,null,null,null,17620.906755442305]
[null,371,"2016-06-14",1.1225000000000001,null,null,null,null,null,-4.453351220338586E-4,null,null,null,-2052.4075508515352]
[null,372,"2016-06-15",1.123,null,null,null,null,null,4.999117713394805E-3,null,null,null,23039.339218762718]
[null,373,"2016-06-16",1.1173999999999999,null,null,null,null,null,-7.1339699741302743E-3,null,null,null,-32878.19243984959]
[null,374,"2016-06-17",1.1254,null,null,null,null,null,-6.906960957183011E-3,null,null,null,-31831.980278621213]
[null,375,"2016-06-20",1.1332,null,null,null,null,null,1.5896850473061674E-3,null,null,null,7326.3513995172789]
[null,376,"2016-06-21",1.1314,null,null,null,null,null,2.7437287646547726E-3,null,null,null,12644.97084431142]
[null,377,"2016-06-22",1.1283000000000001,null,null,null,null,null,-9.3508091359050406E-3,null,null,null,-43094.897140504203]
[null,378,"2016-06-23",1.1389,null,null,null,null,null,2.8770632816296094E-2,null,null,null,132594.67109906863]
[null,379,"2016-06-24",1.1066,null,null,null,null,null,6.1639063902949815E-3,null,null,null,28407.478755339696]
[null,380,"2016-06-27",1.0998000000000001,null,null,null,null,null,-6.7962746303481345E-3,null,null,null,-31321.862298403499]
[null,381,"2016-06-28",1.1073,null,null,null,null,null,-1.5340886463044465E-3,null,null,null,-7070.1253181451775]
[null,382,"2016-06-29",1.109,null,null,null,null,null,-1.0814709056939603E-3,null,null,null,-4984.1545008520034]
[null,383,"2016-06-30",1.1102000000000001,null,null,null,null,null,-2.9680284413613092E-3,null,null,null,-13678.696520435058]
[null,384,"2016-07-01",1.1134999999999999,null,null,null,null,null,-2.6938445814578483E-4,null,null,null,-1241.5070553056951]
[null,385,"2016-07-04",1.1137999999999999,null,null,null,null,null,-7.1800397986783991E-4,null,null,null,-3309.0513568569795]
[null,386,"2016-07-05",1.1146,null,null,null,null,null,{"$f":"-LN(D395/D394)","v":6.9322807438577739E-3},null,null,null,{"$f":"$N$8*J394","v":31948.67110040033}]
[null,{"$f":"B394+1","v":387},"2016-07-06",1.1069,null,null,null,null,null,-9.932729156508645E-4,null,null,null,-4577.6780929108045]
[null,388,"2016-07-07",1.1080000000000001,null,null,null,null,null,9.0293459859236457E-4,null,null,null,4161.3376003502635]
[null,389,"2016-07-08",1.107,null,null,null,null,null,1.8988205895075474E-3,null,null,null,8751.0585237904397]
[null,390,"2016-07-11",1.1049,null,null,null,null,null,-3.8842016224937062E-3,null,null,null,-17901.046525653914]
[null,391,"2016-07-12",1.1092,null,null,null,null,null,1.8047288782178197E-3,null,null,null,8317.4198342534]
[null,392,"2016-07-13",1.1072,null,null,null,null,null,-7.647704735728832E-3,null,null,null,-35245.8321153918]
[null,393,"2016-07-14",1.1156999999999999,null,null,null,null,null,2.6026489899007564E-3,null,null,null,11994.779155735008]
[null,394,"2016-07-15",1.1128,null,null,null,null,null,6.76257029232345E-3,null,null,null,31166.529753459839]
[null,395,"2016-07-18",1.1052999999999999,null,null,null,null,null,1.6298446201186228E-3,null,null,null,7511.4340628895798]
[null,396,"2016-07-19",1.1034999999999999,null,null,null,null,null,1.9956465258927345E-3,null,null,null,9197.2983847913856]
[null,397,"2016-07-20",1.1012999999999999,null,null,null,null,null,-1.8158707149950381E-4,null,null,null,-836.87690065968729]
[null,398,"2016-07-21",1.1014999999999999,null,null,null,null,null,9.0789414016739933E-5,null,null,null,418.41945457689758]
[null,399,"2016-07-22",1.1013999999999999,null,null,null,null,null,2.9096219836087277E-3,null,null,null,13409.519783683594]
[null,400,"2016-07-25",1.0982000000000001,null,null,null,null,null,-1.3649394721164305E-3,null,null,null,-6290.5707194908391]
[null,401,"2016-07-26",1.0996999999999999,null,null,null,null,null,5.4575224203400334E-4,null,null,null,2515.1980318309184]
[null,402,"2016-07-27",1.0991,null,null,null,null,null,-8.9670452755122986E-3,null,null,null,-41326.251898204828]
[null,403,"2016-07-28",1.109,null,null,null,null,null,-2.0717928412338372E-3,null,null,null,-9548.2324675599993]
[null,404,"2016-07-29",1.1113,null,null,null,null,null,-4.5787214705663402E-3,null,null,null,-21101.867008643261]
[null,405,"2016-08-01",1.1164000000000001,null,null,null,null,null,-2.5942672330546753E-3,null,null,null,-11956.150311547439]
[null,406,"2016-08-02",1.1193,null,null,null,null,null,-6.2519539391853998E-4,null,null,null,-2881.3261827987008]
[null,407,"2016-08-03",1.1200000000000001,null,null,null,null,null,5.7306747089852072E-3,null,null,null,26410.852102747307]
[null,408,"2016-08-04",1.1135999999999999,null,null,null,null,null,-1.7943661731787996E-3,null,null,null,-8269.6614316100186]
[null,409,"2016-08-05",1.1155999999999999,null,null,null,null,null,6.2042189750278242E-3,null,null,null,28593.26660185439]
[null,410,"2016-08-08",1.1087,null,null,null,null,null,8.120911793025366E-4,null,null,null,3742.6692526931047]
[null,411,"2016-08-09",1.1077999999999999,null,null,null,null,null,-9.5230258805425062E-3,null,null,null,-43888.589193048247]
[null,412,"2016-08-10",1.1184000000000001,null,null,null,null,null,2.7756654790546931E-3,null,null,null,12792.156975700362]
[null,413,"2016-08-11",1.1153,null,null,null,null,null,-4.4820941093671665E-4,null,null,null,-2065.6542317344911]
[null,414,"2016-08-12",1.1157999999999999,null,null,null,null,null,-1.9697383036166496E-3,null,null,null,-9077.8956509900891]
[null,415,"2016-08-15",1.1180000000000001,null,null,null,null,null,-1.0233682193013256E-2,null,null,null,-47163.777494195492]
[null,416,"2016-08-16",1.1294999999999999,null,null,null,null,null,1.6835766681005334E-3,null,null,null,7759.0679357742029]
[null,417,"2016-08-17",1.1275999999999999,null,null,null,null,null,-3.9828348441063813E-3,null,null,null,-18355.615587887627]
[null,418,"2016-08-18",1.1321000000000001,null,null,null,null,null,-4.4155959564081982E-4,null,null,null,-2035.0073537996554]
[null,419,"2016-08-19",1.1326000000000001,null,null,null,null,null,1.7674094385142134E-3,null,null,null,8145.4264386024579]
[null,420,"2016-08-22",1.1306,null,null,null,null,null,-2.9145527366035342E-3,null,null,null,-13432.244051717309]
[null,421,"2016-08-23",1.1338999999999999,null,null,null,null,null,6.2812609755764455E-3,null,null,null,28948.328612091878]
[null,422,"2016-08-24",1.1268,null,null,null,null,null,-1.950528147444539E-3,null,null,null,-8989.3621677098745]
[null,423,"2016-08-25",1.129,null,null,null,null,null,0,null,null,null,0]
[null,424,"2016-08-26",1.129,null,null,null,null,null,1.0685765080461276E-2,null,null,null,49247.283343838622]
[null,425,"2016-08-29",1.117,null,null,null,null,null,1.7906706109267133E-4,null,null,null,825.26297637815674]
[null,426,"2016-08-30",1.1168,null,null,null,null,null,3.2287023563723339E-3,null,null,null,14880.059460405426]
[null,427,"2016-08-31",1.1132,null,null,null,null,null,-1.2568454837002202E-3,null,null,null,-5792.4000002942939]
[null,428,"2016-09-01",1.1146,null,null,null,null,null,-4.2078937597857845E-3,null,null,null,-19392.840354300162]
[null,429,"2016-09-02",1.1193,null,null,null,null,null,3.3111131418880313E-3,null,null,null,15259.864488339343]
[null,430,"2016-09-05",1.1155999999999999,null,null,null,null,null,-2.6887743832169426E-4,null,null,null,-1239.1703626355943]
[null,431,"2016-09-06",1.1158999999999999,null,null,null,null,null,-6.9655577222012526E-3,null,null,null,-32102.034080867175]
[null,432,"2016-09-07",1.1236999999999999,null,null,null,null,null,-5.2367758251210253E-3,null,null,null,-24134.629661610219]
[null,433,"2016-09-08",1.1295999999999999,null,null,null,null,null,2.4818307367600149E-3,null,null,null,11437.966358454903]
[null,434,"2016-09-09",1.1268,null,null,null,null,null,3.7343334941185575E-3,null,null,null,17210.352118025861]
[null,435,"2016-09-12",1.1226,null,null,null,null,null,-1.8689099018770303E-3,null,null,null,-8613.2097036397408]
[null,436,"2016-09-13",1.1247,null,null,null,null,null,2.5817953357395508E-3,null,null,null,11898.671314368634]
[null,437,"2016-09-14",1.1217999999999999,null,null,null,null,null,-3.203989924942204E-3,null,null,null,-14766.167745250645]
[null,438,"2016-09-15",1.1254,null,null,null,null,null,2.4911044910795616E-3,null,null,null,11480.70613452119]
[null,439,"2016-09-16",1.1226,null,null,null,null,null,5.4486312278863329E-3,null,null,null,25111.003647875674]
[null,440,"2016-09-19",1.1165,null,null,null,null,null,-1.7003001993332555E-3,null,null,null,-7836.1413577450176]
[null,441,"2016-09-20",1.1184000000000001,null,null,null,null,null,3.0446875853267479E-3,null,null,null,14031.994066781559]
[null,442,"2016-09-21",1.115,null,null,null,null,null,-7.8613947838787022E-3,null,null,null,-36230.661397128257]
[null,443,"2016-09-22",1.1237999999999999,null,null,null,null,null,2.1378949885256498E-3,null,null,null,9852.8761830828498]
[null,444,"2016-09-23",1.1214,null,null,null,null,null,-4.2712291309460262E-3,null,null,null,-19684.732881014868]
[null,445,"2016-09-26",1.1262000000000001,null,null,null,null,null,3.7363267378765067E-3,null,null,null,17219.538342819495]
[null,446,"2016-09-27",1.1220000000000001,null,null,null,null,null,-4.4553353376777208E-4,null,null,null,-2053.3219672555274]
[null,447,"2016-09-28",1.1225000000000001,null,null,null,null,null,3.5641094558879079E-4,null,null,null,1642.5843813795452]
[null,448,"2016-09-29",1.1221000000000001,null,null,null,null,null,5.3614640091513158E-3,null,null,null,24709.277736159071]
[null,449,"2016-09-30",1.1161000000000001,null,null,null,null,null,-6.697350568419142E-3,null,null,null,-30865.952845906886]
[null,450,"2016-10-03",1.1235999999999999,null,null,null,null,null,{"$f":"-LN(D459/D458)","v":6.6973505684192677E-3},null,null,null,{"$f":"$N$8*J458","v":30865.952845907465}]
[null,{"$f":"B458+1","v":451},"2016-10-04",1.1161000000000001,null,null,null,null,null,-4.469880497878667E-3,null,null,null,-20600.253677168315]
[null,452,"2016-10-05",1.1211,null,null,null,null,null,2.3218442293635329E-3,null,null,null,10700.639568878356]
[null,453,"2016-10-06",1.1185,null,null,null,null,null,4.0313604429549708E-3,null,null,null,18579.254597161336]
[null,454,"2016-10-07",1.1140000000000001,null,null,null,null,null,-1.7937224540269007E-3,null,null,null,-8266.6947353343003]
[null,455,"2016-10-10",1.1160000000000001,null,null,null,null,null,7.2845324146289872E-3,null,null,null,33572.086710624622]
[null,456,"2016-10-11",1.1079000000000001,null,null,null,null,null,5.3396208137674525E-3,null,null,null,24608.609414882678]
[null,457,"2016-10-12",1.1020000000000001,null,null,null,null,null,-1.6320612925408871E-3,null,null,null,-7521.6499991410074]
[null,458,"2016-10-13",1.1037999999999999,null,null,null,null,null,3.2667905640429923E-3,null,null,null,15055.59586244047]
[null,459,"2016-10-14",1.1002000000000001,null,null,null,null,null,7.2740501479788577E-4,null,null,null,3352.3777286646318]
[null,460,"2016-10-17",1.0993999999999999,null,null,null,null,null,9.0962841741917908E-5,null,null,null,419.21872765254602]
[null,461,"2016-10-18",1.0992999999999999,null,null,null,null,null,1.2743493441312026E-3,null,null,null,5873.0697106767338]
[null,462,"2016-10-19",1.0979000000000001,null,null,null,null,null,-9.107882878920946E-5,null,null,null,-419.75327496283893]
[null,463,"2016-10-20",1.0980000000000001,null,null,null,null,null,8.5978760693763059E-3,null,null,null,39624.868762837003]
[null,464,"2016-10-21",1.0886,null,null,null,null,null,-4.5920008154111066E-4,null,null,null,-2116.306727397443]
[null,465,"2016-10-24",1.0891,null,null,null,null,null,1.7460832447068065E-3,null,null,null,8047.140812709431]
[null,466,"2016-10-25",1.0871999999999999,null,null,null,null,null,-4.8630641328112944E-3,null,null,null,-22412.311656160648]
[null,467,"2016-10-26",1.0925,null,null,null,null,null,-1.8304960695447712E-4,null,null,null,-843.61726013878331]
[null,468,"2016-10-27",1.0927,null,null,null,null,null,4.5768685864629172E-4,null,null,null,2109.3327656733736]
[null,469,"2016-10-28",1.0922000000000001,null,null,null,null,null,-2.1949889917644017E-3,null,null,null,-10116.004235549026]
[null,470,"2016-10-31",1.0946,null,null,null,null,null,-7.1913286111832944E-3,null,null,null,-33142.540105168526]
[null,471,"2016-11-01",1.1025,null,null,null,null,null,-6.3291350516475296E-3,null,null,null,-29168.964960668185]
[null,472,"2016-11-02",1.1094999999999999,null,null,null,null,null,2.7979620221000971E-3,null,null,null,12894.914631766829]
[null,473,"2016-11-03",1.1064000000000001,null,null,null,null,null,-2.6176843940653618E-3,null,null,null,-12064.072538427592]
[null,474,"2016-11-04",1.1093,null,null,null,null,null,2.798467184036162E-3,null,null,null,12897.242762023538]
[null,475,"2016-11-07",1.1062000000000001,null,null,null,null,null,2.1719465551768825E-3,null,null,null,10009.808994027864]
[null,476,"2016-11-08",1.1037999999999999,null,null,null,null,null,1.4505895562658224E-3,null,null,null,6685.3046417479663]
[null,477,"2016-11-09",1.1022000000000001,null,null,null,null,null,1.1589307064460578E-2,null,null,null,53411.420189821663]
[null,478,"2016-11-10",1.0894999999999999,null,null,null,null,null,-8.2572599764833669E-4,null,null,null,-3805.5077820226675]
[null,479,"2016-11-11",1.0904,null,null,null,null,null,1.1715460779536734E-2,null,null,null,53992.822429572676]
[null,480,"2016-11-14",1.0777000000000001,null,null,null,null,null,1.1141027983684348E-3,null,null,null,5134.5444872016014]
[null,481,"2016-11-15",1.0765,null,null,null,null,null,5.8694909272134169E-3,null,null,null,27050.611781191379]
[null,482,"2016-11-16",1.0702,null,null,null,null,null,-1.4006258417472207E-3,null,null,null,-6455.0378159960728]
[null,483,"2016-11-17",1.0717000000000001,null,null,null,null,null,8.2451511794155163E-3,null,null,null,37999.272236287361]
[null,484,"2016-11-18",1.0629,null,null,null,null,null,-1.8814675502341286E-4,null,null,null,-867.1083900023217]
[null,485,"2016-11-21",1.0630999999999999,null,null,null,null,null,1.31777127503197E-3,null,null,null,6073.1875420444394]
[null,486,"2016-11-22",1.0617000000000001,null,null,null,null,null,1.4138274658217166E-3,null,null,null,6515.8798910838286]
[null,487,"2016-11-23",1.0602,null,null,null,null,null,5.1063940745741387E-3,null,null,null,23533.741754782772]
[null,488,"2016-11-24",1.0548,null,null,null,null,null,-4.1627307036120054E-3,null,null,null,-19184.698231830087]
[null,489,"2016-11-25",1.0591999999999999,null,null,null,null,null,3.7771482979757106E-4,null,null,null,1740.7671894474952]
[null,490,"2016-11-28",1.0588,null,null,null,null,null,1.1340012555241935E-3,null,null,null,5226.2501302019973]
[null,491,"2016-11-29",1.0576000000000001,null,null,null,null,null,-5.5631655428698195E-3,null,null,null,-25638.855778267141]
[null,492,"2016-11-30",1.0634999999999999,null,null,null,null,null,7.5251626164236614E-4,null,null,null,3468.1074568736494]
[null,493,"2016-12-01",1.0627,null,null,null,null,null,-1.4105037836194623E-3,null,null,null,-6500.5620998047943]
[null,494,"2016-12-02",1.0642,null,null,null,null,null,-5.6222037149353211E-3,null,null,null,-25910.943884820063]
[null,495,"2016-12-05",1.0702,null,null,null,null,null,-2.9856338655240887E-3,null,null,null,-13759.834305666571]
[null,496,"2016-12-06",1.0733999999999999,null,null,null,null,null,3.7271711202999835E-4,null,null,null,1717.7343021325546]
[null,497,"2016-12-07",1.073,null,null,null,null,null,-2.9778544246209363E-3,null,null,null,-13723.981343568919]
[null,498,"2016-12-08",1.0762,null,null,null,null,null,1.904283424285054E-2,null,null,null,87762.349870687074]
[null,499,"2016-12-09",1.0559000000000001,null,null,null,null,null,-3.4979945854459009E-3,null,null,null,-16121.141461331032]
[null,500,"2016-12-12",1.0596000000000001,null,null,null,null,null,-1.3203812160682787E-3,null,null,null,-6085.2159279164844]
[null,501,"2016-12-13",1.0609999999999999,null,null,null,null,null,-3.1994004895509612E-3,null,null,null,-14745.016501198495]
[null,502,"2016-12-14",1.0644,null,null,null,null,null,2.1365290685396068E-2,null,null,null,98465.810934873778]
[null,503,"2016-12-15",1.0419,null,null,null,null,null,-1.9177299961147273E-3,null,null,null,-8838.2059482411587]
[null,504,"2016-12-16",1.0439000000000001,null,null,null,null,null,1.6298359391385144E-3,null,null,null,7511.3940550208044]
[null,505,"2016-12-19",1.0422,null,null,null,null,null,5.5806937871593814E-3,null,null,null,25719.637866077253]
[null,506,"2016-12-20",1.0364,null,null,null,null,null,-5.4847383104270255E-3,null,null,null,-25277.409676008578]
[null,507,"2016-12-21",1.0421,null,null,null,null,null,-2.2046498265920283E-3,null,null,null,-10160.527942229055]
[null,508,"2016-12-22",1.0444,null,null,null,null,null,-1.9147917722459355E-4,null,null,null,-882.46646114904013]
[null,509,"2016-12-23",1.0446,null,null,null,null,null,9.5735005577904503E-5,null,null,null,441.21210883063071]
[null,510,"2016-12-27",1.0445,null,null,null,null,null,4.221439637533045E-3,null,null,null,19455.268984776056]
[null,511,"2016-12-28",1.0401,null,null,null,null,null,-4.987063179573919E-3,null,null,null,-22983.783716822985]
[null,512,"2016-12-29",1.0452999999999999,null,null,null,null,null,-8.3833967224822142E-3,null,null,null,-38636.401854912161]
[null,513,"2016-12-30",1.0541,null,null,null,null,null,7.2360593750891312E-3,null,null,null,33348.689930442619]
[null,514,"2017-01-02",1.0465,null,null,null,null,null,{"$f":"-LN(D523/D522)","v":7.6738985698873892E-3},null,null,null,{"$f":"$N$8*J522","v":35366.551143271856}]
[null,{"$f":"B522+1","v":515},"2017-01-03",1.0385,null,null,null,null,null,-4.9947275098391943E-3,null,null,null,-23019.106170701831]
[null,516,"2017-01-04",1.0437000000000001,null,null,null,null,null,-6.1133058859416112E-3,null,null,null,-28174.277168324836]
[null,517,"2017-01-05",1.0501,null,null,null,null,null,-8.3452357244610583E-3,null,null,null,-38460.529985366025]
[null,518,"2017-01-06",1.0589,null,null,null,null,null,6.9178195806824314E-3,null,null,null,31882.024211289903]
[null,519,"2017-01-09",1.0516000000000001,null,null,null,null,null,-4.838030591258897E-3,null,null,null,-22296.940046861011]
[null,520,"2017-01-10",1.0567,null,null,null,null,null,6.0750068182553489E-3,null,null,null,27997.768979725504]
[null,521,"2017-01-11",1.0503,null,null,null,null,null,-1.661826554876988E-2,null,null,null,-76588.28600488884]
[null,522,"2017-01-12",1.0679000000000001,null,null,null,null,null,1.6869732210701245E-3,null,null,null,7774.7215651798924]
[null,523,"2017-01-13",1.0661,null,null,null,null,null,6.3044198460032773E-3,null,null,null,29055.060460045268]
[null,524,"2017-01-16",1.0593999999999999,null,null,null,null,null,-8.4594921253796744E-3,null,null,null,-38987.101298465059]
[null,525,"2017-01-17",1.0684,null,null,null,null,null,1.8737123713068395E-3,null,null,null,8635.3427536346717]
[null,526,"2017-01-18",1.0664,null,null,null,null,null,-3.7502344336017685E-4,null,null,null,-1728.3634476964744]
[null,527,"2017-01-19",1.0668,null,null,null,null,null,3.3802849088236404E-3,null,null,null,15578.655101835111]
[null,528,"2017-01-20",1.0631999999999999,null,null,null,null,null,-7.7763075145960469E-3,null,null,null,-35838.521309098585]
[null,529,"2017-01-23",1.0714999999999999,null,null,null,null,null,-3.0750618277044948E-3,null,null,null,-14171.979262925021]
[null,530,"2017-01-24",1.0748,null,null,null,null,null,4.6531106883935267E-4,null,null,null,2144.4703189345059]
[null,531,"2017-01-25",1.0743,null,null,null,null,null,4.0106382165448519E-3,null,null,null,18483.752464384685]
[null,532,"2017-01-26",1.07,null,null,null,null,null,1.7772793603021073E-3,null,null,null,8190.9137604001917]
[null,533,"2017-01-27",1.0681,null,null,null,null,null,4.7862697537019707E-3,null,null,null,22058.390854165275]
[null,534,"2017-01-30",1.0629999999999999,null,null,null,null,null,-1.1690570365836714E-2,null,null,null,-53878.11045089821]
[null,535,"2017-01-31",1.0754999999999999,null,null,null,null,null,-3.2490165503500567E-3,null,null,null,-14973.681101831164]
[null,536,"2017-02-01",1.079,null,null,null,null,null,-1.6668213878545614E-3,null,null,null,-7681.8481927267358]
[null,537,"2017-02-02",1.0808,null,null,null,null,null,6.2184060419876773E-3,null,null,null,28658.650268922593]
[null,538,"2017-02-03",1.0741000000000001,null,null,null,null,null,2.7035862270386943E-3,null,null,null,12459.966690726342]
[null,539,"2017-02-06",1.0711999999999999,null,null,null,null,null,3.4600492741831261E-3,null,null,null,15946.263623267296]
[null,540,"2017-02-07",1.0674999999999999,null,null,null,null,null,9.3720719137420556E-4,null,null,null,4319.2890502414366]
[null,541,"2017-02-08",1.0665,null,null,null,null,null,-2.5284463533586906E-3,null,null,null,-11652.802868671692]
[null,542,"2017-02-09",1.0691999999999999,null,null,null,null,null,5.9096837252278775E-3,null,null,null,27235.847568923517]
[null,543,"2017-02-10",1.0629,null,null,null,null,null,0,null,null,null,0]
[null,544,"2017-02-13",1.0629,null,null,null,null,null,5.6465275356820633E-4,null,null,null,2602.3044617271112]
[null,545,"2017-02-14",1.0623,null,null,null,null,null,6.4217804975923659E-3,null,null,null,29595.938274474618]
[null,546,"2017-02-15",1.0555000000000001,null,null,null,null,null,-9.1479866514015927E-3,null,null,null,-42160.152993722775]
[null,547,"2017-02-16",1.0651999999999999,null,null,null,null,null,1.8777579625168259E-4,null,null,null,865.39875932985933]
[null,548,"2017-02-17",1.0649999999999999,null,null,null,null,null,3.1975951255275659E-3,null,null,null,14736.69615418268]
[null,549,"2017-02-20",1.0616000000000001,null,null,null,null,null,7.4694244125158111E-3,null,null,null,34424.194962993934]
[null,550,"2017-02-21",1.0537000000000001,null,null,null,null,null,2.2802860236968304E-3,null,null,null,10509.111052733841]
[null,551,"2017-02-22",1.0512999999999999,null,null,null,null,null,-5.6909951566956885E-3,null,null,null,-26227.981700876724]
[null,552,"2017-02-23",1.0572999999999999,null,null,null,null,null,-3.3991157267450741E-3,null,null,null,-15665.440336096788]
[null,553,"2017-02-24",1.0609,null,null,null,null,null,2.0758641158917595E-3,null,null,null,9566.9956740444741]
[null,554,"2017-02-27",1.0587,null,null,null,null,null,-9.4410883145639552E-4,null,null,null,-4351.0965083041519]
[null,555,"2017-02-28",1.0597000000000001,null,null,null,null,null,6.0577563382942243E-3,null,null,null,27918.267019120354]
[null,556,"2017-03-01",1.0532999999999999,null,null,null,null,null,1.8054834571486422E-3,null,null,null,8320.8974478946966]
[null,557,"2017-03-02",1.0513999999999999,null,null,null,null,null,-4.8389486707637337E-3,null,null,null,-22301.171182504218]
[null,558,"2017-03-03",1.0565,null,null,null,null,null,-2.5523481266322289E-3,null,null,null,-11762.958518918433]
[null,559,"2017-03-06",1.0591999999999999,null,null,null,null,null,1.5117160853217451E-3,null,null,null,6967.0173196494025]
[null,560,"2017-03-07",1.0576000000000001,null,null,null,null,null,1.8928644682528549E-3,null,null,null,8723.6086604581033]
[null,561,"2017-03-08",1.0556000000000001,null,null,null,null,null,4.737764811226958E-4,null,null,null,2183.4847043529635]
[null,562,"2017-03-09",1.0550999999999999,null,null,null,null,null,-5.1992365549832749E-3,null,null,null,-23961.623137596791]
[null,563,"2017-03-10",1.0606,null,null,null,null,null,-5.3599263211042969E-3,null,null,null,-24702.191022350955]
[null,564,"2017-03-13",1.0663,null,null,null,null,null,3.0055437295744337E-3,null,null,null,13851.59251940622]
[null,565,"2017-03-14",1.0630999999999999,null,null,null,null,null,8.4693930626068674E-4,null,null,null,3903.273156053106]
[null,566,"2017-03-15",1.0622,null,null,null,null,null,-9.7433785605261034E-3,null,null,null,-44904.124420054941]
[null,567,"2017-03-16",1.0726,null,null,null,null,null,-1.0250198912650709E-3,null,null,null,-4723.9897787480222]
[null,568,"2017-03-17",1.0737000000000001,null,null,null,null,null,-1.3960633287950731E-3,null,null,null,-6434.0106488795891]
[null,569,"2017-03-20",1.0751999999999999,null,null,null,null,null,-4.6395183899057037E-3,null,null,null,-21382.06062048045]
[null,570,"2017-03-21",1.0802,null,null,null,null,null,-4.6277015032919429E-4,null,null,null,-2132.7600358727741]
[null,571,"2017-03-22",1.0807,null,null,null,null,null,1.9450754059932721E-3,null,null,null,8964.2322213532734]
[null,572,"2017-03-23",1.0786,null,null,null,null,null,-1.7599930438140776E-3,null,null,null,-8111.2466406715484]
[null,573,"2017-03-24",1.0805,null,null,null,null,null,-7.7441154050746338E-3,null,null,null,-35690.158143045483]
[null,574,"2017-03-27",1.0889,null,null,null,null,null,2.7588761291603725E-3,null,null,null,12714.780216509173]
[null,575,"2017-03-28",1.0859000000000001,null,null,null,null,null,1.0274538481518701E-2,null,null,null,47352.071097999709]
[null,576,"2017-03-29",1.0748,null,null,null,null,null,1.0239703012462191E-3,null,null,null,4719.1525530871495]
[null,577,"2017-03-30",1.0737000000000001,null,null,null,null,null,4.2934544206357731E-3,null,null,null,19787.162153089284]
[null,578,"2017-03-31",1.0690999999999999,null,null,null,null,null,{"$f":"-LN(D587/D586)","v":2.8100430630246757E-3},null,null,null,{"$f":"$N$8*J586","v":12950.592296493811}]
[null,{"$f":"B586+1","v":579},"2017-04-03",1.0661,null,null,null,null,null,9.3843850730949323E-4,null,null,null,4324.963792694999]
[null,580,"2017-04-04",1.0650999999999999,null,null,null,null,null,-2.531765616966E-3,null,null,null,-11668.100296055805]
[null,581,"2017-04-05",1.0678000000000001,null,null,null,null,null,1.1244378995841184E-3,null,null,null,5182.1756726266558]
[null,582,"2017-04-06",1.0666,null,null,null,null,null,3.3809198245539867E-3,null,null,null,15581.581225948488]
[null,583,"2017-04-07",1.0629999999999999,null,null,null,null,null,4.9038197100682241E-3,null,null,null,22600.141113939357]
[null,584,"2017-04-10",1.0578000000000001,null,null,null,null,null,-3.585924386118221E-3,null,null,null,-16526.381869993475]
[null,585,"2017-04-11",1.0616000000000001,null,null,null,null,null,1.0367090132607107E-3,null,null,null,4777.8612141225976]
[null,586,"2017-04-12",1.0605,null,null,null,null,null,-2.3546043372108349E-3,null,null,null,-10851.620458069039]
[null,587,"2017-04-13",1.0629999999999999,null,null,null,null,null,-4.8798895637221801E-3,null,null,null,-22489.854701250199]
[null,588,"2017-04-18",1.0682,null,null,null,null,null,-4.017382896502047E-3,null,null,null,-18514.836543289137]
[null,589,"2017-04-19",1.0725,null,null,null,null,null,-1.8630652803930052E-3,null,null,null,-8586.2737071908232]
[null,590,"2017-04-20",1.0745,null,null,null,null,null,4.3837219854153753E-3,null,null,null,20203.176570960753]
[null,591,"2017-04-21",1.0698000000000001,null,null,null,null,null,-1.3923923088981299E-2,null,null,null,-64170.920889389257]
[null,592,"2017-04-24",1.0848,null,null,null,null,null,-3.9560288955094967E-3,null,null,null,-18232.0755197773]
[null,593,"2017-04-25",1.0891,null,null,null,null,null,-1.8362100675900416E-4,null,null,null,-846.25065960660527]
[null,594,"2017-04-26",1.0892999999999999,null,null,null,null,null,1.1022321314332515E-3,null,null,null,5079.8363690991146]
[null,595,"2017-04-27",1.0881000000000001,null,null,null,null,null,-4.4931532195720469E-3,null,null,null,-20707.510229299696]
[null,596,"2017-04-28",1.093,null,null,null,null,null,1.3733121865400781E-3,null,null,null,6329.1578900372288]
[null,597,"2017-05-02",1.0914999999999999,null,null,null,null,null,-3.6640103002203556E-4,null,null,null,-1688.6254944873433]
[null,598,"2017-05-03",1.0919000000000001,null,null,null,null,null,-7.3239955667894123E-4,null,null,null,-3375.3959793314702]
[null,599,"2017-05-04",1.0927,null,null,null,null,null,-3.1067276449780264E-3,null,null,null,-14317.916915853146]
[null,600,"2017-05-05",1.0961000000000001,null,null,null,null,null,2.1005533090052934E-3,null,null,null,9680.7802912092448]
[null,601,"2017-05-08",1.0938000000000001,null,null,null,null,null,4.5816995754161191E-3,null,null,null,21115.592144116519]
[null,602,"2017-05-09",1.0888,null,null,null,null,null,5.5121728543127834E-4,null,null,null,2540.3846739333253]
[null,603,"2017-05-10",1.0882000000000001,null,null,null,null,null,2.023733557944149E-3,null,null,null,9326.742557979569]
[null,604,"2017-05-11",1.0860000000000001,null,null,null,null,null,-1.4722122644346305E-3,null,null,null,-6784.9568077681142]
[null,605,"2017-05-12",1.0875999999999999,null,null,null,null,null,-8.7880463051325901E-3,null,null,null,-40501.302730207171]
[null,606,"2017-05-15",1.0972,null,null,null,null,null,-7.8980030178662508E-3,null,null,null,-36399.377072452131]
[null,607,"2017-05-16",1.1059000000000001,null,null,null,null,null,-5.2308921582547661E-3,null,null,null,-24107.513717446967]
[null,608,"2017-05-17",1.1116999999999999,null,null,null,null,null,-1.0788457398101955E-3,null,null,null,-4972.0559485135536]
[null,609,"2017-05-18",1.1129,null,null,null,null,null,-4.4827042969006166E-3,null,null,null,-20659.354477085126]
[null,610,"2017-05-19",1.1178999999999999,null,null,null,null,null,-5.7086944794340119E-3,null,null,null,-26309.552234696719]
[null,611,"2017-05-22",1.1243000000000001,null,null,null,null,null,2.4935447954510174E-3,null,null,null,11491.952719105577]
[null,612,"2017-05-23",1.1214999999999999,null,null,null,null,null,1.9635850650411455E-3,null,null,null,9049.5373367909324]
[null,613,"2017-05-24",1.1193,null,null,null,null,null,-1.874414794350352E-3,null,null,null,-8638.5799974249494]
[null,614,"2017-05-25",1.1214,null,null,null,null,null,1.6064260482736878E-3,null,null,null,7403.5053339243186]
[null,615,"2017-05-26",1.1195999999999999,null,null,null,null,null,7.1479631349375935E-4,null,null,null,3294.268245530146]
[null,616,"2017-05-29",1.1188,null,null,null,null,null,1.3416217745124547E-3,null,null,null,6183.1068877312719]
[null,617,"2017-05-30",1.1173,null,null,null,null,null,-4.2868691175285438E-3,null,null,null,-19756.812591257742]
[null,618,"2017-05-31",1.1221000000000001,null,null,null,null,null,1.7825311990176114E-4,null,null,null,821.51178101197104]
[null,619,"2017-06-01",1.1218999999999999,null,null,null,null,null,1.7828489974124146E-4,null,null,null,821.65824415688621]
[null,620,"2017-06-02",1.1216999999999999,null,null,null,null,null,-2.8487511476024598E-3,null,null,null,-13128.985513502203]
[null,621,"2017-06-05",1.1249,null,null,null,null,null,-7.9975123114586159E-4,null,null,null,-3685.7983671042721]
[null,622,"2017-06-06",1.1257999999999999,null,null,null,null,null,3.6485023787484949E-3,null,null,null,16814.783880607272]
[null,623,"2017-06-07",1.1216999999999999,null,null,null,null,null,-1.0692329273152956E-3,null,null,null,-4927.7535614497447]
[null,624,"2017-06-08",1.1229,null,null,null,null,null,4.7310956357409523E-3,null,null,null,21804.110940652954]
[null,625,"2017-06-09",1.1175999999999999,null,null,null,null,null,-4.0184007280687477E-3,null,null,null,-18519.527404372475]
[null,626,"2017-06-12",1.1221000000000001,null,null,null,null,null,3.5653801964299458E-4,null,null,null,1643.1700251688203]
[null,627,"2017-06-13",1.1216999999999999,null,null,null,null,null,1.2488850865000176E-3,null,null,null,5755.7130683342521]
[null,628,"2017-06-14",1.1203000000000001,null,null,null,null,null,3.3081526884175903E-3,null,null,null,15246.220702444063]
[null,629,"2017-06-15",1.1166,null,null,null,null,null,-8.9553575486388417E-5,null,null,null,-412.72386892503454]
[null,630,"2017-06-16",1.1167,null,null,null,null,null,-2.8614881369013667E-3,null,null,null,-13187.68623509093]
[null,631,"2017-06-19",1.1198999999999999,null,null,null,null,null,3.8470188353139788E-3,null,null,null,17729.682917904207]
[null,632,"2017-06-20",1.1155999999999999,null,null,null,null,null,8.0706635775601497E-4,null,null,null,3719.5114527049454]
[null,633,"2017-06-21",1.1147,null,null,null,null,null,-1.9716801512030162E-3,null,null,null,-9086.8450072202013]
[null,634,"2017-06-22",1.1169,null,null,null,null,null,-3.5807000651135389E-4,null,null,null,-1650.2304640627169]
[null,635,"2017-06-23",1.1173,null,null,null,null,null,-1.2522362995925616E-3,null,null,null,-5771.1577407064588]
[null,636,"2017-06-26",1.1187,null,null,null,null,null,-8.1015355201968248E-3,null,null,null,-37337.393464959387]
[null,637,"2017-06-27",1.1277999999999999,null,null,null,null,null,-8.5640394520238462E-3,null,null,null,-39468.926584658242]
[null,638,"2017-06-28",1.1375,null,null,null,null,null,-3.3350917344488161E-3,null,null,null,-15370.374174181739]
[null,639,"2017-06-29",1.1413,null,null,null,null,null,8.7623220209347716E-5,null,null,null,403.82747708346943]
[null,640,"2017-06-30",1.1412,null,null,null,null,null,3.775080204284052E-3,null,null,null,17398.140710208048]
[null,641,"2017-07-03",1.1369,null,null,null,null,null,1.4083269645729767E-3,null,null,null,6490.5298350522635]
[null,642,"2017-07-04",1.1353,null,null,null,null,null,{"$f":"-LN(D651/D650)","v":2.1162162910450771E-3},null,null,null,{"$f":"$N$8*J650","v":9752.9659801809303}]
[null,{"$f":"B650+1","v":643},"2017-07-05",1.1329,null,null,null,null,null,-4.9308896243513943E-3,null,null,null,-22724.897715713647]
[null,644,"2017-07-06",1.1385000000000001,null,null,null,null,null,-2.3687338355506101E-3,null,null,null,-10916.738809727129]
[null,645,"2017-07-07",1.1412,null,null,null,null,null,2.1930795227855255E-3,null,null,null,10107.204101994628]
[null,646,"2017-07-10",1.1387,null,null,null,null,null,-1.5795019078834011E-3,null,null,null,-7279.4205575320138]
[null,647,"2017-07-11",1.1405000000000001,null,null,null,null,null,-3.8505342053238639E-3,null,null,null,-17745.884137155397]
[null,648,"2017-07-12",1.1449,null,null,null,null,null,2.7989172474852764E-3,null,null,null,12899.316960925942]
[null,649,"2017-07-13",1.1416999999999999,null,null,null,null,null,1.7519271243126764E-4,null,null,null,807.40733900785312]
[null,650,"2017-07-14",1.1415,null,null,null,null,null,-4.108936147786936E-3,null,null,null,-18936.776280231396]
[null,651,"2017-07-17",1.1462000000000001,null,null,null,null,null,-8.0810275967981224E-3,null,null,null,-37242.878986416683]
[null,652,"2017-07-18",1.1555,null,null,null,null,null,1.905752482542356E-3,null,null,null,8783.00540806348]
[null,653,"2017-07-19",1.1533,null,null,null,null,null,4.1706551027400488E-3,null,null,null,19221.219260156082]
[null,654,"2017-07-20",1.1485000000000001,null,null,null,null,null,-1.3577412708482142E-2,null,null,null,-62573.965055012377]
[null,655,"2017-07-21",1.1641999999999999,null,null,null,null,null,-5.1524260478658253E-4,null,null,null,-2374.5888439133601]
[null,656,"2017-07-24",1.1648000000000001,null,null,null,null,null,-3.9413982991486464E-3,null,null,null,-18164.647767150622]
[null,657,"2017-07-25",1.1694,null,null,null,null,null,4.2848638701018342E-3,null,null,null,19747.571045383011]
[null,658,"2017-07-26",1.1644000000000001,null,null,null,null,null,-4.2848638701018004E-3,null,null,null,-19747.571045382854]
[null,659,"2017-07-27",1.1694,null,null,null,null,null,-2.9885177858892868E-3,null,null,null,-13773.125374887779]
[null,660,"2017-07-28",1.1729000000000001,null,null,null,null,null,1.7053206044051491E-4,null,null,null,785.92788036101217]
[null,661,"2017-07-31",1.1727000000000001,null,null,null,null,null,-7.2220884027486623E-3,null,null,null,-33284.302174558099]
[null,662,"2017-08-01",1.1812,null,null,null,null,null,-1.4381796819236271E-3,null,null,null,-6628.1114886709811]
[null,663,"2017-08-02",1.1829000000000001,null,null,null,null,null,-2.6172500059795573E-3,null,null,null,-12062.070582275486]
[null,664,"2017-08-03",1.1859999999999999,null,null,null,null,null,-6.7430885899605547E-4,null,null,null,-3107.6744800388005]
[null,665,"2017-08-04",1.1868000000000001,null,null,null,null,null,6.0004405688700302E-3,null,null,null,27654.116917031308]
[null,666,"2017-08-07",1.1797,null,null,null,null,null,-1.4400070253380432E-3,null,null,null,-6636.5331316903275]
[null,667,"2017-08-08",1.1814,null,null,null,null,null,7.0503583614602303E-3,null,null,null,32492.853182529969]
[null,668,"2017-08-09",1.1731,null,null,null,null,null,-8.5240591621226486E-5,null,null,null,-392.84670179046896]
[null,669,"2017-08-10",1.1732,null,null,null,null,null,-2.808871064121162E-3,null,null,null,-12945.190927322265]
[null,670,"2017-08-11",1.1765000000000001,null,null,null,null,null,-2.7162396803796121E-3,null,null,null,-12518.282421726048]
[null,671,"2017-08-14",1.1797,null,null,null,null,null,4.5027899875455437E-3,null,null,null,20751.923019524456]
[null,672,"2017-08-15",1.1744000000000001,null,null,null,null,null,2.8992942625338707E-3,null,null,null,13361.92261097393]
[null,673,"2017-08-16",1.171,null,null,null,null,null,1.1107789410561199E-3,null,null,null,5119.2258888961451]
[null,674,"2017-08-17",1.1697,null,null,null,null,null,-3.6694157313804337E-3,null,null,null,-16911.166853186176]
[null,675,"2017-08-18",1.1739999999999999,null,null,null,null,null,-1.7871584689490277E-3,null,null,null,-8236.4434215013007]
[null,676,"2017-08-21",1.1760999999999999,null,null,null,null,null,-8.4990656144405975E-4,null,null,null,-3916.9482888740808]
[null,677,"2017-08-22",1.1771,null,null,null,null,null,-2.3759026874384435E-3,null,null,null,-10949.77776178267]
[null,678,"2017-08-23",1.1798999999999999,null,null,null,null,null,-5.9309470071553492E-4,null,null,null,-2733.3843254025824]
[null,679,"2017-08-24",1.1806000000000001,null,null,null,null,null,-1.6939103961906356E-4,null,null,null,-780.66927929013696]
[null,680,"2017-08-25",1.1808000000000001,null,null,null,null,null,-9.8597689162881041E-3,null,null,null,-45440.530450464699]
[null,681,"2017-08-28",1.1924999999999999,null,null,null,null,null,-1.0261634283133023E-2,null,null,null,-47292.599763056496]
[null,682,"2017-08-29",1.2048000000000001,null,null,null,null,null,1.1016636206502015E-2,null,null,null,50772.162842099111]
[null,683,"2017-08-30",1.1916,null,null,null,null,null,7.6661004730390683E-3,null,null,null,35330.612201872696]
[null,684,"2017-08-31",1.1825000000000001,null,null,null,null,null,-8.0017272592068627E-3,null,null,null,-36877.409020980172]
[null,685,"2017-09-01",1.1919999999999999,null,null,null,null,null,1.2591816983776724E-3,null,null,null,5803.1668686753792]
[null,686,"2017-09-04",1.1904999999999999,null,null,null,null,null,1.2607692361355327E-3,null,null,null,5810.4833239026557]
[null,687,"2017-09-05",1.1890000000000001,null,null,null,null,null,-3.4423441909726986E-3,null,null,null,-15864.666541268511]
[null,688,"2017-09-06",1.1931,null,null,null,null,null,-3.3470033755695103E-3,null,null,null,-15425.271129237728]
[null,689,"2017-09-07",1.1971000000000001,null,null,null,null,null,-7.4071330298065285E-3,null,null,null,-34137.113846100139]
[null,690,"2017-09-08",1.206,null,null,null,null,null,5.2375727662484104E-3,null,null,null,24138.302509105291]
[null,691,"2017-09-11",1.1997,null,null,null,null,null,5.3489471452723251E-3,null,null,null,24651.591502428175]
[null,692,"2017-09-12",1.1933,null,null,null,null,null,-3.8474453616751461E-3,null,null,null,-17731.64864187473]
[null,693,"2017-09-13",1.1979,null,null,null,null,null,7.8780159370367489E-3,null,null,null,36307.262991203381]
[null,694,"2017-09-14",1.1884999999999999,null,null,null,null,null,-6.541452376609881E-3,null,null,null,-30147.467799023245]
[null,695,"2017-09-15",1.1962999999999999,null,null,null,null,null,1.2546528349036429E-3,null,null,null,5782.2947812720258]
[null,696,"2017-09-18",1.1948000000000001,null,null,null,null,null,-2.006689636589027E-3,null,null,null,-9248.1925601136645]
[null,697,"2017-09-19",1.1972,null,null,null,null,null,-2.9192230581284806E-3,null,null,null,-13453.768074163434]
[null,698,"2017-09-20",1.2007000000000001,null,null,null,null,null,8.5313331097550266E-3,null,null,null,39318.19348387183]
[null,699,"2017-09-21",1.1904999999999999,null,null,null,null,null,-4.6928771285016293E-3,null,null,null,-21627.974029461169]
[null,700,"2017-09-22",1.1960999999999999,null,null,null,null,null,7.8899183843255047E-3,null,null,null,36362.117574820069]
[null,701,"2017-09-25",1.1867000000000001,null,null,null,null,null,6.7642094385695732E-3,null,null,null,31174.084055750503]
[null,702,"2017-09-26",1.1787000000000001,null,null,null,null,null,3.9102395963577074E-3,null,null,null,18021.047243143446]
[null,703,"2017-09-27",1.1740999999999999,null,null,null,null,null,-3.1463948743043514E-3,null,null,null,-14500.730525116416]
[null,704,"2017-09-28",1.1778,null,null,null,null,null,-2.374492296118622E-3,null,null,null,-10943.277717992643]
[null,705,"2017-09-29",1.1806000000000001,null,null,null,null,null,5.2654049463377985E-3,null,null,null,24266.57215087807]
[null,706,"2017-10-02",1.1744000000000001,null,null,null,null,null,{"$f":"-LN(D715/D714)","v":-7.6605527855719627E-4},null,null,null,{"$f":"$N$8*J714","v":-3530.5044679609346}]
[null,{"$f":"B714+1","v":707},"2017-10-03",1.1753,null,null,null,null,null,-2.8887020937154602E-3,null,null,null,-13313.106682952095]
[null,708,"2017-10-04",1.1787000000000001,null,null,null,null,null,3.825071602438378E-3,null,null,null,17628.53512100811]
[null,709,"2017-10-05",1.1741999999999999,null,null,null,null,null,2.9852041444586364E-3,null,null,null,13757.853858322858]
[null,710,"2017-10-06",1.1707000000000001,null,null,null,null,null,-3.3258036027924041E-3,null,null,null,-15327.56813755507]
[null,711,"2017-10-09",1.1746000000000001,null,null,null,null,null,-4.3325047593775756E-3,null,null,null,-19967.132710387687]
[null,712,"2017-10-10",1.1797,null,null,null,null,null,-2.7934161305901224E-3,null,null,null,-12873.964067576397]
[null,713,"2017-10-11",1.1830000000000001,null,null,null,null,null,-2.195390563435656E-3,null,null,null,-10117.854951312307]
[null,714,"2017-10-12",1.1856,null,null,null,null,null,3.8874383444600755E-3,null,null,null,17915.963544939175]
[null,715,"2017-10-13",1.181,null,null,null,null,null,5.9289376233904697E-4,null,null,null,2732.458264508763]
[null,716,"2017-10-16",1.1802999999999999,null,null,null,null,null,3.7348316056531965E-3,null,null,null,17212.647755230919]
[null,717,"2017-10-17",1.1758999999999999,null,null,null,null,null,8.5077425584304759E-4,null,null,null,3920.947215633284]
[null,718,"2017-10-18",1.1749000000000001,null,null,null,null,null,-7.2086136690667282E-3,null,null,null,-33222.201424389983]
[null,719,"2017-10-19",1.1834,null,null,null,null,null,1.3529513310195629E-3,null,null,null,6235.3212004420948]
[null,720,"2017-10-20",1.1818,null,null,null,null,null,6.6219785235325426E-3,null,null,null,30518.587128732179]
[null,721,"2017-10-23",1.1739999999999999,null,null,null,null,null,-1.7871584689490277E-3,null,null,null,-8236.4434215013007]
[null,722,"2017-10-24",1.1760999999999999,null,null,null,null,null,-2.0385635191949836E-3,null,null,null,-9395.0891198025893]
[null,723,"2017-10-25",1.1785000000000001,null,null,null,null,null,2.7190092373774516E-3,null,null,null,12531.046426659948]
[null,724,"2017-10-26",1.1753,null,null,null,null,null,1.2672487424316656E-2,null,null,null,58403.453019726498]
[null,725,"2017-10-27",1.1605000000000001,null,null,null,null,null,-6.0300643598313307E-4,null,null,null,-2779.0643521930883]
[null,726,"2017-10-30",1.1612,null,null,null,null,null,-2.2365600720947055E-3,null,null,null,-10307.592086912082]
[null,727,"2017-10-31",1.1637999999999999,null,null,null,null,null,2.236560072094624E-3,null,null,null,10307.592086911707]
[null,728,"2017-11-01",1.1612,null,null,null,null,null,-2.8378571739208183E-3,null,null,null,-13078.778663117562]
[null,729,"2017-11-02",1.1645000000000001,null,null,null,null,null,-1.0299546013908406E-3,null,null,null,-4746.7322839363351]
[null,730,"2017-11-03",1.1657,null,null,null,null,null,5.7642005860348627E-3,null,null,null,26565.362177971965]
[null,731,"2017-11-06",1.159,null,null,null,null,null,2.4187986913760998E-3,null,null,null,11147.471763506408]
[null,732,"2017-11-07",1.1561999999999999,null,null,null,null,null,-2.4187986913760803E-3,null,null,null,-11147.471763506319]
[null,733,"2017-11-08",1.159,null,null,null,null,null,-3.4453091789128248E-3,null,null,null,-15878.331225088432]
[null,734,"2017-11-09",1.163,null,null,null,null,null,-2.0615021903094242E-3,null,null,null,-9500.8061393512926]
[null,735,"2017-11-10",1.1654,null,null,null,null,null,-1.7160017202128214E-4,null,null,null,-790.85046599384259]
[null,736,"2017-11-13",1.1656,null,null,null,null,null,-7.606549217972533E-3,null,null,null,-35056.159459400813]
[null,737,"2017-11-14",1.1745000000000001,null,null,null,null,null,-8.0560113449833319E-3,null,null,null,-37127.587060003621]
[null,738,"2017-11-15",1.1839999999999999,null,null,null,null,null,5.8447500255159454E-3,null,null,null,26936.588855654179]
[null,739,"2017-11-16",1.1771,null,null,null,null,null,-2.0368334292948332E-3,null,null,null,-9387.115687214331]
[null,740,"2017-11-17",1.1795,null,null,null,null,null,1.1876485956561775E-3,null,null,null,5473.4936116213976]
[null,741,"2017-11-20",1.1780999999999999,null,null,null,null,null,5.3619431413853991E-3,null,null,null,24711.485903820758]
[null,742,"2017-11-21",1.1718,null,null,null,null,null,-2.6420094628387975E-3,null,null,null,-12176.17902263565]
[null,743,"2017-11-22",1.1749000000000001,null,null,null,null,null,-8.3909463800622176E-3,null,null,null,-38671.195818956083]
[null,744,"2017-11-23",1.1848000000000001,null,null,null,null,null,-2.4446798266055726E-3,null,null,null,-11266.74966174849]
[null,745,"2017-11-24",1.1877,null,null,null,null,null,-6.2948715983582862E-3,null,null,null,-29011.05563178362]
[null,746,"2017-11-27",1.1952,null,null,null,null,null,5.3691404150580969E-3,null,null,null,24744.655842818443]
[null,747,"2017-11-28",1.1888000000000001,null,null,null,null,null,5.1444347064235202E-3,null,null,null,23709.058895030466]
[null,748,"2017-11-29",1.1827000000000001,null,null,null,null,null,-1.858422565623116E-3,null,null,null,-8564.8769154743895]
[null,749,"2017-11-30",1.1849000000000001,null,null,null,null,null,-3.0336249775542615E-3,null,null,null,-13981.010035653122]
[null,750,"2017-12-01",1.1884999999999999,null,null,null,null,null,1.684210924430186E-3,null,null,null,7761.9910209200789]
[null,751,"2017-12-04",1.1865000000000001,null,null,null,null,null,1.5182189151048907E-3,null,null,null,6996.9867882326953]
[null,752,"2017-12-05",1.1847000000000001,null,null,null,null,null,2.5354983157436016E-3,null,null,null,11685.303114286749]
[null,753,"2017-12-06",1.1817,null,null,null,null,null,2.6267862411568244E-3,null,null,null,12106.020048904418]
[null,754,"2017-12-07",1.1786000000000001,null,null,null,null,null,3.7402287737276323E-3,null,null,null,17237.521581617209]
[null,755,"2017-12-08",1.1741999999999999,null,null,null,null,null,-4.5883333110356174E-3,null,null,null,-21146.164915950976]
[null,756,"2017-12-11",1.1796,null,null,null,null,null,2.5464745107655431E-3,null,null,null,11735.888896606742]
[null,757,"2017-12-12",1.1766000000000001,null,null,null,null,null,2.5529756015837297E-3,null,null,null,11765.850350855129]
[null,758,"2017-12-13",1.1736,null,null,null,null,null,-9.2447967700682778E-3,null,null,null,-42606.319955903738]
[null,759,"2017-12-14",1.1845000000000001,null,null,null,null,null,3.2979607922511991E-3,null,null,null,15199.249503420138]
[null,760,"2017-12-15",1.1806000000000001,null,null,null,null,null,9.3216395885941164E-4,null,null,null,4296.0463999721496]
[null,761,"2017-12-18",1.1795,null,null,null,null,null,-2.3710740213379231E-3,null,null,null,-10927.523979687092]
[null,762,"2017-12-19",1.1822999999999999,null,null,null,null,null,-1.8590507297725578E-3,null,null,null,-8567.7719237045985]
[null,763,"2017-12-20",1.1845000000000001,null,null,null,null,null,-1.1812353719091971E-3,null,null,null,-5443.9371086815681]
[null,764,"2017-12-21",1.1859,null,null,null,null,null,5.0607288529469984E-4,null,null,null,2332.3285311889131]
[null,765,"2017-12-22",1.1853,null,null,null,null,null,-3.5371436575577214E-3,null,null,null,-16301.567049243729]
[null,766,"2017-12-27",1.1895,null,null,null,null,null,-3.2733253449691085E-3,null,null,null,-15085.712583651832]
[null,767,"2017-12-28",1.1934,null,null,null,null,null,-4.931677149693765E-3,null,null,null,-22728.527168858476]
[null,768,"2017-12-29",1.1993]

{"sheet":"CalculVAR","index":12,"n_rows":102,"n_cols":12,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
["VAR PARAMETRIQUE ET HISTORIQUE"]
[]
[]
[null,null,"Saisie des devises 4 et 5",null,null,"USD","GBP","CHF"]
[null,null,null,null,"Portefeuille",5500000,-4500000,2800000,null,null,"PORTEFEUILLE"]
[null,null,"Cours FX à la date",null,"2014-01-02"]
[null,null,"Contrevaleur Euro",null,null,null,null,null,null,null,null,"Réponse 1.1"]
[null,null,"Cours FX à la date",null,"2016-12-30",{"$f":"1/Rates!D775","v":0.83794201441260263}]
[null,null,"Contrevaleur Euro",null,null,{"$f":"F5*F8","v":4608681.0792693142}]
[null,null,"RESULTAT sur 3 ans",null,null,null,null,null,null,null,null,"Réponse 1.2"]
[]
[null,null,"RISQUE",null,0.02,null,null,null,null,null,null,"Réponse 1.3"]
[]
[null,null,"STATISTIQUES",null,"moyenne"]
[null,null,"sur les rendements",null,"écart type",null,null,null,null,null,null,"Réponse 2.1"]
[null,null,null,null,"centile 5%"]
[null,null,null,null,"centile 95%",null,null,null,null,null,"alpha","beta"]
[null,null,null,null,"alpha écart type",null,null,null,null,null,{"$f":"NORMSINV(0.95)","v":1.6448536269514715}]
[]
[null,null,null,null,"param",null,null,null,null,null,null,"Réponse 4.0"]
[null,null,null,null,"histo plus",null,null,null,null,null,null,"Réponse 4.1"]
[null,null,null,null,"histo moins",null,null,null,null,null,null,"Réponse 4.2"]
[null,null,null,null,"mc",null,null,null,null,null,null,"Réponse 4.3"]
[null,null,null,null,null,null,null,null,null,null,null,"Réponse 4.4"]
[null,null,null,null,null,1,2,3,"Montant","Dev",null,"Réponse 4.5"]
[null,null,"Matrice de Corrélation",null,null,"USD","GBP","CHF",{"$f":"I4","v":0},{"$f":"J4","v":0},null,"Réponse 4.6"]
[null,null,null,1,"USD"]
[null,null,null,2,"GBP",null,null,null,null,null,null,"Réponse 2.2"]
[null,null,null,3,"CHF"]
[null,null,null,"Montant","SGD"]
[null,null,null,"Dev","THB"]
[null,null,null,null,"déterminant"]
[null,null,"Matrice de Variance Covariance",null,null,"USD","GBP","CHF",{"$f":"I26","v":0},{"$f":"J26","v":0}]
[null,null,null,null,"USD"]
[null,null,null,null,"GBP"]
[null,null,null,null,"CHF"]
[null,null,null,null,"SGD"]
[null,null,null,null,"THB"]
[null,null,null,null,"déterminant"]
[]
[null,null,"Matrice de Cholesky sur Covariance",null,null,"USD","GBP","CHF",{"$f":"I33","v":0},{"$f":"J33","v":0}]
[null,null,null,null,"USD",null,null,null,null,null,null,"Réponse 2.3"]
[null,null,null,null,"GBP"]
[null,null,null,null,"CHF"]
[null,null,null,null,"SGD"]
[null,null,null,null,"THB"]
[null,null,null,null,"déterminant",null,null,null,null,null,null,"Réponses 2.4"]
[]
[null,null,null,null,"VALEUR PROPRES"]
[]
[null,null,null,null,null,1,2,3,4,5]
[null,null,null,null,"VECTEURS PROPRES"]
[null,null,null,null,null,null,null,null,null,null,null,"Réponses 2.5"]
[]
[]
[]
[]
[]
[null,null,null,null,"Component","Pos Euro",null,null,"VAR MARGINALE",null,"VAR MARGINALE"]
[null,null,null,null,"Gradient",null,"Component",null,"CALCUL",null,"SIMULATIONS"]
[null,null,"Réponse 6.1"]
[null,null,"Réponse 6.2"]
[null,null,"Réponse 6.3"]
[null,null,"Réponse 6.4"]
[]
[]
[null,null,null,null,"Tableau des positions simulées: +1000 sur chaque position"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Réponse 7.1",null,"ACP","Projections","VP","Racine(VP)",null,"Var Facteur",null,"Var par Facteurs"]
[null,null,"Réponse 7.2"]
[null,null,"Réponse 7.3"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Déterminants",null,"produit des VP"]
[null,null,null,null,null,null,null,null,"determinant de la VCV"]
[null,null,null,null,null,null,null,null,"determinant de la matrice diagonale"]
[null,null,null,null,"Matrice diagonale"]
[null,null,null,null,null,"USD","GBP","CHF",{"$f":"I41","v":0},{"$f":"J41","v":0}]
[null,null,null,null,"USD"]
[null,null,null,null,"GBP"]
[null,null,null,null,"CHF"]
[null,null,null,null,"SGD"]
[null,null,null,null,"THB"]
[]
[null,null,null,null,"Matrice Racine Carrée"]
[null,null,null,null,null,"USD","GBP","CHF",{"$f":"I89","v":0},{"$f":"J89","v":0}]
[null,null,null,null,"USD"]
[null,null,null,null,"GBP"]
[null,null,null,null,"CHF"]
[null,null,null,null,"SGD"]
[null,null,null,null,"THB"]

{"sheet":"MonteCarlo","index":13,"n_rows":2017,"n_cols":30,"rows_kept":2017,"cut":false,"hidden":false,"merged":[]}
["QUASI MONTE CARLO",null,null,null,null,null,null,null,null,null,null,null,"MONTE CARLO CHOLESKY",null,null,null,null,null,null,null,null,"MONTE CARLO RACINE CARREE"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CalculVAR!F5","v":5500000},{"$f":"CalculVAR!G5","v":-4500000},{"$f":"CalculVAR!H5","v":2800000},null,null,null,null,null,null,{"$f":"M3","v":5500000},{"$f":"N3","v":-4500000},2800000]
[]
[]
[]
[]
[]
[null,3,5,7,11,13]
[null,"U1","U2","U3","U4","U5",null,"N1","N2","N3","N4","N5","V1","V2","V3","V4","V5","PORTEFEUILLE",null,null,null,"V1","V2","V3","V4","V5","PORTEFEUILLE"]
[1,{"$f":"halton(B$9,$A11)","v":0.33333333333333331},{"$f":"halton(C$9,$A11)","v":0.2}]
[2,{"$f":"halton(B$9,$A12)","v":0.66666666666666663},{"$f":"halton(C$9,$A12)","v":0.4}]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[195]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]
[251]
[252]
[253]
[254]
[255]
[256]
[257]
[258]
[259]
[260]
[261]
[262]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[270]
[271]
[272]
[273]
[274]
[275]
[276]
[277]
[278]
[279]
[280]
[281]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]
[300]
[301]
[302]
[303]
[304]
[305]
[306]
[307]
[308]
[309]
[310]
[311]
[312]
[313]
[314]
[315]
[316]
[317]
[318]
[319]
[320]
[321]
[322]
[323]
[324]
[325]
[326]
[327]
[328]
[329]
[330]
[331]
[332]
[333]
[334]
[335]
[336]
[337]
[338]
[339]
[340]
[341]
[342]
[343]
[344]
[345]
[346]
[347]
[348]
[349]
[350]
[351]
[352]
[353]
[354]
[355]
[356]
[357]
[358]
[359]
[360]
[361]
[362]
[363]
[364]
[365]
[366]
[367]
[368]
[369]
[370]
[371]
[372]
[373]
[374]
[375]
[376]
[377]
[378]
[379]
[380]
[381]
[382]
[383]
[384]
[385]
[386]
[387]
[388]
[389]
[390]
[391]
[392]
[393]
[394]
[395]
[396]
[397]
[398]
[399]
[400]
[401]
[402]
[403]
[404]
[405]
[406]
[407]
[408]
[409]
[410]
[411]
[412]
[413]
[414]
[415]
[416]
[417]
[418]
[419]
[420]
[421]
[422]
[423]
[424]
[425]
[426]
[427]
[428]
[429]
[430]
[431]
[432]
[433]
[434]
[435]
[436]
[437]
[438]
[439]
[440]
[441]
[442]
[443]
[444]
[445]
[446]
[447]
[448]
[449]
[450]
[451]
[452]
[453]
[454]
[455]
[456]
[457]
[458]
[459]
[460]
[461]
[462]
[463]
[464]
[465]
[466]
[467]
[468]
[469]
[470]
[471]
[472]
[473]
[474]
[475]
[476]
[477]
[478]
[479]
[480]
[481]
[482]
[483]
[484]
[485]
[486]
[487]
[488]
[489]
[490]
[491]
[492]
[493]
[494]
[495]
[496]
[497]
[498]
[499]
[500]
[501]
[502]
[503]
[504]
[505]
[506]
[507]
[508]
[509]
[510]
[511]
[512]
[513]
[514]
[515]
[516]
[517]
[518]
[519]
[520]
[521]
[522]
[523]
[524]
[525]
[526]
[527]
[528]
[529]
[530]
[531]
[532]
[533]
[534]
[535]
[536]
[537]
[538]
[539]
[540]
[541]
[542]
[543]
[544]
[545]
[546]
[547]
[548]
[549]
[550]
[551]
[552]
[553]
[554]
[555]
[556]
[557]
[558]
[559]
[560]
[561]
[562]
[563]
[564]
[565]
[566]
[567]
[568]
[569]
[570]
[571]
[572]
[573]
[574]
[575]
[576]
[577]
[578]
[579]
[580]
[581]
[582]
[583]
[584]
[585]
[586]
[587]
[588]
[589]
[590]
[591]
[592]
[593]
[594]
[595]
[596]
[597]
[598]
[599]
[600]
[601]
[602]
[603]
[604]
[605]
[606]
[607]
[608]
[609]
[610]
[611]
[612]
[613]
[614]
[615]
[616]
[617]
[618]
[619]
[620]
[621]
[622]
[623]
[624]
[625]
[626]
[627]
[628]
[629]
[630]
[631]
[632]
[633]
[634]
[635]
[636]
[637]
[638]
[639]
[640]
[641]
[642]
[643]
[644]
[645]
[646]
[647]
[648]
[649]
[650]
[651]
[652]
[653]
[654]
[655]
[656]
[657]
[658]
[659]
[660]
[661]
[662]
[663]
[664]
[665]
[666]
[667]
[668]
[669]
[670]
[671]
[672]
[673]
[674]
[675]
[676]
[677]
[678]
[679]
[680]
[681]
[682]
[683]
[684]
[685]
[686]
[687]
[688]
[689]
[690]
[691]
[692]
[693]
[694]
[695]
[696]
[697]
[698]
[699]
[700]
[701]
[702]
[703]
[704]
[705]
[706]
[707]
[708]
[709]
[710]
[711]
[712]
[713]
[714]
[715]
[716]
[717]
[718]
[719]
[720]
[721]
[722]
[723]
[724]
[725]
[726]
[727]
[728]
[729]
[730]
[731]
[732]
[733]
[734]
[735]
[736]
[737]
[738]
[739]
[740]
[741]
[742]
[743]
[744]
[745]
[746]
[747]
[748]
[749]
[750]
[751]
[752]
[753]
[754]
[755]
[756]
[757]
[758]
[759]
[760]
[761]
[762]
[763]
[764]
[765]
[766]
[767]
[768]
[769]
[770]
[771]
[772]
[773]
[774]
[775]
[776]
[777]
[778]
[779]
[780]
[781]
[782]
[783]
[784]
[785]
[786]
[787]
[788]
[789]
[790]
[791]
[792]
[793]
[794]
[795]
[796]
[797]
[798]
[799]
[800]
[801]
[802]
[803]
[804]
[805]
[806]
[807]
[808]
[809]
[810]
[811]
[812]
[813]
[814]
[815]
[816]
[817]
[818]
[819]
[820]
[821]
[822]
[823]
[824]
[825]
[826]
[827]
[828]
[829]
[830]
[831]
[832]
[833]
[834]
[835]
[836]
[837]
[838]
[839]
[840]
[841]
[842]
[843]
[844]
[845]
[846]
[847]
[848]
[849]
[850]
[851]
[852]
[853]
[854]
[855]
[856]
[857]
[858]
[859]
[860]
[861]
[862]
[863]
[864]
[865]
[866]
[867]
[868]
[869]
[870]
[871]
[872]
[873]
[874]
[875]
[876]
[877]
[878]
[879]
[880]
[881]
[882]
[883]
[884]
[885]
[886]
[887]
[888]
[889]
[890]
[891]
[892]
[893]
[894]
[895]
[896]
[897]
[898]
[899]
[900]
[901]
[902]
[903]
[904]
[905]
[906]
[907]
[908]
[909]
[910]
[911]
[912]
[913]
[914]
[915]
[916]
[917]
[918]
[919]
[920]
[921]
[922]
[923]
[924]
[925]
[926]
[927]
[928]
[929]
[930]
[931]
[932]
[933]
[934]
[935]
[936]
[937]
[938]
[939]
[940]
[941]
[942]
[943]
[944]
[945]
[946]
[947]
[948]
[949]
[950]
[951]
[952]
[953]
[954]
[955]
[956]
[957]
[958]
[959]
[960]
[961]
[962]
[963]
[964]
[965]
[966]
[967]
[968]
[969]
[970]
[971]
[972]
[973]
[974]
[975]
[976]
[977]
[978]
[979]
[980]
[981]
[982]
[983]
[984]
[985]
[986]
[987]
[988]
[989]
[990]
[991]
[992]
[993]
[994]
[995]
[996]
[997]
[998]
[999]
[1000]
[1001]
[1002]
[1003]
[1004]
[1005]
[1006]
[1007]
[1008]
[1009]
[1010]
[1011]
[1012]
[1013]
[1014]
[1015]
[1016]
[1017]
[1018]
[1019]
[1020]
[1021]
[1022]
[1023]
[1024]
[1025]
[1026]
[1027]
[1028]
[1029]
[1030]
[1031]
[1032]
[1033]
[1034]
[1035]
[1036]
[1037]
[1038]
[1039]
[1040]
[1041]
[1042]
[1043]
[1044]
[1045]
[1046]
[1047]
[1048]
[1049]
[1050]
[1051]
[1052]
[1053]
[1054]
[1055]
[1056]
[1057]
[1058]
[1059]
[1060]
[1061]
[1062]
[1063]
[1064]
[1065]
[1066]
[1067]
[1068]
[1069]
[1070]
[1071]
[1072]
[1073]
[1074]
[1075]
[1076]
[1077]
[1078]
[1079]
[1080]
[1081]
[1082]
[1083]
[1084]
[1085]
[1086]
[1087]
[1088]
[1089]
[1090]
[1091]
[1092]
[1093]
[1094]
[1095]
[1096]
[1097]
[1098]
[1099]
[1100]
[1101]
[1102]
[1103]
[1104]
[1105]
[1106]
[1107]
[1108]
[1109]
[1110]
[1111]
[1112]
[1113]
[1114]
[1115]
[1116]
[1117]
[1118]
[1119]
[1120]
[1121]
[1122]
[1123]
[1124]
[1125]
[1126]
[1127]
[1128]
[1129]
[1130]
[1131]
[1132]
[1133]
[1134]
[1135]
[1136]
[1137]
[1138]
[1139]
[1140]
[1141]
[1142]
[1143]
[1144]
[1145]
[1146]
[1147]
[1148]
[1149]
[1150]
[1151]
[1152]
[1153]
[1154]
[1155]
[1156]
[1157]
[1158]
[1159]
[1160]
[1161]
[1162]
[1163]
[1164]
[1165]
[1166]
[1167]
[1168]
[1169]
[1170]
[1171]
[1172]
[1173]
[1174]
[1175]
[1176]
[1177]
[1178]
[1179]
[1180]
[1181]
[1182]
[1183]
[1184]
[1185]
[1186]
[1187]
[1188]
[1189]
[1190]
[1191]
[1192]
[1193]
[1194]
[1195]
[1196]
[1197]
[1198]
[1199]
[1200]
[1201]
[1202]
[1203]
[1204]
[1205]
[1206]
[1207]
[1208]
[1209]
[1210]
[1211]
[1212]
[1213]
[1214]
[1215]
[1216]
[1217]
[1218]
[1219]
[1220]
[1221]
[1222]
[1223]
[1224]
[1225]
[1226]
[1227]
[1228]
[1229]
[1230]
[1231]
[1232]
[1233]
[1234]
[1235]
[1236]
[1237]
[1238]
[1239]
[1240]
[1241]
[1242]
[1243]
[1244]
[1245]
[1246]
[1247]
[1248]
[1249]
[1250]
[1251]
[1252]
[1253]
[1254]
[1255]
[1256]
[1257]
[1258]
[1259]
[1260]
[1261]
[1262]
[1263]
[1264]
[1265]
[1266]
[1267]
[1268]
[1269]
[1270]
[1271]
[1272]
[1273]
[1274]
[1275]
[1276]
[1277]
[1278]
[1279]
[1280]
[1281]
[1282]
[1283]
[1284]
[1285]
[1286]
[1287]
[1288]
[1289]
[1290]
[1291]
[1292]
[1293]
[1294]
[1295]
[1296]
[1297]
[1298]
[1299]
[1300]
[1301]
[1302]
[1303]
[1304]
[1305]
[1306]
[1307]
[1308]
[1309]
[1310]
[1311]
[1312]
[1313]
[1314]
[1315]
[1316]
[1317]
[1318]
[1319]
[1320]
[1321]
[1322]
[1323]
[1324]
[1325]
[1326]
[1327]
[1328]
[1329]
[1330]
[1331]
[1332]
[1333]
[1334]
[1335]
[1336]
[1337]
[1338]
[1339]
[1340]
[1341]
[1342]
[1343]
[1344]
[1345]
[1346]
[1347]
[1348]
[1349]
[1350]
[1351]
[1352]
[1353]
[1354]
[1355]
[1356]
[1357]
[1358]
[1359]
[1360]
[1361]
[1362]
[1363]
[1364]
[1365]
[1366]
[1367]
[1368]
[1369]
[1370]
[1371]
[1372]
[1373]
[1374]
[1375]
[1376]
[1377]
[1378]
[1379]
[1380]
[1381]
[1382]
[1383]
[1384]
[1385]
[1386]
[1387]
[1388]
[1389]
[1390]
[1391]
[1392]
[1393]
[1394]
[1395]
[1396]
[1397]
[1398]
[1399]
[1400]
[1401]
[1402]
[1403]
[1404]
[1405]
[1406]
[1407]
[1408]
[1409]
[1410]
[1411]
[1412]
[1413]
[1414]
[1415]
[1416]
[1417]
[1418]
[1419]
[1420]
[1421]
[1422]
[1423]
[1424]
[1425]
[1426]
[1427]
[1428]
[1429]
[1430]
[1431]
[1432]
[1433]
[1434]
[1435]
[1436]
[1437]
[1438]
[1439]
[1440]
[1441]
[1442]
[1443]
[1444]
[1445]
[1446]
[1447]
[1448]
[1449]
[1450]
[1451]
[1452]
[1453]
[1454]
[1455]
[1456]
[1457]
[1458]
[1459]
[1460]
[1461]
[1462]
[1463]
[1464]
[1465]
[1466]
[1467]
[1468]
[1469]
[1470]
[1471]
[1472]
[1473]
[1474]
[1475]
[1476]
[1477]
[1478]
[1479]
[1480]
[1481]
[1482]
[1483]
[1484]
[1485]
[1486]
[1487]
[1488]
[1489]
[1490]
[1491]
[1492]
[1493]
[1494]
[1495]
[1496]
[1497]
[1498]
[1499]
[1500]
[1501]
[1502]
[1503]
[1504]
[1505]
[1506]
[1507]
[1508]
[1509]
[1510]
[1511]
[1512]
[1513]
[1514]
[1515]
[1516]
[1517]
[1518]
[1519]
[1520]
[1521]
[1522]
[1523]
[1524]
[1525]
[1526]
[1527]
[1528]
[1529]
[1530]
[1531]
[1532]
[1533]
[1534]
[1535]
[1536]
[1537]
[1538]
[1539]
[1540]
[1541]
[1542]
[1543]
[1544]
[1545]
[1546]
[1547]
[1548]
[1549]
[1550]
[1551]
[1552]
[1553]
[1554]
[1555]
[1556]
[1557]
[1558]
[1559]
[1560]
[1561]
[1562]
[1563]
[1564]
[1565]
[1566]
[1567]
[1568]
[1569]
[1570]
[1571]
[1572]
[1573]
[1574]
[1575]
[1576]
[1577]
[1578]
[1579]
[1580]
[1581]
[1582]
[1583]
[1584]
[1585]
[1586]
[1587]
[1588]
[1589]
[1590]
[1591]
[1592]
[1593]
[1594]
[1595]
[1596]
[1597]
[1598]
[1599]
[1600]
[1601]
[1602]
[1603]
[1604]
[1605]
[1606]
[1607]
[1608]
[1609]
[1610]
[1611]
[1612]
[1613]
[1614]
[1615]
[1616]
[1617]
[1618]
[1619]
[1620]
[1621]
[1622]
[1623]
[1624]
[1625]
[1626]
[1627]
[1628]
[1629]
[1630]
[1631]
[1632]
[1633]
[1634]
[1635]
[1636]
[1637]
[1638]
[1639]
[1640]
[1641]
[1642]
[1643]
[1644]
[1645]
[1646]
[1647]
[1648]
[1649]
[1650]
[1651]
[1652]
[1653]
[1654]
[1655]
[1656]
[1657]
[1658]
[1659]
[1660]
[1661]
[1662]
[1663]
[1664]
[1665]
[1666]
[1667]
[1668]
[1669]
[1670]
[1671]
[1672]
[1673]
[1674]
[1675]
[1676]
[1677]
[1678]
[1679]
[1680]
[1681]
[1682]
[1683]
[1684]
[1685]
[1686]
[1687]
[1688]
[1689]
[1690]
[1691]
[1692]
[1693]
[1694]
[1695]
[1696]
[1697]
[1698]
[1699]
[1700]
[1701]
[1702]
[1703]
[1704]
[1705]
[1706]
[1707]
[1708]
[1709]
[1710]
[1711]
[1712]
[1713]
[1714]
[1715]
[1716]
[1717]
[1718]
[1719]
[1720]
[1721]
[1722]
[1723]
[1724]
[1725]
[1726]
[1727]
[1728]
[1729]
[1730]
[1731]
[1732]
[1733]
[1734]
[1735]
[1736]
[1737]
[1738]
[1739]
[1740]
[1741]
[1742]
[1743]
[1744]
[1745]
[1746]
[1747]
[1748]
[1749]
[1750]
[1751]
[1752]
[1753]
[1754]
[1755]
[1756]
[1757]
[1758]
[1759]
[1760]
[1761]
[1762]
[1763]
[1764]
[1765]
[1766]
[1767]
[1768]
[1769]
[1770]
[1771]
[1772]
[1773]
[1774]
[1775]
[1776]
[1777]
[1778]
[1779]
[1780]
[1781]
[1782]
[1783]
[1784]
[1785]
[1786]
[1787]
[1788]
[1789]
[1790]
[1791]
[1792]
[1793]
[1794]
[1795]
[1796]
[1797]
[1798]
[1799]
[1800]
[1801]
[1802]
[1803]
[1804]
[1805]
[1806]
[1807]
[1808]
[1809]
[1810]
[1811]
[1812]
[1813]
[1814]
[1815]
[1816]
[1817]
[1818]
[1819]
[1820]
[1821]
[1822]
[1823]
[1824]
[1825]
[1826]
[1827]
[1828]
[1829]
[1830]
[1831]
[1832]
[1833]
[1834]
[1835]
[1836]
[1837]
[1838]
[1839]
[1840]
[1841]
[1842]
[1843]
[1844]
[1845]
[1846]
[1847]
[1848]
[1849]
[1850]
[1851]
[1852]
[1853]
[1854]
[1855]
[1856]
[1857]
[1858]
[1859]
[1860]
[1861]
[1862]
[1863]
[1864]
[1865]
[1866]
[1867]
[1868]
[1869]
[1870]
[1871]
[1872]
[1873]
[1874]
[1875]
[1876]
[1877]
[1878]
[1879]
[1880]
[1881]
[1882]
[1883]
[1884]
[1885]
[1886]
[1887]
[1888]
[1889]
[1890]
[1891]
[1892]
[1893]
[1894]
[1895]
[1896]
[1897]
[1898]
[1899]
[1900]
[1901]
[1902]
[1903]
[1904]
[1905]
[1906]
[1907]
[1908]
[1909]
[1910]
[1911]
[1912]
[1913]
[1914]
[1915]
[1916]
[1917]
[1918]
[1919]
[1920]
[1921]
[1922]
[1923]
[1924]
[1925]
[1926]
[1927]
[1928]
[1929]
[1930]
[1931]
[1932]
[1933]
[1934]
[1935]
[1936]
[1937]
[1938]
[1939]
[1940]
[1941]
[1942]
[1943]
[1944]
[1945]
[1946]
[1947]
[1948]
[1949]
[1950]
[1951]
[1952]
[1953]
[1954]
[1955]
[1956]
[1957]
[1958]
[1959]
[1960]
[1961]
[1962]
[1963]
[1964]
[1965]
[1966]
[1967]
[1968]
[1969]
[1970]
[1971]
[1972]
[1973]
[1974]
[1975]
[1976]
[1977]
[1978]
[1979]
[1980]
[1981]
[1982]
[1983]
[1984]
[1985]
[1986]
[1987]
[1988]
[1989]
[1990]
[1991]
[1992]
[1993]
[1994]
[1995]
[1996]
[1997]
[1998]
[1999]
[2000]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Réponse 7.0",null,null,null,null,null,null,null,null,"Réponse 8.0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Réponse 7.1",null,null,null,null,null,null,null,null,"Réponse 8.1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Réponse 7.2",null,null,null,null,null,null,null,null,"Réponse 8.2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Réponse 7.3",null,null,null,null,null,null,null,null,"Réponse 8.3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"anthétiques",null,"Réponse 7.4",null,null,null,null,null,null,null,null,"Réponse 8.4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Réponse 7.5",null,null,null,null,null,null,null,null,"Réponse 8.5"]

{"sheet":"Réponses","index":14,"n_rows":124,"n_cols":4,"rows_kept":124,"cut":false,"hidden":false,"merged":[]}
[null,null,"Numéro/Nom/ Prénom: /….. /  ……………………/………………"]
[null,null,null," "]
[1,1,"Contrevaleur Euro du Portefeuille au 2 janvier 14"]
[1,2,"Résultat en euro entre le 2 1 2013 et le 30 12 2016"]
[1,3,"Risque Forfaitaire 2% au 30 12 2016"]
[2,1,"Ecart type sur la devise 4"]
[2,2,"Corrélation entre devise 4 et devise 5"]
[2,3,"Trace de la matrice de Cholesky sur VCV"]
[2,4,"Valeurs Propres VCV"]
[]
[]
[]
[]
[]
[2,5,"Vecteur Propre 01"]
[]
[]
[]
[]
[]
[null,null,"VAR HISTORIQUE"]
[3,1,"VAR sur GBP"]
[3,2,"VAR sur la devise 4"]
[3,3,"VAR sur le portefeuille dev4+dev5 sans correlation"]
[3,4,"VAR sur le portefeuille dev4+dev5 avec correlation"]
[3,5,"VAR sur le portefeuille avec corrélations nulles"]
[3,6,"VAR sur le portefeuille"]
[3,7,"ES sur le portefeuille"]
[null,null,"VAR PARAMETRIQUE"]
[4,1,"VAR sur GBP"]
[4,2,"VAR sur la devise 4"]
[4,3,"VAR sur le portefeuille dev4+dev5 sans correlation"]
[4,4,"VAR sur le portefeuille dev4+dev5 avec correlation"]
[4,5,"VAR sur le portefeuille avec corrélations nulles"]
[4,6,"VAR sur le portefeuille"]
[4,7,"ES sur le portefeuille"]
[null,null,"VARComponent sur le portefeuille"]
[null,null,"Gradient"]
[5,1,"USD"]
[5,2,"GBP"]
[5,3,"CHF"]
[5,4,"DEV 4"]
[5,5,"DEV 5"]
[null,null,"VAR Component"]
[5,6,"USD"]
[5,7,"GBP"]
[5,8,"CHF"]
[5,9,"DEV 4"]
[5,10,"DEV 5"]
[null,null,"VAR Marginale"]
[5,11,"USD"]
[5,12,"GBP"]
[5,13,"CHF"]
[5,14,"DEV 4"]
[5,15,"DEV 5"]
[null,null,"Par Simulations"]
[5,16,"USD"]
[5,17,"GBP"]
[5,18,"CHF"]
[5,19,"DEV 4"]
[5,20,"DEV 5"]
[null,null,"Projection du Portefeuille"]
[6,1,"Facteur 01"]
[6,2,"Facteur 02"]
[6,3,"Facteur 03"]
[6,4,"Facteur 04"]
[6,5,"Facteur 05"]
[null,null,"VAR sur chaque Axe de projection"]
[6,6,"Facteur 01"]
[6,7,"Facteur 02"]
[6,8,"Facteur 03"]
[6,9,"Facteur 04"]
[6,10,"Facteur 05"]
[null,null,"VAR PROGRESSIVE"]
[6,11,"Facteur 01"]
[6,12,"Facteur 02"]
[6,13,"Facteur 03"]
[6,14,"Facteur 04"]
[6,15,"Facteur 05"]
[null,null,"Cholesky"]
[7,1,"VAR Monte Carlo sur USD"]
[7,2,"VAR Monte Carlo sur les devise 4"]
[7,3,"VAR Monte Carlo sur les devises 4 et 5"]
[7,4,"VAR Monte Carlo sur le Portefeuille"]
[7,5,"ES Monte Carlo sur le Portefeuille"]
[7,6,"VAR Antithétique"]
[null,null,"Racine Carrée"]
[8,1,"VAR Monte Carlo sur USD"]
[8,2,"VAR Monte Carlo sur les devise 4"]
[8,3,"VAR Monte Carlo sur les devises 4 et 5"]
[8,4,"VAR Monte Carlo sur le Portefeuille"]
[8,5,"ES Monte Carlo sur le Portefeuille"]
[8,6,"VAR Antithétique"]
[null,null,"VAR MINIMALE"]
[null,null,"Portefeuille"]
[9,1,"USD"]
[9,2,"GBP"]
[9,3,"CHF"]
[9,4,"DEV 4"]
[9,5,"DEV 5"]
[null,null,"Gradient"]
[9,6,"USD"]
[9,7,"GBP"]
[9,8,"CHF"]
[9,9,"DEV 4"]
[9,10,"DEV 5"]
[null,null,"VARC"]
[9,11,"USD"]
[9,12,"GBP"]
[9,13,"CHF"]
[9,14,"DEV 4"]
[9,15,"DEV 5"]
[null,null,"Projections"]
[9,16,"USD"]
[9,17,"GBP"]
[9,18,"CHF"]
[9,19,"DEV 4"]
[9,20,"DEV 5"]
[null,null,"VAR ACP"]
[9,21,"USD"]
[9,22,"GBP"]
[9,23,"CHF"]
[9,24,"DEV 4"]
[9,25,"DEV 5"]