Min Bet and Fold

[philip77]

Hi,

Will it be possible to build a stat that compute the percentage of time a player bet the minimum (1BB) on the Flop and then fold later in the hand ( could be folding to a Flop Raise, or to a bet or raise on the Turn or River). It won't compute the time, the player wins the hand or loses the hand at showdown.

If it's possible I would be also interested in the same stat but for a min Bet on the Turn.

Thanks

[kraada]

Yes it would, you would check that cash_hand_player_statistics.amt_f_bet_made = cash_limit.amt_bb (that is the amount the player bet on the flop was the same as the size of the big blind) and then that the player later folded (cash_hand_player_statistics.enum_folded <> 'N').

Unfortunately I'm reaching the end of my day and don't have a chance to build this stat for you right now but give it a try - if you have trouble, I'll be happy to help you further.

[philip77]

Hi,

The truth is that I cannot get it right.
When you have time, I will appreciate if you can help me building it (at least for the Flop, and then I probably can adapt it for the Turn).

Thanks.

[kraada]

The stat you want is attached and it will be uploaded to the Warehouse shortly.

[philip77]

Thank you.

But it is not exactly what I was looking for. I wanted the fold percent percentage at any moment in the hand. ie to a Flop 2Bet (as you created it), but also to a Turn or a River Bet/2Bet. To summarize it's the percentage of a villain making a min Bet on the Flop and then losing the hand without a showdown.

[roundar]

What about:

sum( if[ cash_hand_player_statistics.amt_f_bet_made = cash_limit.amt_bb AND (lookup_actions_f.action LIKE '%F' OR lookup_actions_t.action LIKE '%F' OR lookup_actions_r.action LIKE '%F'], 1, 0)

[WhiteRider]

That should work.

[philip77]

that looks fine.
and what should I put as a denominator (opportunities)? It's the number of times the guy make his min-bet on the flop and face a 2Bet on Flop or a Bet/2Bet on the Turn or the River.

[kraada]

To make it validate you need to change the structure slightly (changes in bold):

sum( if[ cash_hand_player_statistics.amt_f_bet_made = cash_limit.amt_bb AND (lookup_actions_f.action LIKE '%F' OR lookup_actions_t.action LIKE '%F' OR lookup_actions_r.action LIKE '%F'), 1, 0])

For the denominator you'd want to use:

sum( if[ cash_hand_player_statistics.amt_f_bet_made = cash_limit.amt_bb AND (cash_hand_player_statistics.amt_f_raise_facing > 0 or cash_hand_player_statistics.amt_t_bet_facing > 0 or cash_hand_player_statistics.amt_t_raise_facing > 0 or cash_hand_player_statistics.amt_r_bet_facing > 0 or cash_hand_player_statistics.amt_r_raise_facing > 0), 1, 0])

As long as you face any bet on raise on the turn or river or face a raise on the flop then you have a chance to fold.

[philip77]

Sorry, but when I try to create the columns I got a message "Not a valid SQL statement" for both.