fwiw there's a typo in the definitions of the bluff and thin v-bet custom stats I posted. the numbers are calculated improperly for pots where you called a turn bet and then lost the pot because I got a '-' instead of a '+' in there.
Bluff Net $
Code:
<Stat GroupName="Default" ColumnName="RiverBluffNet$" ValueExpressions="sum(case when ph.riverplayeractiontype_id between 23 and 44 and river.madehandvalue in (0,10,11,22,29,30,31,32,49,69,84,106,107,108,126,142,162) and ph.NetAmountWOn < 0 then (ph.NetAmountWon + phmisc.betamountpreflop + phmisc.callamountpreflop + phmisc.postamountpreflop + flop.betamount + flop.callamount + turn.betamount + turn.callamount) else 0 end) as FailedBluffAmountOnRiver; sum(case when ph.riverplayeractiontype_id between 23 and 44 and river.madehandvalue in (0,10,11,22,29,30,31,32,49,69,84,106,107,108,126,142,162) and ph.NetAmountWon > 0 then pkh.riverpotsize else 0 end) as WonAmountOnRiverBluff" Evaluate="(WonAmountOnRiverBluff+FailedBluffAmountOnRiver)/100.0" ColumnHeader="River\nBluff\nEff $" ColumnFormat="$0.00" ColumnWidth="61" Tooltip="Net $ won or lost making river bluffs with ace high or worse on River." />
Bluff Efficiency
Code:
<Stat GroupName="Default" ColumnName="RiverBluffEff" ValueExpressions="sum(case when ph.riverplayeractiontype_id between 23 and 44 and river.madehandvalue in (0,10,11,22,29,30,31,32,49,69,84,106,107,108,126,142,162) and ph.NetAmountWon > 0 then pkh.riverpotsize else 0 end) as TotalWonAmountOnRiverBluff;sum(case when ph.riverplayeractiontype_id between 23 and 44 and river.madehandvalue in (0,10,11,22,29,30,31,32,49,69,84,106,107,108,126,142,162) and ph.NetAmountWon < 0 then (ph.NetAmountWon + phmisc.betamountpreflop + phmisc.callamountpreflop + phmisc.postamountpreflop + flop.betamount + flop.callamount + turn.betamount + turn.callamount) else 0 end) as FailedBluffAmountOnRiver" Evaluate="((TotalWonAmountOnRiverBluff+FailedBluffAmountOnRiver)/1.0/(TotalWonAmountOnRiverBluff-FailedBluffAmountOnRiver))" ColumnHeader="River\nBluff\nEfficiency" ColumnFormat="0.00" ColumnWidth="61" Tooltip="Shows average return per 1$ of river bluffs with ace high or worse." />
Thin V-bet Net $
Code:
<Stat GroupName="Default" ColumnName="RiverThinBetNet$" ValueExpressions="sum(case when ph.riverplayeractiontype_id between 23 and 44 and river.madehandvalue in (20,21,23,24,25,26,27,43,44,46,47) and ph.NetAmountWon < 0 then (ph.NetAmountWon + phmisc.betamountpreflop + phmisc.callamountpreflop + phmisc.postamountpreflop + flop.betamount + flop.callamount + turn.betamount + turn.callamount) else 0 end) as FailedTBetAmountOnRiver; sum(case when ph.riverplayeractiontype_id between 23 and 44 and river.madehandvalue in (20,21,23,24,25,26,27,43,44,46,47) and ph.MaxStreetSeen = 4 and ph.NetAmountWon > 0 then (ph.NetAmountWon - phmisc.betamountpreflop - phmisc.callamountpreflop - phmisc.postamountpreflop - flop.betamount - flop.callamount - turn.betamount - turn.callamount) else 0 end) as WonTAmountOnRiverBet" Evaluate="(WonTAmountOnRiverBet+FailedTBetAmountOnRiver)/100.0" ColumnHeader="River\nThin VBet\nEff $" ColumnFormat="$0.00" ColumnWidth="61" Tooltip="Net $ won or lost making thin river v-bets with one pair." />
Thin v-bet Efficiency
Code:
<Stat GroupName="Default" ColumnName="RiverThinBetEff" ValueExpressions="sum(case when ph.riverplayeractiontype_id between 23 and 44 and river.madehandvalue in (20,21,23,24,25,26,27,43,46,47) and ph.NetAmountWon < 0 then (ph.NetAmountWon + phmisc.betamountpreflop + phmisc.callamountpreflop + phmisc.postamountpreflop + flop.betamount + flop.callamount + turn.betamount + turn.callamount) else 0 end) as FailedTEBetAmountOnRiver; sum(case when ph.riverplayeractiontype_id between 23 and 44 and river.madehandvalue in (20,21,23,24,25,26,27,43,46,47) and ph.MaxStreetSeen = 4 and ph.NetAmountWon > 0 then (ph.NetAmountWon - phmisc.betamountpreflop - phmisc.callamountpreflop - phmisc.postamountpreflop - flop.betamount - flop.callamount - turn.betamount - turn.callamount) else 0 end) as WonTEAmountOnRiverBet" Evaluate="((WonTEAmountOnRiverBet+FailedTEBetAmountOnRiver)/1.0/(WonTEAmountOnRiverBet-FailedTEBetAmountOnRiver))" ColumnHeader="River\nThin VBet\nEfficiency" ColumnFormat="0.00" ColumnWidth="61" Tooltip="Shows average return per 1$ of river thin v-bets (one pair hands)" />
</spam>