standard deviation of average three bet percentage

[skeetymcGrinder]

Hey guys,

Does anyone know how I can query my database to get the standard deviation for a global variable, let's say three bet percentage? Is there a loop or command series that the program uses in graph creation that would output standard deviation of the global data series? I'm by no means an expert at SQL.

The mean seems easy enough to find from the "My Reports" tab, but I wouldn't mind seeing how to query it from the database if there are any SQL savants out there.

Thanks guys,

SMG

[kraada]

Is this for PT3 or PT4? You posted in the PT3 forum but talk about the interface in a way that makes it sound like you're dealing with PT4.

[skeetymcGrinder]

Oh, whoops! Yes, it's for PT4. Sorry for the confusion.

SMG

[kraada]

The easiest way to get this kind of data is going to be straight from the database using our cache.

You can find the columns you need to reference in the Configure --> Statistics area by looking at the Value Expression of the Stat you want to get the data from.

For 3Bet percentage the query you'd want is:

SELECT stddev(cnt_p_3bet / cnt_p_3bet_opp) from cash_cache WHERE cnt_p_3bet_opp > 0;

You need to use the > 0 bit to avoid division by 0 errors. You should get the results in under a second.

[Powaqqatsi]

Hi,

That is great information. Is it possible to do that same query but then add an effective stack? So for instance the standard deviation for 3-bet% where the effective stack is 11BB-13BB.

Thanks,
Marcel

[kraada]

No, that's not possible I'm afraid. You'd need to do something a lot more complicated to make that happen by using subselects to get your dataset instead of using direct comparisons to the cache table.