{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Std Dev Prob"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Std Dev Prob","index":0,"n_rows":50,"n_cols":18,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[null,"£/$",null,null,null,"Date/Exp>>",null,"€/£",null,null,null,"Date/Exp>>",null,"£/$",null,null,null,"Date/Exp>>"]
[null,"Stock Price>>",13487,null,null,{"$f":"TODAY()","v":"2021-11-21"},null,"Stock Price>>",8555,null,null,{"$f":"TODAY()","v":"2021-11-21"},null,"Stock Price>>",13487,null,null,{"$f":"TODAY()","v":"2021-11-21"}]
[null,"Implied Volatility>>",7.0000000000000007E-2,null,null,"2021-11-19",null,"Implied Volatility>>",7.0000000000000007E-2,null,null,"2021-11-26",null,"Implied Volatility>>",7.0000000000000007E-2,null,null,"2021-12-15"]
[null,"Sqrt DTE",{"$f":"SQRT(F5)","v":3},null,null,9,null,"Sqrt DTE",{"$f":"SQRT(L5)","v":4},null,null,16,null,"Sqrt DTE",{"$f":"SQRT(R5)","v":4.8989794855663558},null,null,24]
[null,"Sqrt 252",{"$f":"SQRT(252)","v":15.874507866387544},null,null,null,null,"Sqrt 252",{"$f":"SQRT(252)","v":15.874507866387544},null,null,null,null,"Sqrt 252",{"$f":"SQRT(252)","v":15.874507866387544}]
[]
[null,"1 SD",{"$f":"(C3*C4*C5)/C6","v":178.41623966164067},"Close Above Target","Win Prob",null,null,"1 SD",{"$f":"(I3*I4*I5)/I6","v":150.89601644105048},"Close Above Target","Win Prob",null,null,"Prob of Price Expiring in Range"]
[null,"Short Call Target Plus 1 SD",{"$f":"C3+C8","v":13665.416239661641},{"$f":"1-NORMSDIST(LN(C9/C3)/(C4*SQRT(F5/365)))","v":0.11592453110482359},{"$f":"NORMSDIST(LN(C9/C3)/(C4*SQRT(F5/365)))","v":0.88407546889517641},{"$f":"C9/C3-1","v":1.3228756555323073E-2},null,"Short Call Target Plus 1 SD",{"$f":"I3+I8","v":8705.896016441051},{"$f":"1-NORMSDIST(LN(I9/I3)/(I4*SQRT(L5/365)))","v":0.11643282788710163},{"$f":"NORMSDIST(LN(I9/I3)/(I4*SQRT(L5/365)))","v":0.88356717211289837},{"$f":"I9/I3-1","v":1.7638342073764024E-2},null,"Z Score/Std Devs","Winning % Prob","Lower Price","Upper Price","Std Devs"]
[null,null,null,"Close Below Target","Win Prob",null,null,null,null,"Close Below Target","Win Prob",null,null,"3.29053 SD",0.999,{"$f":"O3-R10","v":12528.295860374974},{"$f":"O3+R10","v":14445.704139625026},{"$f":"3.29053*((O3*O4*O5)/O6)","v":958.70413962502641}]
[null,"Short Put Target Minus 1 SD",{"$f":"C3-C8","v":13308.583760338359},{"$f":"NORMSDIST(LN(C11/C3)/(C4*SQRT(F5/365)))","v":0.11284588482690754},{"$f":"1-NORMSDIST(LN(C11/C3)/(C4*SQRT(F5/365)))","v":0.88715411517309251},{"$f":"C11/C3-1","v":-1.3228756555322962E-2},null,"Short Put Target Minus 1 SD",{"$f":"I3-I8","v":8404.103983558949},{"$f":"NORMSDIST(LN(I11/I3)/(I4*SQRT(L5/365)))","v":0.11232794147753229},{"$f":"1-NORMSDIST(LN(I11/I3)/(I4*SQRT(L5/365)))","v":0.88767205852246767},{"$f":"I11/I3-1","v":-1.7638342073764024E-2},null,"3 SD",0.99739999999999995,{"$f":"O3-R11","v":12612.942502005732},{"$f":"O3+R11","v":14361.057497994268},{"$f":"3*((O3*O4*O5)/O6)","v":874.05749799426826}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2.57583 SD",0.99,{"$f":"O3-R12","v":12736.525491647142},{"$f":"O3+R12","v":14237.474508352858},{"$f":"2.57583*((O3*O4*O5)/O6)","v":750.47450835285861}]
[null,"2 SD",{"$f":"2*((C3*C4*C5)/C6)","v":356.83247932328135},"Close Above Target","Win Prob",null,null,"2 SD",{"$f":"2*((I3*I4*I5)/I6)","v":301.79203288210095},"Close Above Target","Win Prob",null,null,"2.326348 SD",0.98,{"$f":"O3-R13","v":12809.212695885344},{"$f":"O3+R13","v":14164.787304114656},{"$f":"2.326348*((O3*O4*O5)/O6)","v":677.78730411465654}]
[null,"Short Call Target Plus 2 SD",{"$f":"C3+C13","v":13843.83247932328},{"$f":"1-NORMSDIST(LN(C14/C3)/(C4*SQRT(F5/365)))","v":8.7576238409725615E-3},{"$f":"NORMSDIST(LN(C14/C3)/(C4*SQRT(F5/365)))","v":0.99124237615902744},{"$f":"C14/C3-1","v":2.6457513110645925E-2},null,"Short Call Target Plus 2 SD",{"$f":"I3+I13","v":8856.7920328821001},{"$f":"1-NORMSDIST(LN(I14/I3)/(I4*SQRT(L5/365)))","v":9.002442684004075E-3},{"$f":"NORMSDIST(LN(I14/I3)/(I4*SQRT(L5/365)))","v":0.99099755731599593},{"$f":"I14/I3-1","v":3.5276684147527826E-2},null,"2 SD",0.95440000000000003,{"$f":"O3-R14","v":12904.295001337154},{"$f":"O3+R14","v":14069.704998662846},{"$f":"2*((O3*O4*O5)/O6)","v":582.70499866284547}]
[null,null,null,"Close Below Target","Win Prob",null,null,null,null,"Close Below Target","Win Prob",null,null,"1.64485 SD",0.9,{"$f":"O3-R15","v":13007.76884147471},{"$f":"O3+R15","v":13966.23115852529},{"$f":"1.64485*((O3*O4*O5)/O6)","v":479.23115852529065}]
[null,"Short Put Target Minus 2 SD",{"$f":"C3-C13","v":13130.16752067672},{"$f":"NORMSDIST(LN(C16/C3)/(C4*SQRT(F5/365)))","v":7.3555312544155782E-3},{"$f":"1-NORMSDIST(LN(C16/C3)/(C4*SQRT(F5/365)))","v":0.99264446874558443},{"$f":"C16/C3-1","v":-2.6457513110645814E-2},null,"Short Put Target Minus 2 SD",{"$f":"I3-I13","v":8253.2079671178999},{"$f":"NORMSDIST(LN(I16/I3)/(I4*SQRT(L5/365)))","v":7.1332644272718432E-3},{"$f":"1-NORMSDIST(LN(I16/I3)/(I4*SQRT(L5/365)))","v":0.9928667355727282},{"$f":"I16/I3-1","v":-3.5276684147527826E-2},null,"2.326348 SD",0.85,{"$f":"O3-R16","v":12809.212695885344},{"$f":"O3+R16","v":14164.787304114656},{"$f":"2.326348*((O3*O4*O5)/O6)","v":677.78730411465654}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1.281551 SD",0.8,{"$f":"O3-R17","v":13113.616913129315},{"$f":"O3+R17","v":13860.383086870685},{"$f":"1.281551*((O3*O4*O5)/O6)","v":373.38308687068417}]
[null,null,null,"Close Above Target","Win Prob",null,null,null,null,"Close Above Target","Win Prob",null,null,"1.15035 SD",0.75,{"$f":"O3-R18","v":13151.842652394098},{"$f":"O3+R18","v":13822.157347605902},{"$f":"1.15035*((O3*O4*O5)/O6)","v":335.15734760590215}]
[null,"Short Call Manual Target>>",13700,{"$f":"1-NORMSDIST(LN(C19/C3)/(C4*SQRT(F5/365)))","v":7.699824712303871E-2},{"$f":"NORMSDIST(LN(C19/C3)/(C4*SQRT(F5/365)))","v":0.92300175287696129},null,null,"Short Call Manual Target>>",8700,{"$f":"1-NORMSDIST(LN(I19/I3)/(I4*SQRT(L5/365)))","v":0.1257354336102785},{"$f":"NORMSDIST(LN(I19/I3)/(I4*SQRT(L5/365)))","v":0.8742645663897215},null,null,"1.04 SD",0.7,{"$f":"O3-R19","v":13183.993400695321},{"$f":"O3+R19","v":13790.006599304679},{"$f":"1.04*((O3*O4*O5)/O6)","v":303.00659930467964}]
[null,null,null,"Close Below Target","Win Prob",null,null,null,null,"Close Below Target","Win Prob",null,null,"1 SD",0.68259999999999998,{"$f":"O3-R20","v":13195.647500668578},{"$f":"O3+R20","v":13778.352499331422},{"$f":"((O3*O4*O5)/O6)","v":291.35249933142273}]
[null,"Short Put Manual Target>>",13400,{"$f":"NORMSDIST(LN(C21/C3)/(C4*SQRT(F5/365)))","v":0.27801238822063362},{"$f":"1-NORMSDIST(LN(C21/C3)/(C4*SQRT(F5/365)))","v":0.72198761177936643},null,null,"Short Put Manual Target>>",8400,{"$f":"NORMSDIST(LN(I21/I3)/(I4*SQRT(L5/365)))","v":0.10609456067737866},{"$f":"1-NORMSDIST(LN(I21/I3)/(I4*SQRT(L5/365)))","v":0.89390543932262134},null,null,"0.934589 SD",0.65,{"$f":"O3-R21","v":13214.705159002346},{"$f":"O3+R21","v":13759.294840997654},{"$f":"0.934589*((O3*O4*O5)/O6)","v":272.29484099765506}]
[null,null,null,null,null,null,null,null,null,null,null,null,null," 0.841621 SD",0.6,{"$f":"O3-R22","v":13241.791618160189},{"$f":"O3+R22","v":13732.208381839811},{"$f":"0.841621*((O3*O4*O5)/O6)","v":245.20838183981132}]
[null,"1 SD Short Strangle Prob",null,null,{"$f":"(0.5 * E9) + (0.5 * E11)","v":0.8856147920341344},null,null,"1 SD Short Strangle Prob",null,null,{"$f":"(0.5 * K9) + (0.5 * K11)","v":0.88561961531768296},null,null,"0.755415 SD",0.55000000000000004,{"$f":"O3-R23","v":13266.907951717554},{"$f":"O3+R23","v":13707.092048282446},{"$f":"0.755415*((O3*O4*O5)/O6)","v":220.09204828244668}]
[null,"2 SD Short Strangle Prob",null,null,{"$f":"(0.5 * E14) + (0.5 * E16)","v":0.99194342245230593},null,null,"2 SD Short Strangle Prob",null,null,{"$f":"(0.5 * K14) + (0.5 * K16)","v":0.99193214644436201},null,null,"0.67449 SD",0.5,{"$f":"O3-R24","v":13290.485652725949},{"$f":"O3+R24","v":13683.514347274051},{"$f":"0.67449*((O3*O4*O5)/O6)","v":196.51434727405132}]
[null,"Manual Short Strangle Prob",null,null,{"$f":"(0.5 * E19) + (0.5 * E21)","v":0.82249468232816381},null,null,"Manual Short Strangle Prob",null,null,{"$f":"(0.5 * K19) + (0.5 * K21)","v":0.88408500285617142},null,null,"0.597760 SD",0.45,{"$f":"O3-R25","v":13312.84112999965},{"$f":"O3+R25","v":13661.15887000035},{"$f":"0.59776*((O3*O4*O5)/O6)","v":174.15887000035124}]
[]
[null,"DIA",null,null,null,"Date/Exp>>",null,"CL",null,null,null,"Date/Exp>>",null,"DIA",null,null,null,"Date/Exp>>"]
[null,"Stock Price>>",36319,null,null,{"$f":"TODAY()","v":"2021-11-21"},null,"Stock Price>>",7920,null,null,{"$f":"TODAY()","v":"2021-11-21"},null,"Stock Price>>",35000,null,null,"2021-11-21"]
[null,"Implied Volatility>>",0.17,null,null,"2021-12-16",null,"Implied Volatility>>",0.4,null,null,"2021-11-19",null,"Implied Volatility>>",0.17,null,null,"2021-12-17"]
[null,"Sqrt DTE",{"$f":"SQRT(F30)","v":6.0827625302982193},null,null,37,null,"Sqrt DTE",{"$f":"SQRT(L30)","v":1.4142135623730951},null,null,2,null,"Sqrt DTE",2.65,null,null,28]
[null,"Sqrt 252",{"$f":"SQRT(252)","v":15.874507866387544},null,null,null,null,"Sqrt 252",{"$f":"SQRT(252)","v":15.874507866387544},null,null,null,null,"Sqrt 252",15.87]
[]
[null,"1 SD",{"$f":"(C28*C29*C30)/C31","v":2365.8292410415133},"Close Above Target","Win Prob",null,null,"1 SD",{"$f":"(I28*I29*I30)/I31","v":282.2278714595202},"Close Above Target","Win Prob",null,null,"Prob of Price Expiring in Range"]
[null,"Short Call Target Plus 1 SD",{"$f":"C28+C33","v":38684.829241041516},{"$f":"1-NORMSDIST(LN(C34/C28)/(C29*SQRT(F30/365)))","v":0.12182233940637888},{"$f":"NORMSDIST(LN(C34/C28)/(C29*SQRT(F30/365)))","v":0.87817766059362112},{"$f":"C34/C28-1","v":6.5140263802459186E-2},null,"Short Call Target Plus 1 SD",{"$f":"I28+I33","v":8202.2278714595195},{"$f":"1-NORMSDIST(LN(I34/I28)/(I29*SQRT(L30/365)))","v":0.11849315402093452},{"$f":"NORMSDIST(LN(I34/I28)/(I29*SQRT(L30/365)))","v":0.88150684597906548},{"$f":"I34/I28-1","v":3.5634832254989757E-2},null,"Z Score/Std Devs","Winning % Prob","Lower Price","Upper Price","Std Devs"]
[null,null,null,"Close Below Target","Win Prob",null,null,null,null,"Close Below Target","Win Prob",null,null,"3.29053 SD",0.999,31736.89,38263.11,3263.11]
[null,"Short Put Target Minus 1 SD",{"$f":"C28-C33","v":33953.170758958484},{"$f":"NORMSDIST(LN(C36/C28)/(C29*SQRT(F30/365)))","v":0.10665994306468535},{"$f":"1-NORMSDIST(LN(C36/C28)/(C29*SQRT(F30/365)))","v":0.89334005693531471},{"$f":"C36/C28-1","v":-6.5140263802459186E-2},null,"Short Put Target Minus 1 SD",{"$f":"I28-I33","v":7637.7721285404796},{"$f":"NORMSDIST(LN(I36/I28)/(I29*SQRT(L30/365)))","v":0.11019968023924738},{"$f":"1-NORMSDIST(LN(I36/I28)/(I29*SQRT(L30/365)))","v":0.88980031976075258},{"$f":"I36/I28-1","v":-3.5634832254989979E-2},null,"3 SD",0.99739999999999995,32025,37975,2975]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2.57583 SD",0.99,32445.64,37554.36,2554.36]
[null,"2 SD",{"$f":"2*((C28*C29*C30)/C31)","v":4731.6584820830267},"Close Above Target","Win Prob",null,null,"2 SD",{"$f":"2*((I28*I29*I30)/I31)","v":564.4557429190404},"Close Above Target","Win Prob",null,null,"2.326348 SD",0.98,32693.040000000001,37306.959999999999,2306.96]
[null,"Short Call Target Plus 2 SD",{"$f":"C28+C38","v":41050.658482083025},{"$f":"1-NORMSDIST(LN(C39/C28)/(C29*SQRT(F30/365)))","v":1.182955386750062E-2},{"$f":"NORMSDIST(LN(C39/C28)/(C29*SQRT(F30/365)))","v":0.98817044613249938},{"$f":"C39/C28-1","v":0.13028052760491815},null,"Short Call Target Plus 2 SD",{"$f":"I28+I38","v":8484.4557429190409},{"$f":"1-NORMSDIST(LN(I39/I28)/(I29*SQRT(L30/365)))","v":1.003339901547573E-2},{"$f":"NORMSDIST(LN(I39/I28)/(I29*SQRT(L30/365)))","v":0.98996660098452427},{"$f":"I39/I28-1","v":7.1269664509979958E-2},null,"2 SD",0.95440000000000003,33016.67,36983.33,1983.33]
[null,null,null,"Close Below Target","Win Prob",null,null,null,null,"Close Below Target","Win Prob",null,null,"1.64485 SD",0.9,33368.86,36631.14,1631.14]
[null,"Short Put Target Minus 2 SD",{"$f":"C28-C38","v":31587.341517916975},{"$f":"NORMSDIST(LN(C41/C28)/(C29*SQRT(F30/365)))","v":4.9558125983757625E-3},{"$f":"1-NORMSDIST(LN(C41/C28)/(C29*SQRT(F30/365)))","v":0.99504418740162426},{"$f":"C41/C28-1","v":-0.13028052760491826},null,"Short Put Target Minus 2 SD",{"$f":"I28-I38","v":7355.5442570809591},{"$f":"NORMSDIST(LN(I41/I28)/(I29*SQRT(L30/365)))","v":6.2610384500279802E-3},{"$f":"1-NORMSDIST(LN(I41/I28)/(I29*SQRT(L30/365)))","v":0.99373896154997199},{"$f":"I41/I28-1","v":-7.1269664509979958E-2},null,"2.326348 SD",0.85,32693.040000000001,37306.959999999999,2306.96]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1.281551 SD",0.8,33729.129999999997,36270.870000000003,1270.8699999999999]
[null,null,null,"Close Above Target","Win Prob",null,null,null,null,"Close Above Target","Win Prob",null,null,"1.15035 SD",0.75,33859.24,36140.76,1140.76]
[null,"Short Call Manual Target>>",38000,{"$f":"1-NORMSDIST(LN(C44/C28)/(C29*SQRT(F30/365)))","v":0.20159786327376017},{"$f":"NORMSDIST(LN(C44/C28)/(C29*SQRT(F30/365)))","v":0.79840213672623983},null,null,"Short Call Manual Target>>",8000,{"$f":"1-NORMSDIST(LN(I44/I28)/(I29*SQRT(L30/365)))","v":0.36714238292946422},{"$f":"NORMSDIST(LN(I44/I28)/(I29*SQRT(L30/365)))","v":0.63285761707053578},null,null,"1.04 SD",0.7,33968.67,36031.33,1031.33]
[null,null,null,"Close Below Target","Win Prob",null,null,null,null,"Close Below Target","Win Prob",null,null,"1 SD",0.68259999999999998,34008.33,35991.67,991.67]
[null,"Short Put Manual Target>>",34000,{"$f":"NORMSDIST(LN(C46/C28)/(C29*SQRT(F30/365)))","v":0.1114175594258312},{"$f":"1-NORMSDIST(LN(C46/C28)/(C29*SQRT(F30/365)))","v":0.8885824405741688},null,null,"Short Put Manual Target>>",7600,{"$f":"NORMSDIST(LN(I46/I28)/(I29*SQRT(L30/365)))","v":8.1824377858870173E-2},{"$f":"1-NORMSDIST(LN(I46/I28)/(I29*SQRT(L30/365)))","v":0.9181756221411298},null,null,"0.934589 SD",0.65,34073.199999999997,35926.800000000003,926.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null," 0.841621 SD",0.6,34165.39,35834.61,834.61]
[null,"1 SD Short Strangle Prob",null,null,{"$f":"(0.5 * E34) + (0.5 * E36)","v":0.88575885876446792},null,null,"1 SD Short Strangle Prob",null,null,{"$f":"(0.5 * K34) + (0.5 * K36)","v":0.88565358286990903},null,null,"0.755415 SD",0.55000000000000004,34250.879999999997,35749.120000000003,749.12]
[null,"2 SD Short Strangle Prob",null,null,{"$f":"(0.5 * E39) + (0.5 * E41)","v":0.99160731676706182},null,null,"2 SD Short Strangle Prob",null,null,{"$f":"(0.5 * K39) + (0.5 * K41)","v":0.99185278126724818},null,null,"0.67449 SD",0.5,34331.129999999997,35668.870000000003,668.87]
[null,"Manual Short Strangle Prob",null,null,{"$f":"(0.5 * E44) + (0.5 * E46)","v":0.84349228865020431},null,null,"Manual Short Strangle Prob",null,null,{"$f":"(0.5 * K44) + (0.5 * K46)","v":0.77551661960583274},null,null,"0.597760 SD",0.45,34407.22,35592.78,592.78]