Football trading strategiesHorse racing strategiesExcel Trading Spreadsheets  

Bet and Lay strategies with spreadsheet staking plans.

Both Sides spreadsheets.
Bet and lay the same runner with just a single stake

Both Sides.
Bet and lay the same runner To a Profit Target using only a single stake.
3 staking plans in a single spreadsheet

  1. Bet your runners to a Profit Target.

  2. Lay your runners to a Profit Target.

  3. Trade your runners to a profit target using the "Both Sides" method.
    Combine the Bet and Lay stakes of the 2 staking plans above to get a single stake.

As we trade each of our runners using that single bet or lay, one or other of the 2 staking plans will complete a sequence in every race.
The 2 staking plans combined will have either a winning bet sequence or a successful lay sequence.

Trade a few races and we are looking to trade to a Profit Target in every race.
These spreadsheet staking plans can be used to trade any sporting or other event.

Trade a series of races and as the staking progresses, the 2 staking plans hit either a winning bet or a successful lay in every race.
The combined "Both Sides" staking plan is therefore working towards a profit from every race.
Once our selections hit a winner followed by a loser, our "Both Sides" Profit Target staking plans each complete a sequence.
Our profit should then be just short of our profit target multiplied by the number of races that we have traded.

For example, if we set our Bet profit target to 2 and our Lay profit target to 2 as well and trade 10 races, if we hit a winner in the 9th race followed by a loser in the 10th race, our staking will be aiming to achieve 10 x 2 = 20.
In reality, if we stake as per the spreadsheet using our money, our profit from our 10 races would be just less than 20.

Loss recovery.   New. 
If we make a loss, we could bet with the aim of recovering that loss over a series of winning bets.
The spreadsheet below shows the staking for doing that, including commission deductions.

The spreadsheet can be set to recover your loss over any set number of winners.
Also, if your loss increases during your Loss Recovery, the staking can be reset to cover a change in your loss.
This method uses a "Bet to a Profit Target" spreadsheet to show the stakes required.
The Bet to a Profit Target staking can be used as a staking plan, with the loss recovery, or set up with a loss in the first row of the spreadsheet, so that it can be used just to recover a loss.

When betting to recover a loss, we may hit more losers whilst we are doing that.
If the spreadsheet is set to recover a loss over say, 4 winning bets, that is what it will do if the next 4 bets are all winners.
If we hit more losers during the loss recovery staking, the original loss and any subsequent losses will be recovered, but it will take more races.
Once the loss is recovered, the sheet carries on aiming for the last profit target that was set in the sheet.

The videos below demonstrate the spreadsheet.
All that is required to recover a loss over any set number of winning bets, is a reset of the target amount that we would like to win.
Input a number of winners, and the spreadsheet shows the target stake required to recover your loss if you hit that number of winners with your next few bets.

Copyright notice.  In the videos below, Betfair content shown is for demonstration purposes only, and is presented with the kind permission of The Sporting Exchange Limited.  The Sporting Exchange Limited.

  • Video 1 describes how the spreadsheet works and the Loss Recovery staking.
    The Loss Recovery spreadsheet in this video uses quite a few columns so it is best viewed in a Full Screen.
    For a BIGGER VIEW of this video, click the small icon bottom right of the YouTube screen with 4 square corners.

  • Video 2 describes how Combined Odds and Dutching can be used to get a single odds input for use in a staking plan or any other spreadsheet.

 

A "Combined Odds" spreadsheet is also included in this file.
The Loss Recovery spreadsheet requires a single set of odds for each row.
If you bet by Dutching your runners, a single set of odds can be used in the Loss Recovery spreadsheet by combining all the odds of your runners.

Enter the odds of your Dutched runners into the Combined Odds sheet and the Combined Odds of your runners is displayed.
Use the Combined Odds in the Loss Recovery sheet as a single entry, to see the stake required to Dutch your runners to the Profit Target.
Another name for Combined Odds, is Coupled Odds.

Profit Target and Loss Recovery spreadsheet       10
Use this spreadsheet to trade to a Bet profit target with loss recovery, or use it just for Loss Recovery.
The file also includes a spreadsheet to show the Combined (or Coupled) Odds of your Dutched bet odds.
A link to the video above is included the spreadsheet file.

