View Single Post
  #14  
Old 10-05-2005, 04:57 AM
TimM TimM is offline
Senior Member
 
Join Date: Jan 2004
Location: New York
Posts: 147
Default 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.
Reply With Quote