stats flop seen

[lifeisagame69]

yesh for hu only

[kraada]

For the check/fold flop after calling a PFR in the BB, add two new columns:

cnt_f_face_bet_after_defending: sum(if[holdem_hand_player_statistics.flg_blind_def_opp and not(holdem_hand_player_statistics.cnt_p_raise > 0) and lookup_actions_f.action LIKE "X_%", 1, 0])

cnt_f_check_fold_after_defending: sum(if[holdem_hand_player_statistics.flg_blind_def_opp and not(holdem_hand_player_statistics.cnt_p_raise > 0) and lookup_actions_f.action = "XF", 1, 0])

Put the latter over the former and multiply by 100 to get your stat.

For check/call flop, check/fold turn use these:

cnt_t_face_bet_after_defending_and_xc_flop: sum(if[holdem_hand_player_statistics.flg_blind_def_opp and not(holdem_hand_player_statistics.cnt_p_raise > 0) and lookup_actions_f.action = "XC" and lookup_actions_t_.action LIKE "X_%", 1, 0])

cnt_t_check_fold_after_defending_and_xc_flop: sum(if[holdem_hand_player_statistics.flg_blind_def_opp and not(holdem_hand_player_statistics.cnt_p_raise > 0) and lookup_actions_f.action = "XC" and lookup_actions_t.action = "XF", 1, 0])

[lifeisagame69]

Sorry i m not expert about your software.
I don t know what mean and how ''add two new columns''
Can you help me?


I have another question,
for the continuation bet flop or turn i guess it s cbet flop or cb contibet turn and not bet flop or bet turn?
I just want to be sure, what excatly is your cbet turn?


thanks

[kraada]

A turn cbet requires a flop cbet. So a turn cbet is the same as a double barrel.

For a detailed walkthrough in how to build a custom statistic once you know the column definitions you want, please see the Tutorial: Using Custom Statistics and Reports.

[lifeisagame69]

Sorry, my english isn t my first language and i don t really understand.

For create column i must go to configure statistic, click on columns?

and?

[kraada]

Follow this walkthrough using the expressions I gave you and it will help you set everything up properly.

[lifeisagame69]

Ok it s look more clearly, but i steal have so problem.

if i understand well
In the tab colum i copy/coll in the expression box ''sum(if[holdem_hand_player_statistics.flg_blind_def_opp and not(holdem_hand_player_statistics.cnt_p_raise > 0)'' ?
because when i did that, pt3 told me '' the statement is not valid SQL''

[kraada]

You only copied half of it, the whole line is:

sum(if[holdem_hand_player_statistics.flg_blind_def_opp and not(holdem_hand_player_statistics.cnt_p_raise > 0) and lookup_actions_f.action = "XC" and lookup_actions_t_.action LIKE "X_%", 1, 0])

[lifeisagame69]

i copy this one
sum(if[holdem_hand_player_statistics.flg_blind_def_opp and not(holdem_hand_player_statistics.cnt_p_raise > 0) and lookup_actions_f.action = "XC" and lookup_actions_t_.action LIKE "X_%", 1, 0])
and that don t work

when you say the half of it it s just this?
sum(if[holdem_hand_player_statistics.flg_blind_def_opp and not(holdem_hand_player_statistics.cnt_p_raise > 0)

if yes what is this one? and what i do with it?
lookup_actions_f.action = "XC" and lookup_actions_t_.action LIKE "X_%", 1, 0])

[kraada]

My apologies, I made a small typing error. The one should read:

sum(if[holdem_hand_player_statistics.flg_blind_def_opp and not(holdem_hand_player_statistics.cnt_p_raise > 0) and lookup_actions_f.action = "XC" and lookup_actions_t.action LIKE "X_%", 1, 0])

The other one should read:

sum(if[holdem_hand_player_statistics.flg_blind_def_opp and not(holdem_hand_player_statistics.cnt_p_raise > 0) and lookup_actions_f.action = "XC" and lookup_actions_t.action = "XF", 1, 0])