After payment via PayPal, select the "Return to merchant" option on the PayPal screen.
PayPal should then route you to a download web page where you can obtain the Excel spreadsheet file.


10

Both sides.
Bet and lay the same runner To a Profit Target using only a single stake.
3 staking plans in a single spreadsheet

This is how the individual staking plans work in the Both Sides spreadsheet :-

  • Bet to a profit target - Bet until we hit a winner and achieve our desired profit.
    Each bet stake aims to recover any lost stakes from hitting losers, and show a profit when we hit a winner.

  • Lay to a profit target - Lay until we hit a loser and achieve our desired profit.
    Each lay stake aims to recover liabilities from hitting winners, and show a profit when we hit a loser.

  • Combine those 2 staking plans so that we can bet and lay the same runner using just a single stake.
    For our "Both Sides" stakes, we simply take one stake from the other and stake the difference.
    That will be either a single bet or lay, depending on which is biggest.

  • We could of course place a bet and a lay to match the 2 individual staking plans.
    Combine the 2 stakes and a single stake does exactly the same. . . . .a bet and lay of Both Sides of the trade.
    The spreadsheet below, shows the staking for doing that.

As we trade a series of events using our "Both Sides" single stakes, our 2 staking plans combined, hit either a winning bet or a successful lay every time.
Therefore, one staking plan or the other will show a profit in every event that we trade, horse races, football matches, or anything else.

Over a series of bets and lays that is reflected in the Both Sides staking plan as we hit winners and losers.
We can therefore in theory, profit from every race, football match etc that we trade.
That is the theory, and in the long term, that is what can happen in practice when using cash.
We will have either hit a winner with a theoretical winning bet, or we will have hit a loser with a theoretical successful lay.
The word "Theoretical" is used here, as our bets won't always hit a winner and our lays won't always hit a loser of course, but in the long term, that is what the "Both Sides" staking plan will be doing.

Note that, these 2 staking plans are basically "Chase Your Losses" staking plans.
Staking to chase losses can be a very dangerous strategy.
It is therefore recommended that using very small stakes may be best as liabilities can escalate very quickly if we hit a series of winners or losers.
That is especially true of the lay side of these trades if we hit winners.
Disclaimer.   The owner of this web site cannot be held responsible for losses incurred by third parties.
It is entirely up to the individual to trade sensibly.
Never bet or lay with money that you cannot afford to lose.

The video below describes a single spreadsheet that includes all 3 staking plans.
Use the Bet or Lay staking plans individually, or combine them for the "Both Sides" staking plan. 

For a bigger view of the video, click the 4 small "Square corners" icon at the bottom right of the video screen.

Both Sides staking plan spreadsheet       20
Use this spreadsheet to trade to a Bet profit target and a Lay profit target, using a single stake.
The spreadsheet allows inputs for the staking of 100 races or other events.
A video description of the strategy and the spreadsheet is included.

After payment via PayPal, select the "Return to merchant" option on the PayPal screen.
PayPal should then route you to a download web page where you can obtain the Excel spreadsheet file.


20

Percentage of Bank staking plan. . . . . . 2 spreadsheet staking plans :- One for Betting and another for Laying.
Staking a percentage of your bank is a very well known method of staking.
Winning bets will increase the stake size, whilst losers will decrease the stakes.
As we continually stake a percentage of our bank, we should never run the risk of losing all of our bank if we have a losing streak.
A series of winners will see our bank grow.

A problem with this method is that we may be limited to one bet at a time, since we need to change our stake size as we hit winners and losers.
The spreadsheets available here get around that problem by allowing us to bet several events using the same stake if we choose, or we can let the spreadsheet update the stake after each individual stake.
That facility allows us to bet several events that take place at the same time, for example several football matches that all kick off around the same time, or if we are at work, we can bet several events at the same level of staking and then update the staking when those results are known.

Want to bet several runners in the same race to Dutch a market. . . . . . No problem.
A spreadsheet is provided to show the Coupled Odds of your Dutched runners so that a single entry can be made into the Percentage of Bank sheet.
Enter the odds of your runners into the "Combined Odds" spreadsheet and the spreadsheet shows those odds coupled.
Use those coupled odds for your entry in the Percentage of Bank sheet as a single entry and the your staking plan can continue as if you had bet a single runner.

