Football Excel Challenge
The raw betfair results is included on a second tab as I sum up the markets for each game.
You do not have the required permissions to view the files attached to this post.
For strike rate you could use formula =IF(profit>=0, "W", "L"), add data to a pivot table with the W/L as column headings and calculate from that.
If you're not confident with a pivot table you could do a count of the column with =COUNTIF(column with W/L, "W") repeat for "L" and then calculate from that.
If you're not confident with a pivot table you could do a count of the column with =COUNTIF(column with W/L, "W") repeat for "L" and then calculate from that.
Never knew myself also to be honest
Had noticed other threads with word "Challenge"
Was challenging my own system
and hence asking for a spreadsheet/advice
YES
THE CUMULATIVE GRAPH LINE IS REQD
I am rubbish at them
Can that be added to the last excel chart I uploaded? plz
Had noticed other threads with word "Challenge"
Was challenging my own system
and hence asking for a spreadsheet/advice
YES
THE CUMULATIVE GRAPH LINE IS REQD
I am rubbish at them
Can that be added to the last excel chart I uploaded? plz