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
by 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
by 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
by 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
by 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
Return to Custom Stats, Reports, and SQL [Read Only]
Users browsing this forum: No registered users and 0 guests