Pages:
Author

Topic: Satoshi Dice -- Statistical Analysis - page 31. (Read 192889 times)

legendary
Activity: 2940
Merit: 1333
March 15, 2013, 07:33:14 PM
I just noticed "65 losses (184391-665  to 184391-739" on the "lessthan 32000" game.  That's a huge number of losses in a row.  They're all in the same block, too.

I checked, and there really were 65 losing "lessthan 32000" bets in a row in this block: http://blockexplorer.com/b/184391.  Search for 25088, which is the winning bet before the losing streak starts, then pair up the txids in the first column with the bettx column in this (large, and so not inlined) collection of screenshots: https://i.imgur.com/GhH7b2H.png
sr. member
Activity: 394
Merit: 250
March 15, 2013, 05:40:46 PM
The following addresses contributed approximately 40,000BTC to S.DICE's profits.

This is how much they have left.

Code:
                                     Remaining
15HJgkvj6roZQvNRC3pUJNKP2YgfEuD8wo      0BTC
17sjYPaYJAvtwXM2q5ojzrCiYewnQMBi9y      0BTC
1A3z7M6GhpUejQ5eqgSyjVWRuezeepdKKV      0BTC  
1B5h9sf6xNLYGa3NBk48hwYbxyNZ22PRJk      0BTC  
1DBH7Xum2re7LXd8YNSe1uRznttsqeMXGK      0BTC
1Di6ux3CQBNXCZLD76BsnYWDo6XnFGzQah      0BTC
1EP4rM8hLZCRSWPNZDWJp9zdvmoWYkkgbQ      0BTC
1MxgyKiKiHEemMUTJuq9NAbjmhKnUL5Ric      0BTC

Any questions?

Updated the stats.

I DO think there is another whale out there with at least 10k distributed across other addresses.  That guy uses a similar betting pattern to the first whale but much smaller bet sizes.
sr. member
Activity: 394
Merit: 250
hero member
Activity: 518
Merit: 500
March 15, 2013, 05:19:34 PM
Thoughts on why profits are so low this month?
legendary
Activity: 2940
Merit: 1333
March 15, 2013, 04:20:01 PM
Quote
Total of 40 bets unaccounted for.

Results: 2013-Mar-15 01:02pm (up to block 225925)

   Address  Target   Should Win |    #Bets |        Win        |   Lose  | Refunds |   BTC In   |  BTC Out   |  Refund  |   Profit  |   RTP 
----------------------------------------------------------------------------------------------------------------------------------------------
 1dice1e6p       1      0.00002 |   100325 |       1 (0.00001) |   98744 |    1580 |    1166.63 |    1280.31 |   125.77 |   -113.67 | 109.744
 1dice1Qf4       2      0.00003 |     5225 |       0 (0.00000) |    4700 |     525 |      89.45 |       0.03 |    20.46 |     89.41 |   0.041
 1dice2pxm       4      0.00006 |     7675 |       1 (0.00014) |    7221 |     453 |     117.03 |     160.00 |    12.83 |    -42.97 | 136.723
 1dice2vQo       8      0.00012 |    12104 |       5 (0.00043) |   11634 |     465 |     228.46 |     431.99 |    10.08 |   -203.53 | 189.089
 1dice2WmR      16      0.00024 |    13743 |       1 (0.00008) |   13300 |     442 |     462.33 |       4.89 |    22.07 |    457.44 |   1.058
 1dice2xkj      32      0.00049 |    17787 |       7 (0.00040) |   17378 |     402 |     969.91 |     913.99 |     1.39 |     55.91 |  94.235
 1dice2zdo      64      0.00098 |    19438 |      23 (0.00121) |   18949 |     466 |    1425.97 |     743.16 |    55.81 |    682.80 |  52.116
 1dice37Ee     128      0.00195 |    19613 |      37 (0.00193) |   19118 |     458 |    2344.05 |    1557.71 |    48.39 |    786.33 |  66.454
 1dice3jkp     256      0.00391 |    24309 |     105 (0.00439) |   23819 |     385 |    4597.55 |    7357.37 |    13.20 |  -2759.81 | 160.028
 1dice4J1m     512      0.00781 |    33646 |     272 (0.00826) |   32673 |     701 |    5739.61 |    5683.71 |    10.04 |     55.90 |  99.026
 1dice5wwE    1000      0.01526 |   118708 |    1803 (0.01526) |  116382 |     523 |   36702.76 |   32138.86 |     2.07 |   4563.89 |  87.565
 1dice61SN    1500      0.02289 |    24614 |     570 (0.02350) |   23687 |     357 |    7661.34 |    8165.60 |    15.09 |   -504.26 | 106.582
 1dice6DPt    2000      0.03052 |    74604 |    2313 (0.03117) |   71893 |     398 |   37607.70 |   33701.03 |     9.37 |   3906.66 |  89.612
 1dice6gJg    3000      0.04578 |    28792 |    1313 (0.04631) |   27041 |     438 |    9298.04 |   10070.88 |    25.18 |   -772.83 | 108.312
 1dice6GV5    4000      0.06104 |    34745 |    2114 (0.06154) |   32239 |     392 |    7645.71 |    7429.64 |    31.35 |    216.06 |  97.174
 1dice6wBx    6000      0.09155 |    47340 |    4320 (0.09213) |   42570 |     450 |   16038.75 |   17764.57 |     7.31 |  -1725.82 | 110.760
 1dice6YgE    8000      0.12207 |   183960 |   22531 (0.12282) |  160919 |     510 |   91560.16 |   90418.14 |   100.47 |   1142.02 |  98.753
 1dice7EYz   12000      0.18311 |    95039 |   17324 (0.18332) |   77175 |     540 |  170736.10 |  172786.55 |  3314.90 |  -2050.45 | 101.201
 1dice7fUk   16000      0.24414 |   245491 |   59776 (0.24406) |  185150 |     565 |  366492.13 |  352670.49 |  2322.45 |  13821.63 |  96.229
 1dice7W2A   24000      0.36621 |   246028 |   90333 (0.36805) |  155101 |     594 |  583448.72 |  575210.45 |  1013.25 |   8238.27 |  98.588
 1dice8EMZ   32000      0.48828 |  1123886 |  547732 (0.48807) |  574502 |    1652 |  875668.99 |  858077.57 |  2924.98 |  17591.42 |  97.991
 1dice97EC   32768      0.50000 |   608690 |  303604 (0.49972) |  303944 |    1142 |  661993.44 |  646089.81 |  6521.25 |  15903.63 |  97.598
 1dice9wcM   48000      0.73242 |   342642 |  251385 (0.73503) |   90621 |     636 |  299847.86 |  292335.14 |  5455.28 |   7512.72 |  97.494
 1dicec9k7   52000      0.79346 |    75401 |   59475 (0.79426) |   15406 |     520 |   61668.45 |   60388.78 |  1187.58 |   1279.67 |  97.925
 1dicegEAr   56000      0.85449 |    63660 |   54048 (0.85675) |    9037 |     575 |   77808.70 |   77185.16 |   400.55 |    623.53 |  99.199
 1diceDCd2   60000      0.91553 |    98507 |   89750 (0.91627) |    8201 |     556 |   71064.66 |   70266.66 |     0.53 |    797.99 |  98.877
 1dice9wVt   64000      0.97656 |    16828 |   15395 (0.97957) |     321 |    1112 |   24067.48 |   23654.03 |   240.21 |    413.44 |  98.282
