Open shove from EPandMP 6-12bb

[kraada]

If you remove the stack size requirement do you still see 0?

[rhalala]

If you remove the stack size requirement do you still see 0?

i dont understand, i have now 100 evrywhere,,


(cnt_p_open_shove_epmp613 / cnt_p_open_shove_opp_ep613) * 100


cnt_p_open_shove_epmp613

sum(if[tourney_hand_player_statistics.flg_p_first_raise and tourney_hand_player_statistics.flg_p_open_opp and lookup_actions_p.action = 'R' and tourney_hand_player_statistics.amt_p_raise_made >= tourney_hand_player_statistics.amt_p_effective_stack AND substring(tourney_hand_summary.str_aggressors_p from 2 for 1)::int BETWEEN 2 AND 3 and (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 6 and 12, 1, 0])

cnt_p_open_shove_opp_ep613

sum(if[tourney_hand_player_statistics.flg_p_open_opp AND tourney_hand_player_statistics.flg_p_open_opp AND tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb > 4 AND substring(tourney_hand_summary.str_aggressors_p from 2 for 1)::int BETWEEN 2 and 3 AND tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb BETWEEN 6 and 12, 1, 0])

[kraada]

tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb > 4 is only true if you actually made a raise - so you're getting all raises in your opportunity column, which you don't want. You should remove this particular piece.

[rhalala]

tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb > 4 is only true if you actually made a raise - so you're getting all raises in your opportunity column, which you don't want. You should remove this particular piece.

working! thank you very much!

[rhalala]

tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb > 4 is only true if you actually made a raise - so you're getting all raises in your opportunity column, which you don't want. You should remove this particular piece.

working! thank you very much!

but thats the % of PFR witch are Openshove,
Would like % openshove of all hands,
i will try it!

edit : done ! thank you for your help!