check/fold & check/raise when RFI

[wusaa]

.
can you help me to build a custom stat based on the standard Check/Fold & Check/Raise stats.
I want to filter these stats for situation when the player has raised first in (rfi), or is preflop aggressor.
(no limped pots and no pots where he is not preflop aggressor)


Is it possible to build it.
Thanks

[WhiteRider]

I assume this is for the flop?

To check for the player raising first in you can use: holdem_hand_player_statistics.flg_p_first_raise
To check for being the preflop aggressor (specifically, the last PF action being a raise) you can use: lookup_actions_p.action LIKE '%R'
However - if you only want hands where the player was the preflop aggressor you only need the second part. The above "action" string check says that the last action was to raise.

So you could make a new version of the stat that you're interested in and include that in the expressions. The Tutorial: Custom Reports and Statistics explains how to make a new version of a stat.

[wusaa]

Goal is: check/fold & check/raise stats when raised first in preflop for Flop / Turn / River.

But I do not have the experience to customize the standard stats with the column "holdem_hand_player_statistics.flg_p_first_raise"

[kraada]

check/fold flop after RFI:

cnt_p_rfi_f_xf: sum( if[holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_open_opp AND lookup_actions_f.action = 'XF', 1, 0])

cnt_p_rfi_f_x_face_action: sum( if[holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_open_opp AND holdem_hand_player_statistics.flg_f_check, 1, 0])

Create those two columns. Put the former over the latter and multiply by 100 to get your stat. For check/raise, use the same second column and use the following first column:

cnt_p_rfi_f_xf: sum( if[holdem_hand_player_statistics.flg_p_first_raise AND holdem_hand_player_statistics.flg_p_open_opp AND lookup_actions_f.action LIKE 'XR%', 1, 0])

To make turn and river versions, change lookup_actions_f.action to lookup_actions_t.action and flg_f_check to flg_t_check. And change things to r similarly for the river.

[wusaa]

I'll try that.
thanks kraada, I appreciate!