Open Shoved Preflop 12-18bb stat

[DJSpinThat]

Hi support,

I created one for 17-30bb and it worked fine, but for some reason for 12-18bb stat i get an Invalid Value Expression error.

Just to show you what i have for:

17-30bb
(cnt_p_os_17_30bb / cnt_p_open_opp_17_30bb ) * 100 === this is what i have in the value expression section and it worked fine,

cnt_p_os_17_30bb:
sum(if[tourney_hand_player_statistics.flg_p_first_raise AND tourney_hand_player_statistics.flg_p_open_opp AND tourney_hand_player_statistics.amt_p_raise_made>=tourney_hand_player_statistics.amt_p_effective_stack AND tourney_hand_player_statistics.amt_p_effective_stack/tourney_blinds.amt_bb<30 AND tourney_hand_player_statistics.amt_p_effective_stack/tourney_blinds.amt_bb>=17, 1, 0])

cnt_p_open_opp_17_30bb:
sum(if[tourney_hand_player_statistics.flg_p_open_opp AND tourney_hand_player_statistics.amt_p_effective_stack/tourney_blinds.amt_bb>=17 AND tourney_hand_player_statistics.amt_p_effective_stack/tourney_blinds.amt_bb<30, 1, 0])

Similarly,

cnt_p_os_12_18bb:
sum(if[tourney_hand_player_statistics.flg_p_first_raise AND tourney_hand_player_statistics.flg_p_open_opp AND tourney_hand_player_statistics.amt_p_raise_made>=tourney_hand_player_statistics.amt_p_effective_stack AND tourney_hand_player_statistics.amt_p_effective_stack/tourney_blinds.amt_bb<18 AND tourney_hand_player_statistics.amt_p_effective_stack/tourney_blinds.amt_bb>=12, 1, 0])

cnt_p_open_opp_12_18bb:
sum(if[tourney_hand_player_statistics.flg_p_open_opp AND tourney_hand_player_statistics.amt_p_effective_stack/tourney_blinds.amt_bb>=12 AND tourney_hand_player_statistics.amt_p_effective_stack/tourney_blinds.amt_bb<18, 1, 0])

But when i put this in the value expression section i get the Invalid Value Expression error.
(cnt_p_os_12_18bb / cnt_p_open_opp_12_18bb ) * 100


Its exactly the same with the numbers just changed to 12 and 18 instead of 17 and 30...

Thank you for your help!

[potamito]

Cant find the reason why it would work your second variation of your custom open shove stat but to save you some time i advice you to just duplicate the one is already working and just change the part from the effective stacks, that should do it. And also, i also builded a set of open shove stat but is written a bit difference, for instance this part...

Code: Select all

tourney_hand_player_statistics.amt_p_effective_stack/tourney_blinds.amt_bb<30 AND tourney_hand_player_statistics.amt_p_effective_stack/tourney_blinds.amt_bb>=17

I have it like this...

Code: Select all

(tourney_hand_player_statistics.amt_p_effective_stack/tourney_blinds.amt_bb) between 17 and 30

I think is easier when you´re trying to build a set of there, u just duplicate them and change that part and thats it, cheers.

PS: For the record, when you use "<30" instead of "<=30" it will effectively take stacks 29bb and below not 30bb and below.

[DJSpinThat]

hey potamito,

thanks for the reply.

Ya i just duplicated the first one that worked and just replaced the numbers but got that error so i am so confused as to why..

Also, i replaced the part that you mentioned above to see if it would work:

cnt_p_os_17_30bb

sum(if[tourney_hand_player_statistics.flg_p_first_raise AND tourney_hand_player_statistics.flg_p_open_opp AND tourney_hand_player_statistics.amt_p_raise_made>=tourney_hand_player_statistics.amt_p_effective_stack AND (tourney_hand_player_statistics.amt_p_effective_stack/tourney_blinds.amt_bb) between 17 and 30

and i click save but i get "The statement is not valid SQL" ....

[Flag_Hippo]

Code: Select all

sum(if[tourney_hand_player_statistics.flg_p_first_raise AND tourney_hand_player_statistics.flg_p_open_opp AND tourney_hand_player_statistics.amt_p_raise_made>=tourney_hand_player_statistics.amt_p_effective_stack AND (tourney_hand_player_statistics.amt_p_effective_stack/tourney_blinds.amt_bb) between 17 and 30, 1, 0])

[potamito]

Holy shit of course you´re missing the last part of the expression

Code: Select all

, 1, 0])

[DJSpinThat]

hey guys, thanks for the replies.

Ok got the columns to work, however when i try to make the stat, again, this value expression i was able to save,

(cnt_p_os_17_30bb / cnt_p_open_opp_17_30bb ) * 100

but when i duplicate it and just change 17 and 30 to 12 and 18 and click save i get "invalid value expression" .....wtf..?

i attached the screenshot.

[potamito]

post the expression you´re getting that error from so we can take a look at it and see whats wrong with it

[Flag_Hippo]

but when i duplicate it and just change 17 and 30 to 12 and 18 and click save i get "invalid value expression" .....wtf..?

Did you create the necessary columns ("cnt_p_os_12_18bb" and "cnt_p_open_opp_12_18bb") first?

[DJSpinThat]

guys, i posted the screenshot......

[DJSpinThat]

yes the columns were created. i have:

cnt_p_os_12_18bb

sum(if[tourney_hand_player_statistics.flg_p_first_raise AND tourney_hand_player_statistics.flg_p_open_opp AND tourney_hand_player_statistics.amt_p_raise_made>=tourney_hand_player_statistics.amt_p_effective_stack AND tourney_hand_player_statistics.amt_p_effective_stack/tourney_blinds.amt_bb<18 AND tourney_hand_player_statistics.amt_p_effective_stack/tourney_blinds.amt_bb>=12, 1, 0])

cnt_p_open_opp_12_18bb

sum(if[tourney_hand_player_statistics.flg_p_open_opp AND tourney_hand_player_statistics.amt_p_effective_stack/tourney_blinds.amt_bb>=12 AND tourney_hand_player_statistics.amt_p_effective_stack/tourney_blinds.amt_bb<18, 1, 0])