Stat Raise F Float Bet and same stat in 3bet pot

[Steinpilz0104]

What do you suggest to get the following stats:
1. Raise flop Float in non 3bet-Pot
2. Raise Flop Float in 3bet Pot
?

[kraada]

Exists by default and is called Raise F Float Bet. The other you built the columns for earlier in this thread.

[Steinpilz0104]

Hi
Thanks

Si if I want to get the total of non 3bets and 3bets, I have to add both, correct?

[kraada]

That's correct.

[Steinpilz0104]

Hi Kraada

It's working, thanks.

A question in the same direction:

Is the stat "Call Raise After F CBet" also only for non 3bet pots?

[kraada]

No, that's for any pot. A CBet doesn't care how many raises there were preflop.

[Steinpilz0104]

Hi

Below you see the construct I made with cbet-call, cbet-Rerraise and cbet-fold. The sum of all should be 22, I only get 21. The stats are the original PT4 stats.
Why is there a lack of it?

http://www.casimages.com/img.php?i=1407 ... 789326.png

Thanks for your answer and regards

[kraada]

cbet-call and cbet-3bet aren't default stats, can you tell me exactly how you defined them?

[Steinpilz0104]

Hi Kraada

The call Raise:

(cnt_f_cbet_call_to_raise / cnt_f_cbet_face_raise) * 100
cnt_f_cbet_call_to_raise:
sum(if[cash_hand_player_statistics.flg_f_cbet AND lookup_actions_f.action = 'BC', 1, 0])
cnt_f_cbet_face__raise:
sum(if[cash_hand_player_statistics.flg_f_cbet AND cash_hand_player_statistics.flg_f_face_raise, 1, 0])

The reraise raise:

(cnt_f_cbet_raise_to_raise / cnt_f_cbet_face_raise) * 100

cnt_f_cbet_raise_to_raise:
sum(if[cash_hand_player_statistics.flg_f_cbet AND lookup_actions_f.action = 'BR', 1, 0])
cnt_f_cbet_face_raise:
sum(if[cash_hand_player_statistics.flg_f_cbet AND cash_hand_player_statistics.flg_f_face_raise, 1, 0])

Fold to Raise After F CBet is the standard Stat:

(cnt_f_cbet_fold_to_raise / cnt_f_cbet_face_raise) * 100
cnt_f_cbet_fold_to_raise:
sum(if[cash_hand_player_statistics.flg_f_cbet AND lookup_actions_f.action = 'BF', 1, 0])
cnt_f_cbet_face_raise:
sum(if[cash_hand_player_statistics.flg_f_cbet AND cash_hand_player_statistics.flg_f_face_raise, 1, 0])

[WhiteRider]

The issue is probably that you're testing for exact actions - bet/fold, bet/call or bet/raise. However, if there is any other action after your call or raise then those hands won't be counted as actions. You actually need to test for:

lookup_actions_f.action LIKE 'BR%'
lookup_actions_f.action LIKE 'BC%'

The % can be any zero or more characters, so will include hands where you raise and face a reraise for example.
The fold version is OK because there can't be any other actions after a player folds.