Page 1 of 1

3bet All-in

PostPosted: Sat Feb 01, 2025 4:11 pm
by TIGANCIC
Are my stats on 3bet ollin 2max correct?
Code: Select all
sum(if[
    tourney_hand_player_statistics.position = 8
    AND tourney_hand_summary.cnt_players = 2
    AND tourney_hand_player_statistics.flg_p_3bet
    AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) = 2
    AND tourney_hand_player_statistics.amt_p_raise_made >= tourney_hand_player_statistics.amt_p_effective_stack
, 1, 0])

Code: Select all
sum(if[
    tourney_hand_player_statistics.position = 8
    AND tourney_hand_summary.cnt_players = 2
    AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) = 2
, 1, 0])


I don't understand here it is necessary to add to AND (tourney_hand_player_statistics.amt_p_raise_made + tourney_hand_player_statistics.amt_p_2bet_facing) >= tourney_hand_player_statistics.amt_p_effective_stack

Re: 3bet All-in

PostPosted: Sun Feb 02, 2025 11:43 am
by Ventilatorrr
If you change this filter:
Code: Select all
[i]tourney_hand_player_statistics.position = 8
    AND tourney_hand_summary.cnt_players = 2
    AND tourney_hand_player_statistics.flg_p_3bet
    AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) = 2
    AND tourney_hand_player_statistics.amt_p_raise_made >= tourney_hand_player_statistics.amt_p_effective_stack[/i]

to this filter:
Code: Select all
[i]tourney_hand_player_statistics.position = 8
    AND tourney_hand_summary.cnt_players = 2
    AND tourney_hand_player_statistics.flg_p_3bet
    AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) = 2
    AND (tourney_hand_player_statistics.amt_p_raise_made[b] + tourney_hand_player_statistics.amt_p_2bet_facing)[/b] >= tourney_hand_player_statistics.amt_p_effective_stack[/i]

then hands where the 3-bet size wasn't effectively quite all-in will be included.

I would suggest you to go to My Reports in Tournament mode and create a new Hand Report. Then go to Filters > Edit Existing Expression Filters, copy first of the above filters, click Save and OK. Then select Max Hands in the dropdown menu on the top right side of the report, and mark all hands. Afterward, change the filter to the 2nd one, sort hands by the Marked column, and you will be able to see which hands weren't marked - those hands will be be counted for the stat if you decide to use the 2nd filter.