Help with colums

[LillGus08]

Trying to make a few custom stats. Made a few but got stuck on these.

Checkfold River after Probe turn in HU
cnt_t_probe_r_checkfold

sum(if[cash_hand_summary.cnt_players_f = 2 and
cash_hand_player_statistics.amt_r_bet_facing > 0 AND
(lookup_actions_r.action SIMILAR TO '(F|XF)%') AND
cash_hand_player_statistics.flg_r_check and
cash_hand_player_statistics.flg_t_bet AND
lookup_actions_f.action LIKE 'X' AND
lookup_actions_p.action NOT LIKE '%R' AND
cash_hand_player_statistics.flg_p_face_raise AND
(cash_hand_player_statistics.val_p_raise_aggressor_pos < cash_hand_player_statistics.position OR
(cash_hand_summary.cnt_players = 2 and cash_hand_player_statistics.flg_blind_b)), 1, 0])

cnt_t_probe_r_open_opp

sum(if[cash_hand_summary.cnt_players_f = 2 and
cash_hand_player_statistics.flg_r_open_opp and
cash_hand_player_statistics.flg_t_bet AND
lookup_actions_f.action LIKE 'X' AND
lookup_actions_p.action NOT LIKE '%R' AND
cash_hand_player_statistics.flg_p_face_raise AND
(cash_hand_player_statistics.val_p_raise_aggressor_pos < cash_hand_player_statistics.position OR
(cash_hand_summary.cnt_players = 2 and cash_hand_player_statistics.flg_blind_b)), 1, 0])

I have this and get "Expression is valid" on both.
But when I make a Stats about it with:
cnt_t_probe_r_checkfold / cnt_t_probe_r_open_opp) * 100
I get "Invalid Value Expression"
What am I doing wrong?

Checkfold to float Turn after checkcall to float flop as 3better in HU
I know this is wrong but how should I make it?

cnt_f_float_XC_t_probe_CF_3bet

sum(if[(cash_hand_player_statistics.flg_p_3bet OR
cash_hand_player_statistics.flg_p_4bet) AND
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_t_open_opp AND
cash_hand_player_statistics.amt_t_bet_facing > 0 AND
substring(lookup_actions_t.action from 1 for 2) = 'XF', 1, 0])

cnt_f_float_XC_t_probe_opp

sum(if[(cash_hand_player_statistics.flg_p_3bet OR
cash_hand_player_statistics.flg_p_4bet) AND
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 AND
cash_hand_player_statistics.flg_t_open_opp AND
cash_hand_player_statistics.flg_t_check AND
cash_hand_player_statistics.amt_t_bet_facing > 0, 1, 0])

Stats:
(cnt_f_float_XC_t_probe_CF_3bet / cnt_f_float_XC_t_probe_opp) * 100

WSD when cbet flop, check turn, bet river HU both for non3bet and 3bet
This one I really dont know how to make.
Can I do something just like this?

cnt_f_cbet_t_check_r_bet_wtsd_won

sum(if[cash_hand_player_statistics.flg_f_cbet AND
cash_hand_player_statistics.flg_f_cbet AND
cash_hand_player_statistics.flg_t_check AND
cash_hand_player_statistics.flg_r_bet AND
cash_hand_player_statistics.flg_showdown AND
cash_hand_player_statistics.flg_won_hand, 1, 0])

cnt_f_cbet_t_check_r_bet_wtsd

sum(if[cash_hand_player_statistics.flg_f_cbet AND
cash_hand_player_statistics.flg_f_cbet AND
cash_hand_player_statistics.flg_t_check AND
cash_hand_player_statistics.flg_r_bet AND
cash_hand_player_statistics.flg_showdown, 1, 0])

And for 3bet pots
cnt_f_cbet_t_check_r_bet_wtsd_won_3bet

