Fold to Delay River Cbet

[poochie]

So im trying to create this specific statistic: (Fold to Delay River Cbet)

This is the scenario explained.
Flop Hero checks) villain does not Cbet,
Turn: (Hero checks) villain does not delay Cbet,
River: (Hero checks) villain delay Cbets river and Hero folds.

I did find the Fold to Delay Turn Cbet stat in the Warehouse, but unfortunately no River variant. I tried to reproduce it from another thread, but unfortunately my implementation gives me wrong result.

Would be great if someone could help me getting this done.


(To analyze the turn variant search for "Fold to Delayed Turn CBet" in the stat Warehouse)

[Flag_Hippo]

I tried to reproduce it from another thread, but unfortunately my implementation gives me wrong result.

Please post a link to the thread you mentioned and the columns you have created so far so I can take a look.

[poochie]

Here you go:

https://pt4.pokertracker.com/forums/viewtopic.php?f=58&t=51507

I created the same columns mentioned in the thread.
It gave me plenty of wrong hands (for example: cbet, check, bet hands)...

[Flag_Hippo]

I created the same columns mentioned in the thread.
It gave me plenty of wrong hands (for example: cbet, check, bet hands)...

That is how the OP in that thread is defining a delayed river cbet (cbet flop, check turn, bet river). For how you want the stat you can replace this

Code: Select all

cash_hand_player_statistics.enum_f_cbet_action='C'

with this

Code: Select all

lookup_actions_f.action = 'X'

and then test separately for villain being the preflop caller.

[poochie]

I did manage to make it work thanks!
But i also wanted to let you know that your custom stat creation is kind of messed up. It seems it does have quite some encoding problems. I only was able to get valid sql syntax when copy text from the browser (for example the ' character). Also after saving a correct syntax column and trying to reediting it, suddenly it gave me a syntax error again, even when not making any changes. Just wanted to let you know these problem...

[Flag_Hippo]

Are you on a Mac? We are aware of an issue in the Mac version of PokerTracker v4.14.22 which causes single quotes in custom stats and columns where if you type a single quote character it is auto replaced with a 'smart quote', which isn't a valid character for SQL queries. We are looking into a fix to avoid the problem, but in the meantime you can work around the issue by turning off smart quotes in OSX keyboard preferences.

1. Open System Preferences.
2. Select the Keyboard preference pane.
3. Select the Text tab in the Keyboard preferences.
4. Uncheck Use smart quotes and dashes.

Also if you open a Support Ticket we can let you know when the fix is available.

[poochie]

Yes, thanks for that info.
How about the other thing i mentioned: after saving a correct column syntax, and reopening the same column , suddenly an syntax error is thrown.

[Flag_Hippo]

If you re-open the custom stats window and view the column again then it auto-updates to smart quotes - does that still happen after using the workaround I suggested? Also please open a Support Ticket so we can let you know when the fix is available.