Report: Loose Passive Raises the flop

[Zito]

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.

[kraada]

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)

[Zito]

Hi Kraada just copied and pasted this, but I'm getting an invalid expression error.

[kraada]

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))

[Zito]

thanks, this one's valid but this report is still "loading..." after 45mins.

[kraada]

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.

[Zito]

It's filtered for last month's hands only (45k). System specs 6gb ram, ssd, 2.7ghz i7.

[kraada]

That does seem a bit slow. How long did you end up letting it run?

[Zito]

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?

[kraada]

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.