{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Test"],"not_rendered":{"charts":0,"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":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["0","Security","Bid","Bid Qty","Ask","Ask Qty","Units","Payoff","Last","Last Qty","VWAP"]
[null,"IMB"]
[null,"T-Strip"]
[null,"Call320"]
[null,"Put320"]
[null,"Call360"]
[null,"Put360"]
[null,"Cash"]
[null,"Trading Case ST1 Support  (Market writes in rows 11/12 below).  To make you spreadsheet update automatically turn Auto Calculate on (Tools, Options , Calculation), otherwise use the F9 to manually update."]
[]
[]
[null,null,"Delta","Gamma","Vega"]
[null,"IMB",1,0,0]
[null,"T-Strip",0,0,0]
[null,"Call320",{"$f":"OptionDelta(1,0.0325,$B$11/$C$11,320,$C$2,0.3,0)","v":{"$error":"#VALUE!"}},{"$f":"OptionGamma(0.0325,$B$11/$C$11,320,$C$2,0.3,0)","v":{"$error":"#VALUE!"}},{"$f":"OptionVega(0.0325,$B$11/$C$11,320,$C$2,0.3,0)","v":{"$error":"#VALUE!"}}]
[null,"Put320",{"$f":"OptionDelta(2,0.0325,$B$11/$C$11,320,$C$2,0.3,0)","v":{"$error":"#VALUE!"}},{"$f":"OptionGamma(0.0325,$B$11/$C$11,320,$C$2,0.3,0)","v":{"$error":"#VALUE!"}},{"$f":"OptionVega(0.0325,$B$11/$C$11,320,$C$2,0.3,0)","v":{"$error":"#VALUE!"}}]
[null,"Call360",{"$f":"OptionDelta(1,0.0325,$B$11/$C$11,360,$C$2,0.3,0)","v":{"$error":"#VALUE!"}},{"$f":"OptionGamma(0.0325,$B$11/$C$11,360,$C$2,0.3,0)","v":{"$error":"#VALUE!"}},{"$f":"OptionVega(0.0325,$B$11/$C$11,360,$C$2,0.3,0)","v":{"$error":"#VALUE!"}}]
[null,"Put360",{"$f":"OptionDelta(2,0.0325,$B$11/$C$11,360,$C$2,0.3,0)","v":{"$error":"#VALUE!"}},{"$f":"OptionGamma(0.0325,$B$11/$C$11,360,$C$2,0.3,0)","v":{"$error":"#VALUE!"}},{"$f":"OptionVega(0.0325,$B$11/$C$11,360,$C$2,0.3,0)","v":{"$error":"#VALUE!"}}]
[]
[null,"Position",{"$f":"+$G$2*C13+$G$3*C14+$G$4*C15+$G$5*C16+$G$6*C17+$G$7*C18","v":{"$error":"#VALUE!"}},{"$f":"+$G$2*D13+$G$3*D14+$G$4*D15+$G$5*D16+$G$6*D17+$G$7*D18","v":{"$error":"#VALUE!"}},{"$f":"+$G$2*E13+$G$3*E14+$G$4*E15+$G$5*E16+$G$6*E17+$G$7*E18","v":{"$error":"#VALUE!"}}]

{"sheet":"Sheet2","index":1,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,"Trial","Period","Time","Security","Action","Price","Quantity"]
[null,"1","1","331","2","sell","887.427","50."]
[null,"1","1","330","2","sell","887.427","50."]
[null,"1","1","330","2","sell","887.98","50."]
[null,"1","1","330","2","sell","887.98","50."]
[null,"1","1","330","2","sell","887.98","50."]
[null,"1","1","325","1","Buy","323.238","50."]
[null,"1","1","324","1","Buy","323.238","50."]
[null,"1","1","324","1","Buy","323.238","50."]
[null,"1","1","324","1","Buy","323.238","50."]
[null,"1","1","324","1","Buy","323.238","50."]
[null,"1","1","323","1","Buy","323.238","50."]
[null,"1","1","323","1","Buy","323.238","50."]
[null,"1","1","323","1","Buy","323.238","50."]
[null,"1","1","323","1","Buy","323.238","50."]
[null,"1","1","323","1","Buy","323.238","50."]
[null,"1","1","322","1","Buy","323.238","50."]
[null,"2","1","347","1","sell","358.663","999."]
[null,"2","1","347","1","sell","358.663","999."]
[null,"2","1","347","1","sell","358.663","999."]
[null,"2","1","346","1","sell","358.663","999."]
[null,"2","1","346","1","sell","358.663","999."]

{"sheet":"Test","index":2,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Call1Put1",1,2]
["RiskFree",0.1,0.1]
["Maturity",1,1]
["Strike",50,50]
["Underlying",50,50]
["Volatility",0.25,0.25]
["Div",0,0]
["Option Price",7,7]
["Tolerance",1E-3,1E-3]
["Iterations",100,100]
[]
["Price",{"$f":"BlackScholes(B$1,B$2,B$3,B$4,B$5,B$6,B$7)","v":7.4879417419433594},{"$f":"BlackScholes(C$1,C$2,C$3,C$4,C$5,C$6,C$7)","v":2.7298123836517334}]
["delta",{"$f":"OptionDelta(B$1,B$2,B$3,B$4,B$5,B$6,B$7)","v":0.70020025968551636},{"$f":"OptionDelta(C$1,C$2,C$3,C$4,C$5,C$6,C$7)","v":-0.29979974031448364}]
["gamma",{"$f":"OptionGamma(B$2,B$3,B$4,B$5,B$6,B$7)","v":2.7806999161839485E-2},{"$f":"OptionGamma(C$2,C$3,C$4,C$5,C$6,C$7)","v":2.7806999161839485E-2}]
["vega",{"$f":"OptionVega(B$2,B$3,B$4,B$5,B$6,B$7)","v":17.379375457763672},{"$f":"OptionVega(C$2,C$3,C$4,C$5,C$6,C$7)","v":17.379375457763672}]
["theta",{"$f":"OptionTheta(B$1,B$2,B$3,B$4,B$5,B$6,B$7)","v":-4.9246292114257812},{"$f":"OptionTheta(C$1,C$2,C$3,C$4,C$5,C$6,C$7)","v":-0.40044200420379639}]
["impvol",{"$f":"ImpliedVol(B$1,B$2,B$3,B$4,B$5,B$6,B$9,B$8,B$7,B$10)","v":0.22167976200580597},{"$f":"ImpliedVol(C$1,C$2,C$3,C$4,C$5,C$6,C$9,C$8,C$7,C$10)","v":0.48864752054214478}]