New stat for sng bubble...

[Narcis13]

Hello,

Can i find a way to determine the average stack a player aproach the bubble for all tournaments i loaded?
Thank you!

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

[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

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

[Narcis13]

OK, i am waiting for your help through this...

Thank you!

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