Open Folding Stat

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Open Folding Stat

Postby 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

Re: Open Folding Stat

Postby 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

Re: Open Folding Stat

Postby 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

Re: Open Folding Stat

Postby tobakudan » Mon Apr 20, 2015 9:54 am

lol. Awesome. Thanks!
tobakudan
 
Posts: 84
Joined: Mon Dec 22, 2014 10:03 pm

Re: Open Folding Stat

Postby 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

Re: Open Folding Stat

Postby 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

Re: Open Folding Stat

Postby 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

Who is online

Users browsing this forum: Google [Bot] and 18 guests

cron
highfalutin