Spreadsheet: 217302d1362039898-calculating-streaks-of-wins-and-losses-projecting-profits-version-1-dd-included
Sheet:  Graph 3

 | Change cell D4 to the approximate number of trades that you are likely to take per year.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year 1 | 10 | January | 5297.302003871485 | -702.6979961285151 | -0.1326520548790601 | -0.1171163326880859
 |  |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | February | 5209.426035764104 | -87.87596810738069 | -0.0168686468536243 | -0.1376638608541694
 | Number of Trades (Year) |  | 120 | 240 | 360 | 480 | 600 | 720 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | March | 5629.744665555256 | 420.3186297911516 | 0.08068424945580409 | -0.1346622411992247
 | Average Per Month |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 | April | 5554.907257551112 | -74.83740800414398 | -0.01329321531436859 | -0.1168882264561195
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | May | 5902.75396305135 | 347.8467055002384 | 0.06261971431249189 | -0.07727435544818473
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60 | June | 6272.382729874554 | 369.6287668232035 | 0.06261971431249165 | -0.02000000000000002
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 | July | 6422.669020244195 | 150.2862903696414 | 0.02396000002580313 | -0.03959999999999997
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80 | August | 7202.930778458793 | 780.2617582145976 | 0.1214855935679107 | -0.02000000000000002
 | First Month |  |  |  |  |  |  |  |  | Second Month |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 90 | September | 8105.05397980097 | 902.1232013421768 | 0.1252439082213704 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | October | 8937.759364244888 | 832.7053844439188 | 0.1027390300569432 | -0.02000000000000002
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 110 | November | 9307.490516183147 | 369.7311519382583 | 0.04136732002624187 | -0.0428077360000001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 120 | December | 9692.516455007302 | 385.0259388241557 | 0.04136732002624147 | -0.06820728022410982
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year 2 | 130 | January | 11472.18326750859 | 1779.666812501284 | 0.1836124623324091 | 0.0169999999999999
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 140 | February | 12190.56810626052 | 718.3848387519356 | 0.06261971431249173 | -0.02000000000000002
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 150 | March | 13218.30407998115 | 1027.73597372063 | 0.08430583093111398 | -0.02000000000000002
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 160 | April | 13086.29855492863 | -132.0055250525256 | -0.009986570459704075 | -0.05880800000000008
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 170 | May | 14430.77217549756 | 1344.473620568939 | 0.1027390300569428 | -0.02978683905051016
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 180 | June | 14191.38275149793 | -239.3894239996334 | -0.01658881597521856 | -0.08071254965439989
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 190 | July | 15336.40381754258 | 1145.021066044654 | 0.08068424945580403 | -0.03625703965571414
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200 | August | 16968.72661722002 | 1632.322799677437 | 0.1064345213582796 | -0.00334000000000001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 210 | September | 18399.28921452766 | 1430.562597307642 | 0.08430583093111382 | -0.01999999999999991
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 220 | October | 19551.4474486943 | 1152.158234166636 | 0.06261971431249193 | -0.02000000000000002
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 230 | November | 21560.14419578245 | 2008.69674708815 | 0.1027390300569433 | -0.01999999999999991
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 240 | December | 21635.19074624433 | 75.0465504618769 | 0.003480800025287278 | -0.02978683905050972
 |  |  |  | Gain (%) |  |  |  |  |  |  |  |  | Gain (%) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year 3 | 250 | January | 22153.5699170826 | 518.3791708382705 | 0.02396000002580317 | -0.03960000000000008
 | Account Balance |  | 5297.302003871485 | -0.1326520548790601 |  |  |  |  |  | Account Balance |  | 5209.426035764104 | -0.0168686468536243 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 260 | February | 22230.68206381018 | 77.1121467275807 | 0.003480800025287102 | -0.07763184000000001
 | Peak Drawdown |  | -0.1171163326880859 |  |  |  |  |  |  | Peak Drawdown |  | -0.1376638608541694 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 270 | March | 21861.90137005004 | -368.7806937601417 | -0.01658881597521868 | -0.04600475816175997
 | Losing Streak |  |  |  |  |  |  |  |  | Losing Streak |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 280 | April | 22766.26964040703 | 904.3682703569939 | 0.0413673200262418 | -0.04919110226949974
 | Winning Streak |  |  |  |  |  |  |  |  | Winning Streak |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 290 | May | 24111.0860388667 | 1344.816398459665 | 0.05907056446668799 | -0.02653546751199998
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 300 | June | 24195.01190776048 | 83.92586889378799 | 0.003480800025287156 | -0.06195158128
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 310 | July | 24857.7492762775 | 662.7373685170169 | 0.02739148759436839 | -0.05236680398791949
 | Year 1 |  |  |  |  |  |  |  |  | Year 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 320 | August | 25886.04774572136 | 1028.298469443856 | 0.04136732002624199 | -0.06183040966984876
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 330 | September | 28545.55518312448 | 2659.507437403128 | 0.102739030056943 | -0.02000000000000002
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 340 | October | 27602.77111237089 | -942.7840707535979 | -0.03302735100808099 | -0.0776318399999999
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 350 | November | 28840.9525601383 | 1238.181447767416 | 0.04485714288347279 | -0.05553189886259968
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 360 | December | 29038.33017131112 | 197.3776111728184 | 0.006843657842481189 | -0.03959999999999997
 |  |  |  | Gain (%) |  |  |  |  |  |  |  |  | Gain (%)
 | Account Balance |  | 9692.516455007302 | 0.6154194091678837 |  |  |  |  |  | Account Balance |  | 21635.19074624433 | 1.232154141463155
 | Peak Drawdown |  | -0.1376638608541694 |  |  |  |  |  |  | Peak Drawdown |  | -0.08071254965439989
 | Losing Streak |  |  |  |  |  |  |  |  | Losing Streak
 | Winning Streak |  |  |  |  |  |  |  |  | Winning Streak
 | Year 3 |  |  |  |  |  |  |  |  | Year 4
 |  |  |  | Gain (%) |  |  |  |  |  |  |  |  | Gain (%)
 | Account Balance |  | 29038.33017131112 | 0.3421804555317781 |  |  |  |  |  | Account Balance |  | 80408.7008000546 | 1.769053878982878
 | Peak Drawdown |  | -0.07763184000000001 |  |  |  |  |  |  | Peak Drawdown
 | Losing Streak |  |  |  |  |  |  |  |  | Losing Streak
 | Winning Streak |  |  |  |  |  |  |  |  | Winning Streak