Cbet F vs Hero

[Huttydr]

HI! I have created this stat but it fails since it always gives me 100 where can the error be?
stat:(cnt_f_cbet_vs_hero / cnt_f_cbet_opp_vs_hero) * 100
cnt_f_cbet_vs_hero : sum(if[cash_hand_player_statistics.flg_f_cbet and exists
(select 1
from cash_hand_player_statistics hero
where hero.id_hand = cash_hand_player_statistics.id_hand
and hero.flg_hero
and hero.flg_f_cbet_def_opp), 1, 0])
cnt_f_cbet_opp_vs_hero : sum(if[cash_hand_player_statistics.flg_f_cbet_opp and exists
(select 1
from cash_hand_player_statistics hero
where hero.id_hand = cash_hand_player_statistics.id_hand
and hero.flg_hero
and hero.flg_f_cbet_def_opp), 1, 0])

[Flag_Hippo]

You cannot use hero.flg_f_cbet_def_opp in the opportunities column as it will only be true when the CBet has been made.

[mish]

I am currently working on the same topic. I tried the "saw flop" Flag instead:

cnt_f_cbet_vs_hero
sum(if[cash_hand_player_statistics.flg_f_cbet and exists (select 1
from cash_hand_player_statistics hero
where hero.id_hand = cash_hand_player_statistics.id_hand
and hero.flg_hero and hero.flg_f_saw), 1, 0])

cnt_f_cbet_def_opp_vs_hero
sum(if[cash_hand_player_statistics.flg_f_cbet_def_opp and exists (select 1
from cash_hand_player_statistics hero
where hero.id_hand = cash_hand_player_statistics.id_hand
and hero.flg_hero and hero.flg_f_saw), 1, 0])

unfortunately the output is not plausible. Which one to use?

[Huttydr]

I am currently working on the same topic. I tried the "saw flop" Flag instead:

cnt_f_cbet_vs_hero
sum(if[cash_hand_player_statistics.flg_f_cbet and exists (select 1
from cash_hand_player_statistics hero
where hero.id_hand = cash_hand_player_statistics.id_hand
and hero.flg_hero and hero.flg_f_saw), 1, 0])

cnt_f_cbet_def_opp_vs_hero
sum(if[cash_hand_player_statistics.flg_f_cbet_def_opp and exists (select 1
from cash_hand_player_statistics hero
where hero.id_hand = cash_hand_player_statistics.id_hand
and hero.flg_hero and hero.flg_f_saw), 1, 0])

unfortunately the output is not plausible. Which one to use?

try to use my expression for the column of times that cbet does and in the one of opportunities use yours changing cash_hand_player_statistics.flg_f_cbet_def_opp by cash_hand_player_statistics.flg_f_cbet_opp

[Huttydr]

I am currently working on the same topic. I tried the "saw flop" Flag instead:

cnt_f_cbet_vs_hero
sum(if[cash_hand_player_statistics.flg_f_cbet and exists (select 1
from cash_hand_player_statistics hero
where hero.id_hand = cash_hand_player_statistics.id_hand
and hero.flg_hero and hero.flg_f_saw), 1, 0])

cnt_f_cbet_def_opp_vs_hero
sum(if[cash_hand_player_statistics.flg_f_cbet_def_opp and exists (select 1
from cash_hand_player_statistics hero
where hero.id_hand = cash_hand_player_statistics.id_hand
and hero.flg_hero and hero.flg_f_saw), 1, 0])

unfortunately the output is not plausible. Which one to use?

try to use my expression for the column of times that cbet does and in the one of opportunities use yours changing cash_hand_player_statistics.flg_f_cbet_def_opp by cash_hand_player_statistics.flg_f_cbet_opp

I try this but unfortunately the results are not real there are too many opp
Any idea?

[Flag_Hippo]

I said that the hero.flg_f_cbet_def_opp edit was required for the opportunities column only. hero.flg_f_cbet_def_opp is still required in the actions column.

cnt_f_cbet_vs_hero

Code: Select all

sum(if[cash_hand_player_statistics.flg_f_cbet and exists
(select 1
from cash_hand_player_statistics hero
where hero.id_hand = cash_hand_player_statistics.id_hand
and hero.flg_hero
and hero.flg_f_cbet_def_opp), 1, 0])

cnt_f_cbet_opp_vs_hero

Code: Select all

sum(if[cash_hand_player_statistics.flg_f_cbet_opp and exists
(select 1
from cash_hand_player_statistics hero
where hero.id_hand = cash_hand_player_statistics.id_hand
and hero.flg_hero
and hero.flg_f_saw), 1, 0])

[mish]

Great! ty