P&l calculations

[Wobbler]

looking to work out my average win/loss amount's and was wondering how people do it as i dont think Betfair lets you just view wins or loss's seperately ? Do people sit there with their Betfair P&l sheet adding them all up? Because i can think of a 100 things i'd rather be doing

[spreadbetting]

Just download whatever period you want to check as a CSV file from the betting history screen and a couple of excel formulas will give you the figures. Sum if less than 0 divided by countif less than zero etc

Even a few sheets already around to breakdown by course/distance if that's your bag.

[Wobbler]

Cheers spreadbetting

[spreadbetting]

There's a ready made sheet here viewtopic.php?f=31&t=133 that someone put up, might be useful or what you're looking for.

Otherwise just simply use these two formulas assuming the pnl data is in column C

=SUMIF(C:C,">0")/COUNTIF(C:C,">0")
=SUMIF(C:C,"<0")/COUNTIF(C:C,"<0")

[Wobbler]

After a scout around last night i found that topic. Im not very familiar with excel so will have a good look at it this week. Thanks again