Top 20 days for Bitcoin

[JANGKRIK BOSS]

1  2013-11-30  1132.29

It looks like a record that will soon be passed, so I dare to sell some gold stock I have for purchase a bitcoin. I'm sure the prices will keep going up bitcoin as many media preach something nice about bitcoin.

[dooglus]

i hope it is ok with you that i copied your idea. if not, i will delete.  

It wasn't my idea, but it's fine with me. You could post in this thread instead of a separate one if you like.

[600watt]

update:

1   2017-01-04   1045.93
2   2017-02-08   983.77
3   2017-01-03   978.51
4   2017-02-07   977.62
5   2017-01-05   969.07
6   2017-01-02   967.42
7   2017-02-06   953.53
8   2017-02-04   951.3
9   2017-02-11   948.41
10  2017-02-05   945.54
11  2017-02-03   942.26
12  2017-01-01   937.48
13  2017-02-09   932.77
14  2016-12-29   927.36
15  2017-02-02   926.1
16  2016-12-28   920.82
17  2017-02-10   916.73
18  2016-12-31   909.36
19  2017-02-01   908.15
20  2016-12-30   904.97

all the 800 values have been kicked out since last update. a slight majority of the €uro top 20 was scored within the last month (11 out of 20). the oldest value on list is just 6/7 weeks in the past. 
 

[qwk]

in €uroland dates are noted usually noted like: 31.12.2016 as opposed to 2016-12-31
i tried to come up with a notation that keeps confusion low. i hope it is readable.

xkcd 1179

[dooglus]

Update:

 1  2013-11-30  1132.29 USD
 2  2013-12-04  1111.56 USD
 3  2017-01-04  1088.45 USD
 4  2013-11-29  1065.36 USD
 5  2013-12-03  1050.57 USD
 6  2017-02-07  1043.50 USD
 7  2017-02-04  1022.99 USD
 8  2017-02-06  1021.23 USD
 9  2017-01-03  1020.56 USD
10  2017-02-05  1015.96 USD
11  2017-01-02  1013.00 USD
12  2017-02-03  1009.32 USD
13  2017-01-05  1005.35 USD
14  2013-12-02  1000.49 USD
15  2013-11-28   998.56 USD
16  2017-02-02   994.32 USD
17  2017-01-01   987.47 USD
18  2013-12-05   975.06 USD
19  2017-02-01   970.40 USD
20  2016-12-29   967.02 USD

[dooglus]

17  dec. 31. 2017   885.64

How confident are you in this prediction?

But seriously, you might consider using a script to generate your reports. I posted mine in this thread not long ago, and here it is again:

Code:

vwap() {
    days=1200
    top=20
    currency=USD
    rows=$(wget -o/dev/null -O- "http://bitcoincharts.com/charts/chart.json?m=bitstampUSD&r=$days&i=Daily" |
                  sed 's/], \[/\n/g'   |
                  head -n $((days-1))  |
                  tr -d '[],'          |
                  awk '{print $1, $8}' |
                  sort -k2nr           |
                  head -$top
        )
    newest=$(echo "$rows" | sort -n | tail -1 | awk '{print $1}')
    printf "Update:\n[pre]\n"
    n=1
    month_ago=$(($(date +%s) - 60*60*24*32))
    echo "$rows" |
        while read t p
        do
            if ((t > month_ago)); then b1="[b]"            ; b2="[/b]"    ; else b1=""; b2=""; fi
            if ((t == newest))   ; then c1="[color=#7F0000]"; c2="[/color]"; else c1=""; c2=""; fi
            printf "%s%s%2d  %s  %7.2f $currency%s%s\n" "$b1" "$c1" $n "$(TZ= date -d @$t +%Y-%m-%d)" $p "$c2" "$b2"
            ((n++))
        done
    printf "[/pre]\n"
}

You should be able to adapt that to work for Euros.

Edit: note that bold font is used for prices less than a month old.

Edit2: I second qwk's proposal to use ISO 8601 for date formats. It makes sense because writing the most significant information first (the year) and the least significant last (the day of the month) matches how we write numbers - (hundreds first, units last), so sorting alphabetically also sorts into date order.

[600watt]

17  dec. 31. 2017   885.64

How confident are you in this prediction?

But seriously, you might consider using a script to generate your reports. I posted mine in this thread not long ago, and here it is again:

Code:

vwap() {
    days=1200
    top=20
    currency=USD
    rows=$(wget -o/dev/null -O- "http://bitcoincharts.com/charts/chart.json?m=bitstampUSD&r=$days&i=Daily" |
                  sed 's/], \[/\n/g'   |
                  head -n $((days-1))  |
                  tr -d '[],'          |
                  awk '{print $1, $8}' |
                  sort -k2nr           |
                  head -$top
        )
    newest=$(echo "$rows" | sort -n | tail -1 | awk '{print $1}')
    printf "Update:\n[pre]\n"
    n=1
    month_ago=$(($(date +%s) - 60*60*24*32))
    echo "$rows" |
        while read t p
        do
            if ((t > month_ago)); then b1="[b]"            ; b2="[/b]"    ; else b1=""; b2=""; fi
            if ((t == newest))   ; then c1="[color=#7F0000]"; c2="[/color]"; else c1=""; c2=""; fi
            printf "%s%s%2d  %s  %7.2f $currency%s%s\n" "$b1" "$c1" $n "$(TZ= date -d @$t +%Y-%m-%d)" $p "$c2" "$b2"
            ((n++))
        done
    printf "[/pre]\n"
}

You should be able to adapt that to work for Euros.

Edit: note that bold font is used for prices less than a month old.

Edit2: I second qwk's proposal to use ISO 8601 for date formats. It makes sense because writing the most significant information first (the year) and the least significant last (the day of the month) matches how we write numbers - (hundreds first, units last), so sorting alphabetically also sorts into date order.

thanks for correcting, edited post.

i will change to ISO 8601

[dooglus]

Update:

 1  2013-11-30  1132.29 USD
 2  2013-12-04  1111.56 USD
 3  2017-01-04  1088.45 USD
 4  2013-11-29  1065.36 USD
 5  2013-12-03  1050.57 USD
 6  2017-02-08  1045.63 USD
 7  2017-02-07  1043.50 USD
 8  2017-02-04  1022.99 USD
 9  2017-02-06  1021.23 USD
10  2017-01-03  1020.56 USD
11  2017-02-05  1015.96 USD
12  2017-01-02  1013.00 USD
13  2017-02-03  1009.32 USD
14  2017-01-05  1005.35 USD
15  2013-12-02  1000.49 USD
16  2013-11-28   998.56 USD
17  2017-02-02   994.32 USD
18  2017-01-01   987.47 USD
19  2013-12-05   975.06 USD
20  2017-02-01   970.40 USD

[JayJuanGee]

Update:

 1  2013-11-30  1132.29 USD
 2  2013-12-04  1111.56 USD
 3  2017-01-04  1088.45 USD
 4  2013-11-29  1065.36 USD
 5  2013-12-03  1050.57 USD
 6  2017-02-08  1045.63 USD
 7  2017-02-07  1043.50 USD
 8  2017-02-04  1022.99 USD
 9  2017-02-06  1021.23 USD
10  2017-01-03  1020.56 USD
11  2017-02-05  1015.96 USD
12  2017-01-02  1013.00 USD
13  2017-02-03  1009.32 USD
14  2017-01-05  1005.35 USD
15  2013-12-02  1000.49 USD
16  2013-11-28   998.56 USD
17  2017-02-02   994.32 USD
18  2017-01-01   987.47 USD
19  2013-12-05   975.06 USD
20  2017-02-01   970.40 USD

Hey dooglus:

Were you maintaining a 50 day list too, or not?  Maybe too much work to maintain that many days, but this 20 day list is starting to seem a bit inadequate and also is starting to appear that little by little all of the top 20 days are being replaced by dates in 2017... maybe that is not a problem, but it would seem a bit more informative to have some older dates in the mix, as well, no?

[dooglus]

Hey dooglus:

Were you maintaining a 50 day list too, or not?  Maybe too much work to maintain that many days, but this 20 day list is starting to seem a bit inadequate and also is starting to appear that little by little all of the top 20 days are being replaced by dates in 2017... maybe that is not a problem, but it would seem a bit more informative to have some older dates in the mix, as well, no?

I'm not actually 'maintaining' any lists. I'm recreating the list from scratch each day, relying on stats from bitcoincharts.com.

I make the list long enough to include the last day's price. If the last day's price is in the top 20 then I only post the top 20. Otherwise I round up to a multiple of 5. Once yesterday's price isn't in the top 50 I go back into hibernation...

[dooglus]

Update:

 1  2013-11-30  1132.29 USD
 2  2013-12-04  1111.56 USD
 3  2017-01-04  1088.45 USD
 4  2013-11-29  1065.36 USD
 5  2013-12-03  1050.57 USD
 6  2017-02-08  1045.63 USD
 7  2017-02-07  1043.50 USD
 8  2017-02-04  1022.99 USD
 9  2017-02-06  1021.23 USD
10  2017-01-03  1020.56 USD
11  2017-02-05  1015.96 USD
12  2017-01-02  1013.00 USD
13  2017-02-03  1009.32 USD
14  2017-01-05  1005.35 USD
15  2013-12-02  1000.49 USD
16  2013-11-28   998.56 USD
17  2017-02-09   996.61 USD
18  2017-02-02   994.32 USD
19  2017-01-01   987.47 USD
20  2013-12-05   975.06 USD

[JayJuanGee]

Hey dooglus:

Were you maintaining a 50 day list too, or not?  Maybe too much work to maintain that many days, but this 20 day list is starting to seem a bit inadequate and also is starting to appear that little by little all of the top 20 days are being replaced by dates in 2017... maybe that is not a problem, but it would seem a bit more informative to have some older dates in the mix, as well, no?

I'm not actually 'maintaining' any lists. I'm recreating the list from scratch each day, relying on stats from bitcoincharts.com.

I make the list long enough to include the last day's price. If the last day's price is in the top 20 then I only post the top 20. Otherwise I round up to a multiple of 5. Once yesterday's price isn't in the top 50 I go back into hibernation...

I only recently came across this thread, but I find the concept quite interesting to post a top 20 of the daily average, rather than just what the price may have reached at any one snap-shot in time.

At the same time, it stirs in me a lot of other ways that similar questions can be post to give slightly differing views of the data... like I mention the top 50 daily averages.  Also could be top 20 3 day averages or top 20 weekly averages... I know that any of this would be a bit of work, but just gets me a bit curious to think about those other variations on the data set and speculation about reading the time periods in different ways.

[dooglus]

Update:

 1  2013-11-30  1132.29 USD
 2  2013-12-04  1111.56 USD
 3  2017-01-04  1088.45 USD
 4  2013-11-29  1065.36 USD
 5  2013-12-03  1050.57 USD
 6  2017-02-08  1045.63 USD
 7  2017-02-07  1043.50 USD
 8  2017-02-04  1022.99 USD
 9  2017-02-06  1021.23 USD
10  2017-01-03  1020.56 USD
11  2017-02-05  1015.96 USD
12  2017-01-02  1013.00 USD
13  2017-02-03  1009.32 USD
14  2017-01-05  1005.35 USD
15  2013-12-02  1000.49 USD
16  2013-11-28   998.56 USD
17  2017-02-09   996.61 USD
18  2017-02-02   994.32 USD
19  2017-01-01   987.47 USD
20  2017-02-10   977.66 USD

[edgar]

only 6 spots for 2013 remaining...

only 5 spots left under a thousand usd...

...

swiggety swooty!!

[600watt]

€uro update:

1   2017-01-04   1045.93
2   2017-02-08   983.77
3   2017-01-03   978.51
4   2017-02-07   977.62
5   2017-01-05   969.07
6   2017-01-02   967.42
7   2017-02-06   953.53
8   2017-02-04   951.3
9   2017-02-11   948.41
10  2017-02-05   945.54
11  2017-02-03   942.26
12  2017-01-01   937.48
13  2017-02-09   932.77
14  2016-12-29   927.36
15  2017-02-02   926.1
16  2016-12-28   920.82
17  2017-02-10   916.73
18  2016-12-31   909.36
19  2017-02-01   908.15
20  2016-12-30   904.97

all the 800 values have been wiped from the list since last update. a slight majority of the €uro top 20 was scored within the last month (11 out of 20). the oldest value on list is just 6/7 weeks in the past.  

edited

[dooglus]

Update:

 1  2013-11-30  1132.29 USD
 2  2013-12-04  1111.56 USD
 3  2017-01-04  1088.45 USD
 4  2013-11-29  1065.36 USD
 5  2013-12-03  1050.57 USD
 6  2017-02-08  1045.63 USD
 7  2017-02-07  1043.50 USD
 8  2017-02-04  1022.99 USD
 9  2017-02-06  1021.23 USD
10  2017-01-03  1020.56 USD
11  2017-02-05  1015.96 USD
12  2017-01-02  1013.00 USD
13  2017-02-03  1009.32 USD
14  2017-02-11  1008.19 USD
15  2017-01-05  1005.35 USD
16  2013-12-02  1000.49 USD
17  2013-11-28   998.56 USD
18  2017-02-09   996.61 USD
19  2017-02-02   994.32 USD
20  2017-01-01   987.47 USD

[dooglus]

Update:

 1  2013-11-30  1132.29 USD
 2  2013-12-04  1111.56 USD
 3  2017-01-04  1088.45 USD
 4  2013-11-29  1065.36 USD
 5  2013-12-03  1050.57 USD
 6  2017-02-08  1045.63 USD
 7  2017-02-07  1043.50 USD
 8  2017-02-04  1022.99 USD
 9  2017-02-06  1021.23 USD
10  2017-01-03  1020.56 USD
11  2017-02-05  1015.96 USD
12  2017-01-02  1013.00 USD
13  2017-02-03  1009.32 USD
14  2017-02-11  1008.19 USD
15  2017-01-05  1005.35 USD
16  2017-02-12  1002.34 USD
17  2013-12-02  1000.49 USD
18  2013-11-28   998.56 USD
19  2017-02-09   996.61 USD
20  2017-02-02   994.32 USD

[JANGKRIK BOSS]

Thankfully, now the price of bitcoin is back to $1.000. I'm sure the price of the bitcoin can reach $2.000 this year. and we have to be patient to hold and not selling, because I optimistic price bitcoin tomorrow better than today.

[dooglus]

Update:

 1  2013-11-30  1132.29 USD
 2  2013-12-04  1111.56 USD
 3  2017-01-04  1088.45 USD
 4  2013-11-29  1065.36 USD
 5  2013-12-03  1050.57 USD
 6  2017-02-08  1045.63 USD
 7  2017-02-07  1043.50 USD
 8  2017-02-04  1022.99 USD
 9  2017-02-06  1021.23 USD
10  2017-01-03  1020.56 USD
11  2017-02-05  1015.96 USD
12  2017-01-02  1013.00 USD
13  2017-02-03  1009.32 USD
14  2017-02-11  1008.19 USD
15  2017-01-05  1005.35 USD
16  2017-02-12  1002.34 USD
17  2013-12-02  1000.49 USD
18  2013-11-28   998.56 USD
19  2017-02-09   996.61 USD
20  2017-02-13   994.47 USD

[dooglus]

Update:

 1  2013-11-30  1132.29 USD
 2  2013-12-04  1111.56 USD
 3  2017-01-04  1088.45 USD
 4  2013-11-29  1065.36 USD
 5  2013-12-03  1050.57 USD
 6  2017-02-08  1045.63 USD
 7  2017-02-07  1043.50 USD
 8  2017-02-04  1022.99 USD
 9  2017-02-06  1021.23 USD
10  2017-01-03  1020.56 USD
11  2017-02-05  1015.96 USD
12  2017-01-02  1013.00 USD
13  2017-02-03  1009.32 USD
14  2017-02-11  1008.19 USD
15  2017-02-14  1006.66 USD
16  2017-01-05  1005.35 USD
17  2017-02-12  1002.34 USD
18  2013-12-02  1000.49 USD
19  2013-11-28   998.56 USD
20  2017-02-09   996.61 USD