PokerTracker

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.

Could you put your custom stat up on the Warehouse? That would make this a lot easier to build.

Sure:
https://www.pokertracker.com/sites/file ... ld.pt4stat

Bump since this dropped off the first page and I might been forgotten

I haven't forgotten, I just need a little time to make it happen and yesterday turned out a bit busier than expected.

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.

Thanks a lot kraada.

Unfortunately the first filter doesn't return any results for me and the 2nd one seems to be invalid.

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.

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 .