{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Strategy","NIFTY","LotSize","StrikeInterval","NIFTY_Option_Chain","Greeks"],"not_rendered":{"charts":4,"images":1,"macros":1,"external_links":0,"defined_names":45,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Strategy","index":0,"n_rows":45,"n_cols":21,"rows_kept":45,"cut":false,"hidden":false,"merged":[[21,13,27,15],[24,3,24,4],[25,3,25,4],[26,3,26,4],[4,6,4,9],[21,3,21,4],[22,3,22,4],[23,3,23,4],[27,3,27,4]]}
[]
[null,"Please fill-in only the yellow cells! ",null,null,"There are provisions to  try to different combinations up to 4 trades in Futures, Cash and Options.",null,null,null,null,null,null,null,null,null,"Please do not insert or delete any row / column!"]
[null,null,null,null,"Some bug will still be there, please let me know if you find any error."]
[]
[null,"Stock Options",null,null,null,null,"Pay-off or \"Profit and Loss\" Table",null,null,null,null,null,null,null,null,null,"fnoAction",null,null,"Securities Transaction Tax",{"$f":"44.74/44744","v":9.9991060253888805E-4}]
[null,"Net over-head on cash","ITC","Lot Size","Strike X",1,null,null,null,null,null,null,"YESBANK","Lot Size","Strike X",1,"Buy Cash",null,null,"Service Tax",{"$f":"12.74/44744","v":2.8473091364205255E-4}]
[null,{"$f":"ROUND(1-44589.59/44744, 5)","v":3.4499999999999999E-3},null,{"$f":"IF(C6=\"BAKNIFTY\", 30, VLOOKUP(C6, LotSize, 2, FALSE))","v":2400},"Strike Interval",{"$f":"VLOOKUP(C6, fnoStepValue, 2, FALSE)","v":10},null,null,null,null,null,null,null,{"$f":"VLOOKUP(M6, LotSize, 2, FALSE)","v":1750},"Strike Interval",{"$f":"VLOOKUP(M6, fnoStepValue, 2, FALSE)","v":10},"Buy Put",null,null,"Education Cess",0]
[null,"@ Brokerage 0.20%","Buy Cash","Sell Call",null,null,null,null,null,null,null,null,"Buy Cash","Sell Call","Sell Put",null,"Buy Call",null,null,"Higher Education Cess",0]
[null,"CMP",264,280,null,{"$f":"IF(F8=\"\", \"\", $C$9)","v":""},null,null,null,null,null,null,310,{"$f":"IF(N8=\"\", \"\", $M$9)","v":310},{"$f":"IF(O8=\"\", \"\", $M$9)","v":310},{"$f":"IF(P8=\"\", \"\", $M$9)","v":""},"Sell Put",null,null,"Swach Bharat Cess",{"$f":"0.46/44744","v":1.0280708027892009E-5}]
[null,"Trade Quantity",610,2400,null,null,null,null,null,null,null,null,100,340,280,null,"Sell Call",null,null,"Krishi Kalyan Cess",{"$f":"0.46/44744","v":1.0280708027892009E-5}]
[null,"Strike/ B / S Price",278,300,null,null,null,null,null,null,null,null,312,316,330,null,"Buy FUTR",null,null,"Exchange Transaction Charges",{"$f":"1.52/44744","v":3.3971035222599675E-5}]
[null,"Premium of 1st Leg",0,2400,null,null,null,null,null,null,null,null,0,{"$f":"40*N10","v":13600},{"$f":"4*O10","v":1120},null,"Sell FUTR",null,null,"Stamp Duty",5]
[null,"Sq-off Premium",0,0,null,null,null,null,null,null,null,null,0,0,0]
[null,"Implied or Hist. Vol.",0.3,{"$f":"IF(D$8=\"\", \"\", $C14)","v":0.3},{"$f":"IF(E$8=\"\", \"\", $C14)","v":""},{"$f":"IF(F$8=\"\", \"\", $C14)","v":""},null,null,null,null,null,null,0.3,{"$f":"IF(N$8=\"\", \"\", $M14)","v":0.3},{"$f":"IF(O$8=\"\", \"\", $M14)","v":0.3},{"$f":"IF(P$8=\"\", \"\", $M14)","v":""}]
[null,"Dividend Yield",0,null,"IR on Margin:",0.18,null,null,null,null,null,null,null,null,"IR on Margin:",0.18]
[null,"Risk-Reward Ratio",{"$f":"IF(ABS(MIN(B45:H45))=0, \"\", MAX(B45:H45)/ABS(MIN(B45:H45)))","v":1.021336938215728},"probability",{"$f":"ABS(SUM(C19:F19))","v":0.24797866666666665},null,null,null,null,null,null,null,{"$f":"IF(ABS(MIN(Q36:Q42))=0, \"\", MAX(Q36:Q42)/ABS(MIN(Q36:Q42)))","v":7.6474929214299099},"probability",{"$f":"ABS(SUM(M19:P19))","v":0.7937048571428571}]
[null,"Theoretical Premium",{"$f":"IF(OR(C$8=\"\", C$11=\"\"),\"\", IF(OR(C$8=\"Buy Call\", C$8=\"Sell Call\"), premCall(C$9, C11, t, RFR, C$14, DYX), IF(OR(C$8=\"Buy Put\", C$8=\"Sell Put\"), premPut(C$9, C11, t, RFR, C$14, DYX), IF(OR(C$8=\"Buy Cash\", C$8=\"Buy FUTR\"), 0, 0))))","v":0},{"$f":"IF(OR(D$8=\"\", D$11=\"\"),\"\", IF(OR(D$8=\"Buy Call\", D$8=\"Sell Call\"), premCall(D$9, D11, t, RFR, D$14, DYX), IF(OR(D$8=\"Buy Put\", D$8=\"Sell Put\"), premPut(D$9, D11, t, RFR, D$14, DYX), IF(OR(D$8=\"Buy Cash\", D$8=\"Buy FUTR\"), 0, 0))))","v":1.5100000000000001E-2},{"$f":"IF(OR(E$8=\"\", E$11=\"\"),\"\", IF(OR(E$8=\"Buy Call\", E$8=\"Sell Call\"), premCall(E$9, E11, t, RFR, E$14, DYX), IF(OR(E$8=\"Buy Put\", E$8=\"Sell Put\"), premPut(E$9, E11, t, RFR, E$14, DYX), IF(OR(E$8=\"Buy Cash\", E$8=\"Buy FUTR\"), 0, 0))))","v":""},{"$f":"IF(OR(F$8=\"\", F$11=\"\"),\"\", IF(OR(F$8=\"Buy Call\", F$8=\"Sell Call\"), premCall(F$9, F11, t, RFR, F$14, DYX), IF(OR(F$8=\"Buy Put\", F$8=\"Sell Put\"), premPut(F$9, F11, t, RFR, F$14, DYX), IF(OR(F$8=\"Buy Cash\", F$8=\"Buy FUTR\"), 0, 0))))","v":""},null,null,null,null,null,null,{"$f":"IF(OR(M$8=\"\", M$11=\"\"),\"\", IF(OR(M$8=\"Buy Call\", M$8=\"Sell Call\"), premCall(M$9, M11, t, RFR, M$14, DYX), IF(OR(M$8=\"Buy Put\", M$8=\"Sell Put\"), premPut(M$9, M11, t, RFR, M$14, DYX), IF(OR(M$8=\"Buy Cash\", M$8=\"Buy FUTR\"), 0, 0))))","v":0},{"$f":"IF(OR(N$8=\"\", N$11=\"\"),\"\", IF(OR(N$8=\"Buy Call\", N$8=\"Sell Call\"), premCall(N$9, N11, t, RFR, N$14, DYY), IF(OR(N$8=\"Buy Put\", N$8=\"Sell Put\"), premPut(N$9, N11, t, RFR, N$14, DYY), IF(OR(N$8=\"Buy Cash\", N$8=\"Buy FUTR\"), 0, 0))))","v":1.2513000000000001},{"$f":"IF(OR(O$8=\"\", O$11=\"\"),\"\", IF(OR(O$8=\"Buy Call\", O$8=\"Sell Call\"), premCall(O$9, O11, t, RFR, O$14, DYY), IF(OR(O$8=\"Buy Put\", O$8=\"Sell Put\"), premPut(O$9, O11, t, RFR, O$14, DYY), IF(OR(O$8=\"Buy Cash\", O$8=\"Buy FUTR\"), 0, 0))))","v":19.838000000000001},{"$f":"IF(OR(P$8=\"\", P$11=\"\"),\"\", IF(OR(P$8=\"Buy Call\", P$8=\"Sell Call\"), premCall(P$9, P11, t, RFR, P$14, DYY), IF(OR(P$8=\"Buy Put\", P$8=\"Sell Put\"), premPut(P$9, P11, t, RFR, P$14, DYY), IF(OR(P$8=\"Buy Cash\", P$8=\"Buy FUTR\"), 0, 0))))","v":""}]
[null,{"$f":"\"Theta=  \" & TEXT(ROUND(SUM(C18:F18), 4), \"0.000\")","v":"Theta=  0.023"},{"$f":"IF(OR(C$8=\"\", C$11=\"\"), \"\", IF(C$8=\"Buy Call\", calltheta(C$9,C$11,t,RFR,DYX), IF(C$8=\"Sell Call\",-calltheta(C$9,C$11,t, RFR,C$14,DYX), IF(C$8=\"Buy Put\",PutTheta(C$9,C$11,t,RFR,C$14,DYX), IF(C$8=\"Sell Put\", -PutTheta(C$9,C$11,t,RFR,C$14,DYX), 0)))))","v":0},{"$f":"IF(OR(D$8=\"\", D$11=\"\"), \"\", IF(D$8=\"Buy Call\", calltheta(D$9,D$11,t,RFR,D$14,DYX), IF(D$8=\"Sell Call\",-calltheta(D$9,D$11,t, RFR,D$14,DYX), IF(D$8=\"Buy Put\",PutTheta(D$9,D$11,t,RFR,D$14,DYX), IF(D$8=\"Sell Put\", -PutTheta(D$9,D$11,t,RFR,D$14,DYX), 0)))))","v":2.2519000000000001E-2},{"$f":"IF(OR(E$8=\"\", E$11=\"\"), \"\", IF(E$8=\"Buy Call\", calltheta(E$9,E$11,t,RFR,E$14,DYX), IF(E$8=\"Sell Call\",-calltheta(E$9,E$11,t, RFR,E$14,DYX), IF(E$8=\"Buy Put\",PutTheta(E$9,E$11,t,RFR,E$14,DYX), IF(E$8=\"Sell Put\", -PutTheta(E$9,E$11,t,RFR,E$14,DYX), 0)))))","v":""},{"$f":"IF(OR(F$8=\"\", F$11=\"\"), \"\", IF(F$8=\"Buy Call\", calltheta(F$9,F$11,t,RFR,F$14,DYX), IF(F$8=\"Sell Call\",-calltheta(F$9,F$11,t, RFR,F$14,DYX), IF(F$8=\"Buy Put\",PutTheta(F$9,F$11,t,RFR,F$14,DYX), IF(F$8=\"Sell Put\", -PutTheta(F$9,F$11,t,RFR,F$14,DYX), 0)))))","v":""},null,null,null,null,null,null,{"$f":"IF(OR(M$8=\"\", M$11=\"\"), \"\", IF(M$8=\"Buy Call\", calltheta(M$9,M$11,t,RFR,M$14,DYY), IF(M$8=\"Sell Call\",-calltheta(M$9,M$11,t, RFR,M$14,DYY), IF(M$8=\"Buy Put\",PutTheta(M$9,M$11,t,RFR,M$14,DYY), IF(M$8=\"Sell Put\", -PutTheta(M$9,M$11,t,RFR,M$14,DYY), 0)))))","v":0},{"$f":"IF(OR(N$8=\"\", N$11=\"\"), \"\", IF(N$8=\"Buy Call\", calltheta(N$9,N$11,t,RFR,N$14,DYY), IF(N$8=\"Sell Call\",-calltheta(N$9,N$11,t, RFR,N$14,DYY), IF(N$8=\"Buy Put\",PutTheta(N$9,N$11,t,RFR,N$14,DYY), IF(N$8=\"Sell Put\", -PutTheta(N$9,N$11,t,RFR,N$14,DYY), 0)))))","v":0.46329199999999998},{"$f":"IF(OR(O$8=\"\", O$11=\"\"), \"\", IF(O$8=\"Buy Call\", calltheta(O$9,O$11,t,RFR,O$14,DYY), IF(O$8=\"Sell Call\",-calltheta(O$9,O$11,t, RFR,O$14,DYY), IF(O$8=\"Buy Put\",PutTheta(O$9,O$11,t,RFR,O$14,DYY), IF(O$8=\"Sell Put\", -PutTheta(O$9,O$11,t,RFR,O$14,DYY), 0)))))","v":-2.1340999999999999E-2},{"$f":"IF(OR(P$8=\"\", P$11=\"\"), \"\", IF(P$8=\"Buy Call\", calltheta(P$9,P$11,t,RFR,P$14,DYY), IF(P$8=\"Sell Call\",-calltheta(P$9,P$11,t, RFR,P$14,DYY), IF(P$8=\"Buy Put\",PutTheta(P$9,P$11,t,RFR,P$14,DYY), IF(P$8=\"Sell Put\", -PutTheta(P$9,P$11,t,RFR,P$14,DYY), 0)))))","v":""},{"$f":"\"Theta= \" & TEXT(ROUND(SUM(M18:P18), 4), \"0.000\")","v":"Theta= 0.442"}]
[null,{"$f":"\"Delta= \" & TEXT(ROUND(SUM(C19:F19), 4), \"0.000\")","v":"Delta= 0.248"},{"$f":"IF(OR(C$8=\"\", C$11=\"\"), \"\", IF(C$8=\"Buy Call\",  CallDelta(C$9, C$11, t, RFR, C$14, DYX), IF(C$8=\"Sell Call\", -CallDelta(C$9, C$11,t,RFR, C$14, DYX), IF(C$8=\"Buy Put\", Putdelta(C$9, C$11, t, RFR, C$14, DYX), IF(C$8=\"Sell Put\", -Putdelta(C$9, C$11, t, RFR,C$14, DYX), IF(OR(C$8=\"Buy Cash\", C$8=\"Buy FUTR\"), 1*C10/$D$7, -1*C10/$D$7))))))","v":0.25416666666666665},{"$f":"IF(OR(D$8=\"\", D$11=\"\"), \"\", IF(D$8=\"Buy Call\",  CallDelta(D$9, D$11, t, RFR, D$14, DYX), IF(D$8=\"Sell Call\", -CallDelta(D$9, D$11,t,RFR, D$14, DYX), IF(D$8=\"Buy Put\", Putdelta(D$9, D$11, t, RFR, D$14, DYX), IF(D$8=\"Sell Put\", -Putdelta(D$9, D$11, t, RFR, D$14, DYX), IF(OR(D$8=\"Buy Cash\", D$8=\"Buy FUTR\"), 1*D10/$D$7, -1*D10/$D$7))))))","v":-6.1879999999999999E-3},{"$f":"IF(OR(E$8=\"\", E$11=\"\"), \"\", IF(E$8=\"Buy Call\",  CallDelta(E$9, E$11, t, RFR, E$14, DYX), IF(E$8=\"Sell Call\", -CallDelta(E$9, E$11,t,RFR, E$14, DYX), IF(E$8=\"Buy Put\", Putdelta(E$9, E$11, t, RFR, E$14, DYX), IF(E$8=\"Sell Put\", -Putdelta(E$9, E$11, t, RFR, E$14, DYX), IF(OR(E$8=\"Buy Cash\", E$8=\"Buy FUTR\"), 1*E10/$D$7, -1*E10/$D$7))))))","v":""},{"$f":"IF(OR(F$8=\"\", F$11=\"\"), \"\", IF(F$8=\"Buy Call\",  CallDelta(F$9, F$11, t, RFR, F$14, DYX), IF(F$8=\"Sell Call\", -CallDelta(F$9, F$11,t,RFR, F$14, DYX), IF(F$8=\"Buy Put\", Putdelta(F$9, F$11, t, RFR, F$14, DYX), IF(F$8=\"Sell Put\", -Putdelta(F$9, F$11, t, RFR, F$14, DYX), IF(OR(F$8=\"Buy Cash\", F$8=\"Buy FUTR\"), 1*F10/$D$7, -1*F10/$D$7))))))","v":""},null,null,null,null,null,null,{"$f":"IF(OR(M$8=\"\", M$11=\"\"), \"\", IF(M$8=\"Buy Call\",  CallDelta(M$9, M$11, t, RFR, M$14, DYY), IF(M$8=\"Sell Call\", -CallDelta(M$9, M$11,t,RFR, M$14, DYY), IF(M$8=\"Buy Put\", Putdelta(M$9, M$11, t, RFR, M$14, DYY), IF(M$8=\"Sell Put\", -Putdelta(M$9, M$11, t, M$14, DYY), IF(OR(M$8=\"Buy Cash\", M$8=\"Buy FUTR\"), 1*M10/N$7, -1*M10/N$7))))))","v":5.7142857142857141E-2},{"$f":"IF(OR(N$8=\"\", N$11=\"\"), \"\", IF(N$8=\"Buy Call\",  CallDelta(N$9, N$11, t, RFR, N$14, DYX), IF(N$8=\"Sell Call\", -CallDelta(N$9, N$11,t,RFR, N$14, DYX), IF(N$8=\"Buy Put\", Putdelta(N$9, N$11, t, RFR, N$14, DYX), IF(N$8=\"Sell Put\", -Putdelta(N$9, N$11, t, RFR, N$14, DYX), IF(OR(N$8=\"Buy Cash\", N$8=\"Buy FUTR\"), 1*N10/$D$7, -1*N10/$D$7))))))","v":-0.25162800000000002},{"$f":"IF(OR(O$8=\"\", O$11=\"\"), \"\", IF(O$8=\"Buy Call\",  CallDelta(O$9, O$11, t, RFR, O$14, DYX), IF(O$8=\"Sell Call\", -CallDelta(O$9, O$11,t,RFR, O$14, DYX), IF(O$8=\"Buy Put\", Putdelta(O$9, O$11, t, RFR, O$14, DYX), IF(O$8=\"Sell Put\", -Putdelta(O$9, O$11, t, RFR, O$14, DYX), IF(OR(O$8=\"Buy Cash\", O$8=\"Buy FUTR\"), 1*O10/$D$7, -1*O10/$D$7))))))","v":0.98819000000000001},{"$f":"IF(OR(P$8=\"\", P$11=\"\"), \"\", IF(P$8=\"Buy Call\",  CallDelta(P$9, P$11, t, RFR, P$14, DYY), IF(P$8=\"Sell Call\", -CallDelta(P$9, P$11,t,RFR, P$14, DYY), IF(P$8=\"Buy Put\", Putdelta(P$9, P$11, t, RFR, P$14, DYY), IF(P$8=\"Sell Put\", -Putdelta(P$9, P$11, t, P$14, DYY), IF(OR(P$8=\"Buy Cash\", P$8=\"Buy FUTR\"), 1*P10/Q$7, -1*P10/Q$7))))))","v":""},{"$f":"\"Delta= \" & TEXT(ROUND(SUM(M19:P19), 4), \"0.000\")","v":"Delta= 0.794"}]
[null,{"$f":"\"Vega=  \" & TEXT(ROUND(SUM(C20:F20),4), \"0.000\")","v":"Vega=  0.004"},{"$f":"IF(OR(C$8=\"\", C$11=\"\"), \"\", IF(OR(C$8=\"Buy Call\",C$8=\"Sell Call\",C$8=\"Buy Put\",C$8=\"Sell Put\"),Vega(C$9,C11,t,RFR,C$14,DYX),IF(OR(C$8=\"Buy Cash\",C$8=\"Buy FUTR\"),0)))","v":0},{"$f":"IF(OR(D$8=\"\", D$11=\"\"), \"\", IF(OR(D$8=\"Buy Call\",D$8=\"Sell Call\",D$8=\"Buy Put\",D$8=\"Sell Put\"),Vega(D$9,D11,t,RFR,D$14,DYX),IF(OR(D$8=\"Buy Cash\",D$8=\"Buy FUTR\"),0)))","v":4.4359999999999998E-3},{"$f":"IF(OR(E$8=\"\", E$11=\"\"), \"\", IF(OR(E$8=\"Buy Call\",E$8=\"Sell Call\",E$8=\"Buy Put\",E$8=\"Sell Put\"),Vega(E$9,E11,t,RFR,E$14,DYX),IF(OR(E$8=\"Buy Cash\",E$8=\"Buy FUTR\"),0)))","v":""},{"$f":"IF(OR(F$8=\"\", F$11=\"\"), \"\", IF(OR(F$8=\"Buy Call\",F$8=\"Sell Call\",F$8=\"Buy Put\",F$8=\"Sell Put\"),Vega(F$9,F11,t,RFR,F$14,DYX),IF(OR(F$8=\"Buy Cash\",F$8=\"Buy FUTR\"),0)))","v":""},null,null,null,null,null,null,{"$f":"IF(OR(M$8=\"\", M$11=\"\"), \"\", IF(OR(M$8=\"Buy Call\",M$8=\"Sell Call\",M$8=\"Buy Put\",M$8=\"Sell Put\"),Vega(M$9,M11,t,RFR,M$14,DYY),IF(OR(M$8=\"Buy Cash\",M$8=\"Buy FUTR\"),0)))","v":0},{"$f":"IF(OR(N$8=\"\", N$11=\"\"), \"\", IF(OR(N$8=\"Buy Call\",N$8=\"Sell Call\",N$8=\"Buy Put\",N$8=\"Sell Put\"),Vega(N$9,N11,t,RFR,N$14,DYY),IF(OR(N$8=\"Buy Cash\",N$8=\"Buy FUTR\"),0)))","v":8.9617000000000002E-2},{"$f":"IF(OR(O$8=\"\", O$11=\"\"), \"\", IF(OR(O$8=\"Buy Call\",O$8=\"Sell Call\",O$8=\"Buy Put\",O$8=\"Sell Put\"),Vega(O$9,O11,t,RFR,O$14,DYY),IF(OR(O$8=\"Buy Cash\",O$8=\"Buy FUTR\"),0)))","v":8.6569999999999998E-3},{"$f":"IF(OR(P$8=\"\", P$11=\"\"), \"\", IF(OR(P$8=\"Buy Call\",P$8=\"Sell Call\",P$8=\"Buy Put\",P$8=\"Sell Put\"),Vega(P$9,P11,t,RFR,P$14,DYY),IF(OR(P$8=\"Buy Cash\",P$8=\"Buy FUTR\"),0)))","v":""},{"$f":"\"Vega = \" & TEXT(ROUND(SUM(M20:P20),4), \"0.000\")","v":"Vega = 0.098"}]
[null,{"$f":"\"Gamma=  \"  & TEXT(ROUND(SUM(C21:F21),4), \"0.000\")","v":"Gamma=  0.002"},{"$f":"IF(OR(C$8=\"\", C$11=\"\"), \"\", IF(C8=\"Buy Cash\", 0, Gamma(C$9, C11, t, RFR, C$14, DYX)))","v":0},{"$f":"IF(OR(D$8=\"\", D$11=\"\"), \"\", IF(D8=\"Buy Cash\", 0, Gamma(D$9, D11, t, RFR, D$14, DYX)))","v":2.2950000000000002E-3},{"$f":"IF(OR(E$8=\"\", E$11=\"\"), \"\", IF(E8=\"Buy Cash\", 0, Gamma(E$9, E11, t, RFR, E$14, DYX)))","v":""},{"$f":"IF(OR(F$8=\"\", F$11=\"\"), \"\", IF(F8=\"Buy Cash\", 0, Gamma(F$9, F11, t, RFR, F$14, DYX)))","v":""},null,null,null,null,null,null,{"$f":"IF(OR(M$8=\"\", M$11=\"\"), \"\", IF(M8=\"Buy Cash\", 0, Gamma(M$9, M11, t, RFR, M$14, DYY)))","v":0},{"$f":"IF(OR(N$8=\"\", N$11=\"\"), \"\", IF(N8=\"Buy Cash\", 0, Gamma(N$9, N11, t, RFR, N$14, DYY)))","v":3.7819999999999999E-2},{"$f":"IF(OR(O$8=\"\", O$11=\"\"), \"\", IF(O8=\"Buy Cash\", 0, Gamma(O$9, O11, t, RFR, O$14, DYY)))","v":3.6540000000000001E-3},{"$f":"IF(OR(P$8=\"\", P$11=\"\"), \"\", IF(P8=\"Buy Cash\", 0, Gamma(P$9, P11, t, RFR, P$14, DYY)))","v":""},{"$f":"\"Gamma= \"  & TEXT(ROUND(SUM(M21:P21),4), \"0.000\")","v":"Gamma= 0.042"}]
[null,"Spot Price at Sqr-Off",{"$f":"IF(C$8=\"\", \"\", C23-F7*F6)","v":250},"STCG Tax/Cess:",null,0.15,null,null,null,null,null,null,{"$f":"IF(M$8=\"\", \"\", M23-P7*P6)","v":290}]
[null,null,{"$f":"IF(C$8=\"\", \"\", C24-F$7*F6)","v":260},"Income Tax Rate:",null,0,null,null,null,null,null,null,{"$f":"IF(M$8=\"\", \"\", M24-P$7*P6)","v":300}]
[null,null,{"$f":"IF(C$8=\"\", \"\", C25-F$7*F6)","v":270},"Brokerage FUTURE:",null,2.0000000000000001E-4,null,null,null,null,null,null,{"$f":"IF(M$8=\"\", \"\", M25-P$7*P6)","v":310}]
[null,null,{"$f":" IF(C$8=\"\", \"\", ROUND(AVERAGE(C9, C11:F11)/F7,0)*F7)","v":280},"Brokerage OPTIONS:",null,50,null,null,null,null,null,null,{"$f":" IF(M$8=\"\", \"\", ROUND(AVERAGE(M9, M11:P11)/P7,0)*P7)","v":320}]
[null,null,{"$f":"IF(C$8=\"\", \"\", C25+F$7*F6)","v":290},"Brokerage   Delivery:",null,1E-3,null,null,null,null,null,null,{"$f":"IF(M$8=\"\", \"\", M25+P$7*P6)","v":330}]
[null,null,{"$f":"IF(C$8=\"\", \"\", C26+F$7*F6)","v":300},"Brokerage   Intra-day:",null,2.9999999999999997E-4,null,null,null,null,null,null,{"$f":"IF(M$8=\"\", \"\", M26+P$7*P6)","v":340}]
[null,null,{"$f":"IF(C$8=\"\", \"\", C27+F$7*F6)","v":310},"Cess, S. Tax, STT factor:",null,1.2,null,null,null,null,null,null,{"$f":"IF(M$8=\"\", \"\", M27+P$7*P6)","v":350},null,null,null,"Total"]
[null,null,{"$f":"IF(OR(C$8=\"\", C$11=\"\"), \"\", IF(C$8=\"Buy Cash\", 0-(C$9*C$10*BrkgCASH*(1+sTax))-($C22*C$10*BrkgCASH*(1+sTax)),  0-IF($C22>C$11,2*BrkgOPTN*1.2,BrkgOPTN*1.2)))","v":-364.96055999999999},-60,{"$f":"IF(OR(E$8=\"\", E$11=\"\"), \"\", IF(E$8=\"Buy Cash\", 0-(E$9*E$10*BrkgCASH*(1+sTax))-($C22*E$10*BrkgCASH*(1+sTax)),  0-IF($C22>E$11,2*BrkgOPTN*1.2,BrkgOPTN*1.2)))","v":""},{"$f":"IF(OR(F$8=\"\", F$11=\"\"), \"\", IF(F$8=\"Buy Cash\", 0-(F$9*F$10*BrkgCASH*(1+sTax))-($C22*F$10*BrkgCASH*(1+sTax)),  0-IF($C22>F$11,2*BrkgOPTN*1.2,BrkgOPTN*1.2)))","v":""},null,null,null,null,null,null,{"$f":"IF(M$8=\"\", \"\", IF(M$8=\"Buy Cash\", 0-(M$9*M$10*BrkgCASH*(1+sTax))-($M22*M$10*BrkgCASH*(1+sTax)),  0-IF($M22>M$11,2*BrkgOPTN*1.2,BrkgOPTN*1.2)))","v":-69.84},-60,{"$f":"IF(O$8=\"\", \"\", IF(O$8=\"Buy Cash\", 0-(O$9*O$10*BrkgCASH*(1+sTax))-($M22*O$10*BrkgCASH*(1+sTax)),  0-IF($M22>O$11,2*BrkgOPTN*1.2,BrkgOPTN*1.2)))","v":-60},{"$f":"IF(P$8=\"\", \"\", IF(P$8=\"Buy Cash\", 0-(P$9*P$10*BrkgCASH*(1+sTax))-($M22*P$10*BrkgCASH*(1+sTax)),  0-IF($M22>P$11,2*BrkgOPTN*1.2,BrkgOPTN*1.2)))","v":""},{"$f":"SUM(M29:P29)","v":-189.84}]
[null,null,-372.06095999999991,-60,"","",null,null,null,null,null,null,-71.003999999999991,-60,-60,"",-191.00399999999999]
[null,"Brokerage",-379.16135999999995,-60,"","",null,null,null,null,null,null,-72.167999999999992,-60,-60,"",-192.16800000000001]
[null,null,-386.26175999999998,-60,"","",null,null,null,null,null,null,-73.331999999999994,-120,-60,"",-253.33199999999999]
[null,null,-393.36215999999996,-60,"","",null,null,null,null,null,null,-74.495999999999995,-120,-60,"",-254.49599999999998]
[null,null,-400.46255999999994,-60,"","",null,null,null,null,null,null,-75.66,-120,-120,"",-315.65999999999997]
[null,null,-407.56295999999998,-120,"","",null,null,null,null,null,null,-76.823999999999984,-120,-120,"",-316.82399999999996]
[null,null,{"$f":"IF(OR(C$8=\"\", C$11=\"\"), \"\", IF(OR(C$8=\"Buy Cash\", C$8=\"Buy FUTR\", C$8=\"Sell FUTR\"), (($C22-C$11)*C$10+$C29)*(1-STCG),   (1-nTax)*(C$12+C$13+$C29+IF(C$8=\"Buy Call\", MAX(C$10*($C22-C$11), 0), IF(C$8=\"Buy Put\", MAX(C$10*(C$11-$C22), 0), IF(C$8=\"Sell Call\", MIN(-C$10*($C22-C$11), 0), IF(C$8=\"Sell Put\", MIN(-C$10*(C$11-$C22), 0))))))))","v":-14828.216476},2035.03944,{"$f":"IF(OR(E$8=\"\", E$11=\"\"), \"\", IF(OR(E$8=\"Buy Cash\", E$8=\"Buy FUTR\", E$8=\"Sell FUTR\"), (($C22-E$11)*E$10+$C29)*(1-STCG),   (1-nTax)*(E$12+E$13+$C29+IF(E$8=\"Buy Call\", MAX(E$10*($C22-E$11), 0), IF(E$8=\"Buy Put\", MAX(E$10*(E$11-$C22), 0), IF(E$8=\"Sell Call\", MIN(-E$10*($C22-E$11), 0), IF(E$8=\"Sell Put\", MIN(-E$10*(E$11-$C22), 0))))))))","v":""},{"$f":"IF(OR(F$8=\"\", F$11=\"\"), \"\", IF(OR(F$8=\"Buy Cash\", F$8=\"Buy FUTR\", F$8=\"Sell FUTR\"), (($C22-F$11)*F$10+$C29)*(1-STCG),   (1-nTax)*(F$12+F$13+$C29+IF(F$8=\"Buy Call\", MAX(F$10*($C22-F$11), 0), IF(F$8=\"Buy Put\", MAX(F$10*(F$11-$C22), 0), IF(F$8=\"Sell Call\", MIN(-F$10*($C22-F$11), 0), IF(F$8=\"Sell Put\", MIN(-F$10*(F$11-$C22), 0))))))))","v":""},null,null,null,null,null,null,{"$f":"IF(M$8=\"\", \"\", IF(OR(M$8=\"Buy Cash\", M$8=\"Buy FUTR\", M$8=\"Sell FUTR\"), ((M22-M$11)*M$10+M29)*(1-STCG),   (1-nTax)*(M$12+M$13+M29+IF(M$8=\"Buy Call\", MAX(M$10*(M22-M$11), 0), IF(M$8=\"Buy Put\", MAX(M$10*(M$11-M22), 0), IF(M$8=\"Sell Call\", MIN(-M$10*(M22-M$11), 0), IF(M$8=\"Sell Put\", MIN(-M$10*(M$11-M22), 0))))))))","v":-1929.364},{"$f":"IF(N$8=\"\", \"\", IF(OR(N$8=\"Buy Cash\", N$8=\"Buy FUTR\", N$8=\"Sell FUTR\"), (($M22-N$11)*N$10+N29)*(1-STCG),   (1-nTax)*(N$12+N$13+N29+IF(N$8=\"Buy Call\", MAX(N$10*($M22-N$11), 0), IF(N$8=\"Buy Put\", MAX(N$10*(N$11-$M22), 0), IF(N$8=\"Sell Call\", MIN(-N$10*($M22-N$11), 0), IF(N$8=\"Sell Put\", MIN(-N$10*(N$11-$M22), 0))))))))","v":13540},{"$f":"IF(O$8=\"\", \"\", IF(OR(O$8=\"Buy Cash\", O$8=\"Buy FUTR\", O$8=\"Sell FUTR\"), (($M22-O$11)*O$10+O29)*(1-STCG),   (1-nTax)*(O$12+O$13+O29+IF(O$8=\"Buy Call\", MAX(O$10*($M22-O$11), 0), IF(O$8=\"Buy Put\", MAX(O$10*(O$11-$M22), 0), IF(O$8=\"Sell Call\", MIN(-O$10*($M22-O$11), 0), IF(O$8=\"Sell Put\", MIN(-O$10*(O$11-$M22), 0))))))))","v":-10140},{"$f":"IF(P$8=\"\", \"\", IF(OR(P$8=\"Buy Cash\", P$8=\"Buy FUTR\", P$8=\"Sell FUTR\"), (($M22-P$11)*P$10+P29)*(1-STCG),   (1-nTax)*(P$12+P$13+P29+IF(P$8=\"Buy Call\", MAX(P$10*($M22-P$11), 0), IF(P$8=\"Buy Put\", MAX(P$10*(P$11-$M22), 0), IF(P$8=\"Sell Call\", MIN(-P$10*($M22-P$11), 0), IF(P$8=\"Sell Put\", MIN(-P$10*(P$11-$M22), 0))))))))","v":""},1470.6360000000004]
[null,null,-9649.251816,2027.9390400000002,"","",null,null,null,null,null,null,-1080.3534,13540,{"$f":"IF(O$8=\"\", \"\", IF(OR(O$8=\"Buy Cash\", O$8=\"Buy FUTR\", O$8=\"Sell FUTR\"), (($M23-O$11)*O$10+O30)*(1-STCG),   (1-nTax)*(O$12+O$13+O30+IF(O$8=\"Buy Call\", MAX(O$10*($M23-O$11), 0), IF(O$8=\"Buy Put\", MAX(O$10*(O$11-$M23), 0), IF(O$8=\"Sell Call\", MIN(-O$10*($M23-O$11), 0), IF(O$8=\"Sell Put\", MIN(-O$10*(O$11-$M23), 0))))))))","v":-7340},"",5119.6466]
[null,"Profit(+)/ Loss(-) ",-4470.2871560000003,2020.8386399999999,"","",null,null,null,null,null,null,-231.34280000000001,13540,-4540,"",8768.6571999999996]
[null,null,708.677504,2013.7382400000001,"","",null,null,null,null,null,null,617.66779999999994,12120,-1740,"",10997.667799999999]
[null,null,5887.6421639999999,2006.6378400000001,"","",null,null,null,null,null,null,1466.6783999999998,8720,1060,"",11246.678400000001]
[null,null,11066.606824,1999.5374400000001,"","",null,null,null,null,null,null,2315.6889999999999,5320,1000,"",8635.6890000000003]
[null,null,16245.571484,-22007.562959999999,"","",null,null,null,null,null,null,3164.6995999999999,{"$f":"IF(N$8=\"\", \"\", IF(OR(N$8=\"Buy Cash\", N$8=\"Buy FUTR\", N$8=\"Sell FUTR\"), (($M28-N$11)*N$10+N35)*(1-STCG),   (1-nTax)*(N$12+N$13+N35+IF(N$8=\"Buy Call\", MAX(N$10*($M28-N$11), 0), IF(N$8=\"Buy Put\", MAX(N$10*(N$11-$M28), 0), IF(N$8=\"Sell Call\", MIN(-N$10*($M28-N$11), 0), IF(N$8=\"Sell Put\", MIN(-N$10*(N$11-$M28), 0))))))))","v":1920},1000,"",6084.6995999999999]
[null,"SPAN Margin@15%",{"$f":"IF(OR(C$8=\"\", C$11=\"\"), \"\", IF(C$8=\"Buy Cash\", C9*$D$7,   IF(OR(C$8=\"Sell Call\", C$8=\"Sell Put\",  C$8=\"Sell FUTR\", C$8=\"Buy FUTR\"), C11*$D$7*0.15, ABS(C12))))","v":633600},{"$f":"IF(OR(D$8=\"\", D$11=\"\"), \"\", IF(D$8=\"Buy Cash\", D9*$D$7,   IF(OR(D$8=\"Sell Call\", D$8=\"Sell Put\",  D$8=\"Sell FUTR\", D$8=\"Buy FUTR\"), D11*$D$7*0.15, ABS(D12))))","v":108000},{"$f":"IF(OR(E$8=\"\", E$11=\"\"), \"\", IF(E$8=\"Buy Cash\", E9*$D$7,   IF(OR(E$8=\"Sell Call\", E$8=\"Sell Put\",  E$8=\"Sell FUTR\", E$8=\"Buy FUTR\"), E11*$D$7*0.15, ABS(E12))))","v":""},{"$f":"IF(OR(F$8=\"\", F$11=\"\"), \"\", IF(F$8=\"Buy Cash\", F9*$D$7,   IF(OR(F$8=\"Sell Call\", F$8=\"Sell Put\",  F$8=\"Sell FUTR\", F$8=\"Buy FUTR\"), F11*$D$7*0.15, ABS(F12))))","v":""},null,null,null,null,null,null,{"$f":"IF(M$8=\"\", \"\", IF(M$8=\"Buy Cash\", M9*$D$7,   IF(OR(M$8=\"Sell Call\", M$8=\"Sell Put\",  M$8=\"Sell FUTR\", M$8=\"Buy FUTR\"), M11*$D$7*0.15, ABS(M$12))))","v":744000},{"$f":"IF(N$8=\"\", \"\", IF(N$8=\"Buy Cash\", N9*$D$7,   IF(OR(N$8=\"Sell Call\", N$8=\"Sell Put\",  N$8=\"Sell FUTR\", N$8=\"Buy FUTR\"), N11*$D$7*0.15, ABS(N$12))))","v":113760},{"$f":"IF(O$8=\"\", \"\", IF(O$8=\"Buy Cash\", O9*$D$7,   IF(OR(O$8=\"Sell Call\", O$8=\"Sell Put\",  O$8=\"Sell FUTR\", O$8=\"Buy FUTR\"), O11*$D$7*0.15, ABS(O$12))))","v":118800},{"$f":"IF(P$8=\"\", \"\", IF(P$8=\"Buy Cash\", P9*$D$7,   IF(OR(P$8=\"Sell Call\", P$8=\"Sell Put\",  P$8=\"Sell FUTR\", P$8=\"Buy FUTR\"), P11*$D$7*0.15,ABS(P$12))))","v":""}]
[null,"Interest p.m. @RFR",{"$f":"IF(OR(C$8=\"\", C$11=\"\"), \"\", C43*RFR/12)","v":3818.4959999999996},{"$f":"IF(OR(D$8=\"\", D$11=\"\"), \"\", D43*RFR/12)","v":650.88},{"$f":"IF(OR(E$8=\"\", E$11=\"\"), \"\", E43*RFR/12)","v":""},{"$f":"IF(OR(F$8=\"\", F$11=\"\"), \"\", F43*RFR/12)","v":""},null,null,null,null,null,null,{"$f":"IF(M$8=\"\", \"\",  M43*RFR/12)","v":4483.8399999999992},{"$f":"IF(N$8=\"\", \"\", N43*RFR/12)","v":685.59360000000004},{"$f":"IF(O$8=\"\", \"\", O43*RFR/12)","v":715.96799999999996},{"$f":"IF(P$8=\"\", \"\", P43*RFR/12)","v":""}]
[null,{"$f":"SUM(C36:F36)","v":-12793.177035999999},{"$f":"SUM(C37:F37)","v":-7621.3127759999998},{"$f":"SUM(C38:F38)","v":-2449.4485160000004},{"$f":"SUM(C39:F39)","v":2722.4157439999999},{"$f":"SUM(C40:F40)","v":7894.2800040000002},{"$f":"SUM(C41:F41)","v":13066.144264},{"$f":"SUM(C42:F42)","v":-5761.9914759999992},null,null,null,null,null,null,null,0.16400000000000001,"Service Tax Rate"]

