Bitcoin Forum

Bitcoin => Bitcoin Discussion => Topic started by: DdmrDdmr on July 30, 2020, 03:29:27 PM



Title: Ever wondered on how many days BTC has been above a certain value?
Post by: DdmrDdmr on July 30, 2020, 03:29:27 PM
Update -> Data as of 18/08/2020:

I was curious how many times BTC has been above 11K historically. I looked around, but couldn’t come across a site that provided this information (now someone will probably point to a site that does).

I’ve used the data from CoinMarketCap, ranging from the 29th  of april 2013 onwards (CoinMarketCap has no prior data values, therefore, the initial years are not included in the dataset, and the calculus will not be complete for low BTC price values):

https://coinmarketcap.com/currencies/bitcoin/historical-data/?start=20130429&end=20200818.


I’ve created the following table (Number of day BTC is above a certain value):

https://docs.google.com/spreadsheets/d/1ukVQfvvopAp9mjAtwnA0DQhPLv6L1AomCitFGQ_NGh8/edit?usp=sharing.


The table allows us to see on which dates, and on how many occasions, Bitcoin has reached or surpassed a value of 11K$, 12K$, 13K$, and so forth.

It turns out that BTC Price has been equal to or surpassed these values on the reflected number of occasions (days):
-   10K on 209 occasions (distinct days)
-   11K on 132 occasions (distinct days)
-   12K on 64 occasions (distinct days)
-   13K on 46 occasions (distinct days)
-   14K on 41 occasions (distinct days)
-   15K on 30 occasions (distinct days)
-   16K on 20 occasions (distinct days)
-   17K on 16 occasions (distinct days)
-   18K on 6 occasions (distinct days)
-   19K on 4 occasions (distinct days)
-   20K on 1 occasion (distinct days)

Notes:
-   If we modify the value of a column header on row number 4, we can see the results for any custom value. Bear in mind that there is no data prior to the 29/04/2013.

-   If we filter a column, setting the filter to the value of “1”, we should get to see the list of dates on which the given value was met or surpassed (i.e. change H4 from $10.000 (10K) to $750).


Edit: Added a tiny meaningless dashboard to play with (that's how the Merit Dashboard (https://public.tableau.com/profile/ddmrddmr#!/vizhome/BitcointalkMeritDashboard/PersonalSummary) started ...): CoinMarketCap Data Dashboard (https://public.tableau.com/profile/ddmrddmr#!/vizhome/CoinMarketCapSummarizedDataforBTC/CoinMarketCap)
 
The idea is simply to be able to filter the High, Low or Range (High-Low) for a specific value range (use the slider, or click the values on either end and overwrite them), and the date range.

This, as I stated, is not big deal at all, merely anecotical really, and does not intent to go beyond.

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


Title: Re: Ever wondered on how many days BTC has been above a certain value?
Post by: hatshepsut93 on July 30, 2020, 03:44:14 PM
If there really is no such site, I can easily make one and post it on github pages. If you haven't patented the idea, of course ;) The site can use coingecko or coinmarketcap api to provide the freshest data without the need to update it on backend. And then some client-side cashing will be required to keep the site responsive.


Title: Re: Ever wondered on how many days BTC has been above a certain value?
Post by: pakhitheboss on July 31, 2020, 07:43:39 AM
I do not think there is any website that displays this information. It is a brand new Idea and if OP wants he can create a website with all the information.

Quote
It turns out that BTC Price has been equal to or surpassed these values on the reflected number of occasions (days):
-   10K on 189 occasions (distinct days)
-   11K on 112 occasions (distinct days)
-   12K on 59 occasions (distinct days)
-   13K on 46 occasions (distinct days)
-   14K on 41 occasions (distinct days)
-   15K on 30 occasions (distinct days)
-   16K on 20 occasions (distinct days)
-   17K on 16 occasions (distinct days)
-   18K on 6 occasions (distinct days)
-   19K on 4 occasions (distinct days)
-   20K on 1 occasion (distinct days)

Thanks for sharing this valuable data.


Title: Re: Ever wondered on how many days BTC has been above a certain value?
Post by: erikoy on July 31, 2020, 07:54:57 AM
I do not really know what could be the purpose of this resewrch but probably it could be use as a reference in the future. We can assume that this data could be possibly be helpful to those who invested bitcoin for a certain period of time. Like for example a user would like to hold a certain amount of bitcoin then seeing the number of times it reaches to that certain amount make one to decide how long should be he will hold the btc or when whe will going to sell the bitcoin.


Title: Re: Ever wondered on how many days BTC has been above a certain value?
Post by: Cnut237 on July 31, 2020, 09:41:07 AM
I’ve created the following table (Number of day BTC is above a certain value)

Thanks for this. It might also be interesting to see how many times BTC has moved above a certain value. Presumably very straightforward to implement if anyone wanted it, just looking at instances where a cell value of '1' has a value of '0' in the cell immediately beneath.


Title: Re: Ever wondered on how many days BTC has been above a certain value?
Post by: slaman29 on July 31, 2020, 10:24:27 AM
It turns out that BTC Price has been equal to or surpassed these values on the reflected number of occasions (days):
-   10K on 189 occasions (distinct days)
-   11K on 112 occasions (distinct days)
-   12K on 59 occasions (distinct days)
-   13K on 46 occasions (distinct days)
-   14K on 41 occasions (distinct days)
-   15K on 30 occasions (distinct days)
-   16K on 20 occasions (distinct days)
-   17K on 16 occasions (distinct days)
-   18K on 6 occasions (distinct days)
-   19K on 4 occasions (distinct days)
-   20K on 1 occasion (distinct days)

Seen this kind of data before, back in 2019 I think when a lot of people thought the bull was coming but didn't.

I guess we can all sum up that BTC price has only been in total just over 1 year and 3 months over 10k. So basically, only 10% of its lifetime is above that threshold yes?


Title: Re: Ever wondered on how many days BTC has been above a certain value?
Post by: DoubleEdgeEX on July 31, 2020, 10:30:21 AM
Lazy ass non-code guy here. Could you put that data in a graphic that explains it for starters and share it?  Such data should be understood and acknowledged by everyone!


Title: Re: Ever wondered on how many days BTC has been above a certain value?
Post by: minairia3 on July 31, 2020, 10:34:28 AM
I do not really know what could be the purpose of this resewrch but probably it could be use as a reference in the future. We can assume that this data could be possibly be helpful to those who invested bitcoin for a certain period of time.
Historical data could somehow help some traders to check some pattern and charts for the movement of btc. Im not that kind of trader, but I believe this info could be useful to some who uses old information. OP probably wanted to share this and he already said out of curiosity.

This will be good if the data can be shown on chart and graphical overlay maybe we can see some sign or pattern what could be possible movement. But of course the result is still not sure as market is always volatile.

But thanks OP for the effort to share this.


Title: Re: Ever wondered on how many days BTC has been above a certain value?
Post by: davis196 on July 31, 2020, 10:57:09 AM
I do not think there is any website that displays this information. It is a brand new Idea and if OP wants he can create a website with all the information.

Quote
It turns out that BTC Price has been equal to or surpassed these values on the reflected number of occasions (days):
-   10K on 189 occasions (distinct days)
-   11K on 112 occasions (distinct days)
-   12K on 59 occasions (distinct days)
-   13K on 46 occasions (distinct days)
-   14K on 41 occasions (distinct days)
-   15K on 30 occasions (distinct days)
-   16K on 20 occasions (distinct days)
-   17K on 16 occasions (distinct days)
-   18K on 6 occasions (distinct days)
-   19K on 4 occasions (distinct days)
-   20K on 1 occasion (distinct days)

Thanks for sharing this valuable data.


Do you really think that such statistical data is "valuable"?What makes this data valuable?
Some people like to play around with data and statistics out of curiosity.Other than that,there's no benefit from this information.It's common sense that the Bitcoin price has reached higher levels in less occasions,the higher the price level,the less it happens.
Can any experienced crypto trader please explain how he can benefit from such data?
If you ask me,this data is useless for both technical and fundamental analysis.


Title: Re: Ever wondered on how many days BTC has been above a certain value?
Post by: Casdinyard on July 31, 2020, 12:40:02 PM
It turns out that BTC Price has been equal to or surpassed these values on the reflected number of occasions (days):
-   10K on 189 occasions (distinct days)
-   11K on 112 occasions (distinct days)
-   12K on 59 occasions (distinct days)
-   13K on 46 occasions (distinct days)
-   14K on 41 occasions (distinct days)
-   15K on 30 occasions (distinct days)
-   16K on 20 occasions (distinct days)
-   17K on 16 occasions (distinct days)
-   18K on 6 occasions (distinct days)
-   19K on 4 occasions (distinct days)
-   20K on 1 occasion (distinct days)

Can you also have a data if it was a growing occasions or just simply a stable one? I mean is it gradually growing or it happens in a common month annually? Such data could be use to predict when year that Bitcoin would reach again the 20K highest price, because it's too obvious that if 10K instances that days it reached would be hitting often, it would soon as well reach the 11k, 12k, so on and so forth. But then the question is that what chance it could often reach it and how long would it take to occur multiple occasions of a limit.

I hope you're getting me lol :D


Title: Re: Ever wondered on how many days BTC has been above a certain value?
Post by: Cnut237 on July 31, 2020, 01:11:10 PM
Do you really think that such statistical data is "valuable"?What makes this data valuable?


It might be useful. A few quick calculations reveal that historically it is best* to buy on a Thursday and sell on a Wednesday (based on daily closing prices).

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

*prices may go down as well as up. trade at your own risk. advice may be nonsense. calculations may be wrong (i said they were quick). illustration is purely for illustrative purposes. that's why it's an illustration.


Title: Re: Ever wondered on how many days BTC has been above a certain value?
Post by: Eureka_07 on July 31, 2020, 01:30:18 PM
I do not think there is any website that displays this information. It is a brand new Idea and if OP wants he can create a website with all the information.

Quote
It turns out that BTC Price has been equal to or surpassed these values on the reflected number of occasions (days):
-   10K on 189 occasions (distinct days)
-   11K on 112 occasions (distinct days)
-   12K on 59 occasions (distinct days)
-   13K on 46 occasions (distinct days)
-   14K on 41 occasions (distinct days)
-   15K on 30 occasions (distinct days)
-   16K on 20 occasions (distinct days)
-   17K on 16 occasions (distinct days)
-   18K on 6 occasions (distinct days)
-   19K on 4 occasions (distinct days)
-   20K on 1 occasion (distinct days)

Thanks for sharing this valuable data.


Do you really think that such statistical data is "valuable"?What makes this data valuable?
Some people like to play around with data and statistics out of curiosity.Other than that,there's no benefit from this information.It's common sense that the Bitcoin price has reached higher levels in less occasions,the higher the price level,the less it happens.
Can any experienced crypto trader please explain how he can benefit from such data?
If you ask me,this data is useless for both technical and fundamental analysis.

If you looked at the data carefully, and took some time to analyze it, you'll find that as the value of BTC goes up, the less day(s) it stays or surpass the current value on that time.
As the value increases, the number of occasions decreases.

This type of data is valuable to a bitcoin investor. For me, it is one of the most valuable data on trading.
Knowing how long a coin stay on a particular value is a good data to have, we can use this as a basis to make more rational decision. :)

