I have been working a bit on the TPTK+underpairs bit, but I am stuck once again. The holdem_hand_player_combinations.id_x_hand_strength doesn't seem to work exactly like you've described in your other post, strength =4 or 5 seems to incude overpairs aswell as some wierd 2-paired with board as far as i can tell.
Here's what i've got for the river TPTK+underpair flag (turn and flop are basically the same).
- Code: Select all
( %this part is to tag TPTK-
((holdem_hand_player_combinations.flg_r_highcard or holdem_hand_player_combinations.flg_r_1pair) and (holdem_hand_player_combinations.val_r_hole_cards_used = 0 or holdem_hand_player_combinations.val_r_hole_cards_used = 1))
or
( %this part is to tag underpairs
holdem_hand_player_combinations.flg_r_1pair and holdem_hand_player_combinations.val_r_hole_cards_used = 2 and
(holdem_hand_player_combinations.id_r_hand_strength = 4 or holdem_hand_player_combinations.id_r_hand_strength = 5)
)
or
( %this part is to tag underpairs (which make 2pair with a paired board)
holdem_hand_player_combinations.flg_r_2pair and holdem_hand_player_combinations.val_r_hole_cards_used = 2 and
(holdem_hand_player_combinations.id_r_hand_strength = 4 or holdem_hand_player_combinations.id_r_hand_strength = 5)
)
I have experimented a bit with the sweet spot for the PTBB level, and around 25 seems to be a good tradeoff (atleast for FR micro-stakes) between false positives and missing plays, for higher levels probably 20PTBB is better.
On another note i am now pretty certain that the stat is flawed in another way too, basically it counts the number of pots where either of the players involved held something weaker than TPTK. The stat is still pretty useful in marking out people who tend to go overboard with TPTK, but it doesn't seem to be very exact.
I have also made the front end, which as you said was a peice of cake.
The front end is attatched to this post, it requires the column cnt_overplayed_tptk in HCPS as described above.
Another pretty useful measure (i actually put it in my regular hud) is cnt_overplayed_tptk / cnt_hands * 1000 , which really marks out the people who overplay alot.
The read based stat format string:
- Code: Select all
if(cnt_overplayed_tptk > 0, format('Overplayed TPTK or less {1} times.', format_number(cnt_overplayed_tptk, 0, false, false)), '')
TPTK Overplayed/hands stat:
- Code: Select all
cnt_overplayed_tptk / cnt_hands * 1000