Horse racing strategiesExcel Trading Spreadsheets

Free On-line Calculators.

These on-line calculators were originally put together for my own use whilst betting and laying horse and football markets.
Some of them convert odds or other information into something a little more useful, whilst others were designed for a specific strategy.
I hope you find these free calculators interesting, and perhaps useful.
Calculators are positioned to the left of your screen so that you can minimise your screen and place them alongside your Betfair market.

Please bear in mind that all betting and laying just within an exchange carries risk.
The only way to trade risk free is to use a bookie for the bet end of a trade.
I expect that you will probably be well aware of that by now.
In the write-up for each calculator, I try to highlight in red the risks / problems that I have had when using that particular calculator.
You may of course have other unforeseen problems.

Warning :-
The owner of this web site cannot be held responsible for any losses incurred whilst using any calculator or spreadsheet associated with this web site.

Calculators

Combined or Coupled odds

Bet exchange accumulator

Betfair Queue & odds movements

Insurance bet or lay

Dutch 3 Lays and L.T.D

Graphs showing Ticks

Combined or "Coupled" odds.
Use this calculator to show the Combined Odds of up to 10 runners.
You may be using a staking plan spreadsheet, betting or laying one runner at a time, but decide you need to bet or lay more than one runner in your race or game.
Dutch your bets or lays and you can use the Combined Odds of your runners for just one row of input in your spreadsheet for all your runners.
Any kind of Dutching - - - - Dutching with a set stakes limit, Dutching to a profit target, etc., will work ok with Combined Odds.
Input the odds of your Dutched runners into this calculator and then use the Combined Odds for a single odds entry in your staking plan.
Follow this link for a selection of Dutching spreadsheets

The balanced staking of Dutching returns the same profit or loss if you hit a winner or a loser.
If you are not Dutching your stakes, Combined Odds isn't going to work for you, as your profit or loss for each runner will not be the equal.

Name your runners and input up to 12 odds.
Combined or Coupled odds are highlighted in yellow.
The total book percentage of your runners is in orange.
Follow this link for a video description of Dutching and using Combined / Coupled odds.

 

Bet an exchange accumulator.
Use this calculator to bet an accumulator at Exchange Odds.
To use this calculator, you will need time between each of your races or games so that you know the result of one before you bet the next.
Input odds and a starting stake.
After each event finishes, input the result as a One for hitting a winner, or Zero, or leave it blank for hitting a loser, and the calculator shows the next stake.
To see the potential total payout if you were to hit all winners, enter all odds and with all results as winners.
Commission is built into this calculator.
To see what bookie odds pay, enter your bookie odds and set commission to zero.

Need to bet more than one runner in your race ?
Put any old odds into the calculator for your race to show the Next Stake for your next runner.
Dutch your runners to a Set Stakes Limit of that amount and then overtype in the calculator with Combined Odds for a single line of input in this calculator.


 

Betfair Queue . . . .  plus, "Where is the money going ?"
Use this calculator to see what is, or is not being bet, and what is or is not being layed, . . . . . before or after you place a bet or lay.
Use this calculator to see where you are in the Betfair queue. . . . . How close you are to getting your stakes matched.

The graph that Betfair provide for each runner shows where the odds have already been. . . . That's history.
This calculator was designed as an indicator for where the odds could be most likely to go next using the same information, but presented in a different way.

Betfair queue position :-
Name your team, horse etc..
From the Betfair graph, input the amount waiting, the "To Bet", or "To Lay" into the calculator from the blue or pink columns in the Betfair's graph info.
Also input the "Traded" amount. . . Enter that number in the "Original Traded" cell in the calculator.
Then, refresh the Betfair graph by clicking on another runner and then clicking your runner again.
Input the "Traded" amount but this time in the "Current Traded" cell in the calculator.
Keep refreshing your runner and updating the
"Current Traded" cell in the calculator.

