PokerTracker

Hello, I'm doing statistics for the player's fold versus bet turn after limped pot and XX flop, that is:

Player
preflop: X
flop: X
turn: XF

the statistic was based on: 'Fold to T Bet'

in statistics I am considering:
HU
player at BB
effective stack preflop 10 to 100bb
turn bet size less than or equal to 75%


expression: (cnt_t_bet_def_action_fold_10more / cnt_t_bet_def_opp_10more) * 100

cnt_t_bet_def_action_fold_10more
sum(if[char_length(tourney_hand_summary.str_aggressors_p) = 1 AND
tourney_hand_summary.cnt_players = 2 and
(tourney_hand_player_statistics.val_t_bet_facing_pct <= 43) and
((tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10 AND 100) AND
tourney_hand_player_statistics.amt_t_bet_facing > 0 AND (lookup_actions_t.action SIMILAR TO '(F|XF)%'), 1, 0])

cnt_t_bet_def_opp_10more
sum(if[char_length(tourney_hand_summary.str_aggressors_p) = 1 AND
tourney_hand_summary.cnt_players = 2 and
(tourney_hand_player_statistics.val_t_bet_facing_pct <=43) and
((tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 10 AND 100) AND
tourney_hand_player_statistics.amt_t_bet_facing > 0, 1, 0])

Is this statistic ok according to the information I provided?

DANNI BASTOS wrote:flop: X

You need to specify the player checked on the flop and made no other flop actions:

Code: Select all

lookup_actions_f.action = 'X'

DANNI BASTOS wrote:player at BB

You haven't tested for the players position:

Code: Select all

tourney_hand_player_statistics.position = 8

[quote="Flag_Hippo"]lookup_actions_f.action = 'X'[/code]

I'm adding it but the message appears: 'The statement in not valid SQL.'

DANNI BASTOS wrote:I'm adding it but the message appears: 'The statement in not valid SQL.'

You will need to copy/paste the entire expression you are using in this thread so I can see what's wrong.

worked, thank you :)