Can't believe this is useless for you. LOL


First time seeing these type of data. Thanks OP :)



Title: Re: Ever wondered on how many days BTC has been above a certain value?
Post by: Cnut237 on July 31, 2020, 01:32:36 PM
It might also be interesting to see how many times BTC has moved above a certain value. Presumably very straightforward to implement if anyone wanted it, just looking at instances where a cell value of '1' has a value of '0' in the cell immediately beneath.

Here you go*, Cnut.

$k   #times passed threshold
21   0
20   1
19   1
18   2
17   3
16   4
15   4
14   1
13   4
12   8
11   9
10   14

You're welcome.

*previous disclaimers apply.


Title: Re: Ever wondered on how many days BTC has been above a certain value?
Post by: Bttzed03 on July 31, 2020, 01:46:28 PM
Lazy ass non-code guy here. Could you put that data in a graphic that explains it for starters and share it?  Such data should be understood and acknowledged by everyone!

~
Can you also have a data if it was a growing occasions or just simply a stable one? I mean is it gradually growing or it happens in a common month annually? Such data could be use to predict when year that Bitcoin would reach again the 20K highest price, because it's too obvious that if 10K instances that days it reached would be hitting often, it would soon as well reach the 11k, 12k, so on and so forth. But then the question is that what chance it could often reach it and how long would it take to occur multiple occasions of a limit.

