Custom Stat

[hanetus]

Hello!

About turn aggression:
cnt_t_bet_raise_hands / cnt_t_saw * 100

a) Can you please confirm that this formula is about right? I try to count one action per street, not for example 2 calls or 2 raises and I would like Bet-folds and raise folds counted as one aggressive move.
b) Does it count check-raises and bet-raises and multiple raises as one aggressive move per street? If not, how to make it to?
c) Does it count bet-folds and raise-folds as one aggressive move per street?
d) How to count out preflop allins and flop allins from cnt_t_saw? How to count "no action, but saw the turn"?

Thanks!

[kraada]

Yes that should work This will give you the percentage of turns in which the player took an aggressive action by either betting or raising somewhere. Check/raises will count as one aggressive action here, as will bet/folds and raise/folds.

For (d) it's probably easiest to just create a custom column instead of using cnt_t_saw. You could create it as follows:

cnt_t_had_action: sum(if[lookup_actions_t.action LIKE '_%', 1, 0])

That counts one for every turn in which you actually made some action - and you can use that for your denominator instead.

[WhiteRider]

Just for reference: you should use brackets, like this:

(cnt_t_bet_raise_hands / cnt_t_saw) * 100