sum(if[(cash_hand_player_statistics.flg_p_3bet OR cash_hand_player_statistics.flg_p_4bet) AND
cash_hand_player_statistics.flg_f_cbet AND
cash_hand_player_statistics.flg_f_cbet AND
cash_hand_player_statistics.flg_t_check AND
cash_hand_player_statistics.flg_r_bet AND
cash_hand_player_statistics.flg_showdown AND
cash_hand_player_statistics.flg_won_hand, 1, 0])

cnt_f_cbet_t_check_r_bet_wtsd_3bet

sum(if[(cash_hand_player_statistics.flg_p_3bet OR cash_hand_player_statistics.flg_p_4bet) AND
cash_hand_player_statistics.flg_f_cbet AND
cash_hand_player_statistics.flg_f_cbet AND
cash_hand_player_statistics.flg_t_check AND
cash_hand_player_statistics.flg_r_bet AND
cash_hand_player_statistics.flg_showdown, 1, 0])

Stats:
((cnt_f_cbet_t_check_r_bet_wtsd_won - cnt_f_cbet_t_check_r_bet_wtsd_won_3bet) / (cnt_f_cbet_t_check_r_bet_wtsd - cnt_f_cbet_t_check_r_bet_wtsd_3bet)) * 100

and for 3bet pots:
(cnt_f_cbet_t_check_r_bet_wtsd_won_3bet / cnt_f_cbet_t_check_r_bet_wtsd_3bet) * 100

[LillGus08]

Problem solved with the first one.
Just wondering if it the statistic does what I want i to?
Think I miss something there on:

sum(if[cash_hand_summary.cnt_players_f = 2 and
cash_hand_player_statistics.flg_r_open_opp and
cash_hand_player_statistics.flg_t_bet AND
lookup_actions_f.action LIKE 'X' AND
lookup_actions_p.action NOT LIKE '%R' AND
cash_hand_player_statistics.flg_p_face_raise AND
(cash_hand_player_statistics.val_p_raise_aggressor_pos < cash_hand_player_statistics.position OR
(cash_hand_summary.cnt_players = 2 and cash_hand_player_statistics.flg_blind_b)), 1, 0])

Should I have something here about that he folds or those the other column make that?

[Flag_Hippo]

Checkfold River after Probe turn in HU

When you say HU is this for heads up hands only or hands that are only heads up on the flop? I can see you are using cash_hand_summary.cnt_players_f = 2 but you have removed cash_hand_summary.cnt_players >= 3 from the built-in turn probe expression which is used to establish the relative position of the preflop aggressor and caller when more than two players are dealt into the hand. Whether this is for heads up hands, 6max e.t.c. you should just use the entire default expression for probing the turn.

Should I have something here about that he folds or those the other column make that?

You are counting the number of folds in your cnt_t_probe_r_checkfold column so you do not need to account for that in the opportunities column. The only thing you might want to consider is hands where the preflop aggressor raises the turn probe bet - if that happens and the hand reaches the river then those hands will be counted too so if you do not want that you will need to specify the player turn action as just being a bet.

[LillGus08]

In HU is for Headsup games only.

Wonder if there is something wrong with the stat "Checkfold River after Probe turn in HU"
When I run it in reports I get really low % for every player. Around 6-13%. That feels really low.
Is the columns written wrong?

HU = True
3bet = False
Donk flop = False
IP Preflop Agg Checks = True
OOP player bets = True
Preflop agg calls = True
OOP checks = True
Preflop agg bets = True
OOP folds = True

[LillGus08]

When I run it in reports I get really low % for every player. Around 6-13%. That feels really low.
Is the columns written wrong?

Played a short session just to check out the stat closer with hands.
Got the stat to show 0 (0/2)
Put the filters on Saw river and then checked hands from the position BB for that player.
No hand played out that it should give a opportunity.
My thought is that when the player probe turn and then also bet river it shows up as an opp. and give that he didnt checkfold river.

[Flag_Hippo]

In HU is for Headsup games only.

You removed cash_hand_summary.cnt_players >= 3 from the built-in probe expression but not the second part of that code which establishes the relative position of players for when 3 or more players are dealt in:

Code: Select all

cash_hand_player_statistics.val_p_raise_aggressor_pos < cash_hand_player_statistics.position

This tests for the player position being higher than the preflop aggressor and since you have removed the number of players being greater than 3 requirement you will get incorrect opportunities recorded for your stat. This is because position 9 (SB) is greater than position 8 (BB) and obviously your stat needs to be from only the BB perspective as they are the player who is going to be OOP postflop.

3bet = False

There is nothing in your expression for that so if you want to specify this stat for 2bet pots you can use:

Code: Select all

char_length(cash_hand_summary.str_aggressors_p) = 2

OOP player bets = True, Preflop agg calls = True

As I mentioned above you are not excluding hands where the turn bet gets raised so if you do not want that you will need to specify the player turn action as just being a bet.

My thought is that when the player probe turn and then also bet river it shows up as an opp. and give that he didnt checkfold river.

That is not how the opportunity should be counted. If the OOP player bets the river then they never had the opportunity to check fold - they only have the opportunity to check fold when they check the river AND the IP player bets. I have made the necessary changes to your columns below and if you need any further assistance with your other stats just let us know.

Checkfold River after Probe turn in HU

cnt_t_probe_r_checkfold

Code: Select all

sum(if[char_length(cash_hand_summary.str_aggressors_p) = 2 AND lookup_actions_r.action LIKE 'XF' AND lookup_actions_t.action LIKE 'B' AND lookup_actions_f.action LIKE 'X' AND lookup_actions_p.action NOT LIKE '%R' AND cash_hand_player_statistics.flg_p_face_raise AND cash_hand_summary.cnt_players = 2 AND cash_hand_player_statistics.flg_blind_b, 1, 0])

cnt_t_probe_r_checkfold_opp

Code: Select all

sum(if[char_length(cash_hand_summary.str_aggressors_p) = 2 AND lookup_actions_r.action LIKE 'X%' AND cash_hand_player_statistics.amt_r_bet_facing > 0 AND lookup_actions_t.action LIKE 'B' AND lookup_actions_f.action LIKE 'X' AND lookup_actions_p.action NOT LIKE '%R' AND cash_hand_player_statistics.flg_p_face_raise AND cash_hand_summary.cnt_players = 2 AND cash_hand_player_statistics.flg_blind_b, 1, 0])

[LillGus08]

Checkfold River after Probe turn in HU

cnt_t_probe_r_checkfold

Code: Select all

sum(if[char_length(cash_hand_summary.str_aggressors_p) = 2 AND lookup_actions_r.action LIKE 'XF' AND lookup_actions_t.action LIKE 'B' AND lookup_actions_f.action LIKE 'X' AND lookup_actions_p.action NOT LIKE '%R' AND cash_hand_player_statistics.flg_p_face_raise AND cash_hand_summary.cnt_players = 2 AND cash_hand_player_statistics.flg_blind_b), 1, 0])

cnt_t_probe_r_checkfold_opp

Code: Select all

sum(if[char_length(cash_hand_summary.str_aggressors_p) = 2 AND lookup_actions_r.action LIKE 'X%' AND cash_hand_player_statistics.amt_r_bet_facing > 0 AND lookup_actions_t.action LIKE 'B' AND lookup_actions_f.action LIKE 'X' AND lookup_actions_p.action NOT LIKE '%R' AND cash_hand_player_statistics.flg_p_face_raise AND cash_hand_summary.cnt_players = 2 AND cash_hand_player_statistics.flg_blind_b), 1, 0])

When I put this in I get
"The statement is not valid SQL"

[Flag_Hippo]

Apologies - I left an erroneous bracket after cash_hand_player_statistics.flg_blind_b) so if you remove that the code will validate. I've also edited the original post to reflect this change.