C-bet in 3-bet-pot and Fold to Raise

[abs2000]

Hi, guys.

Could you tell me, please, whether this formula is true or not:

Sum([
holdem_hand_player_statistic.flq_p_3bet AND
holdem_hand_player_ststistic.flq_p_cbet AND
lookup_actions_f.action LIKE "BF", 1, 0
])

[WhiteRider]

That's pretty close, but there are a few subtle errors.
Where you have "flq_" you need "flg_" - flg is short for 'flag'.
You want to check for a cbet on the flop (not preflop) so you need to use flg_f_cbet.
You're also missing the "s" off the end of the database table name "holdem_hand_player_statistics".
Actions strings need to be in single quotes instead of double quotes. 'BF'.
You're missing the word "if".

When writing expressions you may find it easier to use the "insert" link, which allows you to find the appropriate parts of the expression and make sure they are entered correctly.

This is the expression you want:

sum( if[ holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.flg_f_cbet AND lookup_actions_f.action LIKE 'BF', 1 , 0 ])

Check out the Tutorial: Custom Reports and Statistics for more information.

[abs2000]

thanks a lot, buddy ))

[abs2000]

By the way, I want to ask - If I need to know that his actions were exactly C-bet and fold, then maybe I should use = instead of LIKE in the expression? Does it have any matter in that case?

[abs2000]

Or maybe this variation would be better (because I need only 3-betpot situation) -

sum(if[ holdem_hand_player_statistics.flg_p_3bet AND NOT holdem_hand_player_statistics.flg_p_face_raise AND holdem_hand_player_statistics.flg_f_cbet AND lookup_actions_f.action = 'BF', 1 , 0 ] )

What do you think?

[abs2000]

There should be a 4-bet instead of a raise in that expression. My mistake

[WhiteRider]

You could use = instead of LIKE because you're checking for exact text. That would probably be fractionally more efficient, but I doubt it will make a significant difference. I would use = in that case.

When a player makes a CBet they must have been the last to raise preflop, so your original expression will only count hands where they were 4-bet if they also 5-bet. You could include a check for not facing (or making) a 4+bet if you want to rule those out.