help whit custom stats

[kroma]

hi i need help whit columns stats, is correct?

Code: Select all

stats: call 2bet preflop

-colum name: cnt_p_call_2bet


sum( if[holdem_hand_player_statistics.cnt_p_3bet_opp AND
 ((lookup_actions_p.action LIKE 'C' OR
 (lookup_actions_p.action LIKE 'CC' AND holdem_hand_player_statistics.flg_p_limp)) AND NOT
 (holdem_hand_player_statistics.flg_p_3bet_def_opp OR
holdem_hand_player_statistics.flg_p_4bet_def_opp) , 1, 0])

-colum name: cnt_p_call_2bet_opp

sum( if[cnt_p_3bet_opp , 1, 0])



stat: call 2bet preflop and wtsd

colum: cnt_p_call_2bet_wtsd

sum( if[holdem_hand_player_statistics.cnt_p_3bet_opp AND
 ((lookup_actions_p.action LIKE 'C' OR
 (lookup_actions_p.action LIKE 'CC' AND
 holdem_hand_player_statistics.flg_p_limp)) AND NOT
 (holdem_hand_player_statistics.flg_p_3bet_def_opp OR
holdem_hand_player_statistics.flg_p_4bet_def_opp) AND
holdem_hand_player_statistics.flg_showdown, 1, 0])

colum: cnt_p_call_2bet_f_saw

sum( if[holdem_hand_player_statistics.cnt_p_3bet_opp AND
 ((lookup_actions_p.action LIKE 'C' OR
 (lookup_actions_p.action LIKE 'CC' AND
 holdem_hand_player_statistics.flg_p_limp)) AND NOT
 (holdem_hand_player_statistics.flg_p_3bet_def_opp OR
holdem_hand_player_statistics.flg_p_4bet_def_opp) AND
holdem_hand_player_statistics.flg_f_saw, 1, 0])

stat: call 2bet preflop and wtsd (specific/s hole cards)

premiun(AK+/JJ+)

colum: cnt_p_call_2bet_wtsd_premiun

sum( if[holdem_hand_player_statistics.cnt_p_3bet_opp AND
 ((lookup_actions_p.action LIKE 'C' OR
 (lookup_actions_p.action LIKE 'CC' AND
 holdem_hand_player_statistics.flg_p_limp)) AND NOT
 (holdem_hand_player_statistics.flg_p_3bet_def_opp OR
holdem_hand_player_statistics.flg_p_4bet_def_opp) AND
holdem_hand_player_statistics.flg_showdown AND
(holdem_hand_player_statistics.id_holecard = 1 OR
holdem_hand_player_statistics.id_holecard = 2 OR
holdem_hand_player_statistics.id_holecard = 3 OR
holdem_hand_player_statistics.id_holecard = 26 OR
holdem_hand_player_statistics.id_holecard = 49 OR
holdem_hand_player_statistics.id_holecard = 70), 1, 0])

colum: cnt_p_call_2bet_wtsd

sum( if[holdem_hand_player_statistics.cnt_p_3bet_opp AND
 ((lookup_actions_p.action LIKE 'C' OR
 (lookup_actions_p.action LIKE 'CC' AND
 holdem_hand_player_statistics.flg_p_limp)) AND NOT
 (holdem_hand_player_statistics.flg_p_3bet_def_opp OR
holdem_hand_player_statistics.flg_p_4bet_def_opp) AND
holdem_hand_player_statistics.flg_showdown, 1, 0])


[kroma]

i not can edit post, i see errors in first post,this is correct

hi i need help whit columns stats, is correct?

Code: Select all

stats: call 2bet preflop

-colum name: cnt_p_call_2bet


sum( if[holdem_hand_player_statistics.flg_p_3bet_opp AND
 (lookup_actions_p.action LIKE 'C' OR
 (lookup_actions_p.action LIKE 'CC' AND holdem_hand_player_statistics.flg_p_limp)) AND NOT
 (holdem_hand_player_statistics.flg_p_3bet_def_opp OR
holdem_hand_player_statistics.flg_p_4bet_def_opp) , 1, 0])

-colum name: cnt_p_call_2bet_opp

sum( if[holdem_hand_player_statistics.flg_p_3bet_opp , 1, 0])



stat: call 2bet preflop and wtsd

colum: cnt_p_call_2bet_wtsd

sum( if[holdem_hand_player_statistics.flg_p_3bet_opp AND
 (lookup_actions_p.action LIKE 'C' OR
 (lookup_actions_p.action LIKE 'CC' AND
 holdem_hand_player_statistics.flg_p_limp)) AND NOT
 (holdem_hand_player_statistics.flg_p_3bet_def_opp OR
holdem_hand_player_statistics.flg_p_4bet_def_opp) AND
holdem_hand_player_statistics.flg_showdown, 1, 0])

colum: cnt_p_call_2bet_f_saw

sum( if[holdem_hand_player_statistics.flg_p_3bet_opp AND
 (lookup_actions_p.action LIKE 'C' OR
 (lookup_actions_p.action LIKE 'CC' AND
 holdem_hand_player_statistics.flg_p_limp)) AND NOT
 (holdem_hand_player_statistics.flg_p_3bet_def_opp OR
holdem_hand_player_statistics.flg_p_4bet_def_opp) AND
holdem_hand_player_statistics.flg_f_saw, 1, 0])

stat: call 2bet preflop and wtsd (specific/s hole cards)

premiun(AK+/JJ+)

colum: cnt_p_call_2bet_wtsd_premiun

sum( if[holdem_hand_player_statistics.flg_p_3bet_opp AND
 (lookup_actions_p.action LIKE 'C' OR
 (lookup_actions_p.action LIKE 'CC' AND
 holdem_hand_player_statistics.flg_p_limp)) AND NOT
 (holdem_hand_player_statistics.flg_p_3bet_def_opp OR
holdem_hand_player_statistics.flg_p_4bet_def_opp) AND
holdem_hand_player_statistics.flg_showdown AND
(holdem_hand_player_statistics.id_holecard = 1 OR
holdem_hand_player_statistics.id_holecard = 2 OR
holdem_hand_player_statistics.id_holecard = 3 OR
holdem_hand_player_statistics.id_holecard = 26 OR
holdem_hand_player_statistics.id_holecard = 49 OR
holdem_hand_player_statistics.id_holecard = 70), 1, 0])

colum: cnt_p_call_2bet_wtsd

sum( if[holdem_hand_player_statistics.flg_p_3bet_opp AND
 (lookup_actions_p.action LIKE 'C' OR
 (lookup_actions_p.action LIKE 'CC' AND
 holdem_hand_player_statistics.flg_p_limp)) AND NOT
 (holdem_hand_player_statistics.flg_p_3bet_def_opp OR
holdem_hand_player_statistics.flg_p_4bet_def_opp) AND
holdem_hand_player_statistics.flg_showdown, 1, 0])


[kraada]

That looks good.

[kroma]

thx for see