NEW spreadsheet. See your whole
trade in a Correct Score format.
Trade up to 6 different markets and see the profit &
loss of your whole trade displayed beside each Correct Score.
See it all as if you had done everything in Correct Score.
Work out and test new strategies
without using cash.
Follow and work out what is happening in video trades.
Track the progress of your own trades ......... See it all in a Correct Score
format. This Excel file will also work using Libra Office, or Open Office.
Set up any markets in the spreadsheet
that involve score lines in the Correct Score market ........0-0, 0-1,
0-2, 0-3, 1-0, 1-1, 1-2, etc.
For example, Match Odds, Under/Over, BTTS, Win to Nil, etc. and of course,
Correct Score.
As you trade, use the spreadsheet to see your whole
trade in a Correct Score format, with profit & loss shown against each
of the scores, including commission deductions.
This spreadsheet can also be used to test new strategies without the
need to place any bets or lays.
A 2nd spreadsheet in this file
is provided for following video trades.
Pick the brains of video traders........ Work out what they do.
You may be able to improve on what you see in a trading video.
These spreadsheets can be
used to track your own trades or work out and test new strategies including
commission deductions across all your markets..
See what liabilities would be involved, and what the problems might be before you
"Live trade" your new strategy.
Video 1.
Bet and Lay up to 6 Markets
spreadsheet. Uses odds and stakes inputs - See how it works and what it can
do.
Input matched odds and stakes to see your whole current position.
Input un-matched odds and stakes for a "What if ?" view of the effect of
that against all scores.
Video 2. Follow a Video Trade, or use
this spreadsheet to track your own live trade.
Spreadsheet inputs are Profit & Loss only. Odds and Stakes are not used in
this 2nd spreadsheet.
Copy profit & loss that you see in Exchange screens or in trading software into
the spreadsheet, and update the P & L as the trade progresses.
Bet and Lay up to 6 Markets with Correct
Score display Excel spreadsheet £20.
You will need Excel 2007 or a later
version to view these spreadsheets.
2 spreadsheets are in this file
:-
Bet & Lay up to 6 markets with a
Correct Score display.
Follow video trades, or track
your own trade, again up to 6 markets, also
with a correct Score display.
The 2 separate spreadsheets within the file
allow you to set up the markets that you will use.
Use these sheets to help with the staking of your own trades, or to follow what
others are doing in videos & webinars.
The Correct Score display in both spreadsheets shows profit & loss against all
scores, just as if your whole trade had been done in Correct Score.
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.
Bet & Lay
up to 6 Markets with Correct Score display
spreadsheets price = £20.
Payment is by PayPal, but you don't need a PayPal account to use the payment
button below
Hedge Under 1.5 Goals with insurance.
This is a Bet First
strategy in which we look to trade during the First Half of a football match.
As you know, whilst the score remains 0-0, the odds of Under 1.5 Goals
drop as time passes in the game.
A bet on Under 1.5 Goals before the Kick Off can be layed to profit at
anytime whilst the score remains 0-0.
After one goal is scored, either 1-0 or 0-1 in the Correct Score market
(whichever is still In Play) and Under 1.5 Goals, become equivalent markets.
The odds of Under 1.5 Goals will be virtually the same as either 1-0 or 0-1 - -
- whichever is still In Play.
Quite often, after one goal in the First Half,
the market expects more goals, so the odds of Under 1.5 Goals can be bigger
after the first goal than they were before the Kick Off.
In such a game, it may be impossible to lay Under 1.5 Goals to profit
immediately after a goal has been scored without trading to a sizeable loss.
To exit to profit from such a trade usually involves sweating it out whilst we
wait for time to pass in the game and the odds of Under 1.5 Goals to drop.
Whilst we are waiting, we run the risk of a second goal making our whole trade a
losing bet.
This "Under 1.5 Goals with insurance" strategy gets around that problem in
most games by trading the scores
of 0-0, 1-0 and 0-1 and using an insurance lay, instead of simply
betting and laying in the Under 1.5 Goals market. Basic strategy.
Before the Kick Off, bet scores in the
Correct Score market.
Before the Kick Off, place a lay as
insurance against a 0-0 result.
As the game progresses with a score of 0-0,
we look to exit the market by laying our bets, and betting our insurance lay
for an overall profit.
As time passes in the game, we expect this profit to increase whilst the
score is 0-0.
If a goal is scored, Lay our one remaining
In Play score (either 1-0 or 0-1) in the Correct Score market to an overall profit
or an acceptable loss, to
exit the whole trade.
Note that a goal after about 30 minutes can often be very good for this
strategy.
When we trade this strategy, we bet and
lay the very predictable odds of 0-0, 1-0 & 0-1.
We look to exit to profit
whilst the score remains 0-0.
If a goal is scored, the profit from our insurance lay will often enable
us to trade to profit without having to wait for time to pass in the
game
before placing our lay on 1-0 or 0-1 (whichever is still In Play) to exit our trade.
An early goal can cause problems.
Also, as with any trade involving Under 1.5 Goals, 2 quick goals means
end of trade, but our insurance lay means that we don't lose our whole
bet stakes.
We place our insurance lay to help us to trade to profit after one goal
and keep losses down to an acceptable level if the first goal is scored early in the game, or 2 quick goals are scored.
If we are able to select low scoring games
with no goals or only one goal in the First Half, this strategy may
produce consistent profits in the long term.
For a description of how the odds perform in the Correct Score market,
follow this link. or click the
"Football Odds" tab at the top of this web page.
Hedge Under 1.5
Goals With Insurance Excel spreadsheets £10.
You will need Excel 2000 or a later
version to view these spreadsheets.
These spreadsheets show
the stakes required to :-
Dutch bet scores in the
Correct Score market to balance stakes before the Kick Off.
Hedge the 3
individual scores 0-0, 1-0 & 0-1
Links to
Videos describing this strategy are provided after purchase.
There is also a
detailed write-up.
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.
Hedge Under 1.5 Goals With Insurance
spreadsheets price = £10.
Payment is by PayPal, but you don't need a PayPal account to use the payment
button below
Hedge 3 bets.
This Hedge 3 Bets spreadsheet was built
specifically for trading the 3 outcomes of the Match Odds market in football matches, but you can
use this spreadsheet to
Bet and Lay 1, 2, or 3 selections in any market.
The only inputs required are your matched bets, to mirror your matched bets on
Betfair, and the current odds.
Hedge
(Bet and Lay) up to 3 selections in any
event - football, cricket, tennis, darts, horses, etc.
This Hedge 3 Bets spreadsheet
will enable you to keep track of exactly what you are doing whilst
placing a series of Bets and Lays.
Your
position in the market is shown at all times for each
individual selection.
Your
overall position is shown for all 3 selections combined.
You
can see exactly where you stand in the market at all times.
The spreadsheet
shows what you need to do next Bet or Lay, to equalize
each trade.
Equalizing stakes
are shown over a range of 9 odds increments, 4
either side of your current odds.
As the odds change within those 9 increments, there is no need
to update the odds on the spreadsheet.
Plan your next move.
The spreadsheet shows the effect that equalizing at each of
those 9 odds would have on your present position
You
can
input Bets or Lays on the spreadsheet to see "What If" situations, whilst the
game progresses, without messing about on Betfair.
These videos
demonstrate the Hedge 3 Bets spreadsheet - how it works and what it can
do. For a bigger view of the videos below,
click the icon with 4
small arrows near the bottom right
hand corner, just below the " T " in the word "Tube".
Excel spreadsheets are
a quick and reliable way
of doing calculations.
You can build a spreadsheet with the facilities described above, or purchase an
excellent spreadsheet here for only a tenner. Hedge 3 Bets spreadsheet.
You will need Excel 2000 or a later version to view this
spreadsheet.
This Hedge 3 Bets spreadsheet is
ideal for trading several transactions on up to 3 selections.
The spreadsheet calculates instantly the Bet or Lay stake required to equalize
your trades.
Input the odds of your Bets and Lays to mirror your Matched Bets and Lays on
Betfair, plus the current odds and the spreadsheet :-
Shows your current
position in the market for each individual selection..
Shows your current position in the market for all 3 combined
selections.
Decides for you
whether you need a bet or Lay in order to equalize your trade.
Shows 9 odds
increments, with associated stakes for equalization.
Shows the effect
that equalizing at each of those 9 odds would have on your
present position.
Allows 10 Bet and 10
Lay matched inputs for all 3 selections (60 in total).
The spreadsheet can be
used for trading - you can bet and lay a market for a single runner, golfer, football team, cricket team, tennis player, etc.,
or up to 3 selections. Bet first, or lay first, it makes no difference, this spreadsheet will
decide for you what you need to do next to equalize your trade,
and will display a range of stakes required.
Use this spreadsheet to place a
single Bet and Lay, or a series of Bets and Lays to an All
Green Screen. Stake and
Hedge correctly, and you cannot lose.
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.
Hedge 3 Bets
spreadsheet price = £10.
Payment is by PayPal, but you don't need a PayPal account to use the payment
button below.
Hedge 3 markets.
This is a modified Hedge 3 Bets spreadsheet.
Commission deductions have been added to the calculations to create a
spreadsheet for placing a series of bets and lays in up to 3 separate
markets.
Each of the 3 sections of the spreadsheet can be used to show the effect
of up to 10 bets and 10 lays, including commission deductions.
See your current
position in each market for your matched bets and lays
including commission deductions.
See your current position across all 3 markets including
commission deductions.
Input the current
odds, bet or lay, to see the stake or stakes required to
equalize any or all of your 3 markets.
The spreadsheet will
show whether you need a bet or a lay to equalize.
Input the current
odds, and a single cell shows what will happen to the whole of
your trade including commission deductions if you equalize at
those odds.
You can decide what to do next, equalize your whole trade, part
of your trade, place additional bets or lays, or wait a while. .
. . do nothing.
Hedge 3 Markets spreadsheet.
You will need Excel 2003 or a later version to view this
spreadsheet.
This Hedge 3 markets spreadsheet is
designed to show the effect of commission when trading up to 3 separate
markets..
Input the odds of your Bets and Lays to mirror your Matched Bets and Lays on
Betfair.
Input the current odds, bet or lay, and the spreadsheet :-
Shows your current
position in the market for each individual market, including
commission deductions.
Shows your current position in the market for all 3 combined
markets
including commission deductions..
Decides for you
whether you need a bet or Lay in order to equalize in each
market.
Shows 9 odds
increments, with associated stakes for equalization.
Allows 10 Bet and 10
Lay matched inputs for all 3 markets (60 in total).
The spreadsheet can be
used for trading - you can bet and lay a market for a single market,
or up to 3 separate marketss. Bet first, or lay first, it makes no difference, this spreadsheet will
decide for you what you need to do next to equalize your trade,
and will display a range of stakes required.
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.
Hedge 3 Bets
spreadsheet price = £10.
Hedge 1-1. This
Hedging strategy relies on a decrease in the odds of the 1-1 score line in the
Correct Score market, after a goal is scored or two goals are scored to get the
score to 1-1.
Whether you are
a seasoned trader or a beginner, this strategy offers quite a safe way of
trading.
Providing you stake correctly, you could make good percentage profits on
your initial stake if you are able to Hedge using this strategy.
An advantage of this
strategy is that it is a Bet First Hedge, rather than a Lay First Hedge.
Whenever you use a Lay First hedge (odds increasing), your profit will
always be less than your original Lay stake, but with a Bet First hedge, (odds
decreasing), your profit can be bigger than your original Bet stake.
If events go against you, a
Dutching strategy is suggested to enable you to continue
trading in the match. Basic Strategy.
Before the kick-off,
place a 1-1 Bet in the
Correct Score market.
Place an Insurance
Bet.
Whilst there are no
goals, do nothing - you will break even.
After a goal is
scored, Lay your original 1-1 Bet score line to profit if the
Lay odds are lower than your original Bet odds.
Examples of
risks.
A goal may be scored
but the 1-1 odds may not shorten sufficiently to enable a
successful Hedge.
For example, the first goal may be scored very early in the
game, or if the game is looking very one-sided, the market may
judge that the losing side will not equalize to get the score to
1-1.
2 quick goals scored
by the same side can take the score to 2-0 or 0-2 before we have
had time to place our 1-1 Lay or exit strategy bets whilst the
score is 1-0 or 0-1.
This type of problem of course applies to other strategies.
If you were trading the Draw in the Match Odds market, a quick
goal by both sides taking the score to 1-1, would cause trading
problems.
Hedge 1-1 Correct
Score Excel spreadsheets £10.
You will need Excel 2000 or a later
version to view these spreadsheets.
This spreadsheet can be
used to show
the stakes required to :-
Hedge a 1-1 score
line with an insurance bet.
Dutch the markets if
the odds do not shorten sufficiently for a successful Hedge in
the Correct score market.
Note that this
spreadsheet is also suitable for other Correct Score trades.
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.
Hedge 1-1 Correct Score
spreadsheets price = £10.
Payment is by PayPal, but you don't need a PayPal account to use the payment
button below.
