PokerTracker

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

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.

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.

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

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.

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)

That should work.

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.

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.

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