----------------------------------------------------------------------------------------------------------------------------------------------
           small (bets < 4 BTC) |  3567880 | 1471624           | 2079711 |   16545 |  773649.61 |  759350.66 |   263.28 |  14298.94 |  98.152
            big (bets >= 4 BTC) |   114920 |   52614           |   62014 |     292 | 2642802.50 | 2587135.98 | 23628.70 |  55666.51 |  97.894
----------------------------------------------------------------------------------------------------------------------------------------------
                                |  3682800 | 1524238           | 2141725 |   16837 | 3416452.12 | 3346486.65 | 23891.99 |  69965.46 |  97.952
----------------------------------------------------------------------------------------------------------------------------------------------

SD Profit before fees:      69965.46607793 BTC (2.048%)
Cumulative Fees Paid:        2883.76007500 BTC
SD Profit after fees:       67081.70600293 BTC (1.963%)
Pending Liabilities:          -64.47836550 BTC
Final SD Profit:            67146.18436843 BTC (1.965%)
----
Since Satoshi Dice started, there have been:
Blockchain Tx: 11555723  :  SatoshiDice Tx:  6781108  (58.7%)
Blockchain MB:   4964.3  :  SatoshiDice MB:   2787.9  (56.2%)



legendary
Activity: 2940
Merit: 1333
March 15, 2013, 01:48:36 PM
Can I ask what shows up if you type the following?

$ awk '{print $3, $1}' allbets.txt | grep '^32000 ' | uniq -c | sort -n | tail
$ awk '{print $3, $1}' allbets.txt | grep '^32768 ' | uniq -c | sort -n | tail
$ awk '{print $3, $1}' allbets.txt | grep '^48000 ' | uniq -c | sort -n | tail
$ awk '{print $3, $1}' allbets.txt | grep '^52000 ' | uniq -c | sort -n | tail
$ awk '{print $3, $1}' allbets.txt | grep '^56000 ' | uniq -c | sort -n | tail
$ awk '{print $3, $1}' allbets.txt | grep '^60000 ' | uniq -c | sort -n | tail
$ awk '{print $3, $1}' allbets.txt | grep '^64000 ' | uniq -c | sort -n | tail

Quote
awk: cannot open allbets.txt (No such file or directory)

Smiley

I'm regenerating the list such that I can sort it into the order that the bets were placed rather than payout order.  That should give better numbers I think.  It will take a few hours though.

Edit: the list of bets I'm generating has the block number and transaction number within the block, so I can sort it once it's done.  I just checked a few early entries to make sure the bets were being listed right, and it showed me:

Quote
32000 5020 L 178122-8 0.04
24000 5019 L 178122-8 0.04
12000 5018 L 178122-8 0.04

ie. the 8th transaction (counting from 0) in block 178122 contains 3 bets of 0.04 BTC.  I checked this against blockchain.info (http://blockchain.info/block-index/215305/0000000000000583451e3795919b1afbc6c6b96a0da71773015999a70da6aeb7) but found that these 3 bets were in the 9th transaction, and that there were bets in the 3rd transaction which show up in my list as being the 37th transaction.  So I was worried my code is listing the transactions in the wrong order.

It turns out though that my code lists the transactions in the same order as blockexplorer (http://blockexplorer.com/block/0000000000000583451e3795919b1afbc6c6b96a0da71773015999a70da6aeb7) so it's blockchain.info that's listing the transactions in an apparently random order.

It's only got as far as last October so far, but already found sequences of 30 and 26 wins in a row at lessthan 32768, and 23 losses in a row too:

Quote
$ grep '^32768 ' allbets.txt | sort -k2n | awk '{print $3}' | uniq -c | sort -n | tail -3
     23 L
     26 W
     30 W

Edit2: It's up to December 28th now, and I've improved the code that finds the longest sequences so it tells you which block and transaction number each sequence starts and ends at:

Quote
lessthan     1      0 wins (None        to None       )      0 losses (None        to None       )
lessthan     2      0 wins (None        to None       )      0 losses (None        to None       )
lessthan     4      1 wins (213426-111  to 213426-111 )   4293 losses (177365-68   to 213425-123 )
lessthan     8      1 wins (191198-55   to 191198-55  )   1676 losses (191205-145  to 202814-661 )
lessthan    16      1 wins (191139-261  to 191139-261 )   1582 losses (176832-53   to 191139-252 )
lessthan    32      1 wins (184331-26   to 184331-26  )   3363 losses (184331-33   to 191139-252 )
lessthan    64      1 wins (184331-26   to 184331-26  )   4209 losses (191139-273  to 209097-247 )
lessthan   128      1 wins (184218-167  to 184218-167 )   3165 losses (194000-15   to 206389-210 )
lessthan   256      2 wins (208181-71   to 208181-71  )   1297 losses (210373-648  to 214001-353 )
lessthan   512      1 wins (177492-65   to 177492-65  )    564 losses (206416-327  to 207020-196 )
lessthan  1000      2 wins (180131-98   to 180136-87  )    388 losses (185647-135  to 186200-55  )
lessthan  1500      2 wins (180806-572  to 180806-574 )    221 losses (186994-57   to 187443-156 )
lessthan  2000      3 wins (190605-433  to 190605-479 )    280 losses (192015-159  to 192877-145 )
lessthan  3000      3 wins (190605-433  to 190605-479 )    274 losses (196923-121  to 197196-178 )
lessthan  4000      3 wins (187645-74   to 187668-17  )    123 losses (191201-362  to 191339-143 )
lessthan  6000     25 wins (205973-153  to 205973-153 )     86 losses (187233-224  to 187273-126 )
lessthan  8000     21 wins (212274-43   to 212274-113 )     91 losses (197734-53   to 197745-364 )
lessthan 12000     12 wins (208332-49   to 208332-313 )     73 losses (208332-469  to 208335-22  )
lessthan 16000     18 wins (203664-170  to 203664-179 )     39 losses (204260-155  to 204260-306 )
lessthan 24000     14 wins (213616-75   to 213616-1053)     22 losses (201314-281  to 201319-67  )
lessthan 32000     34 wins (184344-956  to 184345-16  )     65 losses (184391-665  to 184391-739 )
lessthan 32768     30 wins (180866-367  to 180868-167 )     24 losses (213052-220  to 213052-475 )
lessthan 48000     68 wins (182535-247  to 182536-268 )     17 losses (189347-98   to 189347-126 )
lessthan 52000     59 wins (202481-127  to 202567-150 )     13 losses (209193-229  to 209193-229 )
lessthan 56000     56 wins (193592-338  to 193614-452 )     14 losses (209941-317  to 209945-15  )
lessthan 60000    158 wins (208494-103  to 208532-864 )     21 losses (208647-415  to 208647-458 )
lessthan 64000    439 wins (180744-103  to 181691-101 )      2 losses (177069-43   to 177087-37  )

That looks like a genuine run of 30 wins on lessthan 32768.  Isn't that incredibly unlikely?  Like a 1-in-a-billion chance?

Edit3: I see a problem.  It used to be that all the bets in a single transaction would get the same lucky number.  It's also possible to bet on the same address multiple times in a single transaction.  That means you can win the same bet twice in a single transaction, and I'm counting that as 2 in a row.  See the 'lessthan 256' above - it says "2 wins (208181-71   to 208181-71)".  That's because he bet on lessthan 256 twice in the same transaction, and both bets got the same lucky number:
  http://blockchain.info/tx-index/33164014/9
  http://blockchain.info/tx-index/33164014/19
or see lines 3 and 8 here.

OK, so it's finished making the list, and I've changed the script to ignore multiple bets in a single transaction in blocks earlier than block 213879 (when the rule changed).  Here's a list of the current losest winning and losing streaks per bet:

Quote
lessthan     1       1 wins (222877-119  to 222877-119 )   85965 losses (176831-34   to 222877-118 )
lessthan     2       0 wins (None        to None       )       0 losses (None        to None       )
lessthan     4       1 wins (213426-111  to 213426-111 )    4259 losses (177365-68   to 213425-123 )
lessthan     8       1 wins (191198-55   to 191198-55  )    4946 losses (202814-664  to 217110-578 )
lessthan    16       1 wins (191139-261  to 191139-261 )    1581 losses (176832-53   to 191139-252 )
lessthan    32       1 wins (184331-26   to 184331-26  )    6360 losses (196254-318  to 219048-260 )
lessthan    64       1 wins (184331-26   to 184331-26  )    4204 losses (191139-273  to 209097-247 )
lessthan   128       1 wins (184218-167  to 184218-167 )    3158 losses (194000-15   to 206389-210 )
lessthan   256       1 wins (179750-57   to 179750-57  )    1289 losses (210373-648  to 214001-353 )
lessthan   512       1 wins (177492-65   to 177492-65  )     564 losses (206416-327  to 207020-196 )
lessthan  1000       2 wins (180131-98   to 180136-87  )     566 losses (214383-45   to 214430-239 )
lessthan  1500       2 wins (180806-572  to 180806-574 )     303 losses (222782-200  to 222904-322 )
lessthan  2000       3 wins (190605-433  to 190605-479 )     280 losses (192015-159  to 192877-145 )
lessthan  3000       3 wins (190605-433  to 190605-479 )     274 losses (196923-121  to 197196-178 )
lessthan  4000       3 wins (187645-74   to 187668-17  )     123 losses (191201-362  to 191339-143 )
lessthan  6000       4 wins (199484-177  to 199512-23  )      96 losses (221597-329  to 221986-337 )
lessthan  8000       9 wins (192997-182  to 192997-232 )      91 losses (197734-53   to 197745-364 )
lessthan 12000      12 wins (208332-49   to 208332-313 )      73 losses (208332-469  to 208335-22  )
lessthan 16000       9 wins (184483-183  to 184483-294 )      42 losses (219440-228  to 219440-350 )
lessthan 24000      14 wins (213616-75   to 213616-1053)      22 losses (201314-281  to 201319-67  )
lessthan 32000      34 wins (184344-956  to 184345-16  )      65 losses (184391-665  to 184391-739 )
lessthan 32768      30 wins (180866-367  to 180868-167 )      26 losses (216081-852  to 216081-901 )
lessthan 48000      68 wins (182535-247  to 182536-268 )      17 losses (189347-98   to 189347-126 )
lessthan 52000      59 wins (202481-127  to 202567-150 )       9 losses (213719-227  to 213720-86  )
lessthan 56000      60 wins (224067-454  to 224072-192 )       5 losses (196994-197  to 197000-76  )
lessthan 60000     146 wins (213472-454  to 213513-36  )       4 losses (210367-580  to 210367-590 )
lessthan 64000     439 wins (180744-103  to 181691-101 )       2 losses (177069-43   to 177087-37  )

So the 30 wins in a row on lessthan 32768 was real.  Even more incredible is the run of 34 wins on the slightly harder lessthan 32000 game.

Edit76: I just noticed "65 losses (184391-665  to 184391-739" on the "lessthan 32000" game.  That's a huge number of losses in a row.  They're all in the same block, too.

Here's the list of them:

Quote
betnum R  block-tx# amount
------ -  --------- ------
383948 W 184391-663 1000000

383949 L 184391-665 7812500
383950 L 184391-666 1000000
383951 L 184391-667 3000000
383952 L 184391-668 1000000
383953 L 184391-669 3000000
383954 L 184391-670 15625000
383955 L 184391-672 15625000
383956 L 184391-674 3906250
383957 L 184391-675 3906250
383958 L 184391-676 3906250
383959 L 184391-677 3906250
383960 L 184391-679 3906250
383961 L 184391-680 15625000
383963 L 184391-683 7812500
383964 L 184391-684 1000000
383965 L 184391-685 1953125
383966 L 184391-686 1953125
383967 L 184391-687 1953125
383968 L 184391-688 1953125
383969 L 184391-689 1953125
383970 L 184391-690 1953125
383971 L 184391-691 1953125
383972 L 184391-692 1953125
383973 L 184391-693 1953125
383974 L 184391-694 1953125
383975 L 184391-695 1953125
383976 L 184391-696 1953125
383977 L 184391-697 1953125
383978 L 184391-698 3906250
383979 L 184391-699 3906250
383980 L 184391-700 3906250
383981 L 184391-701 3906250
383982 L 184391-702 3906250
383983 L 184391-703 3906250
383985 L 184391-705 3906250
383986 L 184391-706 1953125
383987 L 184391-707 3906250
383988 L 184391-708 3906250
383989 L 184391-709 7812500
383990 L 184391-710 7812500
383991 L 184391-711 7812500
383992 L 184391-713 1000000
383993 L 184391-714 1000000
383994 L 184391-715 1000000
383995 L 184391-716 976563
383996 L 184391-717 976563
383997 L 184391-718 976563
383998 L 184391-719 976563
383999 L 184391-721 3906250
384000 L 184391-722 976563
384001 L 184391-723 976563
384002 L 184391-724 1953125
384003 L 184391-725 976563
384004 L 184391-726 1000000
384005 L 184391-727 7000000
384006 L 184391-728 3000000
384007 L 184391-729 976563
384008 L 184391-730 976563
384009 L 184391-731 1953125
384010 L 184391-733 976563
384011 L 184391-735 1953125
384012 L 184391-736 1953125
384013 L 184391-737 1953125
384014 L 184391-738 1953125
384015 L 184391-739 1000000

384016 W 184391-740 1000000
legendary
Activity: 3416
Merit: 1912
The Concierge of Crypto
March 14, 2013, 11:14:38 PM
Can I ask what shows up if you type the following?

$ awk '{print $3, $1}' allbets.txt | grep '^32000 ' | uniq -c | sort -n | tail
$ awk '{print $3, $1}' allbets.txt | grep '^32768 ' | uniq -c | sort -n | tail
$ awk '{print $3, $1}' allbets.txt | grep '^48000 ' | uniq -c | sort -n | tail
$ awk '{print $3, $1}' allbets.txt | grep '^52000 ' | uniq -c | sort -n | tail
$ awk '{print $3, $1}' allbets.txt | grep '^56000 ' | uniq -c | sort -n | tail
$ awk '{print $3, $1}' allbets.txt | grep '^60000 ' | uniq -c | sort -n | tail
$ awk '{print $3, $1}' allbets.txt | grep '^64000 ' | uniq -c | sort -n | tail
legendary
Activity: 2940
Merit: 1333
March 14, 2013, 06:31:02 PM
Quote
Total of 227 bets unaccounted for.

Results: 2013-Mar-14 03:27pm (up to block 225887)

   Address  Target   Should Win |    #Bets |        Win        |   Lose  | Refunds |   BTC In   |  BTC Out   |  Refund  |   Profit  |   RTP 
----------------------------------------------------------------------------------------------------------------------------------------------
 1dice1e6p       1      0.00002 |   100167 |       1 (0.00001) |   98586 |    1580 |    1164.40 |    1280.30 |   125.77 |   -115.90 | 109.954
 1dice1Qf4       2      0.00003 |     5218 |       0 (0.00000) |    4694 |     524 |      89.26 |       0.03 |    20.46 |     89.22 |   0.040
 1dice2pxm       4      0.00006 |     7672 |       1 (0.00014) |    7218 |     453 |     117.00 |     160.00 |    12.83 |    -43.00 | 136.758
 1dice2vQo       8      0.00012 |    12006 |       5 (0.00043) |   11536 |     465 |     225.43 |     431.98 |    10.08 |   -206.54 | 191.624
 1dice2WmR      16      0.00024 |    13691 |       1 (0.00008) |   13248 |     442 |     460.58 |       4.88 |    22.07 |    455.70 |   1.060
 1dice2xkj      32      0.00049 |    17634 |       6 (0.00035) |   17226 |     402 |     962.00 |     814.01 |     1.39 |    147.98 |  84.617
 1dice2zdo      64      0.00098 |    18908 |      20 (0.00108) |   18422 |     466 |    1381.03 |     573.04 |    55.81 |    807.99 |  41.494
 1dice37Ee     128      0.00195 |    19607 |      37 (0.00193) |   19112 |     458 |    2343.60 |    1557.71 |    48.39 |    785.89 |  66.467
 1dice3jkp     256      0.00391 |    24288 |     105 (0.00439) |   23798 |     385 |    4586.66 |    7357.31 |    13.20 |  -2770.64 | 160.407
 1dice4J1m     512      0.00781 |    33476 |     269 (0.00821) |   32506 |     701 |    5734.43 |    5676.18 |    10.04 |     58.24 |  98.984
 1dice5wwE    1000      0.01526 |   118489 |    1801 (0.01527) |  116165 |     523 |   36649.77 |   32115.98 |     2.07 |   4533.78 |  87.629
 1dice61SN    1500      0.02289 |    24604 |     570 (0.02351) |   23677 |     357 |    7659.72 |    8165.59 |    15.09 |   -505.86 | 106.604
 1dice6DPt    2000      0.03052 |    74504 |    2311 (0.03119) |   71795 |     398 |   37574.70 |   33693.51 |     9.37 |   3881.19 |  89.671
 1dice6gJg    3000      0.04578 |    28785 |    1312 (0.04628) |   27035 |     438 |    9268.01 |   10070.52 |    25.18 |   -802.50 | 108.659
 1dice6GV5    4000      0.06104 |    34724 |    2114 (0.06158) |   32218 |     392 |    7635.27 |    7429.59 |    31.35 |    205.68 |  97.306
 1dice6wBx    6000      0.09155 |    47311 |    4319 (0.09217) |   42542 |     450 |   16033.68 |   17762.94 |     7.31 |  -1729.25 | 110.785
 1dice6YgE    8000      0.12207 |   183640 |   22484 (0.12278) |  160646 |     510 |   91504.63 |   90361.03 |   100.47 |   1143.59 |  98.750
 1dice7EYz   12000      0.18311 |    94811 |   17289 (0.18340) |   76982 |     540 |  170640.56 |  172583.80 |  3314.90 |  -1943.23 | 101.139
 1dice7fUk   16000      0.24414 |   245006 |   59640 (0.24399) |  184801 |     565 |  366310.41 |  352426.39 |  2322.45 |  13884.01 |  96.210
 1dice7W2A   24000      0.36621 |   245693 |   90200 (0.36801) |  154900 |     593 |  583327.49 |  575041.86 |  1013.25 |   8285.62 |  98.580
 1dice8EMZ   32000      0.48828 |  1123259 |  547402 (0.48805) |  574205 |    1652 |  875003.41 |  857356.03 |  2924.98 |  17647.37 |  97.983
 1dice97EC   32768      0.50000 |   607685 |  303087 (0.49969) |  303458 |    1140 |  661647.32 |  645713.90 |  6521.25 |  15933.42 |  97.592
 1dice9wcM   48000      0.73242 |   342207 |  251049 (0.73498) |   90523 |     635 |  299745.67 |  292221.84 |  5455.28 |   7523.82 |  97.490
 1dicec9k7   52000      0.79346 |    75205 |   59307 (0.79408) |   15379 |     519 |   61646.26 |   60365.25 |  1187.57 |   1281.00 |  97.922
 1dicegEAr   56000      0.85449 |    63499 |   53911 (0.85676) |    9013 |     575 |   77787.59 |   77163.64 |   400.55 |    623.94 |  99.198
 1diceDCd2   60000      0.91553 |    98251 |   89515 (0.91626) |    8181 |     555 |   71019.90 |   70220.86 |     0.52 |    799.04 |  98.875
 1dice9wVt   64000      0.97656 |    16795 |   15364 (0.97960) |     320 |    1111 |   24062.03 |   23648.80 |   240.21 |    413.22 |  98.283
----------------------------------------------------------------------------------------------------------------------------------------------
           small (bets < 4 BTC) |  3562285 | 1469540           | 2076208 |   16537 |  772753.11 |  758256.04 |   263.26 |  14497.07 |  98.124
            big (bets >= 4 BTC) |   114850 |   52580           |   61978 |     292 | 2641827.81 | 2585941.06 | 23628.70 |  55886.75 |  97.885
----------------------------------------------------------------------------------------------------------------------------------------------
                                |  3677135 | 1522120           | 2138186 |   16829 | 3414580.93 | 3344197.10 | 23891.96 |  70383.82 |  97.939
----------------------------------------------------------------------------------------------------------------------------------------------

SD Profit before fees:      70383.82618517 BTC (2.061%)
Cumulative Fees Paid:        2878.06757500 BTC
SD Profit after fees:       67505.75861017 BTC (1.977%)
Pending Liabilities:           82.72401753 BTC
Final SD Profit:            67423.03459264 BTC (1.975%)
----
Since Satoshi Dice started, there have been:
Blockchain Tx: 11540074  :  SatoshiDice Tx:  6771690  (58.7%)
Blockchain MB:   4956.9  :  SatoshiDice MB:   2783.8  (56.2%)



legendary
Activity: 2940
Merit: 1333
March 14, 2013, 06:10:02 PM
I started producing a list of all the bets to find the longest winning and losing chains and found a problem:

SatoshiDice has at times in the past run low on confirmed funds in their hot wallet.  When this happens, they can easily pay out losing bets (since all they need to do that is the incoming bet itself), but they have to wait before they can pay out winning bets.  This results in large groups of consecutive bets with the same result.

I've only looked through a fraction of the bets and already found a chain of 319 losing "lessthan 32000" bets in a row, and also a chain of 287 winning "lessthan 32000" bets in a row.

This makes me think it's not worth continuing with this analysis, since it doesn't tell us anything other than that SatoshiDice sometimes bunches winning bets together.

Here's the progress so far.  In less than 400k bets I see all these chains:

Quote
$ awk '{print $3, $1}' allbets.txt | grep '^32000 ' | wc -l
389412

$ awk '{print $3, $1}' allbets.txt | grep '^32000 ' | uniq -c | sort -n | tail
    131 32000 W
    133 32000 W
    135 32000 W
    135 32000 W
    140 32000 W
    150 32000 W
    189 32000 W
    208 32000 W
    287 32000 W
    319 32000 L
donator
Activity: 2058
Merit: 1007
Poor impulse control.
March 14, 2013, 03:03:30 AM
Hi,

I got the latest numbers from dooglus post and tried the theoretical formula for consecutive losses in a row and came up with this.

bets     p-win   q-lose  loss-row
604294   0.5     0.5     18.20489587
1118230  0.48828 0.51172 19.71766168
244037   0.36621 0.63379 24.99911792
243386   0.24414 0.75586 39.27274907
94075    0.18311 0.81689 48.22841691
182495   0.12207 0.87793 76.89902593


So, those playing the 50% game can expect to lose 18 or 19 times in a row if they played that game since the beginning. Those playing the other games can expect to lose much more.

Quote
1. Let total number of times you want to make a bet on this game = "bets".
2. p is probability of winning the game you're playing, q is the probability of losing the same game, q = 1 - p
3. Then expected losses in a row = -log(bets*p + 1)/log(q)

Did I do this correctly?

It looks fine, as long as you have the win/lose probabilities right.

You can also calculate the expected number of rolls before n losses in a row:

Code:
n = -log(bets*p + 1)/log(q)

n = expected losses in a row
bets = number of bets
p = probability of winning the game
q = 1 - p

So
-n*log(q) = log(bets*p + 1)
(1/q)^n = bets*p + 1

Expected number of bets before n losses in a row = (q^(-n) - 1) / p

I've seen a few methods of proving this. The one I have to hand uses Markov chains and is a bit dense, and I can't find the other which is more inuitive to follow. If I find it I'll post it.


legendary
Activity: 3416
Merit: 1912
The Concierge of Crypto
March 13, 2013, 08:54:51 PM
Hi,

I got the latest numbers from dooglus post and tried the theoretical formula for consecutive losses in a row and came up with this.

bets     p-win   q-lose  loss-row
604294   0.5     0.5     18.20489587
1118230  0.48828 0.51172 19.71766168
244037   0.36621 0.63379 24.99911792
243386   0.24414 0.75586 39.27274907
94075    0.18311 0.81689 48.22841691
182495   0.12207 0.87793 76.89902593


So, those playing the 50% game can expect to lose 18 or 19 times in a row if they played that game since the beginning. Those playing the other games can expect to lose much more.

Quote
1. Let total number of times you want to make a bet on this game = "bets".
2. p is probability of winning the game you're playing, q is the probability of losing the same game, q = 1 - p
3. Then expected losses in a row = -log(bets*p + 1)/log(q)

Did I do this correctly?
legendary
Activity: 2940
Merit: 1333
March 13, 2013, 05:54:05 PM
Those colourful violin plots are very nice.  Smiley 

Meanwhile, back to the regular ugly graphs...

Quote
Total of 81 bets unaccounted for.

Results: 2013-Mar-13 02:23pm (up to block 225709)

   Address  Target   Should Win |    #Bets |        Win        |   Lose  | Refunds |   BTC In   |  BTC Out   |  Refund  |   Profit  |   RTP 
----------------------------------------------------------------------------------------------------------------------------------------------
 1dice1e6p       1      0.00002 |    99299 |       1 (0.00001) |   97728 |    1570 |    1148.91 |    1280.22 |   125.02 |   -131.31 | 111.429
 1dice1Qf4       2      0.00003 |     5203 |       0 (0.00000) |    4680 |     523 |      88.80 |       0.03 |    20.45 |     88.77 |   0.038
 1dice2pxm       4      0.00006 |     7650 |       1 (0.00014) |    7196 |     453 |     116.02 |     160.00 |    12.83 |    -43.98 | 137.909
 1dice2vQo       8      0.00012 |    11977 |       5 (0.00043) |   11510 |     462 |     224.75 |     431.97 |    10.07 |   -207.22 | 192.203
 1dice2WmR      16      0.00024 |    13667 |       1 (0.00008) |   13225 |     441 |     459.72 |       4.87 |    22.07 |    454.84 |   1.061
 1dice2xkj      32      0.00049 |    17583 |       6 (0.00035) |   17176 |     401 |     960.20 |     814.00 |     1.39 |    146.19 |  84.775
 1dice2zdo      64      0.00098 |    18802 |      20 (0.00109) |   18318 |     464 |    1373.62 |     573.00 |    55.81 |    800.62 |  41.715
 1dice37Ee     128      0.00195 |    19574 |      37 (0.00194) |   19079 |     458 |    2339.11 |    1557.69 |    48.39 |    781.42 |  66.593
 1dice3jkp     256      0.00391 |    24252 |     105 (0.00440) |   23763 |     384 |    4580.14 |    7357.28 |    13.20 |  -2777.14 | 160.634
 1dice4J1m     512      0.00781 |    33412 |     268 (0.00819) |   32444 |     700 |    5728.28 |    5673.66 |    10.03 |     54.62 |  99.046
 1dice5wwE    1000      0.01526 |   117777 |    1787 (0.01524) |  115468 |     522 |   36563.46 |   32007.45 |     2.07 |   4556.00 |  87.539
 1dice61SN    1500      0.02289 |    24571 |     570 (0.02354) |   23645 |     356 |    7656.00 |    8165.57 |    15.09 |   -509.57 | 106.656
 1dice6DPt    2000      0.03052 |    74115 |    2295 (0.03113) |   71422 |     398 |   37546.55 |   33664.34 |     9.37 |   3882.21 |  89.660
 1dice6gJg    3000      0.04578 |    28754 |    1309 (0.04623) |   27007 |     438 |    9216.93 |   10005.02 |    25.18 |   -788.09 | 108.550
 1dice6GV5    4000      0.06104 |    34595 |    2111 (0.06172) |   32092 |     392 |    7615.02 |    7422.49 |    31.35 |    192.53 |  97.472
 1dice6wBx    6000      0.09155 |    47213 |    4314 (0.09224) |   42453 |     446 |   16023.99 |   17754.90 |     7.29 |  -1730.91 | 110.802
 1dice6YgE    8000      0.12207 |   182495 |   22345 (0.12278) |  159640 |     510 |   91427.22 |   90252.05 |   100.47 |   1175.16 |  98.715
 1dice7EYz   12000      0.18311 |    94075 |   17150 (0.18335) |   76389 |     536 |  170500.40 |  172503.68 |  3314.89 |  -2003.28 | 101.175
 1dice7fUk   16000      0.24414 |   243386 |   59221 (0.24388) |  183604 |     561 |  366002.29 |  352136.29 |  2322.43 |  13866.00 |  96.211
 1dice7W2A   24000      0.36621 |   244037 |   89577 (0.36796) |  153867 |     593 |  583031.35 |  574788.43 |  1013.25 |   8242.92 |  98.586
 1dice8EMZ   32000      0.48828 |  1118230 |  544976 (0.48807) |  571607 |    1647 |  872360.39 |  854669.94 |  2924.95 |  17690.45 |  97.972
 1dice97EC   32768      0.50000 |   604294 |  301452 (0.49979) |  301711 |    1131 |  660037.16 |  643964.23 |  6521.23 |  16072.92 |  97.565
 1dice9wcM   48000      0.73242 |   340319 |  249684 (0.73504) |   90002 |     633 |  298705.42 |  291222.38 |  5455.27 |   7483.03 |  97.495
 1dicec9k7   52000      0.79346 |    74537 |   58760 (0.79383) |   15261 |     516 |   61463.64 |   60155.50 |  1187.55 |   1308.14 |  97.872
 1dicegEAr   56000      0.85449 |    63042 |   53532 (0.85696) |    8935 |     575 |   77608.81 |   76990.19 |   400.55 |    618.62 |  99.203
 1diceDCd2   60000      0.91553 |    96782 |   88168 (0.91620) |    8064 |     550 |   70754.87 |   69949.74 |     0.52 |    805.13 |  98.862
 1dice9wVt   64000      0.97656 |    16654 |   15234 (0.97962) |     317 |    1103 |   24018.55 |   23606.13 |   240.21 |    412.42 |  98.283
----------------------------------------------------------------------------------------------------------------------------------------------
           small (bets < 4 BTC) |  3541669 | 1460455           | 2064743 |   16471 |  769737.69 |  755242.21 |   262.34 |  14495.48 |  98.117
            big (bets >= 4 BTC) |   114626 |   52474           |   61860 |     292 | 2637814.03 | 2581868.96 | 23628.70 |  55945.06 |  97.879
----------------------------------------------------------------------------------------------------------------------------------------------
                                |  3656295 | 1512929           | 2126603 |   16763 | 3407551.72 | 3337111.17 | 23891.04 |  70440.55 |  97.933
----------------------------------------------------------------------------------------------------------------------------------------------

SD Profit before fees:      70440.55165630 BTC (2.067%)
Cumulative Fees Paid:        2857.17677500 BTC
SD Profit after fees:       67583.37488130 BTC (1.983%)
Pending Liabilities:          -57.51910827 BTC
Final SD Profit:            67640.89398957 BTC (1.985%)
----
Since Satoshi Dice started, there have been:
Blockchain Tx: 11481028  :  SatoshiDice Tx:  6734316  (58.7%)
Blockchain MB:   4930.3  :  SatoshiDice MB:   2768.0  (56.1%)



donator
Activity: 2058
Merit: 1007
Poor impulse control.
March 13, 2013, 05:24:30 PM
Amazing charts OoC, does GGplot let you do multiple axes? It would be good to overlay a line showing total number of bets per month, or perhaps median number per day as well as max/day and min/day for each month.

ggplot doesn't do multiple axes. I read (I think) that the devs planned on support for multiple axes when the axes scale linearly to each other, but they don't plan on the sort of multiple axes you're thinking of. I ccould annotate the chart with the actual numbers, but that's not very pretty.

So, number of bets as well as volume of betting? I have a think about it. I hadn't considered that, although it's might be interesting data to have.
legendary
Activity: 1316
Merit: 1005
March 13, 2013, 04:26:05 PM
I played around and got some quite beautiful tile plots and contour plots, but they didn't really help show bet size of volume trends. Then I realised that all I had to do was use the proportional violin plots and use colour as a guide to the volume. I hope this works for you. Please don't tell me you're colour blind - I didn't use the colour blind palette.

If the 2-3 month cycles are valid and hold, May-June ought to be the start of a very active period.
hero member
Activity: 728
Merit: 500
March 13, 2013, 12:56:29 PM
Amazing charts OoC, does GGplot let you do multiple axes? It would be good to overlay a line showing total number of bets per month, or perhaps median number per day as well as max/day and min/day for each month.
donator
Activity: 2058
Merit: 1007
Poor impulse control.
March 13, 2013, 12:36:04 PM
I played around and got some quite beautiful tile plots and contour plots, but they didn't really help show bet size of volume trends. Then I realised that all I had to do was use the proportional violin plots and use colour as a guide to the volume. I hope this works for you. Please don't tell me you're colour blind - I didn't use the colour blind palette.

The two below just use different colour schema.




donator
Activity: 2058
Merit: 1007
Poor impulse control.
March 13, 2013, 04:00:11 AM
Very nice graphs.  The 2nd one reminds me of big scary needles rather than violins.

1. The number and size of Bets on SatoshiDice are increasing;

Is that true?  They increased for a few months Dec 2012 to early Feb this year, but other than that has there been an upwards trend?

A version of your first graph with the horizontal scale magnified about x10 would let us see that - just truncate the high values while the whale was playing.


I plotted your request below - normalising to the volume of bets under 50btc (as an arbitrary cut off). I also plotted all bets before December, to make those trends a bit more obvious, too. Tbh, I should have written "the size and volume of bets in December 2012, January 2013 and February 2013 have increased compared to the previous months". Even so, it's not obvious from the plots.

I'm working on something similar to the "percentile" plots I did that will hopefully show this sort of information in a more intuitive and cntinuous way than either the violin - er scary hypodermic needle - plots or the percentile plots. Hopefully I'll be able to post it tonight.




legendary
Activity: 3416
Merit: 1912
The Concierge of Crypto
March 13, 2013, 12:35:35 AM
Sorry, I was stressed out with other business yesterday when you posted about this.

One problem with your request is that there's not really a definitive ordering on the bets.  Do we count the time the bet transaction was seen by some random host on the network?  Or the timestamp on the block it got into?  Or the depth of the block?  (Blocks aren't always in order of timestamp).  Or do we count the order that the bets were paid out?

There are lots of different ways of ordering the bets, which will change the longest sequence of losses.

Another problem, and what puts me off from looking into this, is "who cares".  Are you wanting the information to check whether the dice rolls are random?  ie. "we would expect to see a chain of 10 losses but the longest chain is 20 so SDICE is cheating"?  Because other than that I don't really see the point.  Runs of good and bad luck happen, due to the random nature of the dice rolls.  Suppose I go through the blockchain and find that once there were 21 losses on the 50% game in a row, given some arbitrary ordering of the bets.  Then what?

I guess I'll do this when I'm bored, but I don't expect it to tell us anything very useful or interesting.  Maybe I'm just being grouchy though.  That happens too.  Smiley

Thanks for the tip organofcorti - that's very kind of you.  Smiley

Hi, Sorry for adding to the stress. I guess you just pick one way of ordering it, and use that for consistency. Actually, a real world example of a 50% game had 26 losses in a row, in a casino.

If you're bored ... you can do this. When you got more bored, you can also do the different ways of ordering.

I don't know if it will tell us anything useful, but I think it will be interesting. And the minute you post your analysis, all the gamblers who are reading this thread will suddenly start betting a little bit more, thinking that they can attempt 21 consecutive attempts to martinegale from 0.01 to 500. (I just might do it, hehe.)

If you're being grouchy, let me know what I need to download and I will try to do this. (Or at least someone else will, so you have less stress.)

Unfortunately, I'm on a crappy OS machine (windows), so I don't know if it's even possible.
legendary
Activity: 1316
Merit: 1005
March 12, 2013, 07:50:08 PM
They didnt shut off betting, just payouts afaik.
I think my graph only shows payouts though.  It ignores bets until they have been paid out.

It seems to be as expected since the analysis is done by block - a chart of betting would've levelled off for ~6 hours or so, but payouts would follow the consistent climb. Transactions still had to be processed into the blockchain block by block.
legendary
Activity: 2940
Merit: 1333
March 12, 2013, 05:32:56 PM
They didnt shut off betting, just payouts afaik.

I think my graph only shows payouts though.  It ignores bets until they have been paid out.
Pages:
Jump to: