saw flop

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

saw flop

Postby tsuneoka » Sun Mar 22, 2009 6:21 am

hi
run a report to see times if flopped a set but i have a problem with the "saw flop stat"
i played 100% of my AA (of course ;) ) but times i have AA preflop not equal to "saw flop stat" with it,why?

thanks
tsuneoka
 
Posts: 64
Joined: Mon Aug 25, 2008 11:31 am

Re: saw flop

Postby WhiteRider » Sun Mar 22, 2009 6:40 am

Maybe you raised preflop and everyone folded?
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: saw flop

Postby tsuneoka » Sun Mar 22, 2009 6:59 am

ok your smarter than me :D

so another question :
i use the "hit flop with pair" report showing how many times i flopped a set with a pair
how can i know, with 22 for example, how many times i flopped a set WHEN i saw the flop cause when i dont see the flop i cant catch a set
and the report dont say if the frequency i flopped a set is compared to times i have a pair preflop or if played postflop
no sure if im clear

maybe i have to ask to the creator of the report ,hes alonealbert
ive watched i the stats &understand how it works but cant go so deep

thanks
tsuneoka
 
Posts: 64
Joined: Mon Aug 25, 2008 11:31 am

Re: saw flop

Postby WhiteRider » Sun Mar 22, 2009 7:38 am

That report will only show you the number of times you made each hand when you saw the flop.
If you mean you want to know how often you saw the flop with each hand you will need to create a new statistic to display that.

(Alternatively, you could just apply another filter for "saw flop", as that would then show the number of hands which went to the flop.)

You will need to create a new column: e.g. cnt_f_saw =
sum( if[ holdem_hand_player_statistics.flg_f_saw, 1, 0] )

Then create a new statistic to display it (in the same way the stats in that report work.)

Have a look at the Custom Stats guide and the Custom Statistics and Reports FAQ.
If you get stuck please post back and I'll help you out.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: saw flop

Postby alonalbert » Sun Mar 22, 2009 7:05 pm

I actually updated my own copy of these reports to consider hands that saw flop only. I forgot to upload them

I just uploaded the new version. They are waiting approval.

I'll post a message about the updated when they become available.
alonalbert
 
Posts: 393
Joined: Mon Mar 31, 2008 3:32 pm

Re: saw flop

Postby WhiteRider » Sun Mar 22, 2009 7:11 pm

I'll see if we can get this approved soon, but I can't do it myself.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: saw flop

Postby WhiteRider » Mon Mar 23, 2009 6:19 pm

This has now been approved.
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 4 guests