Page 1 of 1
raise first in size

Posted:
Tue Feb 28, 2012 3:25 am
by mkjmkjmkj
i would like make a stat raise first in size in BB one for 2bb 2-3bb 3bb 3-4bb 4bb and 4bb+
i have made it for tournement stats but i could not figure out how to do it in the cashgame section
Re: raise first in size

Posted:
Tue Feb 28, 2012 4:18 am
by WhiteRider
Did you try converting the stat from tournament to cash? If you select your tournament version and click the "Convert To" button (set the appropriate new game type there first) it should convert it for you automatically.
If you do need to build it manually in most cases if you use database fields beginning with tourney_holdem_ you can just remove the "tourney_" part to get the cash equivalent. If you click the blue "insert" link on the stat editor you can browse to select the appropriate database fields.
If you're still struggling please post the column expressions here and we'll help you out.
Re: raise first in size

Posted:
Tue Feb 28, 2012 5:22 am
by mkjmkjmkj
i have tried to convert it but there are some of coulumns that cant be used in the cash section
Re: raise first in size

Posted:
Tue Feb 28, 2012 10:01 am
by kraada
If you paste one of the expressions I'll be happy to tell you how to convert it.
Re: raise first in size

Posted:
Tue Feb 28, 2012 10:55 am
by mkjmkjmkj
(cnt_p_raise_3_4_first_in / cnt_p_raise_first_in) * 100
cnt_p_raise_3_4_first_in=
sum( if[tourney_holdem_hand_player_detail.amt_p_raise_made> 3*tourney_holdem_blinds.amt_bb and tourney_holdem_hand_player_detail.amt_p_raise_made<= 4*tourney_holdem_blinds.amt_bb and tourney_holdem_hand_player_statistics.flg_p_open_opp , 1 , 0 ] )
cnt_p_raise_first_in=
sum( if[tourney_holdem_hand_player_statistics.flg_p_first_raise AND tourney_holdem_hand_player_statistics.flg_p_open_opp, 1, 0])
when i try to convert it i get a message with expression not valid
but it is valid in the tournement section
Re: raise first in size

Posted:
Tue Feb 28, 2012 11:22 am
by kraada
The issue is the blinds amount - on the cash side it's holdem_limit.amt_bb - if you remove that piece and convert it then add that piece back in with the proper area that might be easiest (change 3* tourney_holdem_blinds.amt_bb to 3, then convert, then add back in * holdem_limit.amt_bb).