Discuss how to create custom stats, reports and HUD profiles and share your creations.
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
by Zito » Mon Dec 03, 2012 7:18 am
I'm trying to come up with a report that shows all instances where a player with a vp-pfr gap of 8 or greater, calls a 2bet preflop then raises on the flop.
e.g
a 30/20 calls a raise pre, then raises any flop bet.
-
Zito
-
- Posts: 122
- Joined: Fri Sep 02, 2011 10:45 am
by kraada » Mon Dec 03, 2012 12:44 pm
Use this filter in the Filter Expressions area of your custom Hand report and you'll get all and only hands that match your parameters here.
cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, cash_cache cc where not chps.flg_hero and cc.id_player = chps.id_player and chps.amt_p_2bet_facing > 0 and chps.cnt_p_call = 1 and chps.cnt_p_raise = 0 and chps.flg_f_saw and not chps.flg_f_bet and chps.cnt_f_raise >= 1 GROUP BY cc.id_player HAVING ((sum(cc.cnt_vpip) / (sum(cc.cnt_hands) - sum(cc.cnt_walks)) * 100 - (sum(cc.cnt_pfr) / sum(cnt_pfr_opp)) * 100) >= 8)
-
kraada
- Moderator
-
- Posts: 54431
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
by Zito » Mon Dec 03, 2012 1:45 pm
Hi Kraada just copied and pasted this, but I'm getting an invalid expression error.
-
Zito
-
- Posts: 122
- Joined: Fri Sep 02, 2011 10:45 am
by kraada » Mon Dec 03, 2012 2:01 pm
My apologies, I missed a ) and a group by item - the following works:
cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, cash_cache cc where not chps.flg_hero and cc.id_player = chps.id_player and chps.amt_p_2bet_facing > 0 and chps.cnt_p_call = 1 and chps.cnt_p_raise = 0 and chps.flg_f_saw and not chps.flg_f_bet and chps.cnt_f_raise >= 1 GROUP BY cc.id_player, chps.id_hand HAVING ((sum(cc.cnt_vpip) / (sum(cc.cnt_hands) - sum(cc.cnt_walks)) * 100 - (sum(cc.cnt_pfr) / sum(cnt_pfr_opp)) * 100) >= 8))
-
kraada
- Moderator
-
- Posts: 54431
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
by Zito » Mon Dec 03, 2012 5:37 pm
thanks, this one's valid but this report is still "loading..." after 45mins.
-
Zito
-
- Posts: 122
- Joined: Fri Sep 02, 2011 10:45 am
by kraada » Mon Dec 03, 2012 6:45 pm
How large is your database? This report can take a very long time due to the nature of how this kind of filter is constructed.
-
kraada
- Moderator
-
- Posts: 54431
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
by Zito » Tue Dec 04, 2012 4:58 am
It's filtered for last month's hands only (45k). System specs 6gb ram, ssd, 2.7ghz i7.
-
Zito
-
- Posts: 122
- Joined: Fri Sep 02, 2011 10:45 am
by kraada » Tue Dec 04, 2012 4:33 pm
That does seem a bit slow. How long did you end up letting it run?
-
kraada
- Moderator
-
- Posts: 54431
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
by Zito » Wed Dec 05, 2012 8:51 am
50 minutes, I'm actually trying it again as I type, with a 1,500 hand sample its been 71 minutes so far still loading. Am I following the correct steps?
my reports>new report>select hand report>filters>add new expression filters>copy paste>save make a cup/s of tea
Have you tried it yourself?
-
Zito
-
- Posts: 122
- Joined: Fri Sep 02, 2011 10:45 am
by kraada » Wed Dec 05, 2012 10:15 am
Yes and it gave me a reply fairly quickly. Please restart PT4 using the Logging Enabled link on your Start Menu and reproduce this problem. Then please send us the PokerTracker4.log file via a
support ticket so that we can investigate this further for you. You can find this file by clicking File -> Open User Data Folder in the main PT4 window. The file we need is the text file called PokerTracker that's in the folder that appears.
-
kraada
- Moderator
-
- Posts: 54431
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: No registered users and 49 guests