{"sheet":"NIFTY","index":1,"n_rows":42,"n_cols":18,"rows_kept":42,"cut":false,"hidden":false,"merged":[[18,15,24,17],[1,8,1,11],[18,3,24,7]]}
[]
[null,"Index Options",null,null,null,null,null,null,"Pay-off or \"Profit and Loss\" Table"]
[null,"Cahs flow:","NIFTY50","Lot Size",null,null,"Strike X",2,null,null,null,null,null,null,"NIFTY50","Lot Size","Strike X",2]
[null,{"$f":"-75*(127+262)","v":-29175},null,{"$f":"IF(C3=\"BANKNIFTY\", 30, 75)","v":75},null,null,"Strike Interval",{"$f":"IF(C3=\"NIFTY50\", 50, 100)","v":50},null,null,null,null,null,null,null,{"$f":"IF(O3=\"BANKNIFTY\", 30, 75)","v":75},"Strike Interval",{"$f":"IF(O3=\"BANKNIFTY\", 100, 50)","v":50}]
[null,{"$f":"SUM(C9:H9)","v":27150},"Sell Call","Sell Put","Buy Put",null,null,null,null,null,null,null,null,null,"Sell Call","Sell Call"]
[null,"CMP",9750,{"$f":"IF(D5=\"\", \"\", $C$6)","v":9750},{"$f":"IF(E5=\"\", \"\", $C$6)","v":9750},{"$f":"IF(F5=\"\", \"\", $C$6)","v":""},"",{"$f":"IF(H5=\"\", \"\", $C$6)","v":""},null,null,null,null,null,null,9750,{"$f":"IF(P5=\"\", \"\", $O$6)","v":9750},{"$f":"IF(Q5=\"\", \"\", $O$6)","v":""},""]
[null,"Trade Quantity",75,75,75,null,null,null,null,null,null,null,null,null,75,75]
[null,"Strike/ Buy Price",9600,9900,9600,null,null,null,null,null,null,null,null,null,9600,9900]
[null,"Premium of 1st Leg",{"$f":"225*C7","v":16875},{"$f":"219*D7","v":16425},{"$f":"-82*E7","v":-6150},null,null,null,null,null,null,null,null,null,{"$f":"240*75","v":18000},{"$f":"75*P7","v":5625}]
[null,"Square-off Premium",0,0,0,null,null,null,null,null,null,null,null,null,0,0]
[null,"Implied or Hist. Vol.",0.11,{"$f":"IF(D$5=\"\", \"\", $C11)","v":0.11},{"$f":"IF(E$5=\"\", \"\", $C11)","v":0.11},"","","",null,null,null,null,null,null,{"$f":"IF(O$5=\"\", \"\", $C11)","v":0.11},{"$f":"IF(P$5=\"\", \"\", $C11)","v":0.11},{"$f":"IF(Q$5=\"\", \"\", $C11)","v":""},""]
[null,"Dividend Yield",0,null,"IR on Margin:",0.18,"SPAN",0.05]
[null,"Risk-Reward Ratio",{"$f":"IF(ABS(MIN(B42:H42))=0, \"\", MAX(B42:H42)/ABS(MIN(B42:H42)))","v":0.65929203539823011},"@probability",null,{"$f":"ABS(SUM(C16:H16))","v":7.1275999999999978E-2},null,null,null,{"$f":"36.72*5","v":183.6},null,null,null,null,{"$f":"IF(ABS(MIN(L42:R42))=0, \"\", MAX(L42:R42)/ABS(MIN(L42:R42)))","v":1.087439278278973},"@probability",null,{"$f":"ABS(SUM(O16:R16))","v":1.0185819999999999}]
[null,"Theoretical Premium",{"$f":"IF(OR(C$5=\"\", C$8=\"\"),\"\", IF(OR(C$5=\"Buy Call\", C$5=\"Sell Call\"), premCall(C$6, C8, t, RFR, C$11, DYU), IF(OR(C$5=\"Buy Put\", C$5=\"Sell Put\"), premPut(C$6, C8, t, RFR, C$11, DYU), IF(OR(C$5=\"Buy Cash\", C$5=\"Buy FUTR\"), 0, 0))))","v":157.87190000000001},{"$f":"IF(OR(D$5=\"\", D$8=\"\"),\"\", IF(OR(D$5=\"Buy Call\", D$5=\"Sell Call\"), premCall(D$6, D8, t, RFR, D$11, DYU), IF(OR(D$5=\"Buy Put\", D$5=\"Sell Put\"), premPut(D$6, D8, t, RFR, D$11, DYU), IF(OR(D$5=\"Buy Cash\", D$5=\"Buy FUTR\"), 0, 0))))","v":147.18100000000001},{"$f":"IF(OR(E$5=\"\", E$8=\"\"),\"\", IF(OR(E$5=\"Buy Call\", E$5=\"Sell Call\"), premCall(E$6, E8, t, RFR, E$11, DYU), IF(OR(E$5=\"Buy Put\", E$5=\"Sell Put\"), premPut(E$6, E8, t, RFR, E$11, DYU), IF(OR(E$5=\"Buy Cash\", E$5=\"Buy FUTR\"), 0, 0))))","v":2.1680000000000001},{"$f":"IF(OR(F$5=\"\", F$8=\"\"),\"\", IF(OR(F$5=\"Buy Call\", F$5=\"Sell Call\"), premCall(F$6, F8, t, RFR, F$11, DYU), IF(OR(F$5=\"Buy Put\", F$5=\"Sell Put\"), premPut(F$6, F8, t, RFR, F$11, DYU), IF(OR(F$5=\"Buy Cash\", F$5=\"Buy FUTR\"), 0, 0))))","v":""},{"$f":"IF(OR(G$5=\"\", G$8=\"\"),\"\", IF(OR(G$5=\"Buy Call\", G$5=\"Sell Call\"), premCall(G$6, G8, t, RFR, G$11, DYU), IF(OR(G$5=\"Buy Put\", G$5=\"Sell Put\"), premPut(G$6, G8, t, RFR, G$11, DYU), IF(OR(G$5=\"Buy Cash\", G$5=\"Buy FUTR\"), 0, 0))))","v":""},{"$f":"IF(OR(H$5=\"\", H$8=\"\"),\"\", IF(OR(H$5=\"Buy Call\", H$5=\"Sell Call\"), premCall(H$6, H8, t, RFR, H$11, DYU), IF(OR(H$5=\"Buy Put\", H$5=\"Sell Put\"), premPut(H$6, H8, t, RFR, H$11, DYU), IF(OR(H$5=\"Buy Cash\", H$5=\"Buy FUTR\"), 0, 0))))","v":""},null,null,null,null,null,null,{"$f":"IF(OR(O$5=\"\", O$8=\"\"),\"\", IF(OR(O$5=\"Buy Call\", O$5=\"Sell Call\"), premCall(O$6, O8, t, RFR, O$11, DYY), IF(OR(O$5=\"Buy Put\", O$5=\"Sell Put\"), premPut(O$6, O8, t, RFR, O$11, DYY), IF(OR(O$5=\"Buy Cash\", O$5=\"Buy FUTR\"), 0, 0))))","v":157.87190000000001},{"$f":"IF(OR(P$5=\"\", P$8=\"\"),\"\", IF(OR(P$5=\"Buy Call\", P$5=\"Sell Call\"), premCall(P$6, P8, t, RFR, P$11, DYY), IF(OR(P$5=\"Buy Put\", P$5=\"Sell Put\"), premPut(P$6, P8, t, RFR, P$11, DYY), IF(OR(P$5=\"Buy Cash\", P$5=\"Buy FUTR\"), 0, 0))))","v":3.0632999999999999},{"$f":"IF(OR(Q$5=\"\", Q$8=\"\"),\"\", IF(OR(Q$5=\"Buy Call\", Q$5=\"Sell Call\"), premCall(Q$6, Q8, t, RFR, Q$11, DYY), IF(OR(Q$5=\"Buy Put\", Q$5=\"Sell Put\"), premPut(Q$6, Q8, t, RFR, Q$11, DYY), IF(OR(Q$5=\"Buy Cash\", Q$5=\"Buy FUTR\"), 0, 0))))","v":""},{"$f":"IF(OR(R$5=\"\", R$8=\"\"),\"\", IF(OR(R$5=\"Buy Call\", R$5=\"Sell Call\"), premCall(R$6, R8, t, RFR, R$11, DYY), IF(OR(R$5=\"Buy Put\", R$5=\"Sell Put\"), premPut(R$6, R8, t, RFR, R$11, DYY), IF(OR(R$5=\"Buy Cash\", R$5=\"Buy FUTR\"), 0, 0))))","v":""}]
[null,{"$f":"\"Theta=  \" & TEXT(ROUND(SUM(C15:H15), 4), \"0.000\")","v":"Theta=  2.284"},{"$f":"IF(OR(C$5=\"\", C$8=\"\"), \"\", IF(C$5=\"Buy Call\", calltheta(C$6,C$8,t,RFR,C$11,DYU), IF(C$5=\"Sell Call\",-calltheta(C$6,C$8,t, RFR,C$11,DYX), IF(C$5=\"Buy Put\",PutTheta(C$6,C$8,t,RFR,C$11,DYU), IF(C$5=\"Sell Put\", -PutTheta(C$6,C$8,t,RFR,C$11,DYU), 0)))))","v":3.5413600000000001},{"$f":"IF(OR(D$5=\"\", D$8=\"\"), \"\", IF(D$5=\"Buy Call\", calltheta(D$6,D$8,t,RFR,D$11,DYU), IF(D$5=\"Sell Call\",-calltheta(D$6,D$8,t, RFR,D$11,DYX), IF(D$5=\"Buy Put\",PutTheta(D$6,D$8,t,RFR,D$11,DYU), IF(D$5=\"Sell Put\", -PutTheta(D$6,D$8,t,RFR,D$11,DYU), 0)))))","v":0.38298199999999999},{"$f":"IF(OR(E$5=\"\", E$8=\"\"), \"\", IF(E$5=\"Buy Call\", calltheta(E$6,E$8,t,RFR,E$11,DYU), IF(E$5=\"Sell Call\",-calltheta(E$6,E$8,t, RFR,E$11,DYX), IF(E$5=\"Buy Put\",PutTheta(E$6,E$8,t,RFR,E$11,DYU), IF(E$5=\"Sell Put\", -PutTheta(E$6,E$8,t,RFR,E$11,DYU), 0)))))","v":-1.6403760000000001},{"$f":"IF(OR(F$5=\"\", F$8=\"\"), \"\", IF(F$5=\"Buy Call\", calltheta(F$6,F$8,t,RFR,F$11,DYU), IF(F$5=\"Sell Call\",-calltheta(F$6,F$8,t, RFR,F$11,DYX), IF(F$5=\"Buy Put\",PutTheta(F$6,F$8,t,RFR,F$11,DYU), IF(F$5=\"Sell Put\", -PutTheta(F$6,F$8,t,RFR,F$11,DYU), 0)))))","v":""},{"$f":"IF(OR(G$5=\"\", G$8=\"\"), \"\", IF(G$5=\"Buy Call\", calltheta(G$6,G$8,t,RFR,G$11,DYU), IF(G$5=\"Sell Call\",-calltheta(G$6,G$8,t, RFR,G$11,DYX), IF(G$5=\"Buy Put\",PutTheta(G$6,G$8,t,RFR,G$11,DYU), IF(G$5=\"Sell Put\", -PutTheta(G$6,G$8,t,RFR,G$11,DYU), 0)))))","v":""},{"$f":"IF(OR(H$5=\"\", H$8=\"\"), \"\", IF(H$5=\"Buy Call\", calltheta(H$6,H$8,t,RFR,H$11,DYU), IF(H$5=\"Sell Call\",-calltheta(H$6,H$8,t, RFR,H$11,DYX), IF(H$5=\"Buy Put\",PutTheta(H$6,H$8,t,RFR,H$11,DYU), IF(H$5=\"Sell Put\", -PutTheta(H$6,H$8,t,RFR,H$11,DYU), 0)))))","v":""},null,null,null,null,null,null,{"$f":"IF(OR(O$5=\"\", O$8=\"\"), \"\", IF(O$5=\"Buy Call\", calltheta(O$6,O$8,t,RFR,O$11,DYV), IF(O$5=\"Sell Call\",-calltheta(O$6,O$8,t, RFR,O$11,DYV), IF(O$5=\"Buy Put\",PutTheta(O$6,O$8,t,RFR,O$11,DYV), IF(O$5=\"Sell Put\", -PutTheta(O$6,O$8,t,RFR,O$11,DYV), 0)))))","v":3.5413600000000001},{"$f":"IF(OR(P$5=\"\", P$8=\"\"), \"\", IF(P$5=\"Buy Call\", calltheta(P$6,P$8,t,RFR,P$11,DYV), IF(P$5=\"Sell Call\",-calltheta(P$6,P$8,t, RFR,P$11,DYV), IF(P$5=\"Buy Put\",PutTheta(P$6,P$8,t,RFR,P$11,DYV), IF(P$5=\"Sell Put\", -PutTheta(P$6,P$8,t,RFR,P$11,DYV), 0)))))","v":2.3433730000000002},{"$f":"IF(OR(Q$5=\"\", Q$8=\"\"), \"\", IF(Q$5=\"Buy Call\", calltheta(Q$6,Q$8,t,RFR,Q$11,DYV), IF(Q$5=\"Sell Call\",-calltheta(Q$6,Q$8,t, RFR,Q$11,DYV), IF(Q$5=\"Buy Put\",PutTheta(Q$6,Q$8,t,RFR,Q$11,DYV), IF(Q$5=\"Sell Put\", -PutTheta(Q$6,Q$8,t,RFR,Q$11,DYV), 0)))))","v":""},{"$f":"IF(OR(R$5=\"\", R$8=\"\"), \"\", IF(R$5=\"Buy Call\", calltheta(R$6,R$8,t,RFR,R$11,DYV), IF(R$5=\"Sell Call\",-calltheta(R$6,R$8,t, RFR,R$11,DYV), IF(R$5=\"Buy Put\",PutTheta(R$6,R$8,t,RFR,R$11,DYV), IF(R$5=\"Sell Put\", -PutTheta(R$6,R$8,t,RFR,R$11,DYV), 0)))))","v":""}]
[null,{"$f":"\"Delta = \" & TEXT(ROUND(SUM(C16:H16), 4), \"0.000\")","v":"Delta = -0.071"},{"$f":"IF(OR(C$5=\"\", C$8=\"\"), \"\", IF(C$5=\"Buy Call\",  CallDelta(C$6, C$8, t, RFR, C$11, DYU), IF(C$5=\"Sell Call\", -CallDelta(C$6, C$8,t,RFR, C$11, DYU), IF(C$5=\"Buy Put\", Putdelta(C$6, C$8, t, RFR, C$11, DYU), IF(C$5=\"Sell Put\", -Putdelta(C$6, C$8, t, RFR, C$11, DYU), IF(OR(C$5=\"Buy Cash\", C$5=\"Buy FUTR\"), 1*C7/$D$4, -1*C7/$D$4))))))","v":-0.94730599999999998},{"$f":"IF(OR(D$5=\"\", D$8=\"\"), \"\", IF(D$5=\"Buy Call\",  CallDelta(D$6, D$8, t, RFR, D$11, DYU), IF(D$5=\"Sell Call\", -CallDelta(D$6, D$8,t,RFR, D$11, DYU), IF(D$5=\"Buy Put\", Putdelta(D$6, D$8, t, RFR, D$11, DYU), IF(D$5=\"Sell Put\", -Putdelta(D$6, D$8, t, RFR, D$11, DYU), IF(OR(D$5=\"Buy Cash\", D$5=\"Buy FUTR\"), 1*D7/$D$4, -1*D7/$D$4))))))","v":0.92872399999999999},{"$f":"IF(OR(E$5=\"\", E$8=\"\"), \"\", IF(E$5=\"Buy Call\",  CallDelta(E$6, E$8, t, RFR, E$11, DYU), IF(E$5=\"Sell Call\", -CallDelta(E$6, E$8,t,RFR, E$11, DYU), IF(E$5=\"Buy Put\", Putdelta(E$6, E$8, t, RFR, E$11, DYU), IF(E$5=\"Sell Put\", -Putdelta(E$6, E$8, t, RFR, E$11, DYU), IF(OR(E$5=\"Buy Cash\", E$5=\"Buy FUTR\"), 1*E7/$D$4, -1*E7/$D$4))))))","v":-5.2693999999999998E-2},{"$f":"IF(OR(F$5=\"\", F$8=\"\"), \"\", IF(F$5=\"Buy Call\",  CallDelta(F$6, F$8, t, RFR, F$11, DYU), IF(F$5=\"Sell Call\", -CallDelta(F$6, F$8,t,RFR, F$11, DYU), IF(F$5=\"Buy Put\", Putdelta(F$6, F$8, t, RFR, F$11, DYU), IF(F$5=\"Sell Put\", -Putdelta(F$6, F$8, t, RFR, F$11, DYU), IF(OR(F$5=\"Buy Cash\", F$5=\"Buy FUTR\"), 1*F7/$D$4, -1*F7/$D$4))))))","v":""},{"$f":"IF(OR(G$5=\"\", G$8=\"\"), \"\", IF(G$5=\"Buy Call\",  CallDelta(G$6, G$8, t, RFR, G$11, DYU), IF(G$5=\"Sell Call\", -CallDelta(G$6, G$8,t,RFR, G$11, DYU), IF(G$5=\"Buy Put\", Putdelta(G$6, G$8, t, RFR, G$11, DYU), IF(G$5=\"Sell Put\", -Putdelta(G$6, G$8, t, RFR, G$11, DYU), IF(OR(G$5=\"Buy Cash\", G$5=\"Buy FUTR\"), 1*G7/$D$4, -1*G7/$D$4))))))","v":""},{"$f":"IF(OR(H$5=\"\", H$8=\"\"), \"\", IF(H$5=\"Buy Call\",  CallDelta(H$6, H$8, t, RFR, H$11, DYU), IF(H$5=\"Sell Call\", -CallDelta(H$6, H$8,t,RFR, H$11, DYU), IF(H$5=\"Buy Put\", Putdelta(H$6, H$8, t, RFR, H$11, DYU), IF(H$5=\"Sell Put\", -Putdelta(H$6, H$8, t, RFR, H$11, DYU), IF(OR(H$5=\"Buy Cash\", H$5=\"Buy FUTR\"), 1*H7/$D$4, -1*H7/$D$4))))))","v":""},null,null,null,null,null,null,{"$f":"IF(OR(O$5=\"\", O$8=\"\"), \"\", IF(O$5=\"Buy Call\",  CallDelta(O$6, O$8, t, RFR, O$11, DYV), IF(O$5=\"Sell Call\", -CallDelta(O$6, O$8,t,RFR, O$11, DYV), IF(O$5=\"Buy Put\", Putdelta(O$6, O$8, t, RFR, O$11, DYV), IF(O$5=\"Sell Put\", -Putdelta(O$6, O$8, t, RFR, O$11, DYV), IF(OR(O$5=\"Buy Cash\", O$5=\"Buy FUTR\"), 1*O7/P$4, -1*O7/P$4))))))","v":-0.94730599999999998},{"$f":"IF(OR(P$5=\"\", P$8=\"\"), \"\", IF(P$5=\"Buy Call\",  CallDelta(P$6, P$8, t, RFR, P$11, DYV), IF(P$5=\"Sell Call\", -CallDelta(P$6, P$8,t,RFR, P$11, DYV), IF(P$5=\"Buy Put\", Putdelta(P$6, P$8, t, RFR, P$11, DYV), IF(P$5=\"Sell Put\", -Putdelta(P$6, P$8, t, RFR, P$11, DYV), IF(OR(P$5=\"Buy Cash\", P$5=\"Buy FUTR\"), 1*P7/Q$4, -1*P7/Q$4))))))","v":-7.1276000000000006E-2},{"$f":"IF(OR(Q$5=\"\", Q$8=\"\"), \"\", IF(Q$5=\"Buy Call\",  CallDelta(Q$6, Q$8, t, RFR, Q$11, DYV), IF(Q$5=\"Sell Call\", -CallDelta(Q$6, Q$8,t,RFR, Q$11, DYV), IF(Q$5=\"Buy Put\", Putdelta(Q$6, Q$8, t, RFR, Q$11, DYV), IF(Q$5=\"Sell Put\", -Putdelta(Q$6, Q$8, t, RFR, Q$11, DYV), IF(OR(Q$5=\"Buy Cash\", Q$5=\"Buy FUTR\"), 1*Q7/R$4, -1*Q7/R$4))))))","v":""},{"$f":"IF(OR(R$5=\"\", R$8=\"\"), \"\", IF(R$5=\"Buy Call\",  CallDelta(R$6, R$8, t, RFR, R$11, DYV), IF(R$5=\"Sell Call\", -CallDelta(R$6, R$8,t,RFR, R$11, DYV), IF(R$5=\"Buy Put\", Putdelta(R$6, R$8, t, RFR, R$11, DYV), IF(R$5=\"Sell Put\", -Putdelta(R$6, R$8, t, RFR, R$11, DYV), IF(OR(R$5=\"Buy Cash\", R$5=\"Buy FUTR\"), 1*R7/S$4, -1*R7/S$4))))))","v":""}]
[null,{"$f":"\"Vega =  \" & TEXT(ROUND(SUM(C17:H17),4), \"0.000\")","v":"Vega =  3.104"},{"$f":"IF(OR(C$5=\"\", C$8=\"\"), \"\", IF(OR(C$5=\"Buy Call\",C$5=\"Sell Call\",C$5=\"Buy Put\",C$5=\"Sell Put\"),Vega(C$6,C8,t,RFR,C$11,DYU),IF(OR(C$5=\"Buy Cash\",C$5=\"Buy FUTR\"),0)))","v":0.95050999999999997},{"$f":"IF(OR(D$5=\"\", D$8=\"\"), \"\", IF(OR(D$5=\"Buy Call\",D$5=\"Sell Call\",D$5=\"Buy Put\",D$5=\"Sell Put\"),Vega(D$6,D8,t,RFR,D$11,DYU),IF(OR(D$5=\"Buy Cash\",D$5=\"Buy FUTR\"),0)))","v":1.2034290000000001},{"$f":"IF(OR(E$5=\"\", E$8=\"\"), \"\", IF(OR(E$5=\"Buy Call\",E$5=\"Sell Call\",E$5=\"Buy Put\",E$5=\"Sell Put\"),Vega(E$6,E8,t,RFR,E$11,DYU),IF(OR(E$5=\"Buy Cash\",E$5=\"Buy FUTR\"),0)))","v":0.95050999999999997},{"$f":"IF(OR(F$5=\"\", F$8=\"\"), \"\", IF(OR(F$5=\"Buy Call\",F$5=\"Sell Call\",F$5=\"Buy Put\",F$5=\"Sell Put\"),Vega(F$6,F8,t,RFR,F$11,DYU),IF(OR(F$5=\"Buy Cash\",F$5=\"Buy FUTR\"),0)))","v":""},{"$f":"IF(OR(G$5=\"\", G$8=\"\"), \"\", IF(OR(G$5=\"Buy Call\",G$5=\"Sell Call\",G$5=\"Buy Put\",G$5=\"Sell Put\"),Vega(G$6,G8,t,RFR,G$11,DYU),IF(OR(G$5=\"Buy Cash\",G$5=\"Buy FUTR\"),0)))","v":""},{"$f":"IF(OR(H$5=\"\", H$8=\"\"), \"\", IF(OR(H$5=\"Buy Call\",H$5=\"Sell Call\",H$5=\"Buy Put\",H$5=\"Sell Put\"),Vega(H$6,H8,t,RFR,H$11,DYU),IF(OR(H$5=\"Buy Cash\",H$5=\"Buy FUTR\"),0)))","v":""},null,null,null,null,null,null,{"$f":"IF(OR(O$5=\"\", O$8=\"\"), \"\", IF(OR(O$5=\"Buy Call\",O$5=\"Sell Call\",O$5=\"Buy Put\",O$5=\"Sell Put\"),Vega(O$6,O8,t,RFR,O$11,DYV),IF(OR(O$5=\"Buy Cash\",O$5=\"Buy FUTR\"),0)))","v":0.95050999999999997},{"$f":"IF(OR(P$5=\"\", P$8=\"\"), \"\", IF(OR(P$5=\"Buy Call\",P$5=\"Sell Call\",P$5=\"Buy Put\",P$5=\"Sell Put\"),Vega(P$6,P8,t,RFR,P$11,DYV),IF(OR(P$5=\"Buy Cash\",P$5=\"Buy FUTR\"),0)))","v":1.2034290000000001},{"$f":"IF(OR(Q$5=\"\", Q$8=\"\"), \"\", IF(OR(Q$5=\"Buy Call\",Q$5=\"Sell Call\",Q$5=\"Buy Put\",Q$5=\"Sell Put\"),Vega(Q$6,Q8,t,RFR,Q$11,DYV),IF(OR(Q$5=\"Buy Cash\",Q$5=\"Buy FUTR\"),0)))","v":""},{"$f":"IF(OR(R$5=\"\", R$8=\"\"), \"\", IF(OR(R$5=\"Buy Call\",R$5=\"Sell Call\",R$5=\"Buy Put\",R$5=\"Sell Put\"),Vega(R$6,R8,t,RFR,R$11,DYV),IF(OR(R$5=\"Buy Cash\",R$5=\"Buy FUTR\"),0)))","v":""}]
[null,{"$f":"\"Gamma =  \"  & TEXT(ROUND(SUM(C18:H18),4), \"0.000\")","v":"Gamma =  0.004"},{"$f":"IF(OR(C$5=\"\", C$8=\"\"), \"\", IF(C5=\"Buy Cash\", 0, Gamma(C$6, C8, t, RFR, C$11, DYU)))","v":1.106E-3},{"$f":"IF(OR(D$5=\"\", D$8=\"\"), \"\", IF(D5=\"Buy Cash\", 0, Gamma(D$6, D8, t, RFR, D$11, DYU)))","v":1.4E-3},{"$f":"IF(OR(E$5=\"\", E$8=\"\"), \"\", IF(E5=\"Buy Cash\", 0, Gamma(E$6, E8, t, RFR, E$11, DYU)))","v":1.106E-3},{"$f":"IF(OR(F$5=\"\", F$8=\"\"), \"\", IF(F5=\"Buy Cash\", 0, Gamma(F$6, F8, t, RFR, F$11, DYU)))","v":""},{"$f":"IF(OR(G$5=\"\", G$8=\"\"), \"\", IF(G5=\"Buy Cash\", 0, Gamma(G$6, G8, t, RFR, G$11, DYU)))","v":""},{"$f":"IF(OR(H$5=\"\", H$8=\"\"), \"\", IF(H5=\"Buy Cash\", 0, Gamma(H$6, H8, t, RFR, H$11, DYU)))","v":""},null,null,null,null,null,null,{"$f":"IF(OR(O$5=\"\", O$8=\"\"), \"\", IF(O5=\"Buy Cash\", 0, Gamma(O$6, O8, t, RFR, O$11, DYV)))","v":1.106E-3},{"$f":"IF(OR(P$5=\"\", P$8=\"\"), \"\", IF(P5=\"Buy Cash\", 0, Gamma(P$6, P8, t, RFR, P$11, DYV)))","v":1.4E-3},{"$f":"IF(OR(Q$5=\"\", Q$8=\"\"), \"\", IF(Q5=\"Buy Cash\", 0, Gamma(Q$6, Q8, t, RFR, Q$11, DYV)))","v":""},{"$f":"IF(OR(R$5=\"\", R$8=\"\"), \"\", IF(R5=\"Buy Cash\", 0, Gamma(R$6, R8, t, RFR, R$11, DYV)))","v":""}]
[null,"Spot Price at Sqr-Off",{"$f":"IF(C$5=\"\", \"\", C20-H4*H3)","v":9450},null,null,null,null,null,null,null,null,{"$f":"SUM(O26:R26)","v":-120},null,null,{"$f":"IF(O$5=\"\", \"\", O20-R4*R3)","v":9450}]
[null,null,{"$f":"IF(C$5=\"\", \"\", C21-H$4*H3)","v":9550},null,null,null,null,null,null,null,null,-120,null,null,{"$f":"IF(O$5=\"\", \"\", O21-R$4*R3)","v":9550}]
[null,null,{"$f":"IF(C$5=\"\", \"\", C22-H$4*H3)","v":9650},null,null,null,null,null,null,null,null,-180,null,null,{"$f":"IF(O$5=\"\", \"\", O22-R$4*R3)","v":9650}]
[null,null,{"$f":" IF(C$5=\"\", \"\", ROUND(C6/H4,0)*H4)","v":9750},null,null,null,null,null,null,null,null,-180,null,null,{"$f":" IF(O$5=\"\", \"\", ROUND(O6/R4,0)*R4)","v":9750}]
[null,null,{"$f":"IF(C$5=\"\", \"\", C22+H$4*H3)","v":9850},null,null,null,null,null,null,null,null,-180,null,null,{"$f":"IF(O$5=\"\", \"\", O22+R$4*R3)","v":9850}]
[null,null,{"$f":"IF(C$5=\"\", \"\", C23+H$4*H3)","v":9950},null,null,null,null,null,null,null,null,-240,null,null,{"$f":"IF(O$5=\"\", \"\", O23+R$4*R3)","v":9950}]
[null,null,{"$f":"IF(C$5=\"\", \"\", C24+H$4*H3)","v":10050},null,null,null,null,null,null,null,null,{"$f":"SUM(O32:R32)","v":-240},null,null,{"$f":"IF(O$5=\"\", \"\", O24+R$4*R3)","v":10050}]
[null,null,{"$f":"IF(OR(C$5=\"\",C$8=\"\"),\"\",IF(C$5=\"Buy Cash\",-(C$6*C$7*BrkgCASH*(1+sTax))-($C19*C$7*BrkgCASH*(1+sTax)),IF(C10=0,-BrkgOPTN*1.2,-2*BrkgOPTN*1.2)))","v":-60},{"$f":"IF(OR(D$5=\"\", D$8=\"\"), \"\", IF(D$5=\"Buy Cash\", 0-(D$6*D$7*BrkgCASH*(1+sTax))-($C19*D$7*BrkgCASH*(1+sTax)),  0-IF($C19>D$8,2*BrkgOPTN*1.2,BrkgOPTN*1.2)))","v":-60},{"$f":"IF(OR(E$5=\"\", E$8=\"\"), \"\", IF(E$5=\"Buy Cash\", 0-(E$6*E$7*BrkgCASH*(1+sTax))-($C19*E$7*BrkgCASH*(1+sTax)),  0-IF($C19>E$8,2*BrkgOPTN*1.2,BrkgOPTN*1.2)))","v":-60},"","","",null,null,null,null,null,null,{"$f":"IF(OR(O$5=\"\", O$8=\"\"), \"\", IF(O$5=\"Buy Cash\", 0-(O$6*O$7*BrkgCASH*(1+sTax))-($O19*O$7*BrkgCASH*(1+sTax)),  0-IF($O19>O$8,2*BrkgOPTN*1.2,BrkgOPTN*1.2)))","v":-60},{"$f":"IF(OR(P$5=\"\", P$8=\"\"), \"\", IF(P$5=\"Buy Cash\", 0-(P$6*P$7*BrkgCASH*(1+sTax))-($C19*P$7*BrkgCASH*(1+sTax)),  0-IF($C19>P$8,2*BrkgOPTN*1.2,BrkgOPTN*1.2)))","v":-60},"",""]
[null,null,{"$f":"IF(OR(C$5=\"\", C$8=\"\"), \"\", IF(C$5=\"Buy Cash\", 0-(C$6*C$7*BrkgCASH*(1+sTax))-($C20*C$7*BrkgCASH*(1+sTax)),  IF(C10=0, -BrkgOPTN*1.2, -2*BrkgOPTN*1.2)))","v":-60},-60,{"$f":"IF(OR(E$5=\"\", E$8=\"\"), \"\", IF(E$5=\"Buy Cash\", 0-(E$6*E$7*BrkgCASH*(1+sTax))-($C20*E$7*BrkgCASH*(1+sTax)),  0-IF($C20>E$8,2*BrkgOPTN*1.2,BrkgOPTN*1.2)))","v":-60},"","","",null,null,null,null,null,null,-60,-60,"",""]
[null,"Brokerage",{"$f":"IF(OR(C$5=\"\", C$8=\"\"), \"\", IF(C$5=\"Buy Cash\", 0-(C$6*C$7*BrkgCASH*(1+sTax))-($C21*C$7*BrkgCASH*(1+sTax)),  IF(C10=0, -BrkgOPTN*1.2, 2*BrkgOPTN*1.2)))","v":-60},-60,{"$f":"IF(OR(E$5=\"\", E$8=\"\"), \"\", IF(E$5=\"Buy Cash\", 0-(E$6*E$7*BrkgCASH*(1+sTax))-($C21*E$7*BrkgCASH*(1+sTax)),  0-IF($C21>E$8,2*BrkgOPTN*1.2,BrkgOPTN*1.2)))","v":-120},"","","",null,null,null,null,null,null,-120,-60,"",""]
[null,null,{"$f":"IF(OR(C$5=\"\", C$8=\"\"), \"\", IF(C$5=\"Buy Cash\", -(C$6*C$7*BrkgCASH*(1+sTax))-($C22*C$7*BrkgCASH*(1+sTax)),  IF(C10=0, -BrkgOPTN*1.2, -2*BrkgOPTN*1.2)))","v":-60},-60,{"$f":"IF(OR(E$5=\"\", E$8=\"\"), \"\", IF(E$5=\"Buy Cash\", 0-(E$6*E$7*BrkgCASH*(1+sTax))-($C22*E$7*BrkgCASH*(1+sTax)),  0-IF($C22>E$8,2*BrkgOPTN*1.2,BrkgOPTN*1.2)))","v":-120},"","","",null,null,null,null,null,null,-120,-60,"",""]
[null,null,{"$f":"IF(OR(C$5=\"\", C$8=\"\"), \"\", IF(C$5=\"Buy Cash\", 0-(C$6*C$7*BrkgCASH*(1+sTax))-($C23*C$7*BrkgCASH*(1+sTax)),  IF(C10=0, -BrkgOPTN*1.2, -2*BrkgOPTN*1.2)))","v":-60},-60,{"$f":"IF(OR(E$5=\"\", E$8=\"\"), \"\", IF(E$5=\"Buy Cash\", 0-(E$6*E$7*BrkgCASH*(1+sTax))-($C23*E$7*BrkgCASH*(1+sTax)),  0-IF($C23>E$8,2*BrkgOPTN*1.2,BrkgOPTN*1.2)))","v":-120},"","","",null,"SYMBOL","%","QTY","Hold Price",null,-120,-60,"",""]
[null,null,{"$f":"IF(OR(C$5=\"\", C$8=\"\"), \"\", IF(C$5=\"Buy Cash\", 0-(C$6*C$7*BrkgCASH*(1+sTax))-($C24*C$7*BrkgCASH*(1+sTax)),  IF(C10=0, -BrkgOPTN*1.2, -2*BrkgOPTN*1.2)))","v":-60},-120,{"$f":"IF(OR(E$5=\"\", E$8=\"\"), \"\", IF(E$5=\"Buy Cash\", 0-(E$6*E$7*BrkgCASH*(1+sTax))-($C24*E$7*BrkgCASH*(1+sTax)),  0-IF($C24>E$8,2*BrkgOPTN*1.2,BrkgOPTN*1.2)))","v":-120},"","","",null,"HDFCBANK",9.64,10,null,null,-120,-120,"",{"$f":"IF(OR(R$5=\"\", R$8=\"\"), \"\", IF(R$5=\"Buy Cash\", 0-(R$6*R$7*BrkgCASH*(1+sTax))-($C24*R$7*BrkgCASH*(1+sTax)),  0-IF($C24>R$8,2*BrkgOPTN*1.2,BrkgOPTN*1.2)))","v":""}]
[null,null,{"$f":"IF(OR(C$5=\"\", C$8=\"\"), \"\", IF(C$5=\"Buy Cash\", 0-(C$6*C$7*BrkgCASH*(1+sTax))-($C25*C$7*BrkgCASH*(1+sTax)),  IF(C10=0, -BrkgOPTN*1.2, -2*BrkgOPTN*1.2)))","v":-60},-120,{"$f":"IF(OR(E$5=\"\", E$8=\"\"), \"\", IF(E$5=\"Buy Cash\", 0-(E$6*E$7*BrkgCASH*(1+sTax))-($C25*E$7*BrkgCASH*(1+sTax)),  0-IF($C25>E$8,2*BrkgOPTN*1.2,BrkgOPTN*1.2)))","v":-120},"","","",null,"HDFC",7.53,0,null,null,-120,-120,"",""]
[null,null,{"$f":"IF(OR(C$5=\"\", C$8=\"\"), \"\", IF(OR(C$5=\"Buy Cash\", C$5=\"Buy FUTR\", C$5=\"Sell FUTR\"), (($C19-C$8)*C$7+$C26)*(1-STCG),   (1-nTax)*(C$9+C$10+$C26+IF(C$5=\"Buy Call\", MAX(C$7*($C19-C$8), 0), IF(C$5=\"Buy Put\", MAX(C$7*(C$8-$C19), 0), IF(C$5=\"Sell Call\", MIN(-C$7*($C19-C$8), 0), IF(C$5=\"Sell Put\", MIN(-C$7*(C$8-$C19), 0))))))))","v":16815},-17385,{"$f":"IF(OR(E$5=\"\", E$8=\"\"), \"\", IF(OR(E$5=\"Buy Cash\", E$5=\"Buy FUTR\", E$5=\"Sell FUTR\"), (($C19-E$8)*E$7+$C26)*(1-STCG),   (1-nTax)*(E$9+E$10+$C26+IF(E$5=\"Buy Call\", MAX(E$7*($C19-E$8), 0), IF(E$5=\"Buy Put\", MAX(E$7*(E$8-$C19), 0), IF(E$5=\"Sell Call\", MIN(-E$7*($C19-E$8), 0), IF(E$5=\"Sell Put\", MIN(-E$7*(E$8-$C19), 0))))))))","v":5040},"","","",null,"RELIANCE",7.21,70,null,null,{"$f":"IF(OR(O$5=\"\", O$8=\"\"), \"\", IF(OR(O$5=\"Buy Cash\", O$5=\"Buy FUTR\", O$5=\"Sell FUTR\"), (($C19-O$8)*O$7+$O26)*(1-STCG),   (1-nTax)*(O$9+O$10+$O26+IF(O$5=\"Buy Call\", MAX(O$7*($C19-O$8), 0), IF(O$5=\"Buy Put\", MAX(O$7*(O$8-$O19), 0), IF(O$5=\"Sell Call\", MIN(-O$7*($O19-O$8), 0), IF(O$5=\"Sell Put\", MIN(-O$7*(O$8-$O19), 0))))))))","v":17940},{"$f":"IF(OR(P$5=\"\", P$8=\"\"), \"\", IF(OR(P$5=\"Buy Cash\", P$5=\"Buy FUTR\", P$5=\"Sell FUTR\"), (($C19-P$8)*P$7+$O26)*(1-STCG),   (1-nTax)*(P$9+P$10+$O26+IF(P$5=\"Buy Call\", MAX(P$7*($C19-P$8), 0), IF(P$5=\"Buy Put\", MAX(P$7*(P$8-$O19), 0), IF(P$5=\"Sell Call\", MIN(-P$7*($O19-P$8), 0), IF(P$5=\"Sell Put\", MIN(-P$7*(P$8-$O19), 0))))))))","v":5565},{"$f":"IF(OR(Q$5=\"\", Q$8=\"\"), \"\", IF(OR(Q$5=\"Buy Cash\", Q$5=\"Buy FUTR\", Q$5=\"Sell FUTR\"), (($C19-Q$8)*Q$7+$O26)*(1-STCG),   (1-nTax)*(Q$9+Q$10+$O26+IF(Q$5=\"Buy Call\", MAX(Q$7*($C19-Q$8), 0), IF(Q$5=\"Buy Put\", MAX(Q$7*(Q$8-$O19), 0), IF(Q$5=\"Sell Call\", MIN(-Q$7*($O19-Q$8), 0), IF(Q$5=\"Sell Put\", MIN(-Q$7*(Q$8-$O19), 0))))))))","v":""},{"$f":"IF(OR(R$5=\"\", R$8=\"\"), \"\", IF(OR(R$5=\"Buy Cash\", R$5=\"Buy FUTR\", R$5=\"Sell FUTR\"), (($C19-R$8)*R$7+$O26)*(1-STCG),   (1-nTax)*(R$9+R$10+$O26+IF(R$5=\"Buy Call\", MAX(R$7*($C19-R$8), 0), IF(R$5=\"Buy Put\", MAX(R$7*(R$8-$O19), 0), IF(R$5=\"Sell Call\", MIN(-R$7*($O19-R$8), 0), IF(R$5=\"Sell Put\", MIN(-R$7*(R$8-$O19), 0))))))))","v":""}]
[null,null,16815,-9885,{"$f":"IF(OR(E$5=\"\", E$8=\"\"), \"\", IF(OR(E$5=\"Buy Cash\", E$5=\"Buy FUTR\", E$5=\"Sell FUTR\"), (($C20-E$8)*E$7+$C27)*(1-STCG),   (1-nTax)*(E$9+E$10+$C27+IF(E$5=\"Buy Call\", MAX(E$7*($C20-E$8), 0), IF(E$5=\"Buy Put\", MAX(E$7*(E$8-$C20), 0), IF(E$5=\"Sell Call\", MIN(-E$7*($C20-E$8), 0), IF(E$5=\"Sell Put\", MIN(-E$7*(E$8-$C20), 0))))))))","v":-2460},"","","",null,"ITC",6.17,null,null,null,{"$f":"IF(OR(O$5=\"\", O$8=\"\"), \"\", IF(OR(O$5=\"Buy Cash\", O$5=\"Buy FUTR\", O$5=\"Sell FUTR\"), (($O20-O$8)*O$7+$O27)*(1-STCG),   (1-nTax)*(O$9+O$10+$O27+IF(O$5=\"Buy Call\", MAX(O$7*($C20-O$8), 0), IF(O$5=\"Buy Put\", MAX(O$7*(O$8-$O20), 0), IF(O$5=\"Sell Call\", MIN(-O$7*($O20-O$8), 0), IF(O$5=\"Sell Put\", MIN(-O$7*(O$8-$O20), 0))))))))","v":17940},{"$f":"IF(OR(P$5=\"\", P$8=\"\"), \"\", IF(OR(P$5=\"Buy Cash\", P$5=\"Buy FUTR\", P$5=\"Sell FUTR\"), (($O20-P$8)*P$7+$O27)*(1-STCG),   (1-nTax)*(P$9+P$10+$O27+IF(P$5=\"Buy Call\", MAX(P$7*($C20-P$8), 0), IF(P$5=\"Buy Put\", MAX(P$7*(P$8-$O20), 0), IF(P$5=\"Sell Call\", MIN(-P$7*($O20-P$8), 0), IF(P$5=\"Sell Put\", MIN(-P$7*(P$8-$O20), 0))))))))","v":5565},{"$f":"IF(OR(Q$5=\"\", Q$8=\"\"), \"\", IF(OR(Q$5=\"Buy Cash\", Q$5=\"Buy FUTR\", Q$5=\"Sell FUTR\"), (($O20-Q$8)*Q$7+$O27)*(1-STCG),   (1-nTax)*(Q$9+Q$10+$O27+IF(Q$5=\"Buy Call\", MAX(Q$7*($C20-Q$8), 0), IF(Q$5=\"Buy Put\", MAX(Q$7*(Q$8-$O20), 0), IF(Q$5=\"Sell Call\", MIN(-Q$7*($O20-Q$8), 0), IF(Q$5=\"Sell Put\", MIN(-Q$7*(Q$8-$O20), 0))))))))","v":""},{"$f":"IF(OR(R$5=\"\", R$8=\"\"), \"\", IF(OR(R$5=\"Buy Cash\", R$5=\"Buy FUTR\", R$5=\"Sell FUTR\"), (($O20-R$8)*R$7+$O27)*(1-STCG),   (1-nTax)*(R$9+R$10+$O27+IF(R$5=\"Buy Call\", MAX(R$7*($C20-R$8), 0), IF(R$5=\"Buy Put\", MAX(R$7*(R$8-$O20), 0), IF(R$5=\"Sell Call\", MIN(-R$7*($O20-R$8), 0), IF(R$5=\"Sell Put\", MIN(-R$7*(R$8-$O20), 0))))))))","v":""}]
[null,"Profit(+)/ Loss(-) ",13065,-2385,{"$f":"IF(OR(E$5=\"\", E$8=\"\"), \"\", IF(OR(E$5=\"Buy Cash\", E$5=\"Buy FUTR\", E$5=\"Sell FUTR\"), (($C21-E$8)*E$7+$C28)*(1-STCG),   (1-nTax)*(E$9+E$10+$C28+IF(E$5=\"Buy Call\", MAX(E$7*($C21-E$8), 0), IF(E$5=\"Buy Put\", MAX(E$7*(E$8-$C21), 0), IF(E$5=\"Sell Call\", MIN(-E$7*($C21-E$8), 0), IF(E$5=\"Sell Put\", MIN(-E$7*(E$8-$C21), 0))))))))","v":-6210},"","","",null,"ICICIBANK",4.9800000000000004,null,null,null,{"$f":"IF(OR(O$5=\"\", O$8=\"\"), \"\", IF(OR(O$5=\"Buy Cash\", O$5=\"Buy FUTR\", O$5=\"Sell FUTR\"), (($O21-O$8)*O$7+$O28)*(1-STCG),   (1-nTax)*(O$9+O$10+$O28+IF(O$5=\"Buy Call\", MAX(O$7*($O21-O$8), 0), IF(O$5=\"Buy Put\", MAX(O$7*(O$8-$O21), 0), IF(O$5=\"Sell Call\", MIN(-O$7*($O21-O$8), 0), IF(O$5=\"Sell Put\", MIN(-O$7*(O$8-$O21), 0))))))))","v":14130},5505,"",""]
[null,null,5565,5115,{"$f":"IF(OR(E$5=\"\", E$8=\"\"), \"\", IF(OR(E$5=\"Buy Cash\", E$5=\"Buy FUTR\", E$5=\"Sell FUTR\"), (($C22-E$8)*E$7+$C29)*(1-STCG),   (1-nTax)*(E$9+E$10+$C29+IF(E$5=\"Buy Call\", MAX(E$7*($C22-E$8), 0), IF(E$5=\"Buy Put\", MAX(E$7*(E$8-$C22), 0), IF(E$5=\"Sell Call\", MIN(-E$7*($C22-E$8), 0), IF(E$5=\"Sell Put\", MIN(-E$7*(E$8-$C22), 0))))))))","v":-6210},"","","",null,"INFY",4.7,null,null,null,6630,5505,"",""]
[null,null,-1935,12615,{"$f":"IF(OR(E$5=\"\", E$8=\"\"), \"\", IF(OR(E$5=\"Buy Cash\", E$5=\"Buy FUTR\", E$5=\"Sell FUTR\"), (($C23-E$8)*E$7+$C30)*(1-STCG),   (1-nTax)*(E$9+E$10+$C30+IF(E$5=\"Buy Call\", MAX(E$7*($C23-E$8), 0), IF(E$5=\"Buy Put\", MAX(E$7*(E$8-$C23), 0), IF(E$5=\"Sell Call\", MIN(-E$7*($C23-E$8), 0), IF(E$5=\"Sell Put\", MIN(-E$7*(E$8-$C23), 0))))))))","v":-6210},"","","",null,"LT",3.84,null,null,null,-870,5505,"",""]
[null,null,-9435,16365,{"$f":"IF(OR(E$5=\"\", E$8=\"\"), \"\", IF(OR(E$5=\"Buy Cash\", E$5=\"Buy FUTR\", E$5=\"Sell FUTR\"), (($C24-E$8)*E$7+$C31)*(1-STCG),   (1-nTax)*(E$9+E$10+$C31+IF(E$5=\"Buy Call\", MAX(E$7*($C24-E$8), 0), IF(E$5=\"Buy Put\", MAX(E$7*(E$8-$C24), 0), IF(E$5=\"Sell Call\", MIN(-E$7*($C24-E$8), 0), IF(E$5=\"Sell Put\", MIN(-E$7*(E$8-$C24), 0))))))))","v":-6210},"","","",null,"TCS",3.5,null,null,null,-8370,1755,"",""]
[null,null,{"$f":"IF(OR(C$5=\"\", C$8=\"\"), \"\", IF(OR(C$5=\"Buy Cash\", C$5=\"Buy FUTR\", C$5=\"Sell FUTR\"), (($C25-C$8)*C$7+$C32)*(1-STCG),   (1-nTax)*(C$9+C$10+$C32+IF(C$5=\"Buy Call\", MAX(C$7*($C25-C$8), 0), IF(C$5=\"Buy Put\", MAX(C$7*(C$8-$C25), 0), IF(C$5=\"Sell Call\", MIN(-C$7*($C25-C$8), 0), IF(C$5=\"Sell Put\", MIN(-C$7*(C$8-$C25), 0))))))))","v":-16935},16365,{"$f":"IF(OR(E$5=\"\", E$8=\"\"), \"\", IF(OR(E$5=\"Buy Cash\", E$5=\"Buy FUTR\", E$5=\"Sell FUTR\"), (($C25-E$8)*E$7+$C32)*(1-STCG),   (1-nTax)*(E$9+E$10+$C32+IF(E$5=\"Buy Call\", MAX(E$7*($C25-E$8), 0), IF(E$5=\"Buy Put\", MAX(E$7*(E$8-$C25), 0), IF(E$5=\"Sell Call\", MIN(-E$7*($C25-E$8), 0), IF(E$5=\"Sell Put\", MIN(-E$7*(E$8-$C25), 0))))))))","v":-6210},"","","",null,"KOTAKBANK",3.26,null,null,null,-15870,-5745,"",""]
[null,"SPAN Margin@5%",{"$f":"IF(OR(C$5=\"\", C$8=\"\"), \"\", IF(C$5=\"Buy Cash\", C6*$D$4,   IF(OR(C$5=\"Sell Call\", C$5=\"Sell Put\",  C$5=\"Sell FUTR\", C$5=\"Buy FUTR\"), C8*$D$4*SPANidx, C9)))","v":36000},37125,-6150,"","","",null,"MARUTI",2.82,null,null,null,{"$f":"IF(OR(O$5=\"\", O$8=\"\"), \"\", IF(O$5=\"Buy Cash\", O6*$D$4,   IF(OR(O$5=\"Sell Call\", O$5=\"Sell Put\",  O$5=\"Sell FUTR\", O$5=\"Buy FUTR\"), O8*$D$4*SPANidx, O9)))","v":36000},{"$f":"IF(OR(P$5=\"\", P$8=\"\"), \"\", IF(P$5=\"Buy Cash\", P6*$D$4,   IF(OR(P$5=\"Sell Call\", P$5=\"Sell Put\",  P$5=\"Sell FUTR\", P$5=\"Buy FUTR\"), P8*$D$4*SPANidx, P9)))","v":37125},{"$f":"IF(OR(Q$5=\"\", Q$8=\"\"), \"\", IF(Q$5=\"Buy Cash\", Q6*$D$4,   IF(OR(Q$5=\"Sell Call\", Q$5=\"Sell Put\",  Q$5=\"Sell FUTR\", Q$5=\"Buy FUTR\"), Q8*$D$4*SPANidx, Q9)))","v":""},{"$f":"IF(OR(R$5=\"\", R$8=\"\"), \"\", IF(R$5=\"Buy Cash\", R6*$D$4,   IF(OR(R$5=\"Sell Call\", R$5=\"Sell Put\",  R$5=\"Sell FUTR\", R$5=\"Buy FUTR\"), R8*$D$4*SPANidx, R9)))","v":""}]
[null,"Interest p.m. @RFR",{"$f":"IF(OR(C$5=\"\", C$8=\"\"), \"\", C40*RFR/12)","v":216.96},223.73999999999998,-37.064,"","","",null,null,null,null,null,null,{"$f":"IF(OR(O$5=\"\", O$8=\"\"), \"\", O40*RFR/12)","v":216.96},{"$f":"IF(OR(P$5=\"\", P$8=\"\"), \"\", P40*RFR/12)","v":223.73999999999998},{"$f":"IF(OR(Q$5=\"\", Q$8=\"\"), \"\", Q40*RFR/12)","v":""},{"$f":"IF(OR(R$5=\"\", R$8=\"\"), \"\", R40*RFR/12)","v":""}]
[null,{"$f":"SUM(C33:H33)","v":4470},{"$f":"SUM(C34:H34)","v":4470},{"$f":"SUM(C35:H35)","v":4470},{"$f":"SUM(C36:H36)","v":4470},{"$f":"SUM(C37:H37)","v":4470},{"$f":"SUM(C38:H38)","v":720},{"$f":"SUM(C39:H39)","v":-6780},null,null,null,{"$f":"SUM(O33:R33)","v":23505},{"$f":"SUM(O34:R34)","v":23505},{"$f":"SUM(O35:R35)","v":19635},{"$f":"SUM(O36:R36)","v":12135},{"$f":"SUM(O37:R37)","v":4635},{"$f":"SUM(O38:R38)","v":-6615},{"$f":"SUM(O39:R39)","v":-21615}]

