Quote:
Originally Posted by Pyromantha
There were some #VALUE in the O column where you were certain to win or lose the hand - not sure if you see the same thing. I manually changed these to 0 and the corresponding N column to 1 or 0. Not sure why the formula didn't work on my version of Excel.
After I changed these I got 1.46 s.d. from the mean, not sure why that's different than your 1.49 s.d.
Is counting all hands as 0 for a loss and 1 for a win the same as calculating the variance per hand explicitly by using the actual pot-size and the possible gains or losses? It seems to me that if the pot-size is variable rather than fixed this ought to increase the variance markedly. edit. on second thoughts it appears to be definitely different. Is it possible for you to calculate these variances using the actual pot-size?
I excluded 1 and 0 allins as they don't have anything to do with luck.
Of course if you count them, you get less than 1.49.
I don't think pot size should be in the formula. For example, being a short stack on bubble, 400 chip pot is as important for you as would be 6000 pot (especially then you play DoN).
Last 560 allins it was even worse - 2 s.d. They took almost everything I won for 2 months.
Overall result: 6000+ allins, av. equity 49.34%, av. win 48.91%, 0.75 s.d.
To compensate this I have to win 52 flips in a row.
It's not the first streak. Every downstreak was steep, every upstreak flat. I gather upstreaks were not actually upstreak, rather normal play.
Anyway I don't trust the site so I've left.