{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Home","Holidays","APEX","Help"],"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":"Home","index":0,"n_rows":70,"n_cols":14,"rows_kept":70,"cut":false,"hidden":false,"merged":[[1,6,1,8],[1,11,1,16]]}
[]
[null,"APEX Performance Account Planner",null,null,null,null,"Get your own APEX account",null,null,null,null,"Share with a friend - https://aeromir.com/paplanner"]
[null,"Version 1.02  Tom Nunamaker - aeromir.com",null,null,null,null,null,null,null,null,null,null,"Year","Accounts"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MONTH(TODAY())<10,YEAR(TODAY()),YEAR(TODAY())+1)","v":2025},4]
[null,"Days required to trade",8,null,"Date","Withdrawal","To Trader","Account Profit","Trader %","Scaling",null,"Month","Payouts","Payouts"]
[null,"Account size",150000,null,{"$f":"C15","v":"2025-01-14"},{"$f":"-MIN($C$17,$C$8)","v":-2750},{"$f":"F6*I6","v":-2750},{"$f":"C16+F6","v":5250},{"$f":"IF(SUM($G$5:G5)<-25000, 0.9, 1)","v":1},1,null,"2024-01-01",{"$f":"IFERROR(-1*SUMIFS($G$6:$G$1001,\n  $E$6:$E$1001,\">=\"&DATE($M$4,MONTH(L6),1),\n  $E$6:$E$1001,\"<=\"&EOMONTH(DATE($M$4,MONTH(L6),1),0)),\"\")","v":5150},{"$f":"IF(ISNUMBER(M6),M6*$N$4,\"\")","v":20600}]
[null,"Drawdown",{"$f":"VLOOKUP(C6, APEX!B5:C11, 2, FALSE)","v":5000},null,{"$f":"WORKDAY(E6, 8, Holidays!$B$5:$B$200)","v":"2025-01-27"},{"$f":"-MIN($C$17*$C$18,$C$8)","v":-2400},-2400,{"$f":"$C$5*$C$12+H6+F7","v":6050},1,{"$f":"MIN($C$21, CEILING(H6/$C$20,1))","v":1},null,"2024-02-01",{"$f":"IFERROR(-1*SUMIFS($G$6:$G$1001,\n  $E$6:$E$1001,\">=\"&DATE($M$4,MONTH(L7),1),\n  $E$6:$E$1001,\"<=\"&EOMONTH(DATE($M$4,MONTH(L7),1),0)),\"\")","v":4800},19200]
[null,"Withdrawal Initial",{"$f":"VLOOKUP(C6, APEX!B5:E11, 4, FALSE)","v":2750},null,{"$f":"WORKDAY(E7, 8, Holidays!$B$5:$B$200)","v":"2025-02-06"},{"$f":"-MIN($C$17*$C$18,$C$8)","v":-2400},-2400,{"$f":"$C$5*$C$12+H7+F8","v":6850},1,1,null,"2024-03-01",7200,28800]
[null,"Safety Net",{"$f":"C7+100","v":5100},null,{"$f":"WORKDAY(E8, 8, Holidays!$B$5:$B$200)","v":"2025-02-18"},{"$f":"-MIN($C$17*$C$18,$C$8)","v":-2400},-2400,{"$f":"$C$5*$C$12+H8+F9","v":7650},1,1,null,"2024-04-01",7200,28800]
[null,"Initial target",{"$f":"C9+C8","v":7850},null,{"$f":"WORKDAY(E9, 8, Holidays!$B$5:$B$200)","v":"2025-03-03"},{"$f":"-MIN($C$17*$C$18,$C$8)","v":-2400},-2400,{"$f":"$C$5*$C$12+H9+F10","v":8450},1,1,null,"2024-05-01",6720,26880]
[null,"Starting Profit",0,{"$f":"IF(C11>0,C11/C10,\"\")","v":""},{"$f":"WORKDAY(E10, 8, Holidays!$B$5:$B$200)","v":"2025-03-13"},{"$f":"IF((H10 + ($C$17 * J11)) > $C$24,\n    MIN(($C$24 - H10 - ($C$17 * J11)), J11*$C$17*-1*$C$18),\n    J11*$C$17*-1*$C$18)","v":-2400},-2400,{"$f":"$C$17*J11+H10+F11","v":9250},1,1,null,"2024-06-01",12960,51840]
[null,"Profit/Day",{"$f":"CEILING(C7*0.08,5)","v":400},null,{"$f":"WORKDAY(E11, 8, Holidays!$B$5:$B$200)","v":"2025-03-25"},-2400,-2400,10050,1,1,null,"2024-07-01",12960,51840]
[null,"Trading Days to 1st target",{"$f":"CEILING((C10-C11)/C12,1)","v":20},null,{"$f":"WORKDAY(E12, 8, Holidays!$B$5:$B$200)","v":"2025-04-04"},-2400,-2400,10850,1,1,null,"2024-08-01",10800,43200]
[null,"Start Date",{"$f":"TODAY()","v":"2024-12-14"},null,{"$f":"WORKDAY(E13, 8, Holidays!$B$5:$B$200)","v":"2025-04-16"},-2400,-2400,11650,1,1,null,"2024-09-01",24525,98100]
[null,"Projected Date",{"$f":"WORKDAY(C14, C13, Holidays!$B5:$B200)","v":"2025-01-14"},null,{"$f":"WORKDAY(E14, 8, Holidays!$B$5:$B$200)","v":"2025-04-28"},-2400,-2400,12450,1,1,null,"2024-10-01",25920,103680]
[null,"Projected Profit",{"$f":"C12*C13","v":8000},null,{"$f":"WORKDAY(E15, 8, Holidays!$B$5:$B$200)","v":"2025-05-08"},-2400,-2400,13250,1,1,null,"2024-11-01",17280,69120]
[null,"Profit per Pay Period",{"$f":"C5*C12","v":3200},null,{"$f":"WORKDAY(E16, 8, Holidays!$B$5:$B$200)","v":"2025-05-20"},-4800,-4320,14850,0.9,2,null,"2024-12-01",25920,103680]
[null,"% Profit per Withdrawal",0.75,null,{"$f":"WORKDAY(E17, 8, Holidays!$B$5:$B$200)","v":"2025-06-02"},-4800,-4320,16450,0.9,2,null,"Total Payouts",{"$f":"SUM(M6:M17)","v":161435},645740]
[null,"Drawdown Multiple",2.5,null,{"$f":"WORKDAY(E18, 8, Holidays!$B$5:$B$200)","v":"2025-06-12"},-4800,-4320,18050,0.9,2,null,"Ending Balance",{"$f":"IFERROR(__xludf.DUMMYFUNCTION(\"VLOOKUP(LARGE(FILTER($E:$E, YEAR($E:$E)=$M$4), 1), $E:$H, 4, FALSE)\"),30000)","v":30000}]
[null,"Scaling Balance",{"$f":"C9*C19","v":12750},null,{"$f":"WORKDAY(E19, 8, Holidays!$B$5:$B$200)","v":"2025-06-25"},-4800,-4320,19650,0.9,2,null,"Payouts + Balance",{"$f":"M19+M18","v":191435}]
[null,"Max scale",3,null,{"$f":"WORKDAY(E20, 8, Holidays!$B$5:$B$200)","v":"2025-07-08"},-4800,-4320,21250,0.9,2]
[null,"Required Daily Profit",{"$f":"C8/C5","v":343.75},null,{"$f":"WORKDAY(E21, 8, Holidays!$B$5:$B$200)","v":"2025-07-18"},-4800,-4320,22850,0.9,2]
[null,"Max withdrawal multiplier",6,null,{"$f":"WORKDAY(E22, 8, Holidays!$B$5:$B$200)","v":"2025-07-30"},-4800,-4320,24450,0.9,2]
[null,"100% withdrawal threshold",{"$f":"FLOOR(C9*$C$23, 1000)","v":30000},null,{"$f":"WORKDAY(E23, 8, Holidays!$B$5:$B$200)","v":"2025-08-11"},-4800,-4320,26050,0.9,2]
[null,null,null,null,{"$f":"WORKDAY(E24, 8, Holidays!$B$5:$B$200)","v":"2025-08-21"},-7200,-6480,28450,0.9,3]
[null,"Largest Daily Profit",0,null,{"$f":"WORKDAY(E25, 8, Holidays!$B$5:$B$200)","v":"2025-09-03"},-8050,-7245,30000,0.9,3]
[null,"Required Profit (30% Rule)",{"$f":"IF(C26>0,C26/0.3,\"\")","v":""},null,{"$f":"WORKDAY(E26, 8, Holidays!$B$5:$B$200)","v":"2025-09-15"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E27, 8, Holidays!$B$5:$B$200)","v":"2025-09-25"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E28, 8, Holidays!$B$5:$B$200)","v":"2025-10-07"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E29, 8, Holidays!$B$5:$B$200)","v":"2025-10-17"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E30, 8, Holidays!$B$5:$B$200)","v":"2025-10-29"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E31, 8, Holidays!$B$5:$B$200)","v":"2025-11-10"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E32, 8, Holidays!$B$5:$B$200)","v":"2025-11-20"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E33, 8, Holidays!$B$5:$B$200)","v":"2025-12-03"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E34, 8, Holidays!$B$5:$B$200)","v":"2025-12-15"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E35, 8, Holidays!$B$5:$B$200)","v":"2025-12-26"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E36, 8, Holidays!$B$5:$B$200)","v":"2026-01-08"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E37, 8, Holidays!$B$5:$B$200)","v":"2026-01-21"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E38, 8, Holidays!$B$5:$B$200)","v":"2026-02-02"},-9600,-8640,30000,0.9,{"$f":"MIN($C$21, CEILING(H38/$C$20,1))","v":3}]
[null,null,null,null,{"$f":"WORKDAY(E39, 8, Holidays!$B$5:$B$200)","v":"2026-02-12"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E40, 8, Holidays!$B$5:$B$200)","v":"2026-02-25"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E41, 8, Holidays!$B$5:$B$200)","v":"2026-03-09"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E42, 8, Holidays!$B$5:$B$200)","v":"2026-03-19"},{"$f":"IF((H42 + ($C$17 * J43)) > $C$24,\n    MIN(($C$24 - H42 - ($C$17 * J43)), J43*$C$17*-1*$C$18),\n    J43*$C$17*-1*$C$18)","v":-9600},-8640,{"$f":"$C$17*J43+H42+F43","v":30000},0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E43, 8, Holidays!$B$5:$B$200)","v":"2026-03-31"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E44, 8, Holidays!$B$5:$B$200)","v":"2026-04-13"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E45, 8, Holidays!$B$5:$B$200)","v":"2026-04-23"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E46, 8, Holidays!$B$5:$B$200)","v":"2026-05-05"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E47, 8, Holidays!$B$5:$B$200)","v":"2026-05-15"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E48, 8, Holidays!$B$5:$B$200)","v":"2026-05-28"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E49, 8, Holidays!$B$5:$B$200)","v":"2026-06-09"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E50, 8, Holidays!$B$5:$B$200)","v":"2026-06-22"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E51, 8, Holidays!$B$5:$B$200)","v":"2026-07-02"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E52, 8, Holidays!$B$5:$B$200)","v":"2026-07-15"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E53, 8, Holidays!$B$5:$B$200)","v":"2026-07-27"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E54, 8, Holidays!$B$5:$B$200)","v":"2026-08-06"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E55, 8, Holidays!$B$5:$B$200)","v":"2026-08-18"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E56, 8, Holidays!$B$5:$B$200)","v":"2026-08-28"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E57, 8, Holidays!$B$5:$B$200)","v":"2026-09-10"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E58, 8, Holidays!$B$5:$B$200)","v":"2026-09-22"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E59, 8, Holidays!$B$5:$B$200)","v":"2026-10-02"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E60, 8, Holidays!$B$5:$B$200)","v":"2026-10-14"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E61, 8, Holidays!$B$5:$B$200)","v":"2026-10-26"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E62, 8, Holidays!$B$5:$B$200)","v":"2026-11-05"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E63, 8, Holidays!$B$5:$B$200)","v":"2026-11-17"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E64, 8, Holidays!$B$5:$B$200)","v":"2026-11-30"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E65, 8, Holidays!$B$5:$B$200)","v":"2026-12-10"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E66, 8, Holidays!$B$5:$B$200)","v":"2026-12-22"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E67, 8, Holidays!$B$5:$B$200)","v":"2027-01-04"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E68, 8, Holidays!$B$5:$B$200)","v":"2027-01-14"},-9600,-8640,30000,0.9,3]
[null,null,null,null,{"$f":"WORKDAY(E69, 8, Holidays!$B$5:$B$200)","v":"2027-01-26"},-9600,-8640,30000,0.9,3]

