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

Postby darkhorse » Sat Jun 29, 2013 4:58 am

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

Postby kraada » Sat Jun 29, 2013 7:48 am

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.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Rake in BB/100

Postby darkhorse » Sun Jun 30, 2013 7:06 pm

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

Postby WhiteRider » Mon Jul 01, 2013 3:45 am

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

Postby potamito » Wed Jun 17, 2015 11:07 pm

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

Postby WhiteRider » Thu Jun 18, 2015 3:00 am

"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

Postby clanty » Sun Apr 22, 2018 5:11 pm

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

Postby Flag_Hippo » Mon Apr 23, 2018 6:39 am

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

Postby clanty » Mon Apr 23, 2018 5:31 pm

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!
clanty
 
Posts: 138
Joined: Fri Sep 18, 2015 8:24 pm

Re: Rake in BB/100

Postby Flag_Hippo » Mon Apr 23, 2018 6:09 pm

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

Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 2 guests

cron