Re: Swing question for people who play lots of hands
[ QUOTE ]
if you want a SD/100 hands, it should take hands in increments of 100 hands, and find a SD per 100-hand block. it does not do this.
[/ QUOTE ]
I think the easiest way would be to calculate SD per hand, and then multiply by 10 to get SD/100.
( Because SD/(Y hands) = SQRT(Y/X) * SD/(X hands) )
I tried this in Excel, by going to game notes, clicking get all, then click the "p", then export to excel, etc.
Just take the whole BB_won column and do an =STDEV(firstcell:lastcell)
I got a SD/hand of 1.47, for an SD/100 of 14.7. PT gives my SD/100 as 15.6.
That was for a 4400 hand sample.
For a 31000 hand sample I get: Excel: 13.9, PT: 14.4
For a 55000 hand sample I get: Excel: 13.8, PT: 14.1
That was about the most it would let me export. Looks like the two methods converge as the sample gets larger and larger.
|