Author

Topic: Total Marketcap All Coins Logarithmic Regression (Read 7405 times)

legendary
Activity: 1498
Merit: 1000
Anyone done an updated regression lately? Awe hasn't posted since December, nothing on crypto since his last update.
sr. member
Activity: 327
Merit: 250
The Best Investment Deserves The Largest Exposure
Chart was updated by Awe and Wonder:
https://twitter.com/Awe_andWonder/status/1071995130092113920


Made new video about it, enjoy  Cool

"Serious Undervaluation is Here"
https://www.youtube.com/watch?v=k9JsmelO12s&t
newbie
Activity: 7
Merit: 0
From Trolololo's formula I've calculated today's % Spread based on today's actual Market Cap. of $115.7 B.

The Spread comes to -52.8 %.

See https://youtu.be/MvQzjyhtjRg for explanation.

Indeed currently 252B is trendline/fair value of all crypto's, so 115B would be -54%, today 135B is -49%, undervaluation to fair value.

https://www.wolframalpha.com/input/?i=10%5E(3.23720++*+ln((number+of+weeks+since+2009+Jan+09)%2Fweeks)+-+8.81809)

Great job Marc, hope you update chart. follow you.
sr. member
Activity: 327
Merit: 250
The Best Investment Deserves The Largest Exposure
From Trolololo's formula I've calculated today's % Spread based on today's actual Market Cap. of $115.7 B.

The Spread comes to -52.8 %.

See https://youtu.be/MvQzjyhtjRg for explanation.

Indeed currently 252B is trendline/fair value of all crypto's, so 115B would be -54%, today 135B is -49%, undervaluation to fair value.

https://www.wolframalpha.com/input/?i=10%5E(3.23720++*+ln((number+of+weeks+since+2009+Jan+09)%2Fweeks)+-+8.81809)
newbie
Activity: 4
Merit: 0
From Trolololo's formula I've calculated today's % Spread based on today's actual Market Cap. of $115.7 B.

The Spread comes to -52.8 %.

See https://youtu.be/MvQzjyhtjRg for explanation.
newbie
Activity: 4
Merit: 0

Awe and Wonder on twitter does a great job too with the log regression chart and other interesting stuff:
https://twitter.com/Awe_andWonder

Don't think he is doing log regression on total market cap thou
If anyone thinks Trololo's work was a bit difficult, Awe&Wonder's paper in Medium is even more so. But I think I've got the jist of what he is saying.

In my words he reckons the neutral btc price should be about $4800. Since we are already below this price at present bitcoin could now be considered to have become undervalued. For me that means now is more or less time to consider buying.
sr. member
Activity: 327
Merit: 250
The Best Investment Deserves The Largest Exposure
Where is Trolololo when you need him lol!

yup Smiley

Awe and Wonder on twitter does a great job too with the log regression chart and other interesting stuff:
https://twitter.com/Awe_andWonder

Don't think he is doing log regression on total market cap thou
sr. member
Activity: 447
Merit: 250
Where is Trolololo when you need him lol!
legendary
Activity: 1330
Merit: 1019
Is this possible that somebody or Trololo will update this chart frequently?

Donate Trololo for this amazing work. If you find it valuable donate even more.

His Bitcoin one is also very good and deserves donations for an update: https://bitcointalksearch.org/topic/m.9293342
I didn't entirely understood how this is calculated at all. I am trying to see how it is and why it should work but anyway I look at it shows only upto today and nothing about the future.

If we can't really calculate the future this is jut an algorithm that shows us what the marketcap should be looking like according to this also however nothing further? If so than why not just take a look at the marketcap itself instead of this also? If it has a possibility of showing the marketcap for a future time than how it could be done? It just shows today's and that's something we can find ourselves.
newbie
Activity: 8
Merit: 1
Nevermind, current trendline at 200B according to your last link to calculator:

Calculate today's trendline value HERE

Mark how do you know the input in the wolfram alpha.  could you please explain. 
I discover your channel  and Tommyworldpower on youtube.  You guys have done a great work. 
I'm assuming you are Trolololo, lol
sr. member
Activity: 327
Merit: 250
The Best Investment Deserves The Largest Exposure
Nevermind, current trendline at 200B according to your last link to calculator:

