Sqze Success

[barabu]

Hi!

I am trying to make a stats with "sqze success" but I don't find it.



Any suggestion, please?

[kraada]

You'll need to build this column as it doesn't exist by default. See this guide for the basics on custom statistics creation and this guide for a deeper walkthrough. The latter was written for PT3 but the techniques all apply to PT4, the interface is just slightly different.

[barabu]

Thank you, Kaadra.

I have been workink on that and I have got this:





But the result is 0.00 en any postion so I have made something wrong but I don't know where it is. Any sugerence?

[kraada]

You want flg_p_3bet not flg_f_3bet -- you can't 3bet the flop if you cbet it and everyone folds

[barabu]

Yeahhh, thank you. It was that... but now I have another problem because


It was impossible to have more than 100%. In BTN is 17/16 and BB 36/35. And the rest of the cases are very weird 1/37 or something similar...

[WhiteRider]

You'll need to make a new 'opportunities' column as well - cnt_f_cbet won't be the right value if you're adding other conditions to the 'actions' column.
If you post both of your current column expressions we'll take a look for you.

[barabu]

Thanks!!!

Buaaaa, man, I'm felling as little dumb cause I don't know how to do it. I copy my expressions:



This is ok. I think...






But in this expressions I think that I must see the number of times villian call or raise in 3 bet pot while he calls preflop to my 3 bet.
First one the expression is not valid.
Second I don't see the "hands statist player" with the "call to my 3 bet".


¿I am wrong? Well, I am wrong but I am very wrong or very very worng?

[kraada]

cnt_f_call is a number not a boolean expression so you want to test that cnt_f_call > 0 -- and the same for cnt_f_raise.

However that won't tell you how much a player calls or raises after calling a 3bet -- it will tell you how many times a player calls or raises after making a 3bet himself preflop (as that's what flg_p_3bet does). If you want him to have called a preflop 3bet instead you want to use cash_hand_player_statistics.enum_p_3bet_action = 'C'.

[barabu]

Mmmm, too dificult for me.

The first part is ok, isn't? So if I want to know the "cbet success in 3bet pot" the column opportunities is ok, but the column actions is wrong.
So the column action would be "cash_hand_player_statistics.enum_p_3bet_action AND... ¿the number of times that we saw TURN or the number of times that I fold FLOP?".

[kraada]

The first column is right -- but that's successes (or actions) not opportunities. Opportunities are any time you cbet in a 3bet pot, so you just need this:
sum(if[cash_hand_player_statistics.flg_p_3bet and cash_hand_player_statistics.flg_f_cbet, 1, 0])

All times you cbet in a 3bet pot is a potential success.