Be a bookie Excel spreadsheets for Betfair trading.

BE A BOOKIE

Lay the odds in any market on Betfair for any sporting event using an Excel spreadsheet to show the stakes required.

Now is your chance to do all the things that you expect a bookie might do, and more !!

Lay in the Betfair win markets
Lay in the Betfair Place markets
Lay to a set liability Limit your losses whilst you increase your gains.
Target one runner to lose Lay lots of runners, but only one runner is a loser for you.
Lay multiple bets - The bets a bookie loves to lay.
Lay a Yankee
Lay a Union Jack for only a 1 in 10 chance of a payout.
Lay 7 trebles for only a 1 in 30 chance of a payout.
Hedge your bets If the odds of one of your lays increase, Bet that runner for guaranteed win or lose winnings.

There may be only one way to bet, but a bookie can use his own tactics to bias your bet stakes in his favour.
He may target only one runner, so that he only loses if that particular runner wins.
Although he accepts bets on all runners, he wins on all the runners except his targeted runner.
We can make this laying method work for us in Betfair horse race markets, football markets such as Correct Score, Half Time Score, etc., or any golf tournament, other market that has plenty of runners or selections.
Using the Excel spreadsheets available here, you can even target a single runner in Betfair horse racing Place markets.

A bookie may decide that the winner of an event should come from just 2 or 3 well fancied runners.
He might shorten his odds to avoid taking bets on those runners, and lay only the outsiders.
We can do that on Betfair, by just laying runners that we think may not win.
We can also make sure that our liabilities are equal on each of those runners, and we can bias our stakes in favour of one or more of those lays.
We can use an Excel spreadsheet to show all stakes required.
To sum up :-

We can do exactly what we might expect a bookie would do . . . . and more.
We can use an Excel spreadsheet to show the staking for our Betfair lays.
We can add our own variations to target one or more runners or bias our stakes in favour of one or more runners.
We don't have to lay every runner, and we get to choose the losers.

Use your selection method or system to choose which runners, football teams, scores, etc. to lay.
We all have our own method that we use to find winners in football matches, horse racing, golf, cricket, tennis, darts etc..
Why not use your betting system to find your winner and then instead of betting on your selection, lay the other runners ?
Add your own variations to bias your lay stakes and liabilities and you can :-

BE A BOOKIE

Be A Bookie Excel spreadsheet - Betfair Win markets

Be A Bookie Win market Excel spreadsheet £5
You will need Excel 2000 or a later version to view this spreadsheet.

Lay up to 25 selections to an equal liability.
This spreadsheet is suitable for any event - horse racing, football, cricket, tennis, snooker, etc.
Use this spreadsheet to show the stakes required to Lay all runners or Lay just a few runners to an equal liability.

As you input the odds of your selections, the spreadsheet shows :-

The Lay stake required for each runner.
Equal liabilities against each runner.
Liability on each runner reducing as more runners are Layed.
Percentage of your book at all stages.
Total of Lay stakes at all stages - "Skinner" amount.

The more runners you Lay, the less your liabilities become.
The more runners you Lay, the bigger the payout on a "Skinner" - a horse you haven't Layed.

Be A Bookie spreadsheet price = £5.
Payment is by PayPal, but you don't need a PayPal account to use the payment button below

Be A Bookie Excel spreadsheet - Betfair Place markets.
If you are skilled at picking runners that are not likely to make the frame, laying in the Betfair Place market can be a relatively safe way of trading.
Lay enough runners, and races can be reduced to an even money situation, or thereabouts.
For example, in an 8 runner race with payout on the first 3 places :-

You can stake for a very small profit or loss if 2 of the horses that you have layed finish in the first 3.
You can win or lose very similar amounts if 1 or 3 of the horses that you have layed finish
in the first 3.
1 placed in the first 3 and you have good profit.
3 placed in the first and your loss can be very similar to the size of those potential winnings.

Lay enough runners, and you will only lose if you hit all the placed horses with your lays.
That may not be what you would expect from a potential payout on 2, 3, (or 4 runners in a handicap with 16 or more
runners), but that is how the maths of the Place market work.
Follow this link for a detailed description of how you can Be A Bookie in the Betfair Place Market

Be A Bookie - Place Market Excel spreadsheet.
You will need Excel 2000 or a later version to view this spreadsheet.

This Be A Bookie Place Market spreadsheet calculates the lay stakes required to Lay up to 25 selections to an equal liability.

As you input the odds of your selections, the spreadsheet shows :-

The Lay stake required for each runner.
Equal liabilities against each runner.
Liability on each runner reducing as more runners are Layed.
Percentage of your book at all stages.
Total of Lay stakes at all stages - - - "Skinner" amount.
Guaranteed winnings on one placed lay if your total book is over 100%
Guaranteed winnings on 2 placed lays if your total book is over 200%
Guaranteed winnings on 3 placed lays if your total book is over 300%.

The more runners you Lay, the less your liabilities become.
The more runners you Lay, the bigger the payout on a "Skinner" - - - a horse you haven't layed.
In big handicaps, lay to a book percentage of over 300% and you will only have liabilities if you hit ALL 4 placed horses with your lays - - - - - otherwise you will make a profit.

This spreadsheet has an Adjust facility.
This Adjust feature allows you to bias your stakes in favour of one runner, or against that one runner.

For example, you may feel that the winner should come from the first few in the betting.
In a race of say, 8 runners, you may decide to Lay 5 of the runners, to break even on your first runner, but show a profit on your other 4 lays.
Stake correctly and you could :-

win if any one of the horses that you have layed is placed.
break even if one of those horses is placed, but make a bigger profit if one of the other 4 is placed.
clean up with a skinner if none of the horses you have layed are placed.

Be A Bookie - Dutch The Place Market Excel spreadsheet price = £10.
Payment is by PayPal, but you don't need a PayPal account to use the payment button below.

Dutching (Laying) to a Liability Target
This Dutching method offers total control of your liabilities whilst you lay up to 25 runners.
Use this spreadsheet to lay up to 25 runners for a liability of your choice if you hit a winner.

Dutching to a Liability target.
The stake on each runner increases as more runners are Layed.
The total stake (your "Skinner" amount if you don't hit the winner) increases as more runners are added.
Desired liability remains constant.

This Lay staking method may be suitable for use with a staking plan.

Lay big odds for small liabilities if you choose.

Limit the amount you lose if you Lay the winner - in any sport.
As you lay more runners, your liability remains at the level of your choice.
As you lay more runners, your Total Stakes increase.
If you don't hit the winner with your lays, all your lays are successful and you clean up with profit equal to the total of all your lay stakes.

A problem with this method of Lay Dutching is that the odds of all your selections need to be put into the spreadsheet before you start to place your lays.
If you alter any of the odds or you add another runner, ALL the stakes will change in order to maintain your liabilities at your chosen level.

How to Lay several ruinners at once on Betfair.

Click the Lay odds on Betfair and input your stake as usual, but don't hit "Submit".
Do the same for all your selections until you have all your lays with stakes on show.
Once you are satisfied with your staking, hit "Submit," and "Confirm" your Lays.
All your lays will be submitted together in one go.

Excel spreadsheets are a quick and reliable way of doing calculations.
Purchase an excellent spreadsheet here for only a fiver.
Dutch to a Lay Liability Target spreadsheet.
You will need Excel 2000 or a later version to view this spreadsheet.

This Dutch to a Lay Liability Target spreadsheet calculates the stakes required to Lay up to 25 selections for an equal liability if you hit the winner with your Lays.
The only inputs required are the names of your selections, the amount of the Liability that suits your comfort level, and the Lay odds of your selections.
The spreadsheet shows the stakes required for each selection and maintains the liability on all selections at the level that you set.
As you input more runners, the stakes adjust and your liability always remains the same.

The spreadsheet shows your Liability, total stakes, and for interest, the percentage odds of your selections, plus total percentage of your book..

This spreadsheet also has an Adjust feature which allows you to increase or decrease the size of your Liability on any individual runners whilst maintaining your chosen Liability target on all other runners.
You can therefore bias your liability on any runners that you think may be more likely to lose.

Dutch to a Lay Liability Target spreadsheet price = £5.
Payment is by PayPal, but you don't need a PayPal account to use the payment button below.

1 or 2 Losers Excel spreadsheet - Betfair Win markets.
Lay plenty of runners but make only one or 2 of your runners losers for you.
You win on all other runners that you lay, and if you don't lay the winner, all your lays are successful - you clean up with a profit equal to the total of all the bets you have layed - you have a "Skinner".

1 or 2 Losers Excel spreadsheets £10.
You will need Excel 2000 or a later version to view these spreadsheets.

These 1 or 2 Losers spreadsheets calculate the Lay stakes required to Lay up to 20 selections to reduce the liability on either 1 or 2 target horses.
You could of course use this spreadsheet for any event other than horse racing.
This Excel file contains 4 separate spreadsheets.

1 loser spreadsheet
Only the first horse will have a negative liability.
Once you lay more than 2 horses, a profit will be made on horses 2 to 20.
If you don't Lay the winner, you clean up with the total £££ of all your Lays.

2 losers spreadsheet
Only the first 2 horses will have negative liabilities.
Once you lay more than 3 horses, a profit will be made on horses 3 to 20.
If you don't Lay the winner, you clean up with the total £££ of all your Lays.

3 and 4 losers spreadsheets.
As described above, but these sheets target 3 or 4 runners to lose.

If none of the Layed horses win, you clean up with the total of all the Lay amounts staked - you have a "Skinner".

The more runners you Lay :-

The less your liabilities become on your target horses
The more profit you show on other Layed horses
The bigger the payout on a "Skinner" - a horse you haven't layed.

1 or 2 Losers Excel spreadsheets price = £10.
Payment is by PayPal, but you don't need a PayPal account to use the payment button below

Lay A Yankee Excel spreadsheet - Any Betfair market.
Bookies love multiple bets.
A big win on a multiple bet is often well adviertised in newspapers, but that is excellent free advertising for the bookies.
They know that it is very difficult to pick 4 or more winners in one bet, so if the publicity brings in more multiple bets from the betting public, that's good news for the bookies.
Place your lays in different markets, on different days or weeks - the timescale of your Yankee doesn't matter.

Lay just one loser in a Yankee, and you have 7 successful lays - the bet is reduced to 3 doubles and a treble.
Lay just one loser and you can pocket the profit from 7 successful lays and start a fresh Yankee.
If you are unlucky and hit a couple of winners, you don't have to complete a Yankee.

When was the last time you had a winning Yankee, or even hit 4 winners in succession ?
Lay Yankee bets on Betfair using this spreadsheet, and you get to choose the losers.

Lay Yankee Excel spreadsheet £5.
You will need Excel 2000 or a later version to view this spreadsheet.

This Lay Yankee spreadsheet calculates the stakes required to Lay each runner of your Yankee in sequence.
The only inputs required are the amount of your basic stake, which can be less than £2 and the odds of your selections.
A unit stake of 30p would be sufficient to start your Yankee with an initial Lay of £2.10.

As your Lay Yankee progresses, the spreadsheet shows

The stake required for each runner.
Your profit from successful Lays so far
The payout on any winners.
The combined profit or loss on losers or winners so far.

This spreadsheet can be used to Bet or Lay a Yankee.

Just 1 successfully Layed 50p Yankee could pay for your Yankee spreadsheet.

Lay Yankee Excel spreadsheet price = £5.
Payment is by PayPal, but you don't need a PayPal account to use the payment button below

Lay A Union Jack Excel spreadsheet - Any Betfair market.
The Union Jack is another very popular combination bet, at least with bookmakers.
This comprises 9 selections in 8 trebles.

9 runners, are set out in a 3 by 3 grid.
A, B, C
D, E, F
G, H, I
The trebles covered are 3 horizontally, 3 vertically and 2 diagonally.

With 9 selections, there are a possible 84 treble combinations, but a Union Jack covers only 8 of them, leaving the punter with less than a 1 in 10 chance of hitting a winning treble combination.
As a layer we can take advantage of this by laying those 8 trebles from 9 selections, just as bookies do.
It is possible to hit 6 winners with no payout.
An example of 6 winners with no payout is shown in bold above.
There will be other combinations.

Lay Union Jack Excel spreadsheet £5.
You will need Excel 2000 or a later version to view this spreadsheet.

This Lay Union Jack spreadsheet calculates the stakes required to Lay each runner in sequence.
The only inputs required are the amount of your basic stake, which can be less than £2 and the odds of your selections.
A unit stake of 70p would be sufficient to start your Union Jack with an initial Lay of £2.10.

As your Lay Union Jack progresses, the spreadsheet shows :-

The stake required for each of your 9 runners.
Your profit from successful Lays so far
The payout on any winners.
The combined profit or loss on losers or winners so far..

This spreadsheet can be used to either Bet or Lay a Union Jack..

Just 1 successfully Layed 70p Union Jack could pay for your spreadsheet.

Lay Union Jack Excel spreadsheet price = £5.
Payment is by PayPal, but you don't need a PayPal account to use the payment button below.

Lay 7 Trebles Excel spreadsheet - Any Betfair market.
Some bookies offer incentives to encourage punters to bet in multiples such as trebles.
That is a clear indication of how much bookies value these kind of bets.
Now you can copy what they do by Laying several trebles.

The spreadsheet below shows the stakes required to Lay up to 12 selections in 7 separate trebles.
With 12 selections, there are a possible 220 treble combinations, but this staking plan covers only 7 of them, leaving you with less than a 1 in 30 chance of hitting a winning treble combination with your 12 lays.
The treble combinations are arranged so that each selection appears a maximum of only once in any other treble.
For example, your first runner appears in only 1 treble.
Runners 2, 3, 4, 5, 6, 7, 8, 9, and 10 appear in only 2 trebles each, whilst runners 11 and 12 appear in only 1 treble.
If you were a bookie offering this multiple trebles bet, your customer, the punter could have the first 7 winners on his betting slip, and not have a winning treble.
Also, if his first 4 selections were losers, and then his last 8 selections were winners, he would still not have a winning treble.
Place your lays in different markets, on different days or weeks - the timescale of your trebles doesn't matter.

Normally when you bet on a double or treble, you select just one runner per race and any winnings are carried forward onto the next part of your double or treble, but when you Lay doubles or trebles, you don't have to Lay single horses.
As a Layer, you may choose to start several trebles in the same race, and guarantee several losing trebles in your first race.
This Lay 7 Trebles spreadsheet allows a maximum of 3 or 4 selections in any one race, depending upon the progress of your trebles.
If you don't hit the winner with those 3 or 4 selections, all 7 of your trebles will fail, and you will have 7 points profit.

You may of course, Lay less than 3 or 4 runners in each race.
The spreadsheet below, shows the Lay stakes required to Lay each treble as they progress.
Lay one runner at a time, or more than one runner.
The spreadsheet shows the stakes required to Lay 7 trebles from 12 runners, with in theory, a less than 1 in 30 chance of hitting a winning treble.

Lay 7 Trebles Excel spreadsheet £5.
You will need Excel 2000 or a later version to view this spreadsheet.

This Lay 7 Trebles spreadsheet calculates the stakes required to Lay each runner of your trebles in sequence.
The only inputs required are the amount of your basic stake, and the odds of your selections.
As your trebles progress, the spreadsheet shows

The stake required for each runner.
Your profit from successful Lays so far
The liability of your current lay.
Your Bank - profit or loss on losers and winners so far.

Lay 7 Trebles Excel spreadsheet price = £5.
Payment is by PayPal, but you don't need a PayPal account to use the payment button below.

Hedge Your Bets Excel spreadsheet - Trade odds movements in any Betfair market.
Whilst watching horse racing on television, you may hear the presenters in the betting market say that a bookie has sent money to the course to be bet on one of the runners.
If you were a bookie who had accepted 1 or 2 very bets on a runner, you would probably need to bet at least some of the amount you have taken, to reduce your liabilities and balance your book with the other runners.
The only other alternative would be to stand the whole liability and hope that the runner didn't win.

As a bookie it would be best if you could bet at higher odds than the odds that you offered for your lay.
If you can do that, you can make guaranteed winnings on the Bet and Lay part of your transaction, and your remaining lay liability can be used to balance your book against liabilities on other runners that you lay.

As traders, we can do exactly the same, providing the odds move in our favour.
Whilst we place our lays, the odds will move up and down.
If we have placed a lay and the odds increase, we can then bet the same runner and "Green Up" for guaranteed win or lose profit.
We could then lay again at lower odds if the odds shortened later.
Also, if we make a mistake whilst placing our lays, we may need to exit a trade by betting the same runner.
Losses can be kept to a minimum by placing a bet to equalize our trade for an equal profit or loss on the transaction.

Hedge Your Bets spreadsheet.
You will need Excel 2000 or a later version to view this spreadsheet.

Trade using just 2 transactions, a Bet and a Lay, or a Lay and a Bet.
This Hedge Your Bets spreadsheet calculates the bet or lay stake required to make a profit no-matter what the outcome of any event, provided your bet odds are higher than your lay odds.
Input your initial stake and the Bet and Lay odds for instant calculations.
The spreadsheet can be used for trading - you can bet and lay the market for a particular runner, golfer, football team, cricket team, tennis player, etc.
Bet first, or lay first, it makes no difference, providing the bet odds are greater than the lay odds, this spreadsheet covers both eventualities - bet first or lay first.

This spreadsheet has an Adjust facility that allows you to favour one outcome over the other.
In a football match for instance, a goal may be scored, and you may take the view that one team will probably win the match.
This spreadsheet shows the stake required to trade out to an equal profit win or lose, but a further input allows you to bias your stake in favour of your Bet or your Lay.
In this way, you have the option of boosting your hedge profit for a win or a lose whilst still having insurance cover of a smaller gain if events turn against you.

Note that.
These spreadsheets show the stakes required for a range of 16 different odds, thus eliminating the need to re-input the odds if there is a market move whilst you are trading.

Hedge your Bets and Lays to an All Green Screen.
Make an equal profit no-matter what the outcome, or bias your hedge one way or the other, giving a big or small gain to either side of your trade.
Hedge correctly whilst the odds move in your favour, and you cannot lose.

Hedge Your Bets spreadsheet price = £5.
Payment is by PayPal, but you don't need a PayPal account to use the payment button below.

CONTACT

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.