limp opportunity in Pokertracker

[NohimX]

Hello. I trying to understand how the stat Preflop Limp is counted for cash game. I cannot realize that - trying to combine any flags - my value is different from pokertracker stat (denominator)

[Flag_Hippo]

I don't know what flags you are using but you can see how limp opportunities are counted in PokerTracker 4 by looking at the cnt_p_limp_opp column:

cnt_p_limp_opp

Code: Select all

sum(if[((NOT cash_hand_player_statistics.flg_p_face_raise) OR (cash_hand_player_statistics.flg_p_limp) OR (cash_hand_player_statistics.flg_p_first_raise)) AND NOT (cash_hand_player_statistics.flg_blind_b OR cash_hand_player_statistics.flg_blind_db),1,0])

[NohimX]

I don't know what flags you are using but you can see how limp opportunities are counted in PokerTracker 4 by looking at the cnt_p_limp_opp column:

cnt_p_limp_opp

Code: Select all

sum(if[((NOT cash_hand_player_statistics.flg_p_face_raise) OR (cash_hand_player_statistics.flg_p_limp) OR (cash_hand_player_statistics.flg_p_first_raise)) AND NOT (cash_hand_player_statistics.flg_blind_b OR cash_hand_player_statistics.flg_blind_db),1,0])

Perfect, that what i am looking for. Can you please provide the code for vpip opportunities, there i also cannot count exact value from existing flags.

[Flag_Hippo]

If something is already counted in PokerTracker 4 you can check that by going to 'Configure -> Statistics' and checking the relevant statistic and column expressions:

Custom Statistics Guide

VPIP opportunities are calculated using two columns:

Code: Select all

(cnt_hands - cnt_walks)

cnt_hands

Code: Select all

sum(if[cash_hand_player_statistics.id_hand > 0, 1, 0])

cnt_walks

Code: Select all

sum(if[lookup_actions_p.action = '', 1, 0])

[NohimX]

Thanks a lot, was very helpful!

[NohimX]

I still miss some information. My problem that i don't know exactly how to count (Number of Hands - Number of Walks) using flags for different stats. For PFR and VPIP it is same formula, but the calculated denominator by pokertracker is different for VPIP and PFR. I guess that for PFR i have to exclude also enum_face_allin from all hands, it give me very close result to pokertracker stats, but not exact. I only found in internet old pt3 database schema, but it not complete and doesn't have any explanations of this.

[NohimX]

Looks like i found everything in STATS, thanks a lot for your help