Page 1 of 1

4b ip report

PostPosted: Sun Jun 10, 2018 9:45 pm
by Jackntigger
Hi,
I would like to create an expression that I can put into a report that will show me all instances where an active player 2bets then gets 3bet then he 4bets in position vs the 3better. In Position to be defined as if you were postflop (where the button is the most in position). I've searched for this and found the following discussion but I wasn't able to get any of the listed code to validate.
https://www.pokertracker.com/forums/viewtopic.php?t=58271
Thanks.

Re: 4b ip report

PostPosted: Mon Jun 11, 2018 6:23 am
by Flag_Hippo
Code: Select all
cash_hand_player_statistics.flg_p_first_raise and cash_hand_player_statistics.flg_p_4bet and char_length(cash_hand_summary.str_aggressors_p) >= 4 and substring(cash_hand_summary.str_aggressors_p from 3 for 1)::int > cash_hand_player_statistics.position

Re: 4b ip report

PostPosted: Mon Jun 11, 2018 2:44 pm
by Jackntigger
Thank you. This works perfectly.

Re: 4b ip report

PostPosted: Mon Jun 11, 2018 8:08 pm
by Jackntigger
In case anyone is interested, I was able to make a 4B oop vs 3better report by simply reversing the greater than sign and substituting a less than sign so the code came out like this:
Code: Select all
cash_hand_player_statistics.flg_p_first_raise and cash_hand_player_statistics.flg_p_4bet and char_length(cash_hand_summary.str_aggressors_p) >= 4 and substring(cash_hand_summary.str_aggressors_p from 3 for 1)::int < cash_hand_player_statistics.position

highfalutin