Calculate today's trendline value HERE
sr. member
Activity: 327
Merit: 250
The Best Investment Deserves The Largest Exposure
Here is the updated chart:



Calculate today's trendline value HERE

Please, consider donating to bitcoin:19sEscR9bfH2ttXb5WbcabYbRGjq2znwPi

PS: Special thanks to Marc De Mesel, again  Wink


Observing the spread chart, we are heavily overvalued, more than 5x times the estimated value.
Only 2 times we were higher: June 2011 and nov 2013...


Legendary words now already from our one and only Trololo  Cool


Send u message Trololo, would love to see new chart but especially have your confirmation that calculator is correct?

Current trendline is at 150 billion?

Calculate today's trendline value HERE

sr. member
Activity: 327
Merit: 250
The Best Investment Deserves The Largest Exposure
Here is the updated chart:



Calculate today's trendline value HERE

Please, consider donating to bitcoin:19sEscR9bfH2ttXb5WbcabYbRGjq2znwPi

PS: Special thanks to Marc De Mesel, again  Wink


Calculator Trendline used to point to $180 Billion 1 month back, but now dropped to $150 Billion, which is right previous calculation or current one (that sems updated trololo?)
sr. member
Activity: 447
Merit: 250
Hi guys, talked about Trololo chart in my latest video, "Thou Shalt Not Buy Overvaluation In Downtrend!"

Enjoy  Cool

https://www.youtube.com/watch?v=08Z1oBjF4ig


Summary:

Current fair historical valuation of all cryptos according to Trololo chart is $180 billion so current $260 billion is still 44% overvalued (not 70% as mentioned in video). If it is trending upwards you can still make a good buck buying overvaluation but trend is now clearly downwards for half a year. Considering past bull market (2015-2017) lasted 50% longer than previous bull market (2012-2013) (3 years instead of 2), this bear market will likely also last 50% longer than last bear market of 2014-2015 so this time 1.5 year instead of 1, for the biggest coins, 3 years instead of 2 years for smallest, which is still a very long time from here, until end 2020! Also a word on real world adoption of Byteball and Bitcoin Cash.

Recently very active on Instagram, pics and vids of my dating life Wink Check it out: https://www.instagram.com/marcdemesel/

Please share with your friends on your fb or snapchat, or retweet:
https://twitter.com/marcdemesel/status/1010160840518066176

Thanks Marc!

@Trololo could you please start accepting NANO so that we can donate to help you update the chart on a periodic basis?

Thanks.
sr. member
Activity: 327
Merit: 250
The Best Investment Deserves The Largest Exposure
Hi guys, talked about Trololo chart in my latest video, "Thou Shalt Not Buy Overvaluation In Downtrend!"

Enjoy  Cool

https://www.youtube.com/watch?v=08Z1oBjF4ig


Summary:

Current fair historical valuation of all cryptos according to Trololo chart is $180 billion so current $260 billion is still 44% overvalued (not 70% as mentioned in video). If it is trending upwards you can still make a good buck buying overvaluation but trend is now clearly downwards for half a year. Considering past bull market (2015-2017) lasted 50% longer than previous bull market (2012-2013) (3 years instead of 2), this bear market will likely also last 50% longer than last bear market of 2014-2015 so this time 1.5 year instead of 1, for the biggest coins, 3 years instead of 2 years for smallest, which is still a very long time from here, until end 2020! Also a word on real world adoption of Byteball and Bitcoin Cash.

Recently very active on Instagram, pics and vids of my dating life Wink Check it out: https://www.instagram.com/marcdemesel/

Please share with your friends on your fb or snapchat, or retweet:
https://twitter.com/marcdemesel/status/1010160840518066176
legendary
Activity: 1498
Merit: 1000
Has anyone access to an Excel or Google Sheet / calculator where I can plug in and do a Metcalfe analysis of price vs active users (providing my own active users values)?

https://arxiv.org/pdf/1803.05663v1.pdf - similar to what they've done in this paper?

sr. member
Activity: 263
Merit: 280
@vapourminer

