limp stab and stab in limped pot

General discussion of PokerTracker 3.

Moderator: Moderators

limp stab and stab in limped pot

Postby olistr » Thu Oct 06, 2011 7:18 am

Hi what stats can I use to see this, limp stab and stab(donk) in limped pot ?
olistr
 
Posts: 53
Joined: Wed May 14, 2008 4:32 am

Re: limp stab and stab in limped pot

Postby kraada » Thu Oct 06, 2011 8:28 am

This statistic doesn't exist by default but you can build it with these columns:

cnt_f_bet_limp_pot: sum(if[tourney_holdem_hand_player_statistics.flg_f_bet and not(tourney_holdem_hand_player_statistics.flg_p_face_raise) and tourney_holdem_hand_player_statistics.cnt_p_raise = 0, 1, 0])

cnt_f_open_opp_limp_pot: sum(if[tourney_holdem_hand_player_detail.flg_f_open_opp and not(tourney_holdem_hand_player_statistics.flg_p_face_raise) and tourney_holdem_hand_player_statistics.cnt_p_raise = 0, 1, 0])

Put the former over the latter and multiply by 100 to create your statistic. For more on creating custom statistics, please see the Tutorial: Using Custom Statistics and Reports.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: limp stab and stab in limped pot

Postby olistr » Thu Oct 06, 2011 11:15 am

Thank you, I have tried to read that tutorial but is very confusing for me and I am not so good at english. Is it possible that you create that stats and then I just import them? I like to have that stats for HU SnG tournament and as reward for your time u spend I will ship you 10$ in poker stars acc 8-) . Is it fair enough?
olistr
 
Posts: 53
Joined: Wed May 14, 2008 4:32 am

Re: limp stab and stab in limped pot

Postby kraada » Thu Oct 06, 2011 11:59 am

I've gone ahead and built the stat and attached it for you. I also edited the above columns to reflect working versions for tournaments should anybody else be looking for the way this stat was built.
Attachments
Bet Flop in Limp Pot.zip
(621 Bytes) Downloaded 198 times
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: limp stab and stab in limped pot

Postby joker » Sun Nov 13, 2011 6:22 pm

Does this stat covers all stabs in limped pots, (sb limps, bb checks, sb bet) or only donk bets made by bb in to the limped pot ?

Thank you
joker
 
Posts: 67
Joined: Sat May 17, 2008 7:38 am

Re: limp stab and stab in limped pot

Postby WhiteRider » Mon Nov 14, 2011 3:38 am

It counts any flop bet made when the player neither made or faced a preflop raise.

You can see exactly what is being checked for in Kraada's expression:

cnt_f_bet_limp_pot =
sum(if[tourney_holdem_hand_player_statistics.flg_f_bet and not(tourney_holdem_hand_player_statistics.flg_p_face_raise) and tourney_holdem_hand_player_statistics.cnt_p_raise = 0, 1, 0])

All that is mentioned is making a flop bet (flg_f_bet) and not facing a raise preflop (not flg_p_face_raise) and making zero raises preflop (cnt_p_raise = 0).
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: limp stab and stab in limped pot

Postby hello776 » Sat Nov 19, 2011 8:37 am

How do you make this stat specific to the BB instead of any player?
hello776
 
Posts: 7
Joined: Tue May 27, 2008 9:46 am

Re: limp stab and stab in limped pot

Postby WhiteRider » Sat Nov 19, 2011 9:38 am

Make a copy of the stat and add this into the expressions:

AND holdem_hand_player_statistics.position=8

The BB is always position 8 regardless of table size or number of active players.
See the Tutorial: Cust om Reports and Statistics for more information on making a new version of a stat.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: limp stab and stab in limped pot

Postby donkeyeeeaww » Sun Feb 05, 2012 6:31 pm

Hey. WhiteRider mentions that we need to add that "AND holdem_hand_player_statistics.position=8" into the expressions and I have two questions regarding this that I would really appreciate some help with:

1) into the expressions of the 2 columns? if so, exactly where? I'm not experienced with SQL

ex. where in this expression?

sum(if[tourney_holdem_hand_player_statistics.flg_f_bet and not(tourney_holdem_hand_player_statistics.flg_p_face_raise) and tourney_holdem_hand_player_statistics.cnt_p_raise = 0, 1, 0])

2) for SB should the addtion be "tourney_holdem_hand_player_statistics.position=9" because we're dealing with tournaments? (WhiteRider said the non-tournament version but I'm not sure if that matters)

Note: Just to be clear I'm looking for a stat for heads up SNGs that shows me the number of times a player limps the SB and then bets the flop when checked to

Thanks! SQL is really confusing.
donkeyeeeaww
 
Posts: 2
Joined: Sun Feb 05, 2012 6:23 pm

Re: limp stab and stab in limped pot

Postby WhiteRider » Mon Feb 06, 2012 4:14 am

You're correct in (2), for tournament SB you'd want to add it to the column expressions like this:

sum(if[tourney_holdem_hand_player_statistics.flg_f_bet and not(tourney_holdem_hand_player_statistics.flg_p_face_raise) and tourney_holdem_hand_player_statistics.cnt_p_raise = 0 AND tourney_holdem_hand_player_statistics.position=9, 1, 0])

Check out the Tutorial: Custom Reports and Statistics for more information on working with custom stats.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Next

Return to General [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests