21 February 2025

15 thoughts on “Sound Staking: Flat Stakes & Ratcheting

  1. “If you cannot calculate this for yourself in such great detail then either stick to the 75% threshold, or perhaps lower it to 65% (if you have a lower risk aversion) as advised in previous articles.”

    I’m quite curious how setting a lower threshold for the stop-loss would indicate lower risk aversion. Shouldn’t a higher stop-loss minimize a further streak of losses on the way down?

    Perhaps it’d be good to link to the previous articles that were referenced as well. I can’t seem to find one which mentions the ratcheting stop-loss.

    Thanks.

  2. That totally makes sense and for what is worth since i bought your O/U course i have indeed learned a lot and actually spent time in excel working with formulas so i think i could replace the numbers with formulas if i tried.

    I do have a few question about the formula in “Y10” cell under system performance if it’s possible to get some insight.

    In the first nested AND function It states that if the odds available when placing bets are smaller or equal K10*Z6 (which always equals 0), why does it also check if the expected hit rate is bigger then 50%. Since the first part of function is only “TRUE” if the odds when placing bets are 0 or less why would we then even need to check if expected hit rate > 50%?

    Second question is why are we using exactly 50% in Y5 to compare it with expected hit rate. Also in the second AND function is there a specific reason 85% is selected to multiply zero odds with?

    1. The first AND formula…

      $K10*$Z$6
      $K10: Zero Odds
      $Z$6: set to 0% (you can put any number in Z6)

      $J10>$Y$5
      J$10: expected hit rate
      $Y$5: currently set to 50% (you can put any number in Z6)

      The formula means… bet on everything, even if the odds are far the expected Zero odds as long as the expected hit rate is above 50%

      The second AND in the formula you can now probably work out yourself… 😉

  3. Hi,

    just curious if the staking tab in the Winter League Campaign Report is missing formulas for flat stakes & ratcheting intentionally?

    1. Hi Gasper,

      yes, we removed the formulas intentionally. It’s a monitoring not a formulas-give-away spreadsheet. The opening, closing and mid-time odds that the spreadsheet contains are already priceless information as well as giving away the systems we used.

      You at least bought our Over/Under course at some time in the past. Thank you very much for supporting Soccerwidow! And I truly hope that you learned a lot from the course. 🙂 However, we have countless readers who don’t buy anything, enjoy reading our website and get all the information for free. Therefore, please accept my apologies that there are no formulas contained in the workbook if it wasn’t necessary to make the workbook to work.

  4. hi, so ive been only using a 2% of my bank system for quite some time now, adjusting it daily to increasing and decreasing money. Most annoying thing being to lose high stakes after a winning period. The 75% margin prevents this. Will probably try it out. Would you personally see any advantages/disadvantages in increasing the stakes (if money is won) daily instead of each week?

    Wouldnt the bank grow faster? Since a profitable monday would already lead to an increased tuesday and so on, but you probably couldnt lose as much on a monday that you would need to decrease already. And since winning and losing days are not predictable i dont see a reason not do it. Or do you think its more risky for some reason?

    1. Hi Matt, you can do it daily if you like or biweekly, say Fridays for the weekend games and Mondays for the week days. The choice is yours.

      Just do an analysis of your previous years’ bets how it would have performed for those different variations and then go for the most promising as well as the most nerve-saving option.

      1. It would be great to see what the winter portfolio results would of been if the ratchet system was done on a daily basis rather than a round basis? Excellent content as always and looking forward to more portfolio reports in the future

  5. I read your article on Maria’s staking plan and wondered if something similar would help smooth out the roller coaster ride of the ratcheted stakes. So one would still use say 2.5% of the bank as the basis of your staking but them increase or reduce that in line with the probabilities implied by the hit rate of a particular system.

    1. Hi Bruce,

      in the example portfolio I showed in this article, following staking smoothed it out:

      Up to 30% probability: 1.5%
      Up to 40% probability: 2.0%
      Up to 50% probability: 2.5%
      Over 50% probability: 3.5%

      Please note that the calculations need to be done individually depending on the size of the portfolio as well as the exact compilation. Problem is that this requires a whole course to explain it properly, this is why I didn’t even mention it in the article.

      Your suggestion to split the stakes, e.g. into home wins in Greece and for the draws in the EPL, etc. probably won’t work. I would always make it either dependent on the odds played or on the expected hit rate (probability) of the system.

      1. Thanks for the reply. I used the examples of Home wins in Greece and draws in the EPL because those systems had different expected hit rates – so I think we’re on the same page there.

        I can quite imagine that the whole thing gets complicated – my own plan is to calculate, using the predicted hit rate, the longest losing run of each system in my portfolio. I then plan to size my bets so should such a run occur in any of the systems its affect on the bank would be the same. So a system where the calculated LLS is 5 would have a bet size twice that of a system where the calculated LLS is 10. I think that actually ends up pretty close to the numbers you’ve suggested above. Did that smoothing have much effect on overall profitability? Personally I like smooth and will sacrifice some profit for an easier ride.

        This is sort of an experiment and so the starting stakes are pretty small – I’ve got your report from last season so I could play around and try and fine tune things but the season is upon us.

        PS – sorry about the double posting but my post seemed not to be showing up so I wrote another.

        1. The portfolio with flat stakes only produced 38,925; the one with ‘smoothing’ 41,327. The difference is insignificant to say that ‘smoothing’ leads to much better results.

          You cannot even say that the portfolio with fixed staked produced regularly higher losses than the one with flexible stakes. They are both pretty equal although the ‘smoothing’ stakes are probably (slightly) easier on the nerves. The problem is that you simply don’t know when the losing streaks occur and LLS 5 may happen at the same time as LLS 10.

          1. Thanks for the reply – I’m actually surprised that the ‘smoothed’ version led to a higher profit – although you note this may not be significant.

            I agree that such a staking plan has problems – reading your report on the last season almost no leagues performed in line with expectations – so a staking plan based on those expectations seems flawed – but then if no leagues perform as per expectations one might say the whole concept of looking at past performance is flawed but your results suggest otherwise.

            I shall experiment with reasonably small stakes and see where I end up.

          2. Hi Bruce,

            the statement that ‘no leagues performed to expectations’ means that no league exactly hit the goal.

            Say, the average height of a population is 1,75m and you go out and measure the first 50 you come across. Do you really think that your result will be exactly 1,75m average height? It probably won’t and you too would make the statement that the result ‘didn’t exactly meet the expectations’. But if you would do it with 10 different groups then you will probably get pretty close to 1,75 when you look at these 10 groups together as a whole. That’s then the ‘portfolio effect’.

            Hope that example makes sense.

  6. I’ve read your post on Maria’s staking plan – would using this in conjunction with the ratchet smooth the roller coaster somewhat – so your base stake would still be 2.5% your bank with this being adjusted according to the risk implied by the hit rate of a particular group of bets in the portfolio – so for the Home wins in Greece you’d stake more and for the draws in the EPL you’d stake less etc.

Leave a Reply

Your email address will not be published. Required fields are marked *