{"sheet":"LotSize","index":2,"n_rows":216,"n_cols":9,"rows_kept":216,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,"Link to NSE website for strike interval"]
[null,null,null,null,null,null,null,null,"https://www.nseindia.com/content/fo/fo_mktlots.csv"]
[null,"BANKNIFTY",40,40,40]
[null,"ACC",400,400,400]
[null,"AMARAJABAT",600,600,700]
[null,"ADANIENT",4000,4000,4000]
[null,"ADANIPORTS",2500,2500,2500]
[null,"ALBK",10000,10000,10000]
[null,"AMBUJACEM",2500,2500,2500]
[null,"ANDHRABANK",10000,10000,10000]
[null,"APOLLOTYRE",3000,3000,3000]
[null,"ICICIBANK",2750,2750,2750]
[null,"ASHOKLEY",7000,7000,7000]
[null,"IDEA",7000,7000,7000]
[null,"APOLLOHOSP",500,500,500]
[null,"AUROPHARMA",800,800,800]
[null,"BAJAJ-AUTO",250,250,250]
[null,"BAJAJFINSV",125,125,125]
[null,"INDIGO",600,600,600]
[null,"BATAINDIA",1100,1100,1100]
[null,"ASIANPAINT",600,600,600]
[null,"AJANTPHARM",400,400,500]
[null,"BEML",300,300,300]
[null,"MARUTI",75,75,75]
[null,"AXISBANK",1200,1200,1200]
[null,"MFSL",1000,1000,1000]
[null,"BAJFINANCE",500,500,500]
[null,"BALKRISIND",400,400,400]
[null,"BALRAMCHIN",3500,3500,3500]
[null,"BERGEPAINT",2200,2200,2200]
[null,"BHARATFORG",1200,1200,1200]
[null,"BHARTIARTL",1700,1700,1700]
[null,"BEL",4950,4950,4950]
[null,"BHARATFIN",1000,1000,1000]
[null,"BHEL",7500,7500,7500]
[null,"BOSCHLTD",25,25,25]
[null,"NBCC",3000,3000,3000]
[null,"RAYMOND",800,800,800]
[null,"BANKBARODA",3500,3500,4000]
[null,"BPCL",1800,1800,1800]
[null,"BANKINDIA",6000,6000,6000]
[null,"CANFINHOME",1250,1250,1250]
[null,"CAPF",800,800,800]
[null,"CEATLTD",350,350,350]
[null,"CESC",550,550,550]
[null,"CGPOWER",12000,12000,12000]
[null,"CHENNPETRO",1500,1500,1500]
[null,"COALINDIA",1700,1700,2200]
[null,"TORNTPOWER",3000,3000,3000]
[null,"CONCOR",625,625,625]
[null,"CUMMINSIND",600,600,600]
[null,"CADILAHC",1600,1600,1600]
[null,"BIOCON",1800,1800,1800]
[null,"DHFL",1500,1500,1500]
[null,"DISHTV",7000,7000,7000]
[null,"CANBK",3084,3084,1600]
[null,"DIVISLAB",800,800,800]
[null,"DLF",5000,5000,5000]
[null,"DRREDDY",200,200,250]
[null,"EICHERMOT",25,25,25]
[null,"ESCORTS",1100,1100,1100]
[null,"EXIDEIND",4000,4000,4000]
[null,"FEDERALBNK",5500,5500,5500]
[null,"FORTIS",2700,2700,3500]
[null,"CASTROLIND",1400,1400,1400]
[null,"GLENMARK",700,700,900]
[null,"GODFRYPHLP",500,500,500]
[null,"GODREJIND",1500,1500,1500]
[null,"GRASIM",750,750,750]
[null,"HCC",12000,12000,15000]
[null,"HDFC",500,500,500]
[null,"HDFCBANK",500,500,500]
[null,"HDIL",8000,8000,9000]
[null,"CHOLAFIN",500,500,500]
[null,"HEROMOTOCO",200,200,200]
[null,"CIPLA",1000,1000,1000]
[null,"COLPAL",700,700,700]
[null,"HINDALCO",3500,3500,3500]
[null,"HINDPETRO",1575,1575,1575]
[null,"DABUR",2500,2500,2500]
[null,"HINDZINC",3200,3200,3200]
[null,"IBREALEST",2500]
[null,"ICICIPRULI",1300,1300,1300]
[null,"IDFC",13200,13200,13200]
[null,"IDFCBANK",9000,9000,9000]
[null,"DALMIABHA",300,300,300]
[null,"INDUSINDBK",300,300,300]
[null,"INFIBEAM",4000,4000,4000]
[null,"IRB",2500,2500,2500]
[null,"DCBBANK",4500,4500,4500]
[null,"ITC",2400,2400,2400]
[null,"JINDALSTEL",4500,4500,4500]
[null,"ENGINERSIN",3500,3500,3500]
[null,"JUSTDIAL",1200,1200,1400]
[null,"KOTAKBANK",800,800,800]
[null,"KPIT",4000,4000,4500]
[null,"GAIL",2000,2000,2000]
[null,"KTKBANK",3800,3800,3800]
[null,"L&TFH",4500,4500,4500]
[null,"LICHSGFIN",1100,1100,1100]
[null,"LUPIN",400,400,600]
[null,"GMRINFRA",45000,45000,45000]
[null,"M&MFIN",1250,1250,1250]
[null,"MANAPPURAM",6000,6000,6000]
[null,"GODREJCP",800,800,800]
[null,"GRANULES",5000,5000,5000]
[null,"MCX",500,500,500]
[null,"MGL",600,600,600]
[null,"MOTHERSUMI",3750,3750,1600]
[null,"HAVELLS",2000,2000,2000]
[null,"MRF",15,15,15]
[null,"HEXAWARE",3000,3000,3000]
[null,"HINDUNILVR",600,600,600]
[null,"IBULHSGFIN",400,400,400]
[null,"ICIL",3500,3500,5000]
[null,"INFRATEL",1700,1700,1700]
[null,"NATIONALUM",8000,8000,8000]
[null,"JISLJALEQS",9000,9000,9000]
[null,"JSWENERGY",8500,8500,8500]
[null,"NCC",8000,8000,8000]
[null,"JSWSTEEL",3000,3000,3000]
[null,"NESTLEIND",100,100,100]
[null,"IDBI",8000,8000,10000]
[null,"NIITTECH",1500,1500,1500]
[null,"INDIANB",2000,2000,2000]
[null,"NMDC",6000,6000,6000]
[null,"NTPC",4000,4000,4000]
[null,"OFSS",150,150,150]
[null,"OIL",2266,2266,2266]
[null,"M&M",500,500,500]
[null,"IOC",1500,1500,1500]
[null,"ONGC",3750,3750,3750]
[null,"ORIENTBANK",6000,6000,6000]
[null,"PAGEIND",50,50,50]
[null,"PCJEWELLER",1500,1500,1500]
[null,"JUBLFOOD",500,500,500]
[null,"PEL",300,300,300]
[null,"PFC",6000,6000,6000]
[null,"POWERGRID",4000,4000,4000]
[null,"PTC",8000,8000,8000]
[null,"KAJARIACER",800,800,800]
[null,"MARICO",2600,2600,2600]
[null,"MCDOWELL-N",250,250,250]
[null,"RELIANCE",1000,1000,1000]
[null,"RELINFRA",1300,1300,1300]
[null,"MRPL",4500,4500,4500]
[null,"RPOWER",12000,12000,13000]
[null,"SAIL",12000,12000,12000]
[null,"SHREECEM",50,50,50]
[null,"MUTHOOTFIN",1500,1500,1500]
[null,"SIEMENS",500,500,500]
[null,"SOUTHBANK",33141,33141,33141]
[null,"SREINFRA",5000,5000,5000]
[null,"SRF",500,500,500]
[null,"SRTRANSFIN",600,600,600]
[null,"STAR",500,500,600]
[null,"SUNTV",1000,1000,1000]
[null,"TATACHEM",1500,1500,1500]
[null,"TATAMOTORS",1500,1500,1500]
[null,"TATAMTRDVR",2100,2100,2500]
[null,"PETRONET",3000,3000,3000]
[null,"TATASTEEL",1000,1000,1000]
[null,"TCS",250,250,250]
[null,"TECHM",1100,1100,1200]
[null,"TORNTPHARM",400,400,500]
[null,"TVSMOTOR",1000,1000,1000]
[null,"UBL",700,700,700]
[null,"UJJIVAN",1200,1200,1600]
[null,"UNIONBANK",4000,4000,4000]
[null,"PIDILITIND",1000,1000,1000]
[null,"UPL",1200,1200,1200]
[null,"RAMCOCEM",800,800,800]
[null,"VEDL",1750,1750,1750]
[null,"VOLTAS",1000,1000,1000]
[null,"RBLBANK",1000,1000,1000]
[null,"WIPRO",2400,2400,2400]
[null,"RECLTD",6000,6000,6000]
[null,"RELCAPITAL",750,750,750]
[null,"MINDTREE",1200,1200,1200]
[null,"YESBANK",1750,1750,1750]
[null,"ADANIPOWER",20000,20000,20000]
[null,"ARVIND",2000,2000,2000]
[null,"BRITANNIA",200,200,200]
[null,"TV18BRDCST",17000,17000,17000]
[null,"EQUITAS",3200,3200,3200]
[null,"GSFC",4500,4500,4500]
[null,"IGL",2750,2750,2750]
[null,"INFY",500,500,600]
[null,"JETAIRWAYS",1200,1200,1200]
[null,"KSCL",1500,1500,1500]
[null,"NHPC",27000,27000,27000]
[null,"WOCKPHARMA",800,800,900]
[null,"PNB",3500,3500,4000]
[null,"RNAVAL",9000,9000,9000]
[null,"REPCOHOME",700,700,900]
[null,"CENTURYTEX",550,550,550]
[null,"SBIN",3000,3000,3000]
[null,"HCLTECH",700,700,700]
[null,"SYNDIBANK",9000,9000,9000]
[null,"TATACOMM",700,700,800]
[null,"TATAGLOBAL",4500,4500,4500]
[null,"TATAPOWER",9000,9000,9000]
[null,"TITAN",1500,1500,1500]
[null,"INDIACEM",3500,3500,3500]
[null,"ULTRACEMCO",200,200,200]
[null,"VGUARD",3000,3000,3000]
[null,"ZEEL",1300,1300,1300]
[null,"PVR",400,400,400]
[null,"SUNPHARMA",800,800,1100]
[null,"TATAELXSI",800,800,800]
[null,"JPASSOCIAT",34000,34000,34000]
[null,"LT",750,750,750]
[null,"SUZLON",30000,30000,35000]
[null,"RCOM",14000,14000,28000]
[null,"IFCI",22000,22000,22000]

