{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["principal","delta","gamma","theta","rho","vega","value"],"not_rendered":{"charts":6,"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":"principal","index":0,"n_rows":71,"n_cols":24,"rows_kept":71,"cut":false,"hidden":false,"merged":[[3,1,3,2],[3,5,3,6],[14,1,14,6],[1,1,2,6]]}
[]
[null,"ASSET OR NOTHING OPTIONS"]
[]
[null,"INPUTS",null,null,null,"OUPUTS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"call",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"put"]
[null,"Type of option",null,null,null,{"$f":" IF(X5=1,\"Call option Value\",\"Put option Value\")","v":"Put option Value"},{"$f":"AON($X$5,$C$8,$C$9,$C$10,$C$11,$C$12)","v":64.826091958649712}]
[null,"Stock price(S)",120,null,null,{"$f":"IF(X5=1,\"Call  Delta\",\"Put Delta\")","v":"Put Delta"},{"$f":"deltan($X$5,$C$8,$C$9,$C$10,$C$11,$C$12)","v":-4.5839115005506414}]
[null,"Skrike price(K)",125,null,null,{"$f":"IF(X5=1,\"Call  Gamma\",\"Put  Gamma\")","v":"Put  Gamma"},{"$f":"gamman($X$5,$C$8,$C$9,$C$10,$C$11,$C$12)","v":-9.8369014551735745E-2}]
[null,"Time to maturity(T,years)",0.6,null,null,{"$f":"IF(X5=1,\"Call  Theta\",\"Put  Theta\")","v":"Put  Theta"},{"$f":"Thetan($X$5,$C$8,$C$9,$C$10,$C$11,$C$12)","v":0.10387507009957631}]
[null,"Volatility(v%)",0.1,null,null,{"$f":"IF(X5=1,\"Call  Rho\",\"Put Rho\")","v":"Put Rho"},{"$f":"Rhon($X$5,$C$8,$C$9,$C$10,$C$11,$C$12)","v":-3.6857250393632235}]
[null,"Risk free Rate(r %)",0.05,null,null,{"$f":"IF(X5=1,\"Call  Vega\",\"Put  Vega\")","v":"Put  Vega"},{"$f":"Vegan($X$5,$C$8,$C$9,$C$10,$C$11,$C$12)","v":-0.85646135075746344}]
[]
[]
[null,"View Graphs"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Time to maturity(T)","Delta",null,"Time to maturity(T)","Theta",null,"Time to maturity(T)","Rho","Time to maturity(T)","Gamma",null,"Time to maturity(T)","Vega",null,"Time to maturity(T)",{"$f":"IF(X5=1,\"Call option Value\",\"Put option Value\")","v":"Put option Value"}]
[null,0.05,{"$f":"deltan($X$5,$C$8,$C$9,$B$53,$C$11,$C$12)","v":-3.231552336580279},null,1,{"$f":"Thetan($X$5,$C$8,$C$9,E53,$C$11,$C$12)","v":6.2296071259233088E-2},null,0.05,{"$f":"Rhon($X$5,$C$8,$C$9,H53,$C$11,$C$12)","v":-0.251272677289748},0.05,{"$f":"gamman($X$5,$C$8,$C$9,J53,$C$11,$C$12)","v":-2.6918203572279253},null,0.05,{"$f":"Vegan($X$5,$C$8,$C$9,M53,$C$11,$C$12)","v":-1.9191603887393143},null,0.05,{"$f":"AON($X$5,$C$8,$C$9,P53,$C$11,$C$12)","v":114.68177530085313}]
[null,0.1,{"$f":"deltan($X$5,$C$8,$C$9,$B$54,$C$11,$C$12)","v":-5.8926427746996524},null,1.05,{"$f":"Thetan($X$5,$C$8,$C$9,E54,$C$11,$C$12)","v":5.9343809444897033E-2},null,0.1,{"$f":"Rhon($X$5,$C$8,$C$9,H54,$C$11,$C$12)","v":-0.81131018175602776},0.1,{"$f":"gamman($X$5,$C$8,$C$9,J54,$C$11,$C$12)","v":-2.0463304980467001},null,0.1,{"$f":"Vegan($X$5,$C$8,$C$9,M54,$C$11,$C$12)","v":-2.939874718366049},null,0.1,{"$f":"AON($X$5,$C$8,$C$9,P54,$C$11,$C$12)","v":104.15981564424516}]
[null,0.15,{"$f":"deltan($X$5,$C$8,$C$9,$B$55,$C$11,$C$12)","v":-6.4325034299677952},null,1.1000000000000001,{"$f":"Thetan($X$5,$C$8,$C$9,E55,$C$11,$C$12)","v":5.6660055149393429E-2},null,0.15,{"$f":"Rhon($X$5,$C$8,$C$9,H55,$C$11,$C$12)","v":-1.3017245830531863},0.15,{"$f":"gamman($X$5,$C$8,$C$9,J55,$C$11,$C$12)","v":-1.3689988351472948},null,0.15,{"$f":"Vegan($X$5,$C$8,$C$9,M55,$C$11,$C$12)","v":-2.9633077072057148},null,0.15,{"$f":"AON($X$5,$C$8,$C$9,P55,$C$11,$C$12)","v":95.979301485166189}]
[null,0.2,{"$f":"deltan($X$5,$C$8,$C$9,$B$56,$C$11,$C$12)","v":-6.3946835865742457},null,1.1499999999999999,{"$f":"Thetan($X$5,$C$8,$C$9,E56,$C$11,$C$12)","v":5.4209079852626019E-2},null,0.2,{"$f":"Rhon($X$5,$C$8,$C$9,H56,$C$11,$C$12)","v":-1.7138224273497116},0.2,{"$f":"gamman($X$5,$C$8,$C$9,J56,$C$11,$C$12)","v":-0.94700186494378613},null,0.2,-2.7399411996002527,null,0.2,89.707542301249106]
[null,0.25,{"$f":"deltan($X$5,$C$8,$C$9,$B$57,$C$11,$C$12)","v":-6.1850927142245382},null,1.2,5.196120922194325E-2,null,0.25,-2.066689117141145,0.25,-0.67926763108516752,null,0.25,-2.4603195405793556,null,0.25,84.707734892409135]
[null,0.3,{"$f":"deltan($X$5,$C$8,$C$9,$B$58,$C$11,$C$12)","v":-5.9283012039912819},null,1.25,4.9891600853840146E-2,null,0.3,-2.3749755199239218,0.3,-0.50088802112213671,null,0.3,-2.1791194262522069,null,0.3,80.579910392513128]
[null,0.35,{"$f":"deltan($X$5,$C$8,$C$9,$B$59,$C$11,$C$12)","v":-5.6673326221812204},null,1.3,4.7979304862018068E-2,null,0.35,-2.6487098473753505,0.35,-0.37665535188580179,null,0.35,-1.9128809454103504,null,0.35,77.076888924259407]
[null,0.4,{"$f":"deltan($X$5,$C$8,$C$9,$B$60,$C$11,$C$12)","v":-5.4175954021729922},null,1.35,4.6206534179717096E-2,null,0.4,-2.8948457828076712,0.4,-0.28691962086213607,null,0.4,-1.6658941390304349,null,0.4,74.039576893533734]
[null,0.45,{"$f":"deltan($X$5,$C$8,$C$9,$B$61,$C$11,$C$12)","v":-5.1841431638969482},null,1.4,4.4558092188907494E-2,null,0.45,-3.1183578024203982,0.45,-0.22015150520360294,null,0.45,-1.4382433400080572,null,0.45,71.360980282707345]
[null,0.5,{"$f":"deltan($X$5,$C$8,$C$9,$B$62,$C$11,$C$12)","v":-4.9679290187597758},null,1.45,4.3020919665529789E-2,null,0.5,-3.3229185439615705,0.5,-0.16925395158295942,null,0.5,-1.228597195002898,null,0.5,68.966282367510701]
[null,0.55000000000000004,{"$f":"deltan($X$5,$C$8,$C$9,$B$63,$C$11,$C$12)","v":-4.7682764408499168},null,1.5,4.1583733131645317E-2,null,0.55000000000000004,-3.5113172681735705,0.55000000000000004,-0.12967068172997642,null,0.55000000000000004,-1.0352403877441247,null,0.55000000000000004,66.801394787461589]
[null,0.6,{"$f":"deltan($X$5,$C$8,$C$9,B64,$C$11,$C$12)","v":-4.5839115005506414},null,1.55,4.0236733895007148E-2,null,0.6,-3.6857250393632235,0.6,-9.8369014551735745E-2,null,0.6,-0.85646135075746344,null,0.6,64.826091958649712]
[null,0.65,{"$f":"deltan($X$5,$C$8,$C$9,B65,$C$11,$C$12)","v":-4.4134058198665116},null,1.6,3.8971372234563262E-2,null,0.65,-3.8478679755343315,0.65,-7.3266862585796844E-2,null,0.65,-0.69068977676886689,null,0.65,63.009726388258045]
[null,0.7,{"$f":"deltan($X$5,$C$8,$C$9,B66,$C$11,$C$12)","v":-4.2553650000130006},null,1.65,3.7780154962000267E-2,null,0.7,-3.9991438534523915,0.7,-5.2896066904395411E-2,null,0.7,-0.53653413861156096,null,0.7,61.328457709812945]
[null,0.75,{"$f":"deltan($X$5,$C$8,$C$9,B67,$C$11,$C$12)","v":-4.1085033225968459},null,1.7,3.6656487364687962E-2,null,0.75,-4.1407027637528167,0.75,-3.6197086927813871E-2,null,0.75,-0.39277967267482339,null,0.75,59.763403540441779]
[null,0.8,-3.9716669456435483,null,1.75,3.5594542598154533E-2,null,0.8,-4.2735042904408047,0.8,-2.2389613221207583E-2,null,0.8,-0.25837195976203731,null,0.8,58.299370972952424]
[null,0.85,-3.8438340862899878,null,1.8,3.4589153143308238E-2,null,0.85,-4.3983589509828249,0.85,-1.0888627812732921E-2,null,0.85,-0.13239663845222438,null,0.85,56.923964949205086]
[null,0.9,-3.7241055266804324,null,1.85,3.3635720113863954E-2,null,0.9,-4.5159588274266227,0.9,-1.2485345735058218E-3,null,0.9,-1.4059547140089279E-2,null,0.9,55.626947886394838]
[null,0.95,-3.6116917257853487,null,1.9,3.2730137091768086E-2,null,0.95,-4.6269006114889528,0.95,6.8748895643011565E-3,null,0.95,9.7331120307888597E-2,null,0.95,54.39977084380709]

{"sheet":"delta","index":1,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(principal!X5=1,\"Call  Delta Graph\",\"Put Delta Graph \")","v":"Put Delta Graph "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Delta"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Time"]

{"sheet":"gamma","index":2,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(principal!X5=1,\"Call  Gamma Graph\",\"Put Gamma Graph \")","v":"Put Gamma Graph "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Gamma"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Time"]

{"sheet":"theta","index":3,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(principal!X5=1,\"Call  Theta Graph\",\"Put Theta Graph \")","v":"Put Theta Graph "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Theta"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Time"]

{"sheet":"rho","index":4,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(principal!X5=1,\"Call  Rho Graph\",\"Put Rho Graph \")","v":"Put Rho Graph "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Rho"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Time"]

{"sheet":"vega","index":5,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(principal!X5=1,\"Call  Vega Graph\",\"Put Vega Graph \")","v":"Put Vega Graph "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Vega"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Time"]

{"sheet":"value","index":6,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(principal!X5=1,\"Call  Value Graph\",\"Put Value  Graph \")","v":"Put Value  Graph "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"value"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Time"]