Search found 13829 matches

Return to advanced search

Re: Turn - Delayed cbet filter

You can use this expression filter in a custom report by clicking on the 'Filters' link and selecting 'Add New Expression Filters': char_length(cash_hand_summary.str_aggressors_p) >= 2 and char_length(cash_hand_summary.str_aggressors_t) >= 1 and lookup_actions_f.action = 'X' and cash_hand_player_sta...
by Flag_Hippo
Mon Sep 25, 2023 11:31 am
 
Forum: PokerTracker 4
Topic: Turn - Delayed cbet filter
Replies: 3
Views: 55

Re: Turn - Delayed cbet filter

Filter for: 1. Having a CBet opportunity on the flop. 2. Checking the flop and not taking a second flop action. 3. Betting the turn. (Specific Bet Opportunity Continuation Bet Opportunity) AND (First Flop Action Check) AND (NOT (Second Flop Action Any Action)) AND (Bet Turn Any Turn Bet) Guide: Filt...
by Flag_Hippo
Mon Sep 25, 2023 11:06 am
 
Forum: PokerTracker 4
Topic: Turn - Delayed cbet filter
Replies: 3
Views: 55

Re: Turn - 2nd highest card on the board

For that you would need a custom expression filter that compares the rank of the turn card to the 3 flop cards: ((cash_hand_summary.card_4 - 1) % 13 < (cash_hand_summary.card_1 - 1) % 13 and (cash_hand_summary.card_4 - 1) % 13 > (cash_hand_summary.card_2 - 1) % 13 and (cash_hand_summary.card_4 - 1) ...
by Flag_Hippo
Mon Sep 25, 2023 11:05 am
 
Forum: Custom Stats, Reports and HUD Profiles
Topic: Turn - 2nd highest card on the board
Replies: 2
Views: 49

Re: Bet turn as non aggressor after check check the flop

lookup_actions_p.action = 'CC' means that the players first preflop action was call and they took a second preflop action which was also a call (for example a player limps and then subsequently calls when facing a preflop raise).
by Flag_Hippo
Mon Sep 25, 2023 5:08 am
 
Forum: Custom Stats, Reports and HUD Profiles
Topic: Bet turn as non aggressor after check check the flop
Replies: 9
Views: 1775

Re: RFI Bet Size

That type of filtering will require an expression filter with a subquery but unfortunately I've been unable to come up with anything that works for this as it's beyond my SQL knowledge I'm afraid.
by Flag_Hippo
Mon Sep 25, 2023 5:06 am
 
Forum: Custom Stats, Reports and HUD Profiles
Topic: RFI Bet Size
Replies: 7
Views: 352

Re: I'd like one of my hole cards to equal fourth pair.

Unfortunately I don't know if that's feasible although if a PostgreSQL expert sees this then they might be able to offer suggest something.
by Flag_Hippo
Mon Sep 25, 2023 5:05 am
 
Forum: Custom Stats, Reports and HUD Profiles
Topic: I'd like one of my hole cards to equal fourth pair.
Replies: 1
Views: 61

Re: PT$

Hi, so i made a backup pf PT4 on my old computer, i have a folder PT4 backup. I went to new computer to restore it, and there is no folder.. You need to transfer the backup file that was created on the old computer to the new computer. You can transfer the backup file between the computers using a ...
by Flag_Hippo
Mon Sep 25, 2023 5:04 am
 
Forum: PokerTracker 4
Topic: PT$
Replies: 12
Views: 531

Re: Report identifying sitting out hands

You can use underscores as a wildcard for any character: tourney_hand_histories.id_hand = tourney_hand_player_statistics.id_hand and (tourney_hand_histories.history like '%afteRReset (___ in chips) is sitting out%' or tourney_hand_histories.history like '%afteRReset (____ in chips) is sitting out%')
by Flag_Hippo
Sun Sep 24, 2023 5:17 am
 
Forum: Custom Stats, Reports and HUD Profiles
Topic: Report identifying sitting out hands
Replies: 6
Views: 224

Re: PT$

What specifically have you done? If you have created the backup file on the old computer have you transferred that backup file to the new computer? If you haven't transferred the backup file between computers then you are not going to see it if you are trying to run the restore on the new computer.
by Flag_Hippo
Sun Sep 24, 2023 5:16 am
 
Forum: PokerTracker 4
Topic: PT$
Replies: 12
Views: 531

Re: help pt4 please

Please do not reinstall anything as that rarely fixes anything. So we can see what's happening here turn on 'Enable Logging' in PokerTracker 4 via 'Configure -> Options' and then restart PokerTracker 4. Next reproduce this issue you've described and then attach your support bundle to a Support Ticke...
by Flag_Hippo
Sun Sep 24, 2023 5:15 am
 
Forum: PokerTracker 4
Topic: help pt4 please
Replies: 3
Views: 117
Next

Return to advanced search

cron