A graph is provided to show the profit and loss progress of our trades.
Enter your starting bank and the percentage of your bank for each bet of your staking plan.
As the odds of runners are entered, the spreadsheet shows the stake required.
Enter the date and the spreadsheet will update after every event.
Leave the date column blank and the spreadsheet keeps the same stake until the next date is entered.
Once the date is entered, the spreadsheet updates the results and shows an updated stake when the odds of the next runner are entered into the spreadsheet.

The video below describes a single Excel spreadsheet file that includes both bet and lay staking plans.
For a bigger view of the video, click the 4 small "Square corners" icon at the bottom right of the video screen.

 

Percentage of Bank staking plan spreadsheet       10
Use this spreadsheet to bet or lay a pecentage of your betting bank.
2 spreadsheet files allow inputs for the staking of 50 or 2000 races or other events.
Both files contain a Betting spreadsheet and a Laying spreadsheet.
A video description of the spreadsheets is included.

After payment via PayPal, select the "Return to merchant" option on the PayPal screen.
PayPal should then route you to a download web page where you can obtain the Excel spreadsheet file.


10

NEW.   Lay a Percentage Of A Profit Target staking plan.
The theory behind this staking method is that after a loss, the staking increases, so losses may be recovered more quickly than if we simply staked a percentage of our betting bank.

Use this spreadsheet to place a series of lays with the intention of winning a specific profit . . . . . . a Profit Target.
We lay each time to a percentage of our chosen profit.
We set that percentage in the spreadsheet.
Example :
If we set a Profit Target of 40 and stake to a liability of 10% each time, our first lay would have liabilities of 4.

As we hit winners and losers with our lays, the liability of each lay goes up and down.

  • Profit from successful lays is taken off what we still need to win to get to our chosen profit.
    A profit reduces what we need to win, so the percentage of the next lay gives a smaller liability.

  • If we hit a winner with one of our lays, the loss is added to what we still need to win to get to our chosen profit.
    A loss increases what we need to win, so the percentage of the next lay gives a bigger liability.

  • The effect of subtracting profit and adding losses, (the opposite of laying to a percentage of a Betting Bank) is that we lay to a Profit Target.

It won't have escaped your notice that as our profit goes up, our stakes go down.
If
our profit continues to increase if we continue to hit losers with our lays, we could be laying very small stakes.
It could take us a long time to finally reach our profit target.
To get around that problem, a "Reset" facility is built into the spreadsheet that allows us to enter a new Profit Target at any time, so that stakes can be increased without the need to delete all previous stakes and results from the spreadsheet.
The "Reset" can also be used to reduce stakes if necessary.
If we have favourable results, resetting after making profits can increase the overall profit of the staking plan.

For a bigger view of the video, click the 4 small "Square corners" icon at the bottom right of the video screen.

 

Lay a Percentage of a Profit Target staking plan spreadsheet       10
Use this spreadsheet to lay a percentage of a Profit Target.
2 spreadsheet files allow inputs for the staking of 100 or 1000 races or other events.

An additional spreadsheet for Dutching several runners to a Profit Target is included.

After payment via PayPal, select the "Return to merchant" option on the PayPal screen.
PayPal should then route you to a download web page where you can obtain the Excel spreadsheet file.


10
 

 

NEW.   Lay to a Set Liability staking plan.
This Lay staking method keeps lay liabilities under control.
Set a lay liability in the spreadsheet and whatever odds we lay, every lay will have that liability if we are unlucky and hit a winner.

This staking method can be surprisingly profitable.
Profits from favourable results should compare very favourably with the other lay staking plans described above, for staking a Percentage of a Bank or Percentage of a Profit Target.

A "Reset" facility is built into the spreadsheet that allows us to set a new Lay Liability at any time, so that stakes can be increased without the need to delete all previous stakes and results from the spreadsheet.
The "Reset" can also be used to reduce stakes if necessary.
If we have favourable results, resetting after making profits can increase the overall profit of the staking plan.

For a bigger view of the video below, click the 4 small "Square corners" icon at the bottom right of the video screen.

 

Lay to a Set Lay Liability staking plan spreadsheet       10
Use this spreadsheet to lay a percentage of a Profit Target.
2 spreadsheet files allow inputs for the staking of 100 or 1000 races or other events.

