Stacksize on specific position

[expiat]

Hello, how i can create on filter expressions something that will define the stack size of a specific position! Lets say its 4handed game and i want that Hero is on the BTN and i want that SB has 20-25bb and BB as well!

Cause if i filter and use the effective stack option it doesnt work correctly and the stacksizes can be asymmetric!

Thanks in advance!

[Flag_Hippo]

If you want to filter based on the data of other players then you will need to build an expression filter that uses a subquery like this:

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 = 8 and (thps.amt_before / tb.amt_bb ) between 20 and 25)

This expression will filter hands where the BB had a stack between 20bb and 25bb and you can edit that accordingly for other positions and stack sizes. You can use this expression filter by clicking on the 'Filters' link and selecting 'Add New Expression Filters'. For more on how SELECT works see here.

[expiat]

Thanks a lot :)

[hdegou]

If you want to filter based on the data of other players then you will need to build an expression filter that uses a subquery like this:

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 = 8 and (thps.amt_before / tb.amt_bb ) between 20 and 25)

This expression will filter hands where the BB had a stack between 20bb and 25bb and you can edit that accordingly for other positions and stack sizes. You can use this expression filter by clicking on the 'Filters' link and selecting 'Add New Expression Filters'. For more on how SELECT works see here.

is there a way to adjust this filter so instead of selecting one specific position, let’s say at least one stack between BB and CO has 20-25bb and doesn’t matter which one?

[Flag_Hippo]

is there a way to adjust this filter so instead of selecting one specific position, let’s say at least one stack between BB and CO has 20-25bb and doesn’t matter which one?

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 = 8 and (thps.amt_before / tb.amt_bb ) between 20 and 25) or 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) or 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) or 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 = 1 and (thps.amt_before / tb.amt_bb ) between 20 and 25)