4bet vs 3bettor effective stack

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

4bet vs 3bettor effective stack

Postby b4rr4o » Sun Sep 18, 2016 8:33 am

Hi, i'm trying to make a 4bet custom stat but the effective stack is only related to the stat player. I want to know the effective stack from the player that is doing the 3bet

I guess i have to make a subquery but can't figure it out, any ideas?

sum(if[cash_hand_player_statistics.flg_p_first_raise and cash_hand_player_statistics.flg_p_4bet and (select 3bet.amt_p_effective_stack from cash_hand_player_statistics as 3bet
where (cash_hand_player_statistics.id_hand = 3bet.id_hand
and 3bet.flg_p_3bet)
/ cash_limit.amt_bb) <= 25, 1, 0])
b4rr4o
 
Posts: 20
Joined: Mon Feb 11, 2008 11:25 am

Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 25 guests

cron
highfalutin