An additional spreadsheet for Dutching several runners to a Set Liability is included.

After payment via PayPal, select the "Return to merchant" option on the PayPal screen.
PayPal should then route you to a download web page where you can obtain the Excel spreadsheet file.


10

NEW.   Rolling Lays.
The aim of this staking plan is to allocate a small amount for our first lay, with the aim of re-investing profits in further lays to roll up profits until we hit a winner with one of our lays.
Whilst we are rolling up our profits, we can reset our Bank at any point to take some profit.

  • We start with a very small Bank, and lay with our lay liability equal to the whole of that bank on our first runner.

  • Hit a loser with that first lay and We now have some profit to play with.
    By resetting our Bank, we can extract that profit to use as our bank for the lays that follow.

  • To play up our winnings, carry on laying, each time re-investing our winnings, and each time with our liability equal to what is in our Bank column in the spreadsheet.

  • If we reset our Bank again at any point, we can have profit when we hit the first winner with one of our lays.

  • When we eventually hit a winner with one of our lays, we lose what is in our Bank column at that point.
    A "Reset" of our bank before that winner should produce a profit.
    We can reset our Bank several times to build our profit whilst we place our Rolling Lays.

  • We may decide not to reset the Bank at all, but aim for a very large profit at some point after hitting a string of losers.

Method.  If our first lay is successful, we can use the profit from that first successful lay as the initial stake for all lays that follow until we hit a winner with one of our lays.
That is, we keep re-investing our profit by laying with our lay liability equal to the total profit that has built up in our Bank column.
As profits grow, our lay stakes grow.
We lay over and over until we either hit a profit that we have decided on beforehand, (we could withdraw everything and start again), or we hit a winner with one of our lays.
If we have reset our bank, we could lose nothing as we have been playing up the lay profit from our very first lay.
Whilst we are rolling up our lays, we have several options :-

  • Reset our bank after hitting a loser with our first lay, so that we lose zero on our combined lays when we hit a winner later.
    Hit a loser with our first lay and we can have a free stake for all lays that follow.

  • Reset our bank at any time so that we have some profit when we hit a winner later.

  • Simply allocate a small amount to lose, and continually lay that stake and any winnings until we hit a desired profit.
    When we reach our target, stop and start again to take all profit, OR, reset the Bank to a smaller amount to take some profit.

Example :-  Using odds of Evens (2.0) to keep things very simple.
We start with a bank of 10.53.
We lay to a liability of 10.53 on our first runner and if we are successful we reset our bank to 10.
The extra 0.53 in the starting bank allows for commission at 5% on the first successful lay.
Reset the bank after that, and we have a straight 10 lay on our 2nd runner and we roll that up on the lays that follow.
The screenshot below of the spreadsheet, shows a starting bank of 10.53 and the bank reset to 10 for the 2nd lay.
To keep things simple for this demonstration, odds of 2.0 have been used for all lays, but this same principle can be used for any size of lay odds.

      Result 5.00 <<<  Commission        
    LAY Win   Stake Lay Profit Total BANK Reset
Date Details Odds or Lose Adjust   Liability or Loss P/L   BANK
01-Aug Horse 1 2.00 0   10.53 -10.53 10.00 10.00 10.53  
02-Aug Horse 2 2.00 0   10.00 -10.00 9.50 19.50 10.00 10.00
03-Aug Horse 3 2.00 0   19.50 -19.50 18.53 38.03 19.50  
04-Aug Horse 4 2.00 0   38.03 -38.03 36.12 74.15 38.03  
05-Aug Horse 5 2.00 0   74.15 -74.15 70.44 144.59 74.15  
06-Aug Horse 6 2.00 0   144.59 -144.59 137.36 281.95 144.59  
07-Aug Horse 7 2.00 0   281.95 -281.95 267.85 549.81 281.95  
08-Aug Horse 8 2.00 1   549.80 -549.80 -549.80 0.00 549.80  
09-Aug Horse 9             0.00 0.00  
10-Aug Horse 10             0.00    
                     

Enter a zero for a loser or a "1" for a winner in the Result column.
Hit a loser with our first lay and our lays after that can cost us zero if we hit a winner, shown at horse 8 in this example.
8 successful lays at odds of evens (2.0) wins over 1000 at horse 8 if all 8 were losers. . . . . .(1072 after commission).
Below :- 
We may decide to reset our bank once our profit gets above 100  - - - after horse 5 in the example below.
Now when we hit a winner at horse 8, we have 100 profit rather than breaking even with no loss.
We could take profits at any point simply by re-setting the bank.  We can reset at any point and as many times as we like.

      Result 5.00 <<<  Commission        
    LAY Win   Stake Lay Profit Total BANK Reset
Date Details Odds or Lose Adjust   Liability or Loss P/L   BANK
01-Aug Horse 1 2.00 0   10.53 -10.53 10.00 10.00 10.53  
02-Aug Horse 2 2.00 0   10.00 -10.00 9.50 19.50 10.00 10.00
03-Aug Horse 3 2.00 0   19.50 -19.50 18.53 38.03 19.50  
04-Aug Horse 4 2.00 0   38.03 -38.03 36.12 74.15 38.03  
05-Aug Horse 5 2.00 0   74.15 -74.15 70.44 144.59 74.15  
06-Aug Horse 6 2.00 0   44.00 -44.00 41.80 186.39 44.00 44.00
07-Aug Horse 7 2.00 0   85.80 -85.80 81.51 267.90 85.80  
08-Aug Horse 8 2.00 1   167.31 -167.31 -167.31 100.59 167.31  
09-Aug Horse 9             100.59 0.00  
10-Aug Horse 10             100.59    
                     

Note that if our first lay was at odds of 3.0, we could start with a Bank of 21.05.
Hit a loser with a lay stake of 10.53, and we can reset the Bank to 10 for our 2nd runner.
Profit from a lay of 10.53 at odds of 3.0 would be 10 after commission at 5%.
A separate spreadsheet is included to work out the size of your first lay to include commission deductions if you chose to copy the method shown above.

For a bigger view of the video below, click the 4 small "Square corners" icon at the bottom right of the video screen.

 

Rolling Lays staking plan spreadsheet       10
Use this spreadsheet to show the staking for placing a series of lays that re-invest profit each time.
The spreadsheet file allow inputs for the staking of 200 races or other events.

After payment via PayPal, select the "Return to merchant" option on the PayPal screen.
PayPal should then route you to a download web page where you can obtain the Excel spreadsheet file.


10

4 Lay staking plans.
Test your past results to see which staking plan may be best for your lays.
This Excel file contains 4 separate Lay staking plans :-

  1. Lay a percentage of a bank.

  2. Lay to a percentage liability of a profit target

  3. Lay to a set lay liability

  4. Level Stakes.

Methods 1 to 3 are described and sold separately above.
Follow this link down this web page for a video that compares 4 staking plans for Betting.
These 4 Laying spreadsheets allow a similar comparison to be made.
After comparing some suitable results, we can then select the most suitable staking plan for our selection method.
Follow this link for a
comparison of 4 different spreadsheet Lay staking plan returns using a lay tipping service.

4 Lay staking plans spreadsheet       20
Use these spreadsheet to show the staking for placing a series of Lays.
The spreadsheets in this file allow inputs for the staking of 100 races or other events.

After payment via PayPal, select the "Return to merchant" option on the PayPal screen.
PayPal should then route you to a download web page where you can obtain the Excel spreadsheet file.


20

Bet to win a percentage of a Profit Target.
If you are familiar with Betting a Percentage of a Bank, the banking arrangement for this method is the reverse of that.
If we bet a % of a bank, as we hit winners, winnings are added to our bank so our bank increases, and our bet stakes increase.
Hit losers, and losses are deducted from the bank, so our bank goes down and bet stakes decease.

If we do the opposite of that and deduct winnings but add losses, our bank no longer matches the cash that we are winning or losing, but it becomes a Profit Target.
We set a profit target in the spreadsheet - - an amount that we would like to win from our betting.
We stake to win a percentage of that profit target with every bet.
If we hit a winner, we deduct those winnings from our profit target, as we now need to win a smaller amount to get to our profit.
The next bet is the same percentage of what remains to be won to reach our profit, but as the remaining target is now smaller, the bet is smaller.
If we hit a loser, we add that loss to our profit target.
What we still need to win to get to our profit is now bigger.
Our next bet after hitting that loser will be bigger as it is a percentage of a that bigger profit target.

