## 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 hopefully, a refreshing change from the usual free on-line calculators that show the staking for trading bookies free bets, or the returns from winning bets on multiples.

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, plus 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.

**Links down to Calculators ***o**n this web page :-*

Monitor your football markets OR work out the strategy in an on-line video trade

What % commission rate do you REALLY pay when you trade football?

Lay The Draw exit strategy L.T.D

ELS – Expected Losing Sequence

#### Keep track of your personal football trade across several markets as your trade progresses

**or – – – :-** work out the strategy of any on-line football video.

Follow this link to get a copy of this Hedge 6 Markets calculator that allows you to set up the markets of your choice.

No odds or stakes are required in the calculator below. Only profit or loss from each market is required.**All profit & loss amounts can be copied from Betfair or Betdaq or other exchange screens and entered into the calculator.**

Enter your commission rate at the top in the orange cell.**Enter profit as a positive number** **or loss as a negative** for different markets in the grey cells at the top, and profit or loss for Correct Score down the 2nd left column under C/Score.

Enter profit & loss for Match Odds, and that will appear down the 4th column, below the word “Draw”..

If there is a successful bet and lay Hedge profit in a market, enter profit in BOTH cells for that market. . . . If there is a Hedge loss, enter a negative in BOTH cells.

To see how the calculator works, enter bet profits only for your markets.

Now you can see all the scores that your bets cover, including commission deductions.

When you are ok with that, input some losses, using a negative input such as **-10**

Commission is built into the calculator.

The calculator combines the P & L for all your markets to show your overall position for each of the scores in the green column. . .

#### Football Markets Calculator

The video below describes the **Football Markets calculator**.

Copyright notice. In the video 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.

#### Analyse any on-line football strategy video

Quite often when we watch an on-line football trading video, there is no explanation of the aim of the trade, or the basic strategy.

I originally put this calculator together so that I could work out football trading strategies from watching YouTube videos.

This is how I go about that :-

- Using a pen and paper, watch your video and write down the bets and lays placed, plus the profit & loss shown in the Betfair screens.

Alternatively, just copy profit & loss directly into this calculator.

You may need to pause the video or replay parts of it to get those details.

if you write things down, you can go back later and re-use that information in this calculator. - Enter the profit & loss from the Betfair screens into the calculator for the initial set up of the trade.

Look down the green column to see which scores are in profit, which show a loss, and see if any scores still have zero against them.

Has anything been bet twice ? . . . . To check that, see the blue highlighted cells against each individual score.

We can at least see the starting position of the trade and how it was set up. - After that, as more bets or lays are placed in the video, update the P & L in the calculator for any market that changes.

That will keep you up to date with on-going profit & loss. - .If you manage to update the calculator to the end of your video, use the green column in the calculator to check the profit & loss, after paying commission across all markets
- You may also be able to use the Commission Rate calculator further down this web page to take a look at the commission rate paid across the whole trade
- If you manage to work out what has been demonstrated, you may be able to improve things a little to suit your own trading, or copy what is shown in your video.
- Can this trade be simplified and commission saved by trading everything in a single market such as Correct Score ?

Trading across several markets can be expensive in commission.. - Have any scores been bet more than once ?

You may find that even experienced traders bet the same score more than once when they bet in several different markets.

To see that, check the blue cells. If more than one cell is highlighted in blue against a score, that score has been bet more than once. - Can you avoid duplicate bets and improve the strategy by eliminating one of the markets ?

Problems.

Using this calculator to keep track of your personal trade ? – – – Updating the calculator whilst you trade will take time during your trade.

If analysing a video trade :-

Following a video trade is not easy. It may take quite some time to make a note of bet & lay and P & L details.

You may need to pause or replay parts of the video so that you can copy the profit & loss from Betfair markets onto paper or into this calculator.

In your chosen video, a skilled trader may start from a red position, but trade into profit as the game progresses.

That red start may not be obvious from the video or commentary, but the green column in the calculator will show what is happening.**It may pay to take note of game selection** in relation to the opening bets and lays shown in your chosen video..

Hit a game that doesn’t go according to expectations, and even a skilled trader may have problems making an exit with profit or an acceptable loss.

This calculator may help you to see how a trade started, and how it progressed all the way to an exit.

I repeat, “Following a video trade is not easy”.

#### Exact Goals odds . . . . . A guide to . . . . . How many goals do the markets expect will be scored?

We all look at Match Odds to see which team is most likely to win, but where do we go from there ?

If there was one, I have no doubt at all that an Exact Goals market in Betfair would be the 2nd thing to look at, but there is no such market.

The best we can do at present is look at Under / Over Goals, Correct Score, BTTS, etc..

To help us to trade a game, Betfair put several markets on the same screen, but how do you weigh things up across those markets ?.