Thank you very much for your donation!  Grin
legendary
Activity: 1036
Merit: 1000
@trolololo, you're a legend! What a fantastic graph! My suspicions about the whole cryptcurrency movement slowing down have been confirmed!!!
legendary
Activity: 4354
Merit: 3614
what is this "brake pedal" you speak of?
Here is the updated chart:

https://s10.postimg.org/kzlt8lhk9/log_all_coins_marketcap_18-02-2018.jpg

Calculate today's trendline value HERE

Please, donate to:
BTC: 3F6Cs4x5mnp1xnURih8TiHN52DFzfGShNh
LTC: MU6ZfwepfD73SAYwSQVwGx39zmmTXhef3i
DASH: XczitEhpmqPMX4fbTAEvV6SuSo1rBU532s
ZEC: t1TCLym7Jti5Qo2Wn9oMopNVGBMs2kxqkcs


PS: Special thanks to Marc De Mesel, once again  Wink

sent ya a tip, tx id is in a pm.
sr. member
Activity: 327
Merit: 250
The Best Investment Deserves The Largest Exposure
Thank you so much for the update Trolololo!!! Smiley


Just published video on it with my analyses, enjoy guys and please retweet!!!  Cool

https://twitter.com/marcdemesel/status/966207225009143814



Here is the updated chart:



Calculate today's trendline value HERE

Please, donate to:
BTC: 3F6Cs4x5mnp1xnURih8TiHN52DFzfGShNh
LTC: MU6ZfwepfD73SAYwSQVwGx39zmmTXhef3i
DASH: XczitEhpmqPMX4fbTAEvV6SuSo1rBU532s
ZEC: t1TCLym7Jti5Qo2Wn9oMopNVGBMs2kxqkcs


PS: Special thanks to Marc De Mesel, once again  Wink
sr. member
Activity: 263
Merit: 280
Here is the updated chart:



Calculate today's trendline value HERE

Please, donate to:
BTC: 3F6Cs4x5mnp1xnURih8TiHN52DFzfGShNh
LTC: MU6ZfwepfD73SAYwSQVwGx39zmmTXhef3i
DASH: XczitEhpmqPMX4fbTAEvV6SuSo1rBU532s
ZEC: t1TCLym7Jti5Qo2Wn9oMopNVGBMs2kxqkcs


PS: Special thanks to Marc De Mesel, once again  Wink
legendary
Activity: 1652
Merit: 1265
Outlook here is quite bad, do you think we will have to wait till 2020 to recover? Or is this slump due to black swan events, simple FUD-ing on all channels

No
No
Yes
legendary
Activity: 1762
Merit: 1011
Outlook here is quite bad, do you think we will have to wait till 2020 to recover?

Based on what?
newbie
Activity: 2
Merit: 0
Outlook here is quite bad, do you think we will have to wait till 2020 to recover? Or is this slump due to black swan events, simple FUD-ing on all channels
full member
Activity: 294
Merit: 100
The picture is pretty bad compared to the purely bitcoin one...
I really hope there could be fewer bad coins like bitconnect - these bad coins are draining the energy out of the whole crypto market
newbie
Activity: 12
Merit: 1
@Trolololo -   Please message me on telegram @Tommyworldpower, I'll tip you $100 for doing so! (no bullshit)


Cheers!
legendary
Activity: 1762
Merit: 1011
Is this possible that somebody or Trololo will update this chart frequently?

Donate Trololo for this amazing work. If you find it valuable donate even more.

His Bitcoin one is also very good and deserves donations for an update: https://bitcointalksearch.org/topic/m.9293342
newbie
Activity: 12
Merit: 1
Hey Trololol, I'd like to get in closer touch with you, I've referred to your chart for years. I have a Youtube channel myself with a good number of followers. Do you have a telegram? I'd be happy to send you a tip too with Ethereum if you accept that.

Also, I can't seem to message you here, can you send me a message? (Then we can trade telegram names). Thank you!

legendary
Activity: 2744
Merit: 1708
First 100% Liquid Stablecoin Backed by Gold
Is this possible that somebody or Trololo will update this chart frequently?

Donate Trololo for this amazing work. If you find it valuable donate even more.
legendary
Activity: 1762
Merit: 1011
Here is the updated chart:



Calculate today's trendline value HERE

Please, consider donating to bitcoin:19sEscR9bfH2ttXb5WbcabYbRGjq2znwPi

PS: Special thanks to Marc De Mesel, again  Wink



Thanks so much Trolololo!!!!! Cool


Very happy with the chart, made new video about it guys, enjoy!!!  Grin

https://www.youtube.com/watch?v=RSPkNHcQuIc&lc=z234h35ixlmierp0aacdp43algafjev5wwrtvf3ax1lw03c010c



Excellent, looks like the image is working again: https://s10.postimg.org/vo7kc9z3t/log_all_coins_marketcap_27-12-2017.jpg
sr. member
Activity: 327
Merit: 250
The Best Investment Deserves The Largest Exposure
Here is the updated chart:



Calculate today's trendline value HERE

Please, consider donating to bitcoin:19sEscR9bfH2ttXb5WbcabYbRGjq2znwPi

PS: Special thanks to Marc De Mesel, again  Wink



Thanks so much Trolololo!!!!! Cool


Very happy with the chart, made new video about it guys, enjoy!!!  Grin

https://www.youtube.com/watch?v=RSPkNHcQuIc&lc=z234h35ixlmierp0aacdp43algafjev5wwrtvf3ax1lw03c010c

legendary
Activity: 1762
Merit: 1011
Here is the updated chart:



Calculate today's trendline value HERE

Please, consider donating to bitcoin:19sEscR9bfH2ttXb5WbcabYbRGjq2znwPi

PS: Special thanks to Marc De Mesel, again  Wink

Trolololo, I will be donating soon, but the URL for the image isn't working: https://postimg.org/image/nvgwkat4l/

The image is also timing out: https://s10.postimg.org/nvgwkat4l/log_all_coins_marketcap_27-12-2017.jpg
sr. member
Activity: 263
Merit: 280
Where is Trololo? Can he recompute his Bitcoin price regression chart now?

Sure, did u ever donate to him?

I will if he responds that his BTC address is up-to-date and that he will redo the Bitcoin price regression chart. I and others will donate if posts about that. No I did not donate in the past because I wasn’t following him.

Update Dec 4: saw no action on this and will stop following.


Yes, all addresses are up to date. Otherwise, I would have changed them...  Wink

Sorry for the delay answering questions, but I'm too busy and I seldom visit bitcointalk.
sr. member
Activity: 263
Merit: 280
Here is the updated chart:



Calculate today's trendline value HERE

Please, consider donating to bitcoin:19sEscR9bfH2ttXb5WbcabYbRGjq2znwPi

PS: Special thanks to Marc De Mesel, again  Wink

Observing the spread chart, we are heavily overvalued, more than 5x times the estimated value.
Only 2 times we were higher: June 2011 and nov 2013...
sr. member
Activity: 263
Merit: 280
Here is the updated chart:



Calculate today's trendline value HERE

Please, consider donating to bitcoin:19sEscR9bfH2ttXb5WbcabYbRGjq2znwPi

PS: Special thanks to Marc De Mesel, again  Wink
sr. member
Activity: 327
Merit: 250
The Best Investment Deserves The Largest Exposure
Send pm Trolololo 😉
newbie
Activity: 12
Merit: 1
Trolololo I have popularized your work in many avenues- you should post weekly updates to this along with your donation address. Also share them on Twitter. Doing so you'll build a brand for yourself and no doubt get donations -- but even more valuable, you'll gain a following
newbie
Activity: 56
Merit: 0
Where is Trololo? Can he recompute his Bitcoin price regression chart now?

Sure, did u ever donate to him?

I will if he responds that his BTC address is up-to-date and that he will redo the Bitcoin price regression chart. I and others will donate if posts about that. No I did not donate in the past because I wasn’t following him.

Update Dec 4: saw no action on this and will stop following.
sr. member
Activity: 327
Merit: 250
The Best Investment Deserves The Largest Exposure
Where is Trololo? Can he recompute his Bitcoin price regression chart now?

Sure, did u ever donate to him?
newbie
Activity: 56
Merit: 0
I went ahead and created an updated chart using photoshop, is not 100% accurate but by estimate.