Advantages of this method over the Bet a Percentage of a Bank method :-

  • After hitting a winner or winners, a losing bet should cause less financial damage as the bet stake will have gone down after the winnings were deducted from the profit target.

  • Recovery from a loss should be better than the Bet a % of a Bank method.
    After hitting a loser, the next bet stake will be bigger than the previous losing bet stake.

Disadvantages of this method compared with the Bet a Percentage of a Bank method :-

  • Losses may escalate if we hit a series of losers.

  • Profit from a series of winners will be less than the % of bank method, since our bet stakes will be reducing.

The spreadsheet allows us to reset the Profit Target at any time.
Resetting our profit target allows us to increase our bet stakes again if we get into profit and our bet stakes are reducing.

Bet a percentage of a Profit Target staking plan spreadsheet       10
Use this spreadsheet to show the staking for placing a series of bets aiming for a Profit Target..
The spreadsheet file allow inputs for the staking of 100 races or other events.
A "Dutch to a Profit Target" spreadsheet is also provided for betting more than one selection in your race, football match, etc..

After payment via PayPal, select the "Return to merchant" option on the PayPal screen.
PayPal should then route you to a download web page where you can obtain the Excel spreadsheet file.


10

NEW.   Bet to Increase a Bank by a Set Percentage staking plan.
The theory behind this betting method is compound interest.
We all know how Compound Interest can mount up, so why not use that for a few favourable results if we get a bit lucky and hit some winning bets ?
Compound interest adds interest on top of interest :-
!00 plus 10% = 100 + 10 = 110.
110 plus 10% = 110+ 11 = 121.
121 plus 10% = 121 + 12.10 = 133.10.

Compound interest of 10% above adds interest on top of interest already earned.
If we were placing bets to copy that, our betting bank would be the figure on the left each time, 100, 110, and 121,and we would be betting to win a profit of 10% of that which would be 10, 11, and 12.10.
If we could hit 3 winners and win 10% of our betting bank each time, our betting bank would grow from 100 to 133.10 in 3 bets, if we ignore commission of course.

This staking method involves betting to win a profit target with each bet, that is equivalent to a set percentage of our betting bank.
If we can hit a series of results that pay better than level stakes, our winnings should gradually grow as our betting bank gets bigger and our profit target increases.
The theory is that if we are able to hit plenty of winners with our bets, our betting bank will increase each time, with those profits compounded by the added percentage of previous winners.
Losing bets would slow that process down of course.

For a bigger view of the video below, click the 4 small "Square corners" icon at the bottom right of the video screen.

 

Bet to Add a Set Percentage to a Betting Bank, staking plan spreadsheet       10
Use this spreadsheet to bet to increase a betting bank by a set percentage.
2 spreadsheet files allow inputs for the staking of 100 or 1000 races or other events.

An additional spreadsheet for Dutching several runners to a Profit Target is included.

After payment via PayPal, select the "Return to merchant" option on the PayPal screen.
PayPal should then route you to a download web page where you can obtain the Excel spreadsheet file.


10

4 Bet staking plans.
Test your past results to see which staking plan may be best for your Bets.
This Excel file contains 4 separate Bet staking plans :-

  1. Bet a percentage of a bank

  2. Bet to win a percentage of a profit target

  3. Bet to add a percentage to a bank.

  4. Level Stakes.

Methods 1 to 3 are described and sold separately above.
The video below compares 4 staking plans for Betting.
These 4 Betting methods allow a comparison to be made.
After comparing some suitable results, we can then select the most suitable staking plan for our selection method.

For a bigger view of the video below, click the 4 small "Square corners" icon at the bottom right of the video screen.

 

4 Betting staking plans spreadsheet       20
Use these spreadsheet to show the staking for placing a series of Bets.
The spreadsheets in this file allow inputs for the staking of 100 races or other events.

After payment via PayPal, select the "Return to merchant" option on the PayPal screen.
PayPal should then route you to a download web page where you can obtain the Excel spreadsheet file.


20

Contact

Privacy :-  No personal information is collected on this web site.
E-mail addresses or any other information that is forwarded will not be passed to 3rd parties.

Copyright H. Hutchinson 2014 All rights reserved
Copying text or any other kind of content from a web site is a criminal offence.

This site is a member of WebRing.
To browse visit