Acca Profit Spreadsheet

  • Hi All

    I’ve been racking my brain most of the day trying to come up with a spreadsheet that generates the correct lay stakes to guarantee the expected value profit of a 6 fold acca.
    After a lot of trial/error I think I’ve got something that works.
    The spreadsheet can be accessed here:
    https://docs.google.com/spreadsheets/d/1gBiVP9tC1wIP-jwv_ps0uMqr-mZSPYRt-TOPkHDWHsc/edit#gid=432786789
    If someone can check I’ve got this right it would be appreciated as I’d like to start doing these over the next week or so.

    Thanks

  • New to matched betting?

    My Matched Betting Academy is the best place to get started. Learning the fundamentals takes 10-15 minutes and you’ll make £15 in the process.

    Learning the fundamentals takes 10-15 minutes and you’ll make £15 in the process.

    johnboy1980 1

    im now getting the hang of these . I’m now looking at playing about to increase the profits , i love the fact that by underlaying / overlaying each or individual leg can change amount of profit but also loss. im just wondering what others who do these strategies are to maximize more profit or unfortunate losses.

    +0
    Stu Blue 0

    Where’s a good place to read up for a total beginners guide, not done any of these yet.

    +0
    johnboy1980 1

    Use this thread or search the forums if still have any questions then fire away. But be aware not sure you’ll be spoon fed lol

    +0
    the_don 1

    Hi!
    Could someone please look into my spreadsheet and say if it looks right? My strategy is like Mark’s: first 5 legs booked at low odds without lays, 6th leg booked and layed at high odds.

    https://docs.google.com/spreadsheets/d/12CPYhpvU-VRqqIEPOIn6zrPnCYnHFs9LLlSXVwGW0sY/edit?usp=sharing

    +0
    Digibets 0

    Hi The_don, thanks for sharing your spreadsheet. Unfortunately I can’t help critique it because im very new to this. But i did have some questions for you if you could clear some things up for me please:

    1) in cell D5, where is the bonus coming from? is it a bookie offer?
    2) Do bookies regularly have free bets if an acca loses?
    3) What does ROI stand for?

    thanks bud

    +0
    the_don 1

    @Digibets No problems.

    1) William Hill give you 10% bonus (of the winnings, not the stake) if you hit the 6th leg.
    2) What I’ve come to understand, yes. There are a numerous of acca offers. Just google “acca offers” and you’ll get a list of these.
    3) Return on investment = (gain from investment – cost of investment) / cost of investment. In this case gain from investment = E/V and cost of investment = stake. In other words, if the ROI is i.e 1.3, you will (in the long run) earn €15 (30%) for every €50 you invest. This is very good. The stock market is in average 10%.

    +0
    Digibets 0

    @the_don thanks for your reply.

    One more thing, why do you include a list of win probabilities? do these factor into the calculation itself?

    +0
    the_don 1

    @Digibets You mean the “P of win”? I just like to see it in P instead of odds.

    +0
    Digibets 0

    @the_don ah i see mate thanks.

    +0
    Digibets 0

    @the_don sorry to be a pain mate but one more question, how do you wotk out the lay stakes for each leg?

    +0
    the_don 1

    @Digibets There are several strategies to acca insurances. In some strategies you lay each leg, in others you don’t. This strategy of mine just lay the last, 6th leg. So, if 5 legs have won, we have the accumulated odds of the first 5 legs times the initial stake. This is the back stake for the 6th leg. To know what stake to lay you take the Bookie Return/(Lay stake of 6th leg – Exchange commission).

    +0
    the_don 1

    Oops! It should be
    Lay stake of 6th leg = Bookie Return/(Lay odds of 6th leg – Exchange commission)

    +0
    Digibets 0

    @the_don thanks mate

    +0
    Dave_Jones 9

    @the_don, I am not certain but I’m fairly sure Mark has stopped the not laying method now. I think he did some Monte Carlo simulations and found the risk of ruin was higher than he had originally expected. So I think he now lays off all legs.

    +0
    beakerh 3

    I have been doing acca’s since I completed sign up offers and have found them very profitable. Once you understand how they work and how flexible they are they are easy to understand. I find Hills the best as there is no minimum odds and applies to all competitions. The biggest reason for using Hills is the 10% bonus if all legs win so you can play around with the final game lay stake if all legs have won to date. Stick to picking big teams to avoid getting gubbed. And start on smaller amounts whilst you get the hang of them before upping to £50.

    +0
Viewing 15 replies - 136 through 150 (of 207 total)

You must be logged in to reply to this topic.