Matcher Spreadsheet – Instructions

Latest posts by Man of Mystery (see all)

The matcher spreadsheet is very easy to use and quickly works out equally matched returns for SR and SNR free bets, win or lose.

The examples below show a £100 bet at 5 with lay odds at 4.7 and commission of 5% on the lay. The spreadsheet loads with 5% as the default commission rate (cell D7) so unless you are using a different exchange or have already lowered your commission rate at Betfair, this will normally be correct. You can easily change it, and there is an option to enter commission for the back bet in cell D3 in case you are using 2 exchanges.

SR Free Bets, Qualifiers and Arbs

 

 

 

 

 

 

The screenshot shows the input for a SR free bet, a qualifying bet or an arb.

You enter:

The stake (£100) in cell B1.

The bookie odds (5) in cell B3.

The lay odds at Betfair (4.7) in cell B7.

The spreadsheet shows:

How much your bet will win at the bookie, including stake in cell F3: £500

Your liability at Betfair (this does not include the lay stake) in cell F7: £397.85

The overall profit assuming a SR free bet (for a qualifier or arb you need to subtract the bet stake from this) in cells B9 for if the bet wins and D9 for if it loses – note that these are exactly the same: £102.15.

The lay stake you need to use at Betfair in cell B11: £107.53.

The example chosen here is an arb, so you would make a profit of £2.15 even if there was no free bet involved, and £102.15 with a £100 SR free bet.

SNR Free Bets

 

 

 

 

 

 

The only difference for SNR free bets is that you enter the free bet amount (£100) in cell D1 as well as B1.

The spreadsheet then shows:

How much your bet will win at the bookie, not including stake in cell F3: £400

Your liability at Betfair (this does not include the lay stake) in cell F7: £318.28

The overall profit for a SNR free bet in cells B9 for if the bet wins and D9 for if it loses – note that these are again exactly the same: £81.72.

The lay stake you need to use at Betfair in cell B11: £86.02.

This example gives a profit on a £100 SNR free bet of £81.72. Higher odds would give a bigger profit for a SNR free bet.

You can download this spreadsheet here: matcher

This spreadsheet is in Excel format, but should also work with Openoffice.

JuiceStorm TV

Trading The UK, IE, US And AU Betfair Horse Racing Markets 24/7

The Betfair selections we are trading above are UK time. Only filled trades or bets appear on JuiceStorm TV.

Unsure how to get involved? Take a look here.

In 2021 TradeHost traded 7,937 Betfair UK, IE, US & AU horse racing and greyhound markets.

2022 saw TradeHost become even more profitable with 22,698 Betfair markets traded.

2023 less markets were traded – 17,459 – but a with a similar profit to 2022.

All trades and bets were streamed live on JuiceStorm TV which was was watched by 124,209 traders in 2022.

All results for the 48,094 Betfair markets traded are here and the charts are here.

Top 100 Comments on JuiceStorm.com

Racing Traders has over 20,000 registered members and more join every day. Find out why with a free trial.

BetTrader from RacingTraders.co.uk was the 1st application for Betfair & introduced the ladder UI. Invest £99 in yourself with a JuiceStorm EXCLUSIVE crypto only offer for a BetTrader lifetime license and no further payments.

Successful Betfair Traders have the simplest Betfair Trading systems. The difference is their selection process, experience and execution level. Get that difference for yourself with automated trading by TradeHost.

Our AI articles are NOT written by a real person and are provided for entertainment only. They may contain content which is inaccurate but we are hoping our AI bot, Rose, will become better over time. The AI category is the ONLY section of JuiceStorm.com that has zero human input.

Comments are closed, but trackbacks and pingbacks are open.

Comment Rules

  • Please show respect to the opinions of others no matter how seemingly far-fetched.
  • Abusive, foul language, and/or divisive comments may be deleted without notice.
  • Each JuiceStorm member is allowed two daily comments. Use them wisely.
  • Comments must be limited to the number of words displayed above the comment box.
  • Use branded capitalisation, eg. JuiceStorm, TradeHost, BetTrader, etc or John will get upset.
  • You agree that any comment you make may be used for marketing purposes by JuiceStorm.com.
  • You need more than 20 words? Click here for the largest Telegram community for Betfair Traders.