performance graph per tipster

[will2k]

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

[admin]

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.