Matched Betting Calculator Overview

Matched Betting Calculator Overview

Matched Betting Calculator Screenshot

Thank you for expressing an interest in our Matched Betting Calculator.

To make sure that you’re comfortable with the concept of Matched Betting we have updated our Matched Betting Calculator to include three typical scenarios .. an example Qualifying Bet, an example Stake Returned Free Bet and an example Stake Not Returned Free Bet.

Simply download the latest version of our Matched Betting Calculator then follow the guidance depending on which stage of the Matched Betting process you’re at.

Please note that you will need a compatible application that can open an Excel Macro-Enabled Workbook (What is an XLSM File?). Microsoft Office Excel is the primary software program used to open XLSM files. Additionally, the free OpenOffice Calc, Google Sheets or Kingsoft Spreadsheets will also open XLSM files.

Step 1

Qualifying Bet

The following example uses real odds which were taken from a football match between Notts County and Bradford on 14th March 2015.

As demonstrated in our Matched Betting Tutorial we initially found a Free Bet offer where the Terms and Conditions informed us that we must place a Qualifying Bet of £10.00 in order to unlock a £10.00 Free Bet. This was with the Bookmaker Coral and was valid for new customers.

 

  • First, input £10.00 as the “Back Stake”.
  • Second, input £0.00 within the “Of which free” and “Stake forfeit” cells as these only need to be modified if using a Free Bet amount.
  • Third, input the “Back odds” as 2.50 and the corresponding “Back commission %” of the Bookmaker (in this instance 0.00).
  • Fourth, input the “Lay odds” as 2.54 and the corresponding “Lay commission %” of the Betting Exchange (in this instance 5.00).

 

Matched Betting Calculator Qualifying Bet

Finally, all that’s left to do is physically place your bets. Odds can (and do!) change so be prepared to place your bets quickly one after the other. It helps to have both the Bookmaker’s betting slip and the Betting Exchange’s betting slip filled out in advance prior to “Confirming” your bets. We prefer to use the likes of Betfair or Betdaq as our preferred Betting Exchanges as they offer the most liquidity in comparison to others. It is advisable to open up both betting slips in separate browser windows so that you can “Confirm” your bets without delay.

Irrespective of the result we’ll lose -£0.46 in this particular example. However, fear not, as we’ll shortly be credited with a £10.00 Free Bet amount from Coral which we’ll look to extract as much as possible when we get to the next step – placing the Free Bet.

Step 2

Stake Returned Free Bet

The following example uses real odds which were taken from a football match between Swansea and Liverpool on 16th March 2015.

Upon settlement of the Qualifying Bet we must wait until the Free Bet itself gets credited into our account and becomes available to “Match Bet” with.

Usually, Free Bets are credited within 24 hours. If you have met the Terms and Conditions of the Free Bet offer but did not receive your Free Bet within 72 hours it is advisable to contact the relevant Customer Services who’ll be glad to assist.

 

  • First, input £10.00 as the “Back Stake” into our Matched Betting Calculator.
  • Second, input £10.00 within the “Of which free” cell as we are now using our Free Bet and NOT our own money.
  • Third, input £0.00 as the “Stake forfeit” as this particular Free Bet is “Stake Returned” (only “Stake Not Returned” bets mean changing the value of this cell).
  • Fourth, input the “Back odds” as 3.60 and the corresponding “Back commission %” of the Bookmaker (in this instance 0.00).
  • Fifth, input the “Lay odds” as 3.60 and the corresponding “Lay commission %” of the Betting Exchange (in this instance 5.00) – and yes, it is possible to find both Back and Lay odds the same if you look hard enough!

 

Matched Betting Calculator Stake Returned Free Bet

Irrespective of the result we’ll win £9.63 in this particular example. Don’t forget that we must now subtract the loss amount incurred by the previous Qualifying Bet. However, we’re still £9.17 in profit overall. Not a bad result!

Alternative Step 2

Stake Not Returned Free Bet

The following example also uses real odds which were taken from a football match between Swansea and Liverpool on 16th March 2015.

If you run into a Stake Not Returned Free Bet then fear not.

Our Matched Betting Calculator also has an example which demonstrates what values to input where.

Similarly as before, upon settlement of the Qualifying Bet we must wait until the Free Bet itself gets credited into our account and becomes available to “Match Bet” with.

Usually, Free Bets are credited within 24 hours. If you have met the Terms and Conditions of the Free Bet offer but did not receive your Free Bet within 72 hours it is advisable to contact the relevant Customer Services who’ll be glad to assist.

 

  • First, input £10.00 as the “Back Stake” into our Matched Betting Calculator.
  • Second, input £10.00 within the “Of which free” cell as we are now using our Free Bet and NOT our own money.
  • Third, input £10.00 as the “Stake forfeit” as this particular Free Bet is “Stake Not Returned”.
  • Fourth, input the “Back odds” as 3.60 and the corresponding “Back commission %” of the Bookmaker (in this instance 0.00).
  • Fifth, input the “Lay odds” as 3.60 and the corresponding “Lay commission %” of the Betting Exchange (in this instance 5.00) – and yes, it is possible to find both Back and Lay odds the same if you look hard enough!

 

Matched Betting Calculator Stake Not Returned Free Bet

Irrespective of the result we’ll win £6.96 in this particular example. Don’t forget that we must now subtract the loss amount incurred by the previous Qualifying Bet. However, we’re still £6.50 in profit overall. Not a bad result .. but we could do better!

It is a bit more tricky to extract the full amount of the Free Bet when this is a Stake Not Returned Free Bet. This is because you need to find odds around 6.00 (or greater) and, ideally, your Lay odds need to be less than your Back odds.

Useful Tips

Feel free to play around with our Matched Betting Calculator by inputting some different values to our default examples.

For instance, inputting “Back odds” and “Lay odds” of 6.00 will increase the corresponding “Lay risk” at the Betting Exchange. As a result, you’ll need to have this amount deposited within your Betting Exchange account prior to the Sports Event commencing. This is to cover the risk IF your Lay Bet where to win.

If you were Matched Betting a £50.00 Stake Not Returned Free Bet (for example) at “Back odds” and “Lay odds” of 6.0 then the corresponding “Lay risk” jumps to £210.08. This might be too much money for a new Matched Bettor to deposit into their Betting Exchange account so always determine upfront the deposit amounts you’ll need to cover all outcomes!

Also, if you would like to modify the Matched Betting Calculator you’ll need the password to unlock the worksheet which is “laymybet”. Right click on the tab (“MATCHED BETTING CALCULATOR”), select “Unprotect Sheet” and then input the corresponding password.

Tags: