[CASH/MTT] Effective Stack

[Doninorrez]

Good morning,

I was filtering OpenShove/CvOS spots in Cash/MTT games for review and I dont understand why some hands like these are been filtered here:

cash_hand_player_statistics.flg_p_open_opp
AND cash_hand_player_statistics.flg_p_first_raise
AND cash_hand_player_statistics.amt_p_raise_made >= cash_hand_player_statistics.amt_p_effective_stack
AND (cash_hand_player_statistics.amt_p_effective_stack / cash_limit.amt_bb >= 15 )
AND (cash_hand_player_statistics.amt_p_effective_stack / cash_limit.amt_bb < 25 )

https://gyazo.com/53f05cc938dd0889f062859c294f3b77

https://gyazo.com/113e5ae78701f3543e9130f165ceabd1


Also it would be great to know how to exclude this type of spots where the Effective Stack when Hero is openning the Pot (Not when hand is dealt) does not match with I want to review (15-25BB)

https://gyazo.com/0f24535427878dd40a7e9135bf39588c

https://gyazo.com/61941b1a6800877b2824e00c342d5ac4

Thanks in advance. ;)

[Flag_Hippo]

I was filtering OpenShove/CvOS spots in Cash/MTT games for review and I dont understand why some hands like these are been filtered here:

Please attach these hand histories to a Support Ticket and we can take a look.

Also it would be great to know how to exclude this type of spots where the Effective Stack when Hero is openning the Pot (Not when hand is dealt) does not match with I want to review (15-25BB)

Heros effective stack in that hand is 4BB. The effective stack for each player is determined at their first action in the hand and it's the maximum amount they could lose in a pot as of their first action in the hand but you can filter for your actual stack (tourney_hand_player_statistics.amt_before) instead of effective stack. If you want to filter based on the stack of another specific player in the hand then that would need a subquery which we previously discussed here.

[Doninorrez]

Hello,

Thank you again for your help Flag_Hippo.

I have just sent the HH in a Support Ticket.

Heros effective stack in that hand is 4BB. The effective stack for each player is determined at their first action in the hand and it's the maximum amount they could lose in a pot as of their first action in the hand but you can filter for your actual stack (tourney_hand_player_statistics.amt_before) instead of effective stack. If you want to filter based on the stack of another specific player in the hand then that would need a subquery which we previously discussed here.

Ook, I was confused cause this hands should not be filtered here, thanks for claryfying this, I was thinking that maybe the ES was determined when the hand was dealt.

Would be correct this subquery for excample to find the spots where Hero OpenShoves and the villain who has to Call/Fold has a stack between 10-20BBs?

cash_hand_player_statistics.id_hand in (select chps.id_hand from cash_hand_player_statistics chps, cash_limit cl where chps.id_limit = cl.id_limit and chps.flg_p_3bet_opp and (chps.amt_before / cl.amt_bb) between 10 and 20)

[Flag_Hippo]

Would be correct this subquery for excample to find the spots where Hero OpenShoves and the villain who has to Call/Fold has a stack between 10-20BBs?

cash_hand_player_statistics.id_hand in (select chps.id_hand from cash_hand_player_statistics chps, cash_limit cl where chps.id_limit = cl.id_limit and chps.flg_p_3bet_opp and (chps.amt_before / cl.amt_bb) between 10 and 20)

If Hero open shoves then villain may not have an opportunity to 3Bet (i.e they can only call or fold) depending on stacks and what players are left to act. What will always be true is that they are facing a 2bet:

Code: Select all

cash_hand_player_statistics.id_hand in (select chps.id_hand from cash_hand_player_statistics chps, cash_limit cl where chps.id_limit = cl.id_limit and chps.amt_p_2bet_facing > 0 and (chps.amt_before / cl.amt_bb) between 10 and 20)

[Doninorrez]

If Hero open shoves then villain may not have an opportunity to 3Bet (i.e they can only call or fold) depending on stacks and what players are left to act. What will always be true is that they are facing a 2bet

Totally true, sorry for the mistake and thanks again ;)