3Bet Preflop vs Hero

[potamito]

For cnt_resteal_att_bb_vs_hero_sb_rfi i got

Code: Select all

sum(if[tourney_hand_player_statistics.amt_p_raise_facing and tourney_hand_player_statistics.flg_blind_def_opp AND  tourney_hand_player_statistics hero where hero.id_hand = tourney_hand_player_statistics.id_hand
and hero.flg_hero
and hero.position = 9), 1, 0])


And for cnt_resteal_opp_bb_vs_hero_sb_rfi

Code: Select all

sum(if[tourney_hand_player_statistics.amt_p_raise_facing and tourney_hand_player_statistics.flg_blind_def_opp and from tourney_hand_player_statistics hero
where hero.id_hand = tourney_hand_player_statistics.id_hand
and hero.flg_hero
and hero.position = 9), 1, 0])


[kraada]

You're missing the SELECT portion of your subquery so that won't work properly.

[potamito]

Hi,

thanks, I changed it to tourney and add an (effective stack < 20BB) condition and it seems good.

I made the resteal stat too:
Hero is SB, villain is BB, effective stack < 20BB and nobody is comitted (if the raising is lower than the half of the eff stack)

cnt_resteal_att_bb_vs_hero:

sum(if[tourney_hand_player_statistics.amt_p_raise_facing < (tourney_hand_player_statistics.amt_p_effective_stack * 0.5) and tourney_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action LIKE 'R%' and ((tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 20) and exists
(select 1
from tourney_hand_player_statistics hero
where hero.id_hand = tourney_hand_player_statistics.id_hand
and hero.flg_hero
and hero.position = 9), 1, 0])

cnt_resteal_opp_bb_vs_hero:

sum(if[tourney_hand_player_statistics.amt_p_raise_facing < (tourney_hand_player_statistics.amt_p_effective_stack * 0.5) and tourney_hand_player_statistics.flg_blind_def_opp and ((tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 20) and exists
(select 1
from tourney_hand_player_statistics hero
where hero.id_hand = tourney_hand_player_statistics.id_hand
and hero.flg_hero
and hero.position = 9), 1, 0])

Is it good?
(sry, with wich tag can i copy to code form?)

emano85

Can you re-write it without the 0.5 condition? Cheers.

[potamito]

You're missing the SELECT portion of your subquery so that won't work properly.

Got this for the times villain re-steal from the BB vs HERO RFI from the SB..

cnt_resteal_att_bb_vs_hero

Code: Select all

sum(if[tourney_hand_player_statistics.amt_p_raise_facing < (tourney_hand_player_statistics.amt_p_effective_stack) and tourney_hand_player_statistics.flg_blind_def_opp and exists
(select 1
from tourney_hand_player_statistics hero
where hero.id_hand = tourney_hand_player_statistics.id_hand
and hero.flg_hero
and hero.position = 9), 1, 0])

and the other part of the equation..
cnt_resteal_opp_bb_vs_hero

Code: Select all

sum(if[tourney_hand_player_statistics.amt_p_raise_facing < (tourney_hand_player_statistics.amt_p_effective_stack) and tourney_hand_player_statistics.flg_blind_def_opp and exists
(select 1
from tourney_hand_player_statistics hero
where hero.id_hand = tourney_hand_player_statistics.id_hand
and hero.flg_hero
and hero.position = 9), 1, 0])

[potamito]

Also working on BB Fold vs SB Open 12bb-16bb effective stacks and got this...

(cnt_p_fold_vs_sb_opp_12_16/ cnt_p_fold_vs_sb_opp_12_16) * 100

Where...
cnt_p_fold_vs_sb_open_12_16

Code: Select all

sum(if[tourney_hand_player_statistics.position=8 and tourney_hand_player_statistics.val_p_raise_aggressor_pos=9 and tourney_hand_player_statistics.flg_blind_def_opp and lookup_actions_p.action='F' and (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 12 and 16, 1, 0])

And...
cnt_p_fold_vs_sb_opp_12_16

Code: Select all

sum(if[tourney_hand_player_statistics.position=8 and tourney_hand_player_statistics.val_p_raise_aggressor_pos=9 and tourney_hand_player_statistics.flg_blind_def_opp and (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 12 and 16, 1, 0])

But when building the stat i get this...



And both expressions were valid when i wrote them in the column tab

[sawwee]

You have to put space before and after the " / " and the " * "

[potamito]

If you want to specify the position of hero, you'll have to do that in the stat expression. If you want to specify the position of the opponent, you can use the Position property.

So if i wanted to make a slight modification to Fold to HERO PF 3Bet After Steal stat and make it that it counts for the time a villain folds vs a re-steal from HERO after open raising (RFI) from the BTN i have to set up the HERO position int he stat expression and the villians open raising position from the item properties, correct?

[kraada]

Yes; all hero data is in the subquery.

[potamito]

Lets see how far is this frankenstein i just created, trying to build a re-steal vs HERO BTN RFI 12bb-18bb effective stacks so..

cnt_P_3bet_vs_hero_btn_rfi_12_16

Code: Select all

sum(if[tourney_hand_player_statistics.flg_p_3bet and exists
(select 1
from cash_hand_player_statistics hero
where hero.id_hand = [tourney_hand_player_statistics.flg_p_first_raise AND (tourney_hand_player_statistics.flg_p_open_opp) AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 12 and 16 AND
tourney_hand_player_statistics.position = 1 AND
tourney_hand_player_statistics.flg_p_open_opp
and hero.flg_hero
and hero.flg_p_first_raise), 1, 0]


Obviously i couldnt valide it neither the opp part of the equation.

[kraada]

That really doesn't work at all. You need your subquery to return an id_hand that matches when the hero does whatever you want him to do. For more on how SELECT works see here (and any basic SQL tutorial if you need).