Open Shove by Stack Size

[Melkien]

Oh, how do I actually refer to big blinds?

Kra, I actually see 0/0 like you mention.

[kraada]

My last post explains how to make that change

[Melkien]

Great that fixed it, thanks ^^.

[Melkien]

Hey guys! I keep having trouble with this situation. Can anyone tell me what is wrong?

Stat -

Code: Select all

 Raise First In 0-8bb: (cnt_p_raise_first_in_0_8bb / cnt_p_open_opp_0_8bb ) * 100

Columns -

Code: Select all

cnt_p_raise_first_in_0_8bb: sum(if[tourney_hand_player_statistics.flg_p_first_raise AND tourney_hand_player_statistics.flg_p_open_opp AND tourney_hand_player_statistics.amt_p_effective_stack>0 AND tourney_hand_player_statistics.amt_p_effective_stack<8, 1, 0])

cnt_p_open_opp_0_8bb: sum(if[tourney_hand_player_statistics.flg_p_open_opp AND (tourney_hand_player_statistics.amt_p_effective_stack/tourney_blinds.amt_bb)>0 AND (tourney_hand_player_statistics.amt_p_effective_stack/tourney_blinds.amt_bb)<8, 1, 0])

In the stats it shows 0 and - mostly, never detecting if the guy raises first in at that stack depth, and I have already tested it vs people who do so it should actually throw a result.

Any help appreciated .

[kraada]

In your numerator you're not dividing by the size of the big blind (as you are correctly in your denominator) - so you're only getting times when they do it with between 0 and 8 chips. Which is probably why you're getting a lot of 0s

[Melkien]

Haha very true, didnt realize. Thanks for pointing that out. How could I fix that to work? Not very sure. Thanks again!

[kraada]

Replace tourney_hand_player_statistics.amt_p_effective_stack with (tourney_hand_player_statistics.amt_p_effective_stack/tourney_blinds.amt_bb) just like you did in the denominator - that part works fine!