Page 1 of 1

A Couple of stats needed

PostPosted: Sun Nov 25, 2012 8:56 pm
by Northern Monkey
Hey, im not sure if i'm just not seeing these or understanding an easy way to have them, but any help appreciated with the finding of a;

Fold to squeeze (after cold calling a pfr)

and

isolate limper (on btn) % stats,

Thanks in advance.

Re: A Couple of stats needed

PostPosted: Mon Nov 26, 2012 10:15 am
by kraada
The former doesn't exist as a default statistic but it can certainly be built. You'd start with the built in stat Fold to PF Squeeze and you'd want to edit the columns to include:
((cash_hand_player_statistics.flg_p_limp and lookup_actions_p.action LIKE 'CC%') OR (NOT(cash_hand_player_statistics.flg_p_limp) and lookup_actions_p.action LIKE 'C%'))

Please see this guide for more detail on how to use this advice to build your custom statistic - everything else you need is there.

Re: A Couple of stats needed

PostPosted: Tue Nov 27, 2012 2:11 pm
by Northern Monkey
Thanks Kraada, will give it a bash :)

Re: A Couple of stats needed

PostPosted: Tue Nov 27, 2012 2:39 pm
by Northern Monkey
Right having a hard time here but would this work?

(cnt_p_3bet_opp AND cnt_p_ccall AND cnt_p_squeeze_def_fold / cnt_p_squeeze_def_opp) * 100

Something doesnt feel right if i've got it correct first try, thanks.

Re: A Couple of stats needed

PostPosted: Tue Nov 27, 2012 4:07 pm
by kraada
You're confusing columns and stats - what I'm suggesting is to create new columns on the Columns page, and add in the piece of code listed above. Then you use those new columns in the stat - that's where you do the dividing and multiplying by 100.

Take a look at this tutorial which, while it was written for PT3, has a lot of the basics that can help you understand how we do things. The interface is a little different (as are the column names), but the underlying logic is the same.

highfalutin