Football trading strategiesHorse racing strategiesExcel Trading Spreadsheets

List of Excel spreadsheets for Betfair trading.

Mathematically, there are only 2 ways of trading.
Hedge the odds by Betting High and Laying Low on the same selection, or Dutch a market by Betting or Laying more than one runner for an equal profit or liability whatever the result.
Combinations of Hedging and Dutching can be combined to provide strategies for trading different situations, often across more than one market.
These spreadsheets offer a range of staking options, using Hedging, Dutching, and Multiples.

NEW     Take a look at the free on-line calculators on the "Free Calcs" web page.

8 types of spreadsheet are available here.

Analyse your data
Click on the "Analyse Data" tab above.
Analyse your own stuff to create a new betting method from scratch,
OR look to improve some existing tips, or ratings that you may be following, or an existing system.
Staking plans
.
Bet and lay the same runner using just a single stake.
Also, progressive staking plans involving a betting bank or profit target.
Loss recovery 
Risk free trading. .
Build up your betting bank by trading bookie sign-up offers for new customers.
Progress to using those bookie accounts for your bets and Betfair for your lays.
Bookie bet odds are not always lower than Betfair lay odds, especially in horse races.
Pro traders use the difference between bookie bet odds and Betfair lay odds for risk free trading.
Bookie refunds.
Opened a load of on-line bookie accounts and traded the bookie sign-up free bets ?
Continue your profits - - trade bookie refund and bonus payments that are available to existing bookie customers.
Strategies with a spreadsheet for the staking make these zero and low risk trades
Need some staking for your own strategy ?
A range of different Hedging and Dutching methods are available here.
Whatever staking you require for your trades should be covered by at least one of these spreadsheets.
Looking for a trading strategy ?
Tried and tested strategies are available here.
Trading just within Betfair is never risk free, but these strategies are designed to reduce risk.
Insurance bets and insurance lays are included in the staking of some of these trading strategies.
Football trading & strategies.
Strategies for trading football.
Also spreadsheets for trading across 2 or 3 markets.
These sheets show profit & loss including commission deductions across more than one markets traded..
Dutch and Hedge 2 markets.  Designed for trading Correct Score with any other market.
Trade Correct Score with 2 o 3 other markets, placing SEVERAL bets per score or other selection.
Multiples.
Spreadsheets for Bookie Strategies such as Laying Multiple bets, Yankee, Trixie, etc. are available here.
Trade across 2 horse racing markets
  New.
Looking for something a little different ?
Why not take a look at betting & laying your horses across 2 different horse racing markets ?
Dutch and Hedge one or more runners across 2 horse racing markets.
These spreadsheets show profit or loss for all possible outcomes, including commission deductions.

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.

If you have problems downloading your spreadsheet,
e-mail me and I will send your spreadsheet by e-mail the next time I look at my in-box - usually every day.

Analyse data.     
Analyse up to 1000 rows of input. 
Analyse your own data or look to improve  an existing method, or some tips or ratings that you are already betting on.
New update   3 separate files are now provided with this package.
1.  Analyse 4 number inputs and 4 text inputs of data
2.  Analyse 6 number inputs and 2 text inputs of data.
3.  Analyse 8 number inputs of data . . . . . put together specifically for analysing greyhound race data.

20


Staking Plans  Bet and lay strategies with spreadsheet staking plans.    
Trade Both Sides staking plan. 
Bet and lay the same runner using just a single stake.
Bet to a profit target and Lay to a profit target - - - 2 staking plans are combined to produce a single stake, so that we can bet and lay the same runner, aiming to profit from every race traded.
Note that you will need your own selection method for these trades.
 

20

 
Loss recovery.
Bet with the aim of recovering a loss over a series of winning bets.
The spreadsheet can be set to recover your loss over any set number of winners.

10

Bet a Percentage of Bank staking plan. 
A well known staking method but with extra facilities :-
2 spreadsheets - - 1 for Betting and another for Laying.
Keep stakes the same for a few bets or a few lays, eg several football matches that kick off at the same time.
Dutch a race, but combine your Dutching odds for as single entry in the staking plan.
A graph shows the progress of your profit and loss.
 

10

 
Bet a Percentage of a Profit Target staking plan.  
This could be considered as the opposite of betting a percentage of a bank.
Set a Profit Target in the spreadsheet.
Profit from winning bets reduce what we still need to win to meet our profit target.
Losses from hitting losers increases what we need to win to attain our profit target.
We bet a percentage of what we need to win to get to our profit target.
Hit winners and stakes go down.
Bet losers and stakes go up.
 

10

 
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 ?
This staking method involves betting to win a profit target with each bet, that is equivalent to a set percentage of our betting bank.

10

 


 

4 Ways to Bet.  4 Betting staking plans in one Excel file.    
Bet a percentage of a bank.    Bet a percentage of a profit target.
Bet to increase a bank by a set percentage.     Level stakes.
Compare 4 staking plans and find the one that suits you best.
Bet for bigger profit, or maybe less risk.


20


Lay a Percentage of a Profit Target staking plan.  
This could be considered as the opposite of laying a percentage of a bank.
Set a Profit Target in the spreadsheet.
Profit from successful lays reduce what we still need to win to meet our profit target.
Losses from hitting winners increases what we need to win to attain our profit target.
We lay a percentage of what we need to win to get to our profit target.
Continually lay losers and stakes go down.
Hit winners and stakes go up.
 

10

 
Lay to a Set Lay Liability staking plan. 
Keep lay liabilities under control by laying each selection to a set lay liability.
This spreadsheet allows the lay liability to be changed at any time, with previous results are retained in the spreadsheet.
Favourable results can see this staking method can pay surprisingly well.
 

10

 
4 Ways to Lay.  4 Laying staking plans in one Excel file.    
Lay a percentage of a bank.    Lay a percentage of a profit target.
Lay to a set liability.     Level stakes.
Compare 4 staking plans and find the one that suits you best.
Lay for bigger profit, or maybe less risk.


20


Rolling Lays staking plan.  
Play up your winnings from successful lays.
Extract profit as your lays progress.


10


Risk free trading.  New bookie sign-ups, and Arbing.    
Trade bookies Free Bets for new customers. 
Guaranteed winnings from trading a mathematical certainty.
Build up your trading bank - risk free..
These are the easiest trades of all - r
isk free trading, BIG profits, zero risk.
This is free money.
10

Hedge Your Bookie Bets
Trade with zero risk (Arbitrage Hedging).
A very popular method used by many professional traders, especially in horse races..
Bet with a bookie and lay the same runner in Betfair for guaranteed winnings.
Bet high with a bookie and lay low in Betfair with no need to anticipate odds movements.
Commission is built into the lay side of the staking.
Get this right and you cannot lose.
5

Arb an Each Way bookie bet.    
Trade Each Way with zero risk (Arbitrage Hedging).
Another Arbing method used by many professional traders, especially in horse races..
Bet Each Way with a bookie and lay the Win and Place markets in Betfair for guaranteed winnings.
Compare bookie bet odds with lay odds in Betfair Win and Place markets before betting Each Way with your bookie.
Trade with no need to anticipate odds movements.
Commission is built into the lay side of the staking.
Get this right and you cannot lose.
10

Be A Bookie
Trade with zero risk (Arbitrage Dutching).
Bet all runners for guaranteed winnings.
The download web page for this spreadsheet contains instructions for how to use the Bet Dutching sheet of this Excel file to bet all runners to less than a 100% book for risk free guaranteed winnings.
Get this right and you cannot lose.
5

Bookie Refunds, plus Exchange refunds, added bonuses and free bets.  
Zero risk and low risk trades.
   
Lose Only Refund 
Zero risk with guaranteed winnings whatever the result of our trade.
It doesn't matter if we hit a winner or a loser, or if our bet odds are smaller than our lay odds.
The refund allows us to trade to guaranteed profit with no risk to our bank.
5

Percentage Added to Winnings 
Zero risk with guaranteed winnings whatever the result of our trade.
It doesn't matter if we hit a winner or a loser, or if our bet odds are smaller than our lay odds.
The refund allows us to trade to guaranteed profit with no risk to our bank.
5

Monthly or Weekly Refund of Losses 
2 trading methods.
A single trade with zero risk and guaranteed winnings whatever the result, win or lose.
Using this method, it doesn't matter if we hit a winner or a loser, or if our bet odds are smaller than our lay odds.
The refund allows us to trade to guaranteed profit with no risk to our bank.

