Changing Default Colums Value (Fold 3bet) ¡TST PROBLEM!

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

Changing Default Colums Value (Fold 3bet) ¡TST PROBLEM!

Postby parraka » Sun Jul 22, 2012 9:06 pm

Hi people, a lot of time without making a question.
I have tried with Zandry adapt Turbo Scan Table to work with Fold to PF 3bet after raise for making the filter more accurate. These are the current default stats in PT3.

Fold to PF 3bet is (cnt_p_3bet_def_action_fold / cnt_p_3bet_def_opp) * 100

-1 sum(if[holdem_hand_player_statistics.enum_p_3bet_action='F', 1, 0])

-2 sum(if[holdem_hand_player_statistics.flg_p_3bet_def_opp, 1, 0])

Fold to PF 3bet When Raised is (cnt_p_3bet_def_action_fold_when_open_raised / cnt_p_3bet_def_opp_when_open_raised) * 100

-1 sum(if[holdem_hand_player_statistics.enum_p_3bet_action='F' and holdem_hand_player_statistics.flg_p_first_raise and not(holdem_hand_player_statistics.flg_steal_att), 1, 0])

-2 sum(if[holdem_hand_player_statistics.flg_p_3bet_def_opp and holdem_hand_player_statistics.flg_p_first_raise and not(holdem_hand_player_statistics.flg_steal_att), 1, 0])

In the first one we have Player 1 raises, Player 2 3bets, Player 3 folds. Player3 sums a Fold 3bet case, i dont want this.
In the second one we have Player 1 raises at button, Player 2 3bets, Player 1 folds. Player 1 doesnt sum a Fold 3bet case, I dont want this.

So, i need these second columns but without the condition and not(holdem_hand_player_statistics.flg_steal_att)
The problem is that this stat doesnt exist by default and if Zandry adds it to his software all of the users would have to have this new stat Fold 3bet After Raise (With or without steal) and it would be a total mess.

So, it would be easier if i can replace my default columns into:

cnt_p_3bet_def_action_fold = sum(if[holdem_hand_player_statistics.enum_p_3bet_action='F' and holdem_hand_player_statistics.flg_p_first_raise), 1, 0])

cnt_p_3bet_def_opp = sum(if[holdem_hand_player_statistics.flg_p_3bet_def_opp and holdem_hand_player_statistics.flg_p_first_raise), 1, 0])

Is this possible? Any alternative suggestion?
parraka
 
Posts: 79
Joined: Tue Jan 04, 2011 2:49 pm

Re: Changing Default Colums Value (Fold 3bet) ¡TST PROBLEM!

Postby WhiteRider » Mon Jul 23, 2012 3:47 am

No, you can't change the definition of built-in stats - these are protected to avoid complications.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Changing Default Colums Value (Fold 3bet) ¡TST PROBLEM!

Postby parraka » Mon Jul 23, 2012 5:15 am

I ll have to move to Holdem Manager, im tired of trying to fix developers fails.
I dont understad how doesnt exist Fold 3bet After Raise, you create one similar, but you include if its not a steal? Why?
This is not useful.
parraka
 
Posts: 79
Joined: Tue Jan 04, 2011 2:49 pm

Re: Changing Default Colums Value (Fold 3bet) ¡TST PROBLEM!

Postby kraada » Mon Jul 23, 2012 8:49 am

That's why we have the custom statistics! We do have Fold to 3Bet Preflop When Raised built in, and in PT4 we have Fold to Preflop 3Bet After Raise built in by default (and used in our default HUD layouts). We don't disagree that these versions of folding to 3bets is useful, it's just disingenuous of us to call a stat "fold to 3bet" that doesn't count when someone actually folds to a 3bet because of other unnamed (in the stat name) circumstances.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Changing Default Colums Value (Fold 3bet) ¡TST PROBLEM!

Postby parraka » Mon Jul 23, 2012 9:16 am

Cani have installed at the same time PT4 and PT3? I feel so comfortable playing with PT3 but i would like to take a look into PT4. I have read that importing hands is slow, is this real? For me this is so important.
parraka
 
Posts: 79
Joined: Tue Jan 04, 2011 2:49 pm

Re: Changing Default Colums Value (Fold 3bet) ¡TST PROBLEM!

Postby parraka » Mon Jul 23, 2012 9:19 am

Would i be able to play with my current database? Would i be able to use my actual customized stats?
parraka
 
Posts: 79
Joined: Tue Jan 04, 2011 2:49 pm

Re: Changing Default Colums Value (Fold 3bet) ¡TST PROBLEM!

Postby parraka » Mon Jul 23, 2012 11:18 am

kraada wrote:We do have Fold to 3Bet Preflop When Raised built in


Yes, but it doesnt include Attempts to Steal, it doesnt have sense :oops:
parraka
 
Posts: 79
Joined: Tue Jan 04, 2011 2:49 pm

Re: Changing Default Colums Value (Fold 3bet) ¡TST PROBLEM!

Postby kraada » Mon Jul 23, 2012 12:12 pm

You can use PT3 and PT4 at the same time. When you take into account housekeeping time we have found PT4 to be faster overall, but housekeeping is included in the import so the numbers appear slower as h/sec goes down but you end up having to spend less time with import + housekeeping.

There is a built in database conversion tool and PT3 HUDs do import into PT4 so you can convert your setup over with a minimal amount of interruption.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Changing Default Colums Value (Fold 3bet) ¡TST PROBLEM!

Postby parraka » Mon Jul 23, 2012 4:44 pm

I only do update cache, i dont need anything else, i have a database huge (more than 10 millions) and it works perfect, with the cache updated obvious. The question is, is faster PT4 (importing + housekeeping (i dont know what is included in this housekeeping)) or PT3 (importing + update cache)?
parraka
 
Posts: 79
Joined: Tue Jan 04, 2011 2:49 pm

Re: Changing Default Colums Value (Fold 3bet) ¡TST PROBLEM!

Postby kraada » Mon Jul 23, 2012 5:25 pm

By Housekeeping in PT4 I meant the cache - PT4's Import includes the equivalent of the PT3 cache update - whereas PT3 has them separate. With a 10M hand database you well know how long cache updates can take in PT3. In PT4 it's all done at import time so there is nothing else to do afterwards. This means you get lower raw hands per second (since all of the cache update time is included when it isn't included in the h/sec of PT3) but PT4's total time should be smaller than a full PT3 reimport + cache rebuild.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Next

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

Who is online

Users browsing this forum: No registered users and 6 guests