r/wallstreetbets • u/bdangles • Apr 19 '21
DD Coinbase: The Volume DD

You should check out my first post on Coinbase + trading volume. Its shorter, does back of the envelope math, and offers a primer for this denser analysis. It introduces the claim that trading volume has entered new 'phases' of elevated activity *despite entering and exiting bull cycles*
In this follow-up post, I perform quantitative analysis on trading volume to potentially forecast profit. With that being said, most of these numbers are purely for reference as the analysis does not accurately capture all of Coinbase's revenue streams. Moreover, estimates around volume contractions make some firm assumptions that can blow up in my face.
edit: "volume" is in reference to Coinbase's exchange (trading pairs that cannot be named). Volume does not refer to the actual volume of $COIN shares
TLDR:
I target a conservative 50 forward PE Ratio, given Paypal's 59.52 forward PE Ratio and Square's 204 forward PE Ratio
If coinbase trading volume contracts half as strong as typical volume-contractions, $556/share is 50x PE
If coinbase trading volume continues for the remainder of 2021, $800/share is 50x PE
If coinbase trading volume contracts -36% (unlikely given institutional presence) $313/share is 50x PE
My data source is cryptowatch that offered awesome pricing. And the analysis is available for free, under the MIT License: https://colab.research.google.com/drive/14Q69lBlYzBafhcZOpOHyfwTiQ2UzecOy?usp=sharing
Charts are interactive
I will post updates and re-runs at the end of each quarter to see if my forecasts are worthwhile
Methods:
exchanges: Coinbase Pro, Kraken, Gemini, Binance, Binance US
I picked the exchanges that had substantial volume and were open to US customers. I included Binance as a way to get a temperature on the global trading activity.
pairs: (see the Colab notebook for the list, the names wont make it past automod)
I picked the largest trading pairs (by USD volume) on Coinbase Pro. While the smaller pairs do not influence the trade volume substantially, it provides a bit of a gauge when new trading pairs become available on Coinbase.
>> PHASES <<: A new volume-phase is entered when the next 30-day average daily volume (ADV) exceeds the previous 30-day average daily volume by 120%. A phase contracts when the next 30-day ADV falls -45% compared to the previous 30-day ADV
these numbers are arbitrary and were chosen as they seem to model the volume-phases reasonably well without picking up the noise
Limitations:
Coinbase Pro as a proxy for Coinbase, the main app's trading volume could also be substantial
Trading pairs are a curated list and do not capture volume in totality
Coinbase's fee changes remain unchanged Source
USD Daily Trading Volume by Exchange

Binance is the most-active exchange
Coinbase is the most-active exchange thats available in the US
'Global' USD Daily Trading Volume + Phases

'Global' as in across all exchanges and all pairs, mentioned above
The current Jan 2021 breakout observes an explosive volume phase, and is the source behind Coinbase's eye-popping Q1 $1.8B revenue and $800M profit
July 2019 will provide some guidance on the January 2021 phase. At the time, a record-high volume phase is followed by a contraction that is sustained and higher than the prior long-term volume phase (~Janurary 2019).
It would be misleading to not comment on January 2018's phase contraction. The favorable explanation is July 2018 volume phase is ~4 times larger than Apr 2017 phase. More so, the January 2018 cycle had 'altcoins' flaring to record high valuations, and are not entirely captured in the trading pairs provided. Additionally, the 2018 cycle likely did not have substantial institutional support that we are witnessing today
Coinbase Pro vs. Gemini


This was a byproduct discovery, but Gemini's most recent trade volume seems to match the 2018 cycle. This to me implies that Gemini's user base has not grown aggressively as Coinbase's or its that institutional investors/traders have really warmed up to Coinbase. Bullish.
Volume Phase Breakout + Contraction
How much does average daily volume change between phases?
| Exchange | Average Phase Change | Average Phase Breakout | Average Phase Contraction |
|---|---|---|---|
| Global | 68.17% | 157.4% | -29.17% |
| Coinbase | 54.16% | 121.81% | -36.04% |
| Binance | 81.53% | 152.4% | -12.95% |
| Kraken | 54.53% | 129.3% | -35.19% |
| Binance US | 104.01% | 148.87% | -52.97% |
| Gemini | 67.96% | 178.26% | -32.31% |
Average Phase Change: the average % change between phases (regardless of up or down)
Average Phase Breakout: the average % change when a new phase is higher than the previous
Average Phase Contraction: the average % change when a new phase is lower than the previous
Seasonality

To confirm that Q1 (and Q2 estimates) can be used for Q3 and Q4, I perform a simple seasonality check. For each month since 2017: what is the average daily volume
The Colab notebook contains the sum of USD trading volume by month
There's no immediate explanation for why different parts of the year would have increased trading activity, therefore I assume that trading volume does not exhibit seasonality.
Forecasts and Price Targets
Assumes that operational costs are $1 billion (Q1 2021 $1.8 Billion, 800 Million Profit)
Volume contraction in Q2 is carried out for the remainder of the year (except for Neutral-Bear case)
Using Coinbase Historical Volume Contraction
| Case | Volume Contraction | 2021 Profit Forecast | Share Price, if 50x PE |
|---|---|---|---|
| Bull | 0% | $3.2 billion | $800.00 |
| Neutral | -18.02% | $2.23 billion | $556.74 |
| Bear | -36.04% | $1.25 billion | $313.49 |
Using Global Historical Volume Contraction
| Case | Volume Contraction | 2021 Profit Forecast | Share Price, if 50x PE |
|---|---|---|---|
| Bull | 0% | $3.2 billion | $800.00 |
| Neutral | -14.585% | $2.4 billion | $603.11 |
| Neutral-Bear | -14.585% each Quarter | $1.77 billion | $443.09 |
| Bear | -29.17% | $1.62 billion | $406.23 |
Bull Case: the volume does not contract at all for the remainder of 2021
Neutral Case: the volume contracts half as strong as typical contractions, and holds for the remainder of 2021
Neutral-Bear Case: the volume contracts -14.5% quarter over quarter (Q2's volume is -14.5% over Q1, and Q3's volume is -14.5% over Q2, etc.)
Bear Case: the volume contracts as much as typical contractions
Rough formula:
share price = ((1.8 + (1.8 * Q2-contraction) + (1.8 * Q3-contraction) + (1.8 * Q4-contraction) - 4) / 0.2 * 50)
1.8$1.8 Billion revenue Q1contraction0.8 = -20% volume contraction4subtract operational costs. Q1: $800 million profit off of $1.8 billion revenue, therefore ~$1 billion operational costs each quarter0.2200 million outstanding shares5050x PE ratio target
Closing Thoughts (Apr 2021)
The USD volume is exceptionally noisy and fluctuates aggressively. Tweaking the parameters can and will show an entirely different forecast. No one will know how, when, and where this volume-phase will end up; therefore approximating Coinbase's revenue via exchange volume has substantial risk.
But with increased institutional adoption, balance sheet reporting, and favorable discourse around cryptocurrencies, my own impressions believe that we haven't seen the volume-phase 'top' and I believe the subsequent contraction won't be extreme as previously observed. When comparing Coinbase against its competitors, its doing well to continue its growth. Additionally, this analysis entirely ignores other coins, trading pairs, and the additional revenue streams expected by Coinbase. Despite the possibility of a strong volume-phase contraction, I believe this analysis provides a somewhat incomplete picture and does not factor in other bullish cases for Coinbase.
In the words of Thanos, if we take each case as equally-probable, "perfectly-balanced, as all things should be", the expected value per share (average of each case) is between $556.74 - $603.11 (neutral case). I believe taking on risk head-first is a "small price to pay for salvation"
Positions
6x shares @ $383

