Cbet size

[4StarGen]

I coded a stat to retrieve Ignition raked pots and now I'd like to find the cbet size, not any other bet, only the cbet size.
amt_f_bet has any bets in it, so how can I filter it out?

[Flag_Hippo]

There is no "amt_f_bet" in the database schema. Are you referring to "amt_bet_f"?

Code: Select all

cash_hand_player_statistics.amt_bet_f

amt_bet_f is not just bets - it includes calls and raises as well. It's the total amount the player wagered on the flop.

If you want just the players bet size on the flop then that will be:

Code: Select all

cash_hand_player_statistics.amt_f_bet_made

and flg_f_cbet will be true if that bet was a cbet:

Code: Select all

cash_hand_player_statistics.flg_f_cbet

[4StarGen]

Ty as always

[4StarGen]

Wait, I still have some issues...

Let's say I want to count any flop that has been made that are 50% of the pot, but I don't want to use cash_hand_summary.amt_pot_f instead I want to use mine (which takes into account rake on every street), how can I do it?
I cannot reference columns in columns so I'm pretty lost here

[Flag_Hippo]

You will need to use cash_hand_summary.amt_pot_f and do everything in a single column in a similar way as to what was posted here. The specifics of the adjustments needed to cash_hand_summary.amt_pot_f will depend on the rake structure of your poker site. For example if your poker site has a flat rate of 5% on all hands with no cap then a 50% flop cbet adjusted for rake would be:

Code: Select all

sum(if[cash_hand_player_statistics.flg_f_cbet and (cash_hand_player_statistics.amt_f_bet_made / (cash_hand_summary.amt_pot_f * .95)) = 0.5), 1, 0])

If you want to count other bet sizes or bets on other streets then they will require their own columns.

[4StarGen]

The problem is that I cannot use

Code: Select all

(cash_hand_summary.amt_pot_f * .95)

since rake calculation are more complex than that so I need more IFs so to speak but I don't think I can nest CASE statements.

So I have the raked pot calculation below, how can I add it to a custom stat?

Code: Select all

CASE
  WHEN cash_hand_summary.cnt_players = 2 AND cash_hand_summary.amt_pot_f < 20
    THEN 0.95 * cash_hand_summary.amt_pot_f
  WHEN cash_hand_summary.cnt_players = 2 AND cash_hand_summary.amt_pot_f >= 20
    THEN cash_hand_summary.amt_pot_f - 1
  WHEN cash_hand_summary.cnt_players = 3 AND cash_hand_summary.amt_pot_f < 40
    THEN 0.95 * cash_hand_summary.amt_pot_f
  WHEN cash_hand_summary.cnt_players = 3 AND cash_hand_summary.amt_pot_f >= 40 
    THEN cash_hand_summary.amt_pot_f - 2
  WHEN cash_hand_summary.cnt_players = 4 AND cash_hand_summary.amt_pot_f < 60
    THEN 0.95 * cash_hand_summary.amt_pot_f
  WHEN cash_hand_summary.cnt_players = 4 AND cash_hand_summary.amt_pot_f >= 60
    THEN cash_hand_summary.amt_pot_f - 3
  WHEN cash_hand_summary.cnt_players = 5 AND cash_hand_summary.amt_pot_f < 60
    THEN 0.95 * cash_hand_summary.amt_pot_f
  WHEN cash_hand_summary.cnt_players = 5 AND cash_hand_summary.amt_pot_f >= 60
    THEN cash_hand_summary.amt_pot_f - 3     
  WHEN cash_hand_summary.cnt_players = 6 AND cash_hand_summary.amt_pot_f < 80
    THEN 0.95 * cash_hand_summary.amt_pot_f
  WHEN cash_hand_summary.cnt_players = 5 AND cash_hand_summary.amt_pot_f >= 80
    THEN cash_hand_summary.amt_pot_f - 4 END         

[Flag_Hippo]

There is an example column expression in that thread using nested IFs and it appears to be using the same rake structure as what you've posted here (the OP said it was for Ignition). The example there is for the river but the principle is the same although you might want to count different bet size ranges.

[4StarGen]

Awesome, nice catch, gonna take a look at it, well, I've already had actually but I have problems with the expression, I got 0 instances basically.

So I run the expression filter in a report

Code: Select all

 (cash_hand_player_statistics.flg_f_cbet and cash_hand_summary.cnt_players = 2 and ((cash_hand_summary.amt_pot_f < 20 and (cash_hand_player_statistics.amt_f_bet_made / (cash_hand_summary.amt_pot_f * .95)) between 1 and 0) or (cash_hand_summary.amt_pot_f >= 20 and (cash_hand_player_statistics.amt_f_bet_made / (cash_hand_summary.amt_pot_f - 1)) between 1 and 0)))

But still got zero hands, why?

[4StarGen]

edit: if I delete

Code: Select all

cash_hand_player_statistics.flg_f_cbet and cash_hand_summary.cnt_players = 2 and

I still get 0 results

[4StarGen]

nm solved