The calculator will show how much is still left to match, and how much has been matched since you started updating the calculator.
I am unable to show negative numbers in red text, so if the word "Negative" pops up, your Current Traded amount has exceeded the "Target Traded" amount.
When you see a negative in the "Still left to match" column, your bet or lay should be matched, or a bit earlier if other traders have cancelled their trade.

Where might the odds go next ?
Set your own percentage limit and this calculator indicates whether the odds may be about to move up or down based on your inputs.
Update the "Traded" amount in the Current Traded grey cells as described above.

If the % Ratio column hits your Trigger %, an indication will appear with a suggestion as to which way the odds may be about to move.
That is only an indication that one side has been traded more than the other and has hit your % Trigger.
No-one can predict the future - - - - - what the odds will do next.
If the odds change whilst you are doing that, you need to overtype your new odds, plus the Original Waiting & Original Traded amounts in the calculator..
Then carry on updating the "Traded" amount in the Current Traded grey cells as before.

To cut down on typing by 50% or so, input your odds and only the Originally Traded amount. . . . . and ignore the Original To Bet, To Lay amounts.
Leave those blank..
Then just update the "Current Traded" amount in the grey cell.
You will get less information, but speed things up with less effort.

Horses.
Look for a race with 3 horses with odds in single figures, and all the others at big odds.  - - The betting suggests that it is a 3 horse race.
If one or more of the first 3 in the betting shorten, the odds of the other one or 2 must lengthen to maintain Betfair's near 100% book percentage.
If one or more of those 3 odds get bigger, the other one or 2 must get shorter.
The only thing that will prevent that is the odds of the outsiders moving instead of the 3 shorter priced runners.

Football Match Odds.
Use this calculator with a Match Odds football market to monitor all 3 outcomes. 

To keep pace with a market, it may be best to use this calculator well before Race Time, or Kick-Off, when the odds are not moving quickly.
I have had problems in very big markets . . . . One selection that may appear to be very quiet, can suddenly make a move, having been hit by a very big bet or lay.
I found that smaller markets that I expected might be more volatile, proved a little more reliable.
Use this method as an odds movement indicator, and you will still have your ups and downs.  . . . . . Does anyone really know where the odds will move next ?

 

The video below describes a spreadsheet version of this calculator.
How to use it as an indicator of potential odds movements is described in the 2nd half of the video, and especially towards the end
.
For a bigger view, click on the small 4 cornered icon, bottom right of the YouTube screen.

 

Insurance Bet or Lay stake to include commission.
If you need to place an insurance bet in a separate market from your main trade, there will be commission to pay if you hit a winner with your Insurance Bet or Lay.
If you are insuring for a large amount, you could lose quite a bit due to commission deductions in that separate market.
The calculator below shows the stake required to win your chosen amount, including commission deductions.

Input bet or lay odds and the Target amount you need to win with a winning bet or a successful lay.

Dutch 3 Lays and L.T.D. (Lay The Draw) Exit strategy.
Place one or more Lays in a Match Odds football market and use this calculator to show the Lay stakes required to equalize the whole trade for an equal profit or loss whatever the result.
This is the equivalent of a "Green Up" button that you may have seen in trading software, but this is a Dutching method, not a bet and lay Hedge green-up.

You may find other uses for this Dutching calculator.
Below, (later this week) will be a Lay The Draw exit strategy which can be used if the odds of the Draw don't lengthen after the first goal.
Note that this strategy is aimed at damage limitation rather than an exit to profit, and it is also high risk, if the score gets to 1 - 1 at the "Wrong" time.
Instructions.
The calculator has 3 sections at the bottom, one for each of the 2 teams and the Draw.
Name your teams and draw half way down the calculator.
Input odds and stakes of your lays in the 3 bottom sections.
The current position of your trade for each of the 3 outcomes is shown at the top in the middle.

To see the Dutching stakes required to equalize your trade, enter the current odds in the yellow cells.
A range of odds and stakes are shown.
Top left in yellow shows the the profit or loss if you place the stakes shown on the yellow row next to your odds inputs.
The "If Layed" columns in the middle part of the calculator show profit or loss if you lay amounts shown at those odds.
Lay the odds and stakes shown on the yellow row, and your profit or loss should be that shown top left of the calculator.
Lay the odds and stakes in the pink cells, and P & L will be slightly different from the top left yellow cells.

