AFq for sb and bb

[Nitilism]

For HU games, I am trying to build AFq's per street specific to positions. Following the format used by PT3 for AFq, I made a column cnt_f_bet_sb which I defined as:

sum(if[tourney_holdem_hand_player_statistics.flg_blind_s and tourney_holdem_hand_player_statistics.flg_f_bet, 1, 0])

I then tried to make cnt_f_raise_sb similarly, but discovered there was no flg_f_raise field in the tourn_holdem_payer_stat database, and likewise for the turn and river, although the rest of the flg fields I would need for AFq's seem to be there.

Is there a way to create the Flg_f_raise field or create another column that would be equivalent?

Thanks

[Nitilism]

I think I figured this out, would this be the equivalent to cnt_f_raise but only for flop raises in the sb

cnt_f_raise_sb = sum(if[tourney_holdem_hand_player_statistics.flg_blind_s and (tourney_holdem_hand_player_statistics.flg_f_3bet or tourney_holdem_hand_player_statistics.flg_f_4bet or tourney_holdem_hand_player_statistics.flg_f_first_raise), 1, 0])

[WhiteRider]

You just need to add a check for
tourney_holdem_hand_player_statistics.cnt_f_raise > 0
You can raise more than once, so the database field records how many times the player raised on the flop.

[Nitilism]

Do you mean this or something different...

cnt_f_raise_sb = sum(if[tourney_holdem_hand_player_statistics.flg_blind_s and tourney_holdem_hand_player_statistics.cnt_f_raise > 0 and (tourney_holdem_hand_player_statistics.flg_f_3bet or tourney_holdem_hand_player_statistics.flg_f_4bet or tourney_holdem_hand_player_statistics.flg_f_first_raise), 1, 0])

[kraada]

cnt_f_raise_sb = sum(if[tourney_holdem_hand_player_statistics.flg_blind_s and tourney_holdem_hand_player_statistics.cnt_f_raise > 0, 1, 0])

is sufficient as cnt_f_raise is the count of all raises, not exact 2-bets (that is, it's not when you raise a bet, it's when you raise any bet).