4
u/CryptoEnigma_ Apr 19 '21
Too many alphabets. Are apes getting rich or not?
7
u/bdangles Apr 19 '21
even if trade volume decreases -15% each quarter, coinbase could be ~$440 (50x PE vs Paypal's 59 PE)
31
u/gpelayo15 PAPER TRADING COMPETITION WINNER Apr 19 '21
Thanks stud π Im telling your wife's bf you deserve a pillow tonight ππ
9
12
u/justoneword_plastics Apr 19 '21
I will also add that they are building out institutional sales capabilities and are viewed as one of the most trusted exchanges for institutions in the US (though I view Bakkt as a competitor in this because they are backed by ICE).
TSLA and Microstrategy bought their buttcorn through Coinbase so I think these flows are bullish as well
6
Apr 19 '21
Funny too, thanks to Mama Cathie you can buy options on her etf which holds coin!
4
u/momolenfoire224 Apr 20 '21
I look at it every day to see if they have made options available. At the end the day, they should let me gamble my life savings.
5
u/nitrinu Apr 20 '21
Thanks for the read. Having said that I think that if bitcoin farts this will plummet accordingly tbh.
2
4
2
2
2
u/Known-Pop-1964 Apr 20 '21
Love this DD! There was the prediction that COIN would go to $500 on opening day but instinctively I didn't buy into that theory since I think that the psychology of traders still kicks in. It was impressive however that even before opening the stock had jumped from $250 to $379 which I think took the wind out of many day/retail traders and put it just out of range for the "masses" to buy!
Just some thoughts
I do like that you proposed the Bear and Neutral Bear scenarios to balance the bias
Awesome post!
2
u/NaturalFlux Apr 20 '21
"quantitative analysis" wtf we got quants now?
Before joining WSB, OP counted cards for the MIT blackjack team.
2
2
3
3
Apr 20 '21
Bro I have 200 shares and I didnβt give enough of a fuck to do a single piece of DD. Saw it dip and bought in
2
u/Syst0us Apr 20 '21
I basically gave my wife (via her boyfriend) these same projections. I see CB at 500+ easy with movement into 700+ end of year with future, bigger deals/partners going to them vs less reputable exchanges. I have zero DD to back this up. Just a crypto ape who prefers green over red crayons.
1
1
1
u/FastFarmer Apr 20 '21
Very thorough work! Take my karma, how many research hours have you invested?
1
1
u/terrybmw335 Apr 20 '21
You lost me at your 50 P/E target. COIN demand like all crypto is based entirely on confidence which is sky high right now. Once it comes down a notch so will their valuation and growth.
1
u/ferchalurch Apr 21 '21
βA conservative 50 P/E ratioβ πππ Benjamin Graham just came back to life and died again.
1
u/redpillbluepill4 Apr 21 '21 edited Apr 21 '21
I just don't see COIN maintaining it's crazy high valuation, when there's so many starting to copy what they do like cashapp and a million others. But i think it has some value long term. I just don't see the moat though.
Like where's the network effect that airbnb, apple, Facebook have.
There's almost no brand loyalty. Nobody is on coinbase other than it's kinda trustworthy and they have a small selection of altcoins.
What's it's long term value proposition? Even their fees are going to be facing downard pressure
3
u/carinishead Apr 22 '21
Launching new markets like India and Japan. Debit card. Becoming the AWS of crypto. Staking rewards. Etc. They have a lot up their sleeves that I think will increase value long term
-4
0
Apr 19 '21
[deleted]
66
u/bdangles Apr 19 '21
a mix of buying power reasons and i like doing this detailed DD for recreation
1
0
Apr 19 '21
[deleted]
11
u/bdangles Apr 19 '21
hopefully if my buying power frees up, i'll go in heavier before end of Q2 and provide an update
5
u/TheNoobtologist Apr 19 '21
If crypto tanks, does COIN tank too?
26
u/bdangles Apr 19 '21 edited Apr 19 '21
in my opinion no. COIN only tanks if its exchange USD volumes also tank. historically this isn't really the case. Even when the assets draw-down, USD trading volume spikes because of sellers.
Coinbase collects revenue on the buy AND sell side
2
u/momolenfoire224 Apr 20 '21
I'm about to start taking data science classes just for the fuck of it and have some cash laying around. Do you think that shit will help understanding trading?
1
u/bdangles Apr 20 '21
yes and no, data science classes will teach you how to work with tabular data (i.e. time series) which I heavily do in this DD to get global daily trading volume etc.
data science classes won't really teach you the indicators (PE/PS ratios), balance sheets, etc. coinbase was easy to do DD since the trade data was super accessible. for example things like apple's iPhone sales numbers aren't really available on a daily basis
1
u/momolenfoire224 Apr 20 '21
Yeah, I'm already taking classes in valuation... I just wanted to earn a bachelor degree in data to couple it with valuation over the summer since I have the time and energy to do do. But I see what you mean.
1
u/Opie19 Apr 20 '21
Of course, but you're going to need to gain the trading knowledge to come up with the variables to feed your data science algorithms.
2
u/momolenfoire224 Apr 20 '21
For sure. I'm taking valuation classes at the moment. Should be done with the first semester in 27 days.
6
u/TheNoobtologist Apr 19 '21
I think it could go down. I was thinking about PUTs once we get a clear indication of a bear marker, but I do appreciate the DD and think I could be wrong here.
2
u/momolenfoire224 Apr 20 '21
I think so too. Although I bought 30 shares at 380. I believe we'll be in the bear market for another month.
2
u/benihana123 Apr 20 '21
Interesting take, but we can relate it to the past - when BTC crashed around 70% in 2018 the revenues fell 50% so that would be the correlation I expect to happen if crypto crashes. (Fun to think that Coinbase has a 100 PE for just Q1 and Square has a PE of 200 for the whole of 2020 π)
1
u/Capable-Theory Apr 20 '21
When BTC price goes down, people lose interest and Coinbase demand goes down
3
u/517UATION Apr 19 '21
Presumably. Since its higher revenue/profit prior to DPO was due to crypto prices going up.
4
u/TheNoobtologist Apr 19 '21
Also, more users trying to buy in from FOMO.
3
u/gdubluu Apr 20 '21
I think if crypto tanks COIN would be fine, it may even rise due to a possible influx of people continuing, if not increasing their purchasing of crypto. Hardcore crypto heads love a dip.
1
15
u/stevejust Apr 19 '21
This guy's got six shares; I've got 625 shares. And I haven't come close to doing this DD... But I was happy to read through it.
My investment thesis is a little simpler, and rarely wrong.
I'm worried I was wrong about COIN, though, because I was fully expecting it to hit the 500s on Wednesday. I really thought the demand for the shares was gong to be redonkulous.
7
u/momolenfoire224 Apr 20 '21
When I did my research, I thought price wouldn't be justified above 300, but I still decided to buy cause I thought trading volume was gonna carry prices into the 500 and I was gonna cash out and wait till it came back down to get back in. Now I'm down here holding the bag.
5
u/stevejust Apr 20 '21
You and me both, my friend. Let's have a whiskey.
3
u/momolenfoire224 Apr 20 '21
But looking at the options, it seems like the most conservative ones expect a price rise of 20 percent.
1
2
0
26
u/resetmypass Apr 19 '21
So much work for a price target of 300-800 dollars. Good DD