Fold to Flop Bet Stat Split

[pr1mo]

I would like to split this stat up positionally and also by the amount of opponents we are up against as well as no raise preflop.

So to start out i will list the information for the built in pt stat:

Fold to F Bet:
(cnt_f_bet_def_action_fold / cnt_f_bet_def_opp) * 100

whereas:

cnt_f_bet_def_action_fold = sum(if[holdem_hand_player_detail.amt_f_bet_facing > 0 AND holdem_hand_player_statistics.flg_f_fold, 1, 0])

and:

cnt_f_bet_def_opp = sum(if[holdem_hand_player_detail.amt_f_bet_facing > 0, 1, 0])

Now first off I would like this stat to be just for heads up situations where there was also no raise preflop and then split into 2 categories:

1. opponent who has position and faces a bet.

and

2. opponent out of position who checks and then faces a bet


I'm not sure how to add number of players in the hand but i do see this value that we could use in a custom donk bet stat but i'm not sure how to set it to 2 players: (holdem_hand_summary.cnt_players-1)

For whether we are in position or not i see there is holdem_hand_player_statistics.position but not sure how to list whether we are in first or last position.

Not sure how to list whether there was a preflop raise or not. possibly: holdem_hand_player_statistics.cnt_p_raise > 0

For the second stat we need to add that there was a check so a check field would be based on what i saw in columns: holdem_hand_player_statistics.flg_f_check


So I need to combine some of these into the first one and some into the second one to create both columns for the equation but not sure how to put them all together, could someone please take this data and turn it into a stat for me, i tried to do as much research as i could and put as much as i could find in here.

thanks for your time.

[kraada]

Well, there's the holdem_hand_summary.cnt_players_f field which tells you how many players saw the flop.

That combined with holdem_hand_player_detail.flg_f_has_position (which tells you if someone has position) should give you the info you need.

For the opportunities:

sum(if[holdem_hand_summary.cnt_players_f = 2 and holdem_hand_player_detail.flg_f_has_position and holdem_hand_player_detail.amt_bet_facing > 0, 1, 0])

will count how many times someone faced a bet in position on the flop heads up.

change it to NOT(holdem_hand_player_detail.flg_f_has_position) to make it times they faced that bet out of position.

To count how many times they fold, add in holdem_hand_player_statistics.flg_f_fold to the restrictions there. Then create the stat on the stats tab as normal.

[pr1mo]

sum(if[holdem_hand_summary.cnt_players_f = 2 and holdem_hand_player_detail.flg_f_has_position and holdem_hand_player_detail.amt_bet_facing > 0, 1, 0])

will count how many times someone faced a bet in position on the flop heads up.

how would i go about making it so it's only situations where there wasn't a raise preflop. i know there is cnt_p_raise = 0 but that is just us not raising, not including our opponents. is there a general "there was no raise preflop" that i could insert?

[WhiteRider]

You can also check for holdem_hand_player_statistics.flg_p_face_raise.

[kraada]

That would do it; if you didn't make a raise and didn't face a raise, and you got to the flop, there was no raise.