3 Bet All in and 3 Bet Not all Stats

[Zito]

Either way should work though you may also want to think about the size of the 2bet - if the 2bet was really big and you minraised in response and it meant the 3bet was relatively small it wouldn't match your filter as put together.

Though that's not exactly going to be common it seems worth mentioning.

but it would be considered a non all in 3bet? e.g. one thats less than 50% of the effective stack

[Zito]

I can't see my mistake here but this stat won't validate, (all columns have been built and are functioning):

Code: Select all

if(live_table_min_stack / live_amt_bb > 30, if(cnt_p_3bet_def_opp_30_99 != 0, ((cnt_p_3bet_def_action_fold_when_open_raised_30_99 - cnt_p_3bet_ai_def_action_fold_when_open_raised_30_99) / cnt_p_3bet_def_opp_30_99)*100, '-'),
if(live_table_min_stack / live_amt_bb > 17, if(cnt_p_3bet_def_opp_17_30 != 0, ((cnt_p_3bet_def_action_fold_when_open_raised_17_30 - cnt_p_3bet_ai_def_action_fold_when_open_raised_17_30) / cnt_p_3bet_def_opp_17_30)*100, '-'),
if(live_table_min_stack / live_amt_bb > 12, if(cnt_p_3bet_def_opp_12_18 != 0, ((cnt_p_3bet_def_action_fold_when_open_raised_12_18 - cnt_p_3bet_ai_def_action_fold_when_open_raised_12_18) / cnt_p_3bet_def_opp_12_18)*100, '-'),
if(live_table_min_stack / live_amt_bb > 7, if(cnt_p_3bet_def_opp_07_13 != 0, ((cnt_p_3bet_def_action_fold_when_open_raised_07_13 - cnt_p_3bet_ai_def_action_fold_when_open_raised_07_13) / cnt_p_3bet_def_opp_07_13)*100, '-'),
if(cnt_p_3bet_def_opp_00_08 != 0, ((cnt_p_3bet_def_action_fold_when_open_raised_00_08 - cnt_p_3bet_ai_def_action_fold_when_open_raised_00_08) / cnt_p_3bet_def_opp_00_08)*100, '-')))))

[kraada]

Live columns and historical columns cannot be used together in a single stat, they must be kept separate.

[Zito]

Live columns and historical columns cannot be used together in a single stat, they must be kept separate.

Is there an alternative in this case without having to create separate 3 bet not all in columns?

[PeteX]

Live columns and historical columns cannot be used together in a single stat, they must be kept separate.

Not quite true, see this:

Code: Select all

if ((live_cnt_players > 6) AND (cnt_hands_7_10_players - cnt_walks_7_10_players > 9), var_vpip_7_10_players ,
if ((live_cnt_players > 4 AND live_true_cnt_players < 7) AND (cnt_hands_5_6_players - cnt_walks_5_6_players > 9), var_vpip_5_6_players ,
if ((live_cnt_players = 4) AND (cnt_hands_4_players - cnt_walks_4_players > 9), var_vpip_4_players ,
if ((live_cnt_players = 3) AND (cnt_hands_3_players - cnt_walks_3_players > 9), var_vpip_3_players ,
if ((live_cnt_players = 2) AND (cnt_hands_2_players - cnt_walks_2_players > 9), var_vpip_2_players , var_vpip)))))

Here we have a single stat called "Adaptive VPIP" that will show different values for different player counts. Here I combine live stats and historical stats. And rest assured, this stat works just fine.

Arguably you could use the player count filtering from HUD options also, but this is another option, especially if you want to use filtering for part of the stats but not for all.

[kraada]

I stand corrected. If you look in the log file, what error does it give when the validation fails? A quick look shows the parentheses all match. I don't see an obvious typo but the log would make that clear.

[Zito]

Log reads:
"3:51.048 [09835]: [- Main -][StatManager] Variable expression not valid: Unknown token encountered: cnt_p_3bet_def_action_fold_when_open_raised_30_99"

cnt_p_3bet_def_action_fold_when_open_raised_30_99

Code: Select all

sum(if[tourney_hand_player_statistics.enum_p_3bet_action='F'AND  tourney_hand_player_statistics.amt_p_raise_made >= tourney_hand_player_statistics.amt_p_effective_stack * .5 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 30 and 99 AND tourney_hand_player_statistics.flg_p_first_raise, 1, 0])

[kraada]

Try removing one level of the nesting and let me know if it validates then.

[Zito]

Try removing one level of the nesting and let me know if it validates then.

I removed the "30_99" levels but still got an invalid expression.
Log: [- Main -][WindowDialog] Closing Dialog: Invalid Expression (0018DE18)

30_99 removed:

Code: Select all

if(live_table_min_stack / live_amt_bb > 17, if(cnt_p_3bet_def_opp_17_30 != 0, ((cnt_p_3bet_def_action_fold_when_open_raised_17_30 - cnt_p_3bet_ai_def_action_fold_when_open_raised_17_30) / cnt_p_3bet_def_opp_17_30)*100, '-'),
if(live_table_min_stack / live_amt_bb > 12, if(cnt_p_3bet_def_opp_12_18 != 0, ((cnt_p_3bet_def_action_fold_when_open_raised_12_18 - cnt_p_3bet_ai_def_action_fold_when_open_raised_12_18) / cnt_p_3bet_def_opp_12_18)*100, '-'),
if(live_table_min_stack / live_amt_bb > 7, if(cnt_p_3bet_def_opp_07_13 != 0, ((cnt_p_3bet_def_action_fold_when_open_raised_07_13 - cnt_p_3bet_ai_def_action_fold_when_open_raised_07_13) / cnt_p_3bet_def_opp_07_13)*100, '-'),
if(cnt_p_3bet_def_opp_00_08 != 0, ((cnt_p_3bet_def_action_fold_when_open_raised_00_08 - cnt_p_3bet_ai_def_action_fold_when_open_raised_00_08) / cnt_p_3bet_def_opp_00_08)*100, '-'))))

[kraada]

What's the line before that in the log? That line just says it closed the invalid expression window, but doesn't give the reason why it wasn't valid.