atatta
10-26-2009, 01:11 PM
Attempt at rake paid by winning and splitting pots, has a couple of (related) problems that aren't really possible to resolve with the database as it is now: side pots and uncalled bets. Neither has special handling. So for example a little rake is credited for a player who loses a pot but bet more than his opponent's stack and had the remainder returned, and when two deeper stacks play a side pot with a shorter stack in the main pot with the rake being capped, rake is assumed to have been paid proportional to total winnings rather than based on the rake on each pot.
Please add some more columns, the expression for gross winnings on a hand is pretty disgusting, I could do this better in PT2. Relations for main and side pots and players eligible for them (and the share they got if they won/split) would be very welcome. Uncalled bets can also be handled with this.
<Stat ColumnName="RakePaid" ValueExpressions="SUM(pkh.rakeamount * (ph.netamountwon + phmisc.postamountpreflop + phmisc.betamountpreflop + phmisc.callamountpreflop + COALESCE(flop.betamount + flop.callamount, 0) + COALESCE(turn.betamount + turn.callamount, 0) + COALESCE(river.betamount + river.callamount, 0)) * 1. / pkh.potsize) * 0.01 AS RakePaid" Evaluate="RakePaid" ColumnHeader="Rake PAID!!" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="Rake PAID, not to be confused with Rake Paid" />
Winnings before rake, expected winnings before rake, winrate before rake etc. are simple with this, but it took me far too long to discover that I needed to sum bets and calls from all streets to do this and I'm tired.
Please add some more columns, the expression for gross winnings on a hand is pretty disgusting, I could do this better in PT2. Relations for main and side pots and players eligible for them (and the share they got if they won/split) would be very welcome. Uncalled bets can also be handled with this.
<Stat ColumnName="RakePaid" ValueExpressions="SUM(pkh.rakeamount * (ph.netamountwon + phmisc.postamountpreflop + phmisc.betamountpreflop + phmisc.callamountpreflop + COALESCE(flop.betamount + flop.callamount, 0) + COALESCE(turn.betamount + turn.callamount, 0) + COALESCE(river.betamount + river.callamount, 0)) * 1. / pkh.potsize) * 0.01 AS RakePaid" Evaluate="RakePaid" ColumnHeader="Rake PAID!!" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="Rake PAID, not to be confused with Rake Paid" />
Winnings before rake, expected winnings before rake, winrate before rake etc. are simple with this, but it took me far too long to discover that I needed to sum bets and calls from all streets to do this and I'm tired.