Spreadsheet: 217157d1361995077-fnding-lowest-number-within-a-range-simple-sample
Sheet:  Graph 3

 | This is on the assumption that 26 trades are taken on average per month (320 trades per year) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year 1 |  | January | 6294.221923653977 | 294.2219236539768 | 0.04674476483714011 | -0.03960000000000008
 |  |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 | February | 6533.066639694992 | 238.8447160410151 | 0.03655935706973992 | -0.04670116677300806
 | Number of Trades (Year) |  | 240 | 480 | 720 | 960 | 1200 | 1440 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60 | March | 6645.355221291547 | 112.2885815965556 | 0.01718772940632333 | -0.04670116677300806
 | Average Per Month |  | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80 | April | 7399.002442015836 | 753.6472207242887 | 0.1134096215518506 | -0.04670116677300806
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | May | 8532.339098427003 | 1133.336656411167 | 0.1531742508929883
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 120 | June | 9944.405103956078 | 1412.066005529075 | 0.1654957672497334
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 140 | July | 10588.52950206035 | 644.1243981042735 | 0.06477254208479784
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 160 | August | 11677.03174180756 | 1088.502239747209 | 0.1028001328735407
 | First Month |  |  |  |  |  |  |  |  | Second Month |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 180 | September | 12619.88351330525 | 942.8517714976861 | 0.08074413021606945
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200 | October | 14051.09972657763 | 1431.216213272386 | 0.1134096215518505
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 220 | November | 14803.05644891572 | 751.9567223380836 | 0.05351586259940627
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 240 | December | 18409.16740088747 | 3606.110951971748 | 0.2436058367011014
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year 2 | 260 | January | 20715.95128141831 | 2306.783880530846 | 0.1253062580342249
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 280 | February | 23188.23713313616 | 2472.285851717847 | 0.1193421348666438
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 300 | March | 24559.34014826131 | 1371.103015125151 | 0.05912924761174857
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 320 | April | 28746.01665806578 | 4186.676509804474 | 0.170471864656383
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 340 | May | 30445.746994892 | 1699.730336826215 | 0.05912924761174836
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 360 | June | 36751.6888694923 | 6305.941874600307 | 0.2071206160800811
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 380 | July | 46144.3160332792 | 9392.627163786892 | 0.2555699466530841
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 400 | August | 50618.25167623881 | 4473.935642959616 | 0.0969552921693112
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 420 | September | 53327.13107796658 | 2708.879401727769 | 0.0535158625994064
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 440 | October | 59374.9408319647 | 6047.809753998125 | 0.1134096215518507
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 460 | November | 59819.96329165362 | 445.0224596889166 | 0.007495122579546844
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 480 | December | 59062.954824244 | -757.0084674096215 | -0.01265477987204387
 |  |  |  | Gain (%) |  |  |  |  |  |  |  |  | Gain (%) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year 3 | 500 | January | 61304.19684663368 | 2241.242022389684 | 0.0379466626595137
 | Account Balance |  | 6294.221923653977 | 0.04674476483714011 |  |  |  |  |  | Account Balance |  | 6533.066639694992 | 0.03655935706973992 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 520 | February | 69649.67613321487 | 8345.47928658119 | 0.1361322668896437
 | Peak Drawdown |  | -0.03960000000000008 |  |  |  |  |  |  | Peak Drawdown |  | -0.04670116677300806 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 540 | March | 77961.81717572309 | 8312.141042508214 | 0.1193421348666441
 | Losing Streak |  |  |  |  |  |  |  |  | Losing Streak |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 560 | April | 85976.3023404501 | 8014.485164727012 | 0.1028001328735406
 | Winning Streak |  |  |  |  |  |  |  |  | Winning Streak |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 580 | May | 101169.0388224466 | 15192.73648199647 | 0.1767084192785597
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 600 | June | 116665.5305576385 | 15496.49173519193 | 0.1531742508929885
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 620 | July | 132547.4737003328 | 15881.94314269433 | 0.1361322668896437
 | Year 1 |  |  |  |  |  |  |  |  | Year 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 640 | August | 130870.1145980595 | -1677.359102273287 | -0.01265477987204425
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 660 | September | 135836.198688924 | 4966.084090864446 | 0.03794666265951355
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 680 | October | 158992.4487672598 | 23156.25007833581 | 0.1704718646563831
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 700 | November | 163453.1802652987 | 4460.73149803892 | 0.02805624753014992
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 720 | December | 182960.0317489019 | 19506.85148360318 | 0.1193421348666442
 |  |  |  | Gain (%) |  |  |  |  |  |  |  |  | Gain (%)
 | Account Balance |  | 18409.16740088747 | 2.068194566814578 |  |  |  |  |  | Account Balance |  | 59062.954824244 | 2.208344708810498
 | Peak Drawdown |  |  |  |  |  |  |  |  | Peak Drawdown
 | Losing Streak |  |  |  |  |  |  |  |  | Losing Streak
 | Winning Streak |  |  |  |  |  |  |  |  | Winning Streak
 | Year 3 |  |  |  |  |  |  |  |  | Year 4
 |  |  |  | Gain (%) |  |  |  |  |  |  |  |  | Gain (%)
 | Account Balance |  | 182960.0317489019 | 2.097712132644623 |  |  |  |  |  | Account Balance |  | 671876.164663882 | 2.67225649362577
 | Peak Drawdown |  |  |  |  |  |  |  |  | Peak Drawdown
 | Losing Streak |  |  |  |  |  |  |  |  | Losing Streak
 | Winning Streak |  |  |  |  |  |  |  |  | Winning Streak
 | INCORRECT |  |  |  |  |  |  |  |  | INCORRECT
 | Account Balance |  | N/A |  |  |  |  |  |  | Account Balance |  | N/A
 | Peak Drawdown |  |  |  |  |  |  |  |  | Peak Drawdown
 | Losing Streak |  |  |  |  |  |  |  |  | Losing Streak
 | Winning Streak |  |  |  |  |  |  |  |  | Winning Streak