Open shove with various stack sizes

[Leem]

Hi guys,

Trying to make an open shove stat with various stack sizes. eg. Player open shoves 0-10BBs with this %.

I would like to make a generic stat position wise, so that I can just change the positions in the 'item properties'.

Have this for just open shove...

cnt_p_open_shove
sum(if[tourney_hand_player_statistics.amt_p_raise_made >= tourney_hand_player_statistics.amt_p_effective_stack and tourney_hand_player_statistics.flg_p_first_raise and tourney_hand_player_statistics.flg_p_open_opp, 1, 0])

cnt_p_open_opp
sum(if[tourney_hand_player_statistics.flg_p_open_opp, 1, 0])

Both seem to work absolutely fine. Now what I want to do is add stack sizes please guys, to give me 'player open shoves 0-10BB' %' Or 'Player open shoves > 20 BBs %'

Thanks very much in advance as always

[kraada]

You need to add an extra clause. This would be "the open shove was less than 10 big blinds":

(tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb) < 10

You can change the inequality as you need.

[Leem]

Ok cheers Kraada, will give it a go.

Thanks again

[Leem]

cnt_p_open_shove_12bbs

sum(if[(tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb) < 12 AND tourney_hand_player_statistics.amt_p_raise_made >= tourney_hand_player_statistics.amt_p_effective_stack and tourney_hand_player_statistics.flg_p_first_raise and tourney_hand_player_statistics.flg_p_open_opp, 1, 0])

cnt_p_open_opp_12bb

sum(if[(tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb) < 12 AND tourney_hand_player_statistics.flg_p_open_opp, 1, 0])


How does this look to you Kraada? Make sense?

Cheers again, Lee

[kraada]

Looks good.

[Leem]

Hi Kraada,

Just checking some of the stats I created and for open shoving BBs between 1 and 5 it shows me as 0/2 for this session in one of my games. This doesn't make sense because I was never down to 5 or less BBs all game (pretty much 10+). Any ideas?

Thanks in advance.

EDIT: Here is the stat I mentioned

cnt_p_open_shove_1_5BBs

sum(if[(tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb) between 1 and 5 AND tourney_hand_player_statistics.amt_p_raise_made >= tourney_hand_player_statistics.amt_p_effective_stack and tourney_hand_player_statistics.flg_p_first_raise and tourney_hand_player_statistics.flg_p_open_opp, 1, 0])

cnt_p_open_opp_1_5BBs

sum(if[(tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb) between 1 and 5 AND tourney_hand_player_statistics.flg_p_open_opp, 1, 0])

[kraada]

It's based on effective stack -- if you're in the SB and everyone folds to you it doesn't matter if your stack is 1500BB if the person in the big blind only has 4BBs, then your effective stack is 4BBs. I'm guessing it was something like that that did it; the stat looks fine.

[Leem]

I think what I am getting is, I just noticed when I shove with a stack it is 100% and when I don't is 0% = just yes or no. Just folded a hand with a 10bb stack from BTN, never opened, still shows 100%. Something to do with the sum???

Any ideas?

[Leem]

Would also note that I have an open shove for > 36 BBs and that doesn't show anything, not even 0. Surely everyone would have at least a 0 because they chose not to shove > 36 BBs when given the opportunity. Definitely not right.

Cheers in advance.

[kraada]

In the oportunity column you're using actual raise made for your sizing; instead you want to test effective stack size as follows:

sum(if[(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) between 1 and 5 AND tourney_hand_player_statistics.flg_p_open_opp, 1, 0])