Collection of Custom Stats for New FTP

[Raventhon]

Ok!


FTPs

All calculations other than Base assume that 50% of play takes place during Happy Hour. As there's no way to actually track this and Happy Hours happen all the damn time it's probably a decent estimate.


Base

FTP

<Stat GroupName="Default" ColumnName="Base FTP" 
ValueExpressions="sum(round(cast(((cast(pkh.rakeamount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTP" 
Evaluate="FTP" ColumnHeader="Base FTP" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Full Tilt Points" /> 

FTP/100

<Stat GroupName="Default" ColumnName="FTP/100" 
ValueExpressions="sum(round(cast(((cast(pkh.rakeamount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTPHand" 
Evaluate="FTPHand/1.0/TotalHands*100" ColumnHeader="FTP/100" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Full Tilt Points per 100h" /> 

Blackcard

FTP

<Stat GroupName="Default" ColumnName="BC FTP" 
ValueExpressions="sum(round(cast(((cast(pkh.rakeamount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTP" 
Evaluate="FTP*2.5" ColumnHeader="BC FTP" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Full Tilt Points" /> 

FTP/100

<Stat GroupName="Default" ColumnName="BC FTP/100" 
ValueExpressions="sum(round(cast(((cast(pkh.rakeamount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTPHand" 
Evaluate="FTPHand/1.0/TotalHands*250" ColumnHeader="BC FTP/100" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Full Tilt Points per 100h" /> 

Value (Assumes Blackcard)

Total $ From FTP

<Stat GroupName="Default" ColumnName="BC FTP $" 
ValueExpressions="sum(round(cast(((cast(pkh.rakeamount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTP" 
Evaluate="FTP*2.5*.0035" ColumnHeader="BC FTP $" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="BC FTP $ total" /> 

FTP $/100

<Stat GroupName="Default" ColumnName="$/100 From FTPs (BC)" 
ValueExpressions="sum(round(cast(((cast(pkh.rakeamount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTPHand" 
Evaluate="FTPHand/1.0/TotalHands*250*.0035" ColumnHeader="BC $/100 from FTP" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="BC FTP $/100" /> 

WC Rake

New FTP Rake system -- Weighted Contributed instead of Dealt. Nits will see their effective rakeback decrease, crazy lagtards who run 25/23 or thereabouts will see it increase a bit probably.

WC Rake

<Stat ColumnName="WCRake" 
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.01 AS WCRake" 
Evaluate="WCRake" ColumnHeader="WC Rake" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="Weighted Contributed Rake (including uncalled bets)" /> 

WC Rakeback (27%)

<Stat ColumnName="WCRB" 
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" 
Evaluate="WCRB" ColumnHeader="WC Rakeback" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="WCRB" /> 

Totals

Complete Earn (Totalwin+WCRB+BCFTP$)

<Stat GroupName="Default" ColumnName="Real Earn" 
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;sum(round(cast(((cast(pkh.rakeamount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTP;" 
Evaluate="(WCRB+NetWin)+(FTP*2.5*.0035)" ColumnHeader="RealEarn" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="CompleteFTPEarn" /> 

Complete EV Earn

<Stat Groupname="Default" ColumnName="EV Earn" 
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;sum(round(cast(((cast(pkh.rakeamount as numeric)*1)/10)/pkh.numberofplayers as numeric),2)) as FTP;" 
Evaluate="(WCRB+(SklanskyAdjustedWinnings/100.0)+(FTP*2.5*.0035))" ColumnHeader="EVEarn" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="EVEarn" /> 

[Raventhon]

If anyone can figure out how to account for WCRB in big blinds, that'd be pretty awesome & I'd be able to get EVBB/100+WCRB & BB/100+WCRB, but I can't figure out how to do it right now.

[RoslynSlim]

These calculations are great. Thanks so much!

[quakes]

Thank you, how accurate do you think your WC rakeback calculation is, as the amount I am being paid is around 1-2% lower (based on daily totals) than the stat. Am I being cheated?

[RoslynSlim]

Raventhon,

It appears that your calculation for the WC Rake is slightly off. Is this because you are including uncalled bets and Full Tilt Poker is not? Could you post the formula that would not include uncalled bets? Thanks.

RoslynSlim

[titoufred]

I think it's not possible to evaluate the real potsize (without uncalled bets) in HM. The coders did it wrong and pkh.potsize in HM refers to potsize with uncalled bets, which has no interest. So, the WC Rake formula is not good.

[RoslynSlim]

So, the WC Rake formula is not good.

Thanks for your reply. It's not that it's no good, it's just off a little bit depending on how many uncalled bets there were.

RoslynSlim