Need a little help with custom stat for 3bet.

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

Need a little help with custom stat for 3bet.

Postby time1minute » Mon Dec 05, 2011 6:47 am

Hello everyone! I would like to create a custom stat but im not sure how to go about doing it, i've read through the forums and did see something about it being impossible etc but anyway here goes:

btw im talking NLHE 6m cash games here
I would like a custom stat for:
3bet frm (x=utg,mp,co,btn,blinds) against raise from (y=utg,mp,co,btn,blinds)

is this possible? can someone pls guide me on how to go about doing this? i have read that it is not available in pt3 and we have to wait for pt4. **just have to confirm we are talking about the same thing** thanks alot!

Also i would like a fold to cbet IP AND OOP. i have gathered the information on this but not sure how to go about inserting it!


to see if ur in position on the last person to raise preflop:

holdem_hand_player_statistics.position < holdem_hand_player_detail.val_p_raise_aggressor_pos


use this on the build in stats:

cnt_f_cbet_def_action_fold_out_of_pos
sum(if[substring(lookup_actions_f.action from 1 for 1)='X' AND holdem_hand_player_statistics.enum_f_cbet_action='F', 1, 0])

cnt_f_cbet_def_action_fold_in_pos
sum(if[substring(lookup_actions_f.action from 1 for 1)<>'X' AND holdem_hand_player_statistics.enum_f_cbet_action='F', 1, 0])
time1minute
 
Posts: 1
Joined: Mon Dec 05, 2011 6:37 am

Re: Need a little help with custom stat for 3bet.

Postby kraada » Mon Dec 05, 2011 9:22 am

Those stats will not be able to be built with perfect accuracy because of the way the val_p_raise_aggressor_pos field functions. These stats will all be available by default in PT4.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


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

Who is online

Users browsing this forum: No registered users and 14 guests