Face open min raise

Forum for users that want to write their own custom queries against the PT database either via the Structured Query Language (SQL) or using the PT3 custom stats/reports interface.

Moderator: Moderators

Re: Face open min raise

Postby joker » Tue Nov 15, 2011 7:05 pm

So the original "BB vs SB steal - Fold" stat is inaccurate too? For ex. after 1st hand, when I raise from SB, villain in BB 3bets me, I 4bet and he folds will be considered as success steal attempt and I will see 1/1 in the HUD?
joker
 
Posts: 67
Joined: Sat May 17, 2008 7:38 am

Re: Face open min raise

Postby kraada » Tue Nov 15, 2011 7:18 pm

The built in stat works properly because it does not take into account raise sizes - it's only one raise facing size that is stored.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Face open min raise

Postby joker » Wed Nov 16, 2011 9:02 am

Than is there some way how can I split openshove attemps from minraise attemps to steal in my HUD ? Some time ago you helped me to build this stat for cash games and I think that it worked just good - shows how many folds I get from BB when steal his blind by exact bet amount, can it be also used in tourneys and will it fix the limitation with one stored raise size ?

Code: Select all
cnt_bb_steal_fold_21:

sum( if[holdem_hand_player_statistics.flg_blind_def_opp AND holdem_hand_player_statistics.flg_blind_b AND (holdem_hand_player_detail.val_p_raise_facing_pct BETWEEN 30.5 and 30.6 OR holdem_hand_player_detail.val_p_raise_facing_pct BETWEEN 35.4 and 35.5), 1, 0])

cnt_steal_def_opp_bb_21:

sum(if[holdem_hand_player_statistics.flg_bb_steal_fold AND (holdem_hand_player_detail.val_p_raise_facing_pct BETWEEN 30.5 and 30.6 OR holdem_hand_player_detail.val_p_raise_facing_pct BETWEEN 35.4 and 35.5), 1, 0])

This takes into account times it was folded to the SB and he opened to 4.2 - see the earlier posts WhiteRider made.
joker
 
Posts: 67
Joined: Sat May 17, 2008 7:38 am

Re: Face open min raise

Postby kraada » Wed Nov 16, 2011 10:00 am

Hm, there might be a way to use this method - use what you have now for times you don't 3bet and times you do, check to see if your raise amount and raise pct mean that the pot had to be exactly minraised prior.

Unfortunately it's a bit complicated to figure out exactly how that should look so I'll have to take a look at it later and get back to you.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Previous

Return to Custom Stats, Reports, and SQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests