hud profile for different tourny levels

[kingkong32]

Thank you. Unfortunately I forgot to mention that I play SnG so I think I need the tourney expressions.

(1) I finally used tourney_holdem_hand_summary.amt_p_effective_stack. Is this right?

(2) I tried it in the cash section but I get the error "The statement is not valid SQL" when I try something like "sum(if[holdem_hand_player_detail.amt_p_raise_made > holdem_hand_player_detail.amt_p_effective_stack AND lookup_actions_p = 'R' AND holdem_hand_player_statistics.flg_blind_s, 1, 0])" Could you check it and give me also the expression for tourneys.

[WhiteRider]

1) looks good.

2) The effective stack is not a player-specific stat - it relates to the hand, so is "holdem_hand_summary.amt_p_effective_stack" (not player_detail)
Also, you need this: lookup_actions_p.action = 'R'

This validates for cash:

sum(if[holdem_hand_player_detail.amt_p_raise_made > holdem_hand_summary.amt_p_effective_stack AND lookup_actions_p.action = 'R' AND holdem_hand_player_statistics.flg_blind_s, 1, 0])

For tournaments you need to add tourney_ to a few table names:

sum(if[tourney_holdem_hand_player_detail.amt_p_raise_made > tourney_holdem_hand_summary.amt_p_effective_stack AND lookup_actions_p.action = 'R' AND tourney_holdem_hand_player_statistics.flg_blind_s, 1, 0])

[kingkong32]

Thanks, works very well:-)