The purple line would adjust upward if the regression was recomputed.

Where is Trololo? Can he recompute his Bitcoin price regression chart now?
sr. member
Activity: 327
Merit: 250
The Best Investment Deserves The Largest Exposure
I went ahead and created an updated chart using photoshop, is not 100% accurate but by estimate.

Also made a short video with commentary about it:
https://www.youtube.com/watch?v=nAT-c2bflTI





Not many are donating for this very valuable work Sad

Please donate to Trololo by scanning the QR code on the OP or this chart.

It will help greatly in getting more regular updates

Thanks so much!  Smiley
hero member
Activity: 672
Merit: 526
Op needs to be back. It would great see an updated version. Especially for 2018 because we already hit 100 bi and passed.
sr. member
Activity: 1400
Merit: 420


To know where do this comes from: https://bitcointalksearch.org/topic/logarithmic-non-linear-regression-bitcoin-estimated-value-831547

Calculate today's trendline value HERE

Please, consider donating to bitcoin:19sEscR9bfH2ttXb5WbcabYbRGjq2znwPi

PS: Special thanks to Marc De Mesel

This chart of yours is indeed accurate regarding what is happening in Bitcoin's price as of now and if many people will see this post will struck their minds that there are an individual who predicts the price from 2014 to what will be the price today. Your market capitalization of Bitcoin is quite in range for today's market capitalization and I am so grateful to it, I really hope that you update your prediction to this thread sooner as it is now a big thing for me.
sr. member
Activity: 327
Merit: 250
The Best Investment Deserves The Largest Exposure
Indeed, update would be awesome Trolololo!!!  Cool
newbie
Activity: 12
Merit: 1
An update on this would be much appreciated Smiley
sr. member
Activity: 475
Merit: 251
VTOS
I just compared this graph to bitcoin's. It basically shows bitcoin has lot more room to raise in price than other altcoins cause altcoins are gonna need correction. That correction will come by selling out to bitcoin. I suppose that's what we should understand. I am not so good at math btw.
sr. member
Activity: 447
Merit: 250


To know where do this comes from: https://bitcointalksearch.org/topic/logarithmic-non-linear-regression-bitcoin-estimated-value-831547

Calculate today's trendline value HERE

Please, consider donating to bitcoin:19sEscR9bfH2ttXb5WbcabYbRGjq2znwPi

PS: Special thanks to Marc De Mesel

Any update on this chart?
legendary
Activity: 1073
Merit: 1000
Then we still have more correction to go, according to your graph?

Who will bleed more?
legendary
Activity: 2744
Merit: 1708
First 100% Liquid Stablecoin Backed by Gold
Thanks for this great stuff.
legendary
Activity: 854
Merit: 1000
dayum I wish i could understand this more, but awesome!! 
Not only you are ignorant not understanding this but you are an especial ignorant posting and admitting about your own ignorance Cheesy
@OP, you are trying to contribute to this community but then you just ruined it by begging in form of donation Cheesy
Admitting ones ignorance is called humility not stupidity Wink
hero member
Activity: 686
Merit: 500
Great graph!
Anyone know how to import total marketcap historic data into excel. I know how to import per coin, but not total marketcap data.
Who knows, and who wants to share?
legendary
Activity: 1806
Merit: 1090
Learning the troll avoidance button :)
Looks at logarithmic regression, looks at 2011 sees 1337 I smiled.
Got to be E 133t
But if the log shows something we have years where we are under and over the log line and that the regression pattern really spreads out on a deviance from the pattern so far with the trend only intersected not including the years 2010 and 2011, in 2012 at 125 mill, 2014 almost into 2015 at 7-8 billion and now in 2017 around 80-85 billion so we could be in for some serious upside given the historical log in terms of all cryptocurrencies and their market cap before the next intersect.
legendary
Activity: 2842
Merit: 1511
when you use bitcoin price for analysis it is meaningful like that link
when you use bitcoin market cap then it is still meaningful but a little less
when you use altcoins' market cap you are decreasing the meaningfulness of your chart. and at some point it becomes useless.

