Bitcoin Forum

Bitcoin => Bitcoin Discussion => Topic started by: tranthidung on October 09, 2020, 04:57:08 AM



Title: Fact sheet for bitcoin price (daily low, high, close price over years)
Post by: tranthidung on October 09, 2020, 04:57:08 AM
  • In 3 types of median,2 types of min, p25 and p75 of daily low price BTC is in its uptrend.
  • Look at p25, p75. If you buy BTC in price from $ 4155 to $10037 in years between 2018 till now, you are fine.
  • If you bought BTC at a bit higher price than the lowest in a weak-down in March, you are fine
  • Next target of BTC would be somewhere around $12300 (max_h)

Congratulations to all bitcoiners!  :D



Data source:
  • https://coinmarketcap.com/currencies/bitcoin/historical-data/

Variable notes:
  • Medians
    • median_l: Median of daily low price over year
    • median_h: Median of daily high price over year
    • median_c: Median of daily close price over year
  • min_c: Minimum of daily close price over year
  • max_c: Maximum of daily close price over year
  • min_l: Minimum of daily low price over year (Lowest over year)
  • max_h: maximum of daily high price over year (Highest over year
  • p25l: p25 quantile of daily low price over year
  • p75l: p75 quantile of daily low price over year


Raw data:
Code:
    +------------------------------------------------------------------------------------------------------+
     | year   median_l   median_h   median_c     min_c      max_c     min_l      max_h      p25l       p75l |
     |------------------------------------------------------------------------------------------------------|
  1. | 2013      124.7      129.9     127.04     68.43    1151.17     65.53    1156.14       104     199.97 |
  2. | 2014     489.73     516.16      502.5    310.74     953.29     289.3    1017.12    382.25      609.1 |
  3. | 2015     244.13     254.69     249.01     178.1     465.32    171.51     495.56    231.09     281.01 |
  4. | 2016    575.315     588.96    582.555    364.33     975.92    354.91      979.4    427.09      653.7 |
  5. | 2017    2510.48    2682.26    2589.41    777.76    19497.4    755.76      20089   1172.61    4377.46 |
     |------------------------------------------------------------------------------------------------------|
  6. | 2018    6747.98    7109.56    6906.92   3236.76      17527    3191.3    17712.4   6310.11    8360.62 |
  7. | 2019    7583.22    8047.41    7824.23   3399.47   13016.23   3391.02   13796.49   4155.32    9411.52 |
  8. | 2020   9221.055    9445.61    9324.99   4970.79    12254.4   4106.98   12359.06   8329.57   10037.07 |
     +------------------------------------------------------------------------------------------------------+


Title: Re: Fact sheet for bitcoin price (daily low, high, close price over years)
Post by: Tytanowy Janusz on October 09, 2020, 05:12:24 PM


In the meantime bitcoin "has died 382 times" (https://99bitcoins.com/bitcoin-obituaries/). Seriously people should stop looking at 5 min candles while investing in bitcoin. This is the chart that true investors should look at.
Thanks for this. I will have what to quote every time i see panic sellers discuss.


Title: Re: Fact sheet for bitcoin price (daily low, high, close price over years)
Post by: ChrisPop on October 09, 2020, 05:20:11 PM
In the meantime bitcoin "has died 382 times" (https://99bitcoins.com/bitcoin-obituaries/). Seriously people should stop looking at 5 min candles while investing in bitcoin. This is the chart that true investors should look at.
Thanks for this. I will have what to quote every time i see panic sellers discuss.

Exactly, man. I see a very big confusion between people who do trading. Every person should be clear about their goal. The philosophy is simple. If you're a long-term investor don't look at below Monthly timeframes. That's a waste of your time. Go relax, spend time with friends & family or follow any other passion you have. Time is the scarcest resource, please don't waste it.

Conversely, if you're a day-trader, looking at a weekly time-frame won't do you any good. :)


Title: Re: Fact sheet for bitcoin price (daily low, high, close price over years)
Post by: tranthidung on October 10, 2020, 02:38:27 AM
In the meantime bitcoin "has died 382 times" (https://99bitcoins.com/bitcoin-obituaries/). Seriously people should stop looking at 5 min candles while investing in bitcoin. This is the chart that true investors should look at.
Thanks for this. I will have what to quote every time i see panic sellers discuss.
People who say bitcoin has died belong to 2 types:
  • Type I: They hate bitcoin and feel jealously with bitcoiners who are believe in bitcoin (its technology, decentralization and future). They also want to invest in BTC but always feel fear and never actually buy BTC. They simply watch, regret and repeat it many times.
  • Type II: Investors who often buy BTC at peaks, all-time-high and make panic sells when BTC crashes or corrects
They are failured guys. Ignore them.
The plot is for type II investors.  :-\

I created another plot with p25 and p75 for daily low price over years. The range between p25 and p75 represents 50% of daily low price over all days are observed inthe period. It is in upward trend too.
The raw data in OP shows if you buy BTC in price from $ 4155 to $10037 in years between 2018 till now, you are fine.  :P

Exactly, man. I see a very big confusion between people who do trading. Every person should be clear about their goal. The philosophy is simple. If you're a long-term investor don't look at below Monthly timeframes. That's a waste of your time. Go relax, spend time with friends & family or follow any other passion you have. Time is the scarcest resource, please don't waste it.

Conversely, if you're a day-trader, looking at a weekly time-frame won't do you any good. :)
Your statement is all true and I'd prefer to add one more thing: Even you are long term investor or day-trader, you should look at wider time-frame in order to know what's going on in the market battle field. If a day-trader solely and always look at 5-min/ 15-min charts, they will be stucked in very shadow field and they can be killed by crashes. Look wider can help them have better look and make estimation on whether crashes will happen soon and when.


Title: Re: Fact sheet for bitcoin price (daily low, high, close price over years)
Post by: Tytanowy Janusz on October 10, 2020, 04:39:34 PM
  • Type I: They hate bitcoin and feel jealously with bitcoiners who are believe in bitcoin (its technology, decentralization and future). They also want to invest in BTC but always feel fear and never actually buy BTC. They simply watch, regret and repeat it many times.

Yes. I've heard it many times. They are always looking for the dip to buy and every dip is not dip enough or too big(bitcoin going to 0 fear). They are always frightened about fluctuation. Well I would rather like to sit on this:

https://i.imgur.com/rVsyp7A.png

than this:

https://libertyinternational.files.wordpress.com/2011/02/decliningdollachart.png?w=584



Title: Re: Fact sheet for bitcoin price (daily low, high, close price over years)
Post by: pixie85 on October 10, 2020, 06:16:36 PM
The question arises, is there a fall now? Or is it still slow growth?

I'd call that a stabilization.

Both the lowest and the highest yearly values are coming closer with each year which means that Bitcoin is looking for a stable line or at least a channel to say in.
The recent 9-12 thousand channel that we've been in for over 5 months is confirming this.


Title: Re: Fact sheet for bitcoin price (daily low, high, close price over years)
Post by: tranthidung on October 12, 2020, 05:27:44 PM
Yearly low price of bitcoin:


  • Data source: https://coinmarketcap.com/currencies/bitcoin/historical-data/
  • Observed period: 29/4/2013 - 06/10/2020.
  • min_l: Min of daily low price for each specific year.
  • percent_change: % of changes in min_l between 2 consecutive years

  • During the period of almost 8 years, the lowest yearly price of BTC has 7 years with increase (positive in percent_change), only has 1 year with a fall (negative in percent_change, at -40.7 % in 2015).
  • Min and max percent of increase is 6.3% (2019) and 341.5% (2014).
  • Also, see median_l, p25l and p75l (in statistics and in chart) to see the continuous growth (yearly low price) of bitcoin
  • Make double check with another dataset from 2010 to 2020 that I made in WO (https://bitcointalk.org/index.php?topic=178336.msg55270807#msg55270807)

Raw results:
Code:
     +---------------------------------+
     | year     min_l   percent_change |
     |---------------------------------|
  1. | 2013     65.53                . |
  2. | 2014     289.3           341.48 |
  3. | 2015    171.51           -40.72 |
  4. | 2016    354.91           106.93 |
  5. | 2017    755.76           112.94 |
     |---------------------------------|
  6. | 2018    3191.3           322.26 |
  7. | 2019   3391.02             6.26 |
  8. | 2020   4106.98            21.11 |
     +---------------------------------+


If you take 2015 out of the equation and the short timespan during which BTC has been past $12k, all you're left with is mostly pure profit and every year has been a new high. Even if you had invested once per month ever since BTC was >$12k, you still would've had a profit today as the price crashed a few times.

@20kevin20,

I used medians to exclude all extreme values or outliers from pumps or dumps. Please look at the details in OP. Here, I give you charts only. The first chart is very very bullish.  :D



Title: Re: Fact sheet for bitcoin price (daily low, high, close price over years)
Post by: 20kevin20 on October 12, 2020, 05:44:47 PM
Besides 2015 when Bitcoin and crypto in general seemed to be on the real brink of death having their worst year, today the markets look better than ever before imo - possibly being even highly undervalued.

But it's very, very hard to convince someone that they should head for a long term vision and not be led by short radical market movements. If you take 2015 out of the equation and the short timespan during which BTC has been past $12k, all you're left with is mostly pure profit and every year has been a new high. Even if you had invested once per month ever since BTC was >$12k, you still would've had a profit today as the price crashed a few times.

It all goes down to your own vision over the market.


Title: Re: Fact sheet for bitcoin price (daily low, high, close price over years)
Post by: tranthidung on November 23, 2020, 09:19:10 AM
Update for the uncertainty period:

This post is not made to say you buy or long bitcoin, just a fact and visual chart!

With 2765 observed days (from 29 Apr 2013 to 22 Nov 2020), there are only 5 days that have daily high price are higher than the yearly-high-price in 2020 at $18936.62

Those 4 days account for 0.14% whilst the rest of 2761 days account for 99.86%. In the long run, most of people are in profit even they are FOMO. Exceptions for people who are FOMOed in the 4 days: 4 days from 16 Dec 2017 to 19 Dec 2017
Code:
      +----------------------+
      |      date       high |
      |----------------------|
1693. | 16dec2017    19716.7 |
1694. | 17dec2017      20089 |
1695. | 18dec2017      19371 |
1696. | 19dec2017    19177.8 |



Title: Re: Fact sheet for bitcoin price (daily low, high, close price over years)
Post by: tranthidung on January 03, 2021, 10:44:24 AM
Today is the anniversary day for Bitcoin's genesis block. Let's me use this remarkable day to make a plot for Bitcoin close price on 3Jan-dates. There are 2 exceptions: in 2013 and in 2021. Data from coinmarketcap.com in 2013 is from 29 Apr 2013, and this year, the date 3 Jan 2021 has not yet ended.


What a growth!

You can also look at price history for yearly low price in previous post.



Title: Re: Fact sheet for bitcoin price (daily low, high, close price over years)
Post by: Welsh on January 03, 2021, 11:06:22 PM
In the meantime bitcoin "has died 382 times" (https://99bitcoins.com/bitcoin-obituaries/). Seriously people should stop looking at 5 min candles while investing in bitcoin. This is the chart that true investors should look at.
Thanks for this. I will have what to quote every time i see panic sellers discuss.
Honestly, this is quite common to see. People are way to irrational, and reactionary to really have any weight behind something as volatile as Bitcoin. This is proven in some sense, to supporting sports, and how a loss is suddenly a massive deal. Its the same as Bitcoin, has its "losses", and has its winning streaks, and no matter what statistical data you show, there will always be people who claim Bitcoin has died, despite proving time, and time again its actually moving in a upward trend in the long term. 


Title: Re: Fact sheet for bitcoin price (daily low, high, close price over years)
Post by: tranthidung on January 04, 2021, 08:02:34 AM
Its the same as Bitcoin, has its "losses", and has its winning streaks, and no matter what statistical data you show, there will always be people who claim Bitcoin has died, despite proving time, and time again its actually moving in a upward trend in the long term.  
Streaks, I have it for both rise and fall streaks. Below is the part of table for 2020-streaks.

In the last year (2020), there are 10 streaks in total (with my streak definition is for 5+-days at least to be considered as a streak) and only 2 of them (20%) are Fall streaks. The rest 8 streaks (80%) are all Rise streaks. The last streak (also a rise) is lasting since late 2020 till early days of 2021 (yesterday) and might continue if bitcoin can bounce well today after dip few hours ago.

50% of 8 rise streaks have their duration (longevity) last from 6 to 8 days (I have to round the raw results) with the median is at 6 days. The shortest and longest rise streaks are 5 and 9 days, respectively.

50% of 8 rise streaks have changes (in %) range from 12.3% to 26.3% with the median is at 16.9%. The smallest and largest streaks are 8.8% and 32.2%, respectively.

Raw results
Code:
    variable |         N      mean        sd       p50       p25       p75       min       max
-------------+--------------------------------------------------------------------------------
         dur |       8.0       6.5       1.4       6.0       5.5       7.5       5.0       9.0
----------------------------------------------------------------------------------------------

    variable |         N      mean        sd       p50       p25       p75       min       max
-------------+--------------------------------------------------------------------------------
       poc_s |       8.0      19.0       8.4      16.9      12.3      26.3       8.8      32.2
----------------------------------------------------------------------------------------------

More details:
  • Bitcoin Streaks (Rise/ Fall) - 2013 to 2020 (https://bitcointalk.org/index.php?topic=5301867.0)
  • There are 76 streaks in history of bitcoin


Title: Re: Fact sheet for bitcoin price (daily low, high, close price over years)
Post by: Tstar on January 04, 2021, 09:50:47 PM
Excellent data compilation, thanks.

I like how stable is the Min of close price in the second graph. This shows us that the price is steadily rising even the fluctuations.


Title: Re: Fact sheet for bitcoin price (daily low, high, close price over years)
Post by: tranthidung on January 05, 2021, 05:50:53 AM
Excellent data compilation, thanks.
You are welcome. It is my love to do this as I am stats enthusiast.

Quote
I like how stable is the Min of close price in the second graph. This shows us that the price is steadily rising even the fluctuations.
Truly it is.

This fact (growth of bitcoin price) is also reflected through the yearly lowest price. Check details (stats and charts) there (https://bitcointalk.org/index.php?topic=5280920.msg55366083#msg55366083). Despite of some ups and downs, the yearly lowest price almost rises in 2 consecutive years. The exception is year 2015, when price ($171.51) has -40.7% compares to yearly lowest price in 2014 ($289.3)


Title: Re: Fact sheet for bitcoin price (daily low, high, close price over years)
Post by: tranthidung on August 17, 2021, 08:45:32 AM
After half of a year, I am back.  :D

  • Data source: https://coinmarketcap.com/currencies/bitcoin/historical-data/
  • Here is use Daily Close price for calculations
  • Yearly Highest price: Highest price of Daily Close price each year
  • Yearly Lowest price: Lowest price of Daily Close price each year
  • Yearly Median price: Median price of Daily Close price each year


Conclusions
  • Generally, Bitcoin is bullish in all three charts, especially if you look at charts for Yearly Lowest price or Yearly Median price
  • Death cross, who care about it because each year, Bitcoin moves upward in its bullish ride
  • Death crosses, dips, crashes are chances for you to do accumulation and Dollar Cost Averaging (DCA) [1]

[1] https://dcabtc.com/