{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Histogram","Black and Scholes"],"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":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,110,0.3,0.1,1E-3,1E-3,0.05]
[null,"Fair Price",null,null,null,null,null,"Stock Expectations Daily",null,"Day one"]
[null,6.1624030956521834,null,null,null,null,null,"Ini. Volatility","Ini. Drift","Exp. Daily Drift"]
[null,null,null,null,null,null,null,{"$f":"H3/SQRT(252)","v":1.8898223650461361E-2},{"$f":"I3/252","v":3.9682539682539683E-4},{"$f":"I6-0.5*H6^2","v":2.1825396825396828E-4}]
[]
[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,-1.4651317722464157,0.11018211871353231,-0.13652217722464158,-1.4677400809304773E-2,86.821104035919035,0,null,89.305991910511679,88.104809865825573,86.821104035919035]
[null,null,null,2,1.6871417468827623,0.40329435211532305,0.17870517468827624,-0.14296373476689828,16.411504999286464,0,null,78.49004711276109,18.933755758350763,16.411504999286464]
[null,null,null,3,0.93624958794174495,-0.95649587233528699,0.48607986238986811,-0.4740839637379215,63.70235414020992,0,null,102.57910630522977,102.34049931105828,63.70235414020992]
[null,null,null,4,0.44111056205285026,-2.3241256602876549E-2,0.31273029106723332,-1.7375137714287114E-2,74.273260767409084,0,null,96.692100326731534,75.575045496128425,74.273260767409084]
[null,null,null,5,-0.13683200204647783,1.2423702056272692,-3.6922002046477836E-3,-6.6882013367117726E-3,129.96927259517636,19.969272595176363,null,153.63463842606083,130.84144664452583,129.96927259517636]
[null,null,null,6,-0.39268527898212435,-0.65597905353684283,-1.8152910089541653E-2,5.6574272861488299E-3,114.78728220927502,4.7872822092750198,null,105.73232119688815,114.13971501615019,114.78728220927502]
[null,null,null,7,1.591887865444479,-0.87966099937809905,0.1691797865444479,-0.18358970198100455,93.498759219998334,0,null,120.47741407309897,112.34088532233278,93.498759219998334]
[null,null,null,8,0.36420885261657276,-0.3083695160953539,0.10385459114635283,-3.2254687983162403E-2,109.49004106444131,0,null,119.17354245603842,113.07918029679541,109.49004106444131]
[null,null,null,9,-0.84801300011197189,-0.68688992732008458,-7.4810300011197192E-2,-2.4841208088778988E-2,146.86747615207045,36.867476152070452,null,106.41802809447989,150.56153415991787,146.86747615207045]
[null,null,null,10,-0.65446076221528204,-0.60761141294283361,-0.10456999406288126,5.3647793931029739E-2,89.750956935422636,0,null,80.740354713546694,85.062892581522107,89.750956935422636]

{"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":0},null,"Lower limit","Upper limit","Class","Frequency","Probability"]
[null,null,null,null,null,null,null,{"$f":"H7+1","v":2},{"$f":"Sheet1!J11","v":0},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":1},{"$f":"N8/Sheet1!$D$3","v":0.1}]
[null,null,null,null,null,null,null,{"$f":"H8+1","v":3},{"$f":"Sheet1!J12","v":0},null,{"$f":"L8","v":20},30,"20   30",0,{"$f":"N9/Sheet1!$D$3","v":0}]
[null,null,null,null,null,null,null,4,{"$f":"Sheet1!J13","v":0},null,{"$f":"L9","v":30},40,"30   40",1,{"$f":"N10/Sheet1!$D$3","v":0.1}]
[null,null,null,null,null,null,null,5,{"$f":"Sheet1!J14","v":19.969272595176363},null,40,50,"40   50",0,{"$f":"N11/Sheet1!$D$3","v":0}]
[null,null,null,null,null,null,null,6,{"$f":"Sheet1!J15","v":4.7872822092750198},null,50,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,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,80,"70   80",0,{"$f":"N14/Sheet1!$D$3","v":0}]
[null,null,null,null,null,null,null,9,{"$f":"Sheet1!J18","v":36.867476152070452},null,80,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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},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,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,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,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},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,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 Scholes Model"]
[]
[null,"stock",100]
[null,"strike",110]
[null,"volatility",0.3]
[null,"Riskless rate",0.05]
[null,"Term",1]
[null,"Dividend Yield",0]
[]
[null,"d1",{"$f":"LN(C4/C5)+(C7+C6^2/2)*C8/(C6*SQRT(C8))","v":0.22135648686234183}]
[null,"d2",{"$f":"SUM(C11-C6*SQRT(C8))","v":-7.8643513137658161E-2}]
[null,"call",{"$f":"C4*NORMSDIST(C11)-C5*EXP(-C7*C8)*NORMSDIST(C12)","v":9.7211064975901138}]
[null,"put",{"$f":"C5*EXP(-C7*C8)*NORMSDIST(-C12)-C4*NORMSDIST(-C11)","v":14.35634319266866}]
[]
[]
[null,"d1= (Ln(S0/K)+((r-q)+σ2/2)T)/σ √T"]
[null,"d2= d1-σ√T"]
[null,"C=S0N(d1)-Ke-rTN(d2)"]