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 7 of 7
  1. #1
    New Member
    Join Date
    Jan 2015
    Posts
    5

    Staking Plan Tracker

    Aussportsbetting,

    Firstly thank you very much for your spreadsheets and tools. I am finding them incredibly useful.

    I have a brief query regarding the staking plan spreadsheet. It seems my spreadsheet is only intermittently providing a staking recommendation whilst I'm inputting my bets. You can see this by the below image. Is there something I'm doing wrong?


  2. #2
    Moderator
    Join Date
    Aug 2011
    Posts
    989
    Hi elruss,

    Thanks, I'm glad you like the tools!

    The spreadsheet will only provide recommendations when it has sufficient data, like the date and the odds. It appears that the accumulator entries are throwing the spreadsheet off because they don't have all of the information filled in. What I will do for the next version is to try and make the approach you are using work with the background calculations. In the meantime, my recommendation is to input each accumulator as one line only. If you wanted to track which legs won and lost you could update the selection field with (W) and (L). For example for the first bet you would input:

    Selection: Perth (L), Tomic (W), Sixers (W)
    Fixture: Stars v Perth - H2H / Tomic v xx - H2H / Sixers v xx - H2H
    Score / Result: 1 leg lost

    You could unlock the bets worksheet (if you haven't don so already) and increase the column widths to accommodate the longer Selection and Fixture / Event entries.

    Hope that helps. Let me know if you have further questions.

  3. #3
    New Member
    Join Date
    Jan 2015
    Posts
    5
    Thanks for the prompt response admin. I think I'll leave as is and await the next version - I like having the functionality of tracking my accumulator leg types too much

  4. #4
    New Member
    Join Date
    Jun 2017
    Posts
    2
    Nice spreadsheet 10/10...is there a way to disable rounding off since my bookmaker does not round off so my available funds are not the same with bookmaker

  5. #5
    Moderator
    Join Date
    Aug 2011
    Posts
    989
    Hi x_mojojojo, have you tried changing the Currency Rounding in the General Settings sheet? Try changing this value from 2 to a higher number.

  6. #6
    New Member
    Join Date
    Jun 2017
    Posts
    2
    Thanks for the reply, i have tried that and still the available funds do not match.

  7. #7
    Moderator
    Join Date
    Aug 2011
    Posts
    989
    Hi x_mojojojo, one possibility is your bookmaker is calculating your payouts using a different odds system to the one they are displaying to you on their website. This is a common occurrence for bookmakers that enable you to choose which odds system to use. For example some UK bookmakers might have fractional odds of 1/3, which they display to you as 1.33 if you are using decimals. For a winning bet of $100 at 1.33 the spreadsheet would calculate a $133.00 payout while the bookmaker would pay you $133.33. The same can happen if the bookmaker is using American odds, e.g. -110 converts to 1.90909090..., not 1.91 exactly. The way to fix this is to change your odds display on their website to the one they're using to calculate your payouts and then also change the odds system in the spreadsheet Settings sheet to match theirs.

    If you're still unable to reconcile your payouts with those of the bookmaker I would create a bet type called "Account adjustment" and use winning or losing bets at 2.00 (if you're using decimal) odds to adjust your total profit up and down to reflect the actual payouts.

 

 

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
  •