AutoBet Theorem

[js2002]

Hi,

the theory says that you should autobet every flop that is HU and unraised. (u need less then 33% Foldquity)

Any Errors?

sum(if[
holdem_hand_summary.cnt_players_f=2 AND
NOT(holdem_hand_player_statistics.flg_p_face_raise) AND
holdem_hand_player_statistics.cnt_p_raise = 0 AND
holdem_hand_player_statistics.flg_f_bet
, 1, 0])

sum(if[
holdem_hand_summary.cnt_players_f=2 AND
NOT(holdem_hand_player_statistics.flg_p_face_raise) AND
holdem_hand_player_statistics.cnt_p_raise = 0 AND
holdem_hand_player_detail.flg_f_open_opp
, 1, 0])

[WhiteRider]

That looks fine - it will count how often a player bets the flop when the pot was unraised preflop, out of the times they had the chance to.

[js2002]

finally I made one for "in position".

1. Now I want the oop version:
The easiest way to get the "out of posi" version would be to discount the "IP"s from "all" situation, I guess,
f.e.
(cnt_autobet_all - cnt_autobet_ip)/(cnt_autobet_all_opps - cnt_autobet_ip_opps) == autobet oop %age
Would you agree to do it like that? Or should I rather built the columns with "NOT(has_posi...) ...

2. Now I want the reaction to autobets:
js2002_cnt_f_autobet_HU_UR_def_action_fold
sum(if[
holdem_hand_summary.cnt_players_f=2 AND
NOT(holdem_hand_player_statistics.flg_p_face_raise) AND
holdem_hand_player_statistics.cnt_p_raise = 0 AND
holdem_hand_player_detail.amt_f_bet_facing > 0 AND
(lookup_actions_f.action SIMILAR TO '(F|XF)%')
, 1, 0])
________________
js2002_cnt_f_autobet_HU_UR_def_opp
sum(if[holdem_hand_summary.cnt_players_f=2 AND
NOT(holdem_hand_player_statistics.flg_p_face_raise) AND
holdem_hand_player_statistics.cnt_p_raise = 0 AND
holdem_hand_player_detail.amt_f_bet_facing > 0
, 1, 0])

Do you also think that this catches all situations?

ps at first glance I wanted to use "~face_bet AND fold" but then I noticed that a Line like "RF" would make this column "true", The term (lookup_actions_f.action SIMILAR TO '(F|XF)%') blocks this issue I hope.

[kraada]

I think that covers all situations, but I'm on my way out for the day and I'll take a look at it again for you tomorrow just to be sure when I have some more time.

[js2002]

garbage post...del*

[kraada]

Looking it over a bit more now it looks good to me. And just using the complement of the IP hands to get OOP values sounds like the easiest solution (and it'll keep housekeeping times a teensy bit quicker).

[js2002]

"did it done I know its good"

Hi kraada, jo it works, I got the complements and even the fold reactions... very usefull in low stakes and much more usefull when playing FL

[kraada]

Glad to hear it's working well for you :)

[preparac]

How exactly works the string
lookup_actions_f.action SIMILAR TO '(F|XF)%
Thanx for an explanation that a math-donk like me is able to understand (the official SQL-documentation is still some sort of chinese for me ...)
appreciate your help
p.

[js2002]

my hope and explanation is that is works like this:

SIMILAR TO is for regular expressions "(F|XF)%" is such a expression. fold followed by anything OR check fold followed by anything. % = anything and obsolete here I guess. (f.e. with C you should use the % if und want to allow that things happen after the call.)

@mods: plz ignore my post and explain the real truth ;)