Page 1 of 4

Rake in BB/100

PostPosted: Sat Jun 29, 2013 4:58 am
by darkhorse
Is there a way to create a custom stat for reports where I can see how much rake I paid expressed in BB/100 hands? It would be a great way to compare what I've paid in rake on similar stakes across sites, or comparing how much I pay in short handed games vs full ring.

As most know, the formula to calculate rake paid in BB/100 is:

(rake paid/BB of stake) / (hands played/100)

I do this manually in my spreadsheet by copying numbers from PT4, and realized there must be a way to do this internally.

Re: Rake in BB/100

PostPosted: Sat Jun 29, 2013 7:48 am
by kraada
You'll need to create a custom statistic for this but it's a fairly simple one. Find the amt_rake_attributed column in Configure -> Statistics in the $ -> Columns area. Duplicate it and divide the value inside the sum() by cash_limit.amt_bb to convert it to big blinds. Then use the new column in a new stat and that will work (see Rake Attributed to see how to use this) If you want the currency converted versions though, look at amt_rake_attributed_curr_conv.

Re: Rake in BB/100

PostPosted: Sun Jun 30, 2013 7:06 pm
by darkhorse
Thank you! But since I play FL, how can I convert it to big bets? Just multiply it by two?

I downloaded a custom report that includes a stat called amt_mgr_bb, but I'd rather see what I actually paid per 100 big bets, not what I generated. I'm assuming that's the difference between attributed and MGR.

Re: Rake in BB/100

PostPosted: Mon Jul 01, 2013 3:45 am
by WhiteRider
It will automatically be in big bets for fixed limit - PT4 handles that automatically.

Re: Rake in BB/100

PostPosted: Wed Jun 17, 2015 11:07 pm
by potamito
darkhorse wrote:Is there a way to create a custom stat for reports where I can see how much rake I paid expressed in BB/100 hands? It would be a great way to compare what I've paid in rake on similar stakes across sites, or comparing how much I pay in short handed games vs full ring.

As most know, the formula to calculate rake paid in BB/100 is:

(rake paid/BB of stake) / (hands played/100)

I do this manually in my spreadsheet by copying numbers from PT4, and realized there must be a way to do this internally.

Is that formula correct? And is it on big blinds or in big bets? Cuz i see the capital "BB"

Re: Rake in BB/100

PostPosted: Thu Jun 18, 2015 3:00 am
by WhiteRider
"BB of stake" is big blinds for NL/PL and big bets for FL - this is done automatically.

Re: Rake in BB/100

PostPosted: Sun Apr 22, 2018 5:11 pm
by clanty
kraada wrote:You'll need to create a custom statistic for this but it's a fairly simple one. Find the amt_rake_attributed column in Configure -> Statistics in the $ -> Columns area. Duplicate it and divide the value inside the sum() by cash_limit.amt_bb to convert it to big blinds. Then use the new column in a new stat and that will work (see Rake Attributed to see how to use this) If you want the currency converted versions though, look at amt_rake_attributed_curr_conv.


Hi,

I am trying to make the Raked bb/100 stat as you described, but am unable to configure it with your guide.

I've tried dividing the value inside sum() by "cash_limit.amt_bb" and it came back with an invalid expression.

Any feedback is appreciated.

Thank you.

Re: Rake in BB/100

PostPosted: Mon Apr 23, 2018 6:39 am
by Flag_Hippo
Code: Select all
sum(cash_hand_summary.amt_rake * ( (cash_hand_player_statistics.amt_won +  cash_hand_player_statistics.amt_bet_ttl)  / (cash_hand_summary.amt_pot - cash_hand_summary.amt_rake)) / cash_limit.amt_bb)

Re: Rake in BB/100

PostPosted: Mon Apr 23, 2018 5:31 pm
by clanty
I made that into a new column and created a stat, however it doesn't return the correct number for raked bb/100. Please see below screenshots.

https://i.gyazo.com/cd750a693b2e7561129 ... a6c683.png
https://i.gyazo.com/a301236266e4b2541cc ... 90ada1.png

What have I done wrong?

Thank you!

Re: Rake in BB/100

PostPosted: Mon Apr 23, 2018 6:09 pm
by Flag_Hippo
Code: Select all
sum(cash_hand_summary.amt_rake * ( (cash_hand_player_statistics.amt_won +  cash_hand_player_statistics.amt_bet_ttl)  / (cash_hand_summary.amt_pot - cash_hand_summary.amt_rake)) / cash_limit.amt_bb)

This calculates the attributed rake in BB for each hand and it is not equal to BB/100 rate so I'd recommend renaming your column to avoid confusion. You then need to use your column to calculate the rake in BB/100 with the following value expression:

your_new_column_name * 100 / cnt_hands