"Probebet Turn / Bet River"

[js2002]

The following stat is named "Probebet Turn / Bet River".
The italic parts are from the "Probe Bet Turn" Stat.
I added flg_r_bet and flg_t_open_opp.
But took some time and mad thoughts:
"What's when Player Probebets Turn gets raised and calls and then openbets the River?!"
That would count, too, but should not.
So I need to catch the cases.
How do I check for "the first and last action at turn was a bet so only a "B" no "BC" oder "BR" or sth."?

lookup_actions_t.action LIKE "%B" would this correctly catch it?


cnt_turn_probebet_r_bet
sum(if[holdem_hand_player_statistics.flg_r_bet AND
holdem_hand_player_statistics.flg_t_bet AND
lookup_actions_f.action LIKE 'X' AND
lookup_actions_p.action NOT LIKE '%R' AND
holdem_hand_player_statistics.flg_p_face_raise AND
NOT(holdem_hand_player_detail.flg_t_has_position) AND
(holdem_hand_player_detail.val_p_raise_aggressor_pos < holdem_hand_player_statistics.position OR (holdem_hand_summary.cnt_players = 2 AND holdem_hand_player_statistics.flg_blind_b))
, 1, 0])

cnt_turn_probebet_r_open_opp
sum(if[holdem_hand_player_detail.flg_t_open_opp AND
holdem_hand_player_statistics.flg_t_bet AND
lookup_actions_f.action LIKE 'X' AND
lookup_actions_p.action NOT LIKE '%R' AND
holdem_hand_player_statistics.flg_p_face_raise AND
NOT(holdem_hand_player_detail.flg_t_has_position) AND
(holdem_hand_player_detail.val_p_raise_aggressor_pos < holdem_hand_player_statistics.position OR (holdem_hand_summary.cnt_players = 2 AND holdem_hand_player_statistics.flg_blind_b))
, 1, 0])

[WhiteRider]

I assume you mean "flg_r_open_opp"?

To check for the only turn action being a bet you don't need to use LIKE, just use equals:

lookup_actions_t.action = 'B'

(You could do lookup_actions_t.action LIKE 'B', but I think that = will be very slightly more efficient, and they are equivalent in this case.)

[js2002]

I used
lookup_actions_t.action LIKE "%B"

and it seems to work, I ll see if the result change when I switch to the performance exp.

ohoh 1580 column :-)
I only had rush performance trouble when I use the kraada live ranges with >600 columns.
After taking it out, it rushed again

[js2002]

Works perfect.

Even the W$SD stats correposnding to the stat are done.

[js2002]

logic attach:

hmmm wounder bout sth:

For the "W$SD when probebet T bet R stat", so a bet be the final action? what do u logically think?
how would pt3 define stats like "w$SD when bet flop"? would there be a bet the final action or would also count bet/call etc...

[WhiteRider]

W$SD when bet flop would be how often you won money when you bet the flop - it doesn't mention any other actions. It's a measure of how often the player wins after they bet the flopso how likely they are to have a good hand - following actions don't affect a player's decision to bet the flop so wouldn't counted.
You could tighten the criteria, of course, but then it would become a different stat.

For your probe bet variation, I guess that you want a measure of what that probe bet means - are they betting with the best hand or to "steal" when seeing weakness?