new stat/column 3bet from ep vs open raise

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

new stat/column 3bet from ep vs open raise

Postby Whoareyoux1 » Thu Mar 08, 2018 4:09 pm

i put this filter on sample in order to create a column who count the number of times when open ep, ep 3bet

tourney_hand_player_statistics.flg_p_first_raise
and tourney_hand_player_statistics.flg_p_3bet_def_opp and not tourney_hand_player_statistics.flg_p_squeeze
AND ((tourney_hand_summary.cnt_players BETWEEN 4 and 6 and substring(tourney_hand_summary.str_aggressors_p from 3 for 2)::int BETWEEN 3 and 5) OR (tourney_hand_summary.cnt_players BETWEEN 7 and
8 and substring(tourney_hand_summary.str_aggressors_p from 3 for 2)::int BETWEEN 4 and 7) OR (tourney_hand_summary.cnt_players BETWEEN 9 and 10 and
substring(tourney_hand_summary.str_aggressors_p from 3 for 2)::int BETWEEN 5 and 7) )

but i have hands with ep open call and squizz from the btn and even hands with ep open and 3bet btn in 9 max , and i cant figure why with that filter

help pls
regards
Whoareyoux1
 
Posts: 4
Joined: Fri Jun 02, 2017 12:35 pm

Re: new stat/column 3bet from ep vs open raise

Postby Whoareyoux1 » Thu Mar 08, 2018 5:03 pm

some part of the code is useless for EP 3bet but i want to do it for MP CO BN SB BB too which the code will be used for

eg wrong hands counted

https://gyazo.com/eded41c6501288a8c61ef26a5049af43

https://gyazo.com/3016df93aad433d99de20cb07a24fa6e
Whoareyoux1
 
Posts: 4
Joined: Fri Jun 02, 2017 12:35 pm

Re: new stat/column 3bet from ep vs open raise

Postby Whoareyoux1 » Thu Mar 08, 2018 5:58 pm

ok i got i missunderstood de substring function from postgress
it will work with substring.. from to 3 for 1

regards
Whoareyoux1
 
Posts: 4
Joined: Fri Jun 02, 2017 12:35 pm


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 21 guests

cron
highfalutin