{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Garman Kohlhagen","VaR","Result test"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Garman Kohlhagen","index":0,"n_rows":190,"n_cols":16,"rows_kept":190,"cut":false,"hidden":false,"merged":[]}
["Calculating Implied Volatility "]
["Reversed Garman Kohlhagen formula"]
[]
["Expiration Date","Implied volatility","Option price"," Price from formula","Today Date","Networkdays","Annualised time until expiration","Strike rate","Spot rate","Annualised EUR  Risk-free rate","Annualised USD Risk-free rate"]
["2015-04-17",0.01,1.9,{"$f":"GarmanKohlhagen(\"Call\", I5, H5, G5, K5, J5, B5)","v":3.0593159567706181},"2015-03-27",{"$f":"NETWORKDAYS(E5, A5)","v":16},{"$f":"F5/250","v":6.4000000000000001E-2},105.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4,null,null,"Total number of option",186]
["2015-04-17",0.01,1.26,1.5593447567356833,"2015-03-27",16,6.4000000000000001E-2,107,108.56,3.8999999999999999E-4,2.9999999999999997E-4,null,null,"Total call",81]
["2015-04-17",6.3876269552431336E-2,1.35,1.3505288715024193,"2015-03-27",16,6.4000000000000001E-2,107.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4,null,null,"Total put",105]
["2015-04-17",4.4951009611921409E-2,0.82,0.82073446025516716,"2015-03-27",16,6.4000000000000001E-2,108,108.56,3.8999999999999999E-4,2.9999999999999997E-4,null,null,"Total error",{"$f":"O5-O11","v":23}]
["2015-04-17",0.17881060039187383,1.75,1.7504434672481466,"2015-03-27",16,6.4000000000000001E-2,109,108.56,3.8999999999999999E-4,2.9999999999999997E-4,null,null,"Error in Call",5,{"$f":"O9/O6","v":6.1728395061728392E-2}]
["2015-04-17",8.1141445814316759E-2,0.5,0.50024260301711365,"2015-03-27",16,6.4000000000000001E-2,109.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4,null,null,"Error in Put",18,{"$f":"O10/O7","v":0.17142857142857143}]
["2015-04-17",8.19404198196651E-2,0.36,0.36021443869273995,"2015-03-27",16,6.4000000000000001E-2,110,108.56,3.8999999999999999E-4,2.9999999999999997E-4,null,null,"Total implied volatility outtake",163]
["2015-04-17",0.17438457206649099,1.1100000000000001,1.1105864811041073,"2015-03-27",16,6.4000000000000001E-2,110.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4,null,null,"Outtakes from call",76]
["2015-04-17",0.1480023810761186,0.7,0.70020278420341597,"2015-03-27",16,6.4000000000000001E-2,111,108.56,3.8999999999999999E-4,2.9999999999999997E-4,null,null,"Outtakes from put",86]
["2015-04-17",9.2669810740524328E-2,0.11,0.11015914760736223,"2015-03-27",16,6.4000000000000001E-2,112,108.56,3.8999999999999999E-4,2.9999999999999997E-4,null,null,"IV Mean",{"$f":"AVERAGE(B5:B167)","v":0.12611646050778372}]
["2015-04-17",0.15800436667314582,0.45,0.450111517487084,"2015-03-27",16,6.4000000000000001E-2,112.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4,null,null,"IV Max",{"$f":"MAX(B8:B167)","v":0.47529293556635832}]
["2015-04-17",0.15560514953325985,0.35,0.35063968526552713,"2015-03-27",16,6.4000000000000001E-2,113,108.56,3.8999999999999999E-4,2.9999999999999997E-4,null,null,"IV Min",{"$f":"MIN(B9:B167)","v":1E-3}]
["2015-04-17",0.15843856809161683,0.24,0.24002101857289482,"2015-03-27",16,6.4000000000000001E-2,114,108.56,3.8999999999999999E-4,2.9999999999999997E-4,null,null,"IV Mode",{"$f":"MODE(B8:B167)","v":0.01}]
["2015-04-17",0.15843856809161683,0.24,0.24002101857289482,"2015-03-27",16,6.4000000000000001E-2,114,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-04-17",0.21323878509432695,0.44,0.44000677140053668,"2015-03-27",16,6.4000000000000001E-2,115,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-04-17",0.21333064119387068,0.44,0.44059205648488309,"2015-03-27",16,6.4000000000000001E-2,115,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-04-17",0.19071167273920631,0.21,0.21010564406227417,"2015-03-27",16,6.4000000000000001E-2,116,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-04-17",0.3700266431029412,1.37,1.3701256686838548,"2015-03-27",16,6.4000000000000001E-2,116.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-04-17",0.3606330350171435,1.19,1.1907402688769118,"2015-03-27",16,6.4000000000000001E-2,117,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-04-17",0.35195299237735161,1.03,1.0301059275995428,"2015-03-27",16,6.4000000000000001E-2,117.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-05-15",0.13254605281613904,3.34,3.3409843193014837,"2015-03-27",36,0.14399999999999999,106.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-05-15",0.14842718637918279,3.28,3.2799996407878851,"2015-03-27",36,0.14399999999999999,107,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-05-15",0.16622964291544903,3.28,3.2799998690817915,"2015-03-27",36,0.14399999999999999,107.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-05-15",0.12707759244095654,2.65,2.6499996626575921,"2015-03-27",36,0.14399999999999999,107.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-05-15",6.7031010852303854E-2,1.1299999999999999,1.1307874082026714,"2015-03-27",36,0.14399999999999999,108.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-05-15",0.15211225332687142,2.29,2.2899999788636407,"2015-03-27",36,0.14399999999999999,109,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-05-15",0.15413884986398238,2.1,2.1006745237725895,"2015-03-27",36,0.14399999999999999,109.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-05-15",0.10180571752451818,1.06,1.0605823669700314,"2015-03-27",36,0.14399999999999999,110,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-05-15",0.10768100891607998,0.98,0.97999886278672221,"2015-03-27",36,0.14399999999999999,110.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-05-15",0.19538631817114258,2.17,2.1705263314448118,"2015-03-27",36,0.14399999999999999,111,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-05-15",8.7356939774557385E-2,0.34,0.33999552069749939,"2015-03-27",36,0.14399999999999999,112,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-05-15",0.19682481455516534,1.69,1.6900462358269621,"2015-03-27",36,0.14399999999999999,112.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-05-15",0.10792664645280434,0.32,{"$f":"GarmanKohlhagen(\"Call\", I37, H37, G37, K37, J37, B37)","v":0.32008240035506041},"2015-03-27",{"$f":"NETWORKDAYS(E37, A37)","v":36},{"$f":"F37/250","v":0.14399999999999999},113.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-05-15",0.13304483762422556,0.25,0.25071165596330047,"2015-03-27",36,0.14399999999999999,116,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-05-15",0.156420966761629,0.33,0.33019557611082284,"2015-03-27",36,0.14399999999999999,117,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-05-15",0.12818386669732068,0.05,5.038949964474071E-2,"2015-03-27",36,0.14399999999999999,119.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",1E-3,5.94,8.5569896540074524,"2015-03-27",61,0.24399999999999999,100,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",1E-3,3.81,4.5572824432912427,"2015-03-27",61,0.24399999999999999,104,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-09-18",0.20903283203106016,8.25,8.249999361406438,"2015-03-27",126,0.504,105,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.14693083627611875,4.55,4.5499991598640719,"2015-03-27",61,0.24399999999999999,106,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",4.4644764073526626E-2,2.31,2.3099944989288304,"2015-03-27",61,0.24399999999999999,106.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.11843490273073375,3.37,3.369999344551772,"2015-03-27",61,0.24399999999999999,107,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.15005263720517167,3.75,3.7499998905986516,"2015-03-27",61,0.24399999999999999,107.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.1238399337103249,2.93,2.9299999533539278,"2015-03-27",61,0.24399999999999999,108,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",8.282122659104553E-2,1.8,1.8000000015036264,"2015-03-27",61,0.24399999999999999,108.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",8.3631934114374057E-2,1.58,1.5799999444167838,"2015-03-27",61,0.24399999999999999,109,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",8.4362872432049707E-2,1.38,1.37999972610789,"2015-03-27",61,0.24399999999999999,109.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.12826275993223551,2.1,2.0999997780526485,"2015-03-27",61,0.24399999999999999,110,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.11826214996697564,1.52,1.5199992982999433,"2015-03-27",61,0.24399999999999999,111,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.13363000110811096,1.5,1.5008456230637321,"2015-03-27",61,0.24399999999999999,112,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",8.7560420527833152E-2,0.31,0.31036132691261109,"2015-03-27",61,0.24399999999999999,114,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.2174401202425868,2.38,2.3807815826259713,"2015-03-27",61,0.24399999999999999,114.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.1132099738635125,0.49,0.49047473668654362,"2015-03-27",61,0.24399999999999999,115,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.1073599969117866,0.3,0.30072493266969325,"2015-03-27",61,0.24399999999999999,116,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.10316146709267124,0.18,0.18022508251816838,"2015-03-27",61,0.24399999999999999,117,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.27604955155875283,2.5499999999999998,2.5507831137373564,"2015-03-27",61,0.24399999999999999,118,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.10493814195943581,0.09,9.0233403855409122E-2,"2015-03-27",61,0.24399999999999999,119,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.28232573346667761,2.31,2.310187787383704,"2015-03-27",61,0.24399999999999999,119.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-09-18",0.01,8.0500000000000007,8.5537824004012606,"2015-03-27",126,0.504,100,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-09-18",7.0249985487692776E-2,3.65,3.6499966527643011,"2015-03-27",126,0.504,106,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-09-18",9.3643248128215548E-2,1.85,1.8499989641574501,"2015-03-27",126,0.504,111,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-09-18",0.11989754723693945,2.27,2.2699987811238174,"2015-03-27",126,0.504,112,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-09-18",0.11639470628681242,1.85,1.8499980815748884,"2015-03-27",126,0.504,113,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-09-18",0.11452988109033141,1.52,1.5199973254980783,"2015-03-27",126,0.504,114,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-09-18",0.11138220550475132,1.2,{"$f":"GarmanKohlhagen(\"Call\", I69, H69, G69, K69, J69, B69)","v":1.1999963816907595},"2015-03-27",{"$f":"NETWORKDAYS(E69, A69)","v":126},{"$f":"F69/250","v":0.504},115,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-09-18",0.11288083015182383,0.85,0.84999452945090681,"2015-03-27",126,0.504,117,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-09-18",9.6554821132861637E-2,0.42,0.4199929827549056,"2015-03-27",126,0.504,118,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-12-18",0.15480258657300613,10.9,10.899991271693736,"2015-03-27",191,0.76400000000000001,100,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-12-18",7.9467984784637083E-2,4.42,4.4199975762684005,"2015-03-27",191,0.76400000000000001,106,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-12-18",8.1461465323889912E-2,2.87,2.8699999642809004,"2015-03-27",191,0.76400000000000001,109,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-12-18",0.12444363643693311,4.05,4.0499997561652634,"2015-03-27",191,0.76400000000000001,110,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-12-18",8.5161717658913158E-2,2.1800000000000002,2.1799984703610349,"2015-03-27",191,0.76400000000000001,111,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-12-18",0.11806270087248683,3.02,3.019998709703458,"2015-03-27",191,0.76400000000000001,112,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-12-18",0.11852244400236533,2.86,2.8599983825133748,"2015-03-27",191,0.76400000000000001,112.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-12-18",0.11253539087815138,2.17,2.1699962208076329,"2015-03-27",191,0.76400000000000001,114,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-12-18",0.1031440276443268,1.59,1.5899950063905877,"2015-03-27",191,0.76400000000000001,115,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-12-18",9.4611934183953056E-2,1.1100000000000001,1.1099945659409407,"2015-03-27",191,0.76400000000000001,116,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-12-18",9.9330156837194983E-2,1.05,1.0499943293473031,"2015-03-27",191,0.76400000000000001,117,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-12-18",8.8684107924295444E-2,0.63,0.6299897897917397,"2015-03-27",191,0.76400000000000001,118,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-12-18",9.825589514538452E-2,0.71,0.70999265083332297,"2015-03-27",191,0.76400000000000001,119,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2016-03-18",0.11517509534625256,2.4500000000000002,2.4499957194939626,"2015-03-27",256,1.024,115.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-04-17",0.21539728776407449,0.83,{"$f":"GarmanKohlhagen(\"Put\", I86, H86, G86, K86, J86, B86)","v":0.82994806744197547},"2015-03-27",16,6.4000000000000001E-2,104.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-04-17",0.1826887874022706,0.68,0.67980319348619034,"2015-03-27",16,6.4000000000000001E-2,105,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-04-17",0.1609077458512182,0.62,0.61998677853121009,"2015-03-27",16,6.4000000000000001E-2,105.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-04-17",0.2232934658534402,1.35,1.349997952515082,"2015-03-27",16,6.4000000000000001E-2,106,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-04-17",0.22897259116807661,1.59,1.5893901983980214,"2015-03-27",16,6.4000000000000001E-2,106.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-04-17",0.12501311883714256,0.72,0.71994847642016424,"2015-03-27",16,6.4000000000000001E-2,107,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-04-17",0.18394079944017111,1.52,1.5199517209151452,"2015-03-27",16,6.4000000000000001E-2,107.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-04-17",0.1022345021836108,0.86,0.85971136344586796,"2015-03-27",16,6.4000000000000001E-2,108,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-04-17",0.1140453911469989,1.22,1.2196542579699923,"2015-03-27",16,6.4000000000000001E-2,108.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-04-17",4.1052070858274711E-2,1.07,1.0695021848568302,"2015-03-27",16,6.4000000000000001E-2,109.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-04-17",7.6172328858481284E-2,1.75,1.7496349646782505,"2015-03-27",16,6.4000000000000001E-2,110,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-04-17",0.10831146542895201,2.41,2.4094537246726588,"2015-03-27",16,6.4000000000000001E-2,110.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-04-17",8.4164603873606997E-2,2.62,2.6194607725628885,"2015-03-27",16,6.4000000000000001E-2,111,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-04-17",0.47529293556635832,7.5,7.4999583318738416,"2015-03-27",16,6.4000000000000001E-2,112.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-04-17",2.3067782350441744E-2,2.75,5.9405112448882562,"2015-03-27",16,6.4000000000000001E-2,114.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-04-17",0.30763594790949039,7.6,7.5993031921373273,"2015-03-27",{"$f":"NETWORKDAYS(E101, A101)","v":16},{"$f":"F101/250","v":6.4000000000000001E-2},115,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-04-17",0.01,3.5,7.4404824451647329,"2015-03-27",16,6.4000000000000001E-2,116,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-05-15",0.17365102957653875,0.35,0.3499357830504195,"2015-03-27",36,0.14399999999999999,100,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-05-15",0.12782078573768219,0.24,0.23994472253412624,"2015-03-27",36,0.14399999999999999,102,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-05-15",0.13315042392132664,0.34,0.33997382854030711,"2015-03-27",36,0.14399999999999999,102.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-05-15",0.19110850502554586,1.05,1.0499958740032831,"2015-03-27",36,0.14399999999999999,103,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-05-15",0.14258167949303269,0.7,0.69961527144322133,"2015-03-27",36,0.14399999999999999,104,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-05-15",0.10514513144407603,0.48,0.48086353233343004,"2015-03-27",36,0.14399999999999999,105,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-05-15",0.18214914904364998,1.67,1.6699671083695478,"2015-03-27",36,0.14399999999999999,105.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-05-15",0.13867787013959793,1.2,1.1999815362466109,"2015-03-27",36,0.14399999999999999,106,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-05-15",0.18796803530602754,2.14,2.1393144405086844,"2015-03-27",36,0.14399999999999999,106.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-05-15",0.18668914610780077,2.33,2.3292801217332979,"2015-03-27",36,0.14399999999999999,107,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-05-15",0.18897525932143716,2.59,2.5892851406011843,"2015-03-27",36,0.14399999999999999,107.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-05-15",0.19226338562104492,2.88,2.8793664769190528,"2015-03-27",36,0.14399999999999999,108,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-05-15",0.10199232196400002,1.91,1.9093340944377246,"2015-03-27",36,0.14399999999999999,109,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-05-15",0.11091250676030913,2.34,2.3395392646254791,"2015-03-27",36,0.14399999999999999,109.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-05-15",0.10673685237886642,2.58,2.5790740251348439,"2015-03-27",36,0.14399999999999999,110,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.13954036212413565,0.41,{"$f":"GarmanKohlhagen(\"Put\", I118, H118, G118, K118, J118, B118)","v":0.40999271687911509},"2015-03-27",61,0.24399999999999999,100,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.15840176241873935,0.79,0.78940088637170902,"2015-03-27",61,0.24399999999999999,101,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.17472460461059303,1.25,1.2493501990869227,"2015-03-27",61,0.24399999999999999,102,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.11305021270068877,0.55000000000000004,0.54953351668386574,"2015-03-27",61,0.24399999999999999,103,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.13474855317438053,0.98,0.97934988817108604,"2015-03-27",61,0.24399999999999999,103.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.1233762604221937,0.92,0.91901306943226757,"2015-03-27",61,0.24399999999999999,104,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.11691725526826552,1.08,1.079225844102055,"2015-03-27",61,0.24399999999999999,105,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.16491889464267601,2.16,2.1599992094880491,"2015-03-27",61,0.24399999999999999,105.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.20391089569897169,3.15,3.1499996998435691,"2015-03-27",61,0.24399999999999999,106,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.15954582891949667,2.4500000000000002,2.4499996853333386,"2015-03-27",61,0.24399999999999999,106.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.17455580099308107,2.98,2.9791599504040249,"2015-03-27",61,0.24399999999999999,107,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.11101571449261094,2.1,2.0999999565407066,"2015-03-27",61,0.24399999999999999,108,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.10132575568765027,2.4,2.3999999601804944,"2015-03-27",61,0.24399999999999999,109,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",7.9928136857530474E-2,2.23,2.2291978027246842,"2015-03-27",61,0.24399999999999999,109.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",9.0256314370393428E-2,2.75,2.7490241594554874,"2015-03-27",61,0.24399999999999999,110,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.11145614917287867,3.5,3.4999992072599895,"2015-03-27",{"$f":"NETWORKDAYS(E133, A133)","v":61},{"$f":"F133/250","v":0.24399999999999999},110.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.12508777484107006,4.0999999999999996,4.0999989298676809,"2015-03-27",61,0.24399999999999999,111,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",9.4663552492779024E-2,3.85,3.8499980838514745,"2015-03-27",61,0.24399999999999999,111.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",9.1772098030692001E-2,4.17,4.1699958281095206,"2015-03-27",61,0.24399999999999999,112,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.20950667267831796,6.8,6.7999992415045512,"2015-03-27",61,0.24399999999999999,112.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.01,4.22,4.442058780820247,"2015-03-27",61,0.24399999999999999,113,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",5.1986151224791659E-2,4.99,4.9900046380510759,"2015-03-27",61,0.24399999999999999,113.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.23394907465062509,8.3000000000000007,8.2999984036302976,"2015-03-27",61,0.24399999999999999,114,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.01,3.57,5.9419489848388309,"2015-03-27",61,0.24399999999999999,114.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.22368964557434798,8.8000000000000007,8.7999979823870973,"2015-03-27",61,0.24399999999999999,115,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.01,4.55,6.9418757875178869,"2015-03-27",61,0.24399999999999999,115.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.2642610427736552,10.3,10.299997539704719,"2015-03-27",61,0.24399999999999999,116,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.01,5.0999999999999996,7.9418025901969429,"2015-03-27",61,0.24399999999999999,116.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.21584187075206451,10.15,10.149994998562605,"2015-03-27",61,0.24399999999999999,117,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.01,5.9,8.9417293928759989,"2015-03-27",61,0.24399999999999999,117.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.01,8.3000000000000007,9.4416927942155269,"2015-03-27",61,0.24399999999999999,118,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-06-19",0.01,5.15,10.441619596894583,"2015-03-27",61,0.24399999999999999,119,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-09-18",0.12189306203236826,0.66,{"$f":"GarmanKohlhagen(\"Put\", I150, H150, G150, K150, J150, B150)","v":0.65922399609562454},"2015-03-27",126,0.504,99,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-09-18",0.10766551010766373,2.15,2.1499993850954127,"2015-03-27",126,0.504,106,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-09-18",0.12212019013136283,3,2.9999998239627956,"2015-03-27",126,0.504,107,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-09-18",0.10471028929860814,2.94,2.9399999596235702,"2015-03-27",126,0.504,108,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-09-18",9.3581929683943937E-2,3.11,3.1099999649851569,"2015-03-27",126,0.504,109,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-09-18",7.9522077834825303E-2,3.25,3.2499992292254092,"2015-03-27",126,0.504,110,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-09-18",8.6303883461321729E-2,4.08,4.0799982921271578,"2015-03-27",126,0.504,111,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-09-18",8.5951133920286152E-2,4.75,4.7499957158171924,"2015-03-27",126,0.504,112,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-09-18",7.1451643701823983E-2,5.13,5.1299898617277222,"2015-03-27",126,0.504,113,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-09-18",0.01,3.6,5.4441009596210534,"2015-03-27",126,0.504,114,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-09-18",0.1646061190747341,9.0500000000000007,9.0499955392295561,"2015-03-27",126,0.504,115,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-09-18",0.01,7.4,7.4437985824810369,"2015-03-27",126,0.504,116,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-09-18",0.01,5.7,8.443647393911192,"2015-03-27",126,0.504,117,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-09-18",0.01,2.99,9.4434962053413329,"2015-03-27",126,0.504,118,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-09-18",0.01,6.15,10.443345016771474,"2015-03-27",126,0.504,119,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-12-18",0.13330911672226808,1.72,1.7199953956717273,"2015-03-27",{"$f":"NETWORKDAYS(E165, A165)","v":191},{"$f":"F165/250","v":0.76400000000000001},100,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-12-18",0.13848427441733746,2.15,2.1499960768433262,"2015-03-27",191,0.76400000000000001,101,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-12-18",0.1114452809896618,1.62,1.6199963481364072,"2015-03-27",191,0.76400000000000001,102,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-12-18",0.14827597235379442,3.13,3.1299977128097964,"2015-03-27",191,0.76400000000000001,103,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-12-18",0.10683419487375866,2.09,2.089997415525481,"2015-03-27",191,0.76400000000000001,104,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-12-18",0.10571277442166416,2.41,2.4099985730277851,"2015-03-27",191,0.76400000000000001,105,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-12-18",0.1069185877651482,2.85,2.8499991661427515,"2015-03-27",191,0.76400000000000001,106,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-12-18",0.15275854883668963,5.49,5.4900000612614406,"2015-03-27",191,0.76400000000000001,108,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-12-18",0.13649900469579826,5.4,5.4000000491339932,"2015-03-27",191,0.76400000000000001,109,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-12-18",0.13854807928831508,6.03,6.02999983443177,"2015-03-27",191,0.76400000000000001,110,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-12-18",0.10612240448967221,5.4,5.3999988234000895,"2015-03-27",191,0.76400000000000001,111,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-12-18",9.2194070867552047E-2,5.53,5.5299965259375341,"2015-03-27",191,0.76400000000000001,112,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-12-18",7.9768140282742095E-2,5.8,5.7999923008527077,"2015-03-27",191,0.76400000000000001,113,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-12-18",8.3699331730831106E-2,6.67,6.6699891601737136,"2015-03-27",191,0.76400000000000001,114,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-12-18",7.5983554703290962E-3,5.08,6.4459867394874522,"2015-03-27",191,0.76400000000000001,115,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-12-18",0.01,6.1,8.4455283920160866,"2015-03-27",191,0.76400000000000001,117,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-12-18",1.0084891806824408E-2,5.55,9.4452992182803968,"2015-03-27",191,0.76400000000000001,118,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2015-12-18",1.0847809526692101E-2,6.21,{"$f":"GarmanKohlhagen(\"Put\", I182, H182, G182, K182, J182, B182)","v":10.445070044544707},"2015-03-27",191,0.76400000000000001,119,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2016-03-18",0.11756446957345408,1.8,1.7999938681860357,"2015-03-27",256,1.024,100,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2016-03-18",0.1033511170972181,2.9,2.8999981960564227,"2015-03-27",256,1.024,105,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2016-03-18",9.3913440999781828E-2,4.3499999999999996,4.3500000097481717,"2015-03-27",256,1.024,109,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2016-03-18",8.371338804577752E-2,5.7,5.699996050116809,"2015-03-27",256,1.024,112,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2016-03-18",8.047935768304959E-2,6.25,6.2499927841376035,"2015-03-27",256,1.024,113,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2016-03-18",7.7970145816972855E-2,6.51,6.5099906311976383,"2015-03-27",256,1.024,113.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2016-03-18",7.4719061507975568E-2,7.14,7.1399854080551393,"2015-03-27",256,1.024,114.5,108.56,3.8999999999999999E-4,2.9999999999999997E-4]
["2016-03-18",6.6755389749943342E-2,8.1,8.0999778576021697,"2015-03-27",256,1.024,116,108.56,3.8999999999999999E-4,2.9999999999999997E-4]

{"sheet":"VaR","index":1,"n_rows":167,"n_cols":14,"rows_kept":167,"cut":false,"hidden":false,"merged":[]}
[null,"Value at Risk"]
[null,"Log-normal distribution formula"]
[]
[null,"Implied volatility","Spot rate","The first day of observation","The last day of observation","Exposure time /year","Confidence level","z-score","Expected Maximumn Rate","Expected Minimum Rate",null,null,"Expected Maximumn Rate","Expected Minimum Rate"]
[null,6.3876269552431336E-2,1.0855999999999999,"2015-03-27","2015-04-27",{"$f":"(NETWORKDAYS(D5,E5))/250","v":8.7999999999999995E-2},0.95,{"$f":"NORMSINV(G5)","v":1.6448536269514724},{"$f":"EXP(H5*B5*SQRT(F5))*C5","v":1.1199687378798289},{"$f":"EXP(-H5*B5*SQRT(F5))*C5","v":1.052285943472874},null,"Max",{"$f":"MAX(I5:I167)","v":1.3689560250600878},{"$f":"MAX(J5:J167)","v":1.0640706424017334}]
[null,4.4951009611921409E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1096740624950667,1.0620482174289256,null,"Min",{"$f":"MIN(I6:I168)","v":1.107564961420159},{"$f":"MIN(J6:J168)","v":0.86089497283031469}]
[null,0.17881060039187383,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1845726895816979,0.99489661577135213,null,"Mode",{"$f":"MODE(I7:I169)","v":1.1728559189878285},{"$f":"MODE(J7:J169)","v":1.0048355820355717}]
[null,8.1141445814316759E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.129443670531624,1.0434582890223048]
[null,8.19404198196651E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1298840737427505,1.0430515726238339]
[null,0.17438457206649099,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.182017191139437,0.99704756312717124]
[null,0.1480023810761186,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1668986143496174,1.009965515004801]
[null,9.2669810740524328E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1358148956252774,1.037605127859508]
[null,0.15800436667314582,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1726074578386785,1.0050484943804063]
[null,0.15560514953325985,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1712355131108612,1.0062257733884545]
[null,0.15843856809161683,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1728559189878285,1.0048355820355717]
[null,0.21323878509432695,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.2046403798798926,0.97832297479311103]
[null,0.15843856809161683,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1728559189878285,1.0048355820355717]
[null,0.21333064119387068,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.2046943736611126,0.9782791268613712]
[null,0.19071167273920631,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1914715601397079,0.98913595542457566]
[null,0.3700266431029412,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.3004164149110284,0.90626921229737933]
[null,0.3606330350171435,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.2944695434748841,0.91043266791457433]
[null,0.35195299237735161,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.2889985913319049,0.91429685643197112]
[null,0.13254605281613904,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1581312026988224,1.0176112665418628]
[null,0.14849999999999999,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1671819826929704,1.0097203156622181]
[null,0.16630217887967452,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1773647994819973,1.0009874259180451]
[null,0.1271900720653987,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1551084821961957,1.0202741804469118]
[null,6.7031010852303854E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1216940693701332,1.0506673719526574]
[null,0.15217690402405115,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1692779239552504,1.0079103828570215]
[null,0.15413884986398238,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.170397829133508,1.0069459551821884]
[null,0.10180571752451818,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1408894296680803,1.0329899895232348]
[null,0.10776754677877143,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.14421314273053,1.0299893577411487]
[null,0.19538631817114258,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1941923584342915,0.98688234912604]
[null,8.7463717730487139E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1329332764931823,1.0402442795642359]
[null,0.19682481455516534,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1950308603912667,0.9861898960618779]
[null,0.10792664645280434,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1443019731416666,1.0299094012434218]
[null,0.13304483762422556,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1584131009767538,1.0173636322019202]
[null,0.156420966761629,1.0855999999999999,"2015-03-27","2015-04-27",{"$f":"(NETWORKDAYS(D37,E37))/250","v":8.7999999999999995E-2},0.95,{"$f":"NORMSINV(G37)","v":1.6448536269514724},{"$f":"EXP(H37*B37*SQRT(F37))*C37","v":1.1717018418064138},{"$f":"EXP(-H37*B37*SQRT(F37))*C37","v":1.0058253029482851}]
[null,0.12818386669732068,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1556687469662403,1.0197795545598736]
[null,0.14701351607037225,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1663357108432881,1.0104529502469721]
[null,4.4795239307169804E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1095897227676996,1.0621289435345038]
[null,0.11855115813079146,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1502496097799864,1.0245840120088565]
[null,0.1501194901047854,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1681046753650521,1.0089227317163938]
[null,0.1239150568454272,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1532640710874089,1.0219059012987115]
[null,8.288258526683423E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.130403626296935,1.0425721685454179]
[null,8.3691951631332667E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1308501382059437,1.0421605128595506]
[null,8.4428613460215934E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1312566937341251,1.0417859770710753]
[null,0.12831403693751492,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1557421522733697,1.0197147847223631]
[null,0.11831222008514133,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1501155122809796,1.0247034731865081]
[null,0.13363000110811096,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1587439053733399,1.0170731898005416]
[null,8.7560420527833152E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1329867356628986,1.0401951963810554]
[null,0.2174401202425868,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.2071124373730568,0.97631945750201654]
[null,0.1132099738635125,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1472557431857908,1.0272577557357625]
[null,0.1073599969117866,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.143985626125247,1.0301942026944408]
[null,0.10316146709267124,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.141644409379353,1.0323068639566133]
[null,0.27604955155875283,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.2421318298348509,0.94879410678711307]
[null,0.10493814195943581,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1426345472409982,1.0314123293800876]
[null,0.28232573346667761,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.2459415841626063,0.94589294954151848]
[null,0.2091335088816422,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.2022297336050856,0.98028465530127085]
[null,7.0382859444974161E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1235301113380807,1.0489504002669048]
[null,9.3711040772309045E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1363921047223766,1.0370780957580807]
[null,0.11996348675586431,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1510425603238654,1.0238781784649222]
[null,0.11645627657504096,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1490744464923948,1.0256318584035278]
[null,0.11458892345940011,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1480279317053652,1.026566799859415]
[null,0.11144118418803811,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1462660111480705,1.028144731273692]
[null,0.11294493721093293,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1471073866480932,1.0273906120016516]
[null,9.6621145662192251E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1380068864297088,1.0356065275645359]
[null,0.15498128895756011,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1708790338513608,1.0065321232403328]
[null,7.9611219124740867E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1286006720048098,1.0442376911813298]
[null,8.1564284133718093E-2,1.0855999999999999,"2015-03-27","2015-04-27",{"$f":"(NETWORKDAYS(D69,E69))/250","v":8.7999999999999995E-2},0.95,{"$f":"NORMSINV(G69)","v":1.6448536269514724},{"$f":"EXP(H69*B69*SQRT(F69))*C69","v":1.1296767222500561},{"$f":"EXP(-H69*B69*SQRT(F69))*C69","v":1.0432430241216659}]
[null,0.12456249844806835,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1536284611789549,1.0215831176664967]
[null,8.526915354501037E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1317207570587842,1.0413587916005542]
[null,0.11814693124544093,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1500227575496436,1.0247861203295585]
[null,0.11860415739214633,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1502793562968612,1.0245575160055713]
[null,0.11263311097547321,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1469328638040501,1.0275469447192922]
[null,0.1032274285245038,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1416811542320298,1.0322736393005938]
[null,9.4675499303159355E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1369270169837773,1.0365901613690089]
[null,9.9389751660666395E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1395452819979981,1.0342084501755413]
[null,8.8772268991521353E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1336568827636893,1.0395802979883322]
[null,9.8316915374367805E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1389489062605556,1.0347499817787174]
[null,0.1152585212790249,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.148403082635653,1.0262314494099143]
[null,0.21539728776407449,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.2059098056916537,0.97729312294964832]
[null,0.1826887874022706,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.186816416692227,0.99301572123906945]
[null,0.1609077458512182,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1742698468813679,1.0036256684355296]
[null,0.2232934658534402,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.2105649941261754,0.97353497393231536]
[null,0.22897259116807661,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.2139242263579231,0.97084095894179268]
[null,0.12501311883714256,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1538821452155885,1.0213585199204263]
[null,0.18394079944017111,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1875416759925361,0.99240926346016234]
[null,0.1022345021836108,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1411281540738829,1.0327738876589803]
[null,0.1140453911469989,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1477235007390896,1.0268390942949881]
[null,4.1052070858274711E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.107564961420159,1.0640706424017334]
[null,7.6172328858481284E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1267084900458786,1.0459913725794425]
[null,0.10831146542895201,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1445168583361158,1.0297160338147644]
[null,8.4164603873606997E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1311109729568865,1.04192019012879]
[null,0.47529293556635832,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.3689560250600878,0.86089497283031469]
[null,0.30763594790949039,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.261424281043225,0.93428307803408739]
[null,0.17365102957653875,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1815941915552295,0.99740449675772935]
[null,0.12782078573768219,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1554640238109886,1.0199602373710805]
[null,0.13315042392132664,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1584727839980911,1.0173112189418008]
[null,0.19110850502554586,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1917022886806019,0.98894444627173717]
[null,0.14258167949303269,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1638162569720185,1.0126404000114726]
[null,0.10514513144407603,1.0855999999999999,"2015-03-27","2015-04-27",{"$f":"(NETWORKDAYS(D101,E101))/250","v":8.7999999999999995E-2},0.95,{"$f":"NORMSINV(G101)","v":1.6448536269514724},{"$f":"EXP(H101*B101*SQRT(F101))*C101","v":1.1427499579631812},{"$f":"EXP(-H101*B101*SQRT(F101))*C101","v":1.0313081630740879}]
[null,0.18214914904364998,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1865039542849856,0.99327722907607785]
[null,0.13867787013959793,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1616014899473976,1.0145711504324677]
[null,0.18796803530602754,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1898775601208174,0.99046103523486473]
[null,0.18668914610780077,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.189135279216381,0.99107929988977228]
[null,0.18897525932143716,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1904624898087972,0.98997437558010382]
[null,0.19226338562104492,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1923740203471249,0.98838731798006296]
[null,0.10199232196400002,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1409933149189657,1.032895937767786]
[null,0.11091250676030913,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1459703537428163,1.0284099899712502]
[null,0.10673685237886642,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1436378402611969,1.0305074897931277]
[null,0.13954036212413565,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1620904486833503,1.0141442616065492]
[null,0.15840176241873935,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1728348557991093,1.0048536280898743]
[null,0.17472460461059303,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1822133233392484,0.9968821503983416]
[null,0.11305021270068877,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1471663132088483,1.0273378379665181]
[null,0.13474855317438053,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1593765076960243,1.0165182338755794]
[null,0.1233762604221937,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1529609159223801,1.0221745973558576]
[null,0.11691725526826552,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1493329381051465,1.0254011878777136]
[null,0.16491889464267601,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1765703898338851,1.0016632835425945]
[null,0.20391089569897169,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1991699502911357,0.98278593431554517]
[null,0.15954582891949667,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1734897602653052,1.004292836550662]
[null,0.17455580099308107,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1821159526360898,0.99696426342264699]
[null,0.11101571449261094,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1460280656128119,1.0283582011316708]
[null,0.10132575568765027,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1406222717794723,1.0332319376522363]
[null,7.9928136857530474E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1287752096118244,1.0440762252435405]
[null,9.0256314370393428E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1344780935687089,1.0388277805283361]
[null,0.11145614917287867,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1462743812717386,1.0281372237356277]
[null,0.12508777484107006,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1539241794068822,1.0213213147208369]
[null,9.4663552492779024E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1369203894509967,1.0365962040394883]
[null,9.1772098030692001E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1353174811577398,1.0380597318013607]
[null,0.20950667267831796,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.202448658474834,0.98010617891563412]
[null,5.1986151224791659E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1134898351897737,1.0584087279064756]
[null,0.23394907465062509,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.2168755044251112,0.96848638641696705]
[null,0.22368964557434798,1.0855999999999999,"2015-03-27","2015-04-27",{"$f":"(NETWORKDAYS(D133,E133))/250","v":8.7999999999999995E-2},0.95,{"$f":"NORMSINV(G133)","v":1.6448536269514724},{"$f":"EXP(H133*B133*SQRT(F133))*C133","v":1.2107990345758637},{"$f":"EXP(-H133*B133*SQRT(F133))*C133","v":0.97334679525312928}]
[null,0.2642610427736552,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.2350074560285191,0.95426740482187411]
[null,0.21584187075206451,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.2061714331767814,0.97708114085907893]
[null,0.12189306203236826,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1521268021725664,1.0229146286482094]
[null,0.10766551010766373,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1441561760393344,1.0300406401507585]
[null,0.12212019013136283,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1522544942064084,1.0228012699674356]
[null,0.10471028929860814,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1425075173556389,1.0315270071287843]
[null,9.3581929683943937E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1363205156619138,1.0371434324702833]
[null,7.9522077834825303E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1285515836624727,1.0442831121421507]
[null,8.6303883461321729E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1322922942810281,1.0408331540826474]
[null,8.5951133920286152E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1320974192367674,1.0410123192353309]
[null,7.1451643701823983E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1241161909389092,1.0484035097970112]
[null,0.1646061190747341,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1763908395116343,1.0018161655264608]
[null,0.13330911672226808,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1585624914391111,1.0172324485803863]
[null,0.13848427441733746,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1614917661075101,1.0146669949711145]
[null,0.1114452809896618,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1462683025399882,1.0281426760109562]
[null,0.14827597235379442,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.167054401973497,1.0098306968442103]
[null,0.10683419487375866,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1436921615289022,1.0304585443905896]
[null,0.10571277442166416,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.143066517369332,1.0310225538862583]
[null,0.1069185877651482,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1437392584531798,1.0304161121424376]
[null,0.15275854883668963,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1696098228698724,1.0076243692176308]
[null,0.13649900469579826,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1603671768924384,1.0156503764232592]
[null,0.13854807928831508,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1615279275148027,1.0146354057293903]
[null,0.10612240448967221,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1432950116465079,1.0308164979244965]
[null,9.2194070867552047E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1355512653404471,1.037846018908418]
[null,7.9768140282742095E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1286870905654345,1.0441577385363705]
[null,8.3699331730831106E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1308542104767161,1.0421567599798625]
[null,0.11756446957345408,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1496959585890656,1.0250774138984682]
[null,0.1033511170972181,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1417500600842942,1.0322113404688504]
[null,9.3913440999781828E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1365043399631101,1.0369756793346285]
[null,8.371338804577752E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1308619666621038,1.042149612192359]
[null,8.047935768304959E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.129078850378225,1.0437954440517685]
[null,7.7970145816972855E-2,1.0855999999999999,"2015-03-27","2015-04-27",{"$f":"(NETWORKDAYS(D165,E165))/250","v":8.7999999999999995E-2},0.95,{"$f":"NORMSINV(G165)","v":1.6448536269514724},{"$f":"EXP(H165*B165*SQRT(F165))*C165","v":1.1276973075249268},1.0450741986665153]
[null,7.4719061507975568E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1259098120783959,1.0467333594193244]
[null,6.6755389749943342E-2,1.0855999999999999,"2015-03-27","2015-04-27",8.7999999999999995E-2,0.95,1.6448536269514724,1.1215432259819791,1.0508086828023304]

{"sheet":"Result test","index":2,"n_rows":165,"n_cols":16,"rows_kept":165,"cut":false,"hidden":false,"merged":[]}
["RESULT TESTING AND SUMMARISING"]
["Expiration Date","Strike rate","Option price","Implied volatility","Spot rate","Expected Max Rate","Expected Min Rate",null,null,"Date","Actual EUR/USD rate","Number of max rate error","Number of min rate error",null,"Implied volatility quartile"]
["2015-04-17",107.5,1.35,6.3876269552431336E-2,1.0855999999999999,1.1199687378798289,1.052285943472874,null,null,"2015-03-27",1.08962,{"$f":"COUNTIF($F$3:$F$165,\"<\"&K3)","v":0},{"$f":"COUNTIF($G$3:$G$165,\">\"&K3)","v":0},null,"Quart = 0",{"$f":"QUARTILE(D3:D165, 1)","v":9.5648322482675796E-2}]
["2015-04-17",108,0.82,4.4951009611921409E-2,1.0855999999999999,1.1096740624950667,1.0620482174289256,null,null,"2015-03-30",1.0832999999999999,0,0,null,"Quart = 1",{"$f":"QUARTILE(D4:D166, 0)","v":4.1052070858274711E-2}]
["2015-04-17",109,1.75,0.17881060039187383,1.0855999999999999,1.1845726895816979,0.99489661577135213,null,null,"2015-03-31",1.0730999999999999,0,0]
["2015-04-17",109.5,0.5,8.1141445814316759E-2,1.0855999999999999,1.129443670531624,1.0434582890223048,null,null,"2015-04-01",1.0763,0,0]
["2015-04-17",110,0.36,8.19404198196651E-2,1.0855999999999999,1.1298840737427505,1.0430515726238339,null,null,"2015-04-02",1.0880000000000001,0,0]
["2015-04-17",110.5,1.1100000000000001,0.17438457206649099,1.0855999999999999,1.182017191139437,0.99704756312717124,null,null,"2015-04-03",1.0969,0,0]
["2015-04-17",111,0.7,0.1480023810761186,1.0855999999999999,1.1668986143496174,1.009965515004801,null,null,"2015-04-06",1.0922000000000001,0,0]
["2015-04-17",112,0.11,9.2669810740524328E-2,1.0855999999999999,1.1358148956252774,1.037605127859508,null,null,"2015-04-07",1.0813999999999999,0,0]
["2015-04-17",112.5,0.45,0.15800436667314582,1.0855999999999999,1.1726074578386785,1.0050484943804063,null,null,"2015-04-08",1.0781000000000001,0,0]
["2015-04-17",113,0.35,0.15560514953325985,1.0855999999999999,1.1712355131108612,1.0062257733884545,null,null,"2015-04-09",1.0659000000000001,0,0]
["2015-04-17",114,0.24,0.15843856809161683,1.0855999999999999,1.1728559189878285,1.0048355820355717,null,null,"2015-04-10",1.0604,0,3]
["2015-04-17",114,0.24,0.21323878509432695,1.0855999999999999,1.2046403798798926,0.97832297479311103,null,null,"2015-04-13",1.0567,0,4]
["2015-04-17",115,0.44,0.15843856809161683,1.0855999999999999,1.1728559189878285,1.0048355820355717,null,null,"2015-04-14",1.0654999999999999,0,0]
["2015-04-17",115,0.44,0.21333064119387068,1.0855999999999999,1.2046943736611126,0.9782791268613712,null,null,"2015-04-15",1.0684,0,0]
["2015-04-17",116,0.21,0.19071167273920631,1.0855999999999999,1.1914715601397079,0.98913595542457566,null,null,"2015-04-16",1.0761000000000001,0,0]
["2015-04-17",116.5,1.37,0.3700266431029412,1.0855999999999999,1.3004164149110284,0.90626921229737933,null,null,"2015-04-17",1.0806,0,0]
["2015-04-17",117,1.19,0.3606330350171435,1.0855999999999999,1.2944695434748841,0.91043266791457433,null,null,"2015-04-20",1.0738000000000001,0,0]
["2015-04-17",117.5,1.03,0.35195299237735161,1.0855999999999999,1.2889985913319049,0.91429685643197112,null,null,"2015-04-21",1.0736000000000001,0,0]
["2015-05-15",106.5,3.34,0.13254605281613904,1.0855999999999999,1.1581312026988224,1.0176112665418628,null,null,"2015-04-22",1.0725,0,0]
["2015-05-15",107,3.28,0.14849999999999999,1.0855999999999999,1.1671819826929704,1.0097203156622181,null,null,"2015-03-27",1.0828,0,0]
["2015-05-15",107.5,3.28,0.16630217887967452,1.0855999999999999,1.1773647994819973,1.0009874259180451,null,null,"Total",null,0,4]
["2015-05-15",107.5,2.65,0.1271900720653987,1.0855999999999999,1.1551084821961957,1.0202741804469118]
["2015-05-15",108.5,1.1299999999999999,6.7031010852303854E-2,1.0855999999999999,1.1216940693701332,1.0506673719526574]
["2015-05-15",109,2.29,0.15217690402405115,1.0855999999999999,1.1692779239552504,1.0079103828570215]
["2015-05-15",109.5,2.1,0.15413884986398238,1.0855999999999999,1.170397829133508,1.0069459551821884]
["2015-05-15",110,1.06,0.10180571752451818,1.0855999999999999,1.1408894296680803,1.0329899895232348]
["2015-05-15",110.5,0.98,0.10776754677877143,1.0855999999999999,1.14421314273053,1.0299893577411487]
["2015-05-15",111,2.17,0.19538631817114258,1.0855999999999999,1.1941923584342915,0.98688234912604]
["2015-05-15",112,0.34,8.7463717730487139E-2,1.0855999999999999,1.1329332764931823,1.0402442795642359]
["2015-05-15",112.5,1.69,0.19682481455516534,1.0855999999999999,1.1950308603912667,0.9861898960618779]
["2015-05-15",113.5,0.32,0.10792664645280434,1.0855999999999999,1.1443019731416666,1.0299094012434218]
["2015-05-15",116,0.25,0.13304483762422556,1.0855999999999999,1.1584131009767538,1.0173636322019202]
["2015-05-15",117,0.33,0.156420966761629,1.0855999999999999,1.1717018418064138,1.0058253029482851]
["2015-05-15",119.5,0.05,0.12818386669732068,1.0855999999999999,1.1556687469662403,1.0197795545598736]
["2015-06-19",106,4.55,0.14701351607037225,1.0855999999999999,1.1663357108432881,1.0104529502469721]
["2015-06-19",106.5,2.31,4.4795239307169804E-2,1.0855999999999999,1.1095897227676996,1.0621289435345038]
["2015-06-19",107,3.37,0.11855115813079146,1.0855999999999999,1.1502496097799864,1.0245840120088565]
["2015-06-19",107.5,3.75,0.1501194901047854,1.0855999999999999,1.1681046753650521,1.0089227317163938]
["2015-06-19",108,2.93,0.1239150568454272,1.0855999999999999,1.1532640710874089,1.0219059012987115]
["2015-06-19",108.5,1.8,8.288258526683423E-2,1.0855999999999999,1.130403626296935,1.0425721685454179]
["2015-06-19",109,1.58,8.3691951631332667E-2,1.0855999999999999,1.1308501382059437,1.0421605128595506]
["2015-06-19",109.5,1.38,8.4428613460215934E-2,1.0855999999999999,1.1312566937341251,1.0417859770710753]
["2015-06-19",110,2.1,0.12831403693751492,1.0855999999999999,1.1557421522733697,1.0197147847223631]
["2015-06-19",111,1.52,0.11831222008514133,1.0855999999999999,1.1501155122809796,1.0247034731865081]
["2015-06-19",112,1.5,0.13363000110811096,1.0855999999999999,1.1587439053733399,1.0170731898005416]
["2015-06-19",114,0.31,8.7560420527833152E-2,1.0855999999999999,1.1329867356628986,1.0401951963810554]
["2015-06-19",114.5,2.38,0.2174401202425868,1.0855999999999999,1.2071124373730568,0.97631945750201654]
["2015-06-19",115,0.49,0.1132099738635125,1.0855999999999999,1.1472557431857908,1.0272577557357625]
["2015-06-19",116,0.3,0.1073599969117866,1.0855999999999999,1.143985626125247,1.0301942026944408]
["2015-06-19",117,0.18,0.10316146709267124,1.0855999999999999,1.141644409379353,1.0323068639566133]
["2015-06-19",118,2.5499999999999998,0.27604955155875283,1.0855999999999999,1.2421318298348509,0.94879410678711307]
["2015-06-19",119,0.09,0.10493814195943581,1.0855999999999999,1.1426345472409982,1.0314123293800876]
["2015-06-19",119.5,2.31,0.28232573346667761,1.0855999999999999,1.2459415841626063,0.94589294954151848]
["2015-09-18",105,8.25,0.2091335088816422,1.0855999999999999,1.2022297336050856,0.98028465530127085]
["2015-09-18",106,3.65,7.0382859444974161E-2,1.0855999999999999,1.1235301113380807,1.0489504002669048]
["2015-09-18",111,1.85,9.3711040772309045E-2,1.0855999999999999,1.1363921047223766,1.0370780957580807]
["2015-09-18",112,2.27,0.11996348675586431,1.0855999999999999,1.1510425603238654,1.0238781784649222]
["2015-09-18",113,1.85,0.11645627657504096,1.0855999999999999,1.1490744464923948,1.0256318584035278]
["2015-09-18",114,1.52,0.11458892345940011,1.0855999999999999,1.1480279317053652,1.026566799859415]
["2015-09-18",115,1.2,0.11144118418803811,1.0855999999999999,1.1462660111480705,1.028144731273692]
["2015-09-18",117,0.85,0.11294493721093293,1.0855999999999999,1.1471073866480932,1.0273906120016516]
["2015-09-18",118,0.42,9.6621145662192251E-2,1.0855999999999999,1.1380068864297088,1.0356065275645359]
["2015-12-18",100,10.9,0.15498128895756011,1.0855999999999999,1.1708790338513608,1.0065321232403328]
["2015-12-18",106,4.42,7.9611219124740867E-2,1.0855999999999999,1.1286006720048098,1.0442376911813298]
["2015-12-18",109,2.87,8.1564284133718093E-2,1.0855999999999999,1.1296767222500561,1.0432430241216659]
["2015-12-18",110,4.05,0.12456249844806835,1.0855999999999999,1.1536284611789549,1.0215831176664967]
["2015-12-18",111,2.1800000000000002,8.526915354501037E-2,1.0855999999999999,1.1317207570587842,1.0413587916005542]
["2015-12-18",112,3.02,0.11814693124544093,1.0855999999999999,1.1500227575496436,1.0247861203295585]
["2015-12-18",112.5,2.86,0.11860415739214633,1.0855999999999999,1.1502793562968612,1.0245575160055713]
["2015-12-18",114,2.17,0.11263311097547321,1.0855999999999999,1.1469328638040501,1.0275469447192922]
["2015-12-18",115,1.59,0.1032274285245038,1.0855999999999999,1.1416811542320298,1.0322736393005938]
["2015-12-18",116,1.1100000000000001,9.4675499303159355E-2,1.0855999999999999,1.1369270169837773,1.0365901613690089]
["2015-12-18",117,1.05,9.9389751660666395E-2,1.0855999999999999,1.1395452819979981,1.0342084501755413]
["2015-12-18",118,0.63,8.8772268991521353E-2,1.0855999999999999,1.1336568827636893,1.0395802979883322]
["2015-12-18",119,0.71,9.8316915374367805E-2,1.0855999999999999,1.1389489062605556,1.0347499817787174]
["2016-03-18",115.5,2.4500000000000002,0.1152585212790249,1.0855999999999999,1.148403082635653,1.0262314494099143]
["2015-04-17",104.5,0.83,0.21539728776407449,1.0855999999999999,1.2059098056916537,0.97729312294964832]
["2015-04-17",105,0.68,0.1826887874022706,1.0855999999999999,1.186816416692227,0.99301572123906945]
["2015-04-17",105.5,0.62,0.1609077458512182,1.0855999999999999,1.1742698468813679,1.0036256684355296]
["2015-04-17",106,1.35,0.2232934658534402,1.0855999999999999,1.2105649941261754,0.97353497393231536]
["2015-04-17",106.5,1.59,0.22897259116807661,1.0855999999999999,1.2139242263579231,0.97084095894179268]
["2015-04-17",107,0.72,0.12501311883714256,1.0855999999999999,1.1538821452155885,1.0213585199204263]
["2015-04-17",107.5,1.52,0.18394079944017111,1.0855999999999999,1.1875416759925361,0.99240926346016234]
["2015-04-17",108,0.86,0.1022345021836108,1.0855999999999999,1.1411281540738829,1.0327738876589803]
["2015-04-17",108.5,1.22,0.1140453911469989,1.0855999999999999,1.1477235007390896,1.0268390942949881]
["2015-04-17",109.5,1.07,4.1052070858274711E-2,1.0855999999999999,1.107564961420159,1.0640706424017334]
["2015-04-17",110,1.75,7.6172328858481284E-2,1.0855999999999999,1.1267084900458786,1.0459913725794425]
["2015-04-17",110.5,2.41,0.10831146542895201,1.0855999999999999,1.1445168583361158,1.0297160338147644]
["2015-04-17",111,2.62,8.4164603873606997E-2,1.0855999999999999,1.1311109729568865,1.04192019012879]
["2015-04-17",112.5,7.5,0.47529293556635832,1.0855999999999999,1.3689560250600878,0.86089497283031469]
["2015-04-17",115,7.6,0.30763594790949039,1.0855999999999999,1.261424281043225,0.93428307803408739]
["2015-05-15",100,0.35,0.17365102957653875,1.0855999999999999,1.1815941915552295,0.99740449675772935]
["2015-05-15",102,0.24,0.12782078573768219,1.0855999999999999,1.1554640238109886,1.0199602373710805]
["2015-05-15",102.5,0.34,0.13315042392132664,1.0855999999999999,1.1584727839980911,1.0173112189418008]
["2015-05-15",103,1.05,0.19110850502554586,1.0855999999999999,1.1917022886806019,0.98894444627173717]
["2015-05-15",104,0.7,0.14258167949303269,1.0855999999999999,1.1638162569720185,1.0126404000114726]
["2015-05-15",105,0.48,0.10514513144407603,1.0855999999999999,1.1427499579631812,1.0313081630740879]
["2015-05-15",105.5,1.67,0.18214914904364998,1.0855999999999999,1.1865039542849856,0.99327722907607785]
["2015-05-15",106,1.2,0.13867787013959793,1.0855999999999999,1.1616014899473976,1.0145711504324677]
["2015-05-15",106.5,2.14,0.18796803530602754,1.0855999999999999,1.1898775601208174,0.99046103523486473]
["2015-05-15",107,2.33,0.18668914610780077,1.0855999999999999,1.189135279216381,0.99107929988977228]
["2015-05-15",107.5,2.59,0.18897525932143716,1.0855999999999999,1.1904624898087972,0.98997437558010382]
["2015-05-15",108,2.88,0.19226338562104492,1.0855999999999999,1.1923740203471249,0.98838731798006296]
["2015-05-15",109,1.91,0.10199232196400002,1.0855999999999999,1.1409933149189657,1.032895937767786]
["2015-05-15",109.5,2.34,0.11091250676030913,1.0855999999999999,1.1459703537428163,1.0284099899712502]
["2015-05-15",110,2.58,0.10673685237886642,1.0855999999999999,1.1436378402611969,1.0305074897931277]
["2015-06-19",100,0.41,0.13954036212413565,1.0855999999999999,1.1620904486833503,1.0141442616065492]
["2015-06-19",101,0.79,0.15840176241873935,1.0855999999999999,1.1728348557991093,1.0048536280898743]
["2015-06-19",102,1.25,0.17472460461059303,1.0855999999999999,1.1822133233392484,0.9968821503983416]
["2015-06-19",103,0.55000000000000004,0.11305021270068877,1.0855999999999999,1.1471663132088483,1.0273378379665181]
["2015-06-19",103.5,0.98,0.13474855317438053,1.0855999999999999,1.1593765076960243,1.0165182338755794]
["2015-06-19",104,0.92,0.1233762604221937,1.0855999999999999,1.1529609159223801,1.0221745973558576]
["2015-06-19",105,1.08,0.11691725526826552,1.0855999999999999,1.1493329381051465,1.0254011878777136]
["2015-06-19",105.5,2.16,0.16491889464267601,1.0855999999999999,1.1765703898338851,1.0016632835425945]
["2015-06-19",106,3.15,0.20391089569897169,1.0855999999999999,1.1991699502911357,0.98278593431554517]
["2015-06-19",106.5,2.4500000000000002,0.15954582891949667,1.0855999999999999,1.1734897602653052,1.004292836550662]
["2015-06-19",107,2.98,0.17455580099308107,1.0855999999999999,1.1821159526360898,0.99696426342264699]
["2015-06-19",108,2.1,0.11101571449261094,1.0855999999999999,1.1460280656128119,1.0283582011316708]
["2015-06-19",109,2.4,0.10132575568765027,1.0855999999999999,1.1406222717794723,1.0332319376522363]
["2015-06-19",109.5,2.23,7.9928136857530474E-2,1.0855999999999999,1.1287752096118244,1.0440762252435405]
["2015-06-19",110,2.75,9.0256314370393428E-2,1.0855999999999999,1.1344780935687089,1.0388277805283361]
["2015-06-19",110.5,3.5,0.11145614917287867,1.0855999999999999,1.1462743812717386,1.0281372237356277]
["2015-06-19",111,4.0999999999999996,0.12508777484107006,1.0855999999999999,1.1539241794068822,1.0213213147208369]
["2015-06-19",111.5,3.85,9.4663552492779024E-2,1.0855999999999999,1.1369203894509967,1.0365962040394883]
["2015-06-19",112,4.17,9.1772098030692001E-2,1.0855999999999999,1.1353174811577398,1.0380597318013607]
["2015-06-19",112.5,6.8,0.20950667267831796,1.0855999999999999,1.202448658474834,0.98010617891563412]
["2015-06-19",113.5,4.99,5.1986151224791659E-2,1.0855999999999999,1.1134898351897737,1.0584087279064756]
["2015-06-19",114,8.3000000000000007,0.23394907465062509,1.0855999999999999,1.2168755044251112,0.96848638641696705]
["2015-06-19",115,8.8000000000000007,0.22368964557434798,1.0855999999999999,1.2107990345758637,0.97334679525312928]
["2015-06-19",116,10.3,0.2642610427736552,1.0855999999999999,1.2350074560285191,0.95426740482187411]
["2015-06-19",117,10.15,0.21584187075206451,1.0855999999999999,1.2061714331767814,0.97708114085907893]
["2015-09-18",99,0.66,0.12189306203236826,1.0855999999999999,1.1521268021725664,1.0229146286482094]
["2015-09-18",106,2.15,0.10766551010766373,1.0855999999999999,1.1441561760393344,1.0300406401507585]
["2015-09-18",107,3,0.12212019013136283,1.0855999999999999,1.1522544942064084,1.0228012699674356]
["2015-09-18",108,2.94,0.10471028929860814,1.0855999999999999,1.1425075173556389,1.0315270071287843]
["2015-09-18",109,3.11,9.3581929683943937E-2,1.0855999999999999,1.1363205156619138,1.0371434324702833]
["2015-09-18",110,3.25,7.9522077834825303E-2,1.0855999999999999,1.1285515836624727,1.0442831121421507]
["2015-09-18",111,4.08,8.6303883461321729E-2,1.0855999999999999,1.1322922942810281,1.0408331540826474]
["2015-09-18",112,4.75,8.5951133920286152E-2,1.0855999999999999,1.1320974192367674,1.0410123192353309]
["2015-09-18",113,5.13,7.1451643701823983E-2,1.0855999999999999,1.1241161909389092,1.0484035097970112]
["2015-09-18",115,9.0500000000000007,0.1646061190747341,1.0855999999999999,1.1763908395116343,1.0018161655264608]
["2015-12-18",100,1.72,0.13330911672226808,1.0855999999999999,1.1585624914391111,1.0172324485803863]
["2015-12-18",101,2.15,0.13848427441733746,1.0855999999999999,1.1614917661075101,1.0146669949711145]
["2015-12-18",102,1.62,0.1114452809896618,1.0855999999999999,1.1462683025399882,1.0281426760109562]
["2015-12-18",103,3.13,0.14827597235379442,1.0855999999999999,1.167054401973497,1.0098306968442103]
["2015-12-18",104,2.09,0.10683419487375866,1.0855999999999999,1.1436921615289022,1.0304585443905896]
["2015-12-18",105,2.41,0.10571277442166416,1.0855999999999999,1.143066517369332,1.0310225538862583]
["2015-12-18",106,2.85,0.1069185877651482,1.0855999999999999,1.1437392584531798,1.0304161121424376]
["2015-12-18",108,5.49,0.15275854883668963,1.0855999999999999,1.1696098228698724,1.0076243692176308]
["2015-12-18",109,5.4,0.13649900469579826,1.0855999999999999,1.1603671768924384,1.0156503764232592]
["2015-12-18",110,6.03,0.13854807928831508,1.0855999999999999,1.1615279275148027,1.0146354057293903]
["2015-12-18",111,5.4,0.10612240448967221,1.0855999999999999,1.1432950116465079,1.0308164979244965]
["2015-12-18",112,5.53,9.2194070867552047E-2,1.0855999999999999,1.1355512653404471,1.037846018908418]
["2015-12-18",113,5.8,7.9768140282742095E-2,1.0855999999999999,1.1286870905654345,1.0441577385363705]
["2015-12-18",114,6.67,8.3699331730831106E-2,1.0855999999999999,1.1308542104767161,1.0421567599798625]
["2016-03-18",100,1.8,0.11756446957345408,1.0855999999999999,1.1496959585890656,1.0250774138984682]
["2016-03-18",105,2.9,0.1033511170972181,1.0855999999999999,1.1417500600842942,1.0322113404688504]
["2016-03-18",109,4.3499999999999996,9.3913440999781828E-2,1.0855999999999999,1.1365043399631101,1.0369756793346285]
["2016-03-18",112,5.7,8.371338804577752E-2,1.0855999999999999,1.1308619666621038,1.042149612192359]
["2016-03-18",113,6.25,8.047935768304959E-2,1.0855999999999999,1.129078850378225,1.0437954440517685]
["2016-03-18",113.5,6.51,7.7970145816972855E-2,1.0855999999999999,1.1276973075249268,1.0450741986665153]
["2016-03-18",114.5,7.14,7.4719061507975568E-2,1.0855999999999999,1.1259098120783959,1.0467333594193244]
["2016-03-18",116,8.1,6.6755389749943342E-2,1.0855999999999999,1.1215432259819791,1.0508086828023304]