You're (probably) not interested in getting the most wins -- you're interested in maximizing profits per amount risked, so long as it doesn't kill your win% or other stats, yes?
Here's an update to your spreadsheet. It's pretty grubby but it might help you see how this performs. I made several additions:
* Starting in column P, I calculated the W/L for each trade listed in columns M & N. To be conservative, if the SL was hit, I assumed it was a loss, even if the TP was also hit. If neither SL nor TP was hit, I assumed the trade stayed open until the next day.
* I calculated the total profit for the series of trades.
* I also calculated the profit assuming fixed risk%. I said "40 pips = 2% risk," so a 40pip SL traded 1 unit, and a 20pip SL traded 2 units & thus got 2x the net profit.
* I copied the test in column P into the following columns, and swept SL from 20 to 70, PT from 30 to 100.
* I added a win% calculation for each test in P42:BK42.
* I summarized the results in a table in O45:W51, and...
* I plotted the risk-adjusted profits table in a surface chart in A35:G54.
(Note Excel inverted the SL axis for some reason, so be careful if you compare the plot to the table.)
So from that you can see:
* 40:40 or 40:50 (SL:TP) produce the highest profits.
* However it drops off fairly quickly as SL goes below 40. If you zoom in on the best area:
...it looks like 42:45 is about optimal. But this is really much too small a sample to try to force it into that level of detail. There's only one trade with a max negative excursion between 41 and 55, so we have no idea how it actually behaves in that region. It would probably take at least 150-200 trades to get a solid idea of where the best "sweet spot" is.
It's hard to tell without a larger sample, but it might be safest to use a bit larger SL, 45-50 or so, to get away from the dropoff as you get down below 40. Future behavior will almost certainly be different to past behavior, and your actual peak (best profits) in future trades might move around a bit. And the bad-performing areas might move to where the current best peak is, since they're pretty close. It's a good idea to select a position that's in the middle of a big plateau, rather than a sharp peak, especially if the peak is right near a dropoff.
Howzzat?