{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Histogram","Black and Scholes"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":1,"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":19,"n_cols":263,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,7,0,8],[3,7,3,8],[0,9,0,10],[4,1,5,1],[7,11,7,12],[1,11,1,12],[2,11,2,12]]}
[null,null,null,null,null,null,null,"Stock Expectations Yearly",null,"Volatility Costants"]
[null,null,null,"Simulations","Periods","Stock Price","Strike"," Volatility","Drift","Constan Theta","Constant K","Daily Free Int. Rate"]
[null,null,null,10,3,100,50,0.4,0.1,1E-3,1E-3,0.05]
[null,"Fair Price",null,null,null,null,null,"Stock Expectations Daily",null,"Day one"]
[null,14.359501334598566,null,null,null,null,null,"Ini. Volatility","Ini. Drift","Exp. Daily Drift"]
[null,null,null,null,null,null,null,{"$f":"H3/SQRT(252)","v":2.5197631533948481E-2},{"$f":"I3/252","v":3.9682539682539683E-4},{"$f":"I6-0.5*H6^2","v":7.9365079365079365E-5}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Nods Per Simulation "]
[null,null,null,"Simulation","N(0,1) Vol","N(0,1) Price","Volatility","Log Return","Stock Price","Payoff",null,1,{"$f":"L9+1","v":2},{"$f":"M9+1","v":3},{"$f":"N9+1","v":4},5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,{"$f":"BZ9+1","v":68},69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,{"$f":"EL9+1","v":132},133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,{"$f":"GX9+1","v":196},197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252]
[null,null,null,1,-0.79147586735084308,-7.5800950027318348E-2,-6.9156586735084305E-2,5.6176252909444797E-3,79.936155472721339,29.936155472721339,null,86.640920501229431,79.488363046713772,79.936155472721339]
[null,null,null,2,0.89057269168445741,0.22555274670601649,9.9048269168445752E-2,2.2554294449523185E-2,88.095924731706333,38.095924731706333,null,86.722984452966415,86.131222823832061,88.095924731706333]
[null,null,null,3,0.20131113841433212,-0.25846377999014325,0.18607389932185145,-5.457101002482035E-2,89.422959070332254,39.422959070332254,null,92.815991091030526,94.438466295846638,89.422959070332254]
[null,null,null,4,0.55135007354050036,0.2780862695487758,6.5126007354050039E-2,1.3403615864478823E-2,80.415633834483131,30.415633834483131,null,80.356697158607091,79.344965015226549,80.415633834483131]
[null,null,null,5,-0.21512457953582165,-0.11992529454718201,-1.1521457953582165E-2,-0.19068137177181327,55.724340236742592,5.7243402367425915,null,80.751891393885359,67.430565645629869,55.724340236742592]
[null,null,null,6,0.27724077786131374,0.27660504279211129,6.9742816583065581E-2,1.9362976418490035E-2,39.276489757002707,0,null,39.218271547581224,38.523295584986748,39.276489757002707]
[null,null,null,7,1.2219572470519968,0.58826611164471587,0.13218672470519968,7.7582299511396585E-2,37.212120582146511,0,null,35.72445209973813,34.434267981776038,37.212120582146511]
[null,null,null,8,0.80189183761277927,0.87114151905672776,9.0180183761277927E-2,6.7610581276439388E-2,41.056790891869156,0,null,37.371427781111535,38.372677031935751,41.056790891869156]
[null,null,null,9,5.2490044846419864E-2,-0.91626495247155759,1.5240004484641988E-2,-1.7983897313831432E-2,34.771988375284117,0,null,36.375678434539914,35.40298109148668,34.771988375284117]
[null,null,null,10,0.45839800208427128,0.55340032843670905,0.30573544370169797,0.16027381358096082,39.073603903627614,0,null,34.285708664570883,33.287213140022494,39.073603903627614]

{"sheet":"Histogram","index":1,"n_rows":131,"n_cols":15,"rows_kept":131,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Settings"]
[null,"Start at",10]
[null,"Increment",10]
[]
[null,null,null,null,null,null,null,null,"Price"]
[null,null,null,null,null,null,null,1,{"$f":"Sheet1!J10","v":29.936155472721339},null,"Lower limit","Upper limit","Class","Frequency","Probability"]
[null,null,null,null,null,null,null,{"$f":"H7+1","v":2},{"$f":"Sheet1!J11","v":38.095924731706333},null,{"$f":"C3","v":10},{"$f":"K8+C$4","v":20},{"$f":"K8&\"   \"&L8","v":"10   20"},{"$f":"COUNTIF($I$7:$I$132,\"<\"&L8)-COUNTIF($I$7:$I$152,\"<\"&K8)","v":0},{"$f":"N8/Sheet1!$D$3","v":0}]
[null,null,null,null,null,null,null,{"$f":"H8+1","v":3},{"$f":"Sheet1!J12","v":39.422959070332254},null,{"$f":"L8","v":20},{"$f":"K9+C$4","v":30},"20   30",1,{"$f":"N9/Sheet1!$D$3","v":0.1}]
[null,null,null,null,null,null,null,4,{"$f":"Sheet1!J13","v":30.415633834483131},null,{"$f":"L9","v":30},{"$f":"K10+C$4","v":40},"30   40",3,{"$f":"N10/Sheet1!$D$3","v":0.3}]
[null,null,null,null,null,null,null,5,{"$f":"Sheet1!J14","v":5.7243402367425915},null,40,{"$f":"K11+C$4","v":50},"40   50",0,{"$f":"N11/Sheet1!$D$3","v":0}]
[null,null,null,null,null,null,null,6,{"$f":"Sheet1!J15","v":0},null,50,{"$f":"K12+C$4","v":60},"50   60",0,{"$f":"N12/Sheet1!$D$3","v":0}]
[null,null,null,null,null,null,null,7,{"$f":"Sheet1!J16","v":0},null,60,{"$f":"K13+C$4","v":70},"60   70",0,{"$f":"N13/Sheet1!$D$3","v":0}]
[null,null,null,null,null,null,null,8,{"$f":"Sheet1!J17","v":0},null,70,{"$f":"K14+C$4","v":80},"70   80",0,{"$f":"N14/Sheet1!$D$3","v":0}]
[null,null,null,null,null,null,null,9,{"$f":"Sheet1!J18","v":0},null,80,{"$f":"K15+C$4","v":90},"80   90",0,{"$f":"N15/Sheet1!$D$3","v":0}]
[null,null,null,null,null,null,null,10,{"$f":"Sheet1!J19","v":0},null,90,{"$f":"K16+C$4","v":100},"90   100",0,{"$f":"N16/Sheet1!$D$3","v":0}]
[null,null,null,null,null,null,null,11,{"$f":"Sheet1!J20","v":0},null,100,{"$f":"K17+C$4","v":110},"100   110",0,{"$f":"N17/Sheet1!$D$3","v":0}]
[null,null,null,null,null,null,null,12,{"$f":"Sheet1!J21","v":0},null,110,{"$f":"K18+C$4","v":120},"110   120",0,{"$f":"N18/Sheet1!$D$3","v":0}]
[null,null,null,null,null,null,null,13,{"$f":"Sheet1!J22","v":0},null,120,{"$f":"K19+C$4","v":130},"120   130",0,{"$f":"N19/Sheet1!$D$3","v":0}]
[null,null,null,null,null,null,null,14,{"$f":"Sheet1!J23","v":0},null,130,{"$f":"K20+C$4","v":140},"130   140",0,{"$f":"N20/Sheet1!$D$3","v":0}]
[null,null,null,null,null,null,null,15,{"$f":"Sheet1!J24","v":0},null,140,{"$f":"K21+C$4","v":150},"140   150",0,{"$f":"N21/Sheet1!$D$3","v":0}]
[null,null,null,null,null,null,null,16,{"$f":"Sheet1!J25","v":0},null,150,{"$f":"K22+C$4","v":160},"150   160",0,{"$f":"N22/Sheet1!$D$3","v":0}]
[null,null,null,null,null,null,null,17,{"$f":"Sheet1!J26","v":0},null,160,{"$f":"K23+C$4","v":170},"160   170",0,{"$f":"N23/Sheet1!$D$3","v":0}]
[null,null,null,null,null,null,null,18,{"$f":"Sheet1!J27","v":0},null,170,{"$f":"K24+C$4","v":180},"170   180",0,{"$f":"N24/Sheet1!$D$3","v":0}]
[null,null,null,null,null,null,null,19,{"$f":"Sheet1!J28","v":0},null,180,{"$f":"K25+C$4","v":190},"180   190",0,{"$f":"N25/Sheet1!$D$3","v":0}]
[null,null,null,null,null,null,null,20,{"$f":"Sheet1!J29","v":0},null,190,{"$f":"K26+C$4","v":200},"190   200",0,{"$f":"N26/Sheet1!$D$3","v":0}]
[null,null,null,null,null,null,null,21,{"$f":"Sheet1!J30","v":0},null,200,{"$f":"K27+C$4","v":210},"200   210",0,{"$f":"N27/Sheet1!$D$3","v":0}]
[null,null,null,null,null,null,null,22,{"$f":"Sheet1!J31","v":0},null,210,{"$f":"K28+C$4","v":220},"210   220",0,{"$f":"N28/Sheet1!$D$3","v":0}]
[null,null,null,null,null,null,null,23,{"$f":"Sheet1!J32","v":0},null,220,{"$f":"K29+C$4","v":230},"220   230",0,{"$f":"N29/Sheet1!$D$3","v":0}]
[null,null,null,null,null,null,null,24,{"$f":"Sheet1!J33","v":0},null,230,{"$f":"K30+C$4","v":240},"230   240",0,{"$f":"N30/Sheet1!$D$3","v":0}]
[null,null,null,null,null,null,null,25,{"$f":"Sheet1!J34","v":0},null,{"$f":"L30","v":240},{"$f":"K31+C$4","v":250},"240   250",0,{"$f":"N31/Sheet1!$D$3","v":0}]
[null,null,null,null,null,null,null,26,{"$f":"Sheet1!J35","v":0},null,250,{"$f":"K32+C$4","v":260},"250   260",0,{"$f":"N32/Sheet1!$D$3","v":0}]
[null,null,null,null,null,null,null,27,{"$f":"Sheet1!J36","v":0},null,260,{"$f":"K33+C$4","v":270},"260   270",0,{"$f":"N33/Sheet1!$D$3","v":0}]
[null,null,null,null,null,null,null,28,{"$f":"Sheet1!J37","v":0},null,270,{"$f":"K34+C$4","v":280},"270   280",0,{"$f":"N34/Sheet1!$D$3","v":0}]
[null,null,null,null,null,null,null,29,{"$f":"Sheet1!J38","v":0},null,{"$f":"L34","v":280},{"$f":"K35+C$4","v":290},"280   290",0,{"$f":"N35/Sheet1!$D$3","v":0}]
[null,null,null,null,null,null,null,30,{"$f":"Sheet1!J39","v":0},null,290,{"$f":"K36+C$4","v":300},"290   300",0,{"$f":"N36/Sheet1!$D$3","v":0}]
[null,null,null,null,null,null,null,31,{"$f":"Sheet1!J40","v":0}]
[null,null,null,null,null,null,null,32,{"$f":"Sheet1!J41","v":0}]
[null,null,null,null,null,null,null,33,{"$f":"Sheet1!J42","v":0}]
[null,null,null,null,null,null,null,34,{"$f":"Sheet1!J43","v":0}]
[null,null,null,null,null,null,null,35,{"$f":"Sheet1!J44","v":0}]
[null,null,null,null,null,null,null,36,{"$f":"Sheet1!J45","v":0}]
[null,null,null,null,null,null,null,37,{"$f":"Sheet1!J46","v":0}]
[null,null,null,null,null,null,null,38,{"$f":"Sheet1!J47","v":0}]
[null,null,null,null,null,null,null,39,{"$f":"Sheet1!J48","v":0}]
[null,null,null,null,null,null,null,40,{"$f":"Sheet1!J49","v":0}]
[null,null,null,null,null,null,null,41,{"$f":"Sheet1!J50","v":0}]
[null,null,null,null,null,null,null,42,{"$f":"Sheet1!J51","v":0}]
[null,null,null,null,null,null,null,43,{"$f":"Sheet1!J52","v":0}]
[null,null,null,null,null,null,null,44,{"$f":"Sheet1!J53","v":0}]
[null,null,null,null,null,null,null,45,{"$f":"Sheet1!J54","v":0}]
[null,null,null,null,null,null,null,46,{"$f":"Sheet1!J55","v":0}]
[null,null,null,null,null,null,null,47,{"$f":"Sheet1!J56","v":0}]
[null,null,null,null,null,null,null,48,{"$f":"Sheet1!J57","v":0}]
[null,null,null,null,null,null,null,49,{"$f":"Sheet1!J58","v":0}]
[null,null,null,null,null,null,null,50,{"$f":"Sheet1!J59","v":0}]
[null,null,null,null,null,null,null,51,{"$f":"Sheet1!J60","v":0}]
[null,null,null,null,null,null,null,52,{"$f":"Sheet1!J61","v":0}]
[null,null,null,null,null,null,null,53,{"$f":"Sheet1!J62","v":0}]
[null,null,null,null,null,null,null,54,{"$f":"Sheet1!J63","v":0}]
[null,null,null,null,null,null,null,55,{"$f":"Sheet1!J64","v":0}]
[null,null,null,null,null,null,null,56,{"$f":"Sheet1!J65","v":0}]
[null,null,null,null,null,null,null,57,{"$f":"Sheet1!J66","v":0}]
[null,null,null,null,null,null,null,58,{"$f":"Sheet1!J67","v":0}]
[null,null,null,null,null,null,null,59,{"$f":"Sheet1!J68","v":0}]
[null,null,null,null,null,null,null,60,{"$f":"Sheet1!J69","v":0}]
[null,null,null,null,null,null,null,61,{"$f":"Sheet1!J70","v":0}]
[null,null,null,null,null,null,null,62,{"$f":"Sheet1!J71","v":0}]
[null,null,null,null,null,null,null,63,{"$f":"Sheet1!J72","v":0}]
[null,null,null,null,null,null,null,64,{"$f":"Sheet1!J73","v":0}]
[null,null,null,null,null,null,null,65,{"$f":"Sheet1!J74","v":0}]
[null,null,null,null,null,null,null,66,{"$f":"Sheet1!J75","v":0}]
[null,null,null,null,null,null,null,{"$f":"H72+1","v":67},{"$f":"Sheet1!J76","v":0}]
[null,null,null,null,null,null,null,68,{"$f":"Sheet1!J77","v":0}]
[null,null,null,null,null,null,null,69,{"$f":"Sheet1!J78","v":0}]
[null,null,null,null,null,null,null,70,{"$f":"Sheet1!J79","v":0}]
[null,null,null,null,null,null,null,71,{"$f":"Sheet1!J80","v":0}]
[null,null,null,null,null,null,null,72,{"$f":"Sheet1!J81","v":0}]
[null,null,null,null,null,null,null,73,{"$f":"Sheet1!J82","v":0}]
[null,null,null,null,null,null,null,74,{"$f":"Sheet1!J83","v":0}]
[null,null,null,null,null,null,null,75,{"$f":"Sheet1!J84","v":0}]
[null,null,null,null,null,null,null,76,{"$f":"Sheet1!J85","v":0}]
[null,null,null,null,null,null,null,77,{"$f":"Sheet1!J86","v":0}]
[null,null,null,null,null,null,null,78,{"$f":"Sheet1!J87","v":0}]
[null,null,null,null,null,null,null,79,{"$f":"Sheet1!J88","v":0}]
[null,null,null,null,null,null,null,80,{"$f":"Sheet1!J89","v":0}]
[null,null,null,null,null,null,null,81,{"$f":"Sheet1!J90","v":0}]
[null,null,null,null,null,null,null,82,{"$f":"Sheet1!J91","v":0}]
[null,null,null,null,null,null,null,83,{"$f":"Sheet1!J92","v":0}]
[null,null,null,null,null,null,null,84,{"$f":"Sheet1!J93","v":0}]
[null,null,null,null,null,null,null,85,{"$f":"Sheet1!J94","v":0}]
[null,null,null,null,null,null,null,86,{"$f":"Sheet1!J95","v":0}]
[null,null,null,null,null,null,null,87,{"$f":"Sheet1!J96","v":0}]
[null,null,null,null,null,null,null,88,{"$f":"Sheet1!J97","v":0}]
[null,null,null,null,null,null,null,89,{"$f":"Sheet1!J98","v":0}]
[null,null,null,null,null,null,null,90,{"$f":"Sheet1!J99","v":0}]
[null,null,null,null,null,null,null,91,{"$f":"Sheet1!J100","v":0}]
[null,null,null,null,null,null,null,92,{"$f":"Sheet1!J101","v":0}]
[null,null,null,null,null,null,null,93,{"$f":"Sheet1!J102","v":0}]
[null,null,null,null,null,null,null,94,{"$f":"Sheet1!J103","v":0}]
[null,null,null,null,null,null,null,95,{"$f":"Sheet1!J104","v":0}]
[null,null,null,null,null,null,null,96,{"$f":"Sheet1!J105","v":0}]
[null,null,null,null,null,null,null,97,{"$f":"Sheet1!J106","v":0}]
[null,null,null,null,null,null,null,98,{"$f":"Sheet1!J107","v":0}]
[null,null,null,null,null,null,null,99,{"$f":"Sheet1!J108","v":0}]
[null,null,null,null,null,null,null,100,{"$f":"Sheet1!J109","v":0}]
[null,null,null,null,null,null,null,101,{"$f":"Sheet1!J110","v":0}]
[null,null,null,null,null,null,null,102,{"$f":"Sheet1!J111","v":0}]
[null,null,null,null,null,null,null,103,{"$f":"Sheet1!J112","v":0}]
[null,null,null,null,null,null,null,104,{"$f":"Sheet1!J113","v":0}]
[null,null,null,null,null,null,null,105,{"$f":"Sheet1!J114","v":0}]
[null,null,null,null,null,null,null,106,{"$f":"Sheet1!J115","v":0}]
[null,null,null,null,null,null,null,107,{"$f":"Sheet1!J116","v":0}]
[null,null,null,null,null,null,null,108,{"$f":"Sheet1!J117","v":0}]
[null,null,null,null,null,null,null,109,{"$f":"Sheet1!J118","v":0}]
[null,null,null,null,null,null,null,110,{"$f":"Sheet1!J119","v":0}]
[null,null,null,null,null,null,null,111,{"$f":"Sheet1!J120","v":0}]
[null,null,null,null,null,null,null,112,{"$f":"Sheet1!J121","v":0}]
[null,null,null,null,null,null,null,113,{"$f":"Sheet1!J122","v":0}]
[null,null,null,null,null,null,null,114,{"$f":"Sheet1!J123","v":0}]
[null,null,null,null,null,null,null,115,{"$f":"Sheet1!J124","v":0}]
[null,null,null,null,null,null,null,116,{"$f":"Sheet1!J125","v":0}]
[null,null,null,null,null,null,null,117,{"$f":"Sheet1!J126","v":0}]
[null,null,null,null,null,null,null,118,{"$f":"Sheet1!J127","v":0}]
[null,null,null,null,null,null,null,119,{"$f":"Sheet1!J128","v":0}]
[null,null,null,null,null,null,null,120,{"$f":"Sheet1!J129","v":0}]
[null,null,null,null,null,null,null,121,{"$f":"Sheet1!J130","v":0}]
[null,null,null,null,null,null,null,122,{"$f":"Sheet1!J131","v":0}]
[null,null,null,null,null,null,null,123,{"$f":"Sheet1!J132","v":0}]
[null,null,null,null,null,null,null,124,{"$f":"Sheet1!J133","v":0}]
[null,null,null,null,null,null,null,125,{"$f":"Sheet1!J134","v":0}]

{"sheet":"Black and Scholes","index":2,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Black Sholes Model"]
[]
[null,"stock",100]
[null,"strike",110]
[null,"volatility",0.3]
[null,"Riskless rate",0.04]
[null,"Term",1]
[null,"Dividend Yield",0]
[]
[null,"d1",{"$f":"LN(C4/C5)+(C7+C6^2/2)*C8/(C6*SQRT(C8))","v":0.18802315352900845}]
[null,"d2",{"$f":"SUM(C11-C6*SQRT(C8))","v":-0.11197684647099154}]
[null,"call",{"$f":"C4*NORMSDIST(C11)-C5*EXP(-C7*C8)*NORMSDIST(C12)","v":9.3250817843070095}]
[null,"put",{"$f":"C5*EXP(-C7*C8)*NORMSDIST(-C12)-C4*NORMSDIST(-C11)","v":15.011920091062557}]
[]
[]
[null,"d1= (Ln(S0/K)+((r-q)+σ2/2)T)/σ √T"]
[null,"d2= d1-σ√T"]
[null,"C=S0N(d1)-Ke-rTN(d2)"]