## Rake in BB/100

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

### Rake in BB/100

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.
darkhorse

Posts: 192
Joined: Sat May 31, 2008 8:54 pm

### Re: Rake in BB/100

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.
Moderator

Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

### Re: Rake in BB/100

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.
darkhorse

Posts: 192
Joined: Sat May 31, 2008 8:54 pm

### Re: Rake in BB/100

It will automatically be in big bets for fixed limit - PT4 handles that automatically.
WhiteRider
Moderator

Posts: 53972
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

### Re: Rake in BB/100

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"
potamito

Posts: 802
Joined: Wed Apr 21, 2010 4:20 pm

### Re: Rake in BB/100

"BB of stake" is big blinds for NL/PL and big bets for FL - this is done automatically.
WhiteRider
Moderator

Posts: 53972
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

### Re: Rake in BB/100

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.
clanty

Posts: 138
Joined: Fri Sep 18, 2015 8:24 pm

### Re: Rake in BB/100

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)`
Flag_Hippo
Moderator

Posts: 14482
Joined: Tue Jan 31, 2012 7:50 am

### Re: Rake in BB/100

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

What have I done wrong?

Thank you!
clanty

Posts: 138
Joined: Fri Sep 18, 2015 8:24 pm

### Re: Rake in BB/100

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
Flag_Hippo
Moderator

Posts: 14482
Joined: Tue Jan 31, 2012 7:50 am

Next