Can't get 'fold to turn probe bet' working in HU

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Can't get 'fold to turn probe bet' working in HU

Postby hello776 » Tue Nov 22, 2011 8:35 pm

I added the stat 'fold to turn probe' but it just shows NA in the HUD.
This situation keeps happening which should trigger the stat, but for some reason it isn't. SB raised PF and I called in the BB. BB checks flop, SB checks flop. BB bets turn. Regardless of him calling/folding/raising to this turn bet the stat still shows NA.
This is for HU sng.

cnt_t_probe_def_action_fold

sum(if[tourney_holdem_hand_player_detail.amt_t_bet_facing > 0 and tourney_holdem_hand_player_statistics.flg_f_cbet_opp and not(tourney_holdem_hand_player_statistics.flg_f_cbet) and (tourney_holdem_hand_player_detail.val_t_bet_aggressor_pos > tourney_holdem_hand_player_statistics.position) and lookup_actions_t.action = 'F', 1, 0])

cnt_t_probe_def_opp

sum(if[tourney_holdem_hand_player_detail.amt_t_bet_facing > 0 and tourney_holdem_hand_player_statistics.flg_f_cbet_opp and not(tourney_holdem_hand_player_statistics.flg_f_cbet) and tourney_holdem_hand_player_detail.val_t_bet_aggressor_pos > tourney_holdem_hand_player_statistics.position, 1, 0])

(cnt_t_probe_def_action_fold / cnt_t_probe_def_opp) * 100
hello776
 
Posts: 7
Joined: Tue May 27, 2008 9:46 am

Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests