Ongame 8x Bonus & Rake stats for Holdem Manager - Internet Bonuses

Two Plus Two Forums Archived Forums Internet Poker Internet Bonuses

Ongame 8x Bonus & Rake stats for Holdem Manager

...

Page 1 of 2

1 2

Page 1 of 2

1 2

09-06-2008 , 04:17 PM

PNXRMX

adept

Join Date: Jun 2007 Posts: 1,033

I've been working on creating custom stats for Holdem Manager as part of a rake project I'm working on. I thought you guys might be interested in these stats in particular:

This stat displays the number of Player Points you have earned (or would have earned with Ongame's Points structure)

Code:

<Stat GroupName="Default" ColumnName="Ongame PPs" ValueExpressions="
Sum((case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 10 and 19 then 0.1 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 20 and 29 then 0.2 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 30 and 39 then 0.3 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 40 and 49 then 0.4 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 50 and 59 then 0.5 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 60 and 69 then 0.6 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 70 and 79 then 0.7 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 80 and 89 then 0.8 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 90 and 99 then 0.9 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 100 and 109 then 1.0 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 110 and 119 then 1.1 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 120 and 129 then 1.2 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 130 and 139 then 1.3 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 140 and 149 then 1.4 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 150 and 159 then 1.5 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 160 and 169 then 1.6 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 170 and 179 then 1.7 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 180 and 189 then 1.8 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 190 and 199 then 1.9 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 200 and 209 then 2.0 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 210 and 219 then 2.1 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 220 and 229 then 2.2 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 230 and 239 then 2.3 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 240 and 249 then 2.4 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 250 and 259 then 2.5 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 260 and 269 then 2.6 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 270 and 279 then 2.7 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 280 and 289 then 2.8 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 290 and 299 then 2.9 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount >=300 then 3 else 0 end))/1.0
as OngamePPs" Evaluate="OngamePPs" ColumnHeader="Ongame\nPlayer Points" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Ongame Player Points earned" />

This stat is basically PPs earned divided by 8, which shows how much bonus you would have earned if you had an 8x bonus running the whole time.

Code:

<Stat GroupName="Default" ColumnName="Ongame 8x" ValueExpressions="
Sum((case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 10 and 19 then 0.1 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 20 and 29 then 0.2 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 30 and 39 then 0.3 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 40 and 49 then 0.4 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 50 and 59 then 0.5 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 60 and 69 then 0.6 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 70 and 79 then 0.7 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 80 and 89 then 0.8 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 90 and 99 then 0.9 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 100 and 109 then 1.0 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 110 and 119 then 1.1 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 120 and 129 then 1.2 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 130 and 139 then 1.3 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 140 and 149 then 1.4 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 150 and 159 then 1.5 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 160 and 169 then 1.6 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 170 and 179 then 1.7 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 180 and 189 then 1.8 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 190 and 199 then 1.9 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 200 and 209 then 2.0 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 210 and 219 then 2.1 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 220 and 229 then 2.2 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 230 and 239 then 2.3 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 240 and 249 then 2.4 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 250 and 259 then 2.5 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 260 and 269 then 2.6 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 270 and 279 then 2.7 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 280 and 289 then 2.8 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 290 and 299 then 2.9 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount >=300 then 3 else 0 end))/8.0 as Ongame8x" Evaluate="Ongame8x" ColumnHeader="Ongame\n8x Bonus" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="Ongame 8x Bonus earned" />

This last one divides bonus earned by your dealt rake and expresses it as a percentage. You could directly compare this stat to Full Tilt, Crypto or Cake RB.

Code:

<Stat GroupName="Default" ColumnName="Ongame 8x DRB%" ValueExpressions="
Sum((case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 10 and 19 then 0.1 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 20 and 29 then 0.2 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 30 and 39 then 0.3 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 40 and 49 then 0.4 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 50 and 59 then 0.5 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 60 and 69 then 0.6 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 70 and 79 then 0.7 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 80 and 89 then 0.8 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 90 and 99 then 0.9 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 100 and 109 then 1.0 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 110 and 119 then 1.1 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 120 and 129 then 1.2 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 130 and 139 then 1.3 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 140 and 149 then 1.4 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 150 and 159 then 1.5 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 160 and 169 then 1.6 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 170 and 179 then 1.7 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 180 and 189 then 1.8 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 190 and 199 then 1.9 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 200 and 209 then 2.0 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 210 and 219 then 2.1 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 220 and 229 then 2.2 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 230 and 239 then 2.3 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 240 and 249 then 2.4 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 250 and 259 then 2.5 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 260 and 269 then 2.6 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 270 and 279 then 2.7 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 280 and 289 then 2.8 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount between 290 and 299 then 2.9 else 0 end)+
(case when PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop+PHMISC.PostAmountPreflop > 0 and PKH.RakeAmount >=300 then 3 else 0 end))*100.0/(Sum(PH.RakeAmount)*8.0) as Ongame8xPDB" Evaluate="Ongame8xPDB" ColumnHeader="Ongame 8x\nin DRB%" ColumnFormat="0.0%" ColumnWidth="*" Tooltip="Ongame 8x Bonus as % of Dealt Rakeback" />

You can add these stats to Holdem Manager by pasting them into your CustomStats.txt file, which is located in C:\Program Files\RVG Software\Holdem Manager\Reports. Restart HM, add the stats to your report and you're good to go!

Also, let me know if I made any mistakes.

I will also accept requests for custom stats related to bonuses, rake or rakeback here.

Limitations:
I can't express bonuses as contributed or weighted contributed rakeback equivalent.
I can't make stats for bonuses that base points accumulated on weighted contributed rake (such as boss, b2b, everleaf, etc.).
I can't distinguish between NL, PL and FL games. For example, there need to be 2 PartyPoints stats, one that is accurate when the sample only contains NL/PL hands, and one that is accurate when the sample only contains FL hands.

I might be able to create a weighted contributed rake stat with a bit of help from Roy. This would mean it would be possible to compare a 27% dealt rakeback deal to a 40% weighted contributed rakeback deal within HM for example.

09-06-2008 , 08:01 PM

themandude

veteran

Join Date: Mar 2006 Posts: 2,252

Looks like great work. I don't have holdem manager so it's of no use to me, but I wish I did.

09-07-2008 , 10:04 AM

spigge

centurion

Join Date: Feb 2005 Posts: 184

hmm I get division by zero error in that drb% stat

09-07-2008 , 11:17 AM

PNXRMX

adept

Join Date: Jun 2007 Posts: 1,033

Quote:

Originally Posted by spigge

hmm I get division by zero error in that drb% stat

Thanks. Does one of your samples contain 0 hands that saw a flop / were raked? I'm not quite sure how to work around this atm.

09-07-2008 , 11:39 AM

spigge

centurion

Join Date: Feb 2005 Posts: 184

Yes it does. I'll try to get different report if that's causing this problem.

Edit. It was those HU hands that caused errors. Filtered 3 players or more and it works.

09-10-2008 , 05:03 AM

gieffe

journeyman

Join Date: Aug 2007 Posts: 236

so i just have to open the CustomStats.txt file, paste the above text and... how do i see the stats on HM? sorry but i never work with custom stats

09-10-2008 , 08:16 AM

Finnisher

veteran

Join Date: Oct 2006 Posts: 2,187

Thanks this is nice. The "8x in DRB" sums the %s at the bottom, eg two limits with 38% and 37% drb the overall line at the bottom says 75%.

To compare contributed rb and points system, you can go to filter->more filters->put $ in pot.

gieffe, on reports tab there's a stat selection window on the left. Click the green +-button, new window pops up, custom stats are on the right bottom corner. Choose them and save

09-10-2008 , 12:47 PM

PNXRMX

adept

Join Date: Jun 2007 Posts: 1,033

Quote:

Originally Posted by Finnisher

Thanks this is nice. The "8x in DRB" sums the %s at the bottom, eg two limits with 38% and 37% drb the overall line at the bottom says 75%.

No way to fix this that I know of. Not really a big problem anyway

To compare contributed rb and points system, you can go to filter->more filters->put $ in pot.
This probably won't work. If you filter for P$IP, you will indeed only show hands where you contributed, but it will still divide the total rake by all players in the hand, not just the players that contributed. Doing this would underestimate the amount of rake paid, and therefore overestimate the rb %. There is no way to divide rake by # of contributors atm, according to the HEM team. I will post CRB % and WCRB % stats when they are available

^ Reply in bold

09-10-2008 , 01:10 PM

Finnisher

veteran

Join Date: Oct 2006 Posts: 2,187

Ya I realised that too. But HM faq says they're trying to implement correct mgr stats for every site, hopefully soon

09-10-2008 , 02:13 PM

#10

PNXRMX

adept

Join Date: Jun 2007 Posts: 1,033

Yep, it will require new columns in the actual database, because there is no column for # of players who contributed. There is a stat for amount contributed, but it contains uncalled bets, so no weighted contributed stat is possible yet either. When there is a contributed and a weighted contributed stat, that means we can analyze all bonuses and rakeback deals (for sites with HHs compatible with HM, via conversion or regular import) and compare them.

I've started off with this topic:
http://forumserver.twoplustwo.com/49...og-pty-296344/
If you have a lot of hands at ongame or any other site, please contribute as much data as you can

. The aim is to eventually index net rake effect in bb/100 for each site at each stake, so you can compare various bonuses and rakeback deals and see directly how much the site will be raking from you. For example, a site with 50% WCRB and an aggressive rake structure might actually be worse than a 40% WCRB deal with a better rake structure. Using stats per site/network will help with this

09-11-2008 , 08:54 AM

#11

RatAttack

centurion

Join Date: Aug 2007 Posts: 183

I don't have a CustomStats.txt file? Do I just paste them into notepad and save as CustomStats.txt? Does it matter how many lines I leave between the stats codes?

I'd be interested in one of these for Everest if possible, their bonuses always seem quite good value but I'd like to know how it compares to RB%.

09-11-2008 , 02:18 PM

#12

PNXRMX

adept

Join Date: Jun 2007 Posts: 1,033

Quote:

Originally Posted by RatAttack

Yep, just create a new blank CustomStats.txt file and add these in. You can add as many lines between stats as you want. Even text in between stats doesn't interfere with the program at all (it only reads xml-formatted data).

Here are some Everest stats for you. Note that Summit Points are earned in the same way as Full Tilt Points and Cake Network FPPs, so I have just combined the stats for those.

Code:

Summit Points earned:
<Stat GroupName="Default" ColumnName="FTPs/Cake FPPs/Summit Points" ValueExpressions="Sum(PKH.RakeAmount)/100.0 as FullTiltPoints" Evaluate="FullTiltPoints" ColumnHeader="Full Tilt\nPoints" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Full Tilt Points earned" />

Summit Points per 100 hands:
<Stat GroupName="Default" ColumnName="FTPs/Cake FPPs/EVP SPs / 100" ValueExpressions="(Sum(PKH.RakeAmount)/100.0)/Sum(0.01) as FullTiltPoints100" Evaluate="FullTiltPoints100" ColumnHeader="FTPs\n/100" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Full Tilt Points earned per 100 hands" />

Everrest 14.28x Bonus:
<Stat GroupName="Default" ColumnName="Everest 14.28x Bonus" ValueExpressions="Sum(PKH.RakeAmount)/1428.6 as EVPBonus" Evaluate="EVPBonus" ColumnHeader="Everest\n14.28x Bonus" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="Everest 14.28x Bonus earned" />

Everest 10x Bonus:
<Stat GroupName="Default" ColumnName="Everest 10x Bonus" ValueExpressions="Sum(PKH.RakeAmount)/1000.0 as EVPBonus10" Evaluate="EVPBonus10" ColumnHeader="Everest\n10x Bonus" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="Everest 10x Bonus earned" />

Everest 20x Bonus:
<Stat GroupName="Default" ColumnName="Everest 20x Bonus" ValueExpressions="Sum(PKH.RakeAmount)/2000.0 as EVPBonus20" Evaluate="EVPBonus20" ColumnHeader="Everest\n20x Bonus" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="Everest 20x Bonus earned" />

To add a new bonus stat, just change all the '20's in the last stat to whatever you want (for example 15) and change '2000.0' to 1500.0 in that case.
In the case of FTP, Cake and Everest, you can actually work out the rakeback % very easily without these stats, if you know the number of players. 1 Point is awarded to each player per $1 raked from the table, so at a 6-player table, 6 points are awarded. So for a 10x bonus, you'd be getting 60% dealt rakeback. This ignores double points from sitting down first, etc. Holdem Manager can't track that.

Please contribute your Everest rake per 100 hands and Summit Points per 100 hands stats in this topic: http://forumserver.twoplustwo.com/49...og-pty-296344/

Thanks

09-11-2008 , 02:31 PM

#13

RatAttack

centurion

Join Date: Aug 2007 Posts: 183

Thanks again. I'll contribute to that thread once I have a decent sample size. Everest does seem to have the lowest rake for limit that I've seen so far.

09-12-2008 , 12:45 PM

#14

gieffe

journeyman

Join Date: Aug 2007 Posts: 236

the first stat is pretty accurate. it's off by only 12 points out of 4100

second stat it's not only points/8; i don't get what it means

third one is cool

thanks a lot, it's a great addition to hm

09-12-2008 , 01:13 PM

#15

RatAttack

centurion

Join Date: Aug 2007 Posts: 183

Quote:

Originally Posted by gieffe

the first stat is pretty accurate. it's off by only 12 points out of 4100

second stat it's not only points/8; i don't get what it means

third one is cool

thanks a lot, it's a great addition to hm

You get $1 for every 8 points, this stat is bonus $ earned.

09-16-2008 , 04:25 AM

#16

ship indus

newbie

Join Date: Sep 2008 Posts: 20

Wow this is really nice; do you think you can also make something for 'average contributed'?

Average Contributed:
Similar to the dealt cards method as above in terms of the calculation, but you must contribute at least something to the pot. If you fold without contributing to the pot then your rake consideration is zero. If for example the pot on a particular table was $60 the rake taken is $3. Even if you contributed only $2 to the pot and there are six of you playing (but two folded pre-flop) then you get allocated a quarter of the rake as 4 people in total contributed to the pot.
Examples: Eurobet, Hollywood, UltimateBet, Betfair

09-16-2008 , 04:57 AM

#17

PNXRMX

adept

Join Date: Jun 2007 Posts: 1,033

That not possible yet, since there's isn't a way to count the number of contributors.

09-16-2008 , 05:44 AM

#18

ship indus

newbie

Join Date: Sep 2008 Posts: 20

Well it should be possible - HM should know how many people contributed. A stupid way would be like: query the hand#, find all players for this hand# and look if the have contributed. I'm not so familiar yet with the HM SQL format but I guess it should be possible in PT.

You can PM me if you want to build it together.

09-16-2008 , 05:56 AM

#19

ship indus

newbie

Join Date: Sep 2008 Posts: 20

eg something like

Code:

select 
sum (case when playerhandscashkeycolumns.netamountwon != 0 then 1 else 0 end) as total
from playerhandscashkeycolumns
where playerhandscashkeycolumns.pokerhand_id = 106;

09-16-2008 , 02:15 PM

#20

PNXRMX

adept

Join Date: Jun 2007 Posts: 1,033

According to Roy (creator of HM) it isn't possible without a new column for the number of contributors. I'll have another good look into the database structure to see if there isn't maybe a way he hasn't seen.

09-17-2008 , 04:25 AM

#21

ship indus

newbie

Join Date: Sep 2008 Posts: 20

Yes, that could very well be possible. I have now a PHP script which uses SQL queries to find the right amount (although it's not the same as my rakeback reports say

), but I don't think I can write this into a SQL query (and hence it's not possible to put it in a php custom report).

01-29-2009 , 08:40 AM

#22

Magnifico

stranger

Join Date: Jan 2009 Posts: 4

Great job OP! Having the $0.10 increments working is awesome. As for the 3rd stat, cashback % is calculated by dividing the Ongame Points by HM's rake which is actually a contributed one, FTP-like. This stat should be more accurate as it is the way Ongame calculates it (both blinds or VPIP not as a blind):

[PHP]<Stat GroupName="Default" ColumnName="OngameRake" ValueExpressions="
Sum((case when ph.PositionType_ID=0 then PKH.RakeAmount else 0 end)+
(case when ph.PositionType_ID=1 then PKH.RakeAmount else 0 end)+
(case when ph.PositionType_ID not in (0,1) and PHMISC.BetAmountPreflop+PHMISC.CallAmountPreflop > 0 then PKH.RakeAmount else 0 end))
as OngameRake" Evaluate="OngameRake/100" ColumnHeader="OngameRake" ColumnFormat="$0.00" ColumnWidth="*" Tooltip="OngameRake" />[/PHP]

Next step would be having the number of players contributing for every hand put into the equation but we'll have to wait for an update to get that one. For 5max tables, maybe 2.5 players is a good guesstimate.

01-29-2009 , 03:42 PM

#23

PNXRMX

adept

Join Date: Jun 2007 Posts: 1,033

Yeah, for (weighted) contributed we need to wait for input from roy

01-29-2009 , 10:38 PM

#24

BlackRiver69

newbie

Join Date: Apr 2008 Posts: 26

For the Number of Players contributed, ain't it possible to filter a hand for BB, SB and any player with VPIP that hand?

Ups, just saw someone mentioned it before...

02-02-2009 , 05:11 PM

#25

duchas

centurion

Join Date: Jan 2007 Posts: 111

Not working for me. Im using win 64 bits Vista

Page 1 of 2

First

1 2

Last

...

Page 1 of 2

First

1 2

Last