Search found 13830 matches

Return to advanced search

Re: New to custom stats

If anyone can point me to kind of an in-depth tutorial on making stats in general I would appreciate it. I learn much better from videos than I do reading, so ideally I am looking for a video on it. I'm not aware of any videos so I can only refer you to this guide for the basics on custom statistic...
by Flag_Hippo
Tue Sep 26, 2023 12:02 pm
 
Forum: Custom Stats, Reports and HUD Profiles
Topic: New to custom stats
Replies: 1
Views: 5

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: 65

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: 65

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: 53

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: 1787

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: 355

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: 64

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: 538

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: 226

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: 538
Next

Return to advanced search

cron
highfalutin