Page 1 of 1

Put effective stacksize in Stats

PostPosted: Sat Nov 30, 2013 2:24 pm
by hotrocket
Hello, I play NL CAP and want to exclude hands with low effective stacksize in my stats for Cashgame. I searched but didn`t find anything. I need something like ...

AND cash_hand_player_statistics_effective_stack_size Between 18 and 20.

Thanks for any help!

Re: Put effective stacksize in Stats

PostPosted: Sun Dec 01, 2013 6:02 am
by WhiteRider
That sort of thing should work fine - what problem are you having with it?

Re: Put effective stacksize in Stats

PostPosted: Sun Dec 01, 2013 1:23 pm
by hotrocket
this statement is not valid SQL

Re: Put effective stacksize in Stats

PostPosted: Mon Dec 02, 2013 3:45 am
by WhiteRider
Sorry - the database field for the effective stack preflop is:

cash_hand_player_statistics.amt_p_effective_stack