create stat CB success without hand

[kroma]

hi, my english is really bad.

i need create two stats.

my idea is this, the colums count this:

-cb flop

-hole cards a pair:
(
-in flop have a pair ,not over pair, or over pair whit hole cards -77(66,55,44...)
-in flop have a double pair,not over pair hole cards, or over pair hole cards whit hole cards -77
-in flop have a full house,Board trips whit a hole cards -77.
)
-not hole cards:
(
-in flop have a high card/s
-in flop have a pair, not top pair or top pair whit kicker strength -9,or top pair -9
-in flop have a double pair, board paired hole cards not top pair or board paired hole cards top pair -9 or kicker -9
-in flop have a trips in board trips (i not know if this count)
)

this is good way? for hole cards pair:

Code: Select all

-sum(if[holdem_hand_player_statistics.flg_f_cbet AND
           ((lookup_hole_cards.flg_pair) AND
               ((holdem_hand_player_combinations.flg_f_1pair) AND
                   ((holdem_hand_player_combinations.id_f_hand_strength between 0 AND 2) OR
                    (holdem_hand_player_combinations.id_f_hand_strength between 4 AND 5)) OR
                    ((holdem_hand_player_statistics.id_holecard = 134)  OR
                     (holdem_hand_player_statistics.id_holecard = 145) OR
                     (holdem_hand_player_statistics.id_holecard = 154) OR
                     (holdem_hand_player_statistics.id_holecard = 161) OR
                     (holdem_hand_player_statistics.id_holecard = 166) OR
                     (holdem_hand_player_statistics.id_holecard = 169))
               ) OR
               ((holdem_hand_player_combinations.flg_f_2pair) AND
                   ((holdem_hand_player_combinations.id_f_hand_strength between 3 AND 4) OR
                       ((holdem_hand_player_statistics.id_holecard = 134)  OR
                       (holdem_hand_player_statistics.id_holecard = 145) OR
                       (holdem_hand_player_statistics.id_holecard = 154) OR
                       (holdem_hand_player_statistics.id_holecard = 161) OR
                       (holdem_hand_player_statistics.id_holecard = 166) OR
                       (holdem_hand_player_statistics.id_holecard = 169))
                    )   
               ) OR
               ((holdem_hand_player_combinations.flg_f_fullhouse) AND
                   ((holdem_hand_player_combinations.id_f_hand_strength between 1 AND 2) OR
                       ((holdem_hand_player_statistics.id_holecard = 134)  OR
                       (holdem_hand_player_statistics.id_holecard = 145) OR
                       (holdem_hand_player_statistics.id_holecard = 154) OR
                       (holdem_hand_player_statistics.id_holecard = 161) OR
                       (holdem_hand_player_statistics.id_holecard = 166) OR
                       (holdem_hand_player_statistics.id_holecard = 169))
                   )
               )
           )
       ), 1, 0])


thx for all.

[kraada]

If you're looking at your own data it'll be easier to just filter for the hands and situations you want and use the cbet success statistic to see what your cbet success is in those spots.

For opponents, this approach won't give you meaningful data because you have no basis for comparison - you don't know how often they have air and don't cbet and when they do cbet you don't know whether they have air or not until they reach showdown - and they will be folding against resistance when they have air a good portion.

In short - yes this will work in a technical sense, but I'm not certain how useful it will be from a poker standpoint.

[kroma]

hi, is for my stats, but not have filters in poker tracker 3 for this, only can filter one on one situation , and i need in one filter.
the big problem is where hole cards not a pair and situations related.

[kraada]

You can filter for these situations using our filter system - it is very powerful. Please see our Tutorial: Filters for details on how to use it. In particular you want to pay attention to the use of the AND and OR selected buttons as they will be instrumental in doing what you want to do.