Some heads up stats I don't know how to make

[jaffa]

I want to create the following stats to add to my heads up hud, was wondering how to do it:

I downloaded the delayed turn c-bet stat, but I would like to add...

fold to delayed turn c-bet

bet river after delayed turn c-bet was called

fold to river bet after calling delayed turn c-bet

bet river after turn probe bet was called

fold to river bet after calling probe bet on turn

I don't really understand the code for each stat so I don't know how to do it

[jaffa]

anyone? the trouble i'm having is the code for the columns

the delayed c-bet stat i downloaded was made from the columns cnt_t_delayed_cbet "sum(if[cash_hand_player_statistics.flg_t_bet AND cash_hand_player_statistics.flg_f_cbet_opp AND lookup_actions_f.action='X', 1, 0])"
and cnt_t_delayed_cbet_opp "sum(if[cash_hand_player_statistics.flg_t_open_opp AND cash_hand_player_statistics.flg_f_cbet_opp AND lookup_actions_f.action='X', 1, 0])"

so assuming these are correct I had a go at making the stat for the number of times you continued to bet the river when you made a delayed c-bet on the turn that was called:

not sure if this is correct:

"sum(if[cash_hand_player_statistics.flg_t_bet AND cash_hand_player_statistics.flg_f_cbet_opp AND cash_hand_player_statistics.flg_r_bet AND lookup_actions_t.action='c' AND lookup_actions_f.action='X', 1, 0])"

and

"sum(if[cash_hand_player_statistics.flg_t_bet AND cash_hand_player_statistics.flg_f_cbet_opp AND cash_hand_player_statistics.flg_r_open_opp AND lookup_actions_t.action='c' AND lookup_actions_f.action='X', 1, 0])" for the opportunities

I had a go at a similar stat where you make a turn probe bet and want to know what % player continues to bet the river. I can't seem to get this one to work. I started off with the cnt_t_probe column and added these lines to the if part of the code:
"AND cash_hand_player_statistics.flg_r_bet AND lookup_actions_t.action='c' " and these lines to make the opportunities column "AND cash_hand_player_statistics.flg_r_open_opp AND lookup_actions_t.action='c' "

I don't really understand why this won't produce a stat in my hud (it says the expressions are valid, but it produces a - in my hud)

[kraada]

Sorry, I'm not certain how you didn't end up getting a response.

You want lookup_actions_t.action='B' - the one action taken is bet, not call (call is 'C'). Otherwise your columns should work.

[jaffa]

They still won't work. I'm not sure why.

Probe bet turn continued to bet river when called:

sum(if[cash_hand_player_statistics.flg_t_bet AND lookup_actions_t.action='b' AND cash_hand_player_statistics.flg_r_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])

sum(if[cash_hand_player_statistics.flg_t_bet AND lookup_actions_t.action='b' AND cash_hand_player_statistics.flg_r_open_opp 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])

delayed c-bet turn, continued to bet river when called:

sum(if[cash_hand_player_statistics.flg_t_bet AND cash_hand_player_statistics.flg_f_cbet_opp AND cash_hand_player_statistics.flg_r_bet AND lookup_actions_t.action='B' AND lookup_actions_f.action='X', 1, 0])

sum(if[cash_hand_player_statistics.flg_t_bet AND cash_hand_player_statistics.flg_f_cbet_opp AND cash_hand_player_statistics.flg_r_open_opp AND lookup_actions_t.action='B' AND lookup_actions_f.action='X', 1, 0])


I assume lookup_actions applies to hero then? how does it distinguish a bet from the big blind to a check from the bb and the btn betting? or to a situation where someone bets, does that include the times you bet and get raised? some of the default stats have % signs in them and a LIKE command as well which I don't understand either?

[pasita]

I don't really understand why this won't produce a stat in my hud (it says the expressions are valid, but it produces a - in my hud)

Is this still the problem? It'll show a - if there are no opportunities (i.e. PT4 would have to try and divide with 0).
Try putting the stat in an "All players report" and see if it shows any actual numbers there... seems to work for me.

[jaffa]

I don't really understand why this won't produce a stat in my hud (it says the expressions are valid, but it produces a - in my hud)

Is this still the problem? It'll show a - if there are no opportunities (i.e. PT4 would have to try and divide with 0).
Try putting the stat in an "All players report" and see if it shows any actual numbers there... seems to work for me.

Bet river after delayed turn c-bet seems to be working, it was just being temperamental earlier for some reason i think

Bet river after turn probe isn't however, and it also comes up with a "-" in the all players reports

[pasita]

Yeah it was the delcontbet one that I tried and found working.

In the probe stat, I guess this
lookup_actions_t.action='b'

should be
lookup_actions_t.action='B'

(both the count and opp columns).

[kraada]

Yes, strings are case sensitive and we use B for bet, not b.

[jaffa]

this solved the problem, thanks

[Finnisher]

Do you have the other stats too?

Fold to delayed cbet
Fold to river after calling delcbet
Fold to river bet after calling probe bet on turn

Thanks