3Bet Preflop vs Hero

[4StarGen]

Ty a lot, done

[shahrad]

sum(if[cash_hand_player_statistics.flg_f_cbet AND NOT(cash_hand_player_statistics.flg_p_3bet or cash_hand_player_statistics.flg_p_4bet) 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) and cash_hand_summary.cnt_players_f=2, 1, 0])

This is I hope a correct column for flop cbet vs Hero in a single raised pot.
But I could not define the opportunities to cbet vs Hero. Help really appreciated.

[kraada]

Change hero.flg_f_cbet_def_opp to hero.flg_f_saw and cash_hand_player_statistics.flg_f_cbet to cash_hand_player_statistics.flg_f_cbet_opp.

If you have a chance to cbet and the hero saw the flop and only two players saw the flop, he had a chance to cbet against you.

[shahrad]

Already thought of this but I thought it is not clear who has the cbet opportunity.

[kraada]

You can add not(hero.flg_f_cbet_opp) to the hero subselect to be more clear - if someone has the cbet opportunity and it's not hero and only two people see the flop . . .

[nookie]

What am I doing wrong? I would like to have vsHero stats in my popup but I'm not sure how to do it. If someone could help me, I'd be grateful.

[kraada]

These kinds of stats cannot be cached - that is what the error is telling you. It will work, it will just take longer to return data.

[nookie]

These kinds of stats cannot be cached - that is what the error is telling you. It will work, it will just take longer to return data.

Oh, okay. Thanks! Could you make a Fold to 3Bet preflop, 4Bet vs Hero and fold to 4bet vs Hero-stats?

[kraada]

I'm afraid I don't have those stats handy but if you follow the techniques in this thread you'll be able to build them yourself.

[nookie]

Alright, thanks!