cnt_f_check_raise_opp

[husngforfood]

sum(if[tourney_hand_player_statistics.flg_f_check AND (tourney_hand_player_statistics.cnt_f_raise > 0 OR tourney_hand_player_statistics.cnt_f_call > 0 OR tourney_hand_player_statistics.flg_f_fold), 1, 0])

There's a mistake in this column, isn't there? Let's say I check and face an all-in.

Found this when I was trying to make a column: count flop aggressive action opportunity. Any ideas on how to make it?

[kraada]

Would you be content to just use opportunities to check/raise facing a single bet or do you need times you're facing a bet that's already been raised one (or more) times? The latter is the reason this is a tricky column to build.

[husngforfood]

I want to filter out hands where I have an opportunity to make at least one aggressive action on the flop. This can be a bet or 2bet or 8bet.

But It'd also like to know how to make it only count bet or 2bet or 3bet opportunities.

[WhiteRider]

I think we should be able to do that with a combination of tests.

If you have an opportunity to open the flop, you can make an aggressive action:
tourney_hand_player_statistics.flg_f_open_opp

You can check for the size of bet or 2bet faced using these database fields:
tourney_hand_player_statistics.amt_f_bet_facing
tourney_hand_player_statistics.amt_f_2bet_facing

..and you could compare those to the amount of chips you start the flop with to see if you could raise, using:
tourney_hand_player_statistics.amt_bet_p - tourney_hand_player_statistics.amt_before

[husngforfood]

Thanks for the suggestions. Got it working.