Scenario:
Preflop: BTN raises, SB folds, BB calls.
Flop: BTN bets (SB folds).
Turn: BTN bets (SB folds).
River: BTN bets (SB folds).
Flop:
- Code: Select all
sum(if[
tourney_hand_player_statistics.position = 0
AND tourney_hand_summary.cnt_players = 3
AND tourney_hand_summary.str_actors_p LIKE '0%'
AND NOT tourney_hand_summary.str_actors_p LIKE '%9%'
AND tourney_hand_player_statistics.amt_f_bet_made < tourney_hand_player_statistics.amt_p_effective_stack
, 1, 0])
- Code: Select all
sum(if[
tourney_hand_player_statistics.position = 0
AND tourney_hand_summary.cnt_players = 3
AND NOT tourney_hand_summary.str_actors_p LIKE '%9%'
AND (tourney_hand_player_statistics.amt_f_bet_made > 0 OR tourney_hand_player_statistics.amt_f_bet_made = 0)
, 1, 0])
Turn:
- Code: Select all
sum(if[
tourney_hand_player_statistics.position = 0
AND tourney_hand_summary.cnt_players = 3
AND tourney_hand_summary.str_actors_p LIKE '0%'
AND NOT tourney_hand_summary.str_actors_p LIKE '%9%'
AND tourney_hand_player_statistics.amt_f_bet_made > 0
AND tourney_hand_player_statistics.amt_t_bet_made < tourney_hand_player_statistics.amt_p_effective_stack
, 1, 0])
- Code: Select all
sum(if[
tourney_hand_player_statistics.position = 0
AND tourney_hand_summary.cnt_players = 3
AND NOT tourney_hand_summary.str_actors_p LIKE '%9%'
AND tourney_hand_player_statistics.amt_f_bet_made > 0
AND (tourney_hand_player_statistics.amt_t_bet_made > 0 OR tourney_hand_player_statistics.amt_t_bet_made = 0)
, 1, 0])
River:
- Code: Select all
sum(if[
tourney_hand_player_statistics.position = 0
AND tourney_hand_summary.cnt_players = 3
AND tourney_hand_summary.str_actors_p LIKE '0%'
AND NOT tourney_hand_summary.str_actors_p LIKE '%9%'
AND tourney_hand_player_statistics.amt_f_bet_made > 0
AND tourney_hand_player_statistics.amt_t_bet_made > 0
AND tourney_hand_player_statistics.amt_r_bet_made > 0
, 1, 0])
- Code: Select all
sum(if[
tourney_hand_player_statistics.position = 0
AND tourney_hand_summary.cnt_players = 3
AND NOT tourney_hand_summary.str_actors_p LIKE '%9%'
AND tourney_hand_player_statistics.amt_f_bet_made > 0
AND tourney_hand_player_statistics.amt_t_bet_made > 0
AND (tourney_hand_player_statistics.amt_r_bet_made > 0 OR tourney_hand_player_statistics.amt_r_bet_made = 0)
, 1, 0])
