Request for/help creating HU stats

[kraada]

Yes, in heads up spots once you add the line to make sure we're not facing a turn bet into us, that should work properly.

You can check if you have absolute position on the table with the flag flg_f_has_position.

[madskills]

Awesome thanks for all the help.
Having a bit of trouble getting Steal Lead Turn OOP.
PT3 is saying its not valid SQL

sum(if[holdem_hand_player_detail.val_p_raise_aggressor_pos < holdem_hand_player_statistics.position AND
holdem_hand_player_statistics.flg_p_face_raise AND NOT
holdem_hand_player_statistics.flg_p_3bet AND
holdem_hand_player_statistics.flg_f_check AND NOT
holdem_hand_player_statistics.flg_f_face_bet, 1, 0])

If I change the last line from flg_f_face_bet to flg_f_face_raise it says its valid, so I'm guessing I have the expression incorrect for how to chk if the player faced a bet?

[WhiteRider]

There is no "holdem_hand_player_statistics.flg_f_face_bet" field.
You will need to use "holdem_hand_player_statistics.flg_f_3bet_opp" instead (the opportunity to 3-bet).
When you are looking at this kind of thing, click the 'insert' link and browse the database tables (make sure you click the column header on the right hand side to sort the fields alphabetically.

[kraada]

WhiteRider is right there's no flg_f_face_bet field but you can do:
NOT(holdem_hand_player_detail.amt_f_bet_facing > 0) and that will ensure you aren't facing a flop bet (sorry for not noticing that sooner).

[WhiteRider]

WhiteRider is right there's no flg_f_face_bet field but you can do:
NOT(holdem_hand_player_detail.amt_f_bet_facing > 0) and that will ensure you aren't facing a flop bet (sorry for not noticing that sooner).

:oops:
That'll teach me to do quick answers..