{"sheet":"Holidays","index":1,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Trading Holidays"]
[]
[null,"Holidays"]
[null,"2024-12-25"]
[null,"2025-01-01"]
[null,"2025-01-15"]
[null,"2025-02-19"]
[null,"2025-03-29"]
[null,"2025-05-27"]
[null,"2025-06-19"]
[null,"2025-07-04"]
[null,"2025-09-02"]
[null,"2025-11-28"]
[null,"2025-12-25"]
[null,"2026-01-01"]
[null,"2026-01-19"]
[null,"2026-02-16"]
[null,"2026-04-03"]
[null,"2026-05-25"]
[null,"2026-06-19"]
[null,"2026-07-03"]
[null,"2026-09-07"]
[null,"2026-11-26"]
[null,"2026-12-25"]

{"sheet":"APEX","index":2,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"APEX Accounts"]
[]
[null,"Account Size","Drawdown","Profit Target","Initial Withdrawals"]
[null,25000,1500,1500,1500]
[null,50000,2500,3000,2000]
[null,75000,3750,4250,2250]
[null,100000,3000,6000,2500]
[null,150000,5000,9000,2750]
[null,250000,6500,15000,3000]
[null,300000,7500,20000,3500]

{"sheet":"Help","index":3,"n_rows":45,"n_cols":5,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Help"]
[]
[null,"This spreadsheet helps you plan your APEX Performance Account (PA) growth."]
[null,"The RESET button resets all of the formulae in the spreadsheet"]
[]
[null,"The fields with a blue background are fields you can change"]
[]
[null,"Days required to trade",8,null,"Number of trading days to request a payout. This shouldn't change."]
[null,"Account size",150000,null,"The APEX account size"]
[null,"Drawdown",5000,null,"The allowed trailing drawdown"]
[null,"Withdrawal Initial",2750,null,"The allowed initial withdrawal for the first five payout periods"]
[null,"Safety Net",5100,null,"Your APEX required safety. Before you reach this amount of profit you have to trade 1/2 the size normally allowed for your account"]
[null,"Initial target",7850,null,"This is the safety net plus the maximum you are allowed to withdraw in the first five payouts"]
[null,"Profit/Day",333.33333333333331,null,"This is the AVERAGE DAILY NET PROFIT you generate for this account"]
[null,"Trading Days to 1st target",24,null,"This is how many TRADING DAYS it will take to reach your initial profit target. This excludes weekends and holidays"]
[null,"Start Date","2024-12-07",null,"This is the first day you traded this PA account. It defaults to today"]
[null,"Projected Date","2025-01-13",null,"This is the projected date you will reach your initial profit target"]
[null,"Projected Profit",8000,null,"This is the projected profit you will created for your initial payout"]
[null,"Profit per Pay Period",2666.6666666666665,null,"This is the projected profit per payout period after the 1st payout"]
[null,"% Profit per Withdrawal",0.75,null,"This is the percentage of your generated profits you wish to withdraw"]
[null,"Drawdown Multiple",2.5,null,"This is a mutliple of your drawdown used to calcuate the profit needed to increase the number of contracts traded"]
[null,"Scaling Balance",12750,null,"This is the threshold where you will increase the number of contracts traded"]
[null,"Max scale",3,null,"This is the maximum scaling factor. "]
[null,"Required Daily Profit",343.75,null,"This is the required profit per day required to reach your maximum withdrawal during payouts 2-5"]
[null,"Max withdrawal multiplier",6,null,"This is a factor to multiply your drawdown by to calculate the maximum profit you want to leave in your account"]
[null,"100% withdrawal threshold",30000,null,"This is the calculated maximum profit you want to leave in your account."]
[]
[]
[null,null,null,null,"The year shows the totals per month for the year you have selected"]
[null,null,null,null,"The number above Accounts is how many accounts like this you have"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Total payouts are for the selected year"]
[null,null,null,null,"The ending balance is the account value at the end of the year"]
[null,null,null,null,"This value is the total of your payouts + the account ending balance"]