Place ANY NUMBER OF BETS in your Correct Score trades, and use an Excel spreadsheet to see your overall position
across 2 or 3 markets including commission deductions.

The   2 Markets  spreadsheet available here shows :-

• The staking required to Dutch and hedge 2 markets using the balanced staking of Dutching,
• Alternatively, use it to Bet and Lay your trade using any stake sizes of your choice . . . . Do It Yourself . . . . . "Ad-lib" your staking
• or use the sheet to combine both . . . . . . . Dutching stakes  and your "Ad-lib" stakes.

The spreadsheet below shows the effect of commission deductions across 2 Betfair markets, to show the overall position of your trade.
Any number of bets can be entered into the spreadsheet for any selection.
After entering bets, enter lay odds, and the spreadsheet shows the lay stake required to Hedge any particular bets for an equal profit or loss - - - - - a "Green Up" facility.

This sheet can accommodate any number of bets.
Input odds and stakes info for your bets, and the sheet combines those to show combined bet odds.
We can now see what odds we need to lay at for a successful bet and lay Hedge of any score, or anything else we have bet such as
Under / Over Goals, etc. in another market.
If you have seen my other spreadsheets further down this web page for single Dutched stakes and laying to equalize, you will see that this new sheet uses the same layout.

The spreadsheet is set up to cover the Correct Score market, and up to 8 selections in a 2nd market.
It could be used for "Paper trade" practice purposes, or to help with staking of live trades.

This "Several Bets" spreadsheet is an expanded version of the Bet First, Lay 2nd spreadsheet described in videos further down this web page.
This video describes a 2 markets spreadsheet, with the facility for several bets using Dutched stakes, your own size stakes, or both.
The 3 Markets spreadsheet described above this one works in the same way as the one shown in the video.

______________________________________________________________________________________________

If we bet and lay in 2 related markets, Betfair is unable to show our whole market position across both markets.
Betfair cannot show losses or gains in 2 markets combined, so will only show our market position in the 2 individual markets.

The 2 football "Dutch and Hedge" spreadsheets below overcome that problem by showing our total market position across 2 markets, including commission deductions.
The Dutch and Hedge spreadsheets below were designed for use in football markets but can be used for trading across 2 related markets in any sport.

Trading related markets in Betfair.

• Losses may not be deducted before commission.
  When we trade across 2 or more markets in Betfair, we may think that we see a profit from our total trade, but commission deductions can put our whole trade into the red.
  That may not be obvious whilst we are trading.
  As you know,  losses in one market are not deducted before commission is deducted in a 2nd winning market, so trading across 2 markets rather than in one can be expensive

• Don't trade the same thing twice.
  If you trade across 2 or more related markets, it is very important that you don't trade the same thing twice.
  Example.
  The Scores 0-0, 1-0, 0-1 are the same as Under 1.5 Goals.
  It would be a mistake to lay those scores and also lay Under 1.5 Goals.
  If you make a mistake and Lay the same thing but in different markets, you could have payout on the same result twice instead of once.
  If you bet on the same thing and don't hit a winner, you will have more losing bets than expected.
  It is very important that you are sure of the relationships between Betfair markets.
  Betfair provides a wide range of markets for the same event, especially for football matches.
  Many of these markets may be related in that you could bet in one market and lay the same thing in another, or bet in both, or lay in both.
  Watch an  Equivalent markets video

• There's only one winner.
  As a shortcut, these related markets can save us time whilst trading and help to keep things simple.
  Unfortunately, these "Betfair shortcut markets" are of most benefit to Betfair.
  If we trade in a single market, losses are deducted from winnings before commission is paid.
  If we trade 2 related markets, losses in one market are not deducted from winnings in a 2nd market, so commission will be paid on total winnings in one market rather than total profit of the whole trade.
  Also, if we have a big loss in one market but smaller winnings in a 2nd market for an overall loss, we will still pay commission on the total of the winnings profit that we have in our 2nd market.
  If the whole trade was all in the same market, there would be zero commission to pay on a losing trade.

You are probably already aware of those points above.
The extra commission payments and losses not being deducted before commission don't do us any favours, but will be big winners for Betfair when they collect their commission.
We all trade across 2 related markets at some point, but it can be expensive.
Keeping track of our whole trade across 2 markets and getting the staking right is not easy.

__________________________________________

Spreadsheet feature :-
These spreadsheets are split into 2 sections.
These individual sections can be used to Dutch and Hedge a single market or 2 markets combined.
Dutching stakes are balanced and across both markets for an equal profit or loss before commission deductions.
Hedge an individual selection and the spreadsheet shows the stake required to trade that single selection for an equal profit or loss.
Note that due to Excel calculations working to several decimal places, returns may differ very slightly from what is shown on your Betfair screen.
Depending on stake sizes, there should normally only be a few pence difference between the spreadsheet and Betfair.

After payment via PayPal, select the "Return to merchant" option on the PayPal screen.
PayPal should then route you to a download web page where you can obtain the Excel spreadsheet file.

Use this spreadsheet to show the stakes required to bet several selections for an equal profit or loss in one or 2 Betfair markets.
Then, if you choose, as the odds change, lay to equalize individual selections for an equal profit or loss on those selections.
After betting, enter lay odds into the sheet for any of those individual bets and the sheet shows the lay stake required to equalize that individual selection for an equal profit or loss.

Our position is shown in the 2 single markets, and also across the 2 markets combined.
Commission deductions are built into the spreadsheet.

___________________________________

After payment via PayPal, select the "Return to merchant" option on the PayPal screen.
PayPal should then route you to a download web page where you can obtain the Excel spreadsheet file.

Use this spreadsheet to show the stakes required to lay several selections for an equal profit or loss in one or 2 Betfair markets.
Then, if you choose, as the odds change, bet to equalize individual selections for an equal profit or loss on those selections.
After laying, enter bet odds into the sheet for any of those individual lays and the sheet shows the bet stake required to equalize that individual selection for an equal profit or loss.

Our position is shown in the 2 single markets, and also across the 2 markets combined.
Commission deductions are built into the spreadsheet.

Contact me
Copyright © H. Hutchinson 2019 All rights reserved
Copying text or any other kind of content from a web site is a criminal offence.

How copyright protects your creative work

Intellectual property