WWSF as agressor and defender

[BigPaired]

Hello,

I'd like to know if there's a flag in PT4 that indicates whether a player was the aggressor or the defender preflop, so I can create a different WWSF for each scenario.

I would like to have something like (cnt_f_saw_won_aggresor / cnt_f_saw_aggresor) * 100 or (cnt_f_saw_won_defender / cnt_f_saw_defender) * 100 but i don't know how to construct the column definitions.

[Flag_Hippo]

There isn't a flag but you can test for the players final preflop action being a raise or a call. For example:

cnt_f_saw_aggressor

Code: Select all

sum(if[cash_hand_player_statistics.flg_f_saw and lookup_actions_p.action LIKE '%R', 1, 0])

cnt_f_saw_defender

Code: Select all

sum(if[cash_hand_player_statistics.flg_f_saw and cash_hand_player_statistics.flg_p_face_raise and lookup_actions_p.action LIKE '%C', 1, 0])

[BigPaired]

Thank you for your response.

One more thing: if I add up the hands that saw the flop as the aggressor and as the defender with your formulas, the total should be the same as the number obtained from the "cnt_f_saw column".

I have lost a 10% aprox. of hands that show flop in a 420K hands.

[Flag_Hippo]

cnt_f_saw will include hands where there was no preflop aggressor such as limped pots or bomb pots which will not be included in the above column definitions.