[Call_3Bet_Preflop_-_Fold_to_CB_Flop] Evaluate it plz!

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

Re: [Call_3Bet_Preflop_-_Fold_to_CB_Flop] Evaluate it plz!

Postby js2002 » Thu Sep 18, 2008 9:07 am

Found this value in the repository:

The Column:
cnt_p_3bet_f_cbet_def_action_call

sum(if[ holdem_hand_player_statistics.flg_p_3bet AND holdem_hand_player_statistics.enum_f_cbet_action='C', 1 , 0 ])

Do you agree, that the wanted semantic is not expressed by this column?

The columns says:
Number of times the player called a flop continuation bet after making a 3bet prefop.

...but it wants to be:
Number of times the player called a flop continuation bet after a 3bet prefop.
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: [Call_3Bet_Preflop_-_Fold_to_CB_Flop] Evaluate it plz!

Postby WhiteRider » Thu Sep 18, 2008 11:54 am

Yes, I agree - I thought those stats had been updated. Did you just download this from the Repository recently?
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: [Call_3Bet_Preflop_-_Fold_to_CB_Flop] Evaluate it plz!

Postby js2002 » Thu Sep 18, 2008 1:20 pm

2 or 3 weeks ago
there are no new these are from 1.09.08
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: [Call_3Bet_Preflop_-_Fold_to_CB_Flop] Evaluate it plz!

Postby WhiteRider » Thu Sep 18, 2008 2:31 pm

I investigated these stats a while ago, and this is the version I have:
cnt_p_3bet_f_cbet_def_action_call =
sum(if[ (holdem_hand_player_statistics.flg_p_3bet_def_opp OR holdem_hand_player_statistics.flg_p_4bet_def_opp) AND holdem_hand_player_statistics.enum_f_cbet_action='C', 1 , 0 ])

..which addresses exactly the issue you mention.
I thought they had been updated in the Repository - in fact I'm pretty sure, because I have a copy of this stat downloaded in my 'repository test' folder from Sept 9, and imported into a separate test install of PT3, showing the new correct (hopefully!) version.

Try deleting the stat and it's columns from PT3 and re-download and install it.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: [Call_3Bet_Preflop_-_Fold_to_CB_Flop] Evaluate it plz!

Postby js2002 » Thu Sep 18, 2008 2:51 pm

ok thx 4 info.
Why ist the 4bet exp also in the column? to geht all reraised pots?!
js2002
 
Posts: 1502
Joined: Fri Feb 15, 2008 5:44 am
Location: Germany

Re: [Call_3Bet_Preflop_-_Fold_to_CB_Flop] Evaluate it plz!

Postby WhiteRider » Thu Sep 18, 2008 2:57 pm

Yes, I figured you wouldn't just want to know about specifically 3-bet pots (4-bet covers 5-bet, 6-bet, etc too).
If you really do just want 3-bets it can be editted back out again.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Previous

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

Who is online

Users browsing this forum: No registered users and 9 guests