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

[Steinpilz0104]

Hi

I get wrong results when I modified the stat "Raise F Float Bet" to "Raise F Float Bet in 3Bet Pots".

Columns for the stat "Raise F Float Bet" (original from PT4):

cnt_f_float_def_opp_action_raise
sum(if[ not(cash_hand_player_statistics.flg_p_face_raise) AND lookup_actions_p.action LIKE '%R' and cash_hand_player_statistics.flg_f_open_opp AND cash_hand_player_statistics.amt_f_bet_facing > 0 AND substring(lookup_actions_f.action from 1 for 2) = 'XR', 1, 0])

the corresponding in 3bets:
sum(if[(cash_hand_player_statistics.flg_p_3bet OR cash_hand_player_statistics.flg_p_4bet) AND lookup_actions_p.action LIKE '%R' AND cash_hand_player_statistics.flg_f_open_opp AND cash_hand_player_statistics.amt_f_bet_facing > 0 AND substring(lookup_actions_f.action from 1 for 2) = 'XR', 1, 0])

cnt_f_float_def_opp:
sum(if[ not(cash_hand_player_statistics.flg_p_face_raise) AND lookup_actions_p.action LIKE '%R' AND cash_hand_player_statistics.flg_f_open_opp AND cash_hand_player_statistics.flg_f_check AND cash_hand_player_statistics.amt_f_bet_facing > 0, 1, 0])

cnt_f_float_def_opp_3bet_pot:
sum(if[(cash_hand_player_statistics.flg_p_3bet OR cash_hand_player_statistics.flg_p_4bet) AND lookup_actions_p.action LIKE '%R' AND cash_hand_player_statistics.flg_f_open_opp AND cash_hand_player_statistics.flg_f_check AND cash_hand_player_statistics.amt_f_bet_facing > 0, 1, 0])

What is wrong?

Thanks for your answer and regards

[kraada]

Nothing obvious jumps out at me. What kind of results are you seeing?

[Steinpilz0104]

Hi

I get sometimes negative results when I calculate the raise f float bet in non-3bet pots.

I use the formula:
((cnt_f_float_def_opp_action_raise-cnt_f_float_def_opp_action_raise_3bet_pot)/(cnt_f_float_def_opp-cnt_f_float_def_opp_3bet_pot)) * 100

Which is a combination of the two above.

In this example, the sum in normal pots gives 100, which is correct, in the raise I've a negative value because the raise has too much (2 which gives 14% instead of 1):

<a href="http://www.casimages.com/img.php?i=140729025127443464.png" title="upload image">Cliquez ici pour voir mon image</a>

[kraada]

The default is for 2bet pots so you don't want to do extra math to get that using the 3bet pot version -- to get the total you'd add those together.

[Steinpilz0104]

The default is for 2bet pots so you don't want to do extra math to get that using the 3bet pot version -- to get the total you'd add those together.

So the right formula is:
((cnt_f_float_def_opp_action_raise+cnt_f_float_def_opp_action_raise_3bet_pot)/(cnt_f_float_def_opp+cnt_f_float_def_opp_3bet_pot)) * 100

correct?

[kraada]

That would get you both 2bet and 3bet+ pots yes.

[Steinpilz0104]

If I want only the 2 bet pots, I have to take this formula:

((cnt_f_float_def_opp_action_raise)/(cnt_f_float_def_opp)) * 100

correct?

(I hope youre not bored with my many questions )

[kraada]

You got it.

[Steinpilz0104]

I still don't understand...

The standard stat "Raise F Float Bet" has this formula: (cnt_f_float_def_opp_action_raise / cnt_f_float_def_opp) * 100
It doesn't say anything about 3bet pot or not (preflop), it catches all raises, in normal pots and it 3bet pots.

I defined the new stat "Raise F Float Bet in 3Bet+ Pot" with this formula: (cnt_f_float_def_opp_action_raise_3bet_pot / cnt_f_float_def_opp_3bet_pot) * 100

Where "cnt_f_float_def_opp_action_raise_3bet_pot"
sum(if[(cash_hand_player_statistics.flg_p_3bet OR cash_hand_player_statistics.flg_p_4bet) AND lookup_actions_p.action LIKE '%R' AND cash_hand_player_statistics.flg_f_open_opp AND cash_hand_player_statistics.amt_f_bet_facing > 0 AND substring(lookup_actions_f.action from 1 for 2) = 'XR', 1, 0])
and
"cnt_f_float_def_opp_3bet_pot" is
sum(if[(cash_hand_player_statistics.flg_p_3bet OR cash_hand_player_statistics.flg_p_4bet) AND lookup_actions_p.action LIKE '%R' AND cash_hand_player_statistics.flg_f_open_opp AND cash_hand_player_statistics.flg_f_check AND cash_hand_player_statistics.amt_f_bet_facing > 0, 1, 0])

If I want to get only the raises in non 3bet pots, I have to substract the second of the first in a sort of way...

Thanks for your answer.

[kraada]

This is due to legacy naming issues. We agree it isn't ideal. Originally Floating was considered to be just calling the prior street in order to take it away the street after -- which implies a 2bet pot.