{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["DISCLAIMER","WORKSHEET","THEPLOTTER","EXPIRATION","PORTFOLIO DETAILS","RATIO'S","NEAR TERM PL GRAPH","FINAL PL GRAPH","NOTES","DAILY PROFIT CALC","CALCULATORS","CALC GRAPH"],"not_rendered":{"charts":18,"images":20,"macros":1,"external_links":0,"defined_names":2,"comments":6,"pivot_tables":0},"unopened":[{"sheet":"PORTFOLIO DETAILS","index":4,"reason":"not_a_worksheet"},{"sheet":"RATIO'S","index":5,"reason":"not_a_worksheet"},{"sheet":"NEAR TERM PL GRAPH","index":6,"reason":"not_a_worksheet"},{"sheet":"FINAL PL GRAPH","index":7,"reason":"not_a_worksheet"},{"sheet":"CALC GRAPH","index":11,"reason":"not_a_worksheet"}],"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":"DISCLAIMER","index":0,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":false,"merged":[[23,5,24,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"                        REFERENCES"]
[]
[null,null,null,null,null,null,null,null,null,"\"McMillan On Options\" by Lawrence G. McMillan"]
[null,null,null,null,null,null,null,null,"   \"Options as a Strategic Investment\" by Lawrence G. McMillan"]
[null,null,null,null,null,null,null,null,null,"\"High Probability Trading\" by Marcel Link"]
[null,null,null,null,null,null,null,null,null,null,"\"Real Money\" by Jim Cramer"]
[]
[null,null,null,null,null,null,null,null,"No assumption should be made that any of the persons above "]
[null,null,null,null,null,null,null,null," ",null,"endorsed this product. "]

{"sheet":"WORKSHEET","index":1,"n_rows":64,"n_cols":16,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
["3 Month High Volatility",0,null,null,"T= Theoritical",null,null,null,"  HOW TO SET UP POSITIONS"]
["Opening Volatility",0,null,null,null,null,null,null,"ENTER ONLY YELLOW"]
["Stock Opening Price",67.72,null,null,null,null,null,null," "]
["Initial Option Time (Days)",{"$f":"J38","v":237}," ","OPTIONS"," "," ",null,"SC= Sold Call"," "]
["JAN"," ","+QQQRM"," A",null,null,null,"SP =Sold Put"]
["Enter Initial Option Time",237," ",{"$f":"D12+B10-B7-(B9*B10*(B6/365))","v":4.2938321611306529},"T PUT price",null,null,null," ",null,"IF OPTION PRICE>$1.00",{"$f":"B3*K7","v":0}]
["Enter Current Stock Price",67.72,{"$f":"B7+1","v":68.72},{"$f":"((B7*D9)-(((B10*EXP((-B9*(B6/365)))*NORMSDIST(B13)))))-((B7*D9)-(((B10*EXP((-B9*((B6-1)/365)))*NORMSDIST(B13)))))","v":4.3297016701870916E-4},"THETA",null,null,"Enter Shares of Stock",null," ",0,{"$f":"B7-B3","v":0}]
["Enter Implied Volitility",0.19600000000000001,{"$f":"B8+0.01","v":0.20600000000000002},{"$f":"1-D9","v":0.47074416727709578},"PUT DELTA",null," ","Enter Number of Contracts (Option A) ",null," ",1,{"$f":"IF((K8>0),IF(J9=\"PUT\",(D6*(K8*100)), IF(J9=\"SP\",(-D6*(K8*100)),IF(J9=\"SC\", (-D12*(K8*100)),(D12*(K8*100))))),0)","v":423.45992844183229}]
["Enter Risk free interest rate",5.0000000000000001E-3,{"$f":"(LN(B7/B10) + (B9 + C8 * C8/2)* (B6/365))/((C8 * SQRT(B6/365)))","v":7.7698701207624885E-2},{"$f":"NORMSDIST(B12)","v":0.52925583272290422},"CALL DELTA",null,null,"Enter Put / Call"," ","CALL",{"$f":"IF(J9=\"PUT\",D8, IF(J9=\"SP\",-D8,IF(J9=\"SC\", -D9,D9)))","v":0.52925583272290422},{"$f":"I41-(K7*B3)","v":4000},"Enter Slippage A",0]
["Enter Strike Price",68,{"$f":"B12-((C8*SQRT(B6/365)))","v":-9.2595632252009924E-2},{"$f":"1-(ABS(B12-NORMSDIST(C12)))","v":0.50739398141706826},"GAMMA",null,null," ",null," "," ",{"$f":"IF(L9>0,0,L9)","v":0}]
[null,null,null,{"$f":"ABS(D12-D13)","v":0.21703624676240096},"VEGA",null," ","Enter Number of Contracts (Option B) ",null,null,1,{"$f":"IF((K11>0),IF(J12=\"PUT\",(D20*(K11*100)), IF(J12=\"SP\",(-D20*(K11*100)),IF(J12=\"SC\", (-D26*(K11*100)),(D26*(K11*100))))),0)","v":-91.04002132731388}]
[null,{"$f":"(LN(B7/B10) + (B9 + B8 * B8/2)* (B6/365))/((B8 * SQRT(B6/365)))","v":7.3399350342571362E-2},{"$f":"(LN(C7/B10) + (B9 + B8 * B8/2)* (B6/365))/((B8 * SQRT(B6/365)))","v":0.1662130852445321},{"$f":"((B7*D9)-(((B10*EXP((-B9*(B6/365)))*NORMSDIST(B13)))))","v":4.2345992844183229},"T CALL price",null,null,"Enter Put / Call"," ","SC",{"$f":"IF(J12=\"PUT\",D22, IF(J12=\"SP\",-D22,IF(J12=\"SC\", -D23,D23)))","v":-0.46800510546474988},null,"Enter Slippage B",0]
[null,{"$f":"B12-((B8*SQRT(B6/365)))","v":-8.4537623388195288E-2}," ",{"$f":"((B7*D9)-(((B10*EXP((-B9*(B6/365)))*NORMSDIST(C10)))))","v":4.4516355311807239}," "]
["Risk Free IR "," ",null,null,null,null," ","Enter Number of Contracts (Option C) ",null,null,0,{"$f":"IF((K14>0),IF(J15=\"PUT\",(D32*(K14*100)),IF(J15=\"SP\",(-D32*(K14*100)),IF(J15=\"SC\",(-D38*(K14*100)),(D38*(K14*100))))),0)","v":0}]
["2008-10-29"," ",null,null,null,null,null,"Enter Put / Call"," ","PUT",{"$f":"IF(J15=\"PUT\",D34, IF(J15=\"SP\",-D34,IF(J15=\"SC\", -D35,D35)))","v":0},null,"Enter Slippage C",0.1]
[" 3 Month Treasury Bills"]
[null,null,null,null,null,null," ","Enter Number of Contracts (Option D)",null,null,0,{"$f":"IF((K17>0),IF(J18=\"PUT\",(D42*(K17*100)), IF(J18=\"SP\",(-D42*(K17*100)),IF(J18=\"SC\", (-D48*(K17*100)),(D48*(K17*100))))),0)","v":0}]
[" ",null,null," ",null,null,null,"Enter Put / Call"," ","PUT",{"$f":"IF(J18=\"PUT\",D44, IF(J18=\"SP\",-D44,IF(J18=\"SC\", -D45,D45)))","v":0},null,"Enter Slippage D",0]
["MAY"," ","+QQQFU","B",null,null,null," ",null,null," "]
["Initial Option Time",24," ",{"$f":"D26+B24-B21-(B23*B24*(B20/365))","v":1.1680440488895747},"T PUT price",null,null,"Enter BETA",0," "," "]
[null,{"$f":"B7","v":67.72},{"$f":"B21+1","v":68.72},{"$f":"((B21*D23)-(((B24*EXP((-B23*(B20/365)))*NORMSDIST(B27)))))-((B21*D23)-(((B24*EXP((-B23*((B20-1)/365)))*NORMSDIST(B27)))))","v":4.2168652564100739E-4},"THETA",null,null,"Enter STD",0," "," ",null,{"$f":"THEPLOTTER!$I$46+EXPIRATION!$I$38+I47","v":-177.16}]
["Enter Implied Volitility",0.14899999999999999,{"$f":"B22+0.01","v":0.159},{"$f":"1-D23","v":0.53199489453525017},"PUT DELTA",null,null,"Enter ATR",6," "," ",{"$f":"SUM(L8:L17)+(L7*K7)","v":4332.4199071145185},{"$f":"(L22*-1)-I47","v":-4320.9299071145188}]
[" ",{"$f":"B9","v":5.0000000000000001E-3},{"$f":"(LN(B21/B24) + (B23 + C22 * C22/2)* (B20/365))/((C22 * SQRT(B20/365)))","v":-7.2752466701947946E-2},{"$f":"NORMSDIST(B26)","v":0.46800510546474988},"CALL DELTA",null,null,"Enter Total Stock  ",0," "," TIME"," ","Enter Commission Fees"]
["Enter Strike  ",68,{"$f":"B26-((C22*SQRT(B20/365)))","v":-0.12105693871029197},{"$f":"1-(ABS(B26-NORMSDIST(C26)))","v":0.30051538041135684},"GAMMA",null,null,"Buying Power ",2.95,null,"on",{"$f":"L22","v":4332.4199071145185},"STOCK BASE",9.99]
[null,null,null,{"$f":"ABS(D26-D27)","v":6.9043066548200471E-2},"VEGA",null,null,{"$f":"(I24* (I41+EXPIRATION!$I$36))","v":11311.273500000001},{"$f":"IF(H25<=0,H26,I24*(I41+EXPIRATION!$I$36))","v":11311.273500000001},null," "," ","OPTION BASE: ",9.99]
[null,{"$f":"(LN(B21/B24) + (B23 + B22 * B22/2)* (B20/365))/((B22 * SQRT(B20/365)))","v":-8.0285474071808319E-2},{"$f":"(LN(C21/B24) + (B23 + B22 * B22/2)* (B20/365))/((B22 * SQRT(B20/365)))","v":0.30337813204986652},{"$f":"((B21*D23)-(((B24*EXP((-B23*(B20/365)))*NORMSDIST(B27)))))","v":0.9104002132731388},"T CALL price",null,null,{"$f":"I24*I41","v":11800}," A","OFF",{"$f":"IF(J26=\"ON\",IF(B6>0.9,(B6-H27),0.00001),0.0001)","v":1E-4},null,"PER CONTRACT:",0.75]
[null,{"$f":"B26-((B22*SQRT(B20/365)))","v":-0.11849269565126785}," ",{"$f":"((B21*D23)-(((B24*EXP((-B23*(B20/365)))*NORMSDIST(C24)))))","v":0.97944327982133927}," ",null,null,{"$f":"MIN(IF(B6>0.9,B6,1000),    IF(B20>0.9,B20,1000),  IF(B31>0.9,B31,1000), IF(B41>0.9,B41,1000))","v":24}," B","OFF",{"$f":"IF(J27=\"ON\",IF(B20>0.9,(B20-H27),0.00001),0.0001)","v":1E-4},"PROFIT / LOSS",null,{"$f":"SUM(K8+K11+K14+K17)","v":2}]
[null,null,null,null,null,null,null," ","C","OFF",{"$f":"IF(J28=\"ON\",IF(B31>0.9,(B31-H27),0.00001),0.0001)","v":1E-4},{"$f":"L22-L24+(SUM(L29:L33))","v":0}," ",{"$f":"IF((K8>0),1,0)","v":1}]
[null,null,null,null,null,null,null," ","D","OFF",{"$f":"IF(J29=\"ON\",IF(B41>0.9,(B41-H27),0.00001),0.0001)","v":1E-4},null," ",{"$f":"IF((K11>0),1,0)","v":1}]
["JAN"," ","+QQQQQ","C",null,null,{"$f":"ABS(THEPLOTTER!$I$46+WORKSHEET!$I$47)/EXPIRATION!$I$41","v":3.1143866230453768E-3}," "," "," ",null,null," ",{"$f":"IF((K14>0),1,0)","v":0}]
["Initial Option Time",1.0000000000000001E-5,null," ",null,null,{"$f":"B6","v":237}," "," "," "," ",null," ",{"$f":"IF((K17>0),1,0)","v":0}]
[" ",{"$f":"B31-(B4-B6)","v":1.0000000000000001E-5}," ",{"$f":"D38+B36-B33-(B35*B36*(B32/365))","v":2.1327152399821242E-15},"T PUT price",null,null," "," "," "," ",null," ",{"$f":"IF(SUM(N28:N31)>0,1,0)","v":1}]
["Enter Current Stock Price",84.6,{"$f":"B33+1","v":85.6},{"$f":"((B33*D35)-(((B36*EXP((-B35*(B32/365)))*NORMSDIST(B39)))))-((B33*D35)-(((B36*EXP((-B35*((B32-1)/365)))*NORMSDIST(B39)))))","v":3.4246809904914244E-4},"THETA",null," "," "," "," "," ",null,null,{"$f":"IF((K7>0),1,0)","v":0}]
["Enter Implied Volitility",0.26,{"$f":"B34+0.01","v":0.27},{"$f":"1-D35","v":0},"PUT DELTA",null,null," ",null,null,null,{"$f":"(-L8-L11-L14)","v":-332.41990711451842},null,"ON"]
[null,{"$f":"B9","v":5.0000000000000001E-3},{"$f":"(LN(B33/B36) + (B35 + C34 * C34/2)* (B32/365))/((C34 * SQRT(B32/365)))","v":27277.665203356915},{"$f":"NORMSDIST(B38)","v":1},"CALL DELTA",null,null,null,null,null," ",null,null,"OFF",null," "]
["Enter Strike  ",25,{"$f":"B38-((C34*SQRT(B32/365)))","v":28326.806126339037},{"$f":"1-(ABS(B38-NORMSDIST(C38)))","v":-28324.806171029755},"GAMMA",null," "," ",null,null," "," ",null,{"$f":"IF(I37=\"June\",DATEDIF(TODAY(),\"2011/6/20\",\"d\"),IF(I37=\"Jul\",DATEDIF(TODAY(),\"2008/7/20\",\"d\"),IF(I37=\"Aug\",DATEDIF(TODAY(),\"2007/8/20\",\"d\"),IF(I37=\"Sep\",DATEDIF(TODAY(),\"2012/9/20\",\"d\"),IF(I37=\"Oct\",DATEDIF(TODAY(),\"2011/10/22\",\"d\"),IF(I37=\"Nov\",DATEDIF(TODAY(),\"2009/11/22\",\"d\"), ))))))","v":237}]
[null,null,null,{"$f":"ABS(D38-D39)","v":0},"VEGA",null," "," ","SEP"," ",null,null,"BID","ASK"]
[null,{"$f":"(LN(B33/B36) + (B35 + B34 * B34/2)* (B32/365))/((B34 * SQRT(B32/365)))","v":28326.806171029755},{"$f":"(LN(C33/B36) + (B35 + B34 * B34/2)* (B32/365))/((B34 * SQRT(B32/365)))","v":28599.860157635805},{"$f":"((B33*D35)-(((B36*EXP((-B35*(B32/365)))*NORMSDIST(B39)))))","v":59.600000003424654},"T CALL price",null," ",{"$f":"IF(K8>0, ((K8*D12)*100)*IF(J9=\"SC\",0,IF(J9=\"CALL\",1,IF(J9=\"SP\",0,(((K8*D6)*100))/((K8*D12)*100)))),0)","v":423.45992844183229},"  CALC TIME TO EXPIRATION",{"$f":"IF(I37=\"Jan\",DATEDIF(TODAY(),\"2012/1/20\",\"d\"),IF(I37=\"Feb\",DATEDIF(TODAY(),\"2012/2/20\",\"d\"),IF(I37=\"Mar\",DATEDIF(TODAY(),\"2009/3/22\",\"d\"),IF(I37=\"Apr\",DATEDIF(TODAY(),\"2009/4/20\",\"d\"),IF(I37=\"May\",DATEDIF(TODAY(),\"2011/5/20\",\"d\"),IF(I37=\"Dec\",DATEDIF(TODAY(),\"2008/12/31\",\"d\"),N36 ))))))","v":237},null,"Sell To Open",1.94,1.97]
[null,{"$f":"B38-((B34*SQRT(B32/365)))","v":28326.806127994249}," ",{"$f":"((B33*D35)-(((B36*EXP((-B35*(B32/365)))*NORMSDIST(C36)))))","v":59.600000003424654}," ",null," ",{"$f":"IF(K11>0, ((K11*D26)*100)*IF(J12=\"SC\",0,IF(J12=\"CALL\",1,IF(J12=\"SP\",0,(((K11*D20)*100))/((K11*D26)*100)))),0)","v":0},null,null,null,"Buy To Open",16.93,16.940000000000001]
["JAN"," ","+QQQQQ","D",null,null," ",{"$f":"IF(K14>0,((K14*D38)*100)*IF(J15=\"SC\",0,IF(J15=\"CALL\",1,IF(J15=\"SP\",0,(((K14*D32)*100))/((K14*D38)*100)))),0)","v":0},"ENTER AVAIL RISK CAPITAL"]
["Initial Option Time",1.0000000000000001E-5,null," ",null,null," ",{"$f":"IF(K17>0, ((K17*D48)*100)*IF(J18=\"SC\",0,IF(J18=\"CALL\",1,IF(J18=\"SP\",0,(((K17*D42)*100))/((K17*D48)*100)))),0)","v":0},4000,null,null,"Sell To Close",0,0]
[" ",{"$f":"B41-(B4-B6)","v":1.0000000000000001E-5}," ",{"$f":"D48+B46-B43-(B45*B46*(B42/365))","v":2.1327152399821242E-15},"T PUT price",null," ",{"$f":"((EXP(B9*(B4/360))-0.8)/(1.2-0.8))","v":0.50824272537630788}," ",null,null,"Buy To Close",0,0]
[" ",{"$f":"B33","v":84.6},{"$f":"B43+1","v":85.6},{"$f":"((B43*D45)-(((B46*EXP((-B45*(B42/365)))*NORMSDIST(B49)))))-((B43*D45)-(((B46*EXP((-B45*((B42-1)/365)))*NORMSDIST(B49)))))","v":3.4246809904914244E-4},"THETA",null," ","  ","ENTER TOTAL CAPITAL"]
["Enter Implied Volitility",0.62,{"$f":"B44+0.01","v":0.63},{"$f":"1-D45","v":0},"PUT DELTA",null," "," ",4000,null,null," ","Optimal Price "," "]
[null,{"$f":"B9","v":5.0000000000000001E-3},{"$f":"(LN(B43/B46) + (B45 + C44 * C44/2)* (B42/365))/((C44 * SQRT(B42/365)))","v":11690.427986858411},{"$f":"NORMSDIST(B48)","v":1},"CALL DELTA",null," "," ",{"$f":"IF((B7=B3),SUM(H38:H41),0)","v":423.45992844183229},null,null,"Scenero A",{"$f":"M48","v":"Debit Spread"},{"$f":"K60","v":14.980000000000002}]
["Enter Strike  ",25,{"$f":"B48-((C44*SQRT(B42/365)))","v":11878.983171022126},{"$f":"1-(ABS(B48-NORMSDIST(C48)))","v":-11876.983275300468},"GAMMA",null," "," ","COMMISSIONS PAID"," ",null,"Scenero B",{"$f":"M49","v":"Debit Spread"},{"$f":"L60","v":0}]
[null,null,null,{"$f":"ABS(D48-D49)","v":0},"VEGA",null," ",null,{"$f":"((N26*N27)+(N32*N25)+(N24*N33))*(-1)","v":-11.49},null,null,null,"Market Price"]
[null,{"$f":"(LN(B43/B46) + (B45 + B44 * B44/2)* (B42/365))/((B44 * SQRT(B42/365)))","v":11878.983275300468},{"$f":"(LN(C43/B46) + (B45 + B44 * B44/2)* (B42/365))/((B44 * SQRT(B42/365)))","v":11993.489785812684},{"$f":"((B43*D45)-(((B46*EXP((-B45*(B42/365)))*NORMSDIST(B49)))))","v":59.600000003424654},"T CALL price",null," "," ",{"$f":"K7*B3","v":0},null,null,"Scenero A",{"$f":"IF(M38>M39,\"Credit Spread\",\"Debit Spread\")","v":"Debit Spread"},{"$f":"ABS(M38-N39)","v":15.000000000000002}]
[{"$f":"MIN(B8,B22)","v":0.14899999999999999},{"$f":"B48-((B44*SQRT(B42/365)))","v":11878.983172677339}," ",{"$f":"((B43*D45)-(((B46*EXP((-B45*(B42/365)))*NORMSDIST(C46)))))","v":59.600000003424654}," ",null," "," ","INITIAL STOCK EQUITY",null,null,"Scenero B",{"$f":"IF(M41>M42,\"Credit Spread\",\"Debit Spread\")","v":"Debit Spread"},{"$f":"ABS(M41-N42)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"THIS PROGRAM IS BASED ON THE"]
[null,null,null,null,null,null,null,null,null,null,null,"BLACK -SCHOLES OPTION PRICING MODEL"]
["JAN",null,null,null,null,null,null,null,"CALL",null,null,"CREATED BY PAUL PRIVITERA "]
["FEB",null,null,null,null,null,null,null,"PUT"]
["MAR",null,null,null,null,null,null,null,"SC"]
["APR",null,null,null,null,null,null,null,"SP"]
["MAY"]
["JUNE",null,null,null,null,null,null,null,null,null,{"$f":"ABS((M38-N38)/2)+M38","v":1.9550000000000001},{"$f":"ABS((M41-N41)/2)+M41","v":0}]
["JUL",null,null,null,null,null,null,null,null,null,{"$f":"ABS((M39-N39)/2)+M39","v":16.935000000000002},{"$f":"ABS((M42-N42)/2)+M42","v":0}]
["AUG",null,null,null,null,null,null,null,null,null,{"$f":"ABS(K58-K59)","v":14.980000000000002},{"$f":"ABS(L58-L59)","v":0}]
["SEP"]
["OCT"]
["NOV"]
["DEC"]

{"sheet":"THEPLOTTER","index":2,"n_rows":87,"n_cols":36,"rows_kept":87,"cut":false,"hidden":false,"merged":[]}
["Range Setting",24," ",null,null,null,null," "," "]
["Increment Setting",1," ",null,null,null,null," "," ",null,null,null,null,null,null,null,null,null,null,{"$f":"B7+(B2*8)","v":75.72}]
["Stock Opening Price",{"$f":"WORKSHEET!$B$3","v":67.72},139.76020812988281,null,null,null,null,"   "," ",null,null,null,null,null,null,null,null," ",null,null,"Position opening  ",{"$f":"B3","v":67.72},null,null,null,null,null," "]
["Initial Option Time (Spread)",{"$f":"WORKSHEET!$B$4","v":237}," "," "," ","T= Theoritical",null,"SC= Sold Call"," ",null,null,null,null,null,null,null,null," ",null,null,"Price"," ",null,"GREEKS CALC"," ","T= Theoritical",null,"SP= Sold Call","DELTA NEUTRAL CALCULATOR "]
["FEB",null,null,"A",null,null,null,"SP =Sold Put",null,null,null,null,null,null,null,null,null," ",null,null,null,149.56040954589844,null,"A",null,null,null,"SC =Sold Put"]
["Enter Initial Option Time",{"$f":"WORKSHEET!$B$6","v":237}," ",{"$f":"D12+B10-B7-(B9*B10*(B6/365))","v":4.2938321611306529},"T PUT price",null,null,null," ",null,"IF OPTION PRICE>$1.00"," ",null,null,null,null,null," ",null,null,"AUG",{"$f":"B6","v":237}," ",{"$f":"X12+V10-V7-(V9*V10*(V6/365))","v":5.5490421385525943},"T PUT price",null,null,null," ",null,"IF OPTION PRICE>$1.00"," "]
["Enter Current Stock Price",{"$f":"WORKSHEET!$B$7","v":67.72},{"$f":"B7+1","v":68.72},{"$f":"((B7*D9)-(((B10*EXP((-B9*(B6/365)))*NORMSDIST(B13)))))-((B7*D9)-(((B10*EXP((-B9*((B6-1)/365)))*NORMSDIST(B13)))))","v":4.3297016701870916E-4},"THETA",null,null,"Enter Shares of Stock",null," ",{"$f":"WORKSHEET!$K$7","v":0},{"$f":"B7-B3","v":0},null,null,null,null,null,null,null,79.240005493164063,"Enter Current Stock Price",65.290000915527344,{"$f":"V7+1","v":66.290000915527344},{"$f":"((V7*X9)-(((V10*EXP((-V9*(V6/365)))*NORMSDIST(V13)))))-((V7*X9)-(((V10*EXP((-V9*((V6-1)/365)))*NORMSDIST(V13)))))","v":3.4914568331956275E-4},"THETA",null,null,"Enter Shares of Stock",null," ",{"$f":"K7","v":0},{"$f":"V7-V3","v":-2.4299990844726551}]
["            Enter Implied Volitility    ",{"$f":"WORKSHEET!$B$8","v":0.19600000000000001},{"$f":"B8+0.01","v":0.20600000000000002},{"$f":"1-D9","v":0.47074416727709578},"PUT DELTA",null,null,"Enter Number of Contracts (Option A) ",null," ",{"$f":"WORKSHEET!$K$8","v":1},{"$f":"IF((K8>0),IF(J9=\"PUT\",(D6*(K8*100)), IF(J9=\"SP\",(-D6*(K8*100)),IF(J9=\"SC\", (-D12*(K8*100)),(D12*(K8*100))))),0)","v":423.45992844183229}," ",null,null,null,null,null,null,null,"Enter Implied Volitility    ",{"$f":"B8","v":0.19600000000000001},{"$f":"V8+0.01","v":0.20600000000000002},{"$f":"1-X9","v":0.5627619836609481},"PUT DELTA",null,null,"Enter Number of Contracts (Option A) ",null," ",{"$f":"K8","v":1},{"$f":"IF((AE8>0),IF(AD9=\"PUT\",(X6*(AE8*100)), IF(AD9=\"SP\",(-X6*(AE8*100)),IF(AD9=\"SC\", (-X12*(AE8*100)),(X12*(AE8*100))))),0)","v":305.98101773676126}]
["Enter Risk free interest rate",{"$f":"WORKSHEET!$B$9","v":5.0000000000000001E-3},{"$f":"(LN(B7/B10) + (B9 + C8 * C8/2)* (B6/365))/((C8 * SQRT(B6/365)))","v":7.7698701207624885E-2},{"$f":"NORMSDIST(B12)","v":0.52925583272290422},"CALL DELTA",null,null,"Enter Put / Call"," ",{"$f":"WORKSHEET!$J$9","v":"CALL"},{"$f":"IF(J9=\"PUT\",D8, IF(J9=\"SP\",-D8,IF(J9=\"SC\", -D9,D9)))","v":0.52925583272290422},{"$f":"IF(D6<0.25,0.05,(D6+(WORKSHEET!$N$9)))","v":4.2938321611306529},{"$f":"IF(L9>0,L9-D6,0)","v":0},{"$f":"M9*(K8*100)","v":0},{"$f":"IF(J9=\"PUT\",N9, IF(J9=\"SP\",N9,IF(J9=\"SC\", N10,N10)))","v":0},null,null,null,null,null,"Enter Risk free interest rate",{"$f":"B9","v":5.0000000000000001E-3},{"$f":"(LN(V7/V10) + (V9 + W8 * W8/2)* (V6/365))/((W8 * SQRT(V6/365)))","v":-0.14244444693299371},{"$f":"NORMSDIST(V12)","v":0.43723801633905185},"CALL DELTA",null,null,"Enter Put / Call"," ",{"$f":"J9","v":"CALL"},{"$f":"IF(AD9=\"PUT\",X8, IF(AD9=\"SP\",-X8,IF(AD9=\"SC\", -X9,X9)))","v":0.43723801633905185}]
["Enter Strike Price",{"$f":"WORKSHEET!$B$10","v":68},{"$f":"B12-((C8*SQRT(B6/365)))","v":-9.2595632252009924E-2},{"$f":"1-(ABS(B12-NORMSDIST(C12)))","v":0.50739398141706826},"GAMMA",null,null," ",null," "," ",{"$f":"IF(D12<0.25,0.05,(D12+(WORKSHEET!$N$9)))","v":4.2345992844183229},{"$f":"IF(L10>0,(L10-D12),0)","v":0},{"$f":"M10*(K8*100)","v":0}," ",null,null,null,null,null,"Enter Strike Price",{"$f":"B10","v":68},{"$f":"V12-((W8*SQRT(V6/365)))","v":-0.32397057366510906},{"$f":"1-(ABS(V12-NORMSDIST(W12)))","v":0.36663691278810817},"GAMMA",null,null," ",null," "," "]
[null,null,null,{"$f":"ABS(D12-D13)","v":0.21703624676240096},"VEGA",null,null,"Enter Number of Contracts (Option B) ",null,null,{"$f":"WORKSHEET!$K$11","v":1},{"$f":"IF((K11>0),IF(J12=\"PUT\",(D20*(K11*100)), IF(J12=\"SP\",(-D20*(K11*100)),IF(J12=\"SC\", (-D26*(K11*100)),(D26*(K11*100))))),0)","v":-91.04002132731388},null,null,null,null,null,null,null,null,null,null,null,{"$f":"ABS(X12-X13)","v":0.2070179182266294},"VEGA",null,null,"Enter Number of Contracts (Option B) ",null,null,{"$f":"K11","v":1},{"$f":"IF((AE11>0),IF(AD12=\"PUT\",(X20*(AE11*100)), IF(AD12=\"SP\",(-X20*(AE11*100)),IF(AD12=\"SC\", (-X26*(AE11*100)),(X26*(AE11*100))))),0)","v":-19.044532885564891}]
[null,{"$f":"(LN(B7/B10) + (B9 + B8 * B8/2)* (B6/365))/((B8 * SQRT(B6/365)))","v":7.3399350342571362E-2},{"$f":"(LN(C7/B10) + (B9 + B8 * B8/2)* (B6/365))/((B8 * SQRT(B6/365)))","v":0.1662130852445321},{"$f":"((B7*D9)-(((B10*EXP((-B9*(B6/365)))*NORMSDIST(B13)))))","v":4.2345992844183229},"T CALL price",null,null,"Enter Put / Call"," ",{"$f":"WORKSHEET!$J$12","v":"SC"},{"$f":"IF(J12=\"PUT\",D22, IF(J12=\"SP\",-D22,IF(J12=\"SC\", -D23,D23)))","v":-0.46800510546474988},{"$f":"IF(D20<0.25,0.05,(D20+(WORKSHEET!$N$12)))","v":1.1680440488895747},{"$f":"IF(L12>0,L12-D20,0)","v":0},{"$f":"M12*(K11*100)","v":0},{"$f":"IF(J12=\"PUT\",N12, IF(J12=\"SP\",N12,IF(J12=\"SC\", N13,N13)))","v":0},"STRADDLE",null,"ON",null,null,null,{"$f":"(LN(V7/V10) + (V9 + V8 * V8/2)* (V6/365))/((V8 * SQRT(V6/365)))","v":-0.15797559107052778},{"$f":"(LN(W7/V10) + (V9 + V8 * V8/2)* (V6/365))/((V8 * SQRT(V6/365)))","v":-6.1733587161187223E-2},{"$f":"((V7*X9)-(((V10*EXP((-V9*(V6/365)))*NORMSDIST(V13)))))","v":3.0598101773676127},"T CALL price",null,null,"Enter Put / Call"," ",{"$f":"J12","v":"SC"},{"$f":"IF(AD12=\"PUT\",X22, IF(AD12=\"SP\",-X22,IF(AD12=\"SC\", -X23,X23)))","v":-0.14993347587100966}]
[null,{"$f":"B12-((B8*SQRT(B6/365)))","v":-8.4537623388195288E-2}," ",{"$f":"((B7*D9)-(((B10*EXP((-B9*(B6/365)))*NORMSDIST(C10)))))","v":4.4516355311807239}," ",null,null,null,null,null,null,{"$f":"IF(D26<0.25,0.05,(D26+(WORKSHEET!$N$12)))","v":0.9104002132731388},{"$f":"IF(L13>0,(L13-D26),0)","v":0},{"$f":"M13*(K11*100)","v":0},null,"CALL RATIO BSPD",null,"OFF",null,null,null,{"$f":"V12-((V8*SQRT(V6/365)))","v":-0.31591256480129443}," ",{"$f":"((V7*X9)-(((V10*EXP((-V9*(V6/365)))*NORMSDIST(W10)))))","v":3.2668280955942421}," "]
["90 Day Treasury Bills",null,null,null,null,null,null,"Enter Number of Contracts (Option C) ",null,null,{"$f":"WORKSHEET!$K$14","v":0},{"$f":"IF((K14>0),IF(J15=\"PUT\",(D32*(K14*100)),IF(J15=\"SP\",(-D32*(K14*100)),IF(J15=\"SC\",(-D38*(K14*100)),(D38*(K14*100))))),0)","v":0},null,null,null,"D/C SPREAD",null,null,null,null,null,null,null,null,null,null,null,"Enter Number of Contracts (Option C) ",null,null,{"$f":"K14","v":0},{"$f":"IF((AE14>0),IF(AD15=\"PUT\",(X32*(AE14*100)),IF(AD15=\"SP\",(-X32*(AE14*100)),IF(AD15=\"SC\",(-X38*(AE14*100)),(X38*(AE14*100))))),0)","v":0}]
[null," ",null,null,null,null,null,"Enter Put / Call"," ",{"$f":"WORKSHEET!$J$15","v":"PUT"},{"$f":"IF(J15=\"PUT\",D34, IF(J15=\"SP\",-D34,IF(J15=\"SC\", -D35,D35)))","v":0},{"$f":"IF(D32<0.25,0.05,(D32+(WORKSHEET!$N$15)))","v":0.05},{"$f":"IF(L15>0,L15-D32,0)","v":4.9999999999997873E-2},{"$f":"M15*(K14*100)","v":0},{"$f":"IF(J15=\"PUT\",N15, IF(J15=\"SP\",N15,IF(J15=\"SC\", N16,N16)))","v":0},"STRADDLE / LONG",null,null,null,null,null," ",null,null,null,null,null,"Enter Put / Call"," ",{"$f":"J15","v":"PUT"},{"$f":"IF(AD15=\"PUT\",X34, IF(AD15=\"SP\",-X34,IF(AD15=\"SC\", -X35,X35)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D38<0.25,0.05,(D38+(WORKSHEET!$N$15)))","v":59.700000003424655},{"$f":"IF(L16>0,(L16-D38),0)","v":0.10000000000000142},{"$f":"M16*(K14*100)","v":0},null,"DIAG BTFLY"]
[null,null,null,null,null,null,null,"Enter Number of Contracts (Option D ",null,null,{"$f":"WORKSHEET!$K$17","v":0},{"$f":"IF((K17>0),IF(J18=\"PUT\",(D42*(K17*100)), IF(J18=\"SP\",(-D42*(K17*100)),IF(J18=\"SC\", (-D48*(K17*100)),(D48*(K17*100))))),0)","v":0},null,null,null,"BUTTERFLY",null,null,null,null,null,null,null,null,null,null,null,"Enter Number of Contracts (Option D ",null,null,{"$f":"K17","v":0},{"$f":"IF((AE17>0),IF(AD18=\"PUT\",(X42*(AE17*100)), IF(AD18=\"SP\",(-X42*(AE17*100)),IF(AD18=\"SC\", (-X48*(AE17*100)),(X48*(AE17*100))))),0)","v":0}]
[" ",null,null," ",null,null,null,"Enter Put / Call"," ",{"$f":"WORKSHEET!$J$18","v":"PUT"},{"$f":"IF(J18=\"PUT\",D44, IF(J18=\"SP\",-D44,IF(J18=\"SC\", -D45,D45)))","v":0},{"$f":"IF(D42<0.25,0.05,(D42+(WORKSHEET!$N$18)))","v":0.05},{"$f":"IF(L18>0,L18-D42,0)","v":4.9999999999997873E-2},{"$f":"M18*(K17*100)","v":0},{"$f":"IF(J18=\"PUT\",N18, IF(J18=\"SP\",N18,IF(J18=\"SC\", N19,N19)))","v":0},"IRON BUTTERFLY",null,null,null,null," ",null,null," ",null,null,null,"Enter Put / Call"," ",{"$f":"J18","v":"PUT"},{"$f":"IF(AD18=\"PUT\",X44, IF(AD18=\"SP\",-X44,IF(AD18=\"SC\", -X45,X45)))","v":0},null,null," "]
["FEB",null,null,"B",null,null,null,null,null,null," ",{"$f":"IF(D48<0.25,0.05,(D48+(WORKSHEET!$N$18)))","v":59.600000003424654},{"$f":"IF(L19>0,(L19-D48),0)","v":0},{"$f":"M19*(K17*100)","v":0},null,"PUT",null,null,null,null,null,null,null,"B",null,null,null,null,null,null,null,null,null,"PUT"]
["Initial Option Time",{"$f":"WORKSHEET!$B$20","v":24},"1900-01-01",{"$f":"D26+B24-B21-(B23*B24*(B20/365))","v":1.1680440488895747},"T PUT price",null,null," ",null," ",null,null,null,null,{"$f":"SUM(O9:O18)","v":0},"CALL",null,null,null,null,"DEC",{"$f":"B20","v":24},"1900-01-01",{"$f":"X26+V24-V21-(V23*V24*(V20/365))","v":2.8780882489447399},"T PUT price",null,null,"Option  "," "," ",null,null,null,"CALL"]
[null,{"$f":"B7","v":67.72},{"$f":"B21+1","v":68.72},{"$f":"((B21*D23)-(((B24*EXP((-B23*(B20/365)))*NORMSDIST(B27)))))-((B21*D23)-(((B24*EXP((-B23*((B20-1)/365)))*NORMSDIST(B27)))))","v":4.2168652564100739E-4},"THETA",null,null," ",null," ",null,null,null,null,{"$f":"O20/I62","v":0},"SP",null,null,null,null,null,{"$f":"V7","v":65.290000915527344},{"$f":"V21+1","v":66.290000915527344},{"$f":"((V21*X23)-(((V24*EXP((-V23*(V20/365)))*NORMSDIST(V27)))))-((V21*X23)-(((V24*EXP((-V23*((V20-1)/365)))*NORMSDIST(V27)))))","v":1.3149009853385962E-4},"THETA",null,null,{"$f":"(((AE11*100)*AE12)+((AE14*100)*AE15)+((AE17*100)*AE18)+((AE8*100)*AE9))","v":28.730454046804216},{"$f":"IF(AB21<0,(ABS(AB21))-AE7,AE7+AB21)","v":28.730454046804216},"DELTA",null,null,null,"SP"]
["Enter Implied Volitility",{"$f":"WORKSHEET!$B$22","v":0.14899999999999999},{"$f":"B22+0.01","v":0.159},{"$f":"1-D23","v":0.53199489453525017},"PUT DELTA",null,null,null,null,null,null,{"$f":"SUM(L8:L17)+(L7*K7)","v":402.77678282565472},null,null,null,"SC",null,null,null,null,null,{"$f":"B22","v":0.14899999999999999},{"$f":"V22+0.01","v":0.159},{"$f":"1-X23","v":0.85006652412899031},"PUT DELTA",null,null,null,null,null,null,{"$f":"SUM(AF8:AF17)+(AF7*AE7)","v":286.93648485119638},null,"SC"]
[" ",{"$f":"B9","v":5.0000000000000001E-3},{"$f":"(LN(B21/B24) + (B23 + C22 * C22/2)* (B20/365))/((C22 * SQRT(B20/365)))","v":-7.2752466701947946E-2},{"$f":"NORMSDIST(B26)","v":0.46800510546474988},"CALL DELTA",null,null,null," ",null,"Exp Time Values"," ",null,null,null,null,null,null,null,null," ",{"$f":"V9","v":5.0000000000000001E-3},{"$f":"(LN(V21/V24) + (V23 + W22 * W22/2)* (V20/365))/((W22 * SQRT(V20/365)))","v":-0.96903270504850392},{"$f":"NORMSDIST(V26)","v":0.14993347587100966},"CALL DELTA",null,null,null,"DELTA NEUTRAL ADJUSTMENT",null,null,"ENTER INITIAL POSITION"]
["Enter Strike  ",{"$f":"WORKSHEET!$B$24","v":68},{"$f":"B26-((C22*SQRT(B20/365)))","v":-0.12105693871029197},{"$f":"1-(ABS(B26-NORMSDIST(C26)))","v":0.30051538041135684},"GAMMA",null,null,null," ",null,{"$f":"WORKSHEET!$K$24","v":"on"},{"$f":"L22","v":402.77678282565472},null,null,null,null,null,null,null,null,"Enter Strike  ",{"$f":"B24","v":68},{"$f":"V26-((W22*SQRT(V20/365)))","v":-1.0774902131874893},{"$f":"1-(ABS(V26-NORMSDIST(W26)))","v":-0.29816803623609411},"GAMMA",null,null,"Enter Proposed Number of Contracts",null,null,10,{"$f":"L24","v":402.77678282565472}]
[null,null,null,{"$f":"ABS(D26-D27)","v":6.9043066548200471E-2},"VEGA",null,null,null,null,null," "," ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"ABS(X26-X27)","v":3.8969989554024309E-2},"VEGA",null,null,"Enter Option Delta",null,null,0.39," "]
[null,{"$f":"(LN(B21/B24) + (B23 + B22 * B22/2)* (B20/365))/((B22 * SQRT(B20/365)))","v":-8.0285474071808319E-2},{"$f":"(LN(C21/B24) + (B23 + B22 * B22/2)* (B20/365))/((B22 * SQRT(B20/365)))","v":0.30337813204986652},{"$f":"((B21*D23)-(((B24*EXP((-B23*(B20/365)))*NORMSDIST(B27)))))","v":0.9104002132731388},"T CALL price",null,null,null,null,null,{"$f":"WORKSHEET!$K$26","v":1E-4}," ",null,null,null,null,null,null,null,null,null,{"$f":"(LN(V21/V24) + (V23 + V22 * V22/2)* (V20/365))/((V22 * SQRT(V20/365)))","v":-1.0367187485490057},{"$f":"(LN(W21/V24) + (V23 + V22 * V22/2)* (V20/365))/((V22 * SQRT(V20/365)))","v":-0.63888372640236568},{"$f":"((V21*X23)-(((V24*EXP((-V23*(V20/365)))*NORMSDIST(V27)))))","v":0.19044532885564891},"T CALL price",null,null,"Enter Cost of Option",null,null,1.85]
[null,{"$f":"B26-((B22*SQRT(B20/365)))","v":-0.11849269565126785}," ",{"$f":"((B21*D23)-(((B24*EXP((-B23*(B20/365)))*NORMSDIST(C24)))))","v":0.97944327982133927}," ",null,null,null,null,null,{"$f":"WORKSHEET!$K$27","v":1E-4},"PROFIT / LOSS",null,null,null,null,null,null,null,null,null,{"$f":"V26-((V22*SQRT(V20/365)))","v":-1.0749259701284652}," ",{"$f":"((V21*X23)-(((V24*EXP((-V23*(V20/365)))*NORMSDIST(W24)))))","v":0.22941531840967322}," ",null,null,null,{"$f":"AC21+(((AE24*100)*AE25))","v":418.7304540468042},"Final Net Delta",null,"PROFIT / LOSS"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"WORKSHEET!$K$28","v":1E-4},{"$f":"L22-L24","v":0},null,null,null,"PUT",null,null,null,null,null,null,null,null,null,null,null," ",{"$f":"AE26*(AE24*100)","v":1850},"Cost of Transaction",null,{"$f":"AF22-AF24","v":-115.84029797445834},null,"PUT"]
[null,null,null,null,null,null,null,null," "," ",{"$f":"WORKSHEET!$K$29","v":1E-4}," ",null,null,null,{"$f":"IF(A18=\"Jun\",DATEDIF(TODAY(),\"2003/6/20\",\"d\"),IF(A18=\"July\",DATEDIF(TODAY(),\"2003/7/20\",\"d\"),IF(A18=\"Aug\",DATEDIF(TODAY(),\"2003/8/20\",\"d\"),IF(A18=\"Sep\",DATEDIF(TODAY(),\"2003/9/20\",\"d\"),IF(A18=\"Oct\",DATEDIF(TODAY(),\"2003/10/20\",\"d\"),IF(A18=\"Nov\",DATEDIF(TODAY(),\"2003/11/20\",\"d\"), ))))))","v":0},null,"JAN",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V7","v":65.290000915527344},null,{"$f":"IF(U18=\"Jun\",DATEDIF(TODAY(),\"2003/6/20\",\"d\"),IF(U18=\"July\",DATEDIF(TODAY(),\"2003/7/20\",\"d\"),IF(U18=\"Aug\",DATEDIF(TODAY(),\"2003/8/20\",\"d\"),IF(U18=\"Sep\",DATEDIF(TODAY(),\"2003/9/20\",\"d\"),IF(U18=\"Oct\",DATEDIF(TODAY(),\"2003/10/20\",\"d\"),IF(U18=\"Nov\",DATEDIF(TODAY(),\"2003/11/20\",\"d\"), ))))))","v":0},null,"JAN"]
["JUL",null,null,null,null,null,null,null," "," ",null," ",null,null,null,null,null,"FEB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FEB"]
["Initial Option Time",{"$f":"WORKSHEET!$B$31","v":1.0000000000000001E-5},null,"C",null,null,null,null," ",null,null," ",null,null,null,{"$f":"IF(A4=\"Jun\",DATEDIF(TODAY(),\"2003/6/20\",\"d\"),IF(A4=\"July\",DATEDIF(TODAY(),\"2003/7/20\",\"d\"),IF(A4=\"Aug\",DATEDIF(TODAY(),\"2003/8/20\",\"d\"),IF(A4=\"Sep\",DATEDIF(TODAY(),\"2003/9/20\",\"d\"),IF(A4=\"Oct\",DATEDIF(TODAY(),\"2003/10/20\",\"d\"),IF(A4=\"Nov\",DATEDIF(TODAY(),\"2003/11/20\",\"d\"), ))))))","v":0},null,"MAR",null,null," "," ",null,"C",null,null,null,null,null,null,null,null,null,{"$f":"IF(U4=\"Jun\",DATEDIF(TODAY(),\"2003/6/20\",\"d\"),IF(U4=\"July\",DATEDIF(TODAY(),\"2003/7/20\",\"d\"),IF(U4=\"Aug\",DATEDIF(TODAY(),\"2003/8/20\",\"d\"),IF(U4=\"Sep\",DATEDIF(TODAY(),\"2003/9/20\",\"d\"),IF(U4=\"Oct\",DATEDIF(TODAY(),\"2003/10/20\",\"d\"),IF(U4=\"Nov\",DATEDIF(TODAY(),\"2003/11/20\",\"d\"), ))))))","v":0},null,"MAR"]
[" ",{"$f":"B31-(B4-B6)","v":1.0000000000000001E-5}," ",{"$f":"D38+B36-B33-(B35*B36*(B32/365))","v":2.1327152399821242E-15},"T PUT price",null,null,null," "," ",null," ",null,null,null,null,null,"APR",null,null,"JUN",{"$f":"B32","v":1.0000000000000001E-5}," ",{"$f":"X38+V36-V33-(V35*V36*(V32/365))","v":2.1327152399821242E-15},"T PUT price",null,null,null,null,null,null,null,null,null,null,"APR"]
["Enter Current Stock Price",{"$f":"WORKSHEET!$B$33","v":84.6},{"$f":"B33+1","v":85.6},{"$f":"((B33*D35)-(((B36*EXP((-B35*(B32/365)))*NORMSDIST(B39)))))-((B33*D35)-(((B36*EXP((-B35*((B32-1)/365)))*NORMSDIST(B39)))))","v":3.4246809904914244E-4},"THETA",null,null,null," ","  "," "," ",null,null,null,{"$f":"IF(A31=\"Jun\",DATEDIF(TODAY(),\"2003/6/20\",\"d\"),IF(A31=\"July\",DATEDIF(TODAY(),\"2003/7/20\",\"d\"),IF(A31=\"Aug\",DATEDIF(TODAY(),\"2003/8/20\",\"d\"),IF(A31=\"Sep\",DATEDIF(TODAY(),\"2003/9/20\",\"d\"),IF(A31=\"Oct\",DATEDIF(TODAY(),\"2003/10/20\",\"d\"),IF(A31=\"Nov\",DATEDIF(TODAY(),\"2003/11/20\",\"d\"), ))))))","v":0},null,"MAY",null,null,null,{"$f":"V7","v":65.290000915527344},{"$f":"V33+1","v":66.290000915527344},{"$f":"((V33*X35)-(((V36*EXP((-V35*(V32/365)))*NORMSDIST(V39)))))-((V33*X35)-(((V36*EXP((-V35*((V32-1)/365)))*NORMSDIST(V39)))))","v":3.4246809904914244E-4},"THETA",null,null,null,null,null," "," ",null,{"$f":"IF(U31=\"Jun\",DATEDIF(TODAY(),\"2003/6/20\",\"d\"),IF(U31=\"July\",DATEDIF(TODAY(),\"2003/7/20\",\"d\"),IF(U31=\"Aug\",DATEDIF(TODAY(),\"2003/8/20\",\"d\"),IF(U31=\"Sep\",DATEDIF(TODAY(),\"2003/9/20\",\"d\"),IF(U31=\"Oct\",DATEDIF(TODAY(),\"2003/10/20\",\"d\"),IF(U31=\"Nov\",DATEDIF(TODAY(),\"2003/11/20\",\"d\"), ))))))","v":0},null,"MAY"]
["Enter Implied Volitility",{"$f":"WORKSHEET!$B$34","v":0.26},{"$f":"B34+0.01","v":0.27},{"$f":"1-D35","v":0},"PUT DELTA",null,null,"time bo",null,null,2002.6,null,null,null,null,null,null,"JUN",null,null,null,{"$f":"B34","v":0.26},{"$f":"V34+0.01","v":0.27},{"$f":"1-X35","v":0},"PUT DELTA",null,null,null,null,null,null,null,null,null,null,"JUN"]
[null,{"$f":"B9","v":5.0000000000000001E-3},{"$f":"(LN(B33/B36) + (B35 + C34 * C34/2)* (B32/365))/((C34 * SQRT(B32/365)))","v":27277.665203356915},{"$f":"NORMSDIST(B38)","v":1},"CALL DELTA",null,null,null,null,null,1898.15,null,null,null,null,{"$f":"IF(I37=\"Jun\",DATEDIF(TODAY(),\"2004/6/20\",\"d\"),IF(I37=\"Jul\",DATEDIF(TODAY(),\"2004/7/20\",\"d\"),IF(I37=\"Aug\",DATEDIF(TODAY(),\"2005/8/20\",\"d\"),IF(I37=\"Sep\",DATEDIF(TODAY(),\"2005/9/20\",\"d\"),IF(I37=\"Oct\",DATEDIF(TODAY(),\"2003/10/20\",\"d\"),IF(I37=\"Nov\",DATEDIF(TODAY(),\"2003/11/20\",\"d\"), ))))))","v":0},null,"JUL",null,null,null,{"$f":"V9","v":5.0000000000000001E-3},{"$f":"(LN(V33/V36) + (V35 + W34 * W34/2)* (V32/365))/((W34 * SQRT(V32/365)))","v":21480.144396444368},{"$f":"NORMSDIST(V38)","v":1},"CALL DELTA",null,null,null,null,null,null,null,null,{"$f":"IF(AC37=\"Jun\",DATEDIF(TODAY(),\"2003/6/20\",\"d\"),IF(AC37=\"Jul\",DATEDIF(TODAY(),\"2003/7/20\",\"d\"),IF(AC37=\"Aug\",DATEDIF(TODAY(),\"2003/8/20\",\"d\"),IF(AC37=\"Sep\",DATEDIF(TODAY(),\"2003/9/20\",\"d\"),IF(AC37=\"Oct\",DATEDIF(TODAY(),\"2003/10/20\",\"d\"),IF(AC37=\"Nov\",DATEDIF(TODAY(),\"2003/11/20\",\"d\"), ))))))","v":{"$error":"#NUM!"}},null,"JUL"]
["Enter Strike  ",{"$f":"WORKSHEET!$B$36","v":25},{"$f":"B38-((C34*SQRT(B32/365)))","v":28326.806126339037},{"$f":"1-(ABS(B38-NORMSDIST(C38)))","v":-28324.806171029755},"GAMMA",null,null,null," ",null,"DPLOT DATA (CURRENT)",null,null,null,null,null,null,"AUG",null,null,"Enter Strike  ",{"$f":"B36","v":25},{"$f":"V38-((W34*SQRT(V32/365)))","v":22306.303749929852},{"$f":"1-(ABS(V38-NORMSDIST(W38)))","v":-22304.30379462057},"GAMMA",null,null,null,null,null,null,null,null,null,null,"AUG"]
[null,null,null,{"$f":"ABS(D38-D39)","v":0},"VEGA",null,null," ",null,null,null,null,{"$f":"MIN($K$37:$K$49)","v":794.51},null,null,{"$f":"MIN($L$37:$L$49)","v":17.290000915527344},null,"SEP",null,null,null,null,null,{"$f":"ABS(X38-X39)","v":0},"VEGA",null,null,null,"JUL"," ",null,null,null,null,null,"SEP"]
[null,{"$f":"(LN(B33/B36) + (B35 + B34 * B34/2)* (B32/365))/((B34 * SQRT(B32/365)))","v":28326.806171029755},{"$f":"(LN(C33/B36) + (B35 + B34 * B34/2)* (B32/365))/((B34 * SQRT(B32/365)))","v":28599.860157635805},{"$f":"((B33*D35)-(((B36*EXP((-B35*(B32/365)))*NORMSDIST(B39)))))","v":59.600000003424654},"T CALL price",null,null,{"$f":"IF(K8>0, ((K8*D12)*100)*IF(J9=\"SC\",0,IF(J9=\"CALL\",1,IF(J9=\"SP\",0,(((K8*D6)*100))/((K8*D12)*100)))),0)","v":423.45992844183229}," ",null,null,null,{"$f":"MAX($K$37:$K$49)","v":3784.91},null,null,{"$f":"MAX($L$37:$L$49)","v":27.290000915527344},null,"OCT",null,null,null,{"$f":"(LN(V33/V36) + (V35 + V34 * V34/2)* (V32/365))/((V34 * SQRT(V32/365)))","v":22306.30379462057},{"$f":"(LN(W33/V36) + (V35 + V34 * V34/2)* (V32/365))/((V34 * SQRT(V32/365)))","v":22659.504492899781},{"$f":"((V33*X35)-(((V36*EXP((-V35*(V32/365)))*NORMSDIST(V39)))))","v":40.290000918952003},"T CALL price",null,null,null,null,{"$f":"IF(AC37=\"Jan\",DATEDIF(TODAY(),\"2003/1/20\",\"d\"),IF(AC37=\"Feb\",DATEDIF(TODAY(),\"2003/2/20\",\"d\"),IF(AC37=\"Mar\",DATEDIF(TODAY(),\"2003/3/20\",\"d\"),IF(AC37=\"Apr\",DATEDIF(TODAY(),\"2003/4/20\",\"d\"),IF(AC37=\"May\",DATEDIF(TODAY(),\"2003/5/20\",\"d\"),IF(AC37=\"Dec\",DATEDIF(TODAY(),\"2003/12/20\",\"d\"),AH35 ))))))","v":{"$error":"#NUM!"}},null,null,null,null,null,"OCT"]
[null,{"$f":"B38-((B34*SQRT(B32/365)))","v":28326.806127994249}," ",{"$f":"((B33*D35)-(((B36*EXP((-B35*(B32/365)))*NORMSDIST(C36)))))","v":59.600000003424654}," ",null,null,{"$f":"IF(K11>0, ((K11*D26)*100)*IF(J12=\"SC\",0,IF(J12=\"CALL\",1,IF(J12=\"SP\",0,(((K11*D20)*100))/((K11*D26)*100)))),0)","v":0},null,null,3784.91,17.290000915527344," ",null,null," ",null,"NOV",null,null,null,{"$f":"V38-((V34*SQRT(V32/365)))","v":22306.303751585063}," ",{"$f":"((V33*X35)-(((V36*EXP((-V35*(V32/365)))*NORMSDIST(W36)))))","v":40.290000918952003}," ",null,null,null,"TODAY",null,null,null,null,null,null,"NOV"]
["JUL",null,null,null,null,null,null,{"$f":"IF(K14>0,((K14*D38)*100)*IF(J15=\"SC\",0,IF(J15=\"CALL\",1,IF(J15=\"SP\",0,(((K14*D32)*100))/((K14*D38)*100)))),0)","v":0},{"$f":"IF(J40<=0,\"EXCELLENT\",J40)","v":4.3649650850350476E-2},{"$f":"ABS(J43/I43)","v":4.3649650850350476E-2},3359.92,18.290000915527344,{"$f":"MIN(EXPIRATION!$K$36:$K$48)","v":-165.67},null,null,{"$f":"MIN(EXPIRATION!$L$36:$L$48)","v":17.29},null,"DEC",null,null,null,null,null,null,null,null,null,null,"19 DAYS LEFT",null,null,null,null,null,null,"DEC"]
["Initial Option Time",{"$f":"WORKSHEET!$B$41","v":1.0000000000000001E-5},null,"D",null,null,null,{"$f":"IF(K17>0, ((K17*D48)*100)*IF(J18=\"SC\",0,IF(J18=\"CALL\",1,IF(J18=\"SP\",0,(((K17*D42)*100))/((K17*D48)*100)))),0)","v":0},"INITIAL RISK/REWARD",{"$f":"MIN($K39:K865)","v":-165.21},2959.44,19.290000915527344,{"$f":"MAX(EXPIRATION!$K$36:$K$48)","v":3689.33},null,null,{"$f":"MAX(EXPIRATION!$L$36:$L$48)","v":26.29},null,null,null,null," "," ",null,"D",null,null,null,null,"9 DAYS LEFT"]
[" ",{"$f":"B41-(B4-B6)","v":1.0000000000000001E-5}," ",{"$f":"D48+B46-B43-(B45*B46*(B42/365))","v":2.1327152399821242E-15},"T PUT price",null,null,{"$f":"((EXP(B9*(B4/360))-0.8)/(1.2-0.8))","v":0.50824272537630788},null,{"$f":"MIN($K65:K839)","v":-165.21},2586.17,20.290000915527344,null,null,null,null,null,null,null,null,"JUN",{"$f":"B42","v":1.0000000000000001E-5}," ",{"$f":"X48+V46-V43-(V45*V46*(V42/365))","v":2.1327152399821242E-15},"T PUT price"]
[" ",{"$f":"B33","v":84.6},{"$f":"B43+1","v":85.6},{"$f":"((B43*D45)-(((B46*EXP((-B45*(B42/365)))*NORMSDIST(B49)))))-((B43*D45)-(((B46*EXP((-B45*((B42-1)/365)))*NORMSDIST(B49)))))","v":3.4246809904914244E-4},"THETA",null,null," ",{"$f":"MAX($K39:K839)","v":3784.91},{"$f":"MIN($K39:K839)","v":-165.21},2242,21.290000915527344,null,null,null,null,null,null,null,null,null,{"$f":"V7","v":65.290000915527344},{"$f":"V43+1","v":66.290000915527344},{"$f":"((V43*X45)-(((V46*EXP((-V45*(V42/365)))*NORMSDIST(V49)))))-((V43*X45)-(((V46*EXP((-V45*((V42-1)/365)))*NORMSDIST(V49)))))","v":3.4246809904914244E-4},"THETA"]
["Enter Implied Volitility",{"$f":"WORKSHEET!$B$44","v":0.62},{"$f":"B44+0.01","v":0.63},{"$f":"1-D45","v":0},"PUT DELTA",null,null," ","INITIAL PROFIT POTENTIAL",null,1927.98,22.290000915527344,null,null,null,null,null,null,null,null,null,{"$f":"B44","v":0.62},{"$f":"V44+0.01","v":0.63},{"$f":"1-X45","v":0},"PUT DELTA"]
[null,{"$f":"B9","v":5.0000000000000001E-3},{"$f":"(LN(B43/B46) + (B45 + C44 * C44/2)* (B42/365))/((C44 * SQRT(B42/365)))","v":11690.427986858411},{"$f":"NORMSDIST(B48)","v":1},"CALL DELTA",null,null," ",null,null,1644.33,23.290000915527344,null,null,null,null,null,null,null,null,null,{"$f":"V9","v":5.0000000000000001E-3},{"$f":"(LN(V43/V46) + (V45 + W44 * W44/2)* (V42/365))/((W44 * SQRT(V42/365)))","v":9205.7762124673191},{"$f":"NORMSDIST(V48)","v":1},"CALL DELTA"]
["Enter Strike  ",{"$f":"WORKSHEET!$B$46","v":25},{"$f":"B48-((C44*SQRT(B42/365)))","v":11878.983171022126},{"$f":"1-(ABS(B48-NORMSDIST(C48)))","v":-11876.983275300468},"GAMMA",null,null," ",{"$f":"-O20","v":0},null,1390.51,24.290000915527344,null,null,null,null,null,null,null,null,"Enter Strike  ",{"$f":"B46","v":25},{"$f":"V48-((W44*SQRT(V42/365)))","v":9354.2563680118237},{"$f":"1-(ABS(V48-NORMSDIST(W48)))","v":-9352.2564722901661},"GAMMA",null,null,null,null,"S"]
[null,null,null,{"$f":"ABS(D48-D49)","v":0},"VEGA",null," ",null,"SLIPPAGE",null,1165.3900000000001,25.290000915527344,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ABS(X48-X49)","v":0},"VEGA"]
[null,{"$f":"(LN(B43/B46) + (B45 + B44 * B44/2)* (B42/365))/((B44 * SQRT(B42/365)))","v":11878.983275300468},{"$f":"(LN(C43/B46) + (B45 + B44 * B44/2)* (B42/365))/((B44 * SQRT(B42/365)))","v":11993.489785812684},{"$f":"((B43*D45)-(((B46*EXP((-B45*(B42/365)))*NORMSDIST(B49)))))","v":59.600000003424654},"T CALL price",null,null," ",null,null,967.37,26.290000915527344,null,null,null,null,null,null,null,null,null,{"$f":"(LN(V43/V46) + (V45 + V44 * V44/2)* (V42/365))/((V44 * SQRT(V42/365)))","v":9354.2564722901661},{"$f":"(LN(W43/V46) + (V45 + V44 * V44/2)* (V42/365))/((V44 * SQRT(V42/365)))","v":9502.3728941491881},{"$f":"((V43*X45)-(((V46*EXP((-V45*(V42/365)))*NORMSDIST(V49)))))","v":40.290000918952003},"T CALL price"]
[null,{"$f":"B48-((B44*SQRT(B42/365)))","v":11878.983172677339}," ",{"$f":"((B43*D45)-(((B46*EXP((-B45*(B42/365)))*NORMSDIST(C46)))))","v":59.600000003424654}," ",null," "," ",{"$f":"WORKSHEET!$I41/WORKSHEET!$I44","v":1},null,794.51,27.290000915527344,null,null,null,null,null,null,null,null,null,{"$f":"V48-((V44*SQRT(V42/365)))","v":9354.2563696670368}," ",{"$f":"((V43*X45)-(((V46*EXP((-V45*(V42/365)))*NORMSDIST(W46)))))","v":40.290000918952003}," "]
[null,null,null,null,null,null,null,{"$f":"SUM(B1*2)/(B2)","v":48},"Risk Capital To Total Capital",null,644.66999999999996,28.290000915527344]
[null,null,null,null,null,null,null,null,null,null,515.61,29.290000915527344]
[null,null,null,null,null,null,null,null,null,null,405.11,30.290000915527344]
[null,null,null,null,null,null,null,null,null,null,311,31.290000915527344]
[null,null,null,null,null,null,null,null,null,null,231.26,32.290000915527344]
[null,null,null,null,null,null,null,null,null,null,163.98,33.290000915527344]
[null,null,null,null,null,null,null,null,null,null,107.44,34.290000915527344]
[null,null,null,null,null,null,null,null,null,null,60.11,35.290000915527344]
[null,null,null,null,null,null,null,null,null,null,20.62,36.290000915527344," "]
[null,null,null,null,null,null," ",null,{"$f":"WORKSHEET!$I$44","v":4000},null,-12.24,37.290000915527344," "]
[null,null,null,null,null,null,null,null,"TOTAL CAPITAL",null,-39.5,38.290000915527344]
[null,null,null,null,null,null,null,null,{"$f":"WORKSHEET!$I$41/WORKSHEET!$I$44","v":1},null,-62.06,39.290000915527344]
[null,null,null,null,null,null,null,null,{"$f":"WORKSHEET!$I$41","v":4000},null,-80.7,40.290000915527344]
[null,null,null,null,null,null,null,null,"INITIAL LOSS POTENTIAL",null,-96.06,41.290000915527344]
[null,null,null,null,null,null,null,null,{"$f":"J41","v":-165.21},null,-108.7,42.290000915527344]
[null,null,null,null,null,null,null,null," ",null,-119.08,43.290000915527344]
[null,null,null,null,null,null,null,null,{"$f":"IF(K100>K75,\"DOWNSIDE Risk \",\"UPSIDE Risk\")","v":"DOWNSIDE Risk "},null,-127.61,44.290000915527344]
[null,null,null,null,null,null,null,null,{"$f":"IF(K50<K39,\"UPSIDE Risk \",\"DOWNSIDE Risk\")","v":"UPSIDE Risk "},null,-134.59,45.290000915527344]
[null,null,null,null,null,null,null,"ABS(J41/WORKSHEET!$I$41)",null,null,-140.31,46.290000915527344]
[null,null,null,null,null,null,null,null,"INITIAL TRADE RISK  ",null,-144.97999999999999,47.290000915527344]
[null,null,null,null,null,null,null,null,{"$f":"ABS(I64)/WORKSHEET!I41","v":4.1302499999999999E-2},null,-148.80000000000001,48.290000915527344]
[null,null,null,null,null,null,null,null,null,null,-151.93,49.290000915527344]
[null,null,null,null,null,null,null,null,null,null,-154.47999999999999,50.290000915527344]
[null,null,null,null,null,null,null,null,null,null,-156.55000000000001,51.290000915527344]
[null,null,null,null,null,null,null,null,null,null,-158.25,52.290000915527344]
[null,null,null,null,null,null,null,null,null,null,-159.63,53.290000915527344]
[null,null,null,null,null,null,null,null,null,null,-160.76,54.290000915527344]
[null,null,null,null,null,null,null,null,null,null,-161.68,55.290000915527344]
[null,null,null,null,null,null,null,null,null,null,-162.43,56.290000915527344]
[null,null,null,null,null,null,null,null,null,null,-163.04,57.290000915527344]
[null,null,null,null,null,null,null,null,null,null,-163.54,58.290000915527344]
[null,null,null,null,null,null,null,null,null,null,-163.94,59.290000915527344]
[null,null,null,null,null,null,null,null,null,null,-164.27,60.290000915527344]
[null,null,null,null,null,null,null,null,null,null,-164.54,61.290000915527344]
[null,null,null,null,null,null,null,null,null,null,-164.76,62.290000915527344]
[null,null,null,null,null,null,null,null,null,null,-164.94,63.290000915527344]
[null,null,null,null,null,null,null,null,null,null,-165.09,64.290000915527344]
[null,null,null,null,null,null,null,null,null,null,-165.21,65.290000915527344]

{"sheet":"EXPIRATION","index":3,"n_rows":87,"n_cols":34,"rows_kept":87,"cut":false,"hidden":false,"merged":[]}
[null,null," ",null,null,null,null," ","ENTER ONLY YELLOW"]
["Opening Stock Price",{"$f":"THEPLOTTER!B3","v":67.72}," ",null,null,null,null," ",null,null,null,null,null,null,null," ",null,null,"Position opening  ",{"$f":"B2","v":67.72},null,null,null,null,null," "]
["Initial Option Time (Spread)",{"$f":"THEPLOTTER!B4","v":237},null,"GREEKS CALC"," ","T= Theoritical",null,"SC= Sold Call"," ",null,null,null,null,null,null," ",null,null,"Price"," ",null,"GREEKS CALC"," ","T= Theoritical",null,"SP= Sold Call","DELTA NEUTRAL CALCULATOR "]
[null,{"$f":"THEPLOTTER!H32","v":0},null,"A",null,null,null,"SP =Sold Put",null,null,null,null,null,null,null," ",null,null,null,null,null,"A",null,null,null,"SC =Sold Put"]
["AUG",{"$f":"IF(WORKSHEET!$K$24=\"ON\",WORKSHEET!$K$26,0.00001)","v":1E-4}," ",{"$f":"D11+B9-B6-(B8*B9*(B5/365))","v":0.27999990684931619},"T PUT price",null," ",null," ",null,"IF OPTION PRICE>$1.00"," ",null,null,null," ",null,null,"AUG",{"$f":"B5","v":1E-4}," ",{"$f":"V11+T9-T6-(T8*T9*(T5/365))","v":2.7099999068493088},"T PUT price",null,null,null," ",null,"IF OPTION PRICE>$1.00"," "]
[{"$f":"THEPLOTTER!B1","v":24},{"$f":"THEPLOTTER!B7","v":67.72},{"$f":"B6+1","v":68.72},{"$f":"((B6*D8)-(((B9*EXP((-B8*(B5/365)))*NORMSDIST(B12)))))-((B6*D8)-(((B9*EXP((-B8*((B5-1)/365)))*NORMSDIST(B12)))))","v":0},"THETA",null,null,null,null," ",{"$f":"THEPLOTTER!K7","v":0},{"$f":"B6-B2","v":0},null,null,null,null,null,null,"Enter Current Stock Price",65.290000000000006,{"$f":"T6+1","v":66.290000000000006},{"$f":"((T6*V8)-(((T9*EXP((-T8*(T5/365)))*NORMSDIST(T12)))))-((T6*V8)-(((T9*EXP((-T8*((T5-1)/365)))*NORMSDIST(T12)))))","v":0},"THETA",null,null,"Enter Shares of Stock",null," ",{"$f":"K6","v":0},{"$f":"T6-T2","v":-2.4299999999999926}]
[{"$f":"THEPLOTTER!B2","v":1},{"$f":"THEPLOTTER!B8+B4","v":0.19600000000000001},{"$f":"B7+0.01","v":0.20600000000000002},{"$f":"1-D8","v":1},"PUT DELTA",null,null,null,null," ",{"$f":"THEPLOTTER!K8","v":1},{"$f":"IF((K7>0),IF(J8=\"PUT\",(D5*(K7*100)), IF(J8=\"SP\",(-D5*(K7*100)),IF(J8=\"SC\", (-D11*(K7*100)),(D11*(K7*100))))),0)","v":0},null,null,null,null,null,null,"Enter Implied Volitility    ",{"$f":"THEPLOTTER!V8","v":0.19600000000000001},{"$f":"T7+0.01","v":0.20600000000000002},135.27999877929687,"PUT DELTA",null,null,"Enter Number of Contracts (Option A) ",null," ",{"$f":"K7","v":1},{"$f":"IF((AC7>0),IF(AB8=\"PUT\",(V5*(AC7*100)), IF(AB8=\"SP\",(-V5*(AC7*100)),IF(AB8=\"SC\", (-V11*(AC7*100)),(V11*(AC7*100))))),0)","v":0}]
[{"$f":"THEPLOTTER!B7","v":67.72},{"$f":"THEPLOTTER!B9","v":5.0000000000000001E-3},{"$f":"(LN(B6/B9) + (B8 + C7 * C7/2)* (B5/365))/((C7 * SQRT(B5/365)))","v":-38.266897051386387},{"$f":"NORMSDIST(B11)","v":0},"CALL DELTA",null,null,null,null,{"$f":"THEPLOTTER!J9","v":"CALL"},{"$f":"IF(J8=\"PUT\",D7, IF(J8=\"SP\",-D7,IF(J8=\"SC\", -D8,D8)))","v":0},null,null,null,null,null,null,null,"Enter Risk free interest rate",{"$f":"THEPLOTTER!V9","v":5.0000000000000001E-3},{"$f":"(LN(T6/T9) + (T8 + U7 * U7/2)* (T5/365))/((U7 * SQRT(T5/365)))","v":-377.17309586427018},{"$f":"NORMSDIST(T11)","v":0},"CALL DELTA",null,null,"Enter Put / Call"," ",{"$f":"J8","v":"CALL"},{"$f":"IF(AB8=\"PUT\",V7, IF(AB8=\"SP\",-V7,IF(AB8=\"SC\", -V8,V8)))","v":0}]
[null,{"$f":"THEPLOTTER!B10","v":68},{"$f":"B11-((C7*SQRT(B5/365)))","v":-40.219402951183561},{"$f":"1-(ABS(B11-NORMSDIST(C11)))","v":-40.21929512585551},"GAMMA",null,null,null,null," "," ",null,null,null,null,null,null,null,"Enter Strike Price",{"$f":"THEPLOTTER!V10","v":68},{"$f":"T11-((U7*SQRT(T5/365)))","v":-396.41673435656139},{"$f":"1-(ABS(T11-NORMSDIST(U11)))","v":-395.41662653123336},"GAMMA",null,null," ",null," "," "]
[null,null,null,{"$f":"ABS(D11-D12)","v":0},"VEGA",null,null,null,null,null,{"$f":"THEPLOTTER!K11","v":1},{"$f":"IF((K10>0),IF(J11=\"PUT\",(D19*(K10*100)), IF(J11=\"SP\",(-D19*(K10*100)),IF(J11=\"SC\", (-D25*(K10*100)),(D25*(K10*100))))),0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"ABS(V11-V12)","v":0},"VEGA",null,null,"Enter Number of Contracts (Option B) ",null,null,{"$f":"K10","v":1},{"$f":"IF((AC10>0),IF(AB11=\"PUT\",(V19*(AC10*100)), IF(AB11=\"SP\",(-V19*(AC10*100)),IF(AB11=\"SC\", (-V25*(AC10*100)),(V25*(AC10*100))))),0)","v":0}]
[null,{"$f":"(LN(B6/B9) + (B8 + B7 * B7/2)* (B5/365))/((B7 * SQRT(B5/365)))","v":-40.21929512585551},{"$f":"(LN(C6/B9) + (B8 + B7 * B7/2)* (B5/365))/((B7 * SQRT(B5/365)))","v":102.66563356114746},{"$f":"((B6*D8)-(((B9*EXP((-B8*(B5/365)))*NORMSDIST(B12)))))","v":0},"T CALL price",null,null,null,null,{"$f":"THEPLOTTER!J12","v":"SC"},{"$f":"IF(J11=\"PUT\",D21, IF(J11=\"SP\",-D21,IF(J11=\"SC\", -D22,D22)))","v":0},null,null,null,null,null,null,null,null,{"$f":"(LN(T6/T9) + (T8 + T7 * T7/2)* (T5/365))/((T7 * SQRT(T5/365)))","v":-396.41662653123336},{"$f":"(LN(U6/T9) + (T8 + T7 * T7/2)* (T5/365))/((T7 * SQRT(T5/365)))","v":-248.25394273040894},{"$f":"((T6*V8)-(((T9*EXP((-T8*(T5/365)))*NORMSDIST(T12)))))","v":0},"T CALL price",null,null,"Enter Put / Call"," ",{"$f":"J11","v":"SC"},{"$f":"IF(AB11=\"PUT\",V21, IF(AB11=\"SP\",-V21,IF(AB11=\"SC\", -V22,V22)))","v":0}]
[null,{"$f":"B11-((B7*SQRT(B5/365)))","v":-40.219397716944336}," ",{"$f":"((B6*D8)-(((B9*EXP((-B8*(B5/365)))*NORMSDIST(C9)))))","v":0}," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T11-((T7*SQRT(T5/365)))","v":-396.41672912232218}," ",{"$f":"((T6*V8)-(((T9*EXP((-T8*(T5/365)))*NORMSDIST(U9)))))","v":0}," "]
[null,null,null,null,null,null,null,null,null,null,{"$f":"THEPLOTTER!K14","v":0},{"$f":"IF((K13>0),IF(J14=\"PUT\",(D31*(K13*100)),IF(J14=\"SP\",(-D31*(K13*100)),IF(J14=\"SC\",(-D37*(K13*100)),(D37*(K13*100))))),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter Number of Contracts (Option C) ",null,null,{"$f":"K13","v":0},{"$f":"IF((AC13>0),IF(AB14=\"PUT\",(V31*(AC13*100)),IF(AB14=\"SP\",(-V31*(AC13*100)),IF(AB14=\"SC\",(-V37*(AC13*100)),(V37*(AC13*100))))),0)","v":0}]
[null," ",null,null,null,null,null,null,null,{"$f":"THEPLOTTER!J15","v":"PUT"},{"$f":"IF(J14=\"PUT\",D33, IF(J14=\"SP\",-D33,IF(J14=\"SC\", -D34,D34)))","v":0},null,null,null,null,null,null,null,null," ",null,null,null,null,null,"Enter Put / Call"," ",{"$f":"J14","v":"PUT"},{"$f":"IF(AB14=\"PUT\",V33, IF(AB14=\"SP\",-V33,IF(AB14=\"SC\", -V34,V34)))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"THEPLOTTER!K17","v":0},{"$f":"IF((K16>0),IF(J17=\"PUT\",(D41*(K16*100)), IF(J17=\"SP\",(-D41*(K16*100)),IF(J17=\"SC\", (-D47*(K16*100)),(D47*(K16*100))))),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter Number of Contracts (Option D ",null,null,{"$f":"K16","v":0},{"$f":"IF((AC16>0),IF(AB17=\"PUT\",(V41*(AC16*100)), IF(AB17=\"SP\",(V41*(-AC16*100)),IF(AB17=\"SC\", (-V47*(AC16*100)),(V47*(AC16*100))))),0)","v":0}]
[" ",null,null," ",null,null,null,null,null,{"$f":"THEPLOTTER!J18","v":"PUT"},{"$f":"IF(J17=\"PUT\",D43, IF(J17=\"SP\",-D43,IF(J17=\"SC\", -D44,D44)))","v":0},null,null," ",null,null,null,null," ",null,null," ",null,null,null,"Enter Put / Call"," ",{"$f":"J17","v":"PUT"},{"$f":"IF(AB17=\"PUT\",V43, IF(AB17=\"SP\",-V43,IF(AB17=\"SC\", -V44,V44)))","v":0},null,null," "]
[null,null,null,"B",null,null,null,null,null,null,null,null,null,"PUT",null,null,null,null,null,null,null,"B",null,null,null,null,null,null,null,null,null,"PUT"]
["MAR",{"$f":"IF(WORKSHEET!K24=\"ON\",WORKSHEET!K27,0.00001)","v":1E-4},"1900-01-01",{"$f":"D25+B23-B20-(B22*B23*(B19/365))","v":0.27999990684931619},"T PUT price",null,null," "," "," ",null,null,null,"CALL",null,null,null,null,"DEC",{"$f":"B19","v":1E-4},"1900-01-01",{"$f":"V25+T23-T20-(T22*T23*(T19/365))","v":2.7099999068493088},"T PUT price",null,null,"Option  "," "," ",null,null,null,"CALL"]
[null,{"$f":"B6","v":67.72},{"$f":"B20+1","v":68.72},{"$f":"((B20*D22)-(((B23*EXP((-B22*(B19/365)))*NORMSDIST(B26)))))-((B20*D22)-(((B23*EXP((-B22*((B19-1)/365)))*NORMSDIST(B26)))))","v":0},"THETA",null,null," "," "," ",null,null,null,"SP",null,null,null,null,null,{"$f":"T6","v":65.290000000000006},{"$f":"T20+1","v":66.290000000000006},{"$f":"((T20*V22)-(((T23*EXP((-T22*(T19/365)))*NORMSDIST(T26)))))-((T20*V22)-(((T23*EXP((-T22*((T19-1)/365)))*NORMSDIST(T26)))))","v":0},"THETA",null,null,{"$f":"(((AC10*100)*AC11)+((AC13*100)*AC14)+((AC16*100)*AC17)+((AC7*100)*AC8))","v":0},{"$f":"IF(Z20<0,(ABS(Z20))-AC6,AC6+Z20)","v":0},"DELTA",null,null,null,"SP"]
[null,{"$f":"THEPLOTTER!B22+B4","v":0.14899999999999999},{"$f":"B21+0.01","v":0.159},{"$f":"1-D22","v":1},"PUT DELTA",null,null,null,null,null,null,{"$f":"SUM(L7:L16)+(L6*K6)","v":0},null,"SC",null,null,null,null,null,{"$f":"B21","v":0.14899999999999999},{"$f":"T21+0.01","v":0.159},{"$f":"1-V22","v":1},"PUT DELTA",null,null,null,null,null,null,{"$f":"SUM(AD7:AD16)+(AD6*AC6)","v":0},null,"SC"]
[" ",{"$f":"B8","v":5.0000000000000001E-3},{"$f":"(LN(B20/B23) + (B22 + C21 * C21/2)* (B19/365))/((C21 * SQRT(B19/365)))","v":-49.578523787762848},{"$f":"NORMSDIST(B25)","v":0},"CALL DELTA",null,null,null,null,null,null,"ENTER INITIAL POSITION",null,null,null,null,null,null," ",{"$f":"T8","v":5.0000000000000001E-3},{"$f":"(LN(T20/T23) + (T22 + U21 * U21/2)* (T19/365))/((U21 * SQRT(T19/365)))","v":-488.66454237552432},{"$f":"NORMSDIST(T25)","v":0},"CALL DELTA",null,null,null,"DELTA NEUTRAL ADJUSTMENT",null,null,"ENTER INITIAL POSITION"]
[null,{"$f":"THEPLOTTER!B24","v":68},{"$f":"B25-((C21*SQRT(B19/365)))","v":-52.906030125928069},{"$f":"1-(ABS(B25-NORMSDIST(C25)))","v":-52.905946901524381},"GAMMA",null,null,null,null,null,null,{"$f":"THEPLOTTER!L24","v":402.77678282565472},null,null,null,null,null,null,"Enter Strike  ",{"$f":"B23","v":68},{"$f":"T25-((U21*SQRT(T19/365)))","v":-521.46090902159301},{"$f":"1-(ABS(T25-NORMSDIST(U25)))","v":-520.46082579718927},"GAMMA",null,null,"Enter Proposed Number of Contracts",null,null,10,{"$f":"L23","v":402.77678282565472}]
[null,null,null,{"$f":"ABS(D25-D26)","v":0},"VEGA",null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,{"$f":"ABS(V25-V26)","v":0},"VEGA",null,null,"Enter Option Delta",null,null,0.39," "]
[null,{"$f":"(LN(B20/B23) + (B22 + B21 * B21/2)* (B19/365))/((B21 * SQRT(B19/365)))","v":-52.905946901524381},{"$f":"(LN(C20/B23) + (B22 + B21 * B21/2)* (B19/365))/((B21 * SQRT(B19/365)))","v":135.05006667332518},{"$f":"((B20*D22)-(((B23*EXP((-B22*(B19/365)))*NORMSDIST(B26)))))","v":0},"T CALL price",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(LN(T20/T23) + (T22 + T21 * T21/2)* (T19/365))/((T21 * SQRT(T19/365)))","v":-521.46082579718927},{"$f":"(LN(U20/T23) + (T22 + T21 * T21/2)* (T19/365))/((T21 * SQRT(T19/365)))","v":-326.56226187127248},{"$f":"((T20*V22)-(((T23*EXP((-T22*(T19/365)))*NORMSDIST(T26)))))","v":0},"T CALL price",null,null,"Enter Cost of Option",null,null,1.85]
[null,{"$f":"B25-((B21*SQRT(B19/365)))","v":-52.906024891688844}," ",{"$f":"((B20*D22)-(((B23*EXP((-B22*(B19/365)))*NORMSDIST(C23)))))","v":0}," ",null,null,null,null,null,null,"PROFIT / LOSS",null,null,null,null,null,null,null,{"$f":"T25-((T21*SQRT(T19/365)))","v":-521.46090378735369}," ",{"$f":"((T20*V22)-(((T23*EXP((-T22*(T19/365)))*NORMSDIST(U23)))))","v":0}," ",null,null,null,{"$f":"AA20+(((AC23*100)*AC24))","v":390},"Final Net Delta",null,"PROFIT / LOSS"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L21-L23","v":-402.77678282565472},null,"PUT",null,null,null,null,null,null,null,null,null,null,null," ",{"$f":"AC25*(AC23*100)","v":1850},"Cost of Transaction",null,{"$f":"AD21-AD23","v":-402.77678282565472},null,"PUT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A17=\"Jun\",DATEDIF(TODAY(),\"2003/6/20\",\"d\"),IF(A17=\"July\",DATEDIF(TODAY(),\"2003/7/20\",\"d\"),IF(A17=\"Aug\",DATEDIF(TODAY(),\"2003/8/20\",\"d\"),IF(A17=\"Sep\",DATEDIF(TODAY(),\"2003/9/20\",\"d\"),IF(A17=\"Oct\",DATEDIF(TODAY(),\"2003/10/20\",\"d\"),IF(A17=\"Nov\",DATEDIF(TODAY(),\"2003/11/20\",\"d\"), ))))))","v":0},null,"JAN",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T6","v":65.290000000000006},null,{"$f":"IF(S17=\"Jun\",DATEDIF(TODAY(),\"2003/6/20\",\"d\"),IF(S17=\"July\",DATEDIF(TODAY(),\"2003/7/20\",\"d\"),IF(S17=\"Aug\",DATEDIF(TODAY(),\"2003/8/20\",\"d\"),IF(S17=\"Sep\",DATEDIF(TODAY(),\"2003/9/20\",\"d\"),IF(S17=\"Oct\",DATEDIF(TODAY(),\"2003/10/20\",\"d\"),IF(S17=\"Nov\",DATEDIF(TODAY(),\"2003/11/20\",\"d\"), ))))))","v":0},null,"JAN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FEB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FEB"]
[null,{"$f":"THEPLOTTER!B31","v":1.0000000000000001E-5},null,"C",null,null,null,null,null,null,null,null,null,{"$f":"IF(A3=\"Jun\",DATEDIF(TODAY(),\"2003/6/20\",\"d\"),IF(A3=\"July\",DATEDIF(TODAY(),\"2003/7/20\",\"d\"),IF(A3=\"Aug\",DATEDIF(TODAY(),\"2003/8/20\",\"d\"),IF(A3=\"Sep\",DATEDIF(TODAY(),\"2003/9/20\",\"d\"),IF(A3=\"Oct\",DATEDIF(TODAY(),\"2003/10/20\",\"d\"),IF(A3=\"Nov\",DATEDIF(TODAY(),\"2003/11/20\",\"d\"), ))))))","v":0},null,"MAR",null,null," "," ",null,"C",null,null,null,null,null,null,null,null,null,{"$f":"IF(S3=\"Jun\",DATEDIF(TODAY(),\"2003/6/20\",\"d\"),IF(S3=\"July\",DATEDIF(TODAY(),\"2003/7/20\",\"d\"),IF(S3=\"Aug\",DATEDIF(TODAY(),\"2003/8/20\",\"d\"),IF(S3=\"Sep\",DATEDIF(TODAY(),\"2003/9/20\",\"d\"),IF(S3=\"Oct\",DATEDIF(TODAY(),\"2003/10/20\",\"d\"),IF(S3=\"Nov\",DATEDIF(TODAY(),\"2003/11/20\",\"d\"), ))))))","v":0},null,"MAR"]
["JUN",{"$f":"IF(WORKSHEET!K24=\"ON\",WORKSHEET!K28,(B30-(B3-B5)))","v":1E-4}," ",{"$f":"D37+B35-B32-(B34*B35*(B31/365))","v":-7.0945570264468628E-15},"T PUT price",null,null,null,null,null,null,null,null,null,null,"APR",null,null,"JUN",{"$f":"B31","v":1E-4}," ",{"$f":"V37+T35-T32-(T34*T35*(T31/365))","v":7.1162976887551409E-15},"T PUT price",null,null,null,null,null,null,null,null,null,null,"APR"]
[null,{"$f":"THEPLOTTER!B33","v":84.6},{"$f":"B32+1","v":85.6},{"$f":"((B32*D34)-(((B35*EXP((-B34*(B31/365)))*NORMSDIST(B38)))))-((B32*D34)-(((B35*EXP((-B34*((B31-1)/365)))*NORMSDIST(B38)))))","v":3.424680986228168E-4},"THETA",null,null,null,null,null," "," ",null,{"$f":"IF(A30=\"Jun\",DATEDIF(TODAY(),\"2003/6/20\",\"d\"),IF(A30=\"July\",DATEDIF(TODAY(),\"2003/7/20\",\"d\"),IF(A30=\"Aug\",DATEDIF(TODAY(),\"2003/8/20\",\"d\"),IF(A30=\"Sep\",DATEDIF(TODAY(),\"2003/9/20\",\"d\"),IF(A30=\"Oct\",DATEDIF(TODAY(),\"2003/10/20\",\"d\"),IF(A30=\"Nov\",DATEDIF(TODAY(),\"2003/11/20\",\"d\"), ))))))","v":0},null,"MAY",null,null,null,{"$f":"T6","v":65.290000000000006},{"$f":"T32+1","v":66.290000000000006},{"$f":"((T32*V34)-(((T35*EXP((-T34*(T31/365)))*NORMSDIST(T38)))))-((T32*V34)-(((T35*EXP((-T34*((T31-1)/365)))*NORMSDIST(T38)))))","v":3.424680986228168E-4},"THETA",null,null,null,null,null," "," ",null,{"$f":"IF(S30=\"Jun\",DATEDIF(TODAY(),\"2003/6/20\",\"d\"),IF(S30=\"July\",DATEDIF(TODAY(),\"2003/7/20\",\"d\"),IF(S30=\"Aug\",DATEDIF(TODAY(),\"2003/8/20\",\"d\"),IF(S30=\"Sep\",DATEDIF(TODAY(),\"2003/9/20\",\"d\"),IF(S30=\"Oct\",DATEDIF(TODAY(),\"2003/10/20\",\"d\"),IF(S30=\"Nov\",DATEDIF(TODAY(),\"2003/11/20\",\"d\"), ))))))","v":0},null,"MAY"]
[null,{"$f":"THEPLOTTER!B34+B4","v":0.26},{"$f":"B33+0.01","v":0.27},{"$f":"1-D34","v":0},"PUT DELTA",null,null,null,null,null,null,null,null,null,null,"JUN",null,null,null,{"$f":"THEPLOTTER!V34","v":0.26},{"$f":"T33+0.01","v":0.27},{"$f":"1-V34","v":0},"PUT DELTA",null,null,null,null,null,null,null,null,null,null,"JUN"]
[null,{"$f":"B8","v":5.0000000000000001E-3},{"$f":"(LN(B32/B35) + (B34 + C33 * C33/2)* (B31/365))/((C33 * SQRT(B31/365)))","v":8625.9552017325313},{"$f":"NORMSDIST(B37)","v":1},"CALL DELTA",null,null,null,null,null,null,null,null,{"$f":"IF(I36=\"Jun\",DATEDIF(TODAY(),\"2003/6/20\",\"d\"),IF(I36=\"Jul\",DATEDIF(TODAY(),\"2003/7/20\",\"d\"),IF(I36=\"Aug\",DATEDIF(TODAY(),\"2003/8/20\",\"d\"),IF(I36=\"Sep\",DATEDIF(TODAY(),\"2003/9/20\",\"d\"),IF(I36=\"Oct\",DATEDIF(TODAY(),\"2003/10/20\",\"d\"),IF(I36=\"Nov\",DATEDIF(TODAY(),\"2003/11/20\",\"d\"), ))))))","v":0},null,"JUL",null,null,null,{"$f":"T8","v":5.0000000000000001E-3},{"$f":"(LN(T32/T35) + (T34 + U33 * U33/2)* (T31/365))/((U33 * SQRT(T31/365)))","v":6792.6180493045913},{"$f":"NORMSDIST(T37)","v":1},"CALL DELTA",null,null,null,null,null,null,null,null,{"$f":"IF(AA36=\"Jun\",DATEDIF(TODAY(),\"2003/6/20\",\"d\"),IF(AA36=\"Jul\",DATEDIF(TODAY(),\"2003/7/20\",\"d\"),IF(AA36=\"Aug\",DATEDIF(TODAY(),\"2003/8/20\",\"d\"),IF(AA36=\"Sep\",DATEDIF(TODAY(),\"2003/9/20\",\"d\"),IF(AA36=\"Oct\",DATEDIF(TODAY(),\"2003/10/20\",\"d\"),IF(AA36=\"Nov\",DATEDIF(TODAY(),\"2003/11/20\",\"d\"), ))))))","v":{"$error":"#NUM!"}},null,"JUL"]
[null,{"$f":"THEPLOTTER!B36","v":25},{"$f":"B37-((C33*SQRT(B31/365)))","v":8957.7225628321194},{"$f":"1-(ABS(B37-NORMSDIST(C37)))","v":-8955.7227041565784},"GAMMA",null,null,null,null,null,"DPLOT DATA (EXPIRATION)",null,null,null,null,"AUG",null,null,"Enter Strike  ",{"$f":"B35","v":25},{"$f":"T37-((U33*SQRT(T31/365)))","v":7053.8724430031043},{"$f":"1-(ABS(T37-NORMSDIST(U37)))","v":-7051.8725843275633},"GAMMA",null,null,null,null,null,null,null,null,null,null,"AUG"]
[null,null,null,{"$f":"ABS(D37-D38)","v":0},"VEGA",null,null,null,{"$f":"I38 + WORKSHEET!$I$23","v":-165.67}," ",null,null,null,null,null,"SEP",null,null,null,null,null,{"$f":"ABS(V37-V38)","v":0},"VEGA",null,null,null,"JUL"," ",null,null,null,null,null,"SEP"]
[null,{"$f":"(LN(B32/B35) + (B34 + B33 * B33/2)* (B31/365))/((B33 * SQRT(B31/365)))","v":8957.7227041565784},{"$f":"(LN(C32/B35) + (B34 + B33 * B33/2)* (B31/365))/((B33 * SQRT(B31/365)))","v":9044.0699563430007},{"$f":"((B32*D34)-(((B35*EXP((-B34*(B31/365)))*NORMSDIST(B38)))))","v":59.60000003424657},"T CALL price",null,null," "," ",null,null,null,null,null,null,"OCT",null,null,null,{"$f":"(LN(T32/T35) + (T34 + T33 * T33/2)* (T31/365))/((T33 * SQRT(T31/365)))","v":7053.8725843275633},{"$f":"(LN(U32/T35) + (T34 + T33 * T33/2)* (T31/365))/((T33 * SQRT(T31/365)))","v":7165.5644536543386},{"$f":"((T32*V34)-(((T35*EXP((-T34*(T31/365)))*NORMSDIST(T38)))))","v":40.290000034246582},"T CALL price",null,null,null,null,{"$f":"IF(AA36=\"Jan\",DATEDIF(TODAY(),\"2003/1/20\",\"d\"),IF(AA36=\"Feb\",DATEDIF(TODAY(),\"2003/2/20\",\"d\"),IF(AA36=\"Mar\",DATEDIF(TODAY(),\"2003/3/20\",\"d\"),IF(AA36=\"Apr\",DATEDIF(TODAY(),\"2003/4/20\",\"d\"),IF(AA36=\"May\",DATEDIF(TODAY(),\"2003/5/20\",\"d\"),IF(AA36=\"Dec\",DATEDIF(TODAY(),\"2003/12/20\",\"d\"),AF34 ))))))","v":{"$error":"#NUM!"}},null,null,null,null,null,"OCT"]
[null,{"$f":"B37-((B33*SQRT(B31/365)))","v":8957.7225680663578}," ",{"$f":"((B32*D34)-(((B35*EXP((-B34*(B31/365)))*NORMSDIST(C35)))))","v":59.60000003424657}," ",null,null," ",{"$f":"(MIN($K39:K840))","v":-165.67},null,null,null,null,null,null,"NOV",null,null,null,{"$f":"T37-((T33*SQRT(T31/365)))","v":7053.8724482373436}," ",{"$f":"((T32*V34)-(((T35*EXP((-T34*(T31/365)))*NORMSDIST(U35)))))","v":40.290000034246582}," ",null,null,null,"TODAY",null,null,null,null,null,null,"NOV"]
[null,null,null,null,null,null,null," ","FINAL LOSS POTENTIAL",null,3689.33,17.29,null,null,null,"DEC",null,null,null,null,null,null,null,null,null,null,"19 DAYS LEFT",null,null,null,null,null,null,"DEC"]
[null,{"$f":"THEPLOTTER!B41","v":1.0000000000000001E-5},null,"D",null,null,null,null," ",null,3189.33,18.29,null,null,null,null,null,null," "," ",null,"D",null,null,null,null,"9 DAYS LEFT"]
["JUN",{"$f":"IF(WORKSHEET!K24=\"ON\",WORKSHEET!K29,(B40-(B3-B5)))","v":1E-4}," ",{"$f":"D47+B45-B42-(B44*B45*(B41/365))","v":-7.0945570264468628E-15},"T PUT price",null,null,{"$f":"THEPLOTTER!B1","v":24},{"$f":"MAX($K39:K840)","v":3689.33},null,2689.33,19.29,null,null,null,null,null,null,"JUN",{"$f":"B41","v":1E-4}," ",{"$f":"V47+T45-T42-(T44*T45*(T41/365))","v":7.1162976887551409E-15},"T PUT price"]
[null,{"$f":"THEPLOTTER!B33","v":84.6},{"$f":"B42+1","v":85.6},{"$f":"((B42*D44)-(((B45*EXP((-B44*(B41/365)))*NORMSDIST(B48)))))-((B42*D44)-(((B45*EXP((-B44*((B41-1)/365)))*NORMSDIST(B48)))))","v":3.424680986228168E-4},"THETA",null,null," ","MAXIMUM PROFIT POTENTIAL",null,2189.33,20.29,null,null,null,null,null,null,null,{"$f":"T6","v":65.290000000000006},{"$f":"T42+1","v":66.290000000000006},{"$f":"((T42*V44)-(((T45*EXP((-T44*(T41/365)))*NORMSDIST(T48)))))-((T42*V44)-(((T45*EXP((-T44*((T41-1)/365)))*NORMSDIST(T48)))))","v":3.424680986228168E-4},"THETA"]
[null,{"$f":"THEPLOTTER!B44+B4","v":0.62},{"$f":"B43+0.01","v":0.63},{"$f":"1-D44","v":0},"PUT DELTA",null,null," ",null,null,1689.33,21.29,null,null,null,null,null,null,null,{"$f":"B43","v":0.62},{"$f":"T43+0.01","v":0.63},{"$f":"1-V44","v":0},"PUT DELTA"]
[null,{"$f":"B8","v":5.0000000000000001E-3},{"$f":"(LN(B42/B45) + (B44 + C43 * C43/2)* (B41/365))/((C43 * SQRT(B41/365)))","v":3696.8380781943797},{"$f":"NORMSDIST(B47)","v":1},"CALL DELTA",null,null,null,null,null,1189.33,22.29,null,null,null,null,null,null,null,{"$f":"T8","v":5.0000000000000001E-3},{"$f":"(LN(T42/T45) + (T44 + U43 * U43/2)* (T41/365))/((U43 * SQRT(T41/365)))","v":2911.1221557252629},{"$f":"NORMSDIST(T47)","v":1},"CALL DELTA"]
[null,{"$f":"THEPLOTTER!B46","v":25},{"$f":"B47-((C43*SQRT(B41/365)))","v":3756.4641637768959},{"$f":"1-(ABS(B47-NORMSDIST(C47)))","v":-3754.464493533967},"GAMMA",null,null,null,null," ",689.33,23.29,null,null,null,null,null,null,"Enter Strike  ",{"$f":"B45","v":25},{"$f":"T47-((U43*SQRT(T41/365)))","v":2958.0754038485993},{"$f":"1-(ABS(T47-NORMSDIST(U47)))","v":-2956.0757336056704},"GAMMA",null,null,null,null,"S"]
[null,null,null,{"$f":"ABS(D47-D48)","v":0},"VEGA",null,null,null,null,null,189.33,24.29,null,null,null,null,null,null,null,null,null,{"$f":"ABS(V47-V48)","v":0},"VEGA"]
[null,{"$f":"(LN(B42/B45) + (B44 + B43 * B43/2)* (B41/365))/((B43 * SQRT(B41/365)))","v":3756.464493533967},{"$f":"(LN(C42/B45) + (B44 + B43 * B43/2)* (B41/365))/((B43 * SQRT(B41/365)))","v":3792.6746315476285},{"$f":"((B42*D44)-(((B45*EXP((-B44*(B41/365)))*NORMSDIST(B48)))))","v":59.60000003424657},"T CALL price",null,null,null,null,null,-165.67,25.29,null,null,null,null,null,null,null,{"$f":"(LN(T42/T45) + (T44 + T43 * T43/2)* (T41/365))/((T43 * SQRT(T41/365)))","v":2958.0757336056704},{"$f":"(LN(U42/T45) + (T44 + T43 * T43/2)* (T41/365))/((T43 * SQRT(T41/365)))","v":3004.9142594523828},{"$f":"((T42*V44)-(((T45*EXP((-T44*(T41/365)))*NORMSDIST(T48)))))","v":40.290000034246582},"T CALL price"]
[null,{"$f":"B47-((B43*SQRT(B41/365)))","v":3756.4641690111348}," ",{"$f":"((B42*D44)-(((B45*EXP((-B44*(B41/365)))*NORMSDIST(C45)))))","v":59.60000003424657}," ",null,null,null,null,null,-165.67,26.29,null,null,null,null,null,null,null,{"$f":"T47-((T43*SQRT(T41/365)))","v":2958.0754090828382}," ",{"$f":"((T42*V44)-(((T45*EXP((-T44*(T41/365)))*NORMSDIST(U45)))))","v":40.290000034246582}," "]
[null,null,null,null,null,null,null,null,null,null,-165.67,27.29]
[null,null,null,null,null,null,null,{"$f":"SUM(THEPLOTTER!B1*2)/(THEPLOTTER!B2)","v":48},null,null,-165.67,28.29]
[null,null,null,null,null,null,null,{"$f":"IF(H52>0,0,H52)","v":0},null,null,-165.67,29.29]
[null,null,null,null,null,null,null,{"$f":"THEPLOTTER!I62+I38","v":3834.33},null,null,-165.67,30.29]
[null,null,null,null,null,null,null,null,null,null,-165.67,31.29]
[null,null,null,null,null,null,null,null,null,null,-165.67,32.29]
[null,null,null,null,null,null,null,null,null,null,-165.67,33.29]
[null,null,null,null,null,null,null,null," FINAL TRADE  RISK",null,-165.67,34.29]
[null,null,null,null,null,null,null,null,{"$f":"ABS(I38/WORKSHEET!$I$41)","v":4.1417499999999996E-2},null,-165.67,35.29]
[null,null,null,null,null,null,null,null,null,null,-165.67,36.29]
[null,null,null,null,null,null,null,null,null,null,-165.67,37.29]
[null,null,null,null,null,null,null,null,"FINAL RISK/REWARD",null,-165.67,38.29]
[null,null,null,null,null,null,null,null,{"$f":"IF(J62<=0,\"EXCELLENT\",J62)","v":4.4905172483892739E-2},null,-165.67,39.29]
[null,null,null,null,null,null,null,null," ",{"$f":"ABS(I38/I41)","v":4.4905172483892739E-2},-165.67,40.29]
[null,null,null,null,null,null,null,null,null,null,-165.67,41.29]
[null,null,null,null,null,null,null,null,{"$f":"(THEPLOTTER!$I$62+I38)-(THEPLOTTER!$O$20)-(WORKSHEET!$I$47)","v":3845.8199999999997},null,-165.67,42.29]
[null,null,null,null,null,null,null,null,"RESIDUAL BUYING PWR",null,-165.67,43.29]
[null,null,null,null,null,null,null,null,{"$f":"(THEPLOTTER!$I$70+EXPIRATION!$I$57)/2","v":4.1359999999999994E-2},null,-165.67,44.29]
[null,null,null,null,null,null,null,null,null,null,-165.67,45.29]
[null,null,null,null,null,null,null,null," ",null,-165.67,46.29]
[null,null,null,null,null,null,null,null,null,null,-165.67,47.29]
[null,null,null,null,null,null,null,null,null,null,-165.67,48.29]
[null,null,null,null,null,null,null,null,null,null,-165.67,49.29]
[null,null,null,null,null,null,null,null,null,null,-165.67,50.29]
[null,null,null,null,null,null,null,null,null,null,-165.67,51.29]
[null,null,null,null,null,null,null,null,null,null,-165.67,52.29]
[null,null,null,null,null,null,null,null,null,null,-165.67,53.29]
[null,null,null,null,null,null,null,null,null,null,-165.67,54.29]
[null,null,null,null,null,null,null,null,null,null,-165.67,55.29]
[null,null,null,null,null,null,null,null,null,null,-165.67,56.29]
[null,null,null,null,null,null,null,null,null,null,-165.67,57.29]
[null,null,null,null,null,null,null,null,null,null,-165.67,58.29]
[null,null,null,null,null,null,null,null,null,null,-165.67,59.29]
[null,null,null,null,null,null,null,null,null,null,-165.67,60.29]
[null,null,null,null,null,null,null,null,null,null,-165.67,61.29]
[null,null,null,null,null,null,null,null,null,null,-165.67,62.29]
[null,null,null,null,null,null,null,null,null,null,-165.67,63.29]
[null,null,null,null,null,null,null,null,null,null,-165.67,64.290000000000006]
[null,null,null,null,null,null,null,null,null,null,-165.67,65.290000000000006]

{"sheet":"NOTES","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"DAILY PROFIT CALC","index":9,"n_rows":100,"n_cols":16,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,"PROFIT CALCULATOR (APPROX)","ENTER ONLY YELLOW "]
[" "," ",null,null,null,null,null,"(AT ANY POINT DURING THE TRADE)"]
[" ",{"$f":"WORKSHEET!B3","v":67.72},null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Initial Option Time (Spread)",{"$f":"WORKSHEET!B4","v":237}," "," "," ","T= Theoritical",null,"ADX"," ",null,null,null,null,null,null," "]
[null,null,null,"A",null,null,null," ",null,null,null,null,null,null,null," "]
[{"$f":"WORKSHEET!$A$5","v":"JAN"},{"$f":"WORKSHEET!B6","v":237}," ",{"$f":"D12+B10-B7-(B9*B10*(B6/365))","v":4.2938321611306529},"T PUT price",null,null,null," ",null,"IF OPTION PRICE>$1.00"," ",null,null,null," "]
[" ",{"$f":"I25","v":67.72},{"$f":"B7+1","v":68.72},{"$f":"((B7*D9)-(((B10*EXP((-B9*(B6/365)))*NORMSDIST(B13)))))-((B7*D9)-(((B10*EXP((-B9*((B6-1)/365)))*NORMSDIST(B13)))))","v":4.3297016701870916E-4},"THETA",null,null,"VOLATILITY"," "," ",{"$f":"WORKSHEET!K7","v":0},{"$f":"B7-B3","v":0}]
[" ",{"$f":"WORKSHEET!B8","v":0.19600000000000001},{"$f":"B8+0.01","v":0.20600000000000002},{"$f":"1-D9","v":0.47074416727709578},"PUT DELTA",null,null,null,null," ",{"$f":"WORKSHEET!K8","v":1},{"$f":"IF((K8>0),IF(J9=\"PUT\",(D6*(K8*100)), IF(J9=\"SP\",(-D6*(K8*100)),IF(J9=\"SC\", (-D12*(K8*100)),(D12*(K8*100))))),0)","v":423.45992844183229}]
[" ",{"$f":"WORKSHEET!B9","v":5.0000000000000001E-3},{"$f":"(LN(B7/B10) + (B9 + C8 * C8/2)* (B6/365))/((C8 * SQRT(B6/365)))","v":7.7698701207624885E-2},{"$f":"NORMSDIST(B12)","v":0.52925583272290422},"CALL DELTA",null,null,null,null,{"$f":"WORKSHEET!J9","v":"CALL"},{"$f":"IF(J9=\"PUT\",D8, IF(J9=\"SP\",-D8,IF(J9=\"SC\", -D9,D9)))","v":0.52925583272290422}]
[" ",{"$f":"WORKSHEET!B10","v":68},{"$f":"B12-((C8*SQRT(B6/365)))","v":-9.2595632252009924E-2},{"$f":"1-(ABS(B12-NORMSDIST(C12)))","v":0.50739398141706826},"GAMMA",null,null,"BETA",null," "," "]
[null,null,null,{"$f":"ABS(D12-D13)","v":0.21703624676240096},"VEGA",null,null,null,null,null,{"$f":"WORKSHEET!K11","v":1},{"$f":"IF((K11>0),IF(J12=\"PUT\",(D17*(K11*100)), IF(J12=\"SP\",(-D17*(K11*100)),IF(J12=\"SC\", (-D23*(K11*100)),(D23*(K11*100))))),0)","v":-91.04002132731388}]
[null,{"$f":"(LN(B7/B10) + (B9 + B8 * B8/2)* (B6/365))/((B8 * SQRT(B6/365)))","v":7.3399350342571362E-2},{"$f":"(LN(C7/B10) + (B9 + B8 * B8/2)* (B6/365))/((B8 * SQRT(B6/365)))","v":0.1662130852445321},{"$f":"((B7*D9)-(((B10*EXP((-B9*(B6/365)))*NORMSDIST(B13)))))","v":4.2345992844183229},"T CALL price",null,null,null,null,{"$f":"WORKSHEET!J12","v":"SC"},{"$f":"IF(J12=\"PUT\",D19, IF(J12=\"SP\",-D19,IF(J12=\"SC\", -D20,D20)))","v":-0.46800510546474988},null,null,"STRADDLE"]
[null,{"$f":"B12-((B8*SQRT(B6/365)))","v":-8.4537623388195288E-2}," ",{"$f":"((B7*D9)-(((B10*EXP((-B9*(B6/365)))*NORMSDIST(C10)))))","v":4.4516355311807239}," ",null,null,"EARNINGS",null,null,null,null,null,"CALL RATIO BSPD"]
[" ",null,null,null,null,null,null,null,null,null,{"$f":"WORKSHEET!K14","v":0},{"$f":"IF((K14>0),IF(J15=\"PUT\",(D29*(K14*100)),IF(J15=\"SP\",(-D29*(K14*100)),IF(J15=\"SC\",(-D35*(K14*100)),(D35*(K14*100))))),0)","v":0},null,"DEBT SPREAD"]
[null,null,null," ",null,null,null,null,null,{"$f":"WORKSHEET!J15","v":"PUT"},{"$f":"IF(J15=\"PUT\",D31, IF(J15=\"SP\",-D31,IF(J15=\"SC\", -D32,D32)))","v":0},null,null,"CREDIT SPREAD"]
[null,null,null,"B",null,null,null,"VIX",null,null,null,null,null,"DIAG BTFLY"]
[null,{"$f":"WORKSHEET!B20","v":24},"  ",{"$f":"D23+B21-B18-(B20*B21*(B17/365))","v":1.1680440488895747},"T PUT price",null,null,null,null,null,{"$f":"WORKSHEET!K17","v":0},{"$f":"IF((K17>0),IF(J18=\"PUT\",(D40*(K17*100)), IF(J18=\"SP\",(-D40*(K17*100)),IF(J18=\"SC\", (-D46*(K17*100)),(D46*(K17*100))))),0)","v":0},null,"BUTTERFLY"]
[" ",{"$f":"B7","v":67.72},{"$f":"B18+1","v":68.72},{"$f":"((B18*D20)-(((B21*EXP((-B20*(B17/365)))*NORMSDIST(B24)))))-((B18*D20)-(((B21*EXP((-B20*((B17-1)/365)))*NORMSDIST(B24)))))","v":4.2168652564100739E-4},"THETA",null,null,null,null,{"$f":"WORKSHEET!J18","v":"PUT"},{"$f":"IF(J18=\"PUT\",D42, IF(J18=\"SP\",-D42,IF(J18=\"SC\", -D43,D43)))","v":0},null,null,"IRON BUTTERFLY"]
[null,{"$f":"WORKSHEET!B22","v":0.14899999999999999},{"$f":"B19+0.01","v":0.159},{"$f":"1-D20","v":0.53199489453525017},"PUT DELTA",null,null,"GOVERNMENT RELEASES",null,null,null,null,null,"PUT"]
[{"$f":"WORKSHEET!$A$19","v":"MAY"},{"$f":"WORKSHEET!B23","v":5.0000000000000001E-3},{"$f":"(LN(B18/B21) + (B20 + C19 * C19/2)* (B17/365))/((C19 * SQRT(B17/365)))","v":-7.2752466701947946E-2},{"$f":"NORMSDIST(B23)","v":0.46800510546474988},"CALL DELTA",null,null," "," "," ",null,null,null,"CALL"]
[null,{"$f":"WORKSHEET!B24","v":68},{"$f":"B23-((C19*SQRT(B17/365)))","v":-0.12105693871029197},{"$f":"1-(ABS(B23-NORMSDIST(C23)))","v":0.30051538041135684},"GAMMA",null,null," "," "," ",null,null,null,"SP"]
[" ",null,null,{"$f":"ABS(D23-D24)","v":6.9043066548200471E-2},"VEGA",null,null,"PRE-SET STOCK SCREENERS ",null,null,null,{"$f":"SUM(L8:L17)+(L7*K7)","v":332.41990711451842},null,"SC"]
[" ",{"$f":"(LN(B18/B21) + (B20 + B19 * B19/2)* (B17/365))/((B19 * SQRT(B17/365)))","v":-8.0285474071808319E-2},{"$f":"(LN(C18/B21) + (B20 + B19 * B19/2)* (B17/365))/((B19 * SQRT(B17/365)))","v":0.30337813204986652},{"$f":"((B18*D20)-(((B21*EXP((-B20*(B17/365)))*NORMSDIST(B24)))))","v":0.9104002132731388},"T CALL price",null,null,null," ",null,null,"ENTER INITIAL POSITION"]
[" ",{"$f":"B23-((B19*SQRT(B17/365)))","v":-0.11849269565126785}," ",{"$f":"((B18*D20)-(((B21*EXP((-B20*(B17/365)))*NORMSDIST(C21)))))","v":0.97944327982133927}," ",null,null,null,null,null," ",{"$f":"L22","v":332.41990711451842}]
[null,null,null,null,null,null,null,"INITIAL STOCK PRICE",{"$f":"WORKSHEET!$B$3","v":67.72},"AVG",{"$f":"ABS(L35/K26)*0.01","v":6.3743031086197208E-2}," ",null,null,null,"ON"]
[null,null,null," ",null,null,null,"TODAY'S CLOSING PRICE",15.57,null,{"$f":"ABS(I25-I26)","v":52.15},null,null,null,null,"OFF"]
[null,null,null,"C",null,null,null,"ENTER TIME LAPSE (Days)",5,null,"OFF","PROFIT / LOSS"]
[null,{"$f":"WORKSHEET!B31","v":1.0000000000000001E-5},"  "," "," ",null,null,"ENTER VOL DELTA OPT A",0]
[null,{"$f":"WORKSHEET!B32","v":1.0000000000000001E-5}," ",{"$f":"D35+B33-B30-(B32*B33*(B29/365))","v":2.1327152399821242E-15},"T PUT price",null,null,"ENTER VOL DELTA OPT B",0]
[null,{"$f":"WORKSHEET!B33","v":84.6},{"$f":"B30+1","v":85.6},{"$f":"((B30*D32)-(((B33*EXP((-B32*(B29/365)))*NORMSDIST(B36)))))-((B30*D32)-(((B33*EXP((-B32*((B29-1)/365)))*NORMSDIST(B36)))))","v":3.4246809904914244E-4},"THETA",null,null,"ENTER VOL DELTA OPT C",0]
[null,{"$f":"WORKSHEET!B34","v":0.26},{"$f":"B31+0.01","v":0.27},{"$f":"1-D32","v":0},"PUT DELTA",null,null,"ENTER VOL DELTA OPT D",0]
[null,{"$f":"WORKSHEET!B35","v":5.0000000000000001E-3},{"$f":"(LN(B30/B33) + (B32 + C31 * C31/2)* (B29/365))/((C31 * SQRT(B29/365)))","v":27277.665203356915},{"$f":"NORMSDIST(B35)","v":1},"CALL DELTA",null,null,"JUNE",null,null,{"$f":"WORKSHEET!$K$26","v":1E-4},{"$f":"L22-L24","v":0},null,"PUT"]
[null,{"$f":"WORKSHEET!B36","v":25},{"$f":"B35-((C31*SQRT(B29/365)))","v":28326.806126339037},{"$f":"1-(ABS(B35-NORMSDIST(C35)))","v":-28324.806171029755},"GAMMA",null,null,"Enter Locked in Gains for Month",null,null,{"$f":"WORKSHEET!$K$27","v":1E-4},{"$f":"L82","v":-332.41990711451842},null,{"$f":"IF(A18=\"Jun\",DATEDIF(TODAY(),\"2003/6/20\",\"d\"),IF(A18=\"July\",DATEDIF(TODAY(),\"2003/7/20\",\"d\"),IF(A18=\"Aug\",DATEDIF(TODAY(),\"2003/8/20\",\"d\"),IF(A18=\"Sep\",DATEDIF(TODAY(),\"2003/9/20\",\"d\"),IF(A18=\"Oct\",DATEDIF(TODAY(),\"2003/10/20\",\"d\"),IF(A18=\"Nov\",DATEDIF(TODAY(),\"2003/11/20\",\"d\"), ))))))","v":0},null,"JAN"]
[null," ",null,{"$f":"ABS(D35-D36)","v":0},"VEGA",null,null," ",null,null,{"$f":"WORKSHEET!$K$28","v":1E-4}," ",null,null,null,"FEB"]
[" ",{"$f":"(LN(B30/B33) + (B32 + B31 * B31/2)* (B29/365))/((B31 * SQRT(B29/365)))","v":28326.806171029755},{"$f":"(LN(C30/B33) + (B32 + B31 * B31/2)* (B29/365))/((B31 * SQRT(B29/365)))","v":28599.860157635805},{"$f":"((B30*D32)-(((B33*EXP((-B32*(B29/365)))*NORMSDIST(B36)))))","v":59.600000003424654},"T CALL price",null,null,-0.35,null,null,{"$f":"WORKSHEET!$K$29","v":1E-4},{"$f":"L32+L33+THEPLOTTER!$I$46","v":-332.41990711451842},null,{"$f":"IF(A4=\"Jun\",DATEDIF(TODAY(),\"2003/6/20\",\"d\"),IF(A4=\"July\",DATEDIF(TODAY(),\"2003/7/20\",\"d\"),IF(A4=\"Aug\",DATEDIF(TODAY(),\"2003/8/20\",\"d\"),IF(A4=\"Sep\",DATEDIF(TODAY(),\"2003/9/20\",\"d\"),IF(A4=\"Oct\",DATEDIF(TODAY(),\"2003/10/20\",\"d\"),IF(A4=\"Nov\",DATEDIF(TODAY(),\"2003/11/20\",\"d\"), ))))))","v":0},null,"MAR"]
[{"$f":"WORKSHEET!$A$30","v":"JAN"},{"$f":"B35-((B31*SQRT(B29/365)))","v":28326.806127994249}," ",{"$f":"((B30*D32)-(((B33*EXP((-B32*(B29/365)))*NORMSDIST(C33)))))","v":59.600000003424654}," ",null,null,null," "," ",null,"PROFIT / LOSS",null,null,null,"APR"]
[null,null,null,null,null,null,null," "]
[null,null,null,"D",null,null,null,{"$f":"IF(I32=\"Jan\",DATEDIF(TODAY(),\"2004/1/20\",\"d\"),IF(I32=\"Feb\",DATEDIF(TODAY(),\"2004/2/20\",\"d\"),IF(I32=\"Mar\",DATEDIF(TODAY(),\"2004/3/22\",\"d\"),IF(I32=\"Apr\",DATEDIF(TODAY(),\"2004/4/20\",\"d\"),IF(I32=\"May\",DATEDIF(TODAY(),\"2004/5/20\",\"d\"),IF(I32=\"Dec\",DATEDIF(TODAY(),\"2003/12/20\",\"d\"),I38 ))))))","v":0},{"$f":"IF(I32=\"Jun\",DATEDIF(TODAY(),\"2004/6/20\",\"d\"),IF(I32=\"Jul\",DATEDIF(TODAY(),\"2004/7/20\",\"d\"),IF(I32=\"Aug\",DATEDIF(TODAY(),\"2004/8/20\",\"d\"),IF(I32=\"Sep\",DATEDIF(TODAY(),\"2003/9/20\",\"d\"),IF(I32=\"Oct\",DATEDIF(TODAY(),\"2003/10/20\",\"d\"),IF(I32=\"Nov\",DATEDIF(TODAY(),\"2003/11/20\",\"d\"), ))))))","v":0},"  "," "," ",null,{"$f":"IF(A35=\"Jun\",DATEDIF(TODAY(),\"2003/6/20\",\"d\"),IF(A35=\"July\",DATEDIF(TODAY(),\"2003/7/20\",\"d\"),IF(A35=\"Aug\",DATEDIF(TODAY(),\"2003/8/20\",\"d\"),IF(A35=\"Sep\",DATEDIF(TODAY(),\"2003/9/20\",\"d\"),IF(A35=\"Oct\",DATEDIF(TODAY(),\"2003/10/20\",\"d\"),IF(A35=\"Nov\",DATEDIF(TODAY(),\"2003/11/20\",\"d\"), ))))))","v":0},null,"MAY"]
[" ",{"$f":"WORKSHEET!B41","v":1.0000000000000001E-5}," ",null,null,null,null,{"$f":"IF(I33=\"Jan\",DATEDIF(TODAY(),\"2004/1/20\",\"d\"),IF(I33=\"Feb\",DATEDIF(TODAY(),\"2004/2/20\",\"d\"),IF(I33=\"Mar\",DATEDIF(TODAY(),\"2004/3/22\",\"d\"),IF(I33=\"Apr\",DATEDIF(TODAY(),\"2004/4/20\",\"d\"),IF(I33=\"May\",DATEDIF(TODAY(),\"2004/5/20\",\"d\"),IF(I33=\"Dec\",DATEDIF(TODAY(),\"2003/12/20\",\"d\"),I39 ))))))","v":0},{"$f":"IF(I33=\"Jun\",DATEDIF(TODAY(),\"2004/6/20\",\"d\"),IF(I33=\"Jul\",DATEDIF(TODAY(),\"2004/7/20\",\"d\"),IF(I33=\"Aug\",DATEDIF(TODAY(),\"2004/8/20\",\"d\"),IF(I33=\"Sep\",DATEDIF(TODAY(),\"2003/9/20\",\"d\"),IF(I33=\"Oct\",DATEDIF(TODAY(),\"2003/10/20\",\"d\"),IF(I33=\"Nov\",DATEDIF(TODAY(),\"2003/11/20\",\"d\"), ))))))","v":0},null,null,{"$f":"(-L8-L11-L14)","v":-332.41990711451842},null,null,null,"JUN"]
[null,{"$f":"WORKSHEET!B42","v":1.0000000000000001E-5}," ",{"$f":"D46+B44-B41-(B43*B44*(B40/365))","v":2.1327152399821242E-15},"T PUT price",null,null,{"$f":"IF(I34=\"Jan\",DATEDIF(TODAY(),\"2004/1/20\",\"d\"),IF(I34=\"Feb\",DATEDIF(TODAY(),\"2004/2/20\",\"d\"),IF(I34=\"Mar\",DATEDIF(TODAY(),\"2004/3/22\",\"d\"),IF(I34=\"Apr\",DATEDIF(TODAY(),\"2004/4/20\",\"d\"),IF(I34=\"May\",DATEDIF(TODAY(),\"2004/5/20\",\"d\"),IF(I34=\"Dec\",DATEDIF(TODAY(),\"2003/12/20\",\"d\"),I40 ))))))","v":0},{"$f":"IF(I34=\"Jun\",DATEDIF(TODAY(),\"2004/6/20\",\"d\"),IF(I34=\"Jul\",DATEDIF(TODAY(),\"2004/7/20\",\"d\"),IF(I34=\"Aug\",DATEDIF(TODAY(),\"2004/8/20\",\"d\"),IF(I34=\"Sep\",DATEDIF(TODAY(),\"2003/9/20\",\"d\"),IF(I34=\"Oct\",DATEDIF(TODAY(),\"2003/10/20\",\"d\"),IF(I34=\"Nov\",DATEDIF(TODAY(),\"2003/11/20\",\"d\"), ))))))","v":0},null," ",null,null,{"$f":"IF(I42=\"Jun\",DATEDIF(TODAY(),\"2004/6/20\",\"d\"),IF(I42=\"Jul\",DATEDIF(TODAY(),\"2004/7/20\",\"d\"),IF(I42=\"Aug\",DATEDIF(TODAY(),\"2004/8/20\",\"d\"),IF(I42=\"Sep\",DATEDIF(TODAY(),\"2003/9/20\",\"d\"),IF(I42=\"Oct\",DATEDIF(TODAY(),\"2003/10/20\",\"d\"),IF(I42=\"Nov\",DATEDIF(TODAY(),\"2003/11/20\",\"d\"), ))))))","v":0},null,"JUL"]
[" ",{"$f":"WORKSHEET!B43","v":84.6},{"$f":"B41+1","v":85.6},{"$f":"((B41*D43)-(((B44*EXP((-B43*(B40/365)))*NORMSDIST(B47)))))-((B41*D43)-(((B44*EXP((-B43*((B40-1)/365)))*NORMSDIST(B47)))))","v":3.4246809904914244E-4},"THETA",null,null,{"$f":"IF(I35=\"Jan\",DATEDIF(TODAY(),\"2004/1/20\",\"d\"),IF(I35=\"Feb\",DATEDIF(TODAY(),\"2004/2/20\",\"d\"),IF(I35=\"Mar\",DATEDIF(TODAY(),\"2004/3/22\",\"d\"),IF(I35=\"Apr\",DATEDIF(TODAY(),\"2004/4/20\",\"d\"),IF(I35=\"May\",DATEDIF(TODAY(),\"2004/5/20\",\"d\"),IF(I35=\"Dec\",DATEDIF(TODAY(),\"2003/12/20\",\"d\"),I41 ))))))","v":0},{"$f":"IF(I35=\"Jun\",DATEDIF(TODAY(),\"2004/6/20\",\"d\"),IF(I35=\"Jul\",DATEDIF(TODAY(),\"2004/7/20\",\"d\"),IF(I35=\"Aug\",DATEDIF(TODAY(),\"2004/8/20\",\"d\"),IF(I35=\"Sep\",DATEDIF(TODAY(),\"2003/9/20\",\"d\"),IF(I35=\"Oct\",DATEDIF(TODAY(),\"2003/10/20\",\"d\"),IF(I35=\"Nov\",DATEDIF(TODAY(),\"2003/11/20\",\"d\"), ))))))","v":0},null," "," ",null,null,null,"AUG"]
[null,{"$f":"WORKSHEET!B44","v":0.62},{"$f":"B42+0.01","v":0.63},{"$f":"1-D43","v":0},"PUT DELTA",null,null,null,null,null,null,null,{"$f":"MIN($K$43:$K$55)","v":0},{"$f":"MIN($L$43:$L$55)","v":0},null,"SEP"]
[null,{"$f":"WORKSHEET!B45","v":5.0000000000000001E-3},{"$f":"(LN(B41/B44) + (B43 + C42 * C42/2)* (B40/365))/((C42 * SQRT(B40/365)))","v":11690.427986858411},{"$f":"NORMSDIST(B46)","v":1},"CALL DELTA",null,null,null,null,null,null,null,{"$f":"MAX($K$43:$K$55)","v":0},{"$f":"MAX($L$43:$L$55)","v":0},null,"OCT"]
[null,{"$f":"WORKSHEET!B46","v":25},{"$f":"B46-((C42*SQRT(B40/365)))","v":11878.983171022126},{"$f":"1-(ABS(B46-NORMSDIST(C46)))","v":-11876.983275300468},"GAMMA",null,null,null,null,null,null,"\\\\"," "," ",null,"NOV"]
[null,null,null,{"$f":"ABS(D46-D47)","v":0},"VEGA",null,null,null,null,null,null,null,{"$f":"MIN(EXPIRATION!$K$36:$K$48)","v":-165.67},{"$f":"MIN(EXPIRATION!$L$36:$L$48)","v":17.29},null,"DEC"]
[" ",{"$f":"(LN(B41/B44) + (B43 + B42 * B42/2)* (B40/365))/((B42 * SQRT(B40/365)))","v":11878.983275300468},{"$f":"(LN(C41/B44) + (B43 + B42 * B42/2)* (B40/365))/((B42 * SQRT(B40/365)))","v":11993.489785812684},{"$f":"((B41*D43)-(((B44*EXP((-B43*(B40/365)))*NORMSDIST(B47)))))","v":59.600000003424654},"T CALL price",null,null,null,null,null,null,null,{"$f":"MAX(EXPIRATION!$K$36:$K$48)","v":3689.33},{"$f":"MAX(EXPIRATION!$L$36:$L$48)","v":26.29},null,"Enter Time"]
[{"$f":"WORKSHEET!$A$40","v":"JAN"},{"$f":"B46-((B42*SQRT(B40/365)))","v":11878.983172677339}," ",{"$f":"((B41*D43)-(((B44*EXP((-B43*(B40/365)))*NORMSDIST(C44)))))","v":59.600000003424654}," "]
[]
[" ",{"$f":"B2","v":" "}]
[null,{"$f":"B3","v":67.72}]
[" ",{"$f":"B4","v":237}," "," "," ","T= Theoritical"]
[null,null,null,"A"]
[null,{"$f":"IF(K27=\"ON\",K32,IF(I27=0,(J32-1),(THEPLOTTER!B6-I27)))","v":232}," ",{"$f":"D59+B57-B54-(B56*B57*(B53/365))","v":52.213890410958903},"T PUT price"]
[null,{"$f":"I26","v":15.57},{"$f":"B54+1","v":16.57},{"$f":"((B54*D56)-(((B57*EXP((-B56*(B53/365)))*NORMSDIST(B60)))))-((B54*D56)-(((B57*EXP((-B56*((B53-1)/365)))*NORMSDIST(B60)))))","v":1.0553118222970236E-24},"THETA"]
[null,{"$f":"B8+I28","v":0.19600000000000001},{"$f":"B55+0.01","v":0.20600000000000002},{"$f":"1-D56","v":1},"PUT DELTA",null,null,null,"Put all Short Options in first 2 Positions"]
[" ",{"$f":"B9","v":5.0000000000000001E-3},{"$f":"(LN(B54/B57) + (B56 + C55 * C55/2)* (B53/365))/((C55 * SQRT(B53/365)))","v":-8.8744802439504173},{"$f":"NORMSDIST(B59)","v":5.0288322306665914E-21},"CALL DELTA",null,null,null,"if Possible."]
["Stock Opening Price",{"$f":"B10","v":68},{"$f":"B59-((C55*SQRT(B53/365)))","v":-9.4996704321252192},{"$f":"1-(ABS(B59-NORMSDIST(C59)))","v":-8.3354357854209322},"GAMMA"]
["Initial Option Time (Spread)",null,null,{"$f":"ABS(D59-D60)","v":5.6754804892920972E-21},"VEGA",null,null,"SC= Sold Call"," ",null,null,null,null,null,null," "]
[null,{"$f":"(LN(B54/B57) + (B56 + B55 * B55/2)* (B53/365))/((B55 * SQRT(B53/365)))","v":-9.3354357854209322},{"$f":"(LN(C54/B57) + (B56 + B55 * B55/2)* (B53/365))/((B55 * SQRT(B53/365)))","v":-8.9370803994238486},{"$f":"((B54*D56)-(((B57*EXP((-B56*(B53/365)))*NORMSDIST(B60)))))","v":1.2616824576408695E-21},"T CALL price",null,null,"SP =Sold Put",null,null,null,null,null,null,null," "]
[{"$f":"A6","v":"JAN"},{"$f":"B59-((B55*SQRT(B53/365)))","v":-9.4916978764599627}," ",{"$f":"((B54*D56)-(((B57*EXP((-B56*(B53/365)))*NORMSDIST(C57)))))","v":6.9371629469329667E-21}," ",null,null,null," ",null,"IF OPTION PRICE>$1.00"," ",null,null,null," "]
[" ",null,null,null,null,null,null,null,null," ",{"$f":"K7","v":0},{"$f":"B54-B50","v":-52.15},null,null,null," "]
[" "," ",null,null,null,null,null,null,null," ",{"$f":"K8","v":1},{"$f":"IF((K62>0),IF(J63=\"PUT\",(D53*(K62*100)), IF(J63=\"SP\",(-D53*(K62*100)),IF(J63=\"SC\", (-D59*(K62*100)),(D59*(K62*100))))),0)","v":1.2616824576408695E-19}]
[" ",null,null,null,null,null,null,null,null,{"$f":"J9","v":"CALL"},{"$f":"IF(J63=\"PUT\",D55, IF(J63=\"SP\",-D55,IF(J63=\"SC\", -D56,D56)))","v":5.0288322306665914E-21}]
[" ",null,null,null,null,null,null,null,null," "," "]
[null,null,null," ",null,null,null,null,null,null,{"$f":"K11","v":1},{"$f":"IF((K65>0),IF(J66=\"PUT\",(D67*(K65*100)), IF(J66=\"SP\",(-D67*(K65*100)),IF(J66=\"SC\", (-D73*(K65*100)),(D73*(K65*100))))),0)","v":0}]
[null,null,null,"B",null,null,null,null,null,{"$f":"J12","v":"SC"},{"$f":"IF(J66=\"PUT\",D69, IF(J66=\"SP\",-D69,IF(J66=\"SC\", -D70,D70)))","v":0}]
[null,{"$f":"IF(K27=\"ON\",K33,IF(I27=0,(J33-1),(THEPLOTTER!B20-I27)))","v":19},"1900-01-01",{"$f":"D73+B71-B68-(B70*B71*(B67/365))","v":52.412301369863016},"T PUT price",null,null,null,null,null,null,null,null,"STRADDLE"]
["90 Day Treasury Bills",{"$f":"B54","v":15.57},{"$f":"B68+1","v":16.57},{"$f":"((B68*D70)-(((B71*EXP((-B70*(B67/365)))*NORMSDIST(B74)))))-((B68*D70)-(((B71*EXP((-B70*((B67-1)/365)))*NORMSDIST(B74)))))","v":0},"THETA",null,null,null,null,null,{"$f":"K14","v":0},{"$f":"IF((K68>0),IF(J69=\"PUT\",(D79*(K68*100)),IF(J69=\"SP\",(-D79*(K68*100)),IF(J69=\"SC\",(-D85*(K68*100)),(D85*(K68*100))))),0)","v":0},null,"CALL RATIO BSPD"]
[null,{"$f":"B19+I29","v":0.14899999999999999},{"$f":"B69+0.01","v":0.159},{"$f":"1-D70","v":1},"PUT DELTA",null,null,null,null,{"$f":"J15","v":"PUT"},{"$f":"IF(J69=\"PUT\",D81, IF(J69=\"SP\",-D81,IF(J69=\"SC\", -D82,D82)))","v":{"$error":"#NUM!"}},null,null,"DEBT SPREAD"]
[null,{"$f":"B20","v":5.0000000000000001E-3},{"$f":"(LN(B68/B71) + (B70 + C69 * C69/2)* (B67/365))/((C69 * SQRT(B67/365)))","v":-40.611312488634717},{"$f":"NORMSDIST(B73)","v":0},"CALL DELTA",null,null,null,null,null,null,null,null,"CREDIT SPREAD"]
[null,{"$f":"B21","v":68},{"$f":"B73-((C69*SQRT(B67/365)))","v":-43.375538721488184},{"$f":"1-(ABS(B73-NORMSDIST(C73)))","v":-42.339262044955262},"GAMMA",null,null,null,null,null,{"$f":"K17","v":0},{"$f":"IF((K71>0),IF(J72=\"PUT\",(D89*(K71*100)), IF(J72=\"SP\",(-D89*(K71*100)),IF(J72=\"SC\", (-D95*(K71*100)),(D95*(K71*100))))),0)","v":0},null,"DIAG BTFLY"]
[" ",null,null,{"$f":"ABS(D73-D74)","v":0},"VEGA",null,null,null,null,{"$f":"J18","v":"PUT"},{"$f":"IF(J72=\"PUT\",D91, IF(J72=\"SP\",-D91,IF(J72=\"SC\", -D92,D92)))","v":{"$error":"#NUM!"}},null,null,"BUTTERFLY"]
[null,{"$f":"(LN(B68/B71) + (B70 + B69 * B69/2)* (B67/365))/((B69 * SQRT(B67/365)))","v":-43.339262044955262},{"$f":"(LN(C68/B71) + (B70 + B69 * B69/2)* (B67/365))/((B69 * SQRT(B67/365)))","v":-41.508180487906365},{"$f":"((B68*D70)-(((B71*EXP((-B70*(B67/365)))*NORMSDIST(B74)))))","v":0},"T CALL price",null,null,null,null,null,null,null,null,"IRON BUTTERFLY"]
[{"$f":"A20","v":"MAY"},{"$f":"B73-((B69*SQRT(B67/365)))","v":-43.373257169504981}," ",{"$f":"((B68*D70)-(((B71*EXP((-B70*(B67/365)))*NORMSDIST(C71)))))","v":0}," ",null,null," "," "," ",null,null,null,"PUT"]
[null,null,null,null,null,null,null," "," "," ",null,null,null,"CALL"]
[" ",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L62:L71)+(L61*K61)","v":1.2616824576408695E-19},null,"SP"]
[" ",null,null,null,null,null,null,null," ",null,null,"ENTER INITIAL POSITION",null,"SC"]
[" "," ",null,"C",null,null,null,null,null,null," ",{"$f":"L24","v":332.41990711451842}]
[null,{"$f":"IF(K27=\"ON\",K34,IF(I27=0,(J34-1),(THEPLOTTER!B31-I27)))","v":-4.9999900000000004}," ",{"$f":"D85+B83-B80-(B82*B83*(B79/365))","v":{"$error":"#NUM!"}},"T PUT price",null,null,null,null,null," "," "]
[null,{"$f":"B54","v":15.57},{"$f":"B80+1","v":16.57},{"$f":"((B80*D82)-(((B83*EXP((-B82*(B79/365)))*NORMSDIST(B86)))))-((B80*D82)-(((B83*EXP((-B82*((B79-1)/365)))*NORMSDIST(B86)))))","v":{"$error":"#NUM!"}},"THETA",null,null,null,null,null," "]
[null,{"$f":"B31+I30","v":0.26},{"$f":"B81+0.01","v":0.27},{"$f":"1-D82","v":{"$error":"#NUM!"}},"PUT DELTA",null,null,null,null,null,null,"PROFIT / LOSS"]
[null,{"$f":"B32","v":5.0000000000000001E-3},{"$f":"(LN(B80/B83) + (B82 + C81 * C81/2)* (B79/365))/((C81 * SQRT(B79/365)))","v":{"$error":"#NUM!"}},{"$f":"NORMSDIST(B85)","v":{"$error":"#NUM!"}},"CALL DELTA",null,null,null,null,null," ",{"$f":"L76-L78","v":-332.41990711451842}]
[null,{"$f":"B33","v":25},{"$f":"B85-((C81*SQRT(B79/365)))","v":{"$error":"#NUM!"}},{"$f":"1-(ABS(B85-NORMSDIST(C85)))","v":{"$error":"#NUM!"}},"GAMMA",null,null,null,null,null," ",null,null,"PUT"]
[null,null,null,{"$f":"ABS(D85-D86)","v":{"$error":"#NUM!"}},"VEGA",null,null,null,null,null,null,null,null,{"$f":"IF(A73=\"Jun\",DATEDIF(TODAY(),\"2003/6/20\",\"d\"),IF(A73=\"July\",DATEDIF(TODAY(),\"2003/7/20\",\"d\"),IF(A73=\"Aug\",DATEDIF(TODAY(),\"2003/8/20\",\"d\"),IF(A73=\"Sep\",DATEDIF(TODAY(),\"2003/9/20\",\"d\"),IF(A73=\"Oct\",DATEDIF(TODAY(),\"2003/10/20\",\"d\"),IF(A73=\"Nov\",DATEDIF(TODAY(),\"2003/11/20\",\"d\"), ))))))","v":0},null,"JAN"]
[" ",{"$f":"(LN(B80/B83) + (B82 + B81 * B81/2)* (B79/365))/((B81 * SQRT(B79/365)))","v":{"$error":"#NUM!"}},{"$f":"(LN(C80/B83) + (B82 + B81 * B81/2)* (B79/365))/((B81 * SQRT(B79/365)))","v":{"$error":"#NUM!"}},{"$f":"((B80*D82)-(((B83*EXP((-B82*(B79/365)))*NORMSDIST(B86)))))","v":{"$error":"#NUM!"}},"T CALL price",null,null,null," ",null,null,null,null,null,null,"FEB"]
[{"$f":"A36","v":"JAN"},{"$f":"B85-((B81*SQRT(B79/365)))","v":{"$error":"#NUM!"}}," ",{"$f":"((B80*D82)-(((B83*EXP((-B82*(B79/365)))*NORMSDIST(C83)))))","v":{"$error":"#NUM!"}}," ",null,null,null," "," ",null,null,null,{"$f":"IF(A59=\"Jun\",DATEDIF(TODAY(),\"2003/6/20\",\"d\"),IF(A59=\"July\",DATEDIF(TODAY(),\"2003/7/20\",\"d\"),IF(A59=\"Aug\",DATEDIF(TODAY(),\"2003/8/20\",\"d\"),IF(A59=\"Sep\",DATEDIF(TODAY(),\"2003/9/20\",\"d\"),IF(A59=\"Oct\",DATEDIF(TODAY(),\"2003/10/20\",\"d\"),IF(A59=\"Nov\",DATEDIF(TODAY(),\"2003/11/20\",\"d\"), ))))))","v":0},null,"MAR"]
[null,null,null,null,null,null,null,null," ","  "," "," ",null,null,null,"APR"]
[" "," ",null,"D",null,null,null,null,null,null,null,{"$f":"(-L62-L65-L68)","v":-1.2616824576408695E-19},null,{"$f":"IF(A86=\"Jun\",DATEDIF(TODAY(),\"2003/6/20\",\"d\"),IF(A86=\"July\",DATEDIF(TODAY(),\"2003/7/20\",\"d\"),IF(A86=\"Aug\",DATEDIF(TODAY(),\"2003/8/20\",\"d\"),IF(A86=\"Sep\",DATEDIF(TODAY(),\"2003/9/20\",\"d\"),IF(A86=\"Oct\",DATEDIF(TODAY(),\"2003/10/20\",\"d\"),IF(A86=\"Nov\",DATEDIF(TODAY(),\"2003/11/20\",\"d\"), ))))))","v":0},null,"MAY"]
[null,{"$f":"IF(K27=\"ON\",K35,IF(I27=0,(J35-1),(THEPLOTTER!B41-I27)))","v":-4.9999900000000004}," ",{"$f":"D95+B93-B90-(B92*B93*(B89/365))","v":{"$error":"#NUM!"}},"T PUT price",null,null,null,null,null," ",null,null,null,null,"JUN"]
[" ",{"$f":"B54","v":15.57},{"$f":"B90+1","v":16.57},{"$f":"((B90*D92)-(((B93*EXP((-B92*(B89/365)))*NORMSDIST(B96)))))-((B90*D92)-(((B93*EXP((-B92*((B89-1)/365)))*NORMSDIST(B96)))))","v":{"$error":"#NUM!"}},"THETA",null,null,null,null,null," "," ",null,{"$f":"IF(I92=\"Jun\",DATEDIF(TODAY(),\"2004/6/20\",\"d\"),IF(I92=\"Jul\",DATEDIF(TODAY(),\"2004/7/20\",\"d\"),IF(I92=\"Aug\",DATEDIF(TODAY(),\"2004/8/20\",\"d\"),IF(I92=\"Sep\",DATEDIF(TODAY(),\"2003/9/20\",\"d\"),IF(I92=\"Oct\",DATEDIF(TODAY(),\"2003/10/20\",\"d\"),IF(I92=\"Nov\",DATEDIF(TODAY(),\"2003/11/20\",\"d\"), ))))))","v":0},null,"JUL"]
[null,{"$f":"B42+I31","v":0.62},{"$f":"B91+0.01","v":0.63},{"$f":"1-D92","v":{"$error":"#NUM!"}},"PUT DELTA",null,null,null,null,null,null,null,null,null,null,"AUG"]
[null,{"$f":"B43","v":5.0000000000000001E-3},{"$f":"(LN(B90/B93) + (B92 + C91 * C91/2)* (B89/365))/((C91 * SQRT(B89/365)))","v":{"$error":"#NUM!"}},{"$f":"NORMSDIST(B95)","v":{"$error":"#NUM!"}},"CALL DELTA",null,null,null,null,null,null,null,{"$f":"MIN($K$43:$K$55)","v":0},{"$f":"MIN($L$43:$L$55)","v":0},null,"SEP"]
[null,{"$f":"B44","v":25},{"$f":"B95-((C91*SQRT(B89/365)))","v":{"$error":"#NUM!"}},{"$f":"1-(ABS(B95-NORMSDIST(C95)))","v":{"$error":"#NUM!"}},"GAMMA",null,null,null,null,null,null,null,{"$f":"MAX($K$43:$K$55)","v":0},{"$f":"MAX($L$43:$L$55)","v":0},null,"OCT"]
[null,null,null,{"$f":"ABS(D95-D96)","v":{"$error":"#NUM!"}},"VEGA",null,null,null,null,null,null,null," "," ",null,"NOV"]
[" ",{"$f":"(LN(B90/B93) + (B92 + B91 * B91/2)* (B89/365))/((B91 * SQRT(B89/365)))","v":{"$error":"#NUM!"}},{"$f":"(LN(C90/B93) + (B92 + B91 * B91/2)* (B89/365))/((B91 * SQRT(B89/365)))","v":{"$error":"#NUM!"}},{"$f":"((B90*D92)-(((B93*EXP((-B92*(B89/365)))*NORMSDIST(B96)))))","v":{"$error":"#NUM!"}},"T CALL price",null,null,null,null,null,null,null,{"$f":"MIN(EXPIRATION!$K$36:$K$48)","v":-165.67},{"$f":"MIN(EXPIRATION!$L$36:$L$48)","v":17.29},null,"DEC"]
[{"$f":"A47","v":"JAN"},{"$f":"B95-((B91*SQRT(B89/365)))","v":{"$error":"#NUM!"}}," ",{"$f":"((B90*D92)-(((B93*EXP((-B92*(B89/365)))*NORMSDIST(C93)))))","v":{"$error":"#NUM!"}}," ",null,null,null,null,null,null,null,{"$f":"MAX(EXPIRATION!$K$36:$K$48)","v":3689.33},{"$f":"MAX(EXPIRATION!$L$36:$L$48)","v":26.29}]
[null,{"$f":"B96-((B92*SQRT(B90/365)))","v":{"$error":"#NUM!"}}," ",{"$f":"((B91*D93)-(((B94*EXP((-B93*(B90/365)))*NORMSDIST(C94)))))","v":{"$error":"#NUM!"}}," "]
[" "]
[]
[" "]

{"sheet":"CALCULATORS","index":10,"n_rows":86,"n_cols":22,"rows_kept":86,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,{"$f":"TODAY()","v":"2012-01-27"},null,null,{"$f":"TODAY()","v":"2012-01-27"},null,null,null,null,null,null," "]
[null,null,"STANDARD DEV"," ",null," "," ",null,null,null,null,null,null,"PORTFOLIO BALANCER","(Time Erosion)"," "]
[null,null,"Enter last 10 closing prices",null," ",{"$f":"F5/10","v":1.0346810000000004},"  ",null,"EXPIRE DATE"," ","STOCK","BETA ","HIST VOLATILITY","IV","#SHARES","TIME REMAINING","TRADE RISK $","TRADE RISK %","MAX GAIN $"]
[null,null," ",null,null,{"$f":"(SUM(F6:F15))","v":10.346810000000005},null,null,"00:00:00"," ",null,null,null,null,null,{"$f":"IF(I5>0,I5-$F$2,0)","v":0},0]
[null,1,25.29,{"$f":"SUM(C6:C15)","v":255.27},{"$f":"C6-D7","v":-0.23700000000000188},{"$f":"E6^2","v":5.6169000000000892E-2}," ",null,"2011-02-15","  ",null,0.5,0.3,0,10,30,0,0,0]
[null,2,23.07,{"$f":"D6/10","v":25.527000000000001},{"$f":"C7-($D$7)","v":-2.4570000000000007},{"$f":"E7^2","v":6.0368490000000037},null,null,"00:00:00"," ",null,null,null,0,null,0,0,0,0]
[null,3,24.5,null,{"$f":"C8-($D$7)","v":-1.027000000000001},1.054729000000002," ",null,"00:00:00"," ",null," ",null,0,null,0," ",0," "]
[null,4,25.25,null,-0.27700000000000102,7.6729000000000561E-2," ",null,"00:00:00"," "," ",null,null,0," ",0,0,null,0]
[null,5,26.16,null,0.63299999999999912,0.40068899999999891,null,null,"00:00:00"," ",null,null,null,0,null,0,0,0,2]
[null,6,25.91,null,0.38299999999999912,0.14668899999999932," ",null,"00:00:00"," ",null,null,null,0,null,0,0,null,0]
[null,7,26.64,null,1.1129999999999995,1.2387689999999989,null,null,"00:00:00"," ",null,null,null,0,null,0,0]
[null,8,25.92,null,0.39300000000000068,0.15444900000000053,null,null,"00:00:00",null," ",null,null,0,null,0," "," "]
[null,9,26.05,null,0.52299999999999969,0.27352899999999969,null,null,"00:00:00"," ","INDEX HDG",null,null,0,null,0,null," "]
[null,10,26.48,null,0.9529999999999994,0.90820899999999882,null,null,"00:00:00",null," ",null,null,null,null,0,null,null,{"$f":"COUNTIF(S5:S14,\">0\")","v":1}]
[null,null,{"$f":"F16","v":1.0171927054398298},"1 Standard Deviation",null,{"$f":"SQRT(F4)","v":1.0171927054398298},null,null," "," "," "," ",null,null,null,null,{"$f":"SUM(Q5:Q15)","v":0},{"$f":"SUM(R5:R15)","v":0},{"$f":"SUM(S5:S15)","v":3}]
[null,null,null,null," ",null,null,null,null,null,null," ",null," ",null," "]
[null,null,null,null," "," ",null,null,null," "]
[null,null,null,null,null,"IMPLIED VOLATILITY CALCULATOR",null,null,null,null,null,null," ",null,null,null,"STOCK VALUATION CALCULATOR"]
[null,null,"Enter Exp Month 1",null,"January",null,null,"Enter Exp Month 2",null,null,"August ",null,"Enter Exp Month 3",null,"April",null," "]
[null,null,"Enter Stock Price",null,8,null,null,"Stock Price",null,null,{"$f":"E21","v":8},null,"Stock Price",null,{"$f":"E21","v":8},null,"Enter share price",null,43.8]
[null,null,"Enter Strike Price",null,5,null,null,"Enter Strike Price",null,null,5,null,"Enter Strike Price",null,10,null,"Enter Earnings Per share",null,3.31]
[null,null,"Enter Distance %",null,0.19,null,null,"Maximium Distance %",null,null,{"$f":"E23","v":0.19},null,"Maximium Distance %",null,{"$f":"E23","v":0.19},null,"Enter Annual Growth rate",null,-71]
[null,null,"Enter Volume ",null,70,null,null,"Enter Volume",null,null,200,null,"Enter Volume",null,70,null,"Enter Industry AVG",null,21]
[null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,"."]
[null,null,"Distance Factor",null,{"$f":"(((ABS(E22-E21)/E21)-E23))^2/E23^2","v":0.94806094182825484},null,null,"Distance Factor",null,null,{"$f":"(((ABS(K22-K21)/K21)-K23))^2/K23^2","v":0.94806094182825484},null,"Distance Factor",null,{"$f":"(((ABS(O22-O21)/O21)-O23))^2/O23^2","v":9.9722991689750684E-2},null,"MULTIPLE",null,{"$f":"S21/S22","v":13.23262839879154}]
[null,null,"Enter Implied Volitality",null,0.92,null,null,"Enter Implied Volitality",null,null,0.5,null,"Enter Implied Volitality",null,0.69,null,null,null,{"$f":"IF(S26>S23,\"QUESTIONABLE\",IF(S26<S23,\"MORE RESEARCH\",IF(S26=S23,\"MORE RESEARCH\") ))","v":"QUESTIONABLE"}]
[null,null,"Volume Factor",null,{"$f":"E24/S32","v":0.24054982817869416},null,null,"Volume Factor",null,null,{"$f":"K24/S32","v":0.6872852233676976},null,"Volume Factor",null,{"$f":"O24/S32","v":0.24054982817869416},null,"IS IT A VALUE?",null,{"$f":"IF(S23>=S24,\"MORE RESEARCH\",S27)","v":"QUESTIONABLE"}]
[null,null,null,null,null,null,null,null,null,null,"IV= ",{"$f":"((E26*E27*E28)+(K26*K27*K28)+(O26*O27*O28))/((E26*E28)+(K26*K28)+(O26*O28))","v":0.61104211108477524},null,null,null,null,null,null,{"$f":"IF(S24>15,excellent,S28)","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null," "," "]
[null,null,null,"OVERSOLD OR OVERBOUGHT",null,null,null," "," ",null,"OEX EXPIRATION WEEK TRADING ",null,null,null,null," "," "]
[null,null,"Enter  Yesterday's Mo",0," "," ",null,"Enter Close ",674.51,null," ",null," "," ",null,{"$f":"R50","v":0},"Trade Risk ",null,{"$f":"SUM(E24+K24+S24)","v":291}]
[null,null,"Enter Todays advances",972,"Mo=",{"$f":"(F34*D32)+F35*D35","v":-139.30000000000001},null,"Wed Close",674.51,null,{"$f":"I33-I32","v":0},null,{"$f":"ABS(K33)","v":0},{"$f":"MAX(M33:M35)","v":674.51},null,{"$f":"P34-P35","v":4000},"Indicated BP",{"$f":"IF(S50<0,S50/P34,0)","v":{"$error":"#VALUE!"}},"  "]
[null,null,"Enter Todays Decliners",2365,"Yesterday ",0.9,null,"Thur Close",655.83,null,{"$f":"I34-I32","v":-18.67999999999995},null,{"$f":"ABS(K34)","v":18.67999999999995}," "," ",{"$f":"WORKSHEET!$I$41","v":4000},"(CAPITALIZATION)"," ",{"$f":"IF(S37=\"MKT CORRECTION\",\"ON\",\"OFF\")","v":"OFF"}]
[null,null,null,{"$f":"D33-D34","v":-1393},"Today ",0.1,null,"EXP Friday",0,null,{"$f":"I35-I32","v":-674.51},null,{"$f":"ABS(K35)","v":674.51},{"$f":"IF(N33>1.5,\"POSSIBLE  TRADE\",\"\")","v":"POSSIBLE  TRADE"},null,{"$f":"R50*P34 + WORKSHEET!$I$23","v":0},"TOT MARGIN REQ "]
[null,null,null," ",null,null,null,null,null,null," "," "," "," ",null,"ENTER Commission per Trade"]
[null,null,null,"AVERAGE TRUE RANGE ",null,null,null,{"$f":"TODAY()","v":"2012-01-27"},null,null,null," PORTFOLIO   BALANCER",null,"(DIRECTIONAL)","OFF",8.9499999999999993,null,null," "]
[null,null,null,null," ",null,null,"TRADE DATE","EXPIRE DATE","SECTOR","STOCK","BETA ","STANDARD DEV","IV","# SHARES","TIME LAPSE","TIME REMAINING","TRADE RISK %","P/L RATIO","CORRECTION"]
[null,null,"Enter the difference between todays High and Low",null,null,12,null,"2011-01-31","2011-01-31","Technology","XLF",-1.02,-1,0,1,1,1,0,-30,160]
[null,null," ",null,null,null,null,"2011-01-31","2012-01-31","Internet","AKAM",0.41,6.3,0,1,1,1,0,200,-200]
[null,null,"If the Market Gaps Higher:",null,null,null,null,"2011-04-04","2013-01-31"," "," "," "," "," "," "," "," "," "," "," "]
[null,null,"Enter the difference between todays high and ",null,null,50,null,"2011-01-31","2012-01-31"]
[null,null,"yesterdays close",null,null,null,null,"2011-01-31","2012-01-31"]
[null,null,null,null,null,null,null,"2011-01-31","2012-01-31"]
[null,null,"If the Market Gaps Lower:",null,null,null,null,"2011-01-21","2011-01-31"]
[null,null,"Enter the difference between todays low and ",null,null,0,null,"2011-01-01","2011-01-01"]
[null,null,"yesterdays close.",null,null,null,null,"2011-01-01","2011-01-01"]
[null,null,null,null,"ATR =",{"$f":"MAX(F39:F46)","v":50},null,"2011-01-01","2011-01-01",null," ",0,0,0,0,{"$f":"IF(DAYS360(H48,$F$2)>720,0,(DAYS360(H48,$F$2)))","v":386},{"$f":"IF(H48>0,I48-$F$2,0)","v":-391}," ",0,0]
[null,null,null,null,null,null,null,null," "," ",null,{"$f":"SUM(L39:L48)","v":-0.6100000000000001},{"$f":"SUM(M39:M48)","v":5.3},0,0,null,null,null,0.8,{"$f":"COUNTIF(S39:S48,\">0\")","v":1},{"$f":"((T49+S15)*P37)*2","v":35.799999999999997},{"$f":"SUM(S39:S48)/(T49-1)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null," "," ",null,null," ",null," "," ",null,null,{"$f":"IF( O37=\"off\",      ( (SUM(O39:O49)/O51)*100),  ( (SUM(L51:L61)/O51)*100))","v":100},null," ",{"$f":"Q51+R16","v":0},{"$f":"S51","v":{"$error":"#VALUE!"}},{"$f":"SUM(S39:S48)","v":170}]
[null,null,null,null,null,null,null,null,{"$f":"IF(J16>0,(MIN(J16,J50)),I50)","v":0},null," ",{"$f":"IF((SIGN(O39)>0),(O39*1),(IF(SIGN(O39)<0,(O39*1),0)))","v":1},{"$f":"IF((SIGN(S39)>0),(S39*-1),(IF(SIGN(S39)<0,(S39*-1),0)))","v":30}," ",{"$f":"COUNTIF(O39:O49,\">0\")","v":2},null,{"$f":"SUM(R39:R49)","v":0},{"$f":"((L40*((N40*S40)+S40)))","v":82},{"$f":"IF(S34=\"OFF\",(R52+S16),(R53+(-Q16)))","v":{"$error":"#VALUE!"}}]
[null,null,"January",null,null,null,"MKT DIRECTION",null,"ETF Beta's Can be found at YAHOO Finance",null,null,{"$f":"IF((SIGN(O40)>0),(O40*1),(IF(SIGN(O40)<0,(O40*1))))","v":1},"Consumer Discret",{"$f":"L64","v":5},{"$f":"N64","v":1},{"$f":"P64","v":9},{"$f":"(SUM((IF(L39<M39,L39,M39)*((IF(S34=\"ON\",(-O39*(S39-(N39*S39))),(O39*(S39+(N39*S39)))))))+((IF(L40<M40,L40,M40)*((IF(S34=\"ON\",(-O40*(S40-(N40*S39))),(O40*(S40+(N40*S40)))))))+((IF(L41<M41,L41,M41)*((IF(S34=\"ON\",((-O41*(S41-(N41*S41)))),(O41*(S41+(N41*S41)))))))+((IF(L42<M42,L42,M42)*((IF(S34=\"ON\",(-O42*(S42-(N42*S42))),(O42*(S42+(N42*S42)))))))+((IF(L43<M43,L43,M43)*((IF(S34=\"ON\",(-O43*(S43-(N43*S43))),(O43*(S43+(N43*S43)))))))+((IF(L44<M44,L44,M44)*((IF(S34=\"ON\",(-O44*(S44-(N44*S44))),(O44*(S44+(N44*S44)))))))+((IF(L45<M45,L45,M45)*((IF(S34=\"ON\",(-O45*(S45-(N45*S45))),(O45*(S45+(N45*S45)))))))+((IF(L46<M46,L46,M46)*((IF(S34=\"ON\",(-O46*(S46-(N46*S46))),(O46*(S46+(N46*S46)))))))+((IF(L47<M47,L47,M47)*((IF(S34=\"ON\",(-O47*(S47-(N47*S47))),(O47*(S47+(N47*S47)))))))+((IF(L48<M48,L48,M48)*((IF(S34=\"ON\",(-O48*(S48-(N48*S48))),(O48*(S48+(N48*S48))))))))))))))))))","v":{"$error":"#VALUE!"}},{"$f":"(SUM((IF(L39>M39,L39,M39)*((IF(S34=\"ON\",(-O39*(S39-(N39*S39))),(O39*(S39+(N39*S39)))))))+((IF(L40>M40,L40,M40)*((IF(S34=\"ON\",(-O40*(S40-(N40*S39))),(O40*(S40+(N40*S40)))))))+((IF(L41>M41,L41,M41)*((IF(S34=\"ON\",((-O41*(S41-(N41*S41)))),(O41*(S41+(N41*S41)))))))+((IF(L42>M42,L42,M42)*((IF(S34=\"ON\",(-O42*(S42-(N42*S42))),(O42*(S42+(N42*S42)))))))+((IF(L43>M43,L43,M43)*((IF(S34=\"ON\",(-O43*(S43-(N43*S43))),(O43*(S43+(N43*S43)))))))+((IF(L44>M44,L44,M44)*((IF(S34=\"ON\",(-O44*(S44-(N44*S44))),(O44*(S44+(N44*S44)))))))+((IF(L45>M45,L45,M45)*((IF(S34=\"ON\",(-O45*(S45-(N45*S45))),(O45*(S45+(N45*S45)))))))+((IF(L46>M46,L46,M46)*((IF(S34=\"ON\",(-O46*(S46-(N46*S46))),(O46*(S46+(N46*S46)))))))+((IF(L47>M47,L47,M47)*((IF(S34=\"ON\",(-O47*(S47-(N47*S47))),(O47*(S47+(N47*S47)))))))+((IF(L48>M48,L48,M48)*((IF(S34=\"ON\",(-O48*(S48-(N48*S48))),(O48*(S48+(N48*S48))))))))))))))))))","v":{"$error":"#VALUE!"}},{"$f":"(Q52)","v":{"$error":"#VALUE!"}},{"$f":"Q64","v":5.75}]
[null,null,"February ",null,null,null,"MKT CORRECTION",null,null,null,null,{"$f":"IF((SIGN(O41)>0),(O41*1),(IF(SIGN(O41)<0,(O41*1),0)))","v":{"$error":"#VALUE!"}},"Consumer Staples",8,6,2,{"$f":"(SUM((IF(L39<M39,L39,M39)*((IF(S34=\"ON\",(-O39*(T39-(N39*T39))),(O39*(T39+(N39*T39)))))))+((IF(L40<M40,L40,M40)*((IF(S34=\"ON\",(-O40*(T40-(N40*T39))),(O40*(T40+(N40*T40)))))))+((IF(L41<M41,L41,M41)*((IF(S34=\"ON\",((-O41*(T41-(N41*T41)))),(O41*(T41+(N41*T41)))))))+((IF(L42<M42,L42,M42)*((IF(S34=\"ON\",(-O42*(T42-(N42*T42))),(O42*(T42+(N42*T42)))))))+((IF(L43<M43,L43,M43)*((IF(S34=\"ON\",(-O43*(T43-(N43*T43))),(O43*(T43+(N43*T43)))))))+((IF(L44<M44,L44,M44)*((IF(S34=\"ON\",(-O44*(T44-(N44*T44))),(O44*(T44+(N44*T44)))))))+((IF(L45<M45,L45,M45)*((IF(S34=\"ON\",(-O45*(T45-(N45*T45))),(O45*(T45+(N45*T45)))))))+((IF(L46<M46,L46,M46)*((IF(S34=\"ON\",(-O46*(T46-(N46*T46))),(O46*(T46+(N46*T46)))))))+((IF(L47<M47,L47,M47)*((IF(S34=\"ON\",(-O47*(T47-(N47*T47))),(O47*(T47+(N47*T47)))))))+((IF(L48<M48,L48,M48)*((IF(S34=\"ON\",(-O48*(T48-(N48*T48))),(O48*(T48+(N48*T48))))))))))))))))))","v":{"$error":"#VALUE!"}},{"$f":"(SUM((IF(L39>M39,L39,M39)*((IF(S34=\"ON\",(-O39*(T39-(N39*T39))),(O39*(T39+(N39*T39)))))))+((IF(L40>M40,L40,M40)*((IF(S34=\"ON\",(-O40*(T40-(N40*T39))),(O40*(T40+(N40*T40)))))))+((IF(L41>M41,L41,M41)*((IF(S34=\"ON\",((-O41*(T41-(N41*T41)))),(O41*(T41+(N41*T41)))))))+((IF(L42>M42,L42,M42)*((IF(S34=\"ON\",(-O42*(T42-(N42*T42))),(O42*(T42+(N42*T42)))))))+((IF(L43>M43,L43,M43)*((IF(S34=\"ON\",(-O43*(T43-(N43*T43))),(O43*(T43+(N43*T43)))))))+((IF(L44>M44,L44,M44)*((IF(S34=\"ON\",(-O44*(T44-(N44*T44))),(O44*(T44+(N44*T44)))))))+((IF(L45>M45,L45,M45)*((IF(S34=\"ON\",(-O45*(T45-(N45*T45))),(O45*(T45+(N45*T45)))))))+((IF(L46>M46,L46,M46)*((IF(S34=\"ON\",(-O46*(T46-(N46*T46))),(O46*(T46+(N46*T46)))))))+((IF(L47>M47,L47,M47)*((IF(S34=\"ON\",(-O47*(T47-(N47*T47))),(O47*(T47+(N47*T47)))))))+((IF(L48>M48,L48,M48)*((IF(S34=\"ON\",(-O48*(T48-(N48*T48))),(O48*(T48+(N48*T48))))))))))))))))))","v":{"$error":"#VALUE!"}},{"$f":"-(R53)","v":{"$error":"#VALUE!"}},5]
[null,null,"March",null,null,null,null,null,null,null,null,{"$f":"IF((SIGN(O42)>0),(O42*1),(IF(SIGN(O42)<0,(O42*1),0)))","v":0},"Energy",3,9,4,null,null,{"$f":"-(Q53)","v":{"$error":"#VALUE!"}},6.25]
[null,null,"April",null,null,null,null,null,null,null,null,{"$f":"IF((SIGN(O43)>0),(O43*1),(IF(SIGN(O43)<0,(O43*1))))","v":false},"Financials",1,4,6,null,null,{"$f":"(R52)","v":{"$error":"#VALUE!"}},3]
[null,null,"May ",null,null,null,null,null,null,null,null,{"$f":"IF((SIGN(O44)>0),(O44*1),(IF(SIGN(O44)<0,(O44*1),0)))","v":0},"Heallth Care",9,7,3,null,null,null,6]
[null,null,"June ",null,null,null,null,null,null,null,null,0,"Industrials",2,2,7,null,null,null,4.25]
[null,null,"July ",null,null,null,null,null,null,null,null,0,"Materials",6,5,8,null,null,null,6.5]
[null,null,"August ",null,null,null,null,null,"Sector Performance",null,null,0,"Technology",3,3,5,null,null,null,3.5]
[null,null,"September ",null,null,null,null,null,0.93,null,null,0,"Utilities",7,8,1,null,null,null,4.75]
[null,null,"October ",null,null,null,null,null,0.2,null,null,0,{"$f":"IF((SIGN(S49)>0),(S49*-1),(IF(SIGN(S49)<0,(S49*-1),0)))","v":-0.8}]
[null,null,"November",null,"Enter Percentage",null,null,null,2.78]
[null,null,"December","1Day","5Day","1Month","3Month","1Year","SUM","RANK (Year)",null,"RANK 3 Month",null,"Rank 1 Month",null,"Rank 5 Day"]
[null,1,"Consumer Discret",1.61,3.31,-6.78,-3.08,25.62,{"$f":"SUM(D64:H64)","v":20.68},{"$f":"RANK(H64,H64:H72,1)","v":8},null,{"$f":"RANK(G64,G64:G72,1)","v":5},null,{"$f":"RANK(F64,F64:F72,1)","v":1},null,{"$f":"RANK(E64,E64:E72,1)","v":9},{"$f":"SUM(J64:P64)/4","v":5.75}]
[null,2,"Consumer Staples",0.81,0.57999999999999996,-3.3,4.4400000000000004,20.81,23.34,{"$f":"RANK(H65,H64:H72,1)","v":4},null,{"$f":"RANK(G65,G64:G72,1)","v":8},null,{"$f":"RANK(F65,F64:F72,1)","v":6},null,{"$f":"RANK(E65,E64:E72,1)","v":2},5]
[null,3,"Energy",2.0499999999999998,1.62,-2.2000000000000002,-3.91,38.119999999999997,35.68,{"$f":"RANK(H66,H64:H72,1)","v":9},null,{"$f":"RANK(G66,G64:G72,1)","v":3},null,{"$f":"RANK(F66,F64:F72,1)","v":9},null,{"$f":"RANK(E66,E64:E72,1)","v":4},6.25]
[null,4,"Financials",1,1.82,-5.07,-9.49,5.76,-5.98,{"$f":"RANK(H67,H64:H72,1)","v":1},null,{"$f":"RANK(G67,G64:G72,1)","v":1},null,{"$f":"RANK(F67,F64:F72,1)","v":4},null,{"$f":"RANK(E67,E64:E72,1)","v":6},3]
[null,5,"Heallth Care",0.87,1.35,-3.05,6.97,23.85,29.990000000000002,{"$f":"RANK(H68,H64:H72,1)","v":5},null,{"$f":"RANK(G68,G64:G72,1)","v":9},null,{"$f":"RANK(F68,F64:F72,1)","v":7},null,{"$f":"RANK(E68,E64:E72,1)","v":3},6]
[null,6,"Industrials",1.82,2.4,-6.53,-3.95,25.05,18.79,{"$f":"RANK(H69,H64:H72,1)","v":6},null,{"$f":"RANK(G69,G64:G72,1)","v":2},null,{"$f":"RANK(F69,F64:F72,1)","v":2},null,{"$f":"RANK(E69,E64:E72,1)","v":7},4.25]
[null,7,"Materials",1.36,2.78,-3.31,-1.42,25.12,24.53,{"$f":"RANK(H70,H64:H72,1)","v":7},null,{"$f":"RANK(G70,G64:G72,1)","v":6},null,{"$f":"RANK(F70,F64:F72,1)","v":5}," ",{"$f":"RANK(E70,E64:E72,1)","v":8},6.5]
[null,8,"Technology",1.31,1.67,-6.31,-3.91,19.98,12.74,{"$f":"RANK(H71,H64:H72,1)","v":3},null,{"$f":"RANK(G71,G64:G72,1)","v":3},null,{"$f":"RANK(F71,F64:F72,1)","v":3}," ",{"$f":"RANK(E71,E64:E72,1)","v":5},3.5]
[null,9,"Utilities",0.23,0.3,-2.33,1.85,18.73,18.78,{"$f":"RANK(H72,H64:H72,1)","v":2},null,{"$f":"RANK(G72,G64:G72,1)","v":7},null,{"$f":"RANK(F72,F64:F72,1)","v":8},1,{"$f":"RANK(E72,E64:E72,1)","v":1},4.75]
[null,null,null," "," ",null,null,null,0,null,null,null,null,null,2]
[]
[]
[]
[null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[null,null," "," "," "]