Create a stat for Check / Call OOP

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

Create a stat for Check / Call OOP

Postby Hidro_Tracker » Fri Apr 29, 2011 10:54 am

Hi, I tried to create a statistic to determine when an opponent plays Check / Call on any street. I created the following stat for the flop:

"cnt_f_check AND cnt_f_bet_def_action_call"

but the result back to me the HUD is "true"or "false" instead of the number of times you have made ​​the move / by the number of opportunities he has had.

I imagine that I create a column for the result, but can not find a way.

Anybody can help me?

Thanks and regards.
Hidro_Tracker
 
Posts: 72
Joined: Thu Apr 22, 2010 12:50 pm

Re: Create a stat for Check / Call OOP

Postby kraada » Fri Apr 29, 2011 11:16 am

You want to create this stat in the Player Statistics section if you want a count of how many times he did it.

You can then build the column with the definition:

sum(if[ lookup_actions_f.action LIKE 'XC%', 1, 0])

That will count up how many times someone checked the flop and called a bet (the % means anything else can happen after that).

If you want the opportunities column you can use:

sum(if[ lookup_actions_f.action LIKE 'X_%', 1, 0])

'_' means something goes here but it can be anything - this implies the player definitely took a second flop action.

For more on creating custom statistics and reports please see this tutorial.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Create a stat for Check / Call OOP

Postby Hidro_Tracker » Fri Apr 29, 2011 2:34 pm

Hello, thank you very much, the stat works perfectly. I tried many times to read my tutorial for setting up stats and columns, but my English is very basic. It would be great to have a tutorial in Spanish ;)

Thanks for all, greetings.
Hidro_Tracker
 
Posts: 72
Joined: Thu Apr 22, 2010 12:50 pm

Re: Create a stat for Check / Call OOP

Postby kraada » Fri Apr 29, 2011 2:55 pm

Unfortunately my Spanish is not good enough to write one but hopefully it'll be something we can add at some point further in the future.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Create a stat for Check / Call OOP

Postby Hidro_Tracker » Fri Apr 29, 2011 3:28 pm

I'll wait, and I think will be something that I can give you useful stats and share with the community.

Greetings.
Hidro_Tracker
 
Posts: 72
Joined: Thu Apr 22, 2010 12:50 pm


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

Who is online

Users browsing this forum: No registered users and 6 guests