Float flop + barrel turn

[mxga917]

When I test the stat It looks vs the filter they are off but the filter seems correct and has more occurrences for each the denom and numerator. There is some unnecessary stuff in my code you'll see because I was trying to be extremely thorough. It's off in both the numerator and denominator expression.

cnt_f_float_barrel_t

sum(if[ (lookup_actions_p.action LIKE '%C') AND cash_hand_player_statistics.flg_p_face_raise AND cash_hand_player_statistics.flg_f_open_opp AND cash_hand_player_statistics.flg_f_bet AND NOT
cash_hand_player_statistics.flg_f_face_raise AND
cash_hand_player_statistics.flg_t_open AND
char_length(cash_hand_summary.str_aggressors_p) = 2 AND ((cash_hand_summary.cnt_players > 2 AND substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int > cash_hand_player_statistics.position) OR (cash_hand_summary.cnt_players = 2 AND cash_hand_player_statistics.flg_f_has_position)), 1, 0])

cnt_f_float_barrel_t_opp

sum(if[ (lookup_actions_p.action LIKE '%C') AND cash_hand_player_statistics.flg_p_face_raise AND cash_hand_player_statistics.flg_f_open_opp AND cash_hand_player_statistics.flg_f_bet AND NOT
cash_hand_player_statistics.flg_f_face_raise AND
cash_hand_player_statistics.flg_t_open_opp AND
char_length(cash_hand_summary.str_aggressors_p) = 2 AND ((cash_hand_summary.cnt_players > 2 AND substring(cash_hand_summary.str_aggressors_p from 2 for 1)::int > cash_hand_player_statistics.position) OR (cash_hand_summary.cnt_players = 2 AND cash_hand_player_statistics.flg_f_has_position)), 1, 0])

anybody have a hint ?

[potamito]

I got these from the warehouse it isolates these situations...

This is a package of multiple stats that track Continuation Floats, or "CFloats" on the turn and river in both 2Bet and 3Bet+ pots. In the 2Bet pot stat the player in question calls a 2Bet with position, bets the Flop when checked to (Float Flop), and is called. The stat will record a Turn Continuation Float if he bets the turn when checked to again, and a River "CFloat" if his Turn CFloat is called and he is checked to on the river. In the 3Bet pot version of these stats the player in question raised preflop and gets 3Bet by a player out of position on him (most likely a blind), and then calls in position. It's a turn CFloat if after betting the flop when checked to and getting called he then bets the turn when checked to. Assuming his Turn CFloat is called and he is checked to, he can then CFloat the river. NOTE: This package was updated on December 1st, 2014 to update the Continuation Float Turn (2Bet Pot) stat, existing users are advised to redownload this stat package and replace the prior installation for improved results.

Hope that´s what you´re looking for, cheers.

PS: Oh and welcome to the comunity¡!¡

[mxga917]

thanks, happy to be here!

I imported the stat and it's returning the same numbers my stat is reporting but i think they both aren't reporting accurate numbers, and the code is essentially identical to mine so that makes sense. Have you tried running filters for that scenario to see if it matches up and if so what filters did you use?

[potamito]

emmm not really...can you type an example for the exact situation you would like to isolate?

[mxga917]

utg opens pf, hero on the btn calls, blinds fold. flop utg checks, hero bets, utg calls. turn utg checks and hero bets again.

[potamito]

that stat covers that particular situation for both 3bet and non-3bet pots...

In the 2Bet pot stat the player in question calls a 2Bet with position, bets the Flop when checked to (Float Flop), and is called. The stat will record a Turn Continuation Float if he bets the turn when checked to again

It also cover other situation, perhaps if you just want it for what you´re requesting you can take out the pieces of code in the expression that doesnt work for ya.