Expression filters

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Expression filters

Postby summy » Thu Apr 04, 2013 4:52 am

Hey,

I'd like to have an expression filter vs specific types of opponents.
One would be vs players in the BB folding < 40 vs btn open (have made a custom stat for that) and another one reverse
when I'm in the BB and they open > 60 from the btn.
Would be cool to see how I'm doing in both scenarios.
Could you give me the expressions for that? I realize it will probably take a long time to return data but that's ok :).

Thanks.
summy
 
Posts: 36
Joined: Wed Mar 16, 2011 5:39 am

Re: Expression filters

Postby kraada » Thu Apr 04, 2013 9:36 am

Could you put your custom stat up on the Warehouse? That would make this a lot easier to build.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Expression filters

Postby summy » Thu Apr 04, 2013 10:00 am

summy
 
Posts: 36
Joined: Wed Mar 16, 2011 5:39 am

Re: Expression filters

Postby summy » Fri Apr 05, 2013 5:09 am

Bump since this dropped off the first page and I might been forgotten :D
summy
 
Posts: 36
Joined: Wed Mar 16, 2011 5:39 am

Re: Expression filters

Postby kraada » Fri Apr 05, 2013 8:23 am

I haven't forgotten, I just need a little time to make it happen and yesterday turned out a bit busier than expected. :)
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Expression filters

Postby summy » Tue Apr 09, 2013 2:05 pm

:cry:
summy
 
Posts: 36
Joined: Wed Mar 16, 2011 5:39 am

Re: Expression filters

Postby kraada » Tue Apr 09, 2013 4:23 pm

Sorry for the delay. These can take some time.

Either way it's ready now :)

Here's your filters.

For you're in the BB and the BTN opens > 60%, filter for generally being in the BB and facing a steal using Simple Filters. Then add this to get raises only from the button where he had a button open percentage of > 60%:

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, cash_cache cc where chps.id_player = cc.id_player and chps.position = 0 and chps.flg_steal_att GROUP BY chps.id_player, chps.id_hand HAVING (( (CASE WHEN sum(cc.cnt_p_open_opp_btn) <> 0 THEN (((sum(cc.cnt_p_rfi_btn) * 1.0)* 1.0 )/((sum(cc.cnt_p_open_opp_btn) * 1.0) * 100.0 )) ELSE 0 END) ) >= 60))

And for the other side, filter for hands where you're on the button and made a steal using Simple Filters. Add this filter expression to get all hands where the BB faced a steal and he folds < 40% vs a button open:

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, cash_cache cc where chps.id_player = cc.id_player and chps.position = 8 and chps.flg_steal_def_opp and cc.position = 8 GROUP BY chps.id_player, chps.id_hand HAVING (( (CASE WHEN sum(cc.cnt_p_3bet_opp_vs_btn_open) <> 0 THEN (((sum(cc.cnt_p_3bet_opp_vs_btn_open) * 1.0) - (sum(cc.cnt_p_call_vs_btn_open)* 1.0) - (sum(cc.cnt_p_3bet_vs_btn_open) ))/((sum(cc. cnt_p_3bet_opp_vs_btn_open) * 1.0) * 100.0 )) ELSE 0 END) ) <= 40))

I haven't had a time to go through exhaustively and make sure that checks all cases though but give it a spin and let me know if it gives you any trouble.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Expression filters

Postby summy » Wed Apr 10, 2013 6:44 am

Thanks a lot kraada.

Unfortunately the first filter doesn't return any results for me and the 2nd one seems to be invalid.
summy
 
Posts: 36
Joined: Wed Mar 16, 2011 5:39 am

Re: Expression filters

Postby kraada » Wed Apr 10, 2013 10:16 am

Try this instead of the second one:

cash_hand_player_statistics.id_hand in (SELECT chps.id_hand from cash_hand_player_statistics chps, cash_cache cc where chps.id_player = cc.id_player and chps.position = 8 and chps.flg_steal_def_opp and cc.position_type = 4 GROUP BY chps.id_player, chps.id_hand HAVING (( (CASE WHEN sum(cc.cnt_p_3bet_opp_vs_btn_open) <> 0 THEN (((sum(cc.cnt_p_3bet_opp_vs_btn_open) * 1.0) - (sum(cc.cnt_p_call_vs_btn_open)* 1.0) - (sum(cc.cnt_p_3bet_vs_btn_open) ))/((sum(cc. cnt_p_3bet_opp_vs_btn_open) * 1.0) * 100.0 )) ELSE 0 END) ) <= 40))

The first should be working, I don't know why it's not returning data for you unless that situation simply isn't in the database.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Expression filters

Postby summy » Wed Apr 10, 2013 12:21 pm

Still says expression is not valid.

Tryed the first one again but yea doesn't return anything.
I'm using the filter on a small db with 5k+ hands so that it would return results faster, don't know if that changes anything?
Anyways the situation is definitely given, also lowered it to 10% but still nothing :(.
summy
 
Posts: 36
Joined: Wed Mar 16, 2011 5:39 am

Next

Return to PokerTracker 4

Who is online

Users browsing this forum: No registered users and 93 guests

cron