{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["test \"MeineFunktion\"","phi(x) und Phi(x)","Funktion BlackScholesPrice"],"not_rendered":{"charts":1,"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":"test \"MeineFunktion\"","index":0,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Test \"MeinFunktion\""]
[]
[]
["x","f(x)"]
[1,{"$f":"MeineFunktion(A5)","v":1}]
[2,{"$f":"MeineFunktion(A6)","v":4}]
[3,9]
[4,16]
[5,25]
[6,36]
[7,49]
[8,64]
[9,81]
[10,100]
[11,{"$f":"A15^2","v":121},{"$f":"MeineFunktion(A15)","v":121}]

{"sheet":"phi(x) und Phi(x)","index":1,"n_rows":110,"n_cols":4,"rows_kept":110,"cut":false,"hidden":false,"merged":[]}
[]
["phi(x) := 1/sqrt(2*pi) * exp(-x^2/2)"]
["Phi(x) := int_{-infty}^x phi(y) dy"]
[]
["Phi(x) wird auch haeufig mit N(x) bezeichnet, \"N\" fuer \"Normalverteilung\"."]
[]
[null,null,{"$f":"_xlfn.NORM.DIST(A19,0,1,FALSE)","v":8.9261657177132928E-5},{"$f":"_xlfn.NORM.DIST(A19,0,1,TRUE)","v":2.0657506912546714E-5}]
[]
["x","phi(x) von Hand","phi(x) mit Norm.S.Dist","Phi(x) mit Norm.S.Dist"]
[-5,{"$f":"EXP((-1)*A10^2/2)/SQRT(2*PI())","v":1.4867195147342979E-6},{"$f":"_xlfn.NORM.S.DIST(A10,FALSE)","v":1.4867195147342977E-6},{"$f":"_xlfn.NORM.S.DIST(A10,TRUE)","v":2.8665157187919333E-7}]
[-4.9000000000000004,{"$f":"EXP((-1)*A11^2/2)/SQRT(2*PI())","v":2.4389607458933522E-6},{"$f":"_xlfn.NORM.S.DIST(A11,FALSE)","v":2.4389607458933522E-6},{"$f":"_xlfn.NORM.S.DIST(A11,TRUE)","v":4.7918327659031834E-7}]
[-4.8,3.9612990910320753E-6,3.9612990910320753E-6,7.933281519755948E-7]
[-4.7,6.3698251788670899E-6,6.3698251788670899E-6,1.3008074539172773E-6]
[-4.5999999999999996,1.014085206548676E-5,1.0140852065486758E-5,2.1124547025028533E-6]
[-4.5,1.5983741106905478E-5,1.5983741106905475E-5,3.3976731247300535E-6]
[-4.4000000000000004,2.4942471290053535E-5,2.4942471290053535E-5,5.4125439077038416E-6]
[-4.3,3.8535196742087129E-5,3.8535196742087129E-5,8.5399054709917942E-6]
[-4.2,5.8943067756539855E-5,5.8943067756539855E-5,1.3345749015906309E-5]
[-4.0999999999999996,8.9261657177132928E-5,8.9261657177132928E-5,2.0657506912546714E-5]
[-4,1.3383022576488537E-4,1.3383022576488537E-4,3.1671241833119857E-5]
[-3.9,1.9865547139277272E-4,1.9865547139277272E-4,4.8096344017602614E-5]
[-3.8,2.9194692579146027E-4,2.9194692579146027E-4,7.234804392511999E-5]
[-3.7,4.2478027055075143E-4,4.2478027055075143E-4,1.0779973347738824E-4]
[-3.6,6.119019301137719E-4,6.119019301137719E-4,1.5910859015753364E-4]
[-3.5000000000000102,8.7268269504572915E-4,8.7268269504572915E-4,2.3262907903551577E-4]
[-3.4000000000000101,1.2322191684729772E-3,1.2322191684729772E-3,3.3692926567686834E-4]
[-3.30000000000001,1.7225689390536231E-3,1.7225689390536229E-3,4.834241423837595E-4]
[-3.2000000000000099,2.3840882014647662E-3,2.3840882014647662E-3,6.8713793791582453E-4]
[-3.1000000000000099,3.2668190561998202E-3,3.2668190561998202E-3,9.6760321321832314E-4]
[-3.0000000000000102,4.431848411937874E-3,4.431848411937874E-3,1.3498980316300484E-3]
[-2.9000000000000101,5.9525324197756795E-3,5.9525324197756795E-3,1.865813300383974E-3]
[-2.80000000000001,7.915451582979743E-3,7.915451582979743E-3,2.5551303304278523E-3]
[-2.7000000000000099,1.0420934814422319E-2,1.0420934814422318E-2,3.4669738030405624E-3]
[-2.6000000000000099,1.3582969233685271E-2,1.3582969233685271E-2,4.6611880237186157E-3]
[-2.5000000000000102,1.7528300493568086E-2,1.7528300493568086E-2,6.2096653257759519E-3]
[-2.4000000000000101,2.2394530294842355E-2,2.2394530294842355E-2,8.1975359245958987E-3]
[-2.30000000000001,2.8327037741600516E-2,2.8327037741600516E-2,1.0724110021675514E-2]
[-2.2000000000000099,3.5474592846230668E-2,3.5474592846230668E-2,1.3903447513498252E-2]
[-2.1000000000000099,4.3983595980426296E-2,4.3983595980426296E-2,1.7864420562816112E-2]
[-2.0000000000000102,5.3990966513186953E-2,5.3990966513186953E-2,2.2750131948178647E-2]
[-1.9000000000000099,6.561581477467536E-2,6.561581477467536E-2,2.8716559816001137E-2]
[-1.80000000000001,7.8950158300892734E-2,7.8950158300892734E-2,3.5930319112924998E-2]
[-1.7000000000000099,9.4049077376885351E-2,9.4049077376885337E-2,4.4565462758542097E-2]
[-1.6000000000000101,0.11092083467945378,0.11092083467945377,5.479929169955685E-2]
[-1.50000000000001,0.1295175956658898,0.1295175956658898,6.6807201268856753E-2]
[-1.4000000000000099,0.1497274656357428,0.1497274656357428,8.0756659233769554E-2]
[-1.30000000000001,0.17136859204780513,0.17136859204780513,9.6800484585608582E-2]
[-1.2000000000000099,0.19418605498321065,0.19418605498321065,0.11506967022170632]
[-1.1000000000000101,0.21785217703254817,0.21785217703254814,0.13566606094638042]
[-1.00000000000001,0.24197072451914095,0.24197072451914092,0.15865525393145458]
[-0.90000000000001001,0.26608524989875243,0.26608524989875243,0.18406012534675684]
[-0.80000000000001004,0.28969155276148045,0.2896915527614804,0.21185539858339378]
[-0.70000000000002005,0.31225393336675689,0.31225393336675689,0.24196365222306665]
[-0.60000000000001996,0.33322460289179567,0.33322460289179567,0.27425311775006689]
[-0.50000000000001998,0.35206532676429597,0.35206532676429597,0.30853753872597978]
[-0.40000000000002001,0.36827014030332039,0.36827014030332039,0.34457825838966843]
[-0.30000000000001997,0.38138781546052186,0.38138781546052181,0.38208857781103972]
[-0.20000000000002,0.39104269397545433,0.39104269397545433,0.42074029056088913]
[-0.10000000000002,0.39695254747701103,0.39695254747701098,0.46017216272296307]
[-2.0428103653102899E-14,0.3989422804014327,0.3989422804014327,0.49999999999999184]
[9.9999999999980105E-2,0.39695254747701259,0.39695254747701259,0.53982783727702111]
[0.19999999999998,0.39104269397545749,0.39104269397545749,0.57925970943909522]
[0.29999999999998,0.38138781546052641,0.38138781546052641,0.61791142218894501]
[0.39999999999997998,0.36827014030332628,0.36827014030332628,0.65542174161031674]
[0.49999999999998002,0.35206532676430302,0.35206532676430302,0.69146246127400612]
[0.59999999999997999,0.33322460289180367,0.33322460289180361,0.72574688224991979]
[0.69999999999997997,0.31225393336676566,0.31225393336676566,0.75803634777692075]
[0.79999999999997995,0.28969155276148745,0.28969155276148739,0.78814460141659759]
[0.89999999999998004,0.26608524989875965,0.26608524989875959,0.81593987465323525]
[0.99999999999998002,0.24197072451914819,0.24197072451914819,0.84134474606853815]
[1.0999999999999801,0.21785217703255533,0.21785217703255533,0.864333939053613]
[1.19999999999998,0.19418605498321762,0.19418605498321762,0.88493032977828789]
[1.2999999999999801,0.1713685920478118,0.1713685920478118,0.90319951541438626]
[1.3999999999999799,0.14972746563574907,0.14972746563574907,0.91924334076622594]
[1.49999999999998,{"$f":"EXP((-1)*A75^2/2)/SQRT(2*PI())","v":0.12951759566589563},{"$f":"_xlfn.NORM.S.DIST(A75,FALSE)","v":0.1295175956658956},{"$f":"_xlfn.NORM.S.DIST(A75,TRUE)","v":0.93319279873113936}]
[1.5999999999999801,0.1109208346794591,0.11092083467945908,0.94520070830043978]
[1.69999999999998,9.4049077376890139E-2,9.4049077376890139E-2,0.95543453724145511]
[1.7999999999999801,7.8950158300896994E-2,7.8950158300896994E-2,0.96406968088707268]
[1.8999999999999799,6.5615814774679093E-2,6.5615814774679093E-2,0.97128344018399693]
[1.99999999999998,5.3990966513190221E-2,5.3990966513190221E-2,0.97724986805181968]
[2.0999999999999699,4.3983595980429988E-2,4.3983595980429988E-2,0.9821355794371821]
[2.19999999999997,3.5474592846233791E-2,3.5474592846233791E-2,0.9860965524865003]
[2.2999999999999701,2.8327037741603125E-2,2.8327037741603125E-2,0.98927588997832339]
[2.3999999999999702,2.2394530294844502E-2,2.2394530294844502E-2,0.99180246407540318]
[2.4999999999999698,1.7528300493569862E-2,1.7528300493569862E-2,0.99379033467422329]
[2.5999999999999699,1.3582969233686683E-2,1.3582969233686681E-2,0.99533881197628082]
[2.69999999999997,1.0420934814423442E-2,1.0420934814423442E-2,0.99653302619695905]
[2.7999999999999701,7.9154515829806295E-3,7.9154515829806277E-3,0.9974448696695718]
[2.8999999999999702,5.9525324197763725E-3,5.9525324197763725E-3,0.99813418669961573]
[2.9999999999999698,4.4318484119384091E-3,4.4318484119384082E-3,0.99865010196836979]
[3.0999999999999699,3.2668190562002266E-3,3.2668190562002266E-3,0.99903239678678157]
[3.19999999999997,2.3840882014650711E-3,2.3840882014650711E-3,0.99931286206208403]
[3.2999999999999701,1.722568939053851E-3,1.722568939053851E-3,0.99951657585761622]
[3.3999999999999702,1.2322191684731446E-3,1.2322191684731446E-3,0.99966307073432303]
[3.4999999999999698,8.7268269504585231E-4,8.7268269504585231E-4,0.99976737092096446]
[3.5999999999999699,6.1190193011383879E-4,6.1190193011383879E-4,0.99984089140984245]
[3.69999999999997,4.2478027055079903E-4,4.2478027055079903E-4,0.99989220026652259]
[3.7999999999999701,2.9194692579149345E-4,2.9194692579149345E-4,0.99992765195607491]
[3.8999999999999702,1.9865547139279581E-4,1.9865547139279581E-4,0.99995190365598241]
[3.9999999999999698,1.3383022576490152E-4,1.3383022576490152E-4,0.99996832875816688]
[4.0999999999999703,8.9261657177143716E-5,8.9261657177143702E-5,0.9999793424930874]
[4.19999999999997,5.8943067756547295E-5,5.8943067756547288E-5,0.9999866542509841]
[4.2999999999999696,3.853519674209213E-5,3.8535196742092124E-5,0.99999146009452899]
[4.3999999999999702,2.4942471290056856E-5,2.4942471290056852E-5,0.99999458745609227]
[4.4999999999999698,1.5983741106907633E-5,1.5983741106907633E-5,0.99999660232687526]
[4.5999999999999703,1.0140852065488129E-5,1.0140852065488129E-5,0.9999978875452975]
[4.69999999999997,6.3698251788679954E-6,6.3698251788679954E-6,0.99999869919254614]
[4.7999999999999696,3.961299091032653E-6,3.961299091032653E-6,0.99999920667184805]
[4.8999999999999604,2.4389607458938333E-6,2.4389607458938333E-6,0.99999952081672339]
[4.99999999999996,1.4867195147345937E-6,1.4867195147345937E-6,0.99999971334842808]

{"sheet":"Funktion BlackScholesPrice","index":2,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Black-Scholes Formeln fuer Call- und Put-Optionen"]
[]
["Options-Parameter:"]
["Ausuebungspreis K",90]
["Laufzeit T",4]
["Options-Typ (call/put)","call"]
[]
["Markt-Parameter:"]
["Aktueller Preis des Basiswertes S_0",100]
["Zinssatz r",0.03]
["Volatilitaet sigma",0.2]
[]
["Options-Preis:",{"$f":"BlackScholesPrice(B9,B4,B5,B6,B11,B10)","v":26.50471012596876}]
["Options-Preis aus VBA:",26.50471012596876]