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
    Jan 2021
    Posts
    1

    Modification to the Performance Graph

    Hello,

    I have multiple bookie accounts and would like to create a graph which tracks the profit and loss from each individual bookie. I have no issue creating multiple worksheets but it would be nice to create a worksheet that showed the progress of each bookie's balance. Thanks for your help,

    Best Regards,

    Daniel Barton

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

    Yes, that should be possible. If you scroll to the right in the Bets worksheet you will come across the background workings. Look for the columns under "Used for Performance Graph". Unlock the sheet using the password sport, then insert new columns to represent each bookmaker you would like to graph. The new columns would contain a running profit for each bookmaker. The formula would be similar to the existing Profit column, except that it will add a condition so that it only updates the profit if the bookmaker is a specific name. So if the new column is BJ and the name of the bookmaker is listed in cell BJ11 then the formula for BJ13 would be =IF(AND(N13<>"M",A13=BJ$11),BJ12+W13,BJ12).

    The next step would be to update the performance graph source data to include the new columns.

    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
  •