fold to river bet after calling turn probe bet

[minotaurs]

hi i want to make a stat that shows how often player folded to river bet in position after called probe bet on turn

so i made 2 stats:

1. face_probe_river_after_call_turn

sum(if[tourney_hand_player_statistics.amt_r_bet_facing > 0 and
tourney_hand_player_statistics.flg_f_cbet_opp and not
(tourney_hand_player_statistics.flg_f_cbet) and
(tourney_hand_player_statistics.flg_t_open_opp) and
lookup_actions_t.action LIKE 'C%' and
(tourney_hand_player_statistics.flg_r_open_opp), 1, 0])

2.fold_2_probe_river_after_call_turn

sum(if[tourney_hand_player_statistics.amt_r_bet_facing > 0
and tourney_hand_player_statistics.flg_f_cbet_opp and not
(tourney_hand_player_statistics.flg_f_cbet) and
(tourney_hand_player_statistics.flg_t_open_opp) and
lookup_actions_t.action LIKE 'C%' and
(tourney_hand_player_statistics.flg_r_open_opp) and
lookup_actions_r.action = 'F', 1, 0])

than of course
((fold_2_probe_river_after_call_turn)/(face_probe_river_after_call_turn))*100

but when this happened the stat did show nothing at all only "-" like it never happened
Can u help me see the problem here?

[kraada]

You want not(cash_hand_player_statistics.flg_t_open_opp) - if you have an open opp your actions string can never begin with C, so what you have now will never return any data. Changing that should be sufficient to get it doing what you want though (it looks like you just lost that big from the existing turn probe defense columns).

[minotaurs]

what can i use in this place "(tourney_hand_player_statistics.flg_t_open_opp)" what would tell that player in position faced probe bet on turn?,
than i can use almost same line on river 2 and it would work right

[kraada]

Take a look at the built in columns cnt_t_probe_def_opp and cnt_r_probe_def_opp - they are for when a player faced a probe bet. You have to be in position on the probing player in order to face a probe bet.

[minotaurs]

but im not in position and i want to know how often he will fold on river after calling my turn bet, when he doesnt c bet. What line could i use there

[kraada]

Start with looking at calling a turn probe from the column I gave you - then add in that he faced a river bet (and for the times column, that he folded to it).

[minotaurs]

ok maybe i fixed that river probe bet (gonna check tormow) but im also interested why this "Fold to F Float Bet" didnt work

here the situation : 2 players
im in position and other dude is BB

im raised from SB and he 3 bets
than on flop he didnt c bet but i bet the flop..

after the hand it didnt display anything, not 0 not 100 just "-"
and that is original stat not made by me.

[BillGatesIII]

ok maybe i fixed that river probe bet (gonna check tormow) but im also interested why this "Fold to F Float Bet" didnt work

here the situation : 2 players
im in position and other dude is BB

im raised from SB and he 3 bets
than on flop he didnt c bet but i bet the flop..

after the hand it didnt display anything, not 0 not 100 just "-"
and that is original stat not made by me.

You can't be in position in the small blind. Or maybe I do not understand you correctly. This is what the description of Fold to F Float Bet says:

Number of times a player faced a raise and folded given that they bet when they had the opportunity to bet the flop after calling exactly one preflop raise with position on the preflop raiser.

[minotaurs]

ok maybe i fixed that river probe bet (gonna check tormow) but im also interested why this "Fold to F Float Bet" didnt work

here the situation : 2 players
im in position and other dude is BB

im raised from SB and he 3 bets
than on flop he didnt c bet but i bet the flop..

after the hand it didnt display anything, not 0 not 100 just "-"
and that is original stat not made by me.

You can't be in position in the small blind. Or maybe I do not understand you correctly. This is what the description of Fold to F Float Bet says:

Number of times a player faced a raise and folded given that they bet when they had the opportunity to bet the flop after calling exactly one preflop raise with position on the preflop raiser.

when u playing heads up u are in position when u sb (button) coz on flop 1st reacts who is after button and it means u in position

[minotaurs]

so now that stat is working fine (fold % on river after calling turn probe bet) but why i cant color code it?