by I would like to clarify how to build statistics for float bets in the following scenarios:
Raised Spot
SB raises preflop, BB calls.
The hand progresses as follows:
Flop:
SB checks.
BB makes a bet (float bet on the flop).
- Code: Select all
sum(if[
tourney_hand_player_statistics.position = 8
AND tourney_hand_summary.cnt_players = 3
AND tourney_hand_summary.str_actors_p LIKE '9%'
AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) >= 2
AND lookup_actions_p.action = 'C'
AND tourney_hand_player_statistics.amt_f_bet_facing = 0
AND tourney_hand_player_statistics.amt_f_bet_made > 0
, 1, 0])
- Code: Select all
sum(if[
tourney_hand_player_statistics.position = 8
AND tourney_hand_summary.cnt_players = 3
AND tourney_hand_summary.str_actors_p LIKE '9%'
AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) >= 2
AND lookup_actions_p.action = 'C'
AND tourney_hand_player_statistics.amt_f_bet_facing = 0
, 1, 0])
Turn:
SB checks.
BB makes a bet (float bet on the turn).
- Code: Select all
sum(if[
tourney_hand_player_statistics.position = 8
AND tourney_hand_summary.cnt_players = 3
AND tourney_hand_summary.str_actors_p LIKE '9%'
AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) >= 2
AND lookup_actions_p.action = 'C'
AND lookup_actions_f.action = 'C'
AND tourney_hand_player_statistics.amt_t_bet_facing = 0
AND tourney_hand_player_statistics.amt_t_bet_made > 0
, 1, 0])
- Code: Select all
sum(if[
tourney_hand_player_statistics.position = 8
AND tourney_hand_summary.cnt_players = 3
AND tourney_hand_summary.str_actors_p LIKE '9%'
AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) >= 2
AND lookup_actions_p.action = 'C'
AND lookup_actions_f.action = 'C'
AND tourney_hand_player_statistics.amt_t_bet_facing = 0
, 1, 0])
River:
SB checks.
BB makes a bet (float bet on the river).
- Code: Select all
sum(if[
tourney_hand_player_statistics.position = 8
AND tourney_hand_summary.cnt_players = 3
AND tourney_hand_summary.str_actors_p LIKE '9%'
AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) >= 2
AND lookup_actions_p.action = 'C'
AND lookup_actions_f.action = 'C'
AND lookup_actions_t.action = 'C'
AND tourney_hand_player_statistics.amt_r_bet_facing = 0
AND tourney_hand_player_statistics.amt_r_bet_made > 0
, 1, 0])
- Code: Select all
sum(if[
tourney_hand_player_statistics.position = 8
AND tourney_hand_summary.cnt_players = 3
AND tourney_hand_summary.str_actors_p LIKE '9%'
AND ((tourney_hand_player_statistics.amt_p_2bet_facing + tourney_hand_player_statistics.amt_blind) / tourney_blinds.amt_bb) >= 2
AND lookup_actions_p.action = 'C'
AND lookup_actions_f.action = 'C'
AND lookup_actions_t.action = 'C'
AND tourney_hand_player_statistics.amt_r_bet_facing = 0
, 1, 0])
Limped Spot
SB limps preflop, BB checks.
The hand progresses as follows:
Flop:
SB checks.
BB makes a bet (float bet on the flop)
- Code: Select all
sum(if[
tourney_hand_player_statistics.position = 8
AND tourney_hand_summary.cnt_players = 3
AND tourney_hand_summary.str_actors_p LIKE '9%'
AND tourney_hand_player_statistics.cnt_p_face_limpers = 1
AND tourney_hand_player_statistics.amt_p_raise_made = 0
AND tourney_hand_player_statistics.amt_f_bet_facing = 0
AND tourney_hand_player_statistics.amt_f_bet_made > 0
, 1, 0])
- Code: Select all
sum(if[
tourney_hand_player_statistics.position = 8
AND tourney_hand_summary.cnt_players = 3
AND tourney_hand_summary.str_actors_p LIKE '9%'
AND tourney_hand_player_statistics.cnt_p_face_limpers = 1
AND tourney_hand_player_statistics.amt_p_raise_made = 0
AND tourney_hand_player_statistics.amt_f_bet_facing = 0
, 1, 0])
Turn:
SB checks.
BB makes a bet (float bet on the turn)
- Code: Select all
sum(if[
tourney_hand_player_statistics.position = 8
AND tourney_hand_summary.cnt_players = 3
AND tourney_hand_summary.str_actors_p LIKE '9%'
AND tourney_hand_player_statistics.cnt_p_face_limpers = 1
AND tourney_hand_player_statistics.amt_p_raise_made = 0
AND tourney_hand_player_statistics.amt_f_bet_facing > 0
AND lookup_actions_f.action = 'C'
AND tourney_hand_player_statistics.amt_t_bet_facing = 0
AND tourney_hand_player_statistics.amt_t_bet_made > 0
, 1, 0])
- Code: Select all
sum(if[
tourney_hand_player_statistics.position = 8
AND tourney_hand_summary.cnt_players = 3
AND tourney_hand_summary.str_actors_p LIKE '9%'
AND tourney_hand_player_statistics.cnt_p_face_limpers = 1
AND tourney_hand_player_statistics.amt_p_raise_made = 0
AND tourney_hand_player_statistics.amt_f_bet_facing > 0
AND lookup_actions_f.action = 'C'
AND tourney_hand_player_statistics.amt_t_bet_facing = 0
, 1, 0])
River:
SB checks.
BB makes a bet (float bet on the river).
- Code: Select all
sum(if[
tourney_hand_player_statistics.position = 8
AND tourney_hand_summary.cnt_players = 3
AND tourney_hand_summary.str_actors_p LIKE '9%'
AND tourney_hand_player_statistics.cnt_p_face_limpers = 1
AND tourney_hand_player_statistics.amt_p_raise_made = 0
AND tourney_hand_player_statistics.amt_f_bet_facing > 0
AND lookup_actions_f.action = 'C'
AND lookup_actions_t.action = 'C'
AND tourney_hand_player_statistics.amt_r_bet_facing = 0
AND tourney_hand_player_statistics.amt_r_bet_made > 0
, 1, 0])
- Code: Select all
sum(if[
tourney_hand_player_statistics.position = 8
AND tourney_hand_summary.cnt_players = 3
AND tourney_hand_summary.str_actors_p LIKE '9%'
AND tourney_hand_player_statistics.cnt_p_face_limpers = 1
AND tourney_hand_player_statistics.amt_p_raise_made = 0
AND tourney_hand_player_statistics.amt_f_bet_facing > 0
AND lookup_actions_f.action = 'C'
AND lookup_actions_t.action = 'C'
AND tourney_hand_player_statistics.amt_r_bet_facing = 0
, 1, 0])
