Page 1 of 1

How to create 3bet vs. btn open (SB)?

PostPosted: Mon Dec 02, 2024 1:05 am
by pokertrackfan77
Hello,

I'm trying to create a stat for a custom report, not for my HUD. I know that you can use positional parameters for your HUD and was hoping that it would be easy to modify the already-existed 3bet vs. btn open, but i was unable to find it.

Ideally, I'd like to be able to see the percentage of hands that someone 3bets vs. a btn open from the sb.

I saw the definition was:
(cnt_p_3bet_vs_btn_open / cnt_p_3bet_opp_vs_btn_open) * 100

and the code for both those columns was, respectively:

sum(if[cash_hand_player_statistics.flg_p_3bet and cash_hand_summary.str_aggressors_p LIKE '80%' and cash_hand_summary.str_actors_p LIKE '0%', 1, 0])


sum(if[cash_hand_player_statistics.flg_p_3bet_opp and cash_hand_summary.str_aggressors_p LIKE '80%' and cash_hand_summary.str_actors_p LIKE '0%', 1, 0])

Is there a way to modify these columns to include SB only from the 3bettors? Like adding a where clause somewhere?

Thanks

Re: How to create 3bet vs. btn open (SB)?

PostPosted: Mon Dec 02, 2024 7:00 am
by Flag_Hippo
You can also add the 'Position' statistic to a report to see the results broken down by position. If you want to create a separate statistic you can specify that the player was in the small blind by adding:

Code: Select all
cash_hand_player_statistics.position = 9

For example:

cnt_p_3bet_sb_vs_btn_open
Code: Select all
sum(if[cash_hand_player_statistics.position = 9 and cash_hand_player_statistics.flg_p_3bet and cash_hand_summary.str_aggressors_p LIKE '80%' and cash_hand_summary.str_actors_p LIKE '0%', 1, 0])

Re: How to create 3bet vs. btn open (SB)?

PostPosted: Mon Dec 02, 2024 8:28 am
by pokertrackfan77
Flag_Hippo wrote:You can also add the 'Position' statistic to a report to see the results broken down by position. If you want to create a separate statistic you can specify that the player was in the small blind by adding:

Code: Select all
cash_hand_player_statistics.position = 9

For example:

cnt_p_3bet_sb_vs_btn_open
Code: Select all
sum(if[cash_hand_player_statistics.position = 9 and cash_hand_player_statistics.flg_p_3bet and cash_hand_summary.str_aggressors_p LIKE '80%' and cash_hand_summary.str_actors_p LIKE '0%', 1, 0])


Thanks!

Would BB position be equal to cash_hand_player_statistics.position = 1 then? If I wanted to see 3 bet from BB vs. BTN open?

Re: How to create 3bet vs. btn open (SB)?

PostPosted: Mon Dec 02, 2024 12:59 pm
by Flag_Hippo
The BB is position 8, the SB is position 9 and the BTN is position 0. The remaining positions are based on the number of seats off the BTN so CO is position 1 e.t.c.

highfalutin