Spreadsheet for Red Card Refunds

Latest posts by Man of Mystery (see all)

Forum Discussion from BetSeventyTwo

by Betformulas » Fri Jan 08, 2010 8:53 pm

A spreadsheet showing the stakes for trading these offers can be downloaded here: Red_Card_Refund . You will need Excel 2000 or a later version to view the spreadsheet.

There are 2 spreadsheets accessed via the Tabs at the bottom of your Excel screen.

This is my strategy :-

Bet with the bookie in the bookie’s specified market.

Lay the same selection in the equivalent market on your exchange.

There will be a small loss due to the difference in the odds and commission on the lay side of the trade.

Then in the Sending Off market on our exchange we can either

Lay Red Card = Yes . . . .OR

Bet Red Card = No.

An offer of a refund of your losing stake if a player is sent off has 4 possible outcomes :-

Our bet loses and there is a red Card.

Our bet loses and there is NO Red card.

Our bet wins and there is a red card

Our bet wins and there is NO red card.

I have put this spreadsheet together to trade these offers but I have been unable to cover all 4 outcomes.

Usually there will be liabilities on one of the 4 possible outcomes.

The spreadsheet has 2 Adjustments.

A first adjustment can be used to favour either a win or lose outcome of the hedge of your bookie bet if you have an opinion or you decide to overlay.

The 2nd adjustment can be used to balance your profit or loss of the whole trade across all 4 possible outcomes.

Note that you may need a negative input if you decide to Bet Red Card = No.

Before placing your bet or lay in the Sending Off market, it may be best to try both options using the spreadsheet to see if a bet pays better than a lay or a lay pays better than a bet in the Sending Off market.

Note that I have not yet tested this spreadsheet with my cash.

The spreadsheet has protected cells to prevent overtyping of the calculations.

I have left the calculations visible so that you may get an idea of how the sheet works.

The sheet is not particularly tidy. It is functional rather than pretty.

SportingBet have a Red Card Refund offer on Premiership games this weekend, Jan 9th & 10th 2010.

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.

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.

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

All results for the 30,635 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.

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.