Pswirly:
Thank you for sending me your XLS files with results of betting.
Upon extensive studies, eventually I have found the reason of your losts - wrong calculation of stakes and incompleteness. Sorry for the delay as it took a lot of time.
You might read the Odds Wizard manual, the topic "Stake Wizard Guide -> Math background". It clearily states that even though you have met the criterion Line > Fair, you can fall in red when the stake is either too small or too high. Just look at the convex curve (P vs x0).
By the way, why do your files miss many games with potential profit?
For example, you could add the following profitable game to Europa League
events of December 16-17, 2010:
NK Dinamo Zagreb vs PAOK Saloniki (2) F=3.49 L=4.5
NK Dinamo Zagreb vs PAOK Saloniki (2X) F=1.66 L=1.91
Your file "Stake.xls" is definitely incomplete with respect to events meeting criterion Fair < Line and other bet types, e.g. 1X, 2X that may be even more profitable.
Let's look closer at your results. The total sum of your 2565 stakes is GBP 8678.84, and the resulting balance is negative: GBP -513.76.
Applying the simplest Kelly strategy gives more favourable results which are presented in the last two columns highlighted by light green. Total amount of stakes for the same 2565 events is GBP 8423.05, and the balance is still negative GBP -380.13. I attach here modified version of your file Stake.xls.
Note that Kelly strategy is the simplest one. Since 2007, Stake Wizard 4 uses the theorem on the optimal distribution of the bettor's bankroll with more advanced calculations and much greater results.
I have also included a spreadsheet where the same results are filtered if they are above 25% and below 50% in terms of difference in fair odds and line odds and this in itself produces profitable returns.
Your another XLS file "Above 25-Below 50" shows positive balance +GBP 1581.21 even without applying Kelly or more advanced strategy. It is also attached here with an added TOTALS line at the bottom. Positive balance is well expected here as suspicious events with the great difference between Fair and Line odds were cut off (according to Generic tips
http://www.newhavensoft.net/forum/viewtopic.php?f=5&t=6) while events with the small difference Fair/Line result in small stakes/wins/losts, and thus make no significant contribution in the total balance.