{"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,"Stock price",25]
[null,"Daily return",8.0000000000000004E-4]
[null,"Daily volatility",0.05]
[null,"Period",10]
[null,"dt",{"$f":"1/260","v":3.8461538461538464E-3}]
[null,"Simulations",100]
[null,"Strike price",25]
[null,"Risk free rate (in coninious compounding)",0.01]
[null,"Binary payoff",1]
[]
[null,"Time","Price",null,null,"Payoff binary call","Payoff binary put",null,"Value binary call","Value binary put"]
[null,1,24.967528375957087,null,null,1,0,null,{"$f":"(AVERAGE(OFFSET(F17,0,0,COUNT(F17:F1048576))))*EXP(-$C$13*$C$9)","v":0.41622521229654141},{"$f":"(AVERAGE(OFFSET(G17,0,0,COUNT(G17:G1048576))))*EXP(-$C$13*$C$9)","v":0.48861220573941816}]
[null,2,24.912543044335411,null,null,1,0]
[null,3,24.770733194022732,null,null,0,1]
[null,4,24.671087454054938,null,null,1,0]
[null,5,24.723381365754513,null,null,1,0]
[null,6,24.758864516565811,null,null,0,1]
[null,7,24.861751143387195,null,null,0,1]
[null,8,24.775094672234871,null,null,1,0]
[null,9,24.879700303981732,null,null,0,1]
[null,10,24.913161328755631,null,null,0,1]
[null,null,null,null,null,1,0]
[null,null,null,null,null,0,1]
[null,null,null,null,null,1,0]
[null,null,null,null,null,0,1]
[null,null,null,null,null,0,1]
[null,null,null,null,null,0,1]
[null,null,null,null,null,1,0]
[null,null,null,null,null,1,0]
[null,null,null,null,null,1,0]
[null,null,null,null,null,1,0]
[null,null,null,null,null,0,1]
[null,null,null,null,null,1,0]
[null,null,null,null,null,0,1]
[null,null,null,null,null,1,0]
[null,null,null,null,null,0,1]
[null,null,null,null,null,0,1]
[null,null,null,null,null,0,1]
[null,null,null,null,null,0,1]
[null,null,null,null,null,1,0]
[null,null,null,null,null,1,0]
[null,null,null,null,null,0,1]
[null,null,null,null,null,0,1]
[null,null,null,null,null,1,0]
[null,null,null,null,null,0,1]
[null,null,null,null,null,1,0]
[null,null,null,null,null,1,0]
[null,null,null,null,null,0,1]
[null,null,null,null,null,0,1]
[null,null,null,null,null,0,1]
[null,null,null,null,null,1,0]
[null,null,null,null,null,1,0]
[null,null,null,null,null,1,0]
[null,null,null,null,null,0,1]
[null,null,null,null,null,1,0]
[null,null,null,null,null,1,0]
[null,null,null,null,null,0,1]
[null,null,null,null,null,1,0]
[null,null,null,null,null,0,1]
[null,null,null,null,null,0,1]
[null,null,null,null,null,1,0]
[null,null,null,null,null,1,0]
[null,null,null,null,null,0,1]
[null,null,null,null,null,0,1]
[null,null,null,null,null,1,0]
[null,null,null,null,null,1,0]
[null,null,null,null,null,0,1]
[null,null,null,null,null,0,1]
[null,null,null,null,null,1,0]
[null,null,null,null,null,0,1]
[null,null,null,null,null,1,0]
[null,null,null,null,null,1,0]
[null,null,null,null,null,1,0]
[null,null,null,null,null,0,1]
[null,null,null,null,null,1,0]
[null,null,null,null,null,0,1]
[null,null,null,null,null,0,1]
[null,null,null,null,null,0,1]
[null,null,null,null,null,1,0]
[null,null,null,null,null,1,0]
[null,null,null,null,null,1,0]
[null,null,null,null,null,0,1]
[null,null,null,null,null,0,1]
[null,null,null,null,null,0,1]
[null,null,null,null,null,0,1]
[null,null,null,null,null,0,1]
[null,null,null,null,null,0,1]
[null,null,null,null,null,0,1]
[null,null,null,null,null,1,0]
[null,null,null,null,null,0,1]
[null,null,null,null,null,1,0]
[null,null,null,null,null,0,1]
[null,null,null,null,null,1,0]
[null,null,null,null,null,0,1]
[null,null,null,null,null,1,0]
[null,null,null,null,null,0,1]
[null,null,null,null,null,1,0]
[null,null,null,null,null,0,1]
[null,null,null,null,null,1,0]
[null,null,null,null,null,0,1]
[null,null,null,null,null,1,0]
[null,null,null,null,null,0,1]
[null,null,null,null,null,0,1]
[null,null,null,null,null,0,1]
[null,null,null,null,null,1,0]
[null,null,null,null,null,0,1]
[null,null,null,null,null,0,1]
[null,null,null,null,null,1,0]
[null,null,null,null,null,0,1]
[null,null,null,null,null,1,0]
[null,null,null,null,null,0,1]