PokerTracker

I want to review/replay hands with the opponents I have the most hands against in order to search for weaknesses in their play.

I want to replay only those hands in which we both VPIP

I am one of those people who is overwhelmed by Poker Tracker 4's capabilities and not utilizing it fully.

To view/replay hands where you and a specific opponent both VPIP create a custom hand report and then use this expression filter:

Code: Select all

cash_hand_player_statistics.flg_hero AND cash_hand_player_statistics.flg_vpip AND cash_hand_player_statistics.id_hand IN (
    SELECT chps1.id_hand
    FROM cash_hand_player_statistics chps1
    JOIN cash_hand_player_statistics chps2 ON chps1.id_hand = chps2.id_hand AND chps2.flg_hero
    JOIN player p ON chps1.id_player = p.id_player
    WHERE NOT chps1.flg_hero
    AND chps1.flg_vpip
    AND p.player_name = 'OpponentNameHere'
)

You can use this expression filter by clicking on the 'Filters' link and selecting 'Add New Expression Filters'. Replace 'OpponentNameHere' with the actual opponent's screen name (keep the single quotes) and you will need to replace all instances of 'cash' with 'tourney' if you are in a tournament report. If using the expression filter gives an error in your hand report change the hands dropdown to 'Max Hands'.

Thank you, Flag Hippo!

I am getting an "invalid expression" message

The provided expression is valid - see attached screenshot:


Please attach a screenshot of the expression you are trying to use.

my bad ....i miscopied....all is well now, thanks Flag_Hippo