% of how many times player calls open jam OOP

[minotaurs]

So i tryed to make it like this - took column how many times player calls open raise and and how many times he folds to that but adjust that open raise size to basically ALL IN size, so this is it ...

1. i made column call_open_jam_17_25

sum(if[tourney_hand_player_statistics.flg_p_face_raise AND tourney_hand_player_statistics.flg_p_3bet_opp AND ((NOT(tourney_hand_player_statistics.flg_p_limp) AND lookup_actions_p.action LIKE 'C%') OR lookup_actions_p.action LIKE 'CC%') AND
(tourney_hand_player_statistics.amt_p_raise_made > 0.8 * (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb))AND **** added this part
(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 17 AND 25 ****added this part 2
, 1, 0])

2. i made column fold_to_open_jam_17_25

sum(if[tourney_hand_player_statistics.flg_p_face_raise AND tourney_hand_player_statistics.flg_p_3bet_opp AND ((NOT(tourney_hand_player_statistics.flg_p_limp) AND lookup_actions_p.action LIKE 'F') OR lookup_actions_p.action LIKE 'CF') AND
(tourney_hand_player_statistics.amt_p_raise_made > 0.8 * (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb))AND
(tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 17 AND 25
, 1, 0])

again added only part myself what shows size of his raise

3. i made stat

((call_open_jam_17_25)/((call_open_jam_17_25)+(fold_to_open_jam_17_25)))*100

And the problem is that shows 0 again every times this happens. I would be very happy again if u would tell where is the problem.

[kraada]

tourney_hand_player_statistics.amt_p_raise_made > 0.8 * (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb)

This is the part that I don't think you built quite right. This says the raise you made - in chips - is 80% or more of the number of big blinds in the effective stack.

I'm guessing instead you want amt_p_2bet_facing (the first raise made and that you faced) was 80% or more of the actual effective stack in chips.

Then going on to specify the total effective stack depth would work as you have done it.

[minotaurs]

ok tnx man, i will let u know if it works with amt_p_2bet_facing, not feel like playing today :D