Report: Loose Passive Raises the flop

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Report: Loose Passive Raises the flop

Postby 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

Re: Report: Loose Passive Raises the flop

Postby 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

Re: Report: Loose Passive Raises the flop

Postby 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

Re: Report: Loose Passive Raises the flop

Postby 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

Re: Report: Loose Passive Raises the flop

Postby 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

Re: Report: Loose Passive Raises the flop

Postby 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

Re: Report: Loose Passive Raises the flop

Postby 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

Re: Report: Loose Passive Raises the flop

Postby 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

Re: Report: Loose Passive Raises the flop

Postby 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

Re: Report: Loose Passive Raises the flop

Postby 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

Who is online

Users browsing this forum: No registered users and 49 guests

cron
highfalutin