[validation request] Fold to F Float 3betp

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

[validation request] Fold to F Float 3betp

Postby js2002 » Mon Jun 18, 2012 6:36 am

cnt_f_float_def_opp_action_fold_3betp
sum(if[lookup_actions_p.action LIKE '%R' and cash_hand_player_statistics.flg_f_open_opp AND cash_hand_player_statistics.amt_f_bet_facing > 0 AND substring(lookup_actions_f.action from 1 for 2) = 'XF' AND (cash_hand_player_statistics.flg_p_3bet or cash_hand_player_statistics.flg_p_4bet), 1, 0])
------------------------------
cnt_f_float_def_opp_3betp
sum(if[lookup_actions_p.action LIKE '%R' AND cash_hand_player_statistics.flg_f_open_opp AND cash_hand_player_statistics.flg_f_check AND cash_hand_player_statistics.amt_f_bet_facing > 0 AND (cash_hand_player_statistics.flg_p_3bet or cash_hand_player_statistics.flg_p_4bet), 1, 0])

1. looks correct?
2. for the 2 other reaction: call and raise, can I simple build them like that:

a) cnt_f_float_def_opp_action_call_3betp
sum(if[lookup_actions_p.action LIKE '%R' and cash_hand_player_statistics.flg_f_open_opp AND cash_hand_player_statistics.amt_f_bet_facing > 0 AND substring(lookup_actions_f.action from 1 for 2) = 'XC%' AND (cash_hand_player_statistics.flg_p_3bet or cash_hand_player_statistics.flg_p_4bet), 1, 0])

I guess there is a problem with XC% string right? Or is it ok/like u would do it?
I saw u use "XC" only, why?
With "XC" the line XCC for example wont count!


b) cnt_f_float_def_opp_action_raise_3betp
sum(if[lookup_actions_p.action LIKE '%R' and cash_hand_player_statistics.flg_f_open_opp AND cash_hand_player_statistics.amt_f_bet_facing > 0 AND substring(lookup_actions_f.action from 1 for 2) = 'XR%' AND (cash_hand_player_statistics.flg_p_3bet or cash_hand_player_statistics.flg_p_4bet), 1, 0])

same here, ok?
Please react on 1,2a and 2b.
js2002
 
Posts: 1501
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: [validation request] Fold to F Float 3betp

Postby kraada » Mon Jun 18, 2012 8:45 am

(1) Yes.

(2) (a) Yes, that will work. There will only be a third action in very unusual multi-way pots (You check, someone bets, you call, someone else behind you raises, or you check, someone bets, someone raises, you call, someone else 3bets). You will find these to be extremely rare no matter what game is being played.

(b) Yes, this will work as well. Regarding the %, the same considerations are true here, though in theory it is probably a bit more common to get shoved on and have a chance to call (but still if the pot is 4bet and you check/raise it's unlikely anybody has anything left behind).
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: [validation request] Fold to F Float 3betp

Postby WhiteRider » Tue Jun 19, 2012 3:37 am

This:

substring(lookup_actions_f.action from 1 for 2) = 'XC%'

..will not work correctly.

substring( str from 1 for 2 ) will return a 2-character string, and the string you're comparing it to has 3 characters so they will never match.
You should use this:

substring(lookup_actions_f.action from 1 for 2) = 'XC'

Spoiler: show
substring(lookup_actions_f.action from 1 for 2) LIKE 'XC%' would work, but is unnecessary. The point of substring is to get the exact characters you're interested in.
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: [validation request] Fold to F Float 3betp

Postby js2002 » Tue Jun 19, 2012 3:44 am

I did.
for the future: whats the exp to catch all CRCRCR.... so CR% ?
js2002
 
Posts: 1501
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: [validation request] Fold to F Float 3betp

Postby kraada » Tue Jun 19, 2012 8:46 am

Substring gets exactly two characters in this case. If you take the substring from 1 for 2 of "CRCRCRCR" you still get just "CR".

That said if you used LIKE instead of = it would still match your pattern the % can mean 0 or more, but only when used with LIKE, not with =.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: [validation request] Fold to F Float 3betp

Postby js2002 » Tue Jun 19, 2012 9:45 am

I see, Iforget the syntax all the time after pauses. thx
js2002
 
Posts: 1501
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: No registered users and 17 guests

cron
highfalutin