I do not understand why the columns turned out to be valid expressions, but when I enter the statistic, it gives me an invalid expression

I copied everything from the guide in the same way

**Moderators:** WhiteRider, kraada, Flag_Hippo, morny, Moderators

27 posts
• Page **3** of **3** • 1, 2, **3**

I do not understand why the columns turned out to be valid expressions, but when I enter the statistic, it gives me an invalid expression

I copied everything from the guide in the same way

I copied everything from the guide in the same way

- kaisefranz8
**Posts:**5**Joined:**Sat Sep 16, 2017 8:39 am

kaisefranz8 wrote:I do not understand why the columns turned out to be valid expressions, but when I enter the statistic, it gives me an invalid expression

I copied everything from the guide in the same way

For this statistic I suggest following the steps I mentioned a few posts back as you will have a less accurate statistic multiplying 5Bet frequency by VPIP.

With regards to your value expression you are not using any spaces at all which isn't good practice. For example from the steps I posted this validates:

- Code: Select all
`((cnt_p_3bet / cnt_p_3bet_opp) * (cnt_p_5bet_after_3bet / cnt_p_4bet_def_opp_5bet_opp_after_3b)) * 100`

If I remove all the spaces as you have done it does not validate anymore:

- Code: Select all
`((cnt_p_3bet/cnt_p_3bet_opp)*(cnt_p_5bet_after_3bet/cnt_p_4bet_def_opp_5bet_opp_after_3b))*100`

- Flag_Hippo
- Moderator
**Posts:**12793**Joined:**Tue Jan 31, 2012 7:50 am

thank you! it works! is it possible to have the statistic that includes the case where there is a cold 5bet without a 3bet first? because the columns are valid, but when I go to enter the statistics even with spaces, it gives me the error, invalid expression

- kaisefranz8
**Posts:**5**Joined:**Sat Sep 16, 2017 8:39 am

kaisefranz8 wrote:is it possible to have the statistic that includes the case where there is a cold 5bet without a 3bet first?

Yes that's possible.

kaisefranz8 wrote:because the columns are valid, but when I go to enter the statistics even with spaces, it gives me the error, invalid expression

Please give specific details of your columns and value expression. Without those I cannot tell you what's wrong.

- Flag_Hippo
- Moderator
**Posts:**12793**Joined:**Tue Jan 31, 2012 7:50 am

the column are valid, but when i insert the stat 5bet+ ratio is not valid expression

cnt_p_5bet_after_raising

sum(if[(cash_hand_player_statistics.flg_p_first_raise OR cash_hand_player_statistics.flg_p_3bet) and (char_length(cash_hand_summary.str_aggressors_p) >= 4 AND substring(cash_hand_summary.str_aggressors_p from 4 for 1)::int != cash_hand_player_statistics.position AND cash_hand_player_statistics.flg_p_4bet), 1, 0])

cnt_p_5bet_oop_after_raising

sum(if[(cash_hand_player_statistics.flg_p_first_raise OR cash_hand_player_statistics.flg_p_3bet) and (cash_hand_player_statistics.flg_p_4bet_opp and not(cash_hand_player_statistics.flg_p_3bet_def_opp)), 1, 0])

5bet+ ratio

((cnt_pfr / (cnt_hands - cnt_walks)) * (cnt_p_5bet_after_raising / cnt_p_5bet_opp_after_raising)) * 100

cnt_p_5bet_after_raising

sum(if[(cash_hand_player_statistics.flg_p_first_raise OR cash_hand_player_statistics.flg_p_3bet) and (char_length(cash_hand_summary.str_aggressors_p) >= 4 AND substring(cash_hand_summary.str_aggressors_p from 4 for 1)::int != cash_hand_player_statistics.position AND cash_hand_player_statistics.flg_p_4bet), 1, 0])

cnt_p_5bet_oop_after_raising

sum(if[(cash_hand_player_statistics.flg_p_first_raise OR cash_hand_player_statistics.flg_p_3bet) and (cash_hand_player_statistics.flg_p_4bet_opp and not(cash_hand_player_statistics.flg_p_3bet_def_opp)), 1, 0])

5bet+ ratio

((cnt_pfr / (cnt_hands - cnt_walks)) * (cnt_p_5bet_after_raising / cnt_p_5bet_opp_after_raising)) * 100

- kaisefranz8
**Posts:**5**Joined:**Sat Sep 16, 2017 8:39 am

kaisefranz8 wrote:cnt_p_5bet_oop_after_raising

sum(if[(cash_hand_player_statistics.flg_p_first_raise OR cash_hand_player_statistics.flg_p_3bet) and (cash_hand_player_statistics.flg_p_4bet_opp and not(cash_hand_player_statistics.flg_p_3bet_def_opp)), 1, 0])

5bet+ ratio

((cnt_pfr / (cnt_hands - cnt_walks)) * (cnt_p_5bet_after_raising / cnt_p_5bet_opp_after_raising)) * 100

You have used 'oop' in your column name but 'opp' in the statistics value expression.

- Flag_Hippo
- Moderator
**Posts:**12793**Joined:**Tue Jan 31, 2012 7:50 am

Flag_Hippo wrote:kaisefranz8 wrote:cnt_p_5bet_oop_after_raising

sum(if[(cash_hand_player_statistics.flg_p_first_raise OR cash_hand_player_statistics.flg_p_3bet) and (cash_hand_player_statistics.flg_p_4bet_opp and not(cash_hand_player_statistics.flg_p_3bet_def_opp)), 1, 0])

5bet+ ratio

((cnt_pfr / (cnt_hands - cnt_walks)) * (cnt_p_5bet_after_raising / cnt_p_5bet_opp_after_raising)) * 100

You have used 'oop' in your column name but 'opp' in the statistics value expression.

sorry for the mistake. thank you

- kaisefranz8
**Posts:**5**Joined:**Sat Sep 16, 2017 8:39 am

27 posts
• Page **3** of **3** • 1, 2, **3**

Return to Custom Stats, Reports and HUD Profiles

Users browsing this forum: No registered users and 2 guests