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

{"sheet":"Locke","index":0,"n_rows":74,"n_cols":15,"rows_kept":74,"cut":false,"hidden":false,"merged":[[31,4,31,6],[29,4,29,6]]}
[]
["Locke In Your Success 2014 Profit Plan for website account",null,null,null,null,"Examples on website will be demonstrated with fluctuating capital amounts for demonstration purposes "]
[null,null,null,null,null,"Trades are real time simulated trades. Simulated trades are believed to be represented as accurately as possible, however live results may have been different"]
[null,null,null,null,null,"This spreadsheet is corrected to assume a $400,000 portfolio using a consistent trade size for the entire year "]
[null,null,null,null,null,null,"This plan is shared as an example for educational purposes ONLY, it does not imply that the information stated is accurate nor that it is possible"]
[]
[null,"ACCOUNT","PC","PROFIT",null,"WINS","PROFIT","ANNUAL PROFIT","Account Size"]
["STRATEGY","ALLOCATION","ALLOCATION","TARGET","MAX LOSS","LOSSES","(LOSS)","(ON PLANNED CAPITAL)",400000]
[null,null,null,"30% adj to 20% "]
[null,null,null," for reduced PT"]
["Bearish Butterfly",0.125,{"$f":"B12/(B15+B18+B12+B21)","v":0.25},0.2,0.3,9,{"$f":"D11*F11","v":1.8},{"$f":"G11+G12","v":0.90000000000000013}]
[null,{"$f":"B11*I8","v":50000},null,null,null,3,{"$f":"E11*F12*-1","v":-0.89999999999999991},null,{"$f":"I8*B11*H11","v":45000.000000000007}]
[]
["M3 Butterfly",0.125,{"$f":"B15/(B12+B15+B18+B21)","v":0.25},0.1,0.1,9,{"$f":"D14*F14","v":0.9},{"$f":"G14+G15","v":0.6}]
[null,{"$f":"B14*I8","v":50000},null,null,null,3,{"$f":"E14*F15*-1","v":-0.30000000000000004},null,{"$f":"I8*B14*H14","v":30000}]
[]
["ROCK ",0.125,{"$f":"B18/(B18+B15+B12+B21)","v":0.25},0.2,0.2,9,{"$f":"D17*F17","v":1.8},{"$f":"G17+G18","v":1.2}]
[null,{"$f":"I8*B17","v":50000},null,null,null,3,{"$f":"E17*F18*-1","v":-0.60000000000000009},null,{"$f":"I8*B17*H17","v":60000}]
[]
["V Trade",0.125,{"$f":"B21/(B18+B15+B12+B21)","v":0.25},0.1,0.1,9,{"$f":"D20*F20","v":0.9},{"$f":"G20+G21","v":0.6}]
[null,50000,null,null,null,3,{"$f":"E20*F21*-1","v":-0.30000000000000004},null,{"$f":"H20*B20*I8","v":30000}]
[]
["Reserve",{"$f":"1-(B11+B14+B17+B20)","v":0.5},null,null,null,null,null,0]
[null,{"$f":"B23*I8","v":200000},null,null,null,null,null,null,0]
[]
[]
["Totals",{"$f":"B11+B14+B17+B23+B20","v":1}]
[null,{"$f":"B12+B15+B18+B21+B24","v":400000}]
[null,null,null,null,null,null,null,"Estimated","Actual YTD"]
[null,null,null,null,"Annual Return on Planned Capital (Expected Capital Needed for Trades) ",null,null,{"$f":"(C11*H11)+(C14*H14)+(C17*H17)+(H20*C20)","v":0.82500000000000007},{"$f":"(C11*N43)+(C14*N51)+(C17*N59)+(C20*N67)","v":0.94484000000000001}]
[null,null,null,null,null,null,null,{"$f":"(B12+B15+B18+B21)*H30","v":165000},{"$f":"(B12+B15+B18+B21)*I30","v":188968}]
[null,null,null,null,"Annual Return Corrected for Reserve (Entire Account)",null,null,{"$f":"(B14+B11+B17+D34+B20)/B27*H30","v":0.41250000000000003},{"$f":"(B14+B11+B17+B20)/B27*I30","v":0.47242000000000001}]
[null,null,null,null,null,null,null,{"$f":"I8*H32","v":165000},{"$f":"I8*I32","v":188968}]
[]
[]
[]
[]
[null,"January","Febraury","March","April","May","June","July","August","September","October","November","December","Totals"]
["Bearish Butterfly "]
[]
["Target Profit per Plan (%)",0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3]
["Max Loss per Plan (%)",0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3]
["Actual P/L on PC (%)",0.121,0.26400000000000001,-0.23400000000000001,0.28599999999999998,0.19400000000000001,0.13700000000000001,0.1,0.108,0.11799999999999999,0.13600000000000001,0.10100000000000001,0.13100000000000001,{"$f":"B43+C43+D43+E43+F43+G43+H43+I43+J43+K43+L43+M43","v":1.462}]
["Wins",1,1,0,1,1,1,1,1,1,1,1,1,{"$f":"SUM(B44:M44)","v":11},"Wins"]
["Losses",0,0,1,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B45:M45)","v":1},"Losses"]
[]
["M3"]
[]
["Target Profit per Plan (%)",0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1]
["Max Loss per Plan (%)",0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1]
["Actual P/L on PC (%)",5.8000000000000003E-2,3.2000000000000001E-2,0.10299999999999999,4.3999999999999997E-2,0.114,5.3400000000000003E-2,8.7099999999999997E-2,0.10299999999999999,7.3899999999999993E-2,0.11899999999999999,8.8999999999999996E-2,1.5900000000000001E-2,{"$f":"B51+C51+D51+E51+F51+G51+H51+I51+J51+K51+L51+M51","v":0.89229999999999998}]
["Wins",1,1,1,1,1,1,1,1,1,1,1,1,{"$f":"SUM(B52:M52)","v":12},"Wins"]
["Losses",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B53:M53)","v":0},"Losses"]
[]
["ROCK"]
[]
["Target Profit per Plan (%)",0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2]
["Max Loss per Plan (%)",0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2]
["Actual P/L on PC (%)",0.127,4.2999999999999997E-2,0.17399999999999999,6.3E-2,0.10299999999999999,9.0999999999999998E-2,0.104,0.10199999999999999,9.5600000000000004E-2,5.1459999999999999E-2,0.2,3.7999999999999999E-2,{"$f":"B59+C59+D59+E59+F59+G59+H59+I59+J59+K59+L59+M59","v":1.1920599999999999}]
["Wins",1,1,1,1,1,1,1,1,1,1,1,1,{"$f":"SUM(B60:M60)","v":12},"Wins"]
["Losses",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B61:M61)","v":0},"Losses"]
[]
["V-Trade"]
[]
["Target Profit per Plan (%)",0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1]
["Max Loss per Plan (%)",0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1]
["Actual P/L on PC (%)",0.10299999999999999,3.9E-2,-5.5E-2,3.5000000000000003E-2,2.5000000000000001E-2,5.2999999999999999E-2,-9.4E-2,1.2999999999999999E-2,6.5600000000000006E-2,2.3300000000000001E-2,-5.8999999999999999E-3,3.1E-2,{"$f":"B67+C67+D67+E67+F67+G67+H67+I67+J67+K67+L67+M67","v":0.23299999999999998}]
["Wins",1,1,0,1,1,1,0,1,1,1,0,1,{"$f":"SUM(B68:M68)","v":9},"Wins"]
["Losses",0,0,1,0,0,0,1,0,0,0,1,0,{"$f":"SUM(B69:M69)","v":3},"Losses"]
[]
["Below is assuming PC for all trades are the same   "]
["Combined Avg P/L on PC (%)  ",{"$f":"(B43+B51+B59+B67)/4","v":0.10224999999999999},{"$f":"(C43+C51+C59+C67)/4","v":9.4500000000000001E-2},{"$f":"(D43+D51+D59+D67)/4","v":-3.0000000000000044E-3},0.10699999999999998,0.109,8.3599999999999994E-2,4.9274999999999992E-2,8.1500000000000003E-2,8.8274999999999992E-2,8.2439999999999999E-2,9.6024999999999999E-2,5.3975000000000002E-2,{"$f":"SUM(B72:M72)","v":0.9448399999999999}]
["Combined Wins",{"$f":"B44+B52+B60+B68","v":4},{"$f":"C44+C52+C60+C68","v":4},2,4,4,4,3,4,4,4,3,4,44,"Wins"]
["Combined Losses",{"$f":"B45+B61+B69+B53","v":0},{"$f":"C45+C61+C69+C53","v":0},2,0,0,0,1,0,0,0,1,0,4,"Losses"]