market cap on its own should not even be used for analysis. and when you add coins like ether with 72+ million coins premined, ripple with billions coins locked away and all the smaller coins with billions and billions of coins that are contributing to the total market cap you are adding false data to your analysis.

The chart appears to be using cap by circulating supply rather than total supply. The billions in XRP therefore don't make any difference. As for pre-mining, the ability of this practice to inflate cap is limited to withholding supply from the free market at the expense of potential gains. This is easier when the sale is more secretive and restrictive, so that a single entity controls most coins, or several entities can collude.
sr. member
Activity: 447
Merit: 250
Worryingly, this reminds me of the dot com bubble of the late 1990s. If you check the market capitalization of some of the stocks (such as Cisco, Intel, Microsoft, and Dell) during that period, you can see a similar pattern.

Do you have any further details on this? It would be good to see a like for like comparison.

Thanks in advance.
legendary
Activity: 3472
Merit: 10611
when you use bitcoin price for analysis it is meaningful like that link
when you use bitcoin market cap then it is still meaningful but a little less
when you use altcoins' market cap you are decreasing the meaningfulness of your chart. and at some point it becomes useless.

market cap on its own should not even be used for analysis. and when you add coins like ether with 72+ million coins premined, ripple with billions coins locked away and all the smaller coins with billions and billions of coins that are contributing to the total market cap you are adding false data to your analysis.
legendary
Activity: 1582
Merit: 1064
Worryingly, this reminds me of the dot com bubble of the late 1990s. If you check the market capitalization of some of the stocks (such as Cisco, Intel, Microsoft, and Dell) during that period, you can see a similar pattern.

A lot of tech companies went bust after the dot com bubble and I am sure a number of alts will disappear too.
Like the tech leaders, only a few cryptocurrencies will survive once this bubble bursts.
sr. member
Activity: 1988
Merit: 453
Worryingly, this reminds me of the dot com bubble of the late 1990s. If you check the market capitalization of some of the stocks (such as Cisco, Intel, Microsoft, and Dell) during that period, you can see a similar pattern.
legendary
Activity: 1890
Merit: 1031
I am not sure, what do or must I see in the chart?  

legendary
Activity: 2968
Merit: 3684
Join the world-leading crypto sportsbook NOW!
Nice take @OP. I just did a quick search and found your little nugget from 2015, looks like your chart's been pretty accurate even after two years, yeah? In trajectory anyway, if not the $10k prediction for Nov 2017!

Curious if this will hold up over the next two if alt marketshare continues at current rate, or if something drastic happens to the USD.
full member
Activity: 168
Merit: 100
Bitcoin is the King
Thank you Guys. Amazing charts. And great video.
It's hard learning, been into Cryptos for 6 months only. It is an other world and that kind of tool help to see a bigger picture of it all.

So I guess we can carry on investing into crypto Currencies.  Cool
sr. member
Activity: 327
Merit: 250
The Best Investment Deserves The Largest Exposure
Thank you so much Trolololo   Cool

This chart is GOLDEN!!!


Just posted a video on it with my analyses:
https://www.youtube.com/watch?v=AaICCZVkIJk
hero member
Activity: 728
Merit: 500
please solve log(x)n = crypto
zby
legendary
Activity: 1594
Merit: 1001
If it is a logarithm chart on a log scale - than there should exist another log scale where it would be linear.
hero member
Activity: 924
Merit: 506
dayum I wish i could understand this more, but awesome!! 
Not only you are ignorant not understanding this but you are an especial ignorant posting and admitting about your own ignorance Cheesy
@OP, you are trying to contribute to this community but then you just ruined it by begging in form of donation Cheesy
legendary
Activity: 1762
Merit: 1011
Great work, thanks!
full member
Activity: 154
Merit: 100
dayum I wish i could understand this more, but awesome!! 
sr. member
Activity: 263
Merit: 280


To know where do this comes from: https://bitcointalksearch.org/topic/logarithmic-non-linear-regression-bitcoin-estimated-value-831547

Calculate today's trendline value HERE

Please, consider donating to bitcoin:19sEscR9bfH2ttXb5WbcabYbRGjq2znwPi

PS: Special thanks to Marc De Mesel

-----

Updated chart 27-12-2017
Jump to: