Stats

[500kg]

Hi!

I have couple of questions.

1. What is the difference between Raise F Bet and Raise Flop?
2. Stat Check Raise Flop counted in Raise F Bet and Raise Flop or he does with them is not connected?
3. How to display stat "Won at Showdown" with check-raise on flop?
4. How to display stat "Won at Showdown" with check-raise on turn?
5. How to display stat "Won at Showdown" with raise on flop, excluding check-raise?
6. How to display stat "Won at Showdown" with raise on turn, excluding check-raise?
7. How to displey stat "Raise" on flop and turn in position, excluding check-raise?

Thank you.

[WhiteRider]

1. Raise F Bet is specifically how often you raise when facing a bet. Raise Flop is how often you raise the flop regardless if you face a bet or a raise.

2. Check Raise Flop will count any time that you check and then raise on the flop.

For the rest you will need to build these as custom stats.
Have a look at how "W$SD % When Bet or Raise Flop" is built (for instance) and how "Check Raise Flop" is built, and if you combine the two you can build a new version, as described in the Tutorial: Custom Reports and Statistics.

Have a go at building one of the stats and if you get stuck or want to check what you've done please post back and we'll help you out.

[500kg]

2. Check Raise Flop will count any time that you check and then raise on the flop.

1. Is stat "Raise F Bet" includes "Check Raise Flop"?
2. Is stat "Raise Flop" includes "Check Raise Flop"?
3. In case when we won bank with check-raise on flop.

cnt_wtsd_when_f_check-raise

Expression:
sum( if[(holdem_hand_player_statistics.flg_f_check AND holdem_hand_player_statistics.cnt_f_raise > 0) and holdem_hand_player_statistics.flg_showdown, 1, 0])


cnt_wtsd_won_when_f_check-raise

Expression:
sum( if[ (holdem_hand_player_statistics.flg_f_check AND holdem_hand_player_statistics.cnt_f_raise > 0) and holdem_hand_player_statistics.flg_won_hand and holdem_hand_player_statistics.flg_showdown, 1, 0])


W$SD % When Check-Raise Flop

Value Expression:
(cnt_wtsd_won_when_f_check-raise / cnt_wtsd_when_f_check-raise) * 100

Is that correct?

[WhiteRider]

1. It won't include all check/raises - if you check and there is a bet and a raise that will be Check Raise Flop, but not Raise F Bet - but it does include check/raises when only facing a bet.

2. Yes - Raise Flop includes any time you raise the flop. A check/raise includes a raise so is counted.

3. That looks good to me!

[500kg]

but it does include check/raises when only facing a bet.

Didn't get it, for example?

And other stats:

1. In case when we won bank on showdown! With Check-Raise on turn


cnt_wtsd_when_t_check-raise

Expression:
sum( if[(holdem_hand_player_statistics.flg_t_check AND holdem_hand_player_statistics.cnt_t_raise > 0) and holdem_hand_player_statistics.flg_showdown, 1, 0])


cnt_wtsd_won_when_t_check-raise

Expression:
sum( if[ (holdem_hand_player_statistics.flg_t_check AND holdem_hand_player_statistics.cnt_t_raise > 0) and holdem_hand_player_statistics.flg_won_hand and holdem_hand_player_statistics.flg_showdown, 1, 0])


W$SD % When Check-Raise Turn
Value Expression:
(cnt_wtsd_won_when_t_check-raise / cnt_wtsd_when_t_check-raise) * 100

Is that correct?

[WhiteRider]

but it does include check/raises when only facing a bet.

Didn't get it, for example?

You check the flop, player A bets and player B raises. If you re-raise now that is a check raise and a raise, but not a Raise F Bet.

You check the flop, player A bets and B folds. If you re-raise now that is a check raise, a raise and a Raise F Bet.

That stat looks good too.

[500kg]

In case when we won bank with check-raise on flop.

NEW

W$SD % When Check-Raise Flop
(cnt_wtsd_won_when_f_check_raise / cnt_wtsd_when_f_check_raise) * 100

cnt_wtsd_won_when_f_check_raise
sum( if[ holdem_hand_player_statistics.flg_f_check_raise and holdem_hand_player_statistics.flg_won_hand and holdem_hand_player_statistics.flg_showdown, 1, 0])

cnt_wtsd_when_f_check_raise
sum( if[holdem_hand_player_statistics.flg_f_check_raise and holdem_hand_player_statistics.flg_showdown, 1, 0])

[WhiteRider]

Yes - I think you've got it! :)

[500kg]

In case when we won bank with "Raise F Bet" on flop.

W$SD % When Raise F Bet
(cnt_wtsd_won_when_raise_f_bet / cnt_wtsd_when_raise_f_bet) * 100

cnt_wtsd_won_when_raise_f_bet
sum(if[holdem_hand_player_detail.amt_f_bet_facing > 0 AND (lookup_actions_f.action SIMILAR TO '(R|XR)%') AND holdem_hand_player_statistics.flg_won_hand AND holdem_hand_player_statistics.flg_showdown, 1, 0])

cnt_wtsd_when_raise_f_bet
sum( if[holdem_hand_player_detail.amt_f_bet_facing > 0 and holdem_hand_player_statistics.flg_showdown, 1, 0])

Shows not correctly.

What not so?

[WhiteRider]

Your "actions" column looks good, but the "opportunities" column is missing the check for having made the raise. You need this:

cnt_wtsd_when_raise_f_bet
sum( if[holdem_hand_player_detail.amt_f_bet_facing > 0 AND (lookup_actions_f.action SIMILAR TO '(R|XR)%') and holdem_hand_player_statistics.flg_showdown, 1, 0])