{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Asian option valuation"],"not_rendered":{"charts":0,"images":1,"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":"Asian option valuation","index":0,"n_rows":116,"n_cols":10,"rows_kept":116,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"http://breakingdownfinance.com"]
[]
[null,"Wealth",10000000]
[null,"Stock price",25]
[null,"Daily return",8.0000000000000002E-3]
[null,"Daily volatility",0.05]
[null,"Period",10]
[null,"dt",{"$f":"1/260","v":3.8461538461538464E-3}]
[null,"Simulations",100]
[null,"Strike price",25.1]
[null,"Risk free rate (in coninious compounding)",0.01]
[]
[null,"Time","Price",null,null,"Payoff asion call","Payoff asian put",null,"Value Asian call","Value Asian put"]
[null,1,24.889801211667191,null,null,9.5749119387665615E-2,0,null,{"$f":"(AVERAGE(OFFSET(F17,0,0,COUNT(F17:F1048576))))*EXP(-$C$14*$C$10)","v":2.7498184775041758E-2},{"$f":"(AVERAGE(OFFSET(G17,0,0,COUNT(G17:G1048576))))*EXP(-$C$14*$C$10)","v":0.10867957862475355}]
[null,2,24.669380742901417,null,null,0.2636967994904964,0]
[null,3,24.55113464071438,null,null,0,7.0101565765043006E-2]
[null,4,24.515472236367859,null,null,0,0.33574471659524363]
[null,5,24.505315269966651,null,null,0,4.0467726513600866E-2]
[null,6,24.571815526850738,null,null,1.0046577207933893E-2,0]
[null,7,24.500847397452027,null,null,0.21078377428954553,0]
[null,8,24.529304431077641,null,null,0,0.1206944097004552]
[null,9,24.572802618743832,null,null,0,3.9090020935496739E-2]
[null,10,24.573923883553221,null,null,0,9.9254798181721782E-2]
[null,null,null,null,null,0,0.16634073201859678]
[null,null,null,null,null,0,0.35756044052211777]
[null,null,null,null,null,0,3.6753104901702471E-2]
[null,null,null,null,null,4.65901804598019E-2,0]
[null,null,null,null,null,0,0.15075089236452399]
[null,null,null,null,null,0,0.10769620753444187]
[null,null,null,null,null,0,6.8309852324180298E-2]
[null,null,null,null,null,0,0.47571442146418264]
[null,null,null,null,null,0.11775009160008665,0]
[null,null,null,null,null,0,0.16339588876637023]
[null,null,null,null,null,0,0.1245654163627421]
[null,null,null,null,null,0.12211230132199091,0]
[null,null,null,null,null,0,0.15744042169873396]
[null,null,null,null,null,0,0.14455315711607852]
[null,null,null,null,null,0,6.7549487070991177E-2]
[null,null,null,null,null,0.13886105647606684,0]
[null,null,null,null,null,0,9.6321313392202512E-2]
[null,null,null,null,null,0,0.10869103965349325]
[null,null,null,null,null,0,0.30837177943512017]
[null,null,null,null,null,0,0.12291558775859102]
[null,null,null,null,null,0,0.11898721694155512]
[null,null,null,null,null,0,2.7681434922879333E-2]
[null,null,null,null,null,4.985859404906634E-2,0]
[null,null,null,null,null,8.2134812702463478E-3,0]
[null,null,null,null,null,0,0.16852399089764347]
[null,null,null,null,null,0,0.18594126615952433]
[null,null,null,null,null,1.5243422991062516E-4,0]
[null,null,null,null,null,0,0.21807938474323407]
[null,null,null,null,null,0,0.28356437533308565]
[null,null,null,null,null,0,4.1459180339632695E-2]
[null,null,null,null,null,0,7.2713370541812594E-3]
[null,null,null,null,null,0,0.30204128556786358]
[null,null,null,null,null,0,0.3113648020786961]
[null,null,null,null,null,0,0.12680297333905344]
[null,null,null,null,null,0,0.13839537794865464]
[null,null,null,null,null,0,0.18120547615651006]
[null,null,null,null,null,0,0.23459385279837619]
[null,null,null,null,null,2.1682969141245678E-2,0]
[null,null,null,null,null,0,0.109431418297401]
[null,null,null,null,null,0,0.26939022003954705]
[null,null,null,null,null,0,0.18608296975522975]
[null,null,null,null,null,0.33639641372178986,0]
[null,null,null,null,null,2.5054164957705183E-2,0]
[null,null,null,null,null,0,3.4497233670705896E-2]
[null,null,null,null,null,6.7619944096662721E-2,0]
[null,null,null,null,null,0.21232035224971924,0]
[null,null,null,null,null,7.2586032312049298E-2,0]
[null,null,null,null,null,0,0.13982078630472117]
[null,null,null,null,null,0.23980743667991078,0]
[null,null,null,null,null,0,5.9727326566900274E-2]
[null,null,null,null,null,0,0.16331300120675252]
[null,null,null,null,null,2.5366599698052994E-2,0]
[null,null,null,null,null,0.12540711829059248,0]
[null,null,null,null,null,0,0.16784543813531627]
[null,null,null,null,null,0,4.2165622310093909E-2]
[null,null,null,null,null,0,0.35078667570672906]
[null,null,null,null,null,0,8.1517052586754346E-2]
[null,null,null,null,null,9.8431279803058658E-2,0]
[null,null,null,null,null,0,8.3963033639040674E-2]
[null,null,null,null,null,0.1895623158273203,0]
[null,null,null,null,null,0,0.16164858339934085]
[null,null,null,null,null,0,5.1609027437677923E-2]
[null,null,null,null,null,0,3.2300701628759754E-2]
[null,null,null,null,null,0,0.30710114422171486]
[null,null,null,null,null,0,0.24917811309250837]
[null,null,null,null,null,0,0.17156635299219758]
[null,null,null,null,null,0,0.246577182286984]
[null,null,null,null,null,0.12248195726056466,0]
[null,null,null,null,null,0.19618830372610319,0]
[null,null,null,null,null,7.4897649436945102E-2,0]
[null,null,null,null,null,0,0.11769958498520339]
[null,null,null,null,null,0,0.10524056373463964]
[null,null,null,null,null,0,0.10511406844322124]
[null,null,null,null,null,0,0.16811634123400054]
[null,null,null,null,null,0,0.35624956211351488]
[null,null,null,null,null,0,0.17706981200609917]
[null,null,null,null,null,0,3.9094633239027843E-2]
[null,null,null,null,null,0,0.30130687537595691]
[null,null,null,null,null,0,7.083980681611024E-2]
[null,null,null,null,null,0,1.9131522518520683E-3]
[null,null,null,null,null,0,8.2664039019419988E-2]
[null,null,null,null,null,0,0.32437592883944433]
[null,null,null,null,null,5.9127261149189536E-2,0]
[null,null,null,null,null,0.1082752031909493,0]
[null,null,null,null,null,0,0.19522512035983297]
[null,null,null,null,null,0,0.22175947759298253]
[null,null,null,null,null,0,0.22806393985416662]
[null,null,null,null,null,0,0.16596290990130669]
[null,null,null,null,null,0,0.22151813100715856]
[null,null,null,null,null,0,0.51202020407050952]