{"sheet":"StrikeInterval","index":3,"n_rows":216,"n_cols":7,"rows_kept":216,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,"Link to NSE website for strike interval"]
[null,null,null,null,null,null,"https://www.nseindia.com/content/fo/sos_scheme.xls"]
[null,"Symbol","Applicable Step value","No. of Strikes Provided\nIn the money - At the money - Out of the money","No of additional strikes which may be enabled intraday"]
[null,"ACC",20,"10 - 1 - 10",10]
[null,"ADANIENT",5,"6 - 1 - 6",6]
[null,"ADANIPORTS",10,"9 - 1 - 9",9]
[null,"ADANIPOWER",2.5,"5 - 1 - 5",5]
[null,"AJANTPHARM",20,"10 - 1 - 10",10]
[null,"ALBK",2.5,"6 - 1 - 6",6]
[null,"AMARAJABAT",20,"8 - 1 - 8",8]
[null,"AMBUJACEM",5,"10 - 1 - 10",10]
[null,"ANDHRABANK",2.5,"5 - 1 - 5",5]
[null,"APOLLOHOSP",20,"10 - 1 - 10",10]
[null,"APOLLOTYRE",10,"6 - 1 - 6",6]
[null,"ARVIND",10,"9 - 1 - 9",9]
[null,"ASHOKLEY",2.5,"10 - 1 - 10",10]
[null,"ASIANPAINT",20,"10 - 1 - 10",10]
[null,"AUROPHARMA",20,"8 - 1 - 8",8]
[null,"AXISBANK",10,"10 - 1 - 10",10]
[null,"BAJAJ-AUTO",50,"10 - 1 - 10",10]
[null,"BAJAJFINSV",50,"10 - 1 - 10",10]
[null,"BAJFINANCE",50,"8 - 1 - 8",8]
[null,"BALKRISIND",50,"7 - 1 - 7",7]
[null,"BALRAMCHIN",5,"7 - 1 - 7",7]
[null,"BANKBARODA",5,"6 - 1 - 6",6]
[null,"BANKINDIA",5,"7 - 1 - 7",7]
[null,"BATAINDIA",20,"8 - 1 - 8",8]
[null,"BEL",5,"8 - 1 - 8",8]
[null,"BEML",50,"8 - 1 - 8",8]
[null,"BERGEPAINT",5,"10 - 1 - 10",10]
[null,"BHARATFIN",20,"10 - 1 - 10",10]
[null,"BHARATFORG",10,"10 - 1 - 10",10]
[null,"BHARTIARTL",10,"8 - 1 - 8",8]
[null,"BHEL",2.5,"10 - 1 - 10",10]
[null,"BIOCON",10,"7 - 1 - 7",7]
[null,"BOSCHLTD",50,"10 - 1 - 10",10]
[null,"BPCL",10,"10 - 1 - 10",10]
[null,"BRITANNIA",50,"10 - 1 - 10",10]
[null,"CADILAHC",20,"5 - 1 - 5",5]
[null,"CANBK",10,"7 - 1 - 7",7]
[null,"CANFINHOME",10,"10 - 1 - 10",10]
[null,"CAPF",20,"8 - 1 - 8",8]
[null,"CASTROLIND",5,"10 - 1 - 10",10]
[null,"CEATLTD",50,"7 - 1 - 7",7]
[null,"CENTURYTEX",50,"6 - 1 - 6",6]
[null,"CESC",20,"10 - 1 - 10",10]
[null,"CGPOWER",2.5,"7 - 1 - 7",7]
[null,"CHENNPETRO",20,"5 - 1 - 5",5]
[null,"CHOLAFIN",20,"10 - 1 - 10",10]
[null,"CIPLA",10,"10 - 1 - 10",10]
[null,"COALINDIA",5,"10 - 1 - 10",10]
[null,"COLPAL",20,"10 - 1 - 10",10]
[null,"CONCOR",20,"10 - 1 - 10",10]
[null,"CUMMINSIND",20,"10 - 1 - 10",10]
[null,"DABUR",5,"10 - 1 - 10",10]
[null,"DALMIABHA",50,"10 - 1 - 10",10]
[null,"DCBBANK",5,"8 - 1 - 8",8]
[null,"DHFL",20,"6 - 1 - 6",6]
[null,"DISHTV",2.5,"7 - 1 - 7",7]
[null,"DIVISLAB",20,"9 - 1 - 9",9]
[null,"DLF",10,"5 - 1 - 5",5]
[null,"DRREDDY",50,"9 - 1 - 9",9]
[null,"EICHERMOT",50,"10 - 1 - 10",10]
[null,"ENGINERSIN",2.5,"10 - 1 - 10",10]
[null,"EQUITAS",5,"7 - 1 - 7",7]
[null,"ESCORTS",20,"7 - 1 - 7",7]
[null,"EXIDEIND",5,"9 - 1 - 9",9]
[null,"FEDERALBNK",2.5,"10 - 1 - 10",10]
[null,"FORTIS",5,"6 - 1 - 6",6]
[null,"GAIL",10,"8 - 1 - 8",8]
[null,"GLENMARK",10,"10 - 1 - 10",10]
[null,"GMRINFRA",2.5,"5 - 1 - 5",5]
[null,"GODFRYPHLP",50,"5 - 1 - 5",5]
[null,"GODREJCP",20,"10 - 1 - 10",10]
[null,"GODREJIND",20,"7 - 1 - 7",7]
[null,"GRANULES",5,"5 - 1 - 5",5]
[null,"GRASIM",20,"10 - 1 - 10",10]
[null,"GSFC",5,"6 - 1 - 6",6]
[null,"HAVELLS",10,"10 - 1 - 10",10]
[null,"HCC",2.5,"5 - 1 - 5",5]
[null,"HCLTECH",20,"9 - 1 - 9",9]
[null,"HDFC",20,"10 - 1 - 10",10]
[null,"HDFCBANK",20,"10 - 1 - 10",10]
[null,"HDIL",2.5,"5 - 1 - 5",5]
[null,"HEROMOTOCO",50,"10 - 1 - 10",10]
[null,"HEXAWARE",5,"10 - 1 - 10",10]
[null,"HINDALCO",5,"10 - 1 - 10",10]
[null,"HINDPETRO",20,"5 - 1 - 5",5]
[null,"HINDUNILVR",20,"10 - 1 - 10",10]
[null,"HINDZINC",5,"10 - 1 - 10",10]
[null,"IBREALEST",10,"5 - 1 - 5",5]
[null,"IBULHSGFIN",20,"10 - 1 - 10",10]
[null,"ICICIBANK",5,"10 - 1 - 10",10]
[null,"ICICIPRULI",10,"9 - 1 - 9",9]
[null,"ICIL",5,"5 - 1 - 5",5]
[null,"IDBI",2.5,"5 - 1 - 5",5]
[null,"IDEA",2.5,"7 - 1 - 7",7]
[null,"IDFC",2.5,"5 - 1 - 5",5]
[null,"IDFCBANK",2.5,"5 - 1 - 5",5]
[null,"IFCI",2.5,"5 - 1 - 5",5]
[null,"IGL",10,"6 - 1 - 6",6]
[null,"INDIACEM",5,"8 - 1 - 8",8]
[null,"INDIANB",10,"6 - 1 - 6",6]
[null,"INDIGO",20,"10 - 1 - 10",10]
[null,"INDUSINDBK",20,"10 - 1 - 10",10]
[null,"INFIBEAM",5,"6 - 1 - 6",6]
[null,"INFRATEL",10,"8 - 1 - 8",8]
[null,"INFY",20,"9 - 1 - 9",9]
[null,"IOC",10,"9 - 1 - 9",9]
[null,"IRB",5,"9 - 1 - 9",9]
[null,"ITC",10,"6 - 1 - 6",6]
[null,"JETAIRWAYS",20,"6 - 1 - 6",6]
[null,"JINDALSTEL",5,"6 - 1 - 6",6]
[null,"JISLJALEQS",2.5,"9 - 1 - 9",9]
[null,"JPASSOCIAT",2.5,"5 - 1 - 5",5]
[null,"JSWENERGY",2.5,"7 - 1 - 7",7]
[null,"JSWSTEEL",5,"10 - 1 - 10",10]
[null,"JUBLFOOD",50,"6 - 1 - 6",6]
[null,"JUSTDIAL",10,"8 - 1 - 8",8]
[null,"KAJARIACER",20,"7 - 1 - 7",7]
[null,"KOTAKBANK",20,"10 - 1 - 10",10]
[null,"KPIT",5,"5 - 1 - 5",5]
[null,"KSCL",20,"6 - 1 - 6",6]
[null,"KTKBANK",5,"7 - 1 - 7",7]
[null,"L&TFH",5,"9 - 1 - 9",9]
[null,"LICHSGFIN",10,"10 - 1 - 10",10]
[null,"LT",20,"10 - 1 - 10",10]
[null,"LUPIN",20,"10 - 1 - 10",10]
[null,"M&M",20,"10 - 1 - 10",10]
[null,"M&MFIN",10,"9 - 1 - 9",9]
[null,"MANAPPURAM",5,"5 - 1 - 5",5]
[null,"MARICO",5,"10 - 1 - 10",10]
[null,"MARUTI",50,"10 - 1 - 10",10]
[null,"MCDOWELL-N",50,"10 - 1 - 10",10]
[null,"MCX",20,"10 - 1 - 10",10]
[null,"MFSL",10,"10 - 1 - 10",10]
[null,"MGL",20,"10 - 1 - 10",10]
[null,"MINDTREE",10,"10 - 1 - 10",10]
[null,"MOTHERSUMI",10,"7 - 1 - 7",7]
[null,"MRF",50,"10 - 1 - 10",10]
[null,"MRPL",5,"6 - 1 - 6",6]
[null,"MUTHOOTFIN",20,"5 - 1 - 5",5]
[null,"NATIONALUM",2.5,"7 - 1 - 7",7]
[null,"NBCC",5,"9 - 1 - 9",9]
[null,"NCC",2.5,"8 - 1 - 8",8]
[null,"NESTLEIND",50,"10 - 1 - 10",10]
[null,"NHPC",2.5,"5 - 1 - 5",5]
[null,"NIITTECH",10,"10 - 1 - 10",10]
[null,"NMDC",2.5,"10 - 1 - 10",10]
[null,"NTPC",2.5,"10 - 1 - 10",10]
[null,"OFSS",50,"10 - 1 - 10",10]
[null,"OIL",10,"7 - 1 - 7",7]
[null,"ONGC",2.5,"10 - 1 - 10",10]
[null,"ORIENTBANK",5,"6 - 1 - 6",6]
[null,"PAGEIND",50,"10 - 1 - 10",10]
[null,"PCJEWELLER",10,"7 - 1 - 7",7]
[null,"PEL",50,"10 - 1 - 10",10]
[null,"PETRONET",5,"10 - 1 - 10",10]
[null,"PFC",5,"6 - 1 - 6",6]
[null,"PIDILITIND",20,"9 - 1 - 9",9]
[null,"PNB",5,"6 - 1 - 6",6]
[null,"POWERGRID",2.5,"10 - 1 - 10",10]
[null,"PTC",5,"5 - 1 - 5",5]
[null,"PVR",20,"10 - 1 - 10",10]
[null,"RAMCOCEM",20,"8 - 1 - 8",8]
[null,"RAYMOND",20,"9 - 1 - 9",9]
[null,"RBLBANK",10,"10 - 1 - 10",10]
[null,"RCOM",2.5,"5 - 1 - 5",5]
[null,"RECLTD",5,"7 - 1 - 7",7]
[null,"RELCAPITAL",20,"8 - 1 - 8",8]
[null,"RELIANCE",20,"9 - 1 - 9",9]
[null,"RELINFRA",20,"5 - 1 - 5",5]
[null,"REPCOHOME",20,"7 - 1 - 7",7]
[null,"RNAVAL",2.5,"5 - 1 - 5",5]
[null,"RPOWER",2.5,"5 - 1 - 5",5]
[null,"SAIL",2.5,"5 - 1 - 5",5]
[null,"SBIN",5,"10 - 1 - 10",10]
[null,"SHREECEM",50,"10 - 1 - 10",10]
[null,"SIEMENS",20,"10 - 1 - 10",10]
[null,"SOUTHBANK",2.5,"5 - 1 - 5",5]
[null,"SREINFRA",5,"5 - 1 - 5",5]
[null,"SRF",50,"7 - 1 - 7",7]
[null,"SRTRANSFIN",20,"10 - 1 - 10",10]
[null,"STAR",20,"10 - 1 - 10",10]
[null,"SUNPHARMA",20,"6 - 1 - 6",6]
[null,"SUNTV",20,"9 - 1 - 9",9]
[null,"SUZLON",2.5,"5 - 1 - 5",5]
[null,"SYNDIBANK",2.5,"6 - 1 - 6",6]
[null,"TATACHEM",10,"10 - 1 - 10",10]
[null,"TATACOMM",20,"7 - 1 - 7",7]
[null,"TATAELXSI",50,"8 - 1 - 8",8]
[null,"TATAGLOBAL",5,"9 - 1 - 9",9]
[null,"TATAMOTORS",10,"8 - 1 - 8",8]
[null,"TATAMTRDVR",5,"10 - 1 - 10",10]
[null,"TATAPOWER",2.5,"7 - 1 - 7",7]
[null,"TATASTEEL",10,"10 - 1 - 10",10]
[null,"TCS",50,"10 - 1 - 10",10]
[null,"TECHM",10,"9 - 1 - 9",9]
[null,"TITAN",10,"10 - 1 - 10",10]
[null,"TORNTPHARM",50,"5 - 1 - 5",5]
[null,"TORNTPOWER",5,"9 - 1 - 9",9]
[null,"TV18BRDCST",2.5,"5 - 1 - 5",5]
[null,"TVSMOTOR",20,"7 - 1 - 7",7]
[null,"UBL",10,"10 - 1 - 10",10]
[null,"UJJIVAN",10,"7 - 1 - 7",7]
[null,"ULTRACEMCO",50,"10 - 1 - 10",10]
[null,"UNIONBANK",5,"6 - 1 - 6",6]
[null,"UPL",20,"9 - 1 - 9",9]
[null,"VEDL",10,"7 - 1 - 7",7]
[null,"VGUARD",5,"8 - 1 - 8",8]
[null,"VOLTAS",10,"10 - 1 - 10",10]
[null,"WIPRO",5,"10 - 1 - 10",10]
[null,"WOCKPHARMA",20,"7 - 1 - 7",7]
[null,"YESBANK",10,"8 - 1 - 8",8]
[null,"ZEEL",10,"10 - 1 - 10",10]

{"sheet":"NIFTY_Option_Chain","index":4,"n_rows":94,"n_cols":23,"rows_kept":94,"cut":false,"hidden":false,"merged":[[89,4,89,18],[12,16,13,16],[12,17,13,17],[12,18,13,18],[12,19,13,19],[11,0,11,10],[11,12,11,22],[12,0,13,0],[12,1,13,1],[12,2,13,2],[12,3,13,3],[12,4,13,4],[12,5,13,5],[12,6,13,6],[12,11,13,11],[12,22,13,22],[12,20,13,20],[12,21,13,21]]}
[]
[null,null,null,null,null,null,null,null,null,"NIFTY","PCR",{"$f":"OFFSET(V13, COUNTA(B13:B500), 0)/OFFSET(B13, COUNTA(B13:B500), 0)","v":1.20557171668939},"OI"]
[null,null,null,null,null,null,null,null,null,null,"PCR",{"$f":"OFFSET(T13, COUNTA(B13:B500), 0)/OFFSET(D13, COUNTA(B13:B500), 0)","v":1.1344301092783604},"Volume"]
[null,null,null,null,null,null,null,null,null,null,"PCR",{"$f":"(OFFSET(V13, COUNTA(B13:B500), 0)+OFFSET(T13, COUNTA(B13:B500), 0))/(OFFSET(B13, COUNTA(B13:B500), 0)+OFFSET(D13, COUNTA(B13:B500), 0))","v":1.2035571127739086},"OI + Volume"]
[null,"Underlying Index: NIFTY 10389.70  As on Nov 24, 2017 15:30:30 IST "]
["View Options Contracts for: "]
["OR "]
["Filter by: Expiry Date"]
["Futures contracts"]
[]
[]
["CALLS",null,null,null,null,null,null,null,null,null,null,null,"PUTS"]
["Chart","OI","Chng in OI","Volume","IV","LTP","Net Chng","Bid","Bid","Ask","Ask","Strike Price","Bid","Bid","Ask","Ask","Net Chng","LTP","IV","Volume","Chng in OI","OI","Chart"]
[null,null,null,null,null,null,null,"Qty","Price","Price","Qty",null,"Qty","Price","Price","Qty"]
["Graph",50400,-150,3,"-",2149,40.799999999999997,75,2155,2163.1999999999998,75,8250,75,0.15,0.25,2925,-0.25,0.1,55.67,42,-2925,17775,"Graph"]
["Graph",1488375,-11400,153,"-",2102.8000000000002,36.35,75,2102.75,2114.35,300,8300,4800,0.05,0.1,6000,0.05,0.15,56.06,236,-15825,227025,"Graph"]
["Graph","-","-","-","-","-","-",1200,1733.95,"-","-",8350,"-","-",2.4,7500,"-",1,65.06,1,"-",525,"Graph"]
["Graph",195375,-1950,36,59.78,2004.05,38,75,2005.25,2012.8,75,8400,900,0.2,0.3,75,-0.1,0.3,56.5,42,-525,94275,"Graph"]
["Graph","-","-","-","-","-","-",1200,1633.7,"-","-",8450,"-","-",2.4,7500,"-","-","-","-","-","-","Graph"]
["Graph",744150,-89925,1484,"-",1894.7,36.4,75,1907,1914.25,300,8500,44475,0.15,0.25,1200,"-",0.2,51.78,807,-38175,223950,"Graph"]
["Graph","-","-","-","-","-","-",1200,1533.4,"-","-",8550,"-","-",2.4,7500,"-","-","-","-","-","-","Graph"]
["Graph",82875,-300,24,"-",1803.75,45.85,75,1805.3,1811.7,75,8600,600,0.1,0.2,1200,0.1,0.35,51.48,2,-150,48900,"Graph"]
["Graph","-","-","-","-","-","-",750,1738.4,1777.4,750,8650,"-","-",2.4,7500,"-","-","-","-","-","-","Graph"]
["Graph",33075,-825,11,"-",1694.1,72.099999999999994,375,1705.1,1712.15,75,8700,11100,0.1,0.2,2850,-0.3,0.2,46.26,105,-6525,45600,"Graph"]
["Graph","-","-","-","-","-","-",1200,1332.85,"-","-",8750,"-","-",2.4,7500,"-","-","-","-","-","-","Graph"]
["Graph",93300,-1500,40,60.1,1608,98,150,1605.2,1614.15,75,8800,16500,0.15,0.25,4350,-0.3,0.25,44.39,454,"-",86175,"Graph"]
["Graph","-","-","-","-","-","-",1200,1232.55,"-","-",8850,"-","-",2.4,7500,"-","-","-","-","-","-","Graph"]
["Graph",35625,-1500,36,61.88,1511.3,52.7,75,1507,1518.65,75,8900,3000,0.25,0.6,3150,"-",0.55000000000000004,44.86,142,-8175,173700,"Graph"]
["Graph","-","-","-","-","-","-",1200,1132.3,"-","-",8950,37500,0.05,2.4,7500,"-","-","-","-","-","-","Graph"]
["Graph",594000,-28200,501,63.68,1416.35,53.5,75,1404.85,1416.35,150,9000,7275,0.35,0.55000000000000004,375,-0.4,0.35,40.130000000000003,769,-12075,677625,"Graph"]
["Graph","-","-","-","-","-","-",1200,1032,"-","-",9050,150,0.2,2,75,"-",2,"-","-","-",375,"Graph"]
["Graph",53250,-1875,33,53.5,1311,57,75,1303.4000000000001,1315.9,75,9100,1500,0.4,0.5,900,-0.35,0.5,38.67,281,600,109950,"Graph"]
["Graph","-","-","-","-","-","-",1200,931.75,"-","-",9150,27525,0.05,2.4,7500,"-","-","-","-","-","-","Graph"]
["Graph",116175,-2700,50,44.79,1208,52,75,1206.2,1214.4000000000001,1425,9200,1500,0.5,0.6,6225,-0.35,0.6,36.5,298,-2175,538425,"Graph"]
["Graph","-","-","-","-","-","-",1200,831.5,"-","-",9250,35025,0.05,2.4,7500,"-","-","-","-","-","-","Graph"]
["Graph",81750,-4950,83,35.68,1106,56,75,1106,1116.75,300,9300,3075,0.5,0.6,75,-0.45,0.55000000000000004,33.29,2794,-36450,482400,"Graph"]
["Graph","-","-","-","-","-","-",1200,731.2,"-","-",9350,15000,0.15,2.4500000000000002,900,"-","-","-","-","-","-","Graph"]
["Graph",80475,-1425,24,39.82,1009.5,51.7,75,1007.9,1018.5,75,9400,1500,0.5,0.55000000000000004,75,-0.45,0.5,30.12,476,-4875,606750,"Graph"]
["Graph","-","-","-","-","-","-",1200,630.95000000000005,"-","-",9450,7500,0.25,2.9,6000,-0.1,0.3,27.25,2,"-",225,"Graph"]
["Graph",276075,-12825,326,35.340000000000003,909,46.55,75,911.9,915.4,150,9500,150,0.55000000000000004,0.6,4350,-0.5,0.55000000000000004,27.58,5814,37350,1116450,"Graph"]
["Graph","-","-","-","-","-","-",1200,530.65,"-","-",9550,15000,0.2,2.9,6000,"-",3.1,"-","-","-",600,"Graph"]
["Graph",158475,-25650,507,35.4,812.3,52.3,75,809.1,813.8,150,9600,225,1,1.05,1050,-0.3,1.05,26.68,7086,-21225,1292925,"Graph"]
["Graph","-","-","-","-","-","-",750,744.2,780.3,750,9650,15000,0.2,2.9,6000,"-","-","-","-","-","-","Graph"]
["Graph",188700,-6600,119,"-",704.95,38.200000000000003,75,708.35,714.15,1500,9700,75,1.1000000000000001,1.1499999999999999,24375,-0.25,1.1499999999999999,23.92,19242,-153150,1526625,"Graph"]
["Graph",300,"-","-","-",560.6,"-",750,640.79999999999995,664.4,225,9750,7500,0.45,1.5,300,"-",0.85,"-","-","-",4425,"Graph"]
["Graph",165300,-5400,130,"-",601.95000000000005,34.799999999999997,150,609.1,612.25,150,9800,4050,1.4,1.45,7950,-0.35,1.4,21.42,21268,-1275,1627125,"Graph"]
["Graph",150,"-","-","-",515.95000000000005,"-",750,545.70000000000005,574.29999999999995,750,9850,75,1.2,1.5,75,-0.8,1.1499999999999999,19.309999999999999,711,-9825,76200,"Graph"]
["Graph",464025,-35550,768,25.38,514.9,46.75,75,514.20000000000005,519.95000000000005,75,9900,2250,1.75,1.9,5325,-0.85,1.8,18.95,42839,-5250,2879400,"Graph"]
["Graph",3450,"-",20,20.8,461.2,31.2,600,453,464.4,1125,9950,975,2.15,2.25,75,-1,2.15,17.8,3901,-27000,273300,"Graph"]
["Graph",590625,-20250,969,20.079999999999998,413,45.15,75,414.55,421,75,10000,75,2.75,2.85,75,-1.8,2.75,16.8,66245,364575,5726025,"Graph"]
["Graph",3375,"-",6,21.9,370.95,61.55,600,355,376.1,2100,10050,75,3.15,3.8,75,-2.5,3.3,15.56,5381,34575,221325,"Graph"]
["Graph",522900,-23475,4178,18.25,317.7,48.65,150,318,323.10000000000002,75,10100,2550,4.25,4.5999999999999996,300,-3.9,4.45,14.59,88804,-189075,3073800,"Graph"]
["Graph",40275,-5250,244,16.899999999999999,270.10000000000002,51.25,75,266.39999999999998,270.95,300,10150,75,6.45,6.6,1725,-5.3,6.6,13.86,27350,-31575,442275,"Graph"]
["Graph",1042650,-180375,15204,15.83,224.2,43.25,525,224,225.9,75,10200,7050,9.6999999999999993,9.9,300,-7.95,9.6999999999999993,13.06,180196,426600,5640375,"Graph"]
["Graph",205800,-49500,3107,13.44,175,37.85,2100,169.6,176.65,75,10250,150,14.1,14.45,675,-10.45,14.2,12.2,52930,-261225,848700,"Graph"]
["Graph",2133000,-855450,117957,12.59,133,32,150,133,134,1500,10300,300,20.55,20.95,6675,-16.100000000000001,20.95,11.3,295863,148725,6174225,"Graph"]
["Graph",698700,-601950,37103,11.51,93.5,25.15,600,93.25,94,75,10350,75,29.05,29.4,450,-23.2,29.4,10,79054,522900,1866225,"Graph"]
["Graph",4695750,-348150,297466,10.95,61.6,15.05,375,61.6,61.85,150,10400,75,44.6,45.55,225,-33.049999999999997,44.6,9.02,218281,1449450,3360450,"Graph"]
["Graph",1036425,-93150,59357,10.54,37.200000000000003,8.1,75,37.200000000000003,37.799999999999997,300,10450,150,68.05,70,450,-39.15,68.900000000000006,8.26,11526,174450,329550,"Graph"]
["Graph",5950725,-348150,246865,10.53,21.5,3.75,525,21.45,21.5,1500,10500,150,99.05,99.8,75,-45.95,100,6.7,43389,221475,914925,"Graph"]
["Graph",907650,230025,37309,10.45,11.25,1.5,300,11.1,11.25,75,10550,75,138.80000000000001,148.75,600,-43.2,142.80000000000001,"-",358,2850,16950,"Graph"]
["Graph",4280475,-264150,117574,10.51,5.6,0.25,1425,5.6,5.65,150,10600,75,181.45,182.95,75,-50.05,181.5,"-",3981,-6750,364200,"Graph"]
["Graph",348825,6525,7782,10.63,2.65,-0.15,300,2.6,2.8,600,10650,750,216.1,245.45,4200,"-",417,"-","-","-",600,"Graph"]
["Graph",2405850,-163800,48292,11.46,1.75,-0.2,525,1.65,1.8,6675,10700,300,276.39999999999998,278.64999999999998,75,-44.15,278.89999999999998,"-",836,-36375,160200,"Graph"]
["Graph",230250,3975,1823,12.28,1.2,"-",75,1.05,1.2,375,10750,750,313.14999999999998,344.35,750,"-","-","-","-","-","-","Graph"]
["Graph",2070750,-53850,15567,12.76,0.7,-0.2,75,0.7,0.8,75,10800,75,371.05,376.7,75,-41.25,377.8,"-",117,1650,38100,"Graph"]
["Graph",50850,-2400,80,14.38,0.8,-0.05,1050,0.5,0.8,75,10850,750,413.15,444.15,750,"-","-","-","-","-","-","Graph"]
["Graph",826425,-508725,13485,14.47,0.4,-0.4,3000,0.3,0.4,6825,10900,75,469.4,477.1,75,-103,470,"-",12,450,7575,"Graph"]
["Graph",36375,-5700,102,15.49,0.35,-0.3,75,0.25,0.8,7500,10950,750,512.5,543.95000000000005,750,"-","-","-","-","-","-","Graph"]
["Graph",1317825,-41250,7486,16.72,0.35,-0.35,77625,0.3,0.35,3525,11000,150,571.1,577.29999999999995,150,-44.8,576.45000000000005,"-",836,-18900,823275,"Graph"]
["Graph",1575,"-",5,19.72,0.8,-1.2,1125,0.15,0.8,600,11050,1200,407.95,"-","-","-","-","-","-","-","-","Graph"]
["Graph",336150,750,4801,19.399999999999999,0.4,-0.2,7200,0.3,0.4,3750,11100,150,662.5,680.85,75,-59.35,667.7,"-",2,"-",7050,"Graph"]
["Graph",75,-375,10,20.6,0.4,-0.45,45000,0.05,1,225,11150,1200,508.2,"-","-","-","-","-","-","-","-","Graph"]
["Graph",250950,-1200,290,21.48,0.35,-0.4,11250,0.2,0.35,2775,11200,750,759.4,791.9,2100,-11.15,829.05,47.8,2,-150,3225,"Graph"]
["Graph","-","-","-","-","-","-",7500,0.05,1.7,600,11250,1200,608.5,"-","-","-","-","-","-","-","-","Graph"]
["Graph",119775,-2175,54,24.42,0.45,-0.4,1350,0.1,0.5,600,11300,750,861.3,891.9,2100,-80.849999999999994,890,"-",1,-75,600,"Graph"]
["Graph",5850,"-",9,26.13,0.55000000000000004,-0.45,1500,0.2,0.9,750,11350,1200,708.75,"-","-","-","-","-","-","-","-","Graph"]
["Graph",157050,-1125,137,26.41,0.4,-0.35,7500,0.05,0.5,300,11400,75,959.7,991.85,75,-74.099999999999994,989.75,"-",8,-375,15375,"Graph"]
["Graph",75,"-","-","-",0.5,"-",7500,0.05,1.65,600,11450,1200,809.05,"-","-","-","-","-","-","-","-","Graph"]
["Graph",566850,1875,2027,28.28,0.35,-0.25,6075,0.25,0.4,75,11500,225,1070.95,1075.75,75,-48.2,1071,"-",1404,-91650,948900,"Graph"]
["Graph",300,75,2,31.8,0.75,-0.25,6000,0.05,1.5,3000,11550,1200,909.35,"-","-","-","-","-","-","-","-","Graph"]
["Graph",18450,-150,10,31.24,0.45,0.35,13500,0.1,0.45,375,11600,150,1167.3,1184.2,75,-72.3,1196,41.93,4,-300,12525,"Graph"]
["Graph","-","-","-","-","-","-",6000,0.05,1.5,3000,11650,1200,1009.6,"-","-","-","-","-","-","-","-","Graph"]
["Graph",17400,150,7,29.22,0.1,"-",5100,0.1,0.3,1575,11700,150,1268.1500000000001,1283.75,75,-30.3,1284.75,"-",28,-1575,16725,"Graph"]
["Graph",2475,"-","-","-",0.05,"-",4050,0.05,0.4,300,11750,150,1318.65,1328.9,300,-40.35,1342.45,39.229999999999997,45,-2700,26925,"Graph"]
["Graph",31500,"-","-","-",0.25,"-",600,0.25,1.4,525,11800,750,1363.1,1391.85,75,"-",1406.35,"-","-","-",1425,"Graph"]
["Graph",1350,"-",1,30.46,0.05,"-","-","-",0.05,75,11850,1200,1210.1500000000001,1765.25,150,"-","-","-","-","-","-","Graph"]
["Graph",600,300,8,39.46,0.7,-0.3,150,0.1,0.85,1050,11900,150,1458.15,1477.85,225,"-",1568.7,"-","-","-",750,"Graph"]
["Graph","-","-","-","-","-","-","-","-",1.5,6000,11950,75,1475,1599,75,"-","-","-","-","-","-","Graph"]
["Total",35811225,null,1043665,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1183965,null,43173000,"Total"]
[]
["Top"]
["Note : 10% interest rate is applied while computing implied volatility."]
["highlighted Highlighted options are in-the-money."]

{"sheet":"Greeks","index":5,"n_rows":59,"n_cols":23,"rows_kept":59,"cut":false,"hidden":false,"merged":[[2,6,2,9],[3,6,3,9],[32,1,32,4],[4,17,4,20],[2,17,2,20],[2,12,2,15],[2,1,2,4],[4,6,4,9],[3,17,3,20],[34,17,34,20],[34,6,34,9],[33,17,33,20],[33,6,33,9],[32,17,32,20],[32,6,32,9],[32,12,32,15]]}
["N",{"$f":"F6*365","v":2.9999999999999996},"Today =",{"$f":"TODAY()","v":"2017-11-27"},null,null,null,null,null,null,null,null,"2017-11-30","Current expiry date",null,null,null,null,null,null,null,null,"Holidays"]
[null,null,null,null,null,"ITC",null,null,{"$f":"M1","v":"2017-11-30"},"Chosen expiry date",null,null,null,null,null,null,"Lupin",null,null,{"$f":"M1","v":"2017-11-30"},"Chosen expiry date",null,"2017-01-26"]
[null,"Price of the underlying",null,null,null,260,"Strike price nearest to CMP",null,null,null,{"$f":"ROUND(F3/K4,0)*K4","v":260},null,"Price of the underlying",null,null,null,840,"Strike price nearest to CMP",null,null,null,{"$f":"ROUND(Q3/V4,0)*V4","v":840},"2017-03-13"]
[null,"R : risk free absolute ROI",null,null,7.5,{"$f":"ROUND(LN(1+E4/100), 5)","v":7.2319999999999995E-2},"Strike price interval  ",null,null,null,{"$f":"VLOOKUP(F2, fnoStepValue, 2, FALSE)","v":10},null,"R : risk free absolute ROI",null,null,{"$f":"IF(TODAY() <= WORKDAY(   EOMONTH(TODAY(),0)-MOD(WEEKDAY(EOMONTH(TODAY(),0))+2,7),  0,  W2:W13), WORKDAY(EOMONTH(TODAY(),0)-MOD(WEEKDAY(EOMONTH(TODAY(),0))+2,7),  0,  W2:W13), \"ZZ\")","v":"2017-11-30"},{"$f":"F4","v":7.2319999999999995E-2},"Strike price interval  ",null,null,null,{"$f":"VLOOKUP(Q2, fnoStepValue, 2, FALSE)","v":20},"2017-04-04"]
[null,"o :  Annual absolute volatility",null,null,null,0.3," Dividend yield ",null,null,null,0,null,"o :  Annual volatility",null,null,null,0.3," Dividend yield ",null,null,null,0.01,"2017-04-14"]
[null,"T-t : time to expiration (yrs)",null,null,null,{"$f":"IF(A1=\"N\", IF(DATE_EXPR-TODAY()>1, (DATE_EXPR-TODAY())/365, 1/365), (DATE_NEXT-DATE_TO)/365)","v":8.21917808219178E-3},null,null,null,null,null,null,"T-t : time to expiration (yrs)",null,null,null,{"$f":"F6","v":8.21917808219178E-3},null,null,null,null,null,"2017-05-01"]
[null,"Type","d1","d2","Strike","Premium","Delta ","Theta ","Gamma ","Vega ","Rho ",null,"Type","d1","d2","Strike","Premium","Delta ","Theta ","Gamma ","Vega ","Rho ","2017-06-26"]
[null,"Call:TV",{"$f":"(LN($F$3/E8)+(($F$4-$K$5+(POWER($F$5,2)/2))*$F$6))/($F$5*SQRT($F$6))","v":7.8880478321611918},{"$f":"(LN($F$3/E8)+(($F$4-$K$5-(POWER($F$5,2)/2))*$F$6))/($F$5*SQRT($F$6))","v":7.8608499273264947},{"$f":"E9-K4","v":210},{"$f":"ROUND(($F$3*EXP(-1*$K$5*$F$6)*NORMSDIST(C8))-(E8*EXP(-1*$F$4*$F$6)*NORMSDIST(D8)), 2)","v":50.12},{"$f":"ROUND(EXP(-1*$K$5*$F$6)*NORMSDIST(C8), 5)","v":1},{"$f":"ROUND(((-1*(($F$3*((1/SQRT(2*PI()))*EXP(-1*POWER(C8,2)/2))*$F$5*EXP(-1*$F$6*$K$5))/(2*SQRT($F$6)))+($K$5*$F$3*G8)-($F$4*E8*EXP(-1*$F$4*$F$6)*NORMSDIST(D8))))/365, 6)","v":-4.1584000000000003E-2},{"$f":"ROUND(((((1/SQRT(2*PI()))*EXP(-1*POWER(C8,2)/2))*EXP(-1*$F$6*$K$5))/($F$3*$F$5*SQRT($F$6))), 6)","v":0},{"$f":"ROUND((((1/SQRT(2*PI()))*EXP(-1*C8*C8/2))*EXP(-1*$F$6*$K$5)*$F$3*SQRT($F$6))/100, 6)","v":0},{"$f":"ROUND((E8*$F$6*EXP(-1*$F$4*$F$6)*NORMSDIST(D8)*EXP(-1*$K$5*$F$6))/100, 6)","v":1.7250000000000001E-2},null,"Call: TV",{"$f":"(LN($Q$3/P8)+(($Q$4-$V$5+(POWER($Q$5,2)/2))*$Q$6))/($Q$5*SQRT($Q$6))","v":4.6927801463624874},{"$f":"(LN($Q$3/P8)+(($Q$4-$V$5-(POWER($Q$5,2)/2))*$Q$6))/($Q$5*SQRT($Q$6))","v":4.6655822415277903},{"$f":"P9-$V$4","v":740},{"$f":"($Q$3*EXP(-1*$V$5*$Q$6)*NORMSDIST(N8))-(P8*EXP(-1*$Q$4*$Q$6)*NORMSDIST(O8))","v":100.37070124559068},{"$f":"EXP(-1*$V$5*$Q$6)*NORMSDIST(N8)","v":0.99991646412206803},{"$f":"((-1*(($Q$3*((1/SQRT(2*PI()))*EXP(-1*POWER(N8,2)/2))*$Q$5*EXP(-1*$Q$6*$V$5))/(2*SQRT($Q$6)))+($V$5*$Q$3*R8)-($Q$4*P8*EXP(-1*$Q$4*$Q$6)*NORMSDIST(O8))))/365","v":-0.1235473296413543},{"$f":"((((1/SQRT(2*PI()))*EXP(-1*POWER(N8,2)/2))*EXP(-1*$Q$6*$V$5))/($Q$3*$Q$5*SQRT($Q$6)))","v":2.8840501833313055E-7},{"$f":"(((1/SQRT(2*PI()))*EXP(-1*POWER(N8,2)/2))*EXP(-1*$Q$6*$V$5)*$Q$3*SQRT($Q$6))/100","v":5.017773228555377E-6},{"$f":"(P8*$Q$6*EXP(-1*$Q$4*$Q$6)*NORMSDIST(O8)*EXP(-1*$V$5*$Q$6))/100","v":6.0780685926009506E-2},"2017-08-15"]
[null,{"$f":"IF(E9<$F$3, F9-($F$3-E9), F9)","v":0.13000000000000256},6.1776213887409845,6.1504234839062883,{"$f":"E10-K4","v":220},{"$f":"ROUND(($F$3*EXP(-1*$K$5*$F$6)*NORMSDIST(C9))-(E9*EXP(-1*$F$4*$F$6)*NORMSDIST(D9)), 2)","v":40.130000000000003},{"$f":"ROUND(EXP(-1*$K$5*$F$6)*NORMSDIST(C9), 5)","v":1},{"$f":"ROUND(((-1*(($F$3*((1/SQRT(2*PI()))*EXP(-1*POWER(C9,2)/2))*$F$5*EXP(-1*$F$6*$K$5))/(2*SQRT($F$6)))+($K$5*$F$3*G9)-($F$4*E9*EXP(-1*$F$4*$F$6)*NORMSDIST(D9))))/365, 6)","v":-4.3563999999999999E-2},{"$f":"ROUND(((((1/SQRT(2*PI()))*EXP(-1*POWER(C9,2)/2))*EXP(-1*$F$6*$K$5))/($F$3*$F$5*SQRT($F$6))), 6)","v":0},{"$f":"ROUND((((1/SQRT(2*PI()))*EXP(-1*POWER(C9,2)/2))*EXP(-1*$F$6*$K$5)*$F$3*SQRT($F$6))/100, 6)","v":0},{"$f":"ROUND((E9*$F$6*EXP(-1*$F$4*$F$6)*NORMSDIST(D9)*EXP(-1*$K$5*$F$6))/100, 6)","v":1.8071E-2},null,{"$f":"IF(P9<$Q$3, Q9-($Q$3-P9), Q9)","v":0.38314605063055751},3.7122543579150107,{"$f":"(LN($Q$3/P9)+(($Q$4-$V$5-(POWER($Q$5,2)/2))*$Q$6))/($Q$5*SQRT($Q$6))","v":3.6850564530803132},{"$f":"P10-$V$4","v":760},80.383146050630558,0.99981510934248896,-0.1290134751128498,1.7766009782806952E-5,3.09099365821198E-4,6.2416366591671955E-2,"2017-08-25"]
[null,{"$f":"IF(E10<$F$3, F10-($F$3-E10), F10)","v":0.14000000000000057},4.5432395184829115,4.5160416136482144,{"$f":"E11-K4","v":230},{"$f":"ROUND(($F$3*EXP(-1*$K$5*$F$6)*NORMSDIST(C10))-(E10*EXP(-1*$F$4*$F$6)*NORMSDIST(D10)), 2)","v":30.14},{"$f":"ROUND(EXP(-1*$K$5*$F$6)*NORMSDIST(C10), 5)","v":1},{"$f":"ROUND(((-1*(($F$3*((1/SQRT(2*PI()))*EXP(-1*POWER(C10,2)/2))*$F$5*EXP(-1*$F$6*$K$5))/(2*SQRT($F$6)))+($K$5*$F$3*G10)-($F$4*E10*EXP(-1*$F$4*$F$6)*NORMSDIST(D10))))/365, 6)","v":-4.5560000000000003E-2},{"$f":"ROUND(((((1/SQRT(2*PI()))*EXP(-1*POWER(C10,2)/2))*EXP(-1*$F$6*$K$5))/($F$3*$F$5*SQRT($F$6))), 6)","v":1.9999999999999999E-6},{"$f":"ROUND((((1/SQRT(2*PI()))*EXP(-1*POWER(C10,2)/2))*EXP(-1*$F$6*$K$5)*$F$3*SQRT($F$6))/100, 6)","v":3.0000000000000001E-6},{"$f":"ROUND((E10*$F$6*EXP(-1*$F$4*$F$6)*NORMSDIST(D10)*EXP(-1*$K$5*$F$6))/100, 6)","v":1.8893E-2},null,{"$f":"IF(P10<$Q$3, Q10-($Q$3-P10), Q10)","v":0.41467636524555473},2.7571996740658782,2.7300017692311807,{"$f":"P11-$V$4","v":780},60.414676365245555,0.99700311419054932,-0.16496430528995307,3.9018783703165781E-4,6.7886269596872341E-3,6.3863348513565135E-2,"2017-10-02"]
[null,0.14999999999999858,2.9784272773392155,2.951229372504518,{"$f":"E12-K4","v":240},{"$f":"ROUND(($F$3*EXP(-1*$K$5*$F$6)*NORMSDIST(C11))-(E11*EXP(-1*$F$4*$F$6)*NORMSDIST(D11)), 2)","v":20.149999999999999},{"$f":"ROUND(EXP(-1*$K$5*$F$6)*NORMSDIST(C11), 5)","v":0.99855000000000005},{"$f":"ROUND(((-1*(($F$3*((1/SQRT(2*PI()))*EXP(-1*POWER(C11,2)/2))*$F$5*EXP(-1*$F$6*$K$5))/(2*SQRT($F$6)))+($K$5*$F$3*G11)-($F$4*E11*EXP(-1*$F$4*$F$6)*NORMSDIST(D11))))/365, 6)","v":-5.3020999999999999E-2},{"$f":"ROUND(((((1/SQRT(2*PI()))*EXP(-1*POWER(C11,2)/2))*EXP(-1*$F$6*$K$5))/($F$3*$F$5*SQRT($F$6))), 6)","v":6.6799999999999997E-4},{"$f":"ROUND((((1/SQRT(2*PI()))*EXP(-1*POWER(C11,2)/2))*EXP(-1*$F$6*$K$5)*$F$3*SQRT($F$6))/100, 6)","v":1.114E-3},{"$f":"ROUND((E11*$F$6*EXP(-1*$F$4*$F$6)*NORMSDIST(D11)*EXP(-1*$K$5*$F$6))/100, 6)","v":1.9682999999999999E-2},null,0.71445234687485026,1.8263262064894041,1.7991283016547066,{"$f":"P12-V4","v":800},40.71445234687485,0.96602002782110752,-0.41706380117559283,3.2943678316457478E-3,5.7316584871460713E-2,6.3343481501763735E-2,"2017-10-19"]
[null,0.36999999999999922,1.4775030418746979,1.4503051370400004,{"$f":"E13-K4","v":250},10.37,0.93023,-0.203712,1.8939000000000001E-2,3.1569E-2,1.9026999999999999E-2,null,2.6642990450983461,0.91843963432704601,{"$f":"(LN($Q$3/P12)+(($Q$4-$V$5-(POWER($Q$5,2)/2))*$Q$6))/($Q$5*SQRT($Q$6))","v":0.89124172949234848},{"$f":"P13-V4","v":820},22.664299045098346,0.8207381648965435,-1.1094684932855787,1.1452205344848879E-2,0.19924954745733786,5.4797339167958058E-2,"2017-10-20"]
[null,2.9,3.5453979946741189E-2,8.2560751120437197E-3,{"$f":"K3","v":260},2.9,0.51414000000000004,-0.49580000000000002,5.638E-2,9.3978000000000006E-2,1.0749E-2,null,9.3276426165905946,3.2431990520663694E-2,5.2340856859662225E-3,{"$f":"V3","v":840},9.3276426165905946,0.51289406701384677,-1.5898435334639616,1.7451438520190325E-2,0.30362634295511409,3.4641265560478966E-2,"2017-12-25"]
[null,0.28000000000000003,-1.3521649639470625,-1.3793628687817598,{"$f":"E13+K4","v":270},0.28000000000000003,8.8160000000000002E-2,-0.19295699999999999,2.2613999999999999E-2,3.7693999999999998E-2,1.861E-3,null,2.5580004205454827,-0.83272646757406954,-0.85992437240876707,{"$f":"P13+V4","v":860},2.5580004205454827,0.20248286377372193,-1.1024257967702586,1.2344755463354767E-2,0.21477845231366607,1.3768260519700832E-2]
[null,0.01,-2.689313703598474,-2.7165116084331715,{"$f":"E14+K4","v":280},0.01,3.5799999999999998E-3,-1.2824E-2,1.5169999999999999E-3,2.5279999999999999E-3,7.6000000000000004E-5,null,0.43630017782417951,-1.6779944528995419,-1.7051923577342394,{"$f":"P14+V4","v":880},0.43630017782417951,4.6670254890345458E-2,-0.378248292612064,4.2721418554125682E-3,7.432824558523829E-2,3.1860433771850904E-3]
[null,0,-3.9795351388357458,-4.0067330436704438,{"$f":"E15+$K$4","v":290},0,3.0000000000000001E-5,-1.73E-4,2.0999999999999999E-5,3.4E-5,9.9999999999999995E-7,null,4.481718257815448E-2,-2.5042660347968755,{"$f":"(LN($Q$3/P16)+(($Q$4-$V$5-(POWER($Q$5,2)/2))*$Q$6))/($Q$5*SQRT($Q$6))","v":-2.531463939631573},{"$f":"P15+$V$4","v":900},4.481718257815448E-2,6.1347822958342834E-3,-6.6899544063301578E-2,7.590207316169362E-4,1.3205713024822444E-2,4.1983398038534256E-4]
[null,0,-5.2260117289160135,-5.2532096337507106,{"$f":"E16+$K$4","v":300},0,0,-9.9999999999999995E-7,0,0,0,null,2.7550495162429467E-3,-3.3123763231576149,-3.3395742279923124,{"$f":"P16+$V$4","v":920},2.7550495162429467E-3,4.624970737702143E-4,-6.3613370442619993E-3,7.2369491670485708E-5,1.2591101915185E-3,3.1702256621198435E-5]
[null,0,-6.4316127861400814,-6.4588106909747784,{"$f":"E17+$K$4","v":310},0,0,0,0,0,0,null,1.0225854496138595E-4,-4.1031065412267367,-4.1303044460614347,{"$f":"P17+$V$4","v":940},1.0225854496138595E-4,2.038029563404667E-5,-3.384541508721381E-4,3.8572775379886133E-6,6.7110288430802448E-5,1.3985581785191282E-6]
[null,"Put: TV",{"$f":"ROUND(NORMSDIST(C8),4)","v":1},{"$f":"ROUND(NORMSDIST(D8), 4)","v":1},{"$f":"E8","v":210},{"$f":"(E8*EXP(-1*$F$4*$F$6)*NORMSDIST(-1*D8))-($F$3*EXP(-1*$K$5*$F$6)*NORMSDIST(-1*C8))","v":1.3392466063625865E-15},{"$f":"ROUND(EXP(-1*$K$5*$F$6)*((NORMSDIST(C8))-1), 6)","v":0},{"$f":"ROUND(((-1*(($F$3*((1/SQRT(2*PI()))*EXP(-1*POWER(C8,2)/2))*$F$5*EXP(-1*$F$6*$K$5)))/(2*SQRT($F$6))-($K$5*$F$3*NORMSDIST(-1*C8)*EXP(-1*$F$6*$K$5))+($F$4*E8*EXP(-1*$F$4*$F$6)*NORMSDIST(-1*D8))))/365, 6)","v":0},{"$f":"I8","v":0},0,{"$f":"(-1*E8*$F$6*EXP(-1*$F$4*$F$6)*NORMSDIST(-1*D8)*EXP(-1*$K$5*$F$6))/100","v":-3.2907485501196057E-17},null,"Put: TV",{"$f":"ROUND(NORMSDIST(N8),4)","v":1},{"$f":"ROUND(NORMSDIST(O8), 4)","v":1},{"$f":"P8","v":740},{"$f":"(P8*EXP(-1*$Q$4*$Q$6)*NORMSDIST(-1*O8))-($Q$3*EXP(-1*$V$5*$Q$6)*NORMSDIST(-1*N8))","v":6.0987894045076447E-6},{"$f":"EXP(-1*$V$5*$Q$6)*((NORMSDIST(N8))-1)","v":-1.3474747618284502E-6},{"$f":"((-1*(($Q$3*((1/SQRT(2*PI()))*EXP(-1*POWER(N8,2)/2))*$Q$5*EXP(-1*$Q$6*$V$5)))/(2*SQRT($Q$6))-($V$5*$Q$3*NORMSDIST(-1*N8)*EXP(-1*$Q$6*$V$5))+($Q$4*P8*EXP(-1*$Q$4*$Q$6)*NORMSDIST(-1*O8))))/365","v":-2.4894401070826906E-5},{"$f":"T8","v":2.8840501833313055E-7},5.017773228555377E-6,{"$f":"(-1*P8*$Q$6*EXP(-1*$Q$4*$Q$6)*NORMSDIST(-1*O8)*EXP(-1*$V$5*$Q$6))/100","v":-9.3524717324342009E-8}]
[null,{"$f":"IF(E20<$F$3, F20, F20-(E20-$F$3))","v":3.5655344620452998E-10},{"$f":"ROUND(NORMSDIST(C9),4)","v":1},{"$f":"ROUND(NORMSDIST(D9), 4)","v":1},220,{"$f":"(E9*EXP(-1*$F$4*$F$6)*NORMSDIST(-1*D9))-($F$3*EXP(-1*$K$5*$F$6)*NORMSDIST(-1*C9))","v":3.5655344620452998E-10},{"$f":"ROUND(EXP(-1*$K$5*$F$6)*((NORMSDIST(C9))-1), 6)","v":0},{"$f":"ROUND(((-1*(($F$3*((1/SQRT(2*PI()))*EXP(-1*POWER(C9,2)/2))*$F$5*EXP(-1*$F$6*$K$5)))/(2*SQRT($F$6))-($K$5*$F$3*NORMSDIST(-1*C9)*EXP(-1*$F$6*$K$5))+($F$4*E9*EXP(-1*$F$4*$F$6)*NORMSDIST(-1*D9))))/365, 6)","v":0},0,0,{"$f":"(-1*E9*$F$6*EXP(-1*$F$4*$F$6)*NORMSDIST(-1*D9)*EXP(-1*$K$5*$F$6))/100","v":-6.9824756556106981E-12},null,{"$f":"IF(P20<$Q$3, Q20, Q20-(P20-$Q$3))","v":5.662171951185957E-4},{"$f":"ROUND(NORMSDIST(N9),4)","v":0.99990000000000001},{"$f":"ROUND(NORMSDIST(O9), 4)","v":0.99990000000000001},760,{"$f":"(P9*EXP(-1*$Q$4*$Q$6)*NORMSDIST(-1*O9))-($Q$3*EXP(-1*$V$5*$Q$6)*NORMSDIST(-1*N9))","v":5.662171951185957E-4},{"$f":"EXP(-1*$V$5*$Q$6)*((NORMSDIST(N9))-1)","v":-1.0270225434092032E-4},{"$f":"((-1*(($Q$3*((1/SQRT(2*PI()))*EXP(-1*POWER(N9,2)/2))*$Q$5*EXP(-1*$Q$6*$V$5)))/(2*SQRT($Q$6))-($V$5*$Q$3*NORMSDIST(-1*N9)*EXP(-1*$Q$6*$V$5))+($Q$4*P9*EXP(-1*$Q$4*$Q$6)*NORMSDIST(-1*O9))))/365","v":-1.5306549425317631E-3},1.7766009782806952E-5,3.09099365821198E-4,{"$f":"(-1*P9*$Q$6*EXP(-1*$Q$4*$Q$6)*NORMSDIST(-1*O9)*EXP(-1*$V$5*$Q$6))/100","v":-7.1366279934414319E-6}]
[null,{"$f":"IF(E21<$F$3, F21, F21-(E21-$F$3))","v":3.9905305873217398E-6},1,1,230,{"$f":"(E10*EXP(-1*$F$4*$F$6)*NORMSDIST(-1*D10))-($F$3*EXP(-1*$K$5*$F$6)*NORMSDIST(-1*C10))","v":3.9905305873217398E-6},{"$f":"ROUND(EXP(-1*$K$5*$F$6)*((NORMSDIST(C10))-1), 6)","v":-3.0000000000000001E-6},{"$f":"ROUND(((-1*(($F$3*((1/SQRT(2*PI()))*EXP(-1*POWER(C10,2)/2))*$F$5*EXP(-1*$F$6*$K$5)))/(2*SQRT($F$6))-($K$5*$F$3*NORMSDIST(-1*C10)*EXP(-1*$F$6*$K$5))+($F$4*E10*EXP(-1*$F$4*$F$6)*NORMSDIST(-1*D10))))/365, 6)","v":-1.5E-5},1.9999999999999999E-6,3.0000000000000001E-6,{"$f":"(-1*E10*$F$6*EXP(-1*$F$4*$F$6)*NORMSDIST(-1*D10)*EXP(-1*$K$5*$F$6))/100","v":-5.9518499738704971E-8},null,{"$f":"IF(P21<$Q$3, Q21, Q21-(P21-$Q$3))","v":2.0211845176006715E-2},0.99709999999999999,0.99680000000000002,780,{"$f":"(P10*EXP(-1*$Q$4*$Q$6)*NORMSDIST(-1*O10))-($Q$3*EXP(-1*$V$5*$Q$6)*NORMSDIST(-1*N10))","v":2.0211845176006715E-2},{"$f":"EXP(-1*$V$5*$Q$6)*((NORMSDIST(N10))-1)","v":-2.9146974062805712E-3},{"$f":"((-1*(($Q$3*((1/SQRT(2*PI()))*EXP(-1*POWER(N10,2)/2))*$Q$5*EXP(-1*$Q$6*$V$5)))/(2*SQRT($Q$6))-($V$5*$Q$3*NORMSDIST(-1*N10)*EXP(-1*$Q$6*$V$5))+($Q$4*P10*EXP(-1*$Q$4*$Q$6)*NORMSDIST(-1*O10))))/365","v":-3.3521100189600465E-2},3.9018783703165781E-4,6.7886269596872341E-3,{"$f":"(-1*P10*$Q$6*EXP(-1*$Q$4*$Q$6)*NORMSDIST(-1*O10)*EXP(-1*$V$5*$Q$6))/100","v":-2.0287847503881756E-4}]
[null,2.9371247245583154E-3,0.99860000000000004,0.99839999999999995,240,{"$f":"(E11*EXP(-1*$F$4*$F$6)*NORMSDIST(-1*D11))-($F$3*EXP(-1*$K$5*$F$6)*NORMSDIST(-1*C11))","v":2.9371247245583154E-3},{"$f":"ROUND(EXP(-1*$K$5*$F$6)*((NORMSDIST(C11))-1), 6)","v":-1.449E-3},{"$f":"ROUND(((-1*(($F$3*((1/SQRT(2*PI()))*EXP(-1*POWER(C11,2)/2))*$F$5*EXP(-1*$F$6*$K$5)))/(2*SQRT($F$6))-($K$5*$F$3*NORMSDIST(-1*C11)*EXP(-1*$F$6*$K$5))+($F$4*E11*EXP(-1*$F$4*$F$6)*NORMSDIST(-1*D11))))/365, 6)","v":-5.496E-3},{"$f":"I11","v":6.6799999999999997E-4},1.114E-3,{"$f":"(-1*E11*$F$6*EXP(-1*$F$4*$F$6)*NORMSDIST(-1*D11)*EXP(-1*$K$5*$F$6))/100","v":-3.119904921554721E-5},null,0.30810314017119111,0.96609999999999996,0.96399999999999997,800,{"$f":"(P11*EXP(-1*$Q$4*$Q$6)*NORMSDIST(-1*O11))-($Q$3*EXP(-1*$V$5*$Q$6)*NORMSDIST(-1*N11))","v":0.30810314017119111},{"$f":"EXP(-1*$V$5*$Q$6)*((NORMSDIST(N11))-1)","v":-3.389778377572239E-2},{"$f":"((-1*(($Q$3*((1/SQRT(2*PI()))*EXP(-1*POWER(N11,2)/2))*$Q$5*EXP(-1*$Q$6*$V$5)))/(2*SQRT($Q$6))-($V$5*$Q$3*NORMSDIST(-1*N11)*EXP(-1*$Q$6*$V$5))+($Q$4*P11*EXP(-1*$Q$4*$Q$6)*NORMSDIST(-1*O11))))/365","v":-0.28166021114520567},3.2943678316457478E-3,5.7316584871460713E-2,{"$f":"(-1*P11*$Q$6*EXP(-1*$Q$4*$Q$6)*NORMSDIST(-1*O11)*EXP(-1*$V$5*$Q$6))/100","v":-2.3654692557787799E-3}]
[null,0.220454159406966,0.93020000000000003,0.92649999999999999,250,0.220454159406966,-6.9769999999999999E-2,-0.15420700000000001,1.8939000000000001E-2,3.1569E-2,-1.5091038751354675E-3,null,2.2460651517604902,0.82079999999999997,0.81359999999999999,820,2.2460651517604902,-0.17917964670028638,-0.97010451832515709,1.1452205344848879E-2,0.19924954745733786,-1.2554335358523022E-2]
[null,2.7436003509055382,0.5141,0.50329999999999997,260,2.7436003509055382,-0.48585899999999999,-0.44431500000000002,5.638E-2,9.3978000000000006E-2,-1.0608238915606664E-2,null,8.8975240366185631,0.51290000000000002,0.50209999999999999,840,8.8975240366185631,-0.48702374458298314,-1.4465191735735052,1.7451438520190325E-2,0.30362634295511409,-3.4353132734940665E-2]
[null,0.12425620518260416,8.8200000000000001E-2,8.3900000000000002E-2,270,10.124256205182604,-0.91183899999999996,-0.139492,2.2613999999999999E-2,3.7693999999999998E-2,-2.0317999301332393E-2,null,2.1159971539392473,0.20250000000000001,0.19489999999999999,860,22.115997153939247,-0.79743494782310798,-0.95514105194976784,1.2344755463354767E-2,0.21477845231366607,-5.6868861544657368E-2]
[null,-0.15868281205007406,3.5999999999999999E-3,3.3E-3,280,19.841317187949926,-0.99641999999999997,4.2622E-2,1.5169999999999999E-3,2.5279999999999999E-3,-2.292415306032863E-2,null,-1.758777541613199E-2,4.6699999999999998E-2,4.41E-2,880,39.982412224583868,-0.95324755670648442,-0.22700316286153857,4.2721418554125682E-3,7.432824558523829E-2,-6.9093802456111672E-2]
[null,-0.17227296654391466,0,0,290,29.827727033456085,-0.99996499999999999,5.7252999999999998E-2,2.0999999999999999E-5,3.4E-5,-2.38207192202829E-2,null,-0.42095545729637251,6.1000000000000004E-3,5.7000000000000002E-3,900,59.579044542703627,-0.9937830293009956,8.8305970617258436E-2,7.590207316169362E-4,1.3205713024822444E-2,-7.3502735621849988E-2]
[null,-0.17827019017670409,0,0,300,39.821729809823296,-1,5.9404999999999999E-2,0,0,-2.4642880051489666E-2,null,-0.47490227699245224,5.0000000000000001E-4,4.0000000000000002E-4,920,79.525097723007548,-0.99945531452305969,0.15280456256633257,7.2369491670485708E-5,1.2591101915185E-3,-7.5533591114552698E-2]
[null,-0.18421264276338434,0,0,310,49.815787357236616,-1,6.1386000000000003E-2,0,0,-2.5464311288286839E-2,null,{"$f":"IF(P29<$Q$3, Q29, Q29-(P29-$Q$3))","v":-0.48943975459803823},0,0,940,99.510560245401962,-0.9998974313011959,0.162787830389757,3.8572775379886133E-6,6.7110288430802448E-5,-7.7206618581933936E-2]
[null,null,"N(d1) ­","N(d2) ­  Probability that the stock price will be ATM or ITM by the expiry date"]
[null,null,"N(d1): conditional probability that if the option expires ITM, how far ITM the stock price will be."]
[null,null,null,null,null,"Reliance",null,null,{"$f":"I2","v":"2017-11-30"},"Chosen expiry date",null,null,null,null,null,null,"NIFTY50",null,null,{"$f":"T2","v":"2017-11-30"},"Chosen expiry date"]
[null,"Price of the underlying",null,null,null,950,"Strike price nearest to CMP",null,null,null,{"$f":"ROUND(F33/K34,0)*K34","v":960},null,"Price of the underlying",null,null,null,10400,"Strike price nearest to CMP",null,null,null,{"$f":"ROUND(Q33/V34,0)*V34","v":10400}]
[null,"R : risk free absolute ROI",null,null,null,{"$f":"F4","v":7.2319999999999995E-2},"Strike price interval  ",null,null,null,{"$f":"VLOOKUP(F32, fnoStepValue, 2, FALSE)","v":20},null,"R : risk free absolute ROI",null,null,null,{"$f":"F4","v":7.2319999999999995E-2},"Strike price interval  ",null,null,null,50]
[null,"o :  Annual absolute volatility",null,null,null,0.3," Dividend yield ",null,null,null,1.4999999999999999E-2,null,"o :  Annual absolute volatility",null,null,null,0.25," Dividend yield ",null,null,null,0]
[null,"T-t : time to expiration (yrs)",null,null,null,{"$f":"F6","v":8.21917808219178E-3},null,null,null,null,null,null,"T-t : time to expiration (yrs)",null,null,null,{"$f":"F36","v":8.21917808219178E-3}]
[null,"Type","d1 : N(d1)","d2 : N(d2)","Strike","Premium","Delta ","Theta ","Gamma ","Vega ","Rho ",null,"Type","d1 : N(d1)","d2 : N(d2)","Strike","Premium","Delta ","Theta ","Gamma ","Vega ","Rho "]
[null,"Call:TV",{"$f":"(LN($F$33/E38)+(($F$34-$K$35+(POWER($F$35,2)/2))*$F$36))/($F$35*SQRT($F$36))","v":3.690379176573781},{"$f":"(LN($F$33/E38)+(($F$34-$K$35-(POWER($F$35,2)/2))*$F$36))/($F$35*SQRT($F$36))","v":3.6631812717390835},{"$f":"E39-$K$34","v":860},{"$f":"($F$33*EXP(-1*$K$35*$F$36)*NORMSDIST(C38))-(E38*EXP(-1*$F$34*$F$36)*NORMSDIST(D38))","v":90.394626818859933},{"$f":"EXP(-1*$K$35*$F$36)*NORMSDIST(C38)","v":0.99976477371742722},{"$f":"((-1*(($F$33*((1/SQRT(2*PI()))*EXP(-1*POWER(C38,2)/2))*$F$35*EXP(-1*$F$36*$K$35))/(2*SQRT($F$36)))+($K$35*$F$33*G38)-($F$34*E38*EXP(-1*$F$34*$F$36)*NORMSDIST(D38))))/365","v":-0.13313864229875949},{"$f":"((((1/SQRT(2*PI()))*EXP(-1*POWER(C38,2)/2))*EXP(-1*$F$36*$K$35))/($F$33*$F$35*SQRT($F$36)))","v":1.703300369537413E-5},{"$f":"(((1/SQRT(2*PI()))*EXP(-1*POWER(C38,2)/2))*EXP(-1*$F$36*$K$35)*$F$33*SQRT($F$36))/100","v":3.7904266442651062E-4},{"$f":"(E38*$F$36*EXP(-1*$F$34*$F$36)*NORMSDIST(D38)*EXP(-1*$K$35*$F$36))/100","v":7.0625421661602933E-2},null,"Call: TV",{"$f":"(LN($Q$33/P38)+(($Q$34-$V$35+(POWER($Q$35,2)/2))*$Q$36))/($Q$35*SQRT($Q$36))","v":1.1111162166304465},{"$f":"(LN($Q$33/P38)+(($Q$34-$V$35-(POWER($Q$35,2)/2))*$Q$36))/($Q$35*SQRT($Q$36))","v":1.0884512959348653},{"$f":"P39-$V$34","v":10150},{"$f":"($Q$33*EXP(-1*$V$35*$Q$36)*NORMSDIST(N38))-(P38*EXP(-1*$Q$34*$Q$36)*NORMSDIST(O38))","v":272.01195906617431},{"$f":"EXP(-1*$V$35*$Q$36)*NORMSDIST(N38)","v":0.86674083576364869},{"$f":"((-1*(($Q$33*((1/SQRT(2*PI()))*EXP(-1*POWER(N38,2)/2))*$Q$35*EXP(-1*$Q$36*$V$35))/(2*SQRT($Q$36)))+($V$35*$Q$33*R38)-($Q$34*P38*EXP(-1*$Q$34*$Q$36)*NORMSDIST(O38))))/365","v":-10.186105392514166},{"$f":"((((1/SQRT(2*PI()))*EXP(-1*POWER(N38,2)/2))*EXP(-1*$Q$36*$V$35))/($Q$33*$Q$35*SQRT($Q$36)))","v":9.1292908929766121E-4},{"$f":"(((1/SQRT(2*PI()))*EXP(-1*POWER(N38,2)/2))*EXP(-1*$Q$36*$V$35)*$Q$33*SQRT($Q$36))/100","v":2.0289536362692133},{"$f":"(P38*$Q$36*EXP(-1*$Q$34*$Q$36)*NORMSDIST(O38)*EXP(-1*$V$35*$Q$36))/100","v":0.71852816982540579}]
[null,{"$f":"IF(E39<$F$33, F39-($F$33-E39), F39)","v":0.42282190146079301},2.8451111912483085,2.8179132864136109,{"$f":"E40-$K$34","v":880},70.422821901460793,0.99765719745880344,-0.16489378819617473,2.6969002501928574E-4,6.0015266526552025E-3,7.2102193621373656E-2,null,{"$f":"IF(P39<$Q$33, Q39-($Q$33-P39), Q39)","v":30.238142310870899},0.89430474535151783,0.8716398246559367,{"$f":"P40-$V$34","v":10200},230.2381423108709,0.81442056915181138,-12.139533358583741,1.1346248474851995E-3,2.5216648665205308,0.67723855700284663]
[null,{"$f":"IF(E40<$F$33, F40-($F$33-E40), F40)","v":0.62815575721708683},2.0188396093509753,1.9916417045162778,{"$f":"E41-$K$34","v":900},50.628155757217087,0.97812745515822985,-0.359732895041801,2.0117200977884408E-3,4.4767661628182499E-2,7.220421482006957E-2,null,{"$f":"IF(P40<$Q$33, Q40-($Q$33-P40), Q40)","v":41.409775275208631},0.6785534811017796,0.65588856040619836,{"$f":"P41-$V$34","v":10250},191.40977527520863,0.75128958677725921,-13.960052995312255,1.344436734885583E-3,2.9879646009292737,0.62646591182533873]
[null,1.8638958798746899,1.2107293209902352,1.1835314161555377,{"$f":"E42-K34","v":920},31.86389587987469,0.88689106998300937,-0.95138431845482918,7.4180340255140765E-3,0.165076661293803,6.662323393910588E-2,null,56.033420605881474,0.46385210550324796,0.44118718480766678,{"$f":"P42-V34","v":10300},156.03342060588147,0.67862314546503599,-15.441720392940951,1.5198523110205142E-3,3.3778197115064144,0.56725868155319115]
[null,6.3052716620745741,0.41999910292111775,0.39280119808642028,{"$f":"E43-K34","v":940},16.305271662074574,0.66267524075855289,-1.6683832928592879,1.4134903824683904E-2,0.31455001730409593,5.0396762240138983E-2,null,74.518527236715272,0.25019045008293628,0.22752552938735501,{"$f":"P43-V34","v":10350},124.51852723671527,0.59877996490430407,-16.399055998763409,1.6403258704126803E-3,3.6455680714486745,0.50159943351518199]
[null,6.2770730280541329,-0.35408292015345677,-0.3812808249881543,{"$f":"K33","v":960},6.2770730280541329,0.36159378806161863,-1.6660928283345653,1.4500156654438852E-2,0.32267814363199887,2.7714694604861166E-2,null,97.129141915117543,3.755849338306156E-2,1.4893572687480334E-2,{"$f":"V33","v":10400},97.129141915117543,0.51498014898195332,-16.703677067332276,1.6912826981142258E-3,3.7588178759185205,0.43221899239702993]
[null,1.7100726763705865,-1.1122033462691805,-1.139401251103878,{"$f":"E43+K34","v":980},1.7100726763705865,0.13300896536547466,-0.9449568624975625,8.3173913713155759E-3,0.18509044222879667,1.0243814609726693E-2,null,73.952183885609884,-0.17405364185940236,-0.19671856255498363,{"$f":"P43+V34","v":10450},73.952183885609884,0.4309116527215664,-16.310474028765103,1.6670326990827528E-3,3.7049230835504905,0.36226265789742568]
[null,0.31767886136550771,-1.8550071556179817,-1.8822050604526792,{"$f":"E44+K34","v":1000},0.31767886136550771,3.1793682366916071E-2,-0.31211261355108372,2.7630110262060071E-3,6.1486457699611759E-2,2.4561069862693344E-3,null,54.888565554872457,-0.38465569146587725,-0.40732061216145848,{"$f":"P44+V34","v":10500},54.888565554872457,0.35024626349743659,-15.266019637206718,1.5717860020620061E-3,3.493240561295067,0.29487719793028505]
[null,3.9589024806675255E-2,-2.5831010075722181,-2.6102989124069156,{"$f":"E45+$K$34","v":1020},3.9589024806675255E-2,4.8952290005422E-3,-6.1826342063370052E-2,5.4916375823720694E-4,1.2220774318580036E-2,3.7892959695398908E-4,null,39.668537688590277,-0.59425725250394723,-0.61692217319952847,{"$f":"P45+$V$34","v":10550},39.668537688590277,0.27617003258747674,-13.697207149814547,1.4185308355201167E-3,3.1526362021203251,0.23280820284009593]
[null,3.3025316250355208E-3,-3.2970562175459364,-3.3242541223806339,{"$f":"E46+$K$34","v":1040},3.3025316250355208E-3,4.8845948885980334E-4,-7.5616341644864481E-3,6.7310230498450084E-5,1.497883143078523E-3,3.7863878093702561E-5,null,27.887481034091252,-0.80286778591153685,-0.82553270660711808,{"$f":"P46+$V$34","v":10600},27.887481034091252,0.21102557863014915,-11.783974608374507,1.2261684344027056E-3,2.7251173533903414,0.1780913865796816]
[null,1.85633564643857E-4,-3.9974114502914331,-4.0246093551261302,{"$f":"E47+$K$34","v":1060},1.85633564643857E-4,3.2015519961449098E-5,-5.8698193048237549E-4,5.23283364780502E-6,1.1644846932683913E-4,2.4842781165894099E-6,null,19.054460822356532,-1.0104966190594127,-1.0331615397549938,{"$f":"P47+$V$34","v":10650},19.054460822356532,0.15612870921602562,-9.724198390147329,1.0157638039068691E-3,2.257500267751376,0.1318918450704912]
[null,"Put: TV",{"$f":"ROUND(NORMSDIST(C38),4)","v":0.99990000000000001},{"$f":"ROUND(NORMSDIST(D38), 4)","v":0.99990000000000001},{"$f":"E38","v":860},{"$f":"(E38*EXP(-1*$F$34*$F$36)*NORMSDIST(-1*D38))-($F$33*EXP(-1*$K$35*$F$36)*NORMSDIST(-1*C38))","v":7.0136163002365581E-4},{"$f":"EXP(-1*$K$35*$F$36)*((NORMSDIST(C38))-1)","v":-1.1194621095250761E-4},{"$f":"((-1*(($F$33*((1/SQRT(2*PI()))*EXP(-1*POWER(C38,2)/2))*$F$35*EXP(-1*$F$36*$K$35)))/(2*SQRT($F$36))-($K$35*$F$33*NORMSDIST(-1*C38)*EXP(-1*$F$36*$K$35))+($F$34*E38*EXP(-1*$F$34*$F$36)*NORMSDIST(-1*D38))))/365","v":-1.8783732085865497E-3},{"$f":"I38","v":1.703300369537413E-5},3.7904266442651062E-4,{"$f":"(-1*E38*$F$36*EXP(-1*$F$34*$F$36)*NORMSDIST(-1*D38)*EXP(-1*$K$35*$F$36))/100","v":-8.7975669756933071E-6},null,"Put: TV",{"$f":"ROUND(NORMSDIST(N38),4)","v":0.86670000000000003},{"$f":"ROUND(NORMSDIST(O38), 4)","v":0.86180000000000001},{"$f":"P38","v":10150},{"$f":"(P38*EXP(-1*$Q$34*$Q$36)*NORMSDIST(-1*O38))-($Q$33*EXP(-1*$V$35*$Q$36)*NORMSDIST(-1*N38))","v":15.980480599336715},{"$f":"EXP(-1*$V$35*$Q$36)*((NORMSDIST(N38))-1)","v":-0.13325916423635131},{"$f":"((-1*(($Q$33*((1/SQRT(2*PI()))*EXP(-1*POWER(N38,2)/2))*$Q$35*EXP(-1*$Q$36*$V$35)))/(2*SQRT($Q$36))-($V$35*$Q$33*NORMSDIST(-1*N38)*EXP(-1*$Q$36*$V$35))+($Q$34*P38*EXP(-1*$Q$34*$Q$36)*NORMSDIST(-1*O38))))/365","v":-8.1762100405216227},{"$f":"T38","v":9.1292908929766121E-4},2.0289536362692133,{"$f":"(-1*P38*$Q$36*EXP(-1*$Q$34*$Q$36)*NORMSDIST(-1*O38)*EXP(-1*$V$35*$Q$36))/100","v":-0.11522266756088138}]
[null,{"$f":"IF(E50<$F$33, F50, F50-(E50-$F$33))","v":1.7011757596677946E-2},{"$f":"ROUND(NORMSDIST(C39),4)","v":0.99780000000000002},{"$f":"ROUND(NORMSDIST(D39), 4)","v":0.99760000000000004},880,1.7011757596677946E-2,-2.2195224695764023E-3,-2.9673134175967231E-2,2.6969002501928574E-4,6.0015266526552025E-3,-1.7468186833471261E-4,null,{"$f":"IF(P50<$Q$33, Q50, Q50-(P50-$Q$33))","v":24.176952127447066},{"$f":"ROUND(NORMSDIST(N39),4)","v":0.81440000000000001},{"$f":"ROUND(NORMSDIST(O39), 4)","v":0.80830000000000002},10200,24.176952127447066,-0.18557943084818862,-10.119737044266111,1.1346248474851995E-3,2.5216648665205308,-0.16061942736563906]
[null,{"$f":"IF(E51<$F$33, F51, F51-(E51-$F$33))","v":0.2104609267187989},0.97819999999999996,0.9768,900,0.2104609267187989,-2.1749264770149896E-2,-0.22055185609155895,2.0117200977884408E-3,4.4767661628182499E-2,-1.7153169307685305E-3,null,{"$f":"IF(P51<$Q$33, Q51, Q51-(P51-$Q$33))","v":35.318873375199018},0.75129999999999997,0.74409999999999998,10250,35.318873375199018,-0.24871041322274079,-11.93035571866954,1.344436734885583E-3,2.9879646009292737,-0.21549921952534545]
[null,1.4343163627422513,0.88700000000000001,0.88170000000000004,920,1.4343163627422513,-0.11298564994537039,-0.80824289457455256,{"$f":"I41","v":7.4180340255140765E-3},0.165076661293803,-8.9389540728619515E-3,null,49.91280698928631,0.67859999999999998,0.67049999999999998,10300,49.91280698928631,-0.32137685453496401,-13.402122153973146,1.5198523110205142E-3,3.3778197115064144,-0.27881359677969142]
[null,5.8638074583079174,0.66279999999999994,0.65280000000000005,940,5.8638074583079174,-0.3372014791698269,-1.5212814840489768,1.4134903824683904E-2,0.31455001730409593,-2.6808082032958577E-2,null,68.3682019035341,0.5988,0.59,10350,68.3682019035341,-0.40122003509569593,-14.349556797470518,1.6403258704126803E-3,3.6455680714486745,-0.34857999179989912]
[null,5.8237241376533575,0.36159999999999998,0.35149999999999998,960,15.823724137653358,-0.63828293186676122,-1.5150306345942195,1.4500156654438852E-2,0.32267814363199887,-5.1132805929366129E-2,null,90.949104865351728,0.51500000000000001,0.50590000000000002,10400,90.949104865351728,-0.48501985101804668,-14.644276903714298,1.6912826981142258E-3,3.7588178759185205,-0.42206757990024957]
[null,1.2448390993356497,0.13300000000000001,0.1273,980,31.24483909933565,-0.8668677545629051,-0.78993428382718212,8.3173913713155759E-3,0.18509044222879667,-7.0246342185630348E-2,null,67.742435119259426,0.43090000000000001,0.42199999999999999,10450,117.74243511925943,-0.5690883472784336,-14.241172902822042,1.6670326990827528E-3,3.7049230835504905,-0.4961310613820521]
[null,-0.15943940230340559,3.1800000000000002E-2,2.9899999999999999E-2,1000,49.840560597696594,-0.96808303756146374,-0.15312964995066886,2.7630110262060071E-3,6.1486457699611759E-2,-7.9676706070217429E-2,null,48.649105071935992,0.35020000000000001,0.34189999999999998,10500,148.64910507193599,-0.64975373650256341,-13.186817548938571,1.5717860020620061E-3,3.493240561295067,-0.56762366833139122]
[null,-0.44941392549651482,4.8999999999999998E-3,4.4999999999999997E-3,1020,69.550586074503485,-0.99498149092783761,0.10111700646707944,5.4916375823720694E-4,1.2220774318580036E-2,-8.3396539720662535E-2,null,33.399365489069169,0.2762,0.26860000000000001,10550,183.39936548906917,-0.72382996741252326,-11.608104099221311,1.4185308355201167E-3,3.1526362021203251,-0.63379981040377886]
[null,-0.49758510531239608,5.0000000000000001E-4,4.0000000000000002E-4,1040,89.502414894687604,-0.99938826043952,0.15934209929599763,6.7310230498450084E-5,1.497883143078523E-3,-8.5380261700652549E-2,null,21.588597117983227,0.21099999999999999,0.20449999999999999,10600,221.58859711798323,-0.78897442136985085,-9.6849705954561873,1.2261684344027056E-3,2.7251173533903414,-0.69262377364639161]
[null,-0.51258669000708323,0,0,1060,109.48741330999292,-0.99984470440841833,0.17027713646003625,5.23283364780502E-6,1.1644846932683913E-4,-8.7058297561759396E-2,null,12.725865189662727,0.15609999999999999,0.15079999999999999,10650,262.72586518966273,-0.84387129078397438,-7.6152934149039231,1.0157638039068691E-3,2.257500267751376,-0.74293046213778036]