amt_rake_bb

[poompah]

The amt_rake_bb stat appears to be wildly incorrect.

For example, when I run a custom report showing total rake $ (amt_rake) and total rake in BB (amt_rake_BB) the numbers bear no resemblance to each other.
Formatting is:
Rake: format_money(amt_rake, false)
Rake in BB: format_number(amt_rake_bb,2,true,true)

From playing 25NL and 50NL tables I have figures:

25NL Total Rake $786.10 / Rake in BB 10,439.70 (36,802 hands); should be 786.10/0.50
50NL Total Rake $966.30 / Rake in BB 6,843.75 (24.623 hands); should be 966.30/1.00

This seems a pretty straightforward calculation.

FWIW I play on Stars.

[poompah]

The amt_rake_bb stat I am using is calculated as follows:

sum(holdem_hand_summary.amt_rake / (holdem_limit.amt_bb *holdem_limit.val_nlpl_mult))

Presumably the problem is here - I thought the amt_rake_bb was a standard stat - but it was imported along with a report from the repository.

[kraada]

That indeed does look pretty off.

What report did you import in order to get that stat?

[poompah]

Not one of yours!

It was "Detailed Results per Limit inkl Pokersars VPP" by Michael_M112

[kraada]

Flattery will get you everywhere

I'll take import that report later and try and figure out what's causing the statistic to be so broken.

[poompah]

The report is def. off but I have resolved the problem by replacing the existing custom stat for amt_rake_bb (above), with the standard (non-custom) PT3 script for calculating the amount of rake. As follows, for the "Amount Rake in BB" column:

sum(( if[holdem_hand_player_statistics.flg_won_hand, holdem_hand_summary.amt_rake, 0]) / (holdem_limit.amt_bb *holdem_limit.val_nlpl_mult))

Where the script in blue is just the standard amt_rake (i.e. not custom) stat for PT3, and replaces the holdem_hand_summary.amt_rake in the custom report.

The numbers generated are now exactly correct across limits. I should point out that the VPP numbers are spot on for this report; VPP exactly agreeing with my account in Stars. I also love the VPP/100 column as this clearly shows how much value I am getting (effective RakeBack) over the different limits. So, it's still a really useful report, just moreso now it is corrected.

I will PM Michael_M112 and point out what I have found. The original report in the repository def. needs correcting.

[kraada]

Thanks for all your hard work!

If you don't hear back from him please let me know and I'll look into getting the broken report removed. Also if you'll post a corrected version in the repository, and let me know once you have, I'll look into getting that one approved more quickly.

[guru]

I submitted the report "Detailed Results per Limit incl. Poker Stars VPP v2" some days ago, which is essiantially Michael_M112's version with the rake in bb/100 fixed (same fix as above) and the additional stats mgr and mgr in bb/100.

[WhiteRider]

Thanks - I'll see if I can get this accepted for you..

[guru]

Oh, it's already in the repository.