{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Option Strategy Visualiser"],"not_rendered":{"charts":7,"images":2,"macros":1,"external_links":0,"defined_names":1,"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":"Option Strategy Visualiser","index":0,"n_rows":106,"n_cols":26,"rows_kept":106,"cut":false,"hidden":false,"merged":[[6,6,6,7],[8,4,8,5],[11,22,11,23],[3,14,3,15],[4,14,4,15],[5,14,5,15],[3,10,3,11],[4,10,4,11],[5,10,5,11],[6,10,6,11],[7,10,7,11],[4,22,4,23],[5,22,5,23],[6,18,6,19],[3,22,3,24],[10,22,10,23],[55,21,57,22],[55,24,57,25],[55,17,57,18],[19,24,20,25],[17,24,18,25],[17,22,18,23],[24,24,25,25],[27,24,28,25],[30,22,31,23],[30,24,31,25],[33,22,34,23],[33,24,34,25],[19,22,20,23],[1,1,2,2],[1,3,2,4],[55,5,57,6],[55,9,57,10],[55,13,57,14],[7,14,7,15],[6,14,6,15],[6,1,6,2],[7,6,7,7],[7,1,7,3],[55,1,57,2],[3,1,3,2],[3,3,3,4],[3,6,3,7],[4,6,4,7],[5,6,5,7],[2,22,2,24],[8,22,8,24],[24,22,25,23],[27,22,28,23],[1,5,2,5],[2,6,2,8],[2,10,2,12],[2,14,2,16],[2,18,2,20],[15,22,15,23],[12,22,12,23],[9,22,9,24],[7,18,7,19],[3,18,3,19],[4,18,4,19],[5,18,5,19]]}
[]
[null,"UNDERLYING SECURITY",null,"TSLA"]
[null,null,null,null,null,null,"LEG 1",null,null,null,"LEG 2",null,null,null,"LEG 3",null,null,null,"LEG 4",null,null,null,"LEG 5"]
[null,"PX_LAST",null,{"$f":"IFERROR(BDP(D3,B4),F2)","v":0},null,null,"OPTION",null,"CALL",null,"OPTION:",null,null,null,"OPTION:",null,null,null,"OPTION:",null,null,null,"SHARES"]
[null,null,null,null,null,null,"QUANTITY",null,1,null,"QUANTITY",null,null,null,"QUANTITY",null,null,null,"QUANTITY",null,null,null,"QUANTITY"]
[null,null,null,null,null,null,"STRIKE PRICE",null,5,null,"STRIKE PRICE",null,null,null,"STRIKE PRICE",null,null,null,"STRIKE PRICE",null,null,null,"Price"]
[null,"UNDERLYING PRICE",null,"P/L",null,null,"PREMIUM",null,3,null,"PREMIUM",null,null,null,"PREMIUM",null,null,null,"PREMIUM"]
[null,null,null,null,null,null,"UNDERLYING PRICE",null,{"$f":"IF($D$4=\"\",\"\",$D$4)","v":0},null,"UNDERLYING PRICE",null,{"$f":"IF($I$8=\"\",\"\",$I$8)","v":0},null,"UNDERLYING PRICE",null,{"$f":"IF($I$8=\"\",\"\",$I$8)","v":0},null,"UNDERLYING PRICE",null,{"$f":"IF($I$8=\"\",\"\",$I$8)","v":0}]
[null,null,null,{"$f":"Z61","v":-300},"^Reset^",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEG 6"]
[null,null,null,-300,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FUTURES"]
[null,{"$f":"B63","v":-20},null,-300,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QUANTITY"]
[null,-19,null,-300,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FUTURES PRICE"]
[null,-18,null,-300,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CURNT UNDERLYING PX",null,{"$f":"IF($I$8=\"\",\"\",$I$8)","v":0}]
[null,-17,null,-300]
[null,-16,null,-300]
[null,-15,null,-300,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GRAPH INTERVALS SIZE",null,1]
[null,-14,null,-300]
[null,-13,null,-300,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ENTER CUSTOM UNDERLYNG PX"]
[null,-12,null,-300]
[null,-11,null,-300,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PROFIT/LOSS",null,{"$f":"Table137[[#Totals],[P/L ]]","v":-300}]
[null,-10,null,-300]
[null,-9,null,-300]
[null,-8,null,-300]
[null,-7,null,-300]
[null,-6,null,-300,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAX PROFIT POTENTIAL",null,{"$f":"IF(D9>D10,\"UNLIMITED\",IF(D53>D52,\"UNLIMITED\",MAX(D9:D53)))","v":"UNLIMITED"}]
[null,-5,null,-300]
[null,-4,null,-300]
[null,-3,null,-300,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAX LOSS POTENTIAL",null,{"$f":"IF(D9<D10,\"UNLIMITED\",IF(D53<D52,\"UNLIMITED\",MIN(D9:D53)))","v":-300}]
[null,-2,null,-300]
[null,-1,null,-300]
[null,0,null,-300,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Net premium flow",null,{"$f":"-(I5*I7*100+M5*M7*100+Q5*Q7*100+U5*U7*100)","v":-300}]
[null,1,null,-300]
[null,2,null,-300]
[null,3,null,-300,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL STRATEGY COST",null,{"$f":"(I5*I7*100+M5*M7*100+Q5*Q7*100+U5*U7*100+Y5*Y6+Y11*Y12*100)","v":300}]
[null,4,null,-300]
[null,5,null,-300]
[null,6,null,-200]
[null,7,null,-100]
[null,8,null,0]
[null,9,null,100]
[null,10,null,200]
[null,11,null,300]
[null,12,null,400]
[null,13,null,500]
[null,14,null,600]
[null,15,null,700]
[null,16,null,800]
[null,17,null,900]
[null,18,null,1000]
[null,19,null,1100]
[null,20,null,1200]
[null,21,null,1300]
[null,22,null,1400]
[]
[]
[null,"LEG 1",null,null,null,"LEG 2",null,null,null,"LEG 3",null,null,null,"LEG 4",null,null,null,"LEG 5",null,null,null,"LEG 6",null,null,"COMBINED"]
[]
[]
[null,"UNDRLYNG PX","P/L ",null,null,"UNDRLNG PX","P/L ",null,null,"UNDRLYNG PX","P/L ",null,null,"UNDRLYNG PX","P/L ",null,null,"UNDRLYNG PX","P/L ",null,null,"UNDRLYNG PX","P/L ",null,"UNDRLYNG PX","P/L "]
[]
[null,{"$f":"B62-$Y$16","v":-22},{"$f":"IF(I$4=\"CALL\",(IF(B61-(I$6+I$7)<-I$7,-I$7,B61-(I$6+I$7)))*(I$5*100),(IF((I$6-I$7)-B61<-I$7,-I$7,(I$6-I$7)-B61))*(I$5*100))","v":-300},null,null,{"$f":"B61","v":-22},{"$f":"IF(M$4=\"CALL\",(IF(F61-(M$6+M$7)<-M$7,-M$7,F61-(M$6+M$7)))*(M$5*100),(IF((M$6-M$7)-F61<-M$7,-M$7,(M$6-M$7)-F61))*(M$5*100))","v":0},null,null,{"$f":"B61","v":-22},{"$f":"IF(Q$4=\"CALL\",(IF(J61-(Q$6+Q$7)<-Q$7,-Q$7,J61-(Q$6+Q$7)))*(Q$5*100),(IF((Q$6-Q$7)-J61<-Q$7,-Q$7,(Q$6-Q$7)-J61))*(Q$5*100))","v":0},null,null,{"$f":"B61","v":-22},{"$f":"IF(U$4=\"CALL\",(IF(N61-(U$6+U$7)<-U$7,-U$7,N61-(U$6+U$7)))*(U$5*100),(IF((U$6-U$7)-N61<-U$7,-U$7,(U$6-U$7)-N61))*(U$5*100))","v":0},null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":-22},{"$f":"IFERROR((R61-Y$6)*$Y$5,0)","v":0},null,null,{"$f":"B61","v":-22},{"$f":"(V61-Y$12)*($Y$11*100)","v":0},null,{"$f":"B61","v":-22},{"$f":"C61+G61+K61+O61+S61+W61","v":-300}]
[null,-21,-300,null,null,-21,0,null,null,-21,0,null,null,-21,{"$f":"IF(U$4=\"CALL\",(IF(N62-(U$6+U$7)<-U$7,-U$7,N62-(U$6+U$7)))*(U$5*100),(IF((U$6-U$7)-N62<-U$7,-U$7,(U$6-U$7)-N62))*(U$5*100))","v":0},null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":-21},0,null,null,-21,{"$f":"(V62-Y$12)*($Y$11*100)","v":0},null,-21,-300]
[null,-20,-300,null,null,-20,0,null,null,-20,0,null,null,-20,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":-20},0,null,null,-20,0,null,-20,-300]
[null,-19,-300,null,null,-19,0,null,null,-19,0,null,null,-19,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":-19},0,null,null,-19,0,null,-19,-300]
[null,-18,-300,null,null,-18,0,null,null,-18,0,null,null,-18,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":-18},0,null,null,-18,0,null,-18,-300]
[null,-17,-300,null,null,-17,0,null,null,-17,0,null,null,-17,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":-17},0,null,null,-17,0,null,-17,-300]
[null,-16,-300,null,null,-16,0,null,null,-16,0,null,null,-16,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":-16},0,null,null,-16,0,null,-16,-300]
[null,-15,-300,null,null,-15,0,null,null,-15,0,null,null,-15,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":-15},0,null,null,-15,0,null,-15,-300]
[null,-14,-300,null,null,-14,0,null,null,-14,0,null,null,-14,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":-14},0,null,null,-14,0,null,-14,-300]
[null,-13,-300,null,null,-13,0,null,null,-13,0,null,null,-13,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":-13},0,null,null,-13,0,null,-13,-300]
[null,-12,-300,null,null,-12,0,null,null,-12,0,null,null,-12,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":-12},0,null,null,-12,0,null,-12,-300]
[null,-11,-300,null,null,-11,0,null,null,-11,0,null,null,-11,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":-11},0,null,null,-11,0,null,-11,-300]
[null,-10,-300,null,null,-10,0,null,null,-10,0,null,null,-10,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":-10},0,null,null,-10,0,null,-10,-300]
[null,-9,-300,null,null,-9,0,null,null,-9,0,null,null,-9,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":-9},0,null,null,-9,0,null,-9,-300]
[null,-8,-300,null,null,-8,0,null,null,-8,0,null,null,-8,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":-8},0,null,null,-8,0,null,-8,-300]
[null,-7,-300,null,null,-7,0,null,null,-7,0,null,null,-7,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":-7},0,null,null,-7,0,null,-7,-300]
[null,-6,-300,null,null,-6,0,null,null,-6,0,null,null,-6,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":-6},0,null,null,-6,0,null,-6,-300]
[null,-5,-300,null,null,-5,0,null,null,-5,0,null,null,-5,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":-5},0,null,null,-5,0,null,-5,-300]
[null,-4,-300,null,null,-4,0,null,null,-4,0,null,null,-4,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":-4},0,null,null,-4,0,null,-4,-300]
[null,-3,-300,null,null,-3,0,null,null,-3,0,null,null,-3,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":-3},0,null,null,-3,0,null,-3,-300]
[null,-2,-300,null,null,-2,0,null,null,-2,0,null,null,-2,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":-2},0,null,null,-2,0,null,-2,-300]
[null,-1,-300,null,null,-1,0,null,null,-1,0,null,null,-1,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":-1},0,null,null,-1,0,null,-1,-300]
[null,{"$f":"I8","v":0},-300,null,null,0,0,null,null,0,0,null,null,0,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":0},0,null,null,0,0,null,0,-300]
[null,{"$f":"B83+$Y$16","v":1},-300,null,null,1,0,null,null,1,0,null,null,1,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":1},0,null,null,1,0,null,1,-300]
[null,2,-300,null,null,2,0,null,null,2,0,null,null,2,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":2},0,null,null,2,0,null,2,-300]
[null,3,-300,null,null,3,0,null,null,3,0,null,null,3,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":3},0,null,null,3,0,null,3,-300]
[null,4,-300,null,null,4,0,null,null,4,0,null,null,4,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":4},0,null,null,4,0,null,4,-300]
[null,5,-300,null,null,5,0,null,null,5,0,null,null,5,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":5},0,null,null,5,0,null,5,-300]
[null,6,-200,null,null,6,0,null,null,6,0,null,null,6,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":6},0,null,null,6,0,null,6,-200]
[null,7,-100,null,null,7,0,null,null,7,0,null,null,7,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":7},0,null,null,7,0,null,7,-100]
[null,8,0,null,null,8,0,null,null,8,0,null,null,8,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":8},0,null,null,8,0,null,8,0]
[null,9,100,null,null,9,0,null,null,9,0,null,null,9,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":9},0,null,null,9,0,null,9,100]
[null,10,200,null,null,10,0,null,null,10,0,null,null,10,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":10},0,null,null,10,0,null,10,200]
[null,11,300,null,null,11,0,null,null,11,0,null,null,11,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":11},0,null,null,11,0,null,11,300]
[null,12,400,null,null,12,0,null,null,12,0,null,null,12,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":12},0,null,null,12,0,null,12,400]
[null,13,500,null,null,13,0,null,null,13,0,null,null,13,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":13},0,null,null,13,0,null,13,500]
[null,14,600,null,null,14,0,null,null,14,0,null,null,14,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":14},0,null,null,14,0,null,14,600]
[null,15,700,null,null,15,0,null,null,15,0,null,null,15,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":15},0,null,null,15,0,null,15,700]
[null,16,800,null,null,16,0,null,null,16,0,null,null,16,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":16},0,null,null,16,0,null,16,800]
[null,17,900,null,null,17,0,null,null,17,0,null,null,17,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":17},0,null,null,17,0,null,17,900]
[null,18,1000,null,null,18,0,null,null,18,0,null,null,18,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":18},0,null,null,18,0,null,18,1000]
[null,19,1100,null,null,19,0,null,null,19,0,null,null,19,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":19},0,null,null,19,0,null,19,1100]
[null,20,1200,null,null,20,0,null,null,20,0,null,null,20,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":20},0,null,null,20,0,null,20,1200]
[null,21,1300,null,null,21,0,null,null,21,0,null,null,21,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":21},0,null,null,21,0,null,21,1300]
[null,22,1400,null,null,22,0,null,null,22,0,null,null,22,0,null,null,{"$f":"Table13[[#This Row],[UNDRLYNG PX]]","v":22},0,null,null,22,0,null,22,1400]
[null,{"$f":"$Y$18","v":0},-300,null,null,{"$f":"$Y$18","v":0},0,null,null,{"$f":"$Y$18","v":0},0,null,null,{"$f":"$Y$18","v":0},{"$f":"IF(U$4=\"CALL\",(IF(N106-(U$6+U$7)<-U$7,-U$7,N106-(U$6+U$7)))*(U$5*100),(IF((U$6-U$7)-N106<-U$7,-U$7,(U$6-U$7)-N106))*(U$5*100))","v":0},null,null,{"$f":"$Y$18","v":0},0,null,null,{"$f":"$Y$18","v":0},{"$f":"(V106-Y$12)*$Y$11","v":0},null,{"$f":"$Y$18","v":0},{"$f":"C106+G106+K106+O106+W106","v":-300}]