limp first in

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

limp first in

Postby pccarballo » Thu Feb 12, 2009 7:55 pm

Does this stat exists?. I want to know how many times a player limped his SB in a HU match. Is there a specific stat for % of times he surrended preflop?
pccarballo
 
Posts: 360
Joined: Wed Mar 05, 2008 6:33 pm
Location: Spain

Re: limp first in

Postby pccarballo » Thu Feb 12, 2009 8:02 pm

ok theres open-limped but i dont see it on the available stats for reports..Im also looking for 4bets ot of the BB. And the only possibility for this to occur will be: SB open limps, BB raises, SB re-raises (3bet) and BB re-raises (4bet). But when I make a report on Holdem Cash Hand and fiter by "Post Big Blind" AND "Preflop 4bet" the hands that are shown are when SB raises Hero 3bets and SB 4bets and hero 5bets...
pccarballo
 
Posts: 360
Joined: Wed Mar 05, 2008 6:33 pm
Location: Spain

Re: limp first in

Postby WhiteRider » Fri Feb 13, 2009 5:50 am

pccarballo wrote:Does this stat exists?. I want to know how many times a player limped his SB in a HU match. Is there a specific stat for % of times he surrended preflop?

Limp First In is pretty easy to build.
Attach is my version of this - I would recommend you have a look at how it is built as it is very simple and if you can learn how to build your own stats you will get MUCH more out of PT3. Also, my stat isn't specific to heads up situations so you may want to tweak it a bit.
Preflop Limp First In.zip
(598 Bytes) Downloaded 159 times


pccarballo wrote:ok theres open-limped but i dont see it on the available stats for reports..Im also looking for 4bets ot of the BB. And the only possibility for this to occur will be: SB open limps, BB raises, SB re-raises (3bet) and BB re-raises (4bet). But when I make a report on Holdem Cash Hand and fiter by "Post Big Blind" AND "Preflop 4bet" the hands that are shown are when SB raises Hero 3bets and SB 4bets and hero 5bets...

If you want to filter to hands where a player specifically raise (2-bet) in the BB and then 4-bet but exclude hands where the SB raised and the BB 3-bet you can add a filter for NOT 3-bet (by adding 3-bet and then selecting it and clicking NOT).
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: limp first in

Postby pccarballo » Fri Feb 13, 2009 6:17 am

But if I put the filters "Post Big Blind" and "4 bet preflop" it should come the hands where this sequence happened (SB completes, BB raises (2bet), SB re-raises (3bet) and BB re-raises (4bet)). But when I put this the tracker is showing me hands where the BB was 5betting
pccarballo
 
Posts: 360
Joined: Wed Mar 05, 2008 6:33 pm
Location: Spain

Re: limp first in

Postby pccarballo » Fri Feb 13, 2009 6:39 am

Thanks for Limp First in stat. How can I use it to see the hands when this happend on Holdem Cash Hand?
pccarballo
 
Posts: 360
Joined: Wed Mar 05, 2008 6:33 pm
Location: Spain

Re: limp first in

Postby WhiteRider » Fri Feb 13, 2009 5:23 pm

pccarballo wrote:But if I put the filters "Post Big Blind" and "4 bet preflop" it should come the hands where this sequence happened (SB completes, BB raises (2bet), SB re-raises (3bet) and BB re-raises (4bet)). But when I put this the tracker is showing me hands where the BB was 5betting

4-bets include all bets 4-bet and higher, so includes 5-bets, 6-bets, etc.

pccarballo wrote:Thanks for Limp First in stat. How can I use it to see the hands when this happend on Holdem Cash Hand?

You can't use that stat directly for Holdem Cash Hands reports, because it is in the Holdem Cash Player Statistics section.
What you need to do is build equivalent columns in HCH (without the SUM(if[...]) parts) and then build a boolean stat which you can display in HCH reports, or use to filter Custom Reports.
I'll attach this one too, because I'm too lazy to type it out, but I would strongly recommend you look how this is built as this is a really useful way to test any new stats that you build.
The boolean stat is formatted to only show the checkbox when you have an opportunity to enter the pot first, and it will be checked if you limped.
You could build this in a different way to show the action you took when you had the opportunity to open the pot - e.g. show a F, C, or R.

PF Limp First In.zip
(505 Bytes) Downloaded 124 times
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


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

Who is online

Users browsing this forum: No registered users and 3 guests