Insurance Bet.
The Insurance Bet odds & stake facility is provided for use with Lay The Draw trades if you place an insurance bet on 0-0, or something else.
Input odds and stake, and bet profit will be added to the P & L of the left - most section of the calculator, but taken off P & L for the middle & right sections.
That allows the calculator to show 0 - 0 bet profit in Correct Score combined with lay liabilities in Match Odds.
If a goal goes in and your 0 - 0 insurance bet becomes a loser, delete only the bet odds and the calculator will then see the 0 - 0 bet stake as a losing bet stake.
The bet stake will now be deducted from all 3 sections of the calculator, not just middle & right hand sections.
If you are not using an insurance bet, or not even doing an L.T.D. trade, leave the bet odds & stake blank.

L.T.D Exit strategy
This is nothing new.  I read about this method years ago in a forum somewhere and put a spreadsheet together for my own use to show the staking.
We have layed the Draw and the outsider of the 2 teams scores the first goal.
The odds of the Draw go down instead of up, so we cannot bet the Draw to exit to profit.
We have several options, . . . do nothing and hope for more goals, bet to exit our trade and take the hit of a losing trade, or start to Dutch the 2 teams in Match Odds, hoping for an early equalizing goal that gets the score to 1-1 so that we can make a clean exit with little or no financial damage.
Dutch Match Odds exit Strategy if we are expecting
an equalizing goal from the favourite team :-

  • With the score at 1-0 or 0-1, Lay the winning team for a chunk of what would be an equalizing lay at the current odds.
    Look for to break even if that team wins, or perhaps an acceptable loss.

  • At a score of 1-1, lay both teams at the current odds to Dutch all 3 outcomes to equalize the whole trade.

Problems can occur if we have layed the winning team, but the score remains 1-0 or 0-1 well into the 2nd half of the game.
After about 65 minutes or so, if a goal goes in to get the score to 1-1, the odds of the 2 teams may not be small enough for a good exit without too much damage.
Also, a goal very late in the game that gets the score to 1-1 may not leave enough time for the Match Odds market to reform before the final whistle.
If that happens, there will not be time to trade out.
Perhaps a speculative lay of the current score, 1-0 or 0-1 at very short odds may help as that could be done very cheaply at very short odds.
A very late goal would see profit from that lay, but if no later goal is scored, the payout on 1-0 or 0-1 can be quite small.

 

Video 1.  This old video describes a spreadsheet version of this Dutch 3 Lays calculator.
Apologies for the poor sound quality.
Please turn up your volume.
Video 2 describes an L.T.D Dutching exit strategy that can be used with this calculator.
To demonstrate the exit strategy, odds are used from a game that was already in progress, so no lays were actually placed.
Odds in the video are :- The Draw pre kick-off Lay 4.5.  After one goal, Watford Lay 2.72, Liverpool Lay 3.05, and at a score of 1-1, Watford Lay 7.4, Liverpool Lay 1.76.
For a bigger view, click on the small 4 cornered icon, bottom right of the YouTube screen.

 

A graph showing the number of Ticks moved.
I put this together in an attempt to see more clearly how odds interact.
Follow this link - - Opens in another window.
If something goes up, something else must come down to maintain the near 100% book percentage of Betfair markets.
This method of displaying Tick movements makes it easier to see how one set of odds are moving in relation to others.

Contact me
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.

Copying text or any other kind of content from a web site is a criminal offence.
Copyright H. Hutchinson 2017 All rights reserved
Copyright notice.  In the videos above, Betfair content shown is for demonstration purposes only,
and is presented with the kind permission of The Sporting Exchange Limited.  The Sporting Exchange Limited.

Parts of this page Copyright (C) 2002-2017 Framtidsforum I&M AB, Sweden

This site is a member of WebRing.
To browse visit Here.