Fold to Raise Flop/Turn in 3Bet Pots

[parraka]

Hello, excuse is my english is not so good. I have to thank you the great job that you make. Reading tutorials and the forum i have been able to make Raise Over Limpers by position, W$SD when Raise Flop/Turn/River, WTSD when Raise Flop/Turn/River and W$SD when bet Turn/River.

I have tryed to make a Fold to Raise Flop/Turn in 3bet Post.
[[[Player 2 Raise PF, Player 1 3B, Player 2 Call 3B ||| Player 2 Check, Player 1 Cbet flop, Player 2 Raise, Player 1 Fold OR Player 1 Cbet flop, Player 2 Raise, Player 1 Fold]]]

The problem is that i cant make it. I dont have time to spent, i have to study, to work and to play Poker.
I have spent so much time in this stat. I cant make for my own and i think that i would not be able to make it with little help. I think that it not must be so hard, but i cannot, i have tried a lot of things and nothing, i am gonna crazy.

I would be very thanked if you can make this stat, please, I need it, i can improve my game with this.

[kraada]

Create the following two custom columns and you can use them to make fold to flop raise in 3-bet pots:

cnt_f_raise_cbet_3b_pot: sum(if[holdem_hand_player_statistics.flg_p_first_raise and holdem_hand_player_statistics.flg_p_3bet_def_opp and not(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp) and holdem_hand_player_statistics.flg_f_cbet_def_opp and lookup_actions_f.action LIKE 'XR%' OR lookup_actions_f.action LIKE 'R%', 1, 0])

cnt_f_face_cbet_3b_pot: sum(if[holdem_hand_player_statistics.flg_p_first_raise and holdem_hand_player_statistics.flg_p_3bet_def_opp and not(holdem_hand_player_statistics.flg_p_4bet OR holdem_hand_player_statistics.flg_p_4bet_def_opp) and holdem_hand_player_statistics.flg_f_cbet_def_opp, 1, 0])

You'll need to define the turn case a little more though - what do you want to have happen on the flop?

[parraka]

In the case of turn i had thought: Player 1 cbet flop, Player 2 calls, Player cbet turn, Player 2 raise, Flayer 1 fold or Player 1 checks, Player 2 check, Player 1 bet turn, Player 2 raise, Player 1 fold. It will be more difficult, i think.

I dont know what i have to do with the columns that you make, ¿cnt_f_raise_cbet_3b_pot/
cnt_f_face_cbet_3b_pot? x 100? Sorry for ask again, but really i have not any time and i dont want to make a stat that doesnt work correctly.

[kraada]

Yes, that's the idea for what to do with the columns :)

So you want the turn one to include hands where the flop isn't bet by anyone I see. Do you only want specifically for the cbettor to be out of position on the turn? As that's all you stated.

[parraka]

Do you only want specifically for the cbettor to be out of position on the turn?

No, no, i want for the cbettor to be in position too, sorry.

Its the first time that i crushed the Database, i made a wrong stat and the hud didnt work.
At the end i have found where was the problem, i have deleted and now its all ok, thats because i didnt want to make many changes, i thought that was time to reinstall PT xd.

[kraada]

These stats won't break the HUD regardless of whether they do exactly what you want.

Actually looking over the first ones I built for you, the columns I put together will give you the percentage that someone raises a flop cbet in a 3-bet pot.

For fold to flop raise after c-betting in a 3-bet pot you actually want:

cnt_f_cbet_and_fold_in_3b_pot: sum(if[holdem_hand_player_statistics.flg_p_3bet and not(holdem_hand_player_statistics.flg_p_4bet) and holdem_hand_player_statistics.flg_f_cbet and lookup_actions_f.action = 'BF', 1, 0])

cnt_f_cbet_face_raise_in_3b_pot: sum(if[holdem_hand_player_statistics.flg_p_3bet and not(holdem_hand_player_statistics.flg_p_4bet) and holdem_hand_player_statistics.flg_f_cbet and lookup_actions_f.action LIKE 'B_%', 1, 0])

Those are just for the flop. For the turn:

cnt_t_cbet_or_delayed_3b_pot_fold: sum(if[holdem_hand_player_statistics.flg_p_3bet and not(holdem_hand_player_statistics.flg_p_4bet) and ((holdem_hand_player_statistics.flg_t_cbet OR (lookup_actions_f.action = 'X' and holdem_hand_player_statistics.flg_t_bet)) and lookup_actions_t.action = 'BF', 1, 0])

cnt_t_cbet_or_delayed_3b_pot_face_raise: sum(if[holdem_hand_player_statistics.flg_p_3bet and not(holdem_hand_player_statistics.flg_p_4bet) and ((holdem_hand_player_statistics.flg_t_cbet OR (lookup_actions_f.action = 'X' and holdem_hand_player_statistics.flg_t_bet)) and lookup_actions_t.action LIKE 'B_%', 1, 0])

[parraka]

I was guilty of Database's crush, i make wrong things, but now it is okey.
Emmm, then these last stats are the good for Fold to Raise, ¿no? I can remove previous.
I had Raise Cbet Flop in 3bet Pot and Raise Cbet Turn in 3bet Pot from this page, and works good.

[kraada]

Yes these last ones should work well.

[parraka]

No, the Fold to Raise turn in 3B doesnt work, try it: The Statement is not valid SQL.
The Fold tu Raise flop works, i dont know if works well but is a statement valid.

[kraada]

The statements are good, I just missed a ) :oops:

For both of those columns add a ) right before the "," of ", 1 0])'