Limp/Call + Flop CBet C/F/R

[pr1mo]

i would love this stat but i am having troubles building it... it's a stat which is a combination of limp-call-pfr and what they do against a continuation bet when they are facing a bet in this situation. so opponent limps preflop and you raise after him and he calls, you are either in position on him or in the blinds - and then you continuation bet into him - or he checks and then you continuation bet.


here are the possible stat names and wording:

L/C-CFCB - Limp and call a raise preflop and then call a flop continuation bet
L/C-FFCB - Limp and call a raise preflop and then fold to a flop continuation bet
L/C-RFCB - Limp and call a raise preflop and then raise a flop continuation bet


you can get the set of 3 preflop limp stats from this forum post:

viewtopic.php?f=15&t=9500&p=68770#p68770


is it possible to combine this stat with the pt3 flop continuation bets? anyone up for building this?

this is what i've got so far, i tried combining a few pieces of other stats and this is what i came up with:

i made a cnt_f_cbet_def_action_fold_limpcall with this expression:

sum( if[holdem_hand_player_statistics.flg_p_limp AND substring(lookup_actions_p.action from 2 for 1)='C' AND holdem_hand_player_statistics.enum_f_cbet_action='F', 1, 0] )

and then a cnt_f_cbet_def_action_opp with this expression:

sum(if[holdem_hand_player_statistics.flg_p_limp AND substring(lookup_actions_p.action from 2 for 1)='C' AND holdem_hand_player_statistics.flg_f_cbet_def_opp, 1, 0])

and then build the stat called L/C-FFCB:

(cnt_f_cbet_def_action_fold_limpcall / cnt_f_cbet_def_action_fold_limpcall_opp) * 100

but this is returning a very small number of results so i don't think it's accurate.

[WhiteRider]

That stat looks pretty good.
What I do when testing stats like this is build the equivalent version of the same stat in the Holdem Cash Hand section (basically the same column but with the SUM removed so it's just a boolean) and then format the Statistic as a checkbox.
Search the Custom Statistics and Reports FAQ for format_bool.

[pr1mo]

i read through the section but didn't really follow exactly what would need to be done to check that this stat is working properly with the check box/format_bool that you mentioned. any way that you could do me a favor and check it for me please? i'm not fully confident that what i've built is correct and i don't want to use it if it's not. no rush... when you have time.

thanks again.

[kraada]

Create the columns in the Holdem Cash Hand section that doesn't sum them up (remember the Hand section is for each hand).

Then in the stat in the format tab put the format expression in as:

if(flg_f_cbet_def_action_opp_limpcall, format_bool(flg_f_cbet_def_action_fold_limpcall,'check'), '')

And it'll display the box if they had the opportunity to face a flop cbet in that spot and the box will be checked if they folded.