Open shove from EPandMP 6-12bb

[rhalala]

Hello iam trying to create this stat, unfortunately isnt working.. always 0

(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_before - tourney_hand_player_statistics.amt_ante) AND substring(tourney_hand_summary.str_aggressors_p from 2 for 1)::int BETWEEN 4 AND 6, 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])

Thank you very much!

[kraada]

You want tourney_hand_player_statistics.amt_p_raise_made >= tourney_hand_player_statistics.amt_p_effective_stack - that way if someone is short behind you and you bet their stack it counts also.

You also don't need to make it EP specific - just use the Early Position Position Item Property in the HUD editor - then you can make one stat and use it for all 6 position options!

[rhalala]

ok! i will try thank you,!

yes i need it because i want both EP and MP in the same stat!

thank you!

[rhalala]

no, still 0 ..

here what i change,, cant see what is bad here,,
Oportunitis oop , seems working

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_before - tourney_hand_player_statistics.amt_ante) AND substring(tourney_hand_summary.str_aggressors_p from 2 for 1)::int BETWEEN 4 AND 6, 1, 0])

thank you

[kraada]

As I said above, replace: tourney_hand_player_statistics.amt_p_raise_made = (tourney_hand_player_statistics.amt_before - tourney_hand_player_statistics.amt_ante)

with:
tourney_hand_player_statistics.amt_p_raise_made >= tourney_hand_player_statistics.amt_p_effective_stack

[rhalala]

sorry, make wrong copypast, yes i change it

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 4 AND 6, 1, 0])

But the stat still 0

Thank you!

Edit , i think i made a better version, still 0

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])

[kraada]

I see no reason why that wouldn't work. Are you sure you have data from those situations? It is fairly specific.

[rhalala]

I see no reason why that wouldn't work. Are you sure you have data from those situations? It is fairly specific.

i got 300k+ hands on myself , and a lot of players with 5 6k hands, and everybody 0 but i can see the opportunities 0/240 0/114 etc
thank you for your help

[kraada]

Perhaps it's a parentheses issue? Try: (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 6 and 12

[rhalala]

Perhaps it's a parentheses issue? Try: (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 6 and 12

still 0 , sorry.. i will try delete position, thx!


Still 0 , is not a position problem