I hope you're getting me lol :D

Is bitcoin historical chart not enough for this? https://coinmarketcap.com/currencies/bitcoin/

The data provided by @DdmrDdmr is a simply a summary. If you check the spreadsheet he made, bitcoin first hit $10K on Nov. 28, 2017. You can start from there.

If we're going to be more accurate, the first time btc hit $10K was earlier than that. I remember it happened one time on Livecoin.net and it was done by mistake. I can't find an article about that unfortunately.


Title: Re: Ever wondered on how many days BTC has been above a certain value?
Post by: DdmrDdmr on July 31, 2020, 07:15:25 PM
<…>
My initial quest was simply to find out how many times we’ve been above 11k and when, to elaborate on a thread someone started on my local board.  I then flexed the idea a bit to cover different K thresholds. I could easily exploit this information quite a bit, as I do on the BitcoinTalk Merit Dashboard (https://public.tableau.com/profile/ddmrddmr#!/vizhome/BitcointalkMeritDashboard/GlobalSummary) (creating a new one), but I would not update it more than once a week. I'm not really convinced though it has (that) much to it in terms of useful information.

Everyone is free though to implement their own solution, and sometimes it’s better to have a few, lest an OP should drop out of an implementation instance (i.e. as happens with notifications on merit and mention alternatives, where we have multiple solutions created by forum members).

Lazy ass non-code guy here. <…>
Could you clarify whether the prodigal phrase is in reflexive mode, or aimed at the OP (namely me)?

<..>
The information is merely anecdotic, and on it’s own does not really mean much (i.e. no trends, no casual indicators and so forth). The origin was merely to depict what it shows: how many times, and on what dates, a certain threshold was surpassed. It’s rather more a curiosity than anything else.

<…>
I get it, but that is not the intent. I’m sure some could do something much more elaborate from a predictive point of view, and there are some models I’ve seen (but lost track of) that appeared to infer seemingly decent results, although not good enough to play short with.

<…>
Indeed, a chart as the one you referenced produces way more visual information, and that is where I tried to infer the (again, anecdotic) information in the OP. The chart did not resolve my query, so I resorted to using the underlying raw data.


Title: Re: Ever wondered on how many days BTC has been above a certain value?
Post by: mezzaluna on August 01, 2020, 09:55:12 AM

The table allows us to see on which dates, and on how many occasions, Bitcoin has reached or surpassed a value of 11K$, 12K$, 13K$, and so forth.

It turns out that BTC Price has been equal to or surpassed these values on the reflected number of occasions (days):
-   10K on 189 occasions (distinct days)
-   11K on 112 occasions (distinct days)
-   12K on 59 occasions (distinct days)
-   13K on 46 occasions (distinct days)
-   14K on 41 occasions (distinct days)
-   15K on 30 occasions (distinct days)
-   16K on 20 occasions (distinct days)
-   17K on 16 occasions (distinct days)
-   18K on 6 occasions (distinct days)
-   19K on 4 occasions (distinct days)
-   20K on 1 occasion (distinct days)

Notes:
-   If we modify the value of a column header on row number 4, we can see the results for any custom value. Bear in mind that there is no data prior to the 29/04/2013.

-   If we filter a column, setting the filter to the value of “1”, we should get to see the list of dates on which the given value was met or surpassed (i.e. change H4 from $10.000 (10K) to $750).


Edit: I'll get back to this thread when I can (I'm a very short of free time today).

I was really curious too on what occasion did Bitcoin exceeded their highest value in different years. I was curious on what event or occasion triggers the skyrocketing of Bitcoin and based on some of my assumption, they are really random. Its just surprising that its not happening every year since it also has the capability to do that too.


Title: Re: Ever wondered on how many days BTC has been above a certain value?
Post by: JayJuanGee on August 18, 2020, 06:08:42 PM
I am NOT going to poo poo this topic, but I also believe that the weighted trade volume price of BTC is an important and interesting metric, too.

That top 20 days / 100 days information has largely been tracked in the below-linked thread since early 2013... and you can look back at various high trade volume price points in BTC history, and even the last few years (since early 2017) in 4 other trading pairs/currencies, beyond the USD/BTC pair.

Top 20/100 days for Bitcoin (https://bitcointalk.org/index.php?topic=138109.0)


Title: Re: Ever wondered on how many days BTC has been above a certain value?
Post by: int03h on August 19, 2020, 08:40:18 AM
Thanks for your data. I opened the BTC chart and noticed that over the months and weeks the green candlestick appeared more and most of the excessive price drops did not appear much. Bitcoin, for example, fell to the 3k3 level that only appeared in 1 week and quickly rebounded to $ 4k-5k. I believe bitcoin will soon return to 10k then rise to 20k quickly.


Title: Re: Ever wondered on how many days BTC has been above a certain value?
Post by: kryptqnick on August 19, 2020, 10:44:27 AM

If you looked at the data carefully, and took some time to analyze it, you'll find that as the value of BTC goes up, the less day(s) it stays or surpass the current value on that time.
As the value increases, the number of occasions decreases.
The data provided by the op is interesting, but your analysis shows why I believe it would be better to make it not only about high prices, but also about the low ones (like, start with $1k, for instance). Because I'm pretty sure that the tendency described here (that the number of occasions is inversely proportional to the value of Bitcoin) is not universal. Well, it is universal because of the way this table is formed, but that's not what I'm trying to say here.
I did not check, but I am pretty sure that Bitcoin was worth $6k for longer than it was worth $1k. Then again, the way the data is comprised, when Bitcoin was worth $6k, it was more than $1k, so that column would get all those occasions and thus inevitably the higher the price gets, the lower is the number of occasions. What could be a different set of data, but also useful, is for how long Bitcoin price was in a certain range (between 1k and 2k; between 6k and 7k). This would show what Bitcoin is often worth, and what price is higher than usual OR lower than usual.


Title: Re: Ever wondered on how many days BTC has been above a certain value?
Post by: DdmrDdmr on August 19, 2020, 11:39:39 AM
I’ve update the data in the OP, and played around a bit, porting some functionality to Tableau: CoinMarketCap Data Dashboard (https://public.tableau.com/profile/ddmrddmr#!/vizhome/CoinMarketCapSummarizedDataforBTC/CoinMarketCap)
 
The idea is simply to be able to filter the High, Low or Range (High-Low) for a specific value range (use the slider, or click the values on either end and overwrite them), and the date range.

This, as I stated, is not big deal at all, merely anecotical really, and does not intent to go beyond.

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