Custom stats needed in new Beta / Custom stats not working

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

Custom stats needed in new Beta / Custom stats not working

Postby Letissie » Wed Jan 07, 2009 11:59 pm

4Bet steal w 3Bet from Blinds
4Bet by position
3Bet by position (already posted in the site might not work)
Fold to pf 4bet w 3betting (not working)
4bet preflop w RFI (not working)
Donk bet flop and fold to Riase (doesn't work and cancel all the other stats displayed in the pop up)
BB raise Sb steal
SB 4Bet steal BB 3Bet defence

I've created this stats code seems right and i even get a validate message for: (definition - format - categories)
for this stats:

4Bet from BTN
4Bet from CO
3Bet vs Steal from BTN

I'm asking for support to someone good coding to upload em or send me via email.




V.
Letissie
 
Posts: 39
Joined: Thu Apr 10, 2008 9:31 am

Re: Custom stats needed in new Beta / Custom stats not working

Postby kraada » Thu Jan 08, 2009 10:34 am

The 3bet by position and 4bet by position stats are available in the How To: Advanced HUD Configuration in the last big stat block I uploaded.

I replied to your other post about 4bet steal when 3bet from blinds. That stat should be easily modifyable into sb steal bb 3bet defense (just check for being the small blind, holdem_hand_player_statistics.position = 9).

BB raise SB steal isn't possible to uniquely determine because if the SB folds to the 3bet you can't pull the data out of the database that hero was in the BB and facing a SB steal - the position information isn't easy to grab in that spot.

With the ones you say aren't working, I'll look into that for you.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Custom stats needed in new Beta / Custom stats not working

Postby Letissie » Thu Jan 08, 2009 2:12 pm

Could you create for me this stats i'm asking please.

Fold 3bet from blinds from a 4Bet initial stealer (i mean a player steal - sb / bb 3bet defense and stealer 4bet).
And 4Bet after performing a steal vs a 3Bet from blinds.

I can figure out of what stats you are talking i have to edit to create the BB raise SB steal.

I've just started studing the code and this stats i'm asking are to hard for me.

Please if you can help and link a zip to download this 3 really really important stats for me.


Thank you very much.



V
Letissie
 
Posts: 39
Joined: Thu Apr 10, 2008 9:31 am

Re: Custom stats needed in new Beta / Custom stats not working

Postby kraada » Thu Jan 08, 2009 2:58 pm

You cannot pick out who exactly is the initial stealer when you 4bet, so there's no way right now to distinguish between these two spots:

Button raises, you're in the SB, you 3bet, the BB pushes all in, and the button folds

and

The button raises, you're in the SB, you 3bet, the BB folds and the button pushes all in.

You can't distinguish those two spots with the custom stat system the way it is set up currently.

That said, if you want to pick out times you're facing a 4bet preflop after you've 3bet vs some steal attempt:

cnt_p_face_4bet_when_3b_steal:

sum(if[holdem_hand_player_statistics.flg_blind_def_opp and holdem_hand_player_statistics.flg_p_3bet and holdem_hand_player_statistics.flg_p_4bet_def_opp, 1, 0])

flg_blind_def_opp means you had a chance to defend the blinds
flg_p_3bet means you made a 3bet
flg_p_4bet_def_opp means you had a chance to defend against a 4bet.

and

cnt_p_fold_4bet_when_3b_steal:

sum(if[holdem_hand_player_statistics.flg_blind_def_opp and holdem_hand_player_statistics.flg_p_3bet and holdem_hand_player_statistics.enum_p_4bet_action = 'F', 1, 0])

Then create the stat using those two columns, since the first counts up the times the person faced the 4bet, and the second is the times they folded, put the latter over the former, multiply by 100, and make sure to fill in the format tab and everything should work.

Since I've shown you how to build this one, you should be able to build 4bet after stealing yourself. It's the same principle, you just use flg_steal_att for steal attempt and change 3bets and 4bets when necessary.

Good luck.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Custom stats needed in new Beta / Custom stats not working

Postby Letissie » Thu Jan 08, 2009 4:04 pm

I understand some part of it.

Still when you give me:

cnt_p_face_4bet_when_3b_steal:

sum(if[holdem_hand_player_statistics.flg_blind_def_opp and holdem_hand_player_statistics.flg_p_3bet and holdem_hand_player_statistics.flg_p_4bet_def_opp, 1, 0])

But i need the range so i also also need the cnt_p_face_4bet_when_3b_steal_opp !!!

So i can create (cnt_p_face_4bet_when_3b_steal / cnt_p_face_4bet_when_3b_steal_opp) * 100

And have the range of 4bet after a steal being 3bet from blinds.

Second:

I need also cnt_p_fold_4bet_when_3b_steal_opp

So i also can make: (cnt_p_fold_4bet_when_3b_steal / cnt_p_fold_4bet_when_3b_steal_opp) * 100

To have his calling range to a 4bet resteal from LP.


Thank you
Letissie
 
Posts: 39
Joined: Thu Apr 10, 2008 9:31 am

Re: Custom stats needed in new Beta / Custom stats not working

Postby Letissie » Thu Jan 08, 2009 4:17 pm

I don't get this: Since I've shown you how to build this one, you should be able to build 4bet after stealing yourself. It's the same principle, you just use flg_steal_att for steal attempt and change 3bets and 4bets when necessary.

Haven't i got it already with this?

(cnt_p_face_4bet_when_3b_steal / cnt_p_fold_4bet_when_3b_steal) * 100

I've created it and i consider this as the Fold % of the BB / SB to a 4Bet initial stealer.
Tell me if i'm right.

The code is hard man, i'm sorry if i'm bugging you.

I need the BB 3bet SB steal!


V
Letissie
 
Posts: 39
Joined: Thu Apr 10, 2008 9:31 am

Re: Custom stats needed in new Beta / Custom stats not working

Postby Letissie » Thu Jan 08, 2009 4:24 pm

(cnt_p_face_4bet_when_3b_steal / cnt_p_fold_4bet_when_3b_steal) * 100

is not working.

What should i put under the Format Tab?

Title: is easy
Width: ?
Right /Center / Left?

Format Expression?
Format Summary Expression?

I guess this is the main reason the stat is not working, and the reason why some of the stats uploaded aren't working.
They give the same issue, the stats under the bugged one doesn't diplay numbers or the N/A sign anymore even if they have a correct code.

V.
Letissie
 
Posts: 39
Joined: Thu Apr 10, 2008 9:31 am

Re: Custom stats needed in new Beta / Custom stats not working

Postby kraada » Thu Jan 08, 2009 4:27 pm

The stat I built should be put together as:
(cnt_p_fold_4bet_when_3b_steal / cnt_p_face_4bet_when_3b_steal) * 100

Think about what the columns mean. cnt_p_fold_4bet_when_3b_steal is the number of times you fold to a 4bet when someone 3bets your steal. cnt_p_face_4bet_when_3b_steal is the number of times you face a 4bet when someone 3bets your steal. So putting it like I just did above is the number of times you fold out of the number of opportunities you had to fold. The opportunities doesn't need to have an _opp at the end of the field, though you can name it really whatever you like, I just picked the name that I thought most natural.

And width of something like 55 should work.

Format expression of /%.2f and same for format summary expression should work.

You need to actually add the columns that I've defined in the Columns tab though otherwise the stat won't verify.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Custom stats needed in new Beta / Custom stats not working

Postby Letissie » Thu Jan 08, 2009 4:38 pm

No, i think you got me wrong, i mean for "you" is player x is oke, but if "you" is me then is impossibile.

Think about what the columns mean. cnt_p_fold_4bet_when_3b_steal is the number of times "you" fold to a 4bet when someone 3bets your steal.

What i'm looking forward to be easy is this.


CO / BTN - steal

SB or BB - 3Bet (so this is considered a 3bet vs Steal)

CO / BTN - 4Bet

I need the fold % of the SB or BB in this situation.
I need the 4Bet % of the CO / BTN in this situation.

Please be kind, since this are working on your PT3 link a zip with this stas.
They will be working, i'll be studying em.

I really need them as BB 3bet SB steal -> everyone fold at the table. SB PFR / BB 3Bet/

Would be perfect to have:

SB steal fold to a BB 3Bet
SB 4Bet range in this situation and so on.

This stats are really important in this days!


Thank you for your fast reply.

Stats still not working even with the /%.2f
Letissie
 
Posts: 39
Joined: Thu Apr 10, 2008 9:31 am

Re: Custom stats needed in new Beta / Custom stats not working

Postby kraada » Thu Jan 08, 2009 4:47 pm

The stat I defined is the fold % of the SB or BB in the situation.

The 4bet % of the CO/BTN in this situation should be something you can build with the information I've given you in this thread. I want to help you learn how to do this; if you don't understand what's going on behind the stats, it's going to be a lot harder to grasp how to react as a result of knowing the stat's value.

Building a distinct range from the actual hands you've seen a player play in a given spot as a stat in PT3 is not possible at this time.
kraada
Moderator
 
Posts: 54431
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 22 guests

cron