PDA

View Full Version : HEM Custom Report



define
02-15-2009, 09:11 AM
Hi
Has anyone made a custom report for calculating points on iPoker yet?

-DefiNe

PCP Poker
02-15-2009, 03:58 PM
You would need a custom stat, not custom report.

How does Ipoker calculate their points? I could whip one up for you if you give me their formula.

PCP Poker
02-15-2009, 04:06 PM
Ok i got it working for ipoker, that is it:


Quote:
Stat GroupName="Default" ColumnName="Ipoker PPs" ValueExpressions="
Sum((case when PKH.RakeAmount between 301 and 500 then 20 else 0 end) +
(case when PKH.RakeAmount between 276 and 300 then 15 else 0 end) +
(case when PKH.RakeAmount between 251 and 275 then 13.25 else 0 end) +
(case when PKH.RakeAmount between 226 and 250 then 12 else 0 end) +
(case when PKH.RakeAmount between 201 and 225 then 10.75 else 0 end) +
(case when PKH.RakeAmount between 176 and 200 then 9.5 else 0 end) +
(case when PKH.RakeAmount between 151 and 175 then 8.25 else 0 end) +
(case when PKH.RakeAmount between 126 and 150 then 7 else 0 end) +
(case when PKH.RakeAmount between 101 and 125 then 5.75 else 0 end) +
(case when PKH.RakeAmount between 76 and 100 then 5 else 0 end) +
(case when PKH.RakeAmount between 51 and 75 then 4 else 0 end) +
(case when PKH.RakeAmount between 25 and 50 then 3 else 0 end) +
(case when PKH.RakeAmount between 10 and 24 then 1 else 0 end) +
(case when PKH.RakeAmount between 1 and 9 then 0.4 else 0 end))/1.0
as IpokerPPs" Evaluate="IpokerPPs" ColumnHeader="Ipoker\nPlayer Points" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Ipoker Player Points earned" /

You can change it dependend on your Ipoker skin and VIP Level. the above setup is for pokerplex and maximum VIP. What cant be done is that you earn 50% more points when you start a new table.
Found this in another thread, add it to your customstats.txt file and edit it to your liking. It should work like gold.

define
02-15-2009, 04:50 PM
You would need a custom stat, not custom report.

How does Ipoker calculate their points? I could whip one up for you if you give me their formula.

ah yea my bad, ty

FatBoy
02-15-2009, 11:15 PM
Can anybody tell my why my custom stat doesn't match up with the actual points I receive? My stat is:

Stat GroupName="Default" ColumnName="Ipoker PPs" ValueExpressions="Sum((case when PKH.RakeAmount between 301 and 500 then 13 else 0 end) +(case when PKH.RakeAmount between 201 and 300 then 11 else 0 end) +(case when PKH.RakeAmount between 151 and 200 then 9 else 0 end) +(case when PKH.RakeAmount between 101 and 150 then 6 else 0 end) +(case when PKH.RakeAmount between 51 and 100 then 3 else 0 end) +(case when PKH.RakeAmount between 25 and 50 then 2 else 0 end))/1.0 as IpokerPPs" Evaluate="IpokerPPs" ColumnHeader="Ipoker\nPlayer Points" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Ipoker Player Points earned" /

and the VIP system is:


Rake taken FPPs
0.25c to 0.50c 2
0.51c to $1 3
$1.01 to $1.5 6
$1.51 to $2 9
$2.01 to $3 11
$3.01 to$5 13

i always make more points than the stat says and I can't figure out why... heeeeeeeeelp

PCP Poker
02-16-2009, 08:34 PM
Does iPoker calculate their points using contributed rake, total rake or by dealt rake? Many sites use contributed rake, which is the amount of rake divided by the # of players that VPIP'ed. Dealt rake is the total rake for the hand divided by the number of players who were dealt cards. And I believe total rake is the total rake for the hand on any hand you win. At the moment, HEM only calculates Dealt Rake, so this is most likely the cause of the discrepancy. Other rake calculation methods are in the works from what I can tell by reading posts from the mods, but I haven't seen an E.T.A. for them.

FatBoy
02-16-2009, 09:23 PM
How does whether it is total rake or dealt rake make a difference? FPPs are calculated hand by hand and, according to how much was raked only in that hand and given out only if you were dealt cards. Doesn't "PKH.RakeAmount" mean that? I didn't make this custom stat, just tweaked the one you posted

btw the answer to your question is dealt rake, if that makes a difference

PCP Poker
02-17-2009, 01:56 AM
The way the rake is calculated greatly influences this. If they go by contributed rake, and you fold preflop without vpip, you get no credit for the hand. If they go by dealt rake, you get credit for the hand assuming there was some rake. As of right now, HEM only calculates dealt rake, so assuming iPoker doesn't use dealt rake, that is why the numbers are different.

FatBoy
02-17-2009, 01:20 PM
Did you read my last post? FPPs are not given out according to dealt or contributed rake. If the rake in one hand in which you receive card is $1.54 for example, you get 9 FPPs immediately.
Doesn't the custom stat you posted add up all the rake taken in the hands you played and calculate FPPs?
What is "PKH.RakeAmount"? total rake for a single hand or dealt or contributed or whatever?

PCP Poker
02-17-2009, 09:57 PM
I don't know what to tell you man. HEM calculates it by dealt rake, and if your site does as well, it should be accurate. Try looking at some specific hand histories and comparing what you think your rake should be with what HEM should be. Your stat looks accurate to me. The only thing that can be wrong is the rake amounts.

PCP Poker
02-17-2009, 10:09 PM
Oh, so if there's $1.54 rake taken from the hand, and you were dealt cards, you get credit for the whole $1.54? That's really weird. That is not dealt rake, contributed rake, or total rake. Wish they calculated rakeback like that.

Maybe try:

Stat GroupName="Default" ColumnName="Ipoker PPs" ValueExpressions="Sum((case when (PKH.RakeAmount * PKH.numberofplayers) between 301 and 500 then 13 else 0 end) +(case when (PKH.RakeAmount * PKH.numberofplayers) between 201 and 300 then 11 else 0 end) +(case when (PKH.RakeAmount * PKH.numberofplayers) between 151 and 200 then 9 else 0 end) +(case when (PKH.RakeAmount * PKH.numberofplayers) between 101 and 150 then 6 else 0 end) +(case when (PKH.RakeAmount * PKH.numberofplayers) between 51 and 100 then 3 else 0 end) +(case when (PKH.RakeAmount * PKH.numberofplayers) between 25 and 50 then 2 else 0 end))/1.0 as IpokerPPs" Evaluate="IpokerPPs" ColumnHeader="Ipoker\nPlayer Points" ColumnFormat="0.00" ColumnWidth="*" Tooltip="Ipoker Player Points earned" /

FatBoy
02-17-2009, 10:27 PM
Isn't what I'm talking about "Total Rake"? Anyway thanks for the new stat but it still doesn't work right (it's about 20% higher than what it should be)
Having an FPPs stat in HEM is probably useless and not worth the time. By the way I was genuinely asking what PKH.rakeamount was, sorry if it looked abrasive...

P.S. nice ninja edit :)

PCP Poker
02-17-2009, 10:39 PM
Nah, this is where it gets really confusing. Total Rake is where only the player that wins the hand gets credit for the rake. Really wish there was an industry standard. Online Poker is going to cannabilize itself to the point where we only have 2 or 3 successful sites....oh wait, it's already there.

PS, I think PKH.numberofplayers isn't 100% accurate. I think it sometimes counts players that are sitting out and those who haven't posted yet, which could definitely skew your numbers a lot, especially if you are playing 6 max