Discuss how to create custom stats, reports and HUD profiles and share your creations.
Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators
by tobakudan » Sat Apr 18, 2015 11:24 pm
I have a stat for being open folded to in the BB and I can't figure out why it won't increment. The column for the stat is:
- Code: Select all
sum(if[tourney_hand_player_statistics.id_hand > 0 AND lookup_positions.flg_bb AND NOT(tourney_hand_player_statistics.flg_p_3bet) AND NOT(tourney_hand_player_statistics.cnt_p_face_limpers > 0), 1 , 0 ])
I also tried changing "tourney_hand_player_statistics.flg_p_3bet" to "tourney_hand_player_statistics.amt_p_2bet_facing > 0", but that didn't work either.
The problem occurs with any HU hand in which the player is in the BB and the SB folds to him. For example,
- Code: Select all
PokerStars Hand #133949004231: Tournament #1205312090, $3.40+$0.10 USD Hold'em No Limit - Match Round I, Level I (10/20) - 2015/04/19 11:03:38 JST [2015/04/18 22:03:38 ET]
Table '1205312090 1' 2-max Seat #1 is the button
Seat 1: tobakudan (500 in chips)
Seat 2: Kalmi33 (500 in chips)
tobakudan: posts small blind 10
Kalmi33: posts big blind 20
*** HOLE CARDS ***
Dealt to tobakudan [5c 2d]
tobakudan: folds
Uncalled bet (10) returned to Kalmi33
Kalmi33 collected 20 from pot
Kalmi33: doesn't show hand
*** SUMMARY ***
Total pot 20 | Rake 0
Seat 1: tobakudan (button) (small blind) folded before Flop
Seat 2: Kalmi33 (big blind) collected (20)
-
tobakudan
-
- Posts: 84
- Joined: Mon Dec 22, 2014 10:03 pm
by Flag_Hippo » Sun Apr 19, 2015 6:08 am
Thanks for the information. I will make sure that the appropriate staff who can answer your query will reply on Monday.
- Rob
-
Flag_Hippo
- Moderator
-
- Posts: 14441
- Joined: Tue Jan 31, 2012 7:50 am
by kraada » Mon Apr 20, 2015 7:49 am
In general we don't recommend using lookup_positions as that will keep the stat from being cached.
No new columns are needed to build your statistic - the value you want is in the already existing column called cnt_walks.
-
kraada
- Moderator
-
- Posts: 54431
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
by tobakudan » Mon Apr 20, 2015 9:54 am
lol. Awesome. Thanks!
-
tobakudan
-
- Posts: 84
- Joined: Mon Dec 22, 2014 10:03 pm
by tobakudan » Mon Apr 20, 2015 10:09 am
Actually, I realized that I'm not able track walks for different effective stack sizes like you normally would for other statistics (since when a walk occurs the effective stack size is counted as 0, right?). Is there a way to get around this?
-
tobakudan
-
- Posts: 84
- Joined: Mon Dec 22, 2014 10:03 pm
by kraada » Mon Apr 20, 2015 2:39 pm
If you wanted to track how often someone is open folding you'd just use 100-VPIP from the SB and that will track for any stack size you want. From the BB when you get a walk your effective stack is treated as 0 as you could not lose any chips in the hand. You could use tourney_hand_summary.amt_short_stack if you really wanted to track how often you're getting walks at various levels.
-
kraada
- Moderator
-
- Posts: 54431
- Joined: Wed Mar 05, 2008 2:32 am
- Location: NY
by tobakudan » Mon Apr 20, 2015 7:19 pm
Okay, I'll try that out.
-
tobakudan
-
- Posts: 84
- Joined: Mon Dec 22, 2014 10:03 pm
Return to Custom Stats, Reports and HUD Profiles
Users browsing this forum: Google [Bot] and 18 guests