PDA

View Full Version : Total win + rakeback amount on FT since method change



BornTuKill
11-19-2010, 03:38 PM
is this still correct since they changed their rakeback method?

Stat GroupName="Default" ColumnName="TotalWin+RB FT" ValueExpressions="Sum(PH.RakeAmount)/100.0*0.27 as RakeBackAmount27;Sum(PH.NetAmountWon)/100 as NetWin" Evaluate="(RakeBackAmount27+NetWin)" ColumnHeader="TotalWin+RB FT" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="TotalWin" />

Raventhon
12-17-2010, 10:28 AM
New rake method:

Total Amount Won + WCRB

Stat GroupName="Default" ColumnName="TotalWin" ValueExpressions="SUM(pkh.rakeamount * (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 + pkh.rakeamount)) * 0.0027 AS WCRB;Sum(PH.NetAmountWon)/100.0 as NetWin" Evaluate="(WCRB+NetWin)" ColumnHeader="TotalWin with WCRB" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="TotalWin" />


EV Adjusted Winnings + WCRakeback

Stat Groupname="Default" ColumnName="EV$ + Rakeback" ValueExpressions="SUM(pkh.rakeamount * (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 + pkh.rakeamount)) * 0.0027 AS WCRB;sum(case when EV.SklanskyBucks <> 0 or (EV.SklanskyBucks = 0 and EV.EquityPct = 500) then EV.SklanskyBucks else ph.NetAmountWon end) as SklanskyAdjustedWinnings;" Evaluate="(WCRB+(SklanskyAdjustedWinnings/100.0))" ColumnHeader="EV$+WCRB" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="EV$+RB" />