PokerTracker

I created a custom report where given 3 players, I want to filter hands for a certain stack size range between BTN and SB (e.g. 20-25BB), while ignoring BB. Effective stack stat works only if BB stack <= min(BTN, SB stack), but it doesn't if BB stack is larger than any of these two. Any way to get around this?

That would need a custom expression filter in a custom report with a subquery that tests for the actual stacks of each player:

Code: Select all

tourney_hand_player_statistics.id_hand in (select thps.id_hand from tourney_hand_player_statistics thps, player p, tourney_blinds tb where thps.id_player = p.id_player and thps.id_blinds = tb.id_blinds and thps.position = 0 and (thps.amt_before / tb.amt_bb ) between 20 and 25) and tourney_hand_player_statistics.id_hand in (select thps.id_hand from tourney_hand_player_statistics thps, player p, tourney_blinds tb where thps.id_player = p.id_player and thps.id_blinds = tb.id_blinds and thps.position = 9 and (thps.amt_before / tb.amt_bb ) between 20 and 25)

You can use this expression filter by clicking on the 'Filters' link and selecting 'Add New Expression Filters'.