Page 1 of 1
New stat for sng bubble...

Posted:
Fri Dec 05, 2008 7:44 am
by Narcis13
Hello,
Can i find a way to determine the average stack a player aproach the bubble for all tournaments i loaded?
Thank you!
Re: New stat for sng bubble...

Posted:
Fri Dec 05, 2008 10:33 am
by kraada
There might be a way to do this, but you're going to have to define "approaches the bubble" a lot more before I can help you further.
Are you only talking 9 man SnGs? Is this when 4/5 handed or just 4 handed?
There are details like that which need to be worked out before the stat can be built.
Re: New stat for sng bubble...

Posted:
Mon Dec 08, 2008 7:30 am
by Narcis13
I play 6 man sngs so i need to know what is my average stack size when i am dealt first hand when we are down to 3 players...
Thank you very much for your help...
Narcis
Re: New stat for sng bubble...

Posted:
Mon Dec 08, 2008 10:49 am
by kraada
Picking out the first hand when you reach 3 players may be tough. I'll have to think about whether that's doable.
Average stack size for you while 3 handed though shouldn't be too hard and I can walk you through that if you'd like.
Re: New stat for sng bubble...

Posted:
Tue Dec 09, 2008 7:18 am
by Narcis13
OK, i am waiting for your help through this...
Thank you!
Re: New stat for sng bubble...

Posted:
Tue Dec 09, 2008 2:02 pm
by kraada
Average stack size while 3 handed:
Create two columns:
(1) cnt_hands_3handed defined as:
sum(if[tourney_holdem_hand_summary.cnt_players = 3, 1, 0])
This is the total number of 3 handed hands a player has played
(2) amt_before_3handed defined as:
sum(if[tourney_holdem_hand_summary.cnt_players = 3, tourney_holdem_hand_player_detail.amt_before, 0])
This sums up how much of a stack someone had for all hands that were 3 handed.
Then create the stat:
Average stack size when 3 handed
with value expression:
amt_before_3handed / cnt_hands_3handed
make sure to give it a title and a width on the format tab, and you'll want format expression to be /%.2f.