2nd method.  Several trades with some risk but only if we hit a winner or winners.
Hit a series of losers and our lay stakes (and our potential profit) increase as our potential refund grows.
5

Trade Accumulator Free Bets, Refunds and Bonuses 
How to to profit from bookie accumulator free bets, refunds, and bonus payments.
If the bookie offer allows us to choose runners with time between events, we can trade with
Zero risk for guaranteed winnings whatever the result of our trade.
It doesn't matter if we hit a winner or a loser, or if our bet odds are smaller than our lay odds.
The bookie offer allows us to trade to guaranteed profit with no risk to our bank.
If the bookie offer forces us to bet events that all kick off at the same time, there is some risk.
10

Betfair or Betdaq Lose Only refunds,  bonus payments,   and free bets  
This package of 3 spreadsheets covers Lose Only refunds, Percentage bonus payment added to bet or lay winnings, and free bets offered by Betfair or Betdaq.
These Exchange refund and bonus offers allow us to trade to guaranteed profit with no risk to our bank
It doesn't matter if we hit a winner or a loser, or if our bet odds are smaller than our lay odds. . . . . .Stake correctly and we can trade with zero risk to guaranteed profit.
15

Hedging spreadsheets for your own trading strategy.
Bet High and Lay Low for guaranteed profits.
   
Lay In Bits             Bet and then place a series of lays at different odds.
                             Equalize your whole trade for an equal profit or loss.
10

Hedge Your Bets.  Hedge a single Bet or Lay on one runner 5

Hedge Several Bets.  Hedge a series of Bets and/or Lays on one runner 5

Hedge 3 Bets.  Hedge a series of Bets and/or Lays on up to 3 runners 10

Hedge To A Profit Target.  Win a specific amount. 5

 5 Hedging Excel spreadsheets.  Hedge Your Bookie Bets / Hedge Your Bets / Hedge Several Bets / Hedge 3 Bets / Hedge to a Profit Target. 15

Dutching spreadsheets for your own trading strategy.
Bet or Lay more than one runner.
   
Dutch BET to Break Even Excel spreadsheet 
Bet up to 25 runners.
Stake to break even on some runners but show an equal profit on others.
10

Dutch LAY to Break Even Excel spreadsheet 
Lay
up to 25 runners.
Stake to break even on some runners but show an equal profit on others.
10

Be A Bookie Excel spreadsheet
Lay up to 25 runners for an equal profit or loss whatever the outcome.
Also includes Bet up to 25 runners for an equal profit or loss.
5

Set a Total Bet Stakes Limit.  Bet up to 25 runners with a limit on your total stakes. 5

Dutch to a Profit Target.  Bet up to 25 runners to win a specific amount. 5

 3 Dutching Methods.  Be a Bookie / Set Stakes Limit / Profit Target. 10

Be A Bookie.  LAY in Horse Racing Place markets  Excel spreadsheet.
Lay up to 25 runners in the Place market for an equal profit or loss whatever the outcome.  This spreadsheet shows your market position.
Betfair cannot display your market position properly in theses markets.
10

Be A Bookie.  BET in Horse Racing Place markets   Excel spreadsheet.
Bet
up to 25 runners in the Place market for an equal profit or loss whatever the outcome. 
This spreadsheet shows your market position.
Betfair cannot display your market position properly in theses markets.
10

Lay to a Set Liability  Take total control of your liabilities whilst Laying.
Lay up to 25 runners for a liability of your choice.
As you lay more runners, your liability remains constant at a level of your choice, but the total of your Lay stakes increases.
Clean up with the total of all your lays if you don't hit the winner.

5

 

Strategies    
1 or 2 Losers.  Lay several horses, golfers etc, targeting 1 or 2 to lose, but win on all the others layed. 10

Football strategies    
Hedge Under 1.5 Goals with insurance.  Bet and lay the scores 0-0, 1-0, and 0-1 instead of betting and laying in the Under 1.5 Goals market. 10

1 or 2 Losers.  Lay several selections in First Goal Scorer market, or Correct Score market, etc targeting 1 or 2 to lose, but win on all the others layed. 10


Hedge 1-1 score line.  With or without an insurance bet. 10

Bet first, lay 2nd - - - -  Dutch and Hedge 2 Betfair markets      
Use this spreadsheet to bet several selections in 2 different markets . . . . using single bets.
Also, after placing bets, lay any individual bet to equalize that part of the trade.
The spreadsheet shows our whole market position after commission deductions, across both markets combined
10

Lay first, bet 2nd - - - -  Dutch and Hedge 2 Betfair markets     
Use this spreadsheet to lay several selections in 2 different markets . . . . using single lays.
Also, after placing lays, bet any individual lay to equalize that part of the trade.
The spreadsheet shows our whole market position after commission deductions, across both markets combined.
10

 New.  Bet first, lay 2nd - - - -  Dutch and Hedge TWO Betfair markets placing SEVERAL BETS per selection if required
Trade Correct Score with any other related market.
This spreadsheet can accommodate any number of bets per selection.
Use the balanced staking of Dutching or use your own stake sizes.
The spreadsheet can combine both of those if you choose to Dutch and also enter your own stakes as your trade progresses.
Lay any score or other selection at any time for a bet and lay of any selection to equalize that part of your trade.
 

15

 
 New. Bet first, lay 2nd - - - -  Dutch and Hedge THREE Betfair markets placing SEVERAL BETS per selection if required
Trade Correct Score with any other 2 related markets.
This spreadsheet can accommodate any number of bets per selection.
Use the balanced staking of Dutching or use your own stake sizes.
The spreadsheet can combine both of those if you choose to Dutch and also enter your own stakes as your trade progresses.
Lay any score or other selection at any time for a bet and lay of any selection to equalize that part of your trade.
 

20

 
Trade the Winning TeamLay the Winning Team in the Match Odds market, and Bet scores on the Correct Score market. 5

Multiples spreadsheets.    
Lay or Bet a Yankee.  This spreadsheet shows the staking required to Lay or Bet a Yankee, one runner at a time, rather than all at once.
Commission deductions are built into the calculations.
Lay 4 selections in a Yankee.
Bet 4 selections in a Yankee.
5

Lay a Union Jack.  Lay 9 selections in 8 trebles. 5

Lay 7 Trebles  Lay 12 selections in 7 trebles. 5

Lay Accumulators
You may decide to bet and lay an accumulator, in a similar way to betting and laying an odds movement for a single runner.
With more runners involved, that has the potential to pay much better than trading a few ticks for a single runner or team.
Alternatively, you may be looking to trade a bookie refund offer or a free bet that involves an accumulator bet.
Whatever your reason for laying an accumulator, this spreadsheet package should be able to sort out the staking for you.
Note that this is the same Excel file as the one higher up this web page for trading bookie accumulator free bets and refunds.
10

Bet or Lay a Trixie in an exchange.      This spreadsheet shows the staking required to Lay or Bet a Trixie, ( 3 doubles and a treble ) one runner at a time, rather than all at once.
The Excel file contains a spreadsheet for betting a Trixie, and a 2nd spreadsheet for laying a Trixie in an exchange.
Commission deductions are built into the calculations.
Lay 4 selections in a Trixie.
Bet 4 selections in a Trixie.
10
Combine horse racing markets.    
Bet Win, Bet Place.     NEW
Betfair Each Way market odds may not always keep in step with the Win and Place odds for some runners.
As the odds fluctuate, betting Win & Place may pay better or worse than betting Each Way, even after commission deductions..
Compare the markets to take advantage of the difference in the odds.
Alternatively, vary the stakes between Win and Place markets to see what effect that has on profit & loss for different results.
10
Lay the Extra Place     NEW
Bet the normal Place market and lay the "Extra" Place market and bet odds will be bigger than lay odds.
Hit a losing trade only if one of your runners finishes in the "Extra" place offered by the Extra Place market.
Example :- Bet in "3 to be placed", and Lay in "4 to be placed".
Using the staking in the spreadsheet, only a horse that finishes in 4th place will be a loser.
The spreadsheet shows the staking to profit from all other finishing positions, including unplaced runners.
10


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 2017 All rights reserved
Copying text or any other kind of content from a web site is a criminal offence.