Fold to check raise FTR

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

Fold to check raise FTR

Postby js2002 » Tue Jul 22, 2008 8:18 am

Hi.

does anyone have this stat value?
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Fold to check raise FTR

Postby js2002 » Sat Jul 26, 2008 4:25 am

no one? puuush
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Fold to check raise FTR

Postby WhiteRider » Sat Jul 26, 2008 5:12 am

It should be pretty straighforward to build this.
You'll need to use fields like:

holdem_hand_player_statistics.flg_f_check
AND
holdem_hand_player_statistics.flg_f_face_raise
AND
holdem_hand_player_statistics.flg_f_fold

For completeness, you might also want to include:
holdem_hand_player_statistics.cnt_f_call = 0
AND
holdem_hand_player_statistics.cnt_f_raise = 0

(in fact, if cnt_f_call=0 and cnt_f_raise=0 then I guess you don't need flg_f_fold)

Have a look at the Custom Statistics and Reports FAQ for a couple of examples.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Fold to check raise FTR

Postby js2002 » Sun Jul 27, 2008 4:34 am

This one is to tough for me. Can someone do it plz (if it is as simple as Whitey says)

Greetings

JS

ps problem: I check raise but he gets faced by my raise and folds. Dont how how to query stats for different players. so, me and the other one.

I can´t even query if he was facing a check raise :-(
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Fold to check raise FTR

Postby WhiteRider » Sun Jul 27, 2008 4:54 am

No, you can't query directly what your opponent does, all you can do is set up the stats and see them from each player's point of view.
So if you want to know how often each player folds to a check raise you create the Custom Statistic in the 'Holdem Player Statistics' section. However if you want to be able to filter to those hands where a particular player folds to a check raise then you need to create it in the 'Holdem Cash Hand' section.

For the 'player stats' version, I guess you would want it as a percentage, so you would need to work out how often they face a check raise as well.
fold to check raise % = ( #times folds to check raise / #times faced check raise ) / 100.

If I have time later I'll have a go at building it for you, but I'd really advise you to have a look through the walkthroughs linked above and try it for yourself - that's the best way to learn. Once you understand how to put a simple stat together you'll be able to adapt that to others.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Fold to check raise FTR

Postby js2002 » Sun Jul 27, 2008 5:01 am

WhiteRider wrote:fold to check raise % = ( #times folds to check raise / #times faced check raise ) / 100.

If I have time later I'll have a go at building it for you, but I'd really advise you to have a look through the walkthroughs linked above and try it for yourself - that's the best way to learn. Once you understand how to put a simple stat together you'll be able to adapt that to others.


Am I on the right way if I do sth like:

2 Columns:
#times folds to check raise = faced a raise AND faced a raise AND fold action
#times faced check raise = faced a raise AND faced a raise

...and build em together like u told me above?!
This should be it, I hope. If not, please do it when u find little "free" time.

Greetings

JS
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Fold to check raise FTR

Postby WhiteRider » Sun Jul 27, 2008 5:29 am

js2002 wrote:
WhiteRider wrote:fold to check raise % = ( #times folds to check raise / #times faced check raise ) / 100.

If I have time later I'll have a go at building it for you, but I'd really advise you to have a look through the walkthroughs linked above and try it for yourself - that's the best way to learn. Once you understand how to put a simple stat together you'll be able to adapt that to others.


Am I on the right way if I do sth like:

2 Columns:
#times folds to check raise = faced a raise AND faced a raise AND fold action
#times faced check raise = faced a raise AND faced a raise

...and build em together like u told me above?!
This should be it, I hope. If not, please do it when u find little "free" time.


Sorry - I'm talking rubbish! (well, a bit..)

The situation you are looking for is when playerX bets and then folds to a check raise, yes?

So it's a little more complictated.
You need to check for "bet AND faced-a-raise", but also you only want 'bet after other player checked' so you need to use the 'in position' field too.

Sorry, I have to go out now - I'll have a look at this later..
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Fold to check raise FTR

Postby js2002 » Mon Jul 28, 2008 6:12 am

Answer = yes.

I had a error in my text too:

#times folds to check raise = faced a check AND faced a raise AND fold action
#times faced check raise = faced a check AND faced a raise

this is right or?!

faced a check AND faced a raise because there son faced a checkraise stat.

And then 2 2 things u told like position and the bet thing. But its more complicate so I cant do it and I dont thing its my job. I think PT3 should have this stat as feature.
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: Fold to check raise FTR

Postby WhiteRider » Sat Aug 02, 2008 5:26 am

OK, here's my first attempt.
These are stats for the 'Holdem Cash Player Statistics' section, so can be added to reports such as 'Known Starting Hands Summary', or custom reports using this section.
I have attached a zip of stats for when a player bets the flop and gets check raised (so the aggressor is out of position). The 3 stats show how often the player folds, calls, or raises when faced with a flop check-raise.

I think the 'folds' stat is accurate, but 'calls' and 'raises' have potential not to be perfectly accurate.
So far, I don't think there is a way to get the actions in order (although there is an id_actions field in the DB which holds the info there is no way to access it yet), so if the player calls the CR then raises later, or raises the CR then calls later, both the 'calls' and 'raises' stats will count this. I think that these cases will be pretty rare, though, so shouldn't throw the stats out too much (and if you call a CR then raise again later the same round it's still pretty aggressive, which I guess is what you want to know..).

Please have a look at how they are built, and test them - I don't have much data to test with, and only the odd case where these stats apply.
Attachments
Flop CR actions.zip
(1.94 KiB) Downloaded 270 times
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Fold to check raise FTR

Postby WhiteRider » Sat Aug 02, 2008 5:29 am

As a testing aid, and to highlight the different stat 'sections', here are a couple of stats in the 'Holdem Cash Hands' section which I used to identify appropriate hands.
You can add these stats to the 'Known Starting Hands Detail' report, or Custom Reports of the appropriate section.

Both are boolean / checkbox stats.
Hand_Flop Bet Face Check Raise.pt3stat - True if the player faced a check raise.
Hand_Flop Bet Face Check Raise Folded.pt3stat - True if the player folded when facing a check raise.
Attachments
Hand Flop CR.zip
(1.15 KiB) Downloaded 256 times
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Next

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

Who is online

Users browsing this forum: No registered users and 0 guests