Betfair doesn’t have a market for the Exact Number of goals to be scored.

We can use Correct Score to work out Exact Goal odds, but the normal Correct Score market bunches odds together for scores with 4 goals or more, with scores shown for such as 4-0, 0-4, 5-0, 0-5, 1-4, 4-1, 2-3, 3-2, etc. in 2 separate Correct Score markets, one for Home scores and another for Away scores.

The result of that is that we can work out accurate Exact Goals odds for 0, 1, 2, or 3 goals if we use only the normal Correct Score market, but for bigger scores, things get more complicated.

To look at Exact Goal odds for 4, 5, 6, or more goals we would need to look at 2 more Correct Score markets as well.

Also, in games with poor liquidity, there can be big gaps between bet and lay odds in Correct Score markets, or even no odds at all.

To get around those problems, we can use the Under / Over goals markets which usually have smaller gaps between bet and lay odds.

For example :-

If you bet Under 1.5 goals and bet Over 2.5 goals, and you have bet everything except 2 goals.

Using those 2 bits of information, we can work out the odds for 2 goals.

We can of course do the same for other exact numbers of goals.

In the calculator below, input bet or lay odds to see both bet and lay odds for Exact Goals.**The column on the right** shows the odds used to work out the Exact Number of Goals odds, but to understand how the odds have been worked out, **a bit of reverse logic is required.**

For example :- If we BET EVERYTHING EXCEPT the scores containing ONE goal, that is the same as LAYING one goal.

LAY EVERYTHING EXCEPT the scores containing ONE goal, and that is the same as BETTING one goal.

To see only Bet odds, input only the LAY odds from your Under / Over Goals markets, + both bet and lay odds for 0-0.

To see only Lay odds, input only the BET odds from your Under / Over Goals markets, + both bet and lay odds for 0-0.

**Note that** we do not need Over 0.5 odds. Also, we don’t need Under 8.5 odds (for odds for 9 goals).

0-0 odds from Correct Score can be used instead of Under 0.5 Goals odds.

A quick way to see what score will have the Favourite odds is to look in Betfair and compare the Over goal odds of one market with the Under goal odds of the market above.

For example compare **Over **1.5 with **Under** 2.5.

If the odds of both are less than 2.0, the goals in between will be the favourite in your Exact Goals market.

In that example, if Over 1.5 and Under 2.5.odds were both less than 2.0, then 2 goals would be the favourite odds. . . . **in red** in the calculator.

If it is odds-on that there will be more than 1.5 goals and odds-on that there will be less than 2.5 goals, the indications are that there will be 2 goals.

You do not need inputs in all the cells, . . . . . . just enough for you to see the shape of your market.

The **favourite odds** will be in red.

Compare the 2nd and 3rd fav odds.

2nd fav odds smaller than 3rd fav odds may indicate that the markets expect “Favourite or less” goals in your game.

3rd fav odds smaller than 2nd fav odds may indicate that the markets expect “Favourite or more” goals, a higher scoring game.

**Note that** to bet or lay Exact Goals using the Under / Over Goals markets will be costly in commission as your 2 stakes will be split across 2 separate markets.

To bet or lay Exact Goals, it **costs less in commission to Dutch the scores that add up to your number of goals in the normal Correct Score market** .. . .

BUT the normal Correct Score market only covers up to 3 goals of course . . . . with 4, 5, 6, etc. goals being split across 3 Correct Score markets.

The Exact Goals odds produced by this calculator are only approximate odds, based on a 100% book percentage.

The **Exact Goals video** below demonstrates the calculator.

The result of the game in the video was Bristol City 4 – 1 Crystal Palace, . . . 5 goals.

For a bigger view, click on the small 4 cornered icon, bottom right of the YouTube screen.

#### Football trading commission rates

If you trade football using more than one market, **you will probably be paying well above your normal commission rate.**

As you know, if we bet and lay in a single market, losses are combined with winnings and we only pay commission if there is a profit overall.

If there is no overall profit, (we break even or make a loss), Betfair and Betdaq charge zero commission.

If we bet and lay in more than one market, each of those markets is treated separately for commission deductions.

The result of that is that if we make a loss in one market but a profit in a 2nd market, total losses are not deducted from total winnings before commission.

Profit and loss in the 2 markets are not combined, therefore, we pay a BIGGER commission rate on our total trade.

Make a small profit in one market, but a bigger loss in a 2nd market, and we pay commission in the winning market, even though we make an overall loss on the whole trade.

In that situation, we pay commission . . . . . . on a red, losing trade.

**Use the calculator below to show your TRUE commission rate in**** past trades, or to test and improve your football strategy commission rate.**

In the calculator below input your normal commission rate, top left in the orange cell.

Name your markets and enter profit or loss for each separate market that you have used, and enter any commission paid.

For past trades, you can get that information from your exchange account statement.

Enter a loss with a minus sign, with no spaces . . . e.g ** ****-2.50**

Your inputs are added together in the calculator to show total profit or loss and total commission paid.

Those 2 totals are used to show the commission rate that you have been charged for the whole trade across your markets, in the yellow highlighted cell to the right..

The column on the far right shows the returns for your trade if you were able to place all your bets and lays in a single market, such as Correct Score, and pay your normal commission rate.

If you trade across more than one market, you may have more than one market with winnings.

If you make a profit in one market but a loss in another, for example a losing “Insurance bet”, you WILL be paying well above your normal commission rate.

**Test to improve your strategy**. . . . . . by reducing your commission rate.

Input your normal commission rate, top left in the orange cell.

Input potential profit or loss, plus commission paid at your normal rate where you anticipate a profit.

If you anticipate a loss in a market, enter the loss for that market in the P or L column.

When you have all your profits and losses plus commission payments in the calculator, compare the 2 columns on the right, especially the “% Comm rate” cells.

You may decide that you can improve your football strategy by trading it differently so that you pay far less commission.

One way to reduce commission payments could be to do more of your trade in Correct Score, so that you reduce the number of markets that you trade.

Note that if your total trade makes a Net Loss overall but you still paid some commission, . . . .the yellow cell will not work out a commission rate for you as you have had a losing trade across all your markets combined, . . . but still paid some commission.

If you had been able to do all of that trade in a single market, you would pay zero commission on the loss.

Use the calculator below to work out exactly how BIG your commission rate is for any football, or other trade.

Take a deep breath and be prepared to be shocked by the yellow cell . . . . . Lol.

Video 1. below demonstrates the Commission rate calculator.

The speradsheets used are **Be A Bookie** for the Dutching, and **Hedge 3 Markets** for the Hedging,

Video 2. Do it ALL in Correct Score – – – Lay The Draw with 0-0 insurance.

Do it all in a single market to save on commission for a bigger profit.

The speradsheets used are **Dutch LAY to Break Even ** for the Dutching, and **Hedge 3 Markets** for the Hedging,

For a bigger view, click on the small 4 cornered icon, bottom right of the YouTube screen.

#### 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 Strategies**

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.

**1. 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.

**2. Try this – – – Dutch Match Odds exit strategy with insurance :-**

If we lay a little less on the Winning team, we can place a lay towards the end of the game when the lay odds are very small.

That will cover a very late goal from the Favourite Team :-

If we anticipate that there may NOT be an equalizing goal from the Favourite Team (Liverpool in the 2nd video below) :-

With the score at 1-0 or 0-1, Lay the winning team for slightly less than an equalizing amount at the current odds.

In video 2 below, lay Watford for £10 instead of £11.63.

If the score remains 1-0, we could lay Watford again very late in the game at odds of 1.05 for £60 at odds of 1.05 for zero loss against the Draw, and a loss of only -£0.20 against a win for Watford.

If we lay very late in the game, there would be no need to lay Liverpool at all as there would be a very big profit from our successful lays of the Draw and Watford against a very late Liverpool win.

In the video, Liverpool scored an equalizer soon after the first Watford goal to get the score to 1-1.

At that point, with the score at 1-1 & after laying Watford for £10 instead of £11.63, lay the 2 teams at the odds shown in the video.

Lay Watford £8.49 at odds of 7.40 & Liverpool £51.14 at odds 1.76 – – – – for a loss against all 3 outcomes of close to -£0.38.whatever the result.

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.

#### 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.

#### 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 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.

#### Expected Losing Sequence . . . . E.L.S

Use this calculator to work out (estimate) how many consecutive losers you can expect to hit in your trades.

From your records of past results, or your estimate of the number of winners you expect to hit, input your number of bets and winners.

The calculator shows the E.L.S. based on the those figures.

Note that for the same strike rate, a big sample will show a bigger E.L.S. than a small sample.

I came across the calculation for “Expected losing sequence” whilst browsing the Internet quite some time ago, so put a small spreadsheet together.

I added a Profit & Loss calculation so that potential P & L can be worked out for bets at different odds.

Input your commission rate and Average Odds for your bets.

The P & L part of the calculator has zero influence on the E.L.S. part, so if you change your odds, the E.L.S will be unaffected..

To arrive at the net profit on the right in the green highlighted cell, **each bet has been treated as an individual bet.**

Commission has been taken off everything in the “Win” cell, and then the losses deducted from those winnings.

For example, if we were to place one bet per day for 100 days, 100 bets, and hit 60 individual winners and 40 losers :-

We would pay commission on each of those 60 bets, and then deduct the 40 losing stakes.

That is how the P & L has been worked out.

#### 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.