stats - raising flop

[diconoclastx]

Can someone point to me how to write a query for:

1) Bet turn pct after raising flop.
2) Fold to turn bet pct after calling flop raise.

Thanks

[kraada]

Bet turn Pct after raising flop:

You're going to create two column here, as the count of how many times you raised the flop already exists as a default column (cnt_f_raise), but it doesn't guarantee that you get to a turn, so we need a number of times you get to the turn and have a chance to bet it.

Configure --> Configure Statistics to bring up the stats configuration menu, click on Holdem Cash Player Statistics to get to the right, section, change to the columns tab, click new then create:

cnt_t_bet_after_f_raise:

sum(if[holdem_hand_player_statistics.cnt_f_raise > 0 and holdem_hand_player_statistics.flg_t_bet, 1, 0])

(This is a sum of each time you raised the flop and bet the turn.)

cnt_t_open_opp_after_f_raise:

sum(if[holdem_hand_player_statistics.cnt_f_raise > 0 and holdem_hand_player_statistics.flg_t_saw and (substring(lookup_actions_t.action from 1 for 1) = 'X' or substring(lookup_actions_t.action from 1 for 1) = 'B' , 1, 0])

(This is a sum of each time you raised the flop, saw the turn, and your first turn action was either check or bet -- if you raised/called/folded it means you faced a bet/raise from someone. Note that this stat will require Beta 24 to function properly as the lookup_actions_x fields aren't available in Build 3.)

Then go to the stats tab and create a new stat:

Bet turn Pct After Raising Flop, with value expression:

(cnt_t_bet_after_f_raise / cnt_t_open_opp_after_f_raise) * 100

Go to the format tab, add a name, width of 50 or so should be fine, expression of /%.2f should do the trick, add any categories you want and you should be all set to go.

Your second stat is going to be created in a similar fashion, so I'll just outline what you need here, so that you can have the experience of putting it together for yourself.

You already know: how to pick out your first action on the turn (with substring, in this case you want = 'F' for fold). holdem_hand_player_detail.amt_f_raise_facing is greater than 0 when you face a flop raise, cnt_f_call is > 0 when you call on the flop (if you want to make sure you call exactly the raise and not any bet first in a multiway spot figuring that out exactly may get a bit hairy, but it should be pretty rare, and you may want that included in the fold to turn bet pct after calling flop raise anyway). And that should be everything you need to put this one together.

Good luck.