Welcome guest, is this your first visit? Create Account now to join.
  • Login:

Welcome to the Australia Sports Betting Forum.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

Betfair
Results 1 to 14 of 14

Threaded View

  1. #1
    Moderator
    Join Date
    Aug 2011
    Posts
    989

    Entering each way bets

    Below is a suggestion for inputting each way bets into the betting tracker spreadsheet. The inputs below are based on example #2 here:
    http://en.wikipedia.org/wiki/Each-way_%28bet%29
    "A £10 each-way single on a 10-1 selection in a horse race and paying 1⁄4 the odds a place 1, 2, or 3 would cost £20."

    Note that the spreadsheet has been set to fractional odds in the Settings sheet to be consistent with the example above.

    In the spreadsheet you would input two lines: one at 10-1 odds and one at 2.5-1 odds. The sport, selection, bet type, event, and wager amounts are identical for both lines of the wager. You then update the two lines separately based on the event outcome.

    The bets have been entered into the spreadsheet three times to cover three scenarios:


    1. The horse places first
    2. The horse places 2nd or 3rd
    3. The horse doesn't place




    The payouts/profits for the three scenarios are as follows:


    1. You have a total payout of $145 for a net profit of $125 if the horse places first.
    2. You have a total payout of $35 for a net profit of $15 if the horse places 2nd or 3rd
    3. You have a net loss of $20 if the horse doesn't place


    Note that a bet type called 'Each Way' has been created in the settings sheet.

 

 

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •