{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Sheet1","index":0,"n_rows":210,"n_cols":15,"rows_kept":210,"cut":false,"hidden":false,"merged":[]}
["Black-Scholes Preise von Call- und Put-Optionen"]
[]
["Options-Parameter:"]
["Ausuebungspreis oder Strike K",80]
["Laufzeit oder Maturity T",1]
["Options-Typ (call/put)","call"]
["Barrier B ",80]
["Markt-Parameter:"]
["aktueller Preis S0 des Basiswerts",100]
["jaehrliche Volatilitaet",0.3]
["jaehrlicher Zinssatz",0]
[]
["kappa",{"$f":"2*B11/B10^2","v":0}]
["Black-Scholes Preis Standard Call/Put",{"$f":"BlackScholesPrice(B9,B4,B5,B6,B10,B11)","v":23.534390103173756}]
["Black-Scholes Preis Barrier Call (down and out)",{"$f":"IF(B4>=B7,VLOOKUP(B9,A20:B210,2,FALSE),VLOOKUP(B9,I21:J210,2,FALSE))","v":20.000000000000004}]
[]
[]
[]
[]
["S0","V_Barrier (K>=B)","V_call(S0)","V_call(B^2/S0)",null,null,null,null,"S0","V_Barrier (K<B)","V_call(S0)","V^B_call(S0)","V^B_Dig(S0)","V^B_call(B^2/S0)","V^B_Dig(B^2/S0)"]
[11,{"$f":"IF(A21>$B$7,C21-(A21/$B$7)^(1-$B$13)*D21,0)","v":0},{"$f":"BlackScholesPrice(A21,$B$4,$B$5,$B$6,$B$10,$B$11)","v":2.3907491017997929E-11},{"$f":"BlackScholesPrice($B$7^2/A21,$B$4,$B$5,$B$6,$B$10,$B$11)","v":501.81818181835575},null,null,null,null,11,{"$f":"IF(I21<$B$7,0,L21+($B$7-$B$4)*M21-(I21/$B$7)^(1-$B$13)*(N21+($B$7-$B$4)*O21))","v":0},{"$f":"BlackScholesPrice(I21,$B$4,$B$5,$B$6,$B$10,$B$11)","v":2.3907491017997929E-11},{"$f":"BlackScholesPrice(I21,$B$7,$B$5,$B$6,$B$10,$B$11)","v":2.3907491017997929E-11},{"$f":"BlackScholesDigital(I21,$B$7,$B$5,$B$6,$B$10,$B$11)","v":6.7222670987486718E-12},{"$f":"BlackScholesPrice($B$7^2/I21,$B$7,$B$5,$B$6,$B$10,$B$11)","v":501.81818181835575},{"$f":"BlackScholesDigital($B$7^2/I21,$B$7,$B$5,$B$6,$B$10,$B$11)","v":0.9999999999489374}]
[12,{"$f":"IF(A22>$B$7,C22-(A22/$B$7)^(1-$B$13)*D22,0)","v":0},{"$f":"BlackScholesPrice(A22,$B$4,$B$5,$B$6,$B$10,$B$11)","v":1.7733665507679123E-10},{"$f":"BlackScholesPrice($B$7^2/A22,$B$4,$B$5,$B$6,$B$10,$B$11)","v":453.3333333345156},null,null,null,null,12,{"$f":"IF(I22<$B$7,0,L22+($B$7-$B$4)*M22-(I22/$B$7)^(1-$B$13)*(N22+($B$7-$B$4)*O22))","v":0},{"$f":"BlackScholesPrice(I22,$B$4,$B$5,$B$6,$B$10,$B$11)","v":1.7733665507679123E-10},{"$f":"BlackScholesPrice(I22,$B$7,$B$5,$B$6,$B$10,$B$11)","v":1.7733665507679123E-10},{"$f":"BlackScholesDigital(I22,$B$7,$B$5,$B$6,$B$10,$B$11)","v":4.7805306219093027E-11},{"$f":"BlackScholesPrice($B$7^2/I22,$B$7,$B$5,$B$6,$B$10,$B$11)","v":453.3333333345156},{"$f":"BlackScholesDigital($B$7^2/I22,$B$7,$B$5,$B$6,$B$10,$B$11)","v":0.99999999966651987}]
[13,0,1.0433546447286362E-9,412.30769231411296,null,null,null,null,13,0,1.0433546447286362E-9,1.0433546447286362E-9,2.7015811481648621E-10,412.30769231411296,0.99999999825723052]
[14,0,5.0659241296255277E-9,377.1428571718053,null,null,null,null,14,0,5.0659241296255277E-9,5.0659241296255277E-9,1.2619795643638955E-9,377.1428571718053,0.99999999242683646]
[15,0,2.0932853839093693E-8,346.66666677830858,null,null,null,null,15,0,2.0932853839093693E-8,2.0932853839093693E-8,5.0238577086719135E-9,346.66666677830858,0.99999997181056866]
[16,0,7.5418097254991383E-8,320.00000037709049,null,null,null,null,16,0,7.5418097254991383E-8,7.5418097254991383E-8,1.7459531256732693E-8,320.00000037709049,0.99999990798871263]
[17,0,2.4157000513867595E-7,296.4705893720942,null,null,null,null,17,0,2.4157000513867595E-7,2.4157000513867595E-7,5.400313661992388E-8,296.4705893720942,0.99999973165759204]
[18,0,6.9885980086639767E-7,275.55555866159909,null,null,null,null,18,0,6.9885980086639767E-7,6.9885980086639767E-7,1.5100934306504864E-7,275.55555866159909,0.99999929002181964]
[19,0,1.8499354963745559E-6,256.84211305235999,null,null,null,null,19,0,1.8499354963745559E-6,1.8499354963745559E-6,3.8670770759964982E-7,256.84211305235999,0.99999827439199451]
[20,0,4.5292822546913739E-6,240.00001811712903,null,null,null,null,20,0,4.5292822546913739E-6,4.5292822546913739E-6,9.1665324857543551E-7,240.00001811712903,0.99999610692289298]
[21,0,1.035000325198351E-5,224.76194419048858,null,null,null,null,21,0,1.035000325198351E-5,1.035000325198351E-5,2.0294112478736876E-6,224.76194419048858,0.99999177605223422]
[22,0,2.2244212998325296E-5,210.90917179713821,null,null,null,null,22,0,2.2244212998325296E-5,2.2244212998325296E-5,4.2284058180711912E-6,210.90917179713821,0.99998361287825255]
[23,0,4.5258096136927499E-5,198.26102698468222,null,null,null,null,23,0,4.5258096136927499E-5,4.5258096136927499E-5,8.3452121441368341E-6,198.26102698468222,0.99996900543184053]
[24,0,8.7662672015699451E-5,186.66695887557339,null,null,null,null,24,0,8.7662672015699451E-5,8.7662672015699451E-5,1.5687978957626345E-5,186.66695887557339,0.99994405412547394]
[25,0,1.6243447075314879E-4,176.00051979030641,null,null,null,null,25,0,1.6243447075314879E-4,1.6243447075314879E-4,2.8226184737963751E-5,176.00051979030641,0.99990317883000834]
[26,0,2.8914629451150015E-4,166.15473583475236,null,null,null,null,26,0,2.8914629451150015E-4,2.8914629451150015E-4,4.8809766259142312E-5,166.15473583475236,0.99983869509249068]
[27,0,4.9628759836360485E-4,157.03850751880995,null,null,null,null,27,0,4.9628759836360485E-4,4.9628759836360485E-4,8.1417138869960409E-5,157.03850751880995,0.99974038301081625]
[28,0,8.2400825369657654E-4,148.57378288072488,null,null,null,null,28,0,8.2400825369657654E-4,8.2400825369657654E-4,1.3142314618865814E-4,148.57378288072488,0.99959507643040035]
[29,0,1.3272506936010489E-3,140.69331655363752,null,null,null,null,29,0,1.3272506936010489E-3,1.3272506936010489E-3,2.0587492677062987E-4,140.69331655363752,0.99938630190223277]
[30,0,2.0792061855180407E-3,133.33887788316139,null,null,null,null,30,0,2.0792061855180407E-3,2.0792061855180407E-3,3.1376140638648422E-4,133.33887788316139,0.99909399604345206]
[31,0,3.1750037686722674E-3,126.45980646133849,null,null,null,null,31,0,3.1750037686722674E-3,3.1750037686722674E-3,4.6626086004150809E-4,126.45980646133849,0.99869432669122604]
[32,0,4.7355175110556178E-3,120.01183879377764,null,null,null,null,32,0,4.7355175110556178E-3,4.7355175110556178E-3,6.7695086177355166E-4,120.01183879377764,0.99815963792334561]
[33,0,6.9111609770525998E-3,113.95614826903528,null,null,null,null,33,0,6.9111609770525998E-3,6.9111609770525998E-3,9.6196595384171878E-4,113.95614826903528,0.99745853220350333]
[34,0,9.8855283232632714E-3,108.25855418429003,null,null,null,null,34,0,9.8855283232632714E-3,9.8855283232632714E-3,1.3400904114001153E-3,108.25855418429003,0.9965560952577861]
[35,0,1.387873975528039E-2,102.88886569086921,null,null,null,null,35,0,1.387873975528039E-2,1.387873975528039E-2,1.8327763594462869E-3,102.88886569086921,0.99541426147111478]
[36,0,1.9150355037357632E-2,97.82033412230524,null,null,null,null,36,0,1.9150355037357632E-2,1.9150355037357632E-2,2.4640809651868241E-3,97.82033412230524,0.99399231021521384]
[37,0,2.6001731651075152E-2,93.029192933299626,null,null,null,null,37,0,2.6001731651075152E-2,2.6001731651075152E-2,3.2605202056628486E-3,93.029192933299626,0.99224747707826755]
[38,0,3.4777722922542609E-2,88.494268890363244,null,null,null,null,38,0,3.4777722922542609E-2,3.4777722922542609E-2,4.2508405257450739E-3,88.494268890363244,0.99013565881625931]
[39,0,4.5867634572845428E-2,84.196651558098168,null,null,null,null,39,0,4.5867634572845428E-2,4.5867634572845428E-2,5.4657133100862185E-3,84.196651558098168,0.98761218719539123]
[40,0,5.9705384148237284E-2,80.119410768296476,null,null,null,null,40,0,5.9705384148237284E-2,5.9705384148237284E-2,6.9373602916126421E-3,80.119410768296476,0.98463264481306878]
[41,0,7.6768835102799138E-2,76.247353824590817,null,null,null,null,41,0,7.6768835102799138E-2,7.6768835102799138E-2,8.6991206579926043E-3,76.247353824590817,0.98115369542092179]
[42,0,9.7578304484758904E-2,72.566815818066203,null,null,null,null,42,0,9.7578304484758904E-2,9.7578304484758904E-2,1.0784972600754717E-2,72.566815818066203,0.9771339020822587]
[43,0,0.12269426894662946,69.065477709668144,null,null,null,null,43,0,0.12269426894662946,0.12269426894662946,1.3229023337033867E-2,69.065477709668144,0.97253450846722467]
[44,0,0.15271431711959813,65.732207849308381,null,null,null,null,44,0,0.15271431711959813,0.15271431711959813,1.6064982226337718E-2,65.732207849308381,0.96732016147212241]
[45,0,0.18826941648329959,62.55692340708142,null,null,null,null,45,0,0.18826941648329959,0.18826941648329959,1.9325631548408377E-2,62.55692340708142,0.96145955688097851]
[46,0,0.23001957920537863,59.530468833400661,null,null,null,null,46,0,0.23001957920537863,0.23001957920537863,2.304230887701712E-2,59.530468833400661,0.95492599370941844]
[47,0,0.27864902375110046,56.644508976597621,null,null,null,null,47,0,0.27864902375110046,0.27864902375110046,2.7244413872215805E-2,56.644508976597621,0.94769782694620497]
[48,0,0.33486093732456845,53.891434895540961,null,null,null,null,48,0,0.33486093732456845,0.33486093732456845,3.195895082502398E-2,53.891434895540961,0.93975881243069814]
[49,0,0.39937194853935404,51.26428073230916,null,null,null,null,49,0,0.39937194853935404,0.39937194853935404,3.7210116531690457E-2,51.26428073230916,0.93109834140664105]
[50,0,0.47290642041624864,48.756650272665993,null,null,null,null,50,0,0.47290642041624864,0.47290642041624864,4.3018941154075431E-2,48.756650272665993,0.92171156574515434]
[51,0,0.55619067126716959,46.362652033360263,null,null,null,null,51,0,0.55619067126716959,0.55619067126716959,4.9402987734571489E-2,46.362652033360263,0.91159941784249232]
[52,0,0.64994722571695451,44.076841885718402,null,null,null,null,52,0,0.64994722571695451,0.64994722571695451,5.637611406274199E-2,44.076841885718402,0.90076853171660942]
[53,0,0.75488919054658454,41.894172363089183,null,null,null,null,53,0,0.75488919054658454,0.75488919054658454,6.394829870712436E-2,41.894172363089183,0.88923107382798994]
[54,0,0.87171484073011862,39.809947912192762,null,null,null,null,54,0,0.87171484073011862,0.87171484073011862,7.2125531285300942E-2,39.809947912192762,0.87700449363788535]
[55,0,1.0011024904860188,37.819785440706937,null,null,null,null,55,0,1.0011024904860188,1.0011024904860188,8.0909765489666913E-2,37.819785440706937,0.86411120491528415]
[56,0,1.1437057128424299,35.919579589774898,null,null,null,null,56,0,1.1437057128424299,1.1437057128424299,9.029893204279392E-2,35.919579589774898,0.85057820935239392]
[57,0,1.3001489595507711,34.105472223930896,null,null,null,null,57,0,1.3001489595507711,1.3001489595507711,0.10028700763990768,34.105472223930896,0.83643667419748446]
[58,0,1.4710236215437777,32.373825684887962,null,null,null,null,58,0,1.4710236215437777,1.4710236215437777,0.11086413505098611,32.373825684887962,0.82172147542029883]
[59,0,1.6568845588364478,30.721199401812129,null,null,null,null,59,0,1.6568845588364478,1.6568845588364478,0.12201678889657859,30.721199401812129,0.80647071744808918]
[60,0,1.8582471180646905,29.144329490752938,null,null,null,null,60,0,1.8582471180646905,1.8582471180646905,0.13372798116775822,29.144329490752938,0.79072523980857756]
[61,0,2.0755846459437182,27.640111011073728,null,null,null,null,61,0,2.0755846459437182,2.0755846459437182,0.14597750031444201,27.640111011073728,0.77452812014591677]
[62,0,2.3093264979475436,26.205582577996836,null,null,null,null,62,0,2.3093264979475436,2.3093264979475436,0.15874217765672288,26.205582577996836,0.75792418208894552]
[63,0,2.5598565335564603,24.837913058484396,null,null,null,null,63,0,2.5598565335564603,2.5598565335564603,0.17199617495771691,24.837913058484396,0.74095951539406624]
[64,0,2.8275120825390014,23.534390103173756,null,null,null,null,64,0,2.8275120825390014,2.8275120825390014,0.18571128720960708,23.534390103173756,0.72368101469831936]
[65,0,3.112583360942546,22.292410290390837,null,null,null,null,65,0,3.112583360942546,3.112583360942546,0.19985725500295212,22.292410290390837,0.70613594213571207]
[66,0,3.4153133107424045,21.109470679687764,null,null,null,null,66,0,3.4153133107424045,3.4153133107424045,0.2144020812497133,21.109470679687764,0.688371518019402]
[67,0,3.735897833400176,19.983161592119625,null,null,null,null,67,0,3.735897833400176,3.735897833400176,0.22931234749102697,19.983161592119625,0.67043454279578618]
[68,0,4.0744863848456134,18.91116045275956,null,null,null,null,68,0,4.0744863848456134,4.0744863848456134,0.24455352552167953,18.91116045275956,0.65237105255029437]
[69,0,4.4311828975459582,17.891226547879373,null,null,null,null,69,0,4.4311828975459582,4.4311828975459582,0.26009028058680461,17.891226547879373,0.6342260095001403]
[70,0,4.8060469942768229,16.921196564887794,null,null,null,null,70,0,4.8060469942768229,4.8060469942768229,0.27588676293715059,16.921196564887794,0.61604302815358758]
[71,0,5.1990954578686859,15.998980797598527,null,null,null,null,71,0,5.1990954578686859,5.1990954578686859,0.29190688505435525,15.998980797598527,0.59786413715187148]
[72,0,5.6103039214797734,15.122559912755303,null,null,null,null,72,0,5.6103039214797734,5.6103039214797734,0.30811458236626543,15.122559912755303,0.57972957623915278]
[73,0,6.0396087447485023,14.289982186025743,null,null,null,null,73,0,6.0396087447485023,6.0396087447485023,0.32447405575594912,14.289982186025743,0.56167762732569271]
[74,0,6.4869090424171523,13.499361126937465,null,null,null,null,74,0,6.4869090424171523,6.4869090424171523,0.34094999462013731,13.499361126937465,0.54374447821583605]
[75,0,6.9520688336094292,12.748873422516716,null,null,null,null,75,0,6.9520688336094292,6.9520688336094292,0.35750777964873098,12.748873422516716,0.52596411725989456]
[76,{"$f":"IF(A86>$B$7,C86-(A86/$B$7)^(1-$B$13)*D86,0)","v":0},{"$f":"BlackScholesPrice(A86,$B$4,$B$5,$B$6,$B$10,$B$11)","v":7.4349192818106413},{"$f":"BlackScholesPrice($B$7^2/A86,$B$4,$B$5,$B$6,$B$10,$B$11)","v":12.036757138748044},null,null,null,null,76,{"$f":"IF(I86<$B$7,0,L86+($B$7-$B$4)*M86-(I86/$B$7)^(1-$B$13)*(N86+($B$7-$B$4)*O86))","v":0},{"$f":"BlackScholesPrice(I86,$B$4,$B$5,$B$6,$B$10,$B$11)","v":7.4349192818106413},{"$f":"BlackScholesPrice(I86,$B$7,$B$5,$B$6,$B$10,$B$11)","v":7.4349192818106413},{"$f":"BlackScholesDigital(I86,$B$7,$B$5,$B$6,$B$10,$B$11)","v":0.37411366487365777},{"$f":"BlackScholesPrice($B$7^2/I86,$B$7,$B$5,$B$6,$B$10,$B$11)","v":12.036757138748044},{"$f":"BlackScholesDigital($B$7^2/I86,$B$7,$B$5,$B$6,$B$10,$B$11)","v":0.50836825695127308}]
[77,0,7.9352609976679958,11.361310127447268,null,null,null,null,77,0,7.9352609976679958,7.9352609976679958,0.39073493887110045,11.361310127447268,0.49098628432005142]
[78,0,8.4528663789370562,10.7208885937816,null,null,null,null,78,0,8.4528663789370562,8.4528663789370562,0.4073400652954926,10.7208885937816,0.47384523586440452]
[79,0,8.9874819641915558,10.113905786523102,null,null,null,null,79,0,8.9874819641915558,8.9874819641915558,0.42389880317719658,10.113905786523102,0.45696979470421173]
[80,0,9.5388307792388005,9.5388307792388005,null,null,null,null,80,0,9.5388307792388005,9.5388307792388005,0.4403823076297575,9.5388307792388005,0.4403823076297575]
[81,1.0000000000000018,10.106614657499136,8.9941873160485279,null,null,null,null,81,1.0000000000000018,10.106614657499136,10.106614657499136,0.45676321178900914,8.9941873160485279,0.42410281974543362]
[82,2.0000000000000107,10.690516517881218,8.4785527003719103,null,null,null,null,82,2.0000000000000107,10.690516517881218,10.690516517881218,0.47301569094746165,8.4785527003719103,0.40814912446733953]
[83,2.9999999999999929,11.290202585885325,7.9905567092870671,null,null,null,null,83,2.9999999999999929,11.290202585885325,11.290202585885325,0.48911550995605985,7.9905567092870671,0.3925368267184326]
[84,3.9999999999999911,11.905324545772274,7.5288805197831259,null,null,null,null,84,3.9999999999999911,11.905324545772274,11.905324545772274,0.50504005504446114,7.5288805197831259,0.37727941726989084]
[85,4.9999999999999991,12.535521613627845,7.0922556363556195,null,null,null,null,85,4.9999999999999991,12.535521613627845,12.535521613627845,0.52076835126347409,7.0922556363556195,0.36238835629757915]
[86,6.0000000000000036,13.180422523018809,6.6794628121105166,null,null,null,null,86,6.0000000000000036,13.180422523018809,13.180422523018809,0.53628106678222898,6.6794628121105166,0.34787316435352189]
[87,7.0000000000000027,13.839647416668543,6.2893309578561292,null,null,null,null,87,7.0000000000000027,13.839647416668543,13.839647416668543,0.55156050528102718,6.2893309578561292,0.33374151909022154]
[88,7.9999999999999929,14.512809639171362,5.9207360356103349,null,null,null,null,88,7.9999999999999929,14.512809639171362,14.512809639171362,0.56659058767149073,5.9207360356103349,0.31999935621715225]
[89,9,15.199517427214545,5.572599934574872,null,null,null,null,89,9,15.199517427214545,15.199517427214545,0.58135682435133551,5.572599934574872,0.30665097331099589]
[90,9.9999999999999947,15.899375495084721,5.243889328964201,null,null,null,null,90,9.9999999999999947,15.899375495084721,15.899375495084721,0.59584627916439048,5.243889328964201,0.29369913524182273]
[91,10.999999999999986,16.611986514404485,4.9336145181578024,null,null,null,null,91,10.999999999999986,16.611986514404485,16.611986514404485,0.61004752618970681,4.9336145181578024,0.28114518011449413]
[92,11.999999999999993,17.336952488078779,4.6408282505032936,null,null,null,null,92,11.999999999999993,17.336952488078779,17.336952488078779,0.62395060042893424,4.6408282505032936,0.26898912475659198]
[93,12.999999999999993,18.073876019336449,4.3646245327625435,null,null,null,null,93,12.999999999999993,18.073876019336449,18.073876019336449,0.63754694340048723,4.3646245327625435,0.25722976890994154]
[94,14.000000000000011,18.822361477535058,4.1041374276894018,null,null,null,null,94,14.000000000000011,18.822361477535058,18.822361477535058,0.65082934458412933,4.1041374276894018,0.24586479740143202]
[95,15.000000000000004,19.582016063065083,3.8585398425811208,null,null,null,null,95,15.000000000000004,19.582016063065083,19.582016063065083,0.66379187959198915,3.8585398425811208,0.23489087967974506]
[96,16,20.352450774251452,3.6270423118762087,null,null,null,null,96,16,20.352450774251452,20.352450774251452,0.67642984587298338,3.6270423118762087,0.22430376620739459]
[97,17.000000000000004,21.133281279612209,3.408891776999758,null,null,null,null,97,17.000000000000004,21.133281279612209,21.133281279612209,0.68873969668833657,3.408891776999758,0.21409838129196759]
[98,18,21.924128699207465,3.2033703666999718,null,null,null,null,98,18,21.924128699207465,21.924128699207465,0.70071897402726169,3.2033703666999718,0.20426891202664907]
[99,19,22.724620299100959,3.0097941810916851,null,null,null,null,99,19,22.724620299100959,22.724620299100959,0.712366241064738,3.0097941810916851,0.194808893088081]
[100,20.000000000000004,23.534390103173756,2.8275120825390014,null,null,null,null,100,20.000000000000004,23.534390103173756,23.534390103173756,0.72368101469831936,2.8275120825390014,0.18571128720960708]
[101,21,24.353079426679201,2.6559044963795668,null,null,null,null,101,21,24.353079426679201,24.353079426679201,0.73466369863853942,2.6559044963795668,0.17696856121027374]
[102,21.999999999999993,25.180337336020052,2.4943822243294589,null,null,null,null,102,21.999999999999993,25.180337336020052,25.180337336020052,0.74531551746817049,2.4943822243294589,0.16857275751496373]
[103,23.000000000000014,26.015821039268609,2.3423852732183268,null,null,null,null,103,23.000000000000014,26.015821039268609,26.015821039268609,0.75563845202960134,2.3423852732183268,0.16051556114915819]
[104,24.000000000000011,26.859196211945797,2.1993817014967592,null,null,null,null,104,24.000000000000011,26.859196211945797,26.859196211945797,0.76563517644714629,2.1993817014967592,0.15278836223348563]
[105,25.000000000000011,27.710137262531948,2.064866485738619,null,null,null,null,105,25.000000000000011,27.710137262531948,27.710137262531948,0.77530899704229572,2.064866485738619,0.14538231403889898]
[106,26,28.568327542105159,1.9383604091359696,null,null,null,null,106,26,28.568327542105159,28.568327542105159,0.78466379335481629,1.9383604091359696,0.13828838669348623]
[107,27.000000000000004,29.43345950239955,1.8194089737566714,null,null,null,null,107,27.000000000000004,29.43345950239955,29.43345950239955,0.79370396144121258,1.8194089737566714,0.13149741665704148]
[108,28.000000000000007,30.305234806448993,1.7075813381103604,null,null,null,null,108,28.000000000000007,30.305234806448993,30.305234806448993,0.80243435958429687,1.7075813381103604,0.12500015210006724]
[109,29.000000000000004,31.18336439583631,1.6024692813477475,null,null,null,null,109,29.000000000000004,31.18336439583631,31.18336439583631,0.81086025651341598,1.6024692813477475,0.11878729434027915]
[110,30,32.067568518408606,1.5036861952062581,null,null,null,null,110,30,32.067568518408606,32.067568518408606,0.81898728220410655,1.5036861952062581,0.11284953550238971]
[111,30.999999999999989,32.957576720148545,1.4108661046115727,null,null,null,null,111,30.999999999999989,32.957576720148545,32.957576720148545,0.82682138129845251,1.4108661046115727,0.10717759257635354]
[112,32,33.853127804712649,1.3236627176518909,null,null,null,null,112,32,33.853127804712649,33.853127804712649,0.83436876916304481,1.3236627176518909,0.10176223805574795]
[113,33.000000000000007,34.753969763963759,1.2417485054610657,null,null,null,null,113,33.000000000000007,34.753969763963759,34.753969763963759,0.8416358905800041,1.2417485054610657,9.6594327341910813E-2]
[114,34,35.65985968263869,1.1648138123780261,null,null,null,null,114,34,35.65985968263869,35.65985968263869,0.8486293810478327,1.1648138123780261,9.1664823101181528E-2]
[115,34.999999999999993,36.570563620103869,1.0925659965940022,null,null,null,null,115,34.999999999999993,36.570563620103869,36.570563620103869,0.85535603065274146,1.0925659965940022,8.6964816762406957E-2]
[116,35.999999999999993,37.485856471966073,1.0247286013559187,null,null,null,null,116,35.999999999999993,37.485856471966073,37.485856471966073,0.86182275045733003,1.0247286013559187,8.248554734006476E-2]
[117,37,38.40552181412113,0.96104055666402111,null,null,null,null,117,37,38.40552181412113,38.40552181412113,0.86803654134192199,0.96104055666402111,7.8218417765171841E-2]
[118,37.999999999999993,39.32935173164347,0.90125541128371356,null,null,null,null,118,37.999999999999993,39.32935173164347,39.32935173164347,0.87400446522426323,0.90125541128371356,7.4155008901825983E-2]
[119,39,40.257146634744352,0.8451405947861198,null,null,null,null,119,39,40.257146634744352,40.257146634744352,0.8797336185755098,0.8451405947861198,7.0287091421973674E-2]
[120,40,41.188715063856236,0.79247670923748914,null,null,null,null,120,40,41.188715063856236,41.188715063856236,0.88523110814429185,0.79247670923748914,6.6606635705003539E-2]
[121,41.000000000000007,42.123873485738457,0.7430568500750081,null,null,null,null,121,41.000000000000007,42.123873485738457,42.123873485738457,0.8905040287959598,0.7430568500750081,6.3105819922188125E-2]
[122,42.000000000000007,43.062446082341808,0.6966859556339684,null,null,null,null,122,42.000000000000007,43.062446082341808,43.062446082341808,0.8955594433707631,0.6966859556339684,5.9777036458993064E-2]
[123,43.000000000000007,44.004264534020933,0.65318018472905881,null,null,null,null,123,43.000000000000007,44.004264534020933,44.004264534020933,0.90040436446251348,0.65318018472905881,5.6612896820959303E-2]
[124,44.000000000000007,44.94916779854109,0.61236632163941029,null,null,null,null,124,44.000000000000007,44.94916779854109,44.94916779854109,0.9050457380181165,0.61236632163941029,5.3606235161367692E-2]
[125,45.000000000000007,45.897001887191728,0.574081207802703,null,null,null,null,125,45.000000000000007,45.897001887191728,45.897001887191728,0.90949042865808349,0.574081207802703,5.075011056129277E-2]
[126,46,46.847619639192082,0.53817119948703429,null,null,null,null,126,46,46.847619639192082,46.847619639192082,0.913745206618647,0.53817119948703429,4.8037808185048894E-2]
[127,47.000000000000007,47.800880495455402,0.50449165068056556,null,null,null,null,127,47.000000000000007,47.800880495455402,47.800880495455402,0.91781673621727755,0.50449165068056556,4.5462839426475561E-2]
[128,47.999999999999993,48.756650272665993,0.47290642041624864,null,null,null,null,128,47.999999999999993,48.756650272665993,48.756650272665993,0.92171156574515434,0.47290642041624864,4.3018941154075431E-2]
[129,49.000000000000007,49.714800938519573,0.44328740373306402,null,null,null,null,129,49.000000000000007,49.714800938519573,49.714800938519573,0.92543611869236198,0.44328740373306402,4.0700074155747855E-2]
[130,49.999999999999993,50.675210388879592,0.41551408546436641,null,null,null,null,130,49.999999999999993,50.675210388879592,50.675210388879592,0.92899668621421694,0.41551408546436641,3.8500420876792708E-2]
[131,50.999999999999993,51.637762227512681,0.38947311603828322,null,null,null,null,131,50.999999999999993,51.637762227512681,51.637762227512681,0.93239942075006554,0.38947311603828322,3.6414382538031045E-2]
[132,52,52.602345548982008,0.3650579084739447,null,null,null,null,132,52,52.602345548982008,52.602345548982008,0.93565033070909998,0.3650579084739447,3.4436575714318046E-2]
[133,52.999999999999993,53.5688547252009,0.34216825575994536,null,null,null,null,133,52.999999999999993,53.5688547252009,53.5688547252009,0.93875527614113163,0.34216825575994536,3.2561828447432793E-2]
[134,54,54.537189196077939,0.32070996780772471,null,null,null,null,134,54,54.537189196077939,54.537189196077939,0.94171996531379798,0.32070996780772471,3.0785175961330031E-2]
[135,55,55.507253264619202,0.30059452718175123,null,null,null,null,135,55,55.507253264619202,55.507253264619202,0.94454995212131732,0.30059452718175123,2.9101856042040065E-2]
[136,55.999999999999993,56.478955896794623,0.28173876282036903,null,null,null,null,136,55.999999999999993,56.478955896794623,56.478955896794623,0.94725063425358536,0.28173876282036903,2.7507304139106917E-2]
[137,57,57.452210526420146,0.26406454097526821,null,null,null,null,137,57,57.452210526420146,57.452210526420146,0.94982725205812513,0.26406454097526821,2.5997148240363786E-2]
[138,57.999999999999993,58.426934865258779,0.24749847261378949,null,null,null,null,138,57.999999999999993,58.426934865258779,58.426934865258779,0.95228488803108946,0.24749847261378949,2.4567203567058403E-2]
[139,58.999999999999993,59.403050718498413,0.23197163654585426,null,null,null,null,139,58.999999999999993,59.403050718498413,59.403050718498413,0.95462846687718139,0.23197163654585426,2.3213467131849429E-2]
[140,{"$f":"IF(A150>$B$7,C150-(A150/$B$7)^(1-$B$13)*D150,0)","v":59.999999999999993},{"$f":"BlackScholesPrice(A150,$B$4,$B$5,$B$6,$B$10,$B$11)","v":60.380483805724062},{"$f":"BlackScholesPrice($B$7^2/A150,$B$4,$B$5,$B$6,$B$10,$B$11)","v":0.21741931755661004},null,null,null,null,140,{"$f":"IF(I150<$B$7,0,L150+($B$7-$B$4)*M150-(I150/$B$7)^(1-$B$13)*(N150+($B$7-$B$4)*O150))","v":59.999999999999993},{"$f":"BlackScholesPrice(I150,$B$4,$B$5,$B$6,$B$10,$B$11)","v":60.380483805724062},{"$f":"BlackScholesPrice(I150,$B$7,$B$5,$B$6,$B$10,$B$11)","v":60.380483805724062},{"$f":"BlackScholesDigital(I150,$B$7,$B$5,$B$6,$B$10,$B$11)","v":0.95686275608195104},{"$f":"BlackScholesPrice($B$7^2/I150,$B$7,$B$5,$B$6,$B$10,$B$11)","v":0.21741931755661004},{"$f":"BlackScholesDigital($B$7^2/I150,$B$7,$B$5,$B$6,$B$10,$B$11)","v":2.1932112197998881E-2}]
[141,61.000000000000007,61.359163587465837,0.20378075884586183,null,null,null,null,141,61.000000000000007,61.359163587465837,61.359163587465837,0.9589923669434528,0.20378075884586183,2.0719482674169835E-2]
[142,61.999999999999993,62.339023097371296,0.19099892809650773,null,null,null,null,142,61.999999999999993,62.339023097371296,62.339023097371296,0.9610217560136699,0.19099892809650773,1.9572087475599336E-2]
[143,63,63.319998780022068,0.17902029651584275,null,null,null,null,143,63,63.319998780022068,63.319998780022068,0.96295522690343827,0.17902029651584275,1.848659487904105E-2]
[144,64,64.302030334388135,0.16779463021562877,null,null,null,null,144,64,64.302030334388135,64.302030334388135,0.96479693240780318,0.16779463021562877,1.7459826895747335E-2]
[145,65,65.285060562891303,0.15727479331934194,null,null,null,null,145,65,65.285060562891303,65.285060562891303,0.96655087691182506,0.15727479331934194,1.6488753683880614E-2]
[146,66,66.269035226028592,0.14741656220744587,null,null,null,null,146,66,66.269035226028592,66.269035226028592,0.96822091903980312,0.14741656220744587,1.5570488019090126E-2]
[147,67,67.253902902488974,0.13817845033413603,null,null,null,null,147,67,67.253902902488974,67.253902902488974,0.96981077451370501,0.13817845033413603,1.4702279839555257E-2]
[148,68,68.239614854682046,0.12952154307137295,null,null,null,null,148,68,68.239614854682046,68.239614854682046,0.97132401918927525,0.12952154307137295,1.3881510879567174E-2]
[149,69.000000000000014,69.22612489958361,0.12140934205830563,null,null,null,null,149,69.000000000000014,69.22612489958361,69.22612489958361,0.97276409224084481,0.12140934205830563,1.3105689403683339E-2]
[150,70,70.213389284792555,0.11380761855602912,null,null,null,null,150,70,70.213389284792555,70.213389284792555,0.9741342994682769,0.11380761855602912,1.2372445051635258E-2]
[151,71,71.201366569683955,0.10668427532924957,null,null,null,null,151,71,71.201366569683955,71.201366569683955,0.97543781670176444,0.10668427532924957,1.1679523802482682E-2]
[152,71.999999999999986,72.190017511535203,0.10000921659748019,null,null,null,null,152,71.999999999999986,72.190017511535203,72.190017511535203,0.976677693282342,0.10000921659748019,1.1024783064983118E-2]
[153,73,73.179304956496495,9.3754225619081075E-2,null,null,null,null,153,73,73.179304956496495,73.179304956496495,0.9778568555979934,9.3754225619081075E-2,1.0406186899764951E-2]
[154,74,74.169193735271207,8.7892849491539832E-2,null,null,null,null,154,74,74.169193735271207,74.169193735271207,0.97897811065713003,8.7892849491539832E-2,9.8218013776518297E-3]
[155,75,75.159650563368686,8.2400290770937842E-2,null,null,null,null,155,75,75.159650563368686,75.159650563368686,0.9800441496829837,8.2400290770937842E-2,9.2697900773717323E-3]
[156,76,76.15064394578846,7.7253305532539923E-2,null,null,null,null,156,76,76.15064394578846,76.15064394578846,0.98105755171411335,7.7253305532539923E-2,8.7484097248876815E-3]
[157,77.000000000000014,77.142144085993806,7.2430107512762867E-2,null,null,null,null,157,77.000000000000014,77.142144085993806,77.142144085993806,0.98202078719776587,7.2430107512762867E-2,8.2560059757001997E-3]
[158,78,78.134122799031303,6.7910277990532925E-2,null,null,null,null,158,78,78.134122799031303,78.134122799031303,0.98293622156425831,6.7910277990532925E-2,7.7910093406837275E-3]
[159,79,79.12655342865277,6.3674681083151455E-2,null,null,null,null,159,79,79.12655342865277,79.12655342865277,0.98380611877188417,6.3674681083151455E-2,7.3519312553239095E-3]
[160,80,80.119410768296476,5.9705384148237284E-2,null,null,null,null,160,80,80.119410768296476,80.119410768296476,0.98463264481306878,5.9705384148237284E-2,6.9373602916126421E-3]
[161,81.000000000000014,81.112670985785812,5.5985582999156014E-2,null,null,null,null,161,81.000000000000014,81.112670985785812,81.112670985785812,0.98541787117363966,5.5985582999156014E-2,6.5459585113231324E-3]
[162,82,82.106311551604492,5.2499531656542003E-2,null,null,null,null,162,82,82.106311551604492,82.106311551604492,0.98616377823812107,5.2499531656542003E-2,6.1764579589247996E-3]
[163,83,83.100311170610155,4.9232476373084581E-2,null,null,null,null,163,83,83.100311170610155,83.100311170610155,0.986872258634926,4.9232476373084581E-2,5.8276572919985529E-3]
[164,83.999999999999986,84.094649717049521,4.6170593682698768E-2,null,null,null,null,164,83.999999999999986,84.094649717049521,84.094649717049521,0.98754512051620225,4.6170593682698768E-2,5.4984185466724917E-3]
[165,85.000000000000014,85.089308172742037,4.3300932238558805E-2,null,null,null,null,165,85.000000000000014,85.089308172742037,85.089308172742037,0.98818409076789704,4.3300932238558805E-2,5.1876640353103482E-3]
[166,86,86.084268568300658,4.0611358217181953E-2,null,null,null,null,166,86,86.084268568300658,86.084268568300658,0.98879081814634384,4.0611358217181953E-2,4.8943733734448137E-3]
[167,86.999999999999986,87.07951392726271,3.8090504077950352E-2,null,null,null,null,167,86.999999999999986,87.07951392726271,87.07951392726271,0.98936687633834774,3.8090504077950352E-2,4.6175806327512737E-3]
[168,88,88.075028213005965,3.5727720479032568E-2,null,null,null,null,168,88,88.075028213005965,88.075028213005965,0.989913766942357,3.5727720479032568E-2,4.3563716166992563E-3]
[169,89,89.070796278329112,3.3513031161711018E-2,null,null,null,null,169,89,89.070796278329112,89.070796278329112,0.99043292236886371,3.3513031161711018E-2,4.1098812553951999E-3]
[170,89.999999999999986,90.066803817579483,3.1437090625643004E-2,null,null,null,null,170,89.999999999999986,90.066803817579483,90.066803817579483,0.9909257086586748,3.1437090625643004E-2,3.8772911160383683E-3]
[171,91,91.063037321213898,2.949114442755724E-2,null,null,null,null,171,91,91.063037321213898,91.063037321213898,0.99139342821814802,2.949114442755724E-2,3.657827025346535E-3]
[172,92.000000000000014,92.059484032682647,2.7666991945410477E-2,null,null,null,null,172,92.000000000000014,92.059484032682647,92.059484032682647,0.99183732247089085,2.7666991945410477E-2,3.45075680026802E-3]
[173,93,93.056131907530116,2.5956951459013385E-2,null,null,null,null,173,93,93.056131907530116,93.056131907530116,0.99225857442578447,2.5956951459013385E-2,3.2553880832782182E-3]
[174,94,94.052969574609591,2.4353827406706042E-2,null,null,null,null,174,94,94.052969574609591,94.052969574609591,0.9926583111615136,2.4353827406706042E-2,3.0710662785593734E-3]
[175,95,95.049986299312607,2.2850879685765053E-2,null,null,null,null,175,95,95.049986299312607,95.049986299312607,0.9930376062280748,2.2850879685765053E-2,2.897172585379451E-3]
[176,95.999999999999986,96.047171948718187,2.1441794871911481E-2,null,null,null,null,176,95.999999999999986,96.047171948718187,96.047171948718187,0.99339748196598332,2.1441794871911481E-2,2.7331221250178122E-3]
[177,97,97.044516958569716,2.0120659240551338E-2,null,null,null,null,177,97,97.044516958569716,97.044516958569716,0.99373891174412232,2.0120659240551338E-2,2.5783621576299163E-3]
[178,98,98.042012301991406,1.8881933479281514E-2,null,null,null,null,178,98,98.042012301991406,98.042012301991406,0.99406282211737385,1.8881933479281514E-2,2.4323703854982888E-3]
[179,99,99.039649459859945,1.7720428987687213E-2,null,null,null,null,179,99,99.039649459859945,99.039649459859945,0.99437009490533268,1.7720428987687213E-2,2.2946533391811877E-3]
[180,100,100.03742039274991,1.6631285666628172E-2,null,null,null,null,180,100,100.03742039274991,100.03742039274991,0.99466156919355464,1.6631285666628172E-2,2.1647448431428577E-3]
[181,101,101.03531751437511,1.5609951105017316E-2,null,null,null,null,181,101,101.03531751437511,101.03531751437511,0.994938043258906,1.5609951105017316E-2,2.0422045575271505E-3]
[182,101.99999999999999,102.03333366645151,1.4652161077591423E-2,null,null,null,null,182,101.99999999999999,102.03333366645151,102.03333366645151,0.99520027642068931,1.4652161077591423E-2,1.9266165928205458E-3]
[183,103,103.03146209491051,1.3753921272354336E-2,null,null,null,null,183,103,103.03146209491051,103.03146209491051,0.99544899081929916,1.3753921272354336E-2,1.8175881942380403E-3]
[184,104,104.02969642739393,1.2911490171276111E-2,null,null,null,null,184,104,104.02969642739393,104.02969642739393,0.99568487312423526,1.2911490171276111E-2,1.7147484927567435E-3]
[185,105,105.02803065196625,1.2121363012432801E-2,null,null,null,null,185,105,105.02803065196625,105.02803065196625,0.99590857617334871,1.2121363012432801E-2,1.617747319815437E-3]
[186,105.99999999999999,106.02645909698124,1.1380256766129391E-2,null,null,null,null,186,105.99999999999999,106.02645909698124,106.02645909698124,0.99612072054523926,1.1380256766129391E-2,1.5262540827935976E-3]
[187,107,107.02497641204411,1.0685096061653609E-2,null,null,null,null,187,107,107.02497641204411,107.02497641204411,0.9963218960667527,1.0685096061653609E-2,1.4399566984794894E-3]
[188,108,108.02357755001211,1.0033000005153414E-2,null,null,null,null,188,108,108.02357755001211,108.02357755001211,0.9965126632575394,1.0033000005153414E-2,1.3585605818337181E-3]
[189,109,109.02225774997997,9.4212698327950217E-3,null,null,null,null,189,109,109.02225774997997,109.02225774997997,0.99669355471364707,9.4212698327950217E-3,1.2817876874510782E-3]
[190,109.99999999999999,110.02101252119854,8.8473773467579522E-3,null,null,null,null,190,109.99999999999999,110.02101252119854,110.02101252119854,0.99686507643212163,8.8473773467579522E-3,1.2093756012195812E-3]
[191,110.99999999999999,111.01983762787761,8.3089540848657606E-3,null,null,null,null,191,110.99999999999999,111.01983762787761,111.01983762787761,0.99702770907857707,8.3089540848657606E-3,1.1410766797707802E-3]
[192,112,112.01872907482641,7.8037811776719623E-3,null,null,null,null,192,112,112.01872907482641,112.01872907482641,0.9971819091996873,7.8037811776719623E-3,1.0766572354093788E-3]
[193,112.99999999999999,113.01768309388736,7.3297798496844086E-3,null,null,null,null,193,112.99999999999999,113.01768309388736,113.01768309388736,0.99732811038252811,7.3297798496844086E-3,1.0158967643025365E-3]
[194,114,114.01669613112091,6.8850025240857716E-3,null,null,null,null,194,114,114.01669613112091,114.01669613112091,0.9974667243626737,6.8850025240857716E-3,9.5858721579999539E-4]
[195,115,115.01576483470129,6.4676244928331319E-3,null,null,null,null,195,115,115.01576483470129,115.01576483470129,0.99759814208292452,6.4676244928331319E-3,9.0453230084489651E-4]
[196,116.00000000000001,116.01488604348518,6.0759361163930537E-3,null,null,null,null,196,116.00000000000001,116.01488604348518,116.01488604348518,0.99772273470450712,6.0759361163930537E-3,8.5354683752175426E-4]
[197,117,117.01405677621699,5.7083355195919738E-3,null,null,null,null,197,117,117.01405677621699,117.01405677621699,0.99784085457255156,5.7083355195919738E-3,8.0545613187250637E-4]
[198,118,118.01327422133659,5.3633217521581993E-3,null,null,null,null,198,118,118.01327422133659,118.01327422133659,0.99795283613761332,5.3633217521581993E-3,7.6009539219363338E-4]
[199,119,119.01253572735642,5.0394883844919495E-3,null,null,null,null,199,119,119.01253572735642,119.01253572735642,0.99805899683496624,5.0394883844919495E-3,7.1730917510689997E-4]
[200,120,120.01183879377764,4.7355175110556178E-3,null,null,null,null,200,120,120.01183879377764,120.01183879377764,0.99815963792334561,4.7355175110556178E-3,6.7695086177355166E-4]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}