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 2 of 2
  1. #1
    New Member
    Join Date
    Dec 2014
    Posts
    1

    Opening balances

    Have been using the tracker for a while now, has been a great asset and easy to use - thankyou!

    Am looking to start a new tracker for next year and want to add my existing bookmakers balances.
    The only way I can see to do this is via the deposits tab but this makes the performance summary wrong as it look as if I have deposited funds rather than them already being available.

    Is there a way to add existing balances without messing the stats?

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

    Thanks, I'm glad you like the spreadsheet!

    When starting a new tracker you can enter your current bookmaker balances as deposits, although if you are starting with a net profit/loss what you can do instead is input your net deposits into the deposits sheet and then enter winning/losing bets to adjust each of your bookmaker balances to their current levels.

    For example, if you deposited $100 with Bookmaker A and the current balance is $140, you could input $100 as a deposit with Bookmaker A and then input a winning bet of $40.00 at 2.00 (decimal) odds. You could create bet type, tipper, etc. values like "Previous Records" or "Prior Results" to avoid distorting other categories.

    Alternatively, instead of inputting your net deposits with each bookmaker, you could paste in all of you deposits data from your previous spreadsheet. You could then input winning or losing bets for each bookmaker to reflect the current balance.

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

 

 

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
  •