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.

Results 1 to 2 of 2
  1. #1
    New Member
    Join Date
    May 2016
    Posts
    3

    performance graph per tipster

    Hi all , Has anyone figured out a way to show the betting performance graph per tipster , at the moment it shows the global performance across all tipsters .
    but i wanted to just view it for the individual tipsters .
    thanks matt

  2. #2
    Moderator
    Join Date
    Aug 2011
    Posts
    896
    Hi Matt, my advice would be to create new columns to the right of the data entry area in the Bets worksheet. Each new column would correspond to the running profit of the tipster you want to plot the performance of.

    For, say, row 100 in the basic version, for a tipster entered into column AB, the formula would be something along the lines of =if(K100>0,if(F100=AB$10,AB99+W100,AB99),"")
    K100 = the bet's stake
    F100 = the bet's tipster
    AB$10 = the name of the tipster in that column
    AB99 = the tipster's profit up until now
    W100 = the profit/loss from the bet

    You could then create a new graph using the date column (BH) and the new tipster profit columns.

 

 

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
  •