38 Comments
User's avatar
BowTiedBiotech's avatar

Iguana just exploded heads all over substack.....any chance we can get the formulas on those columns sir?

Expand full comment
Night Owl's avatar

He does that to me daily in DMs

Expand full comment
Jeff c.'s avatar

Any modifications to the portfolio construction article or keep as is?

Expand full comment
BowTiedIguana's avatar

Sure...

Column | Formula

A | Date

B | Price

C | Percent Change =(B3-B2)/B2

D | Standard Deviation =STDEV(D2:D31) #This is for 30 days

E | Annualized =E2 * sqrt(365.25)

F | Volatility of a $10k investment =(E2/SQRT(365.25)*10000)

G| Return to volatility comparison =E2/(F2/SQRT(12))) #12 months in a year ~= 30 days

H| Investment required to hit $500 volatility / day =(500/F6)*10000

I | Cost:Volatility =(trade_cost_usd/H2)/E2

Expand full comment
TheOtherGuy's avatar

Hi, for column A, I am assuming that there are 30 rows for each day of the month? Hence, the 30 day percent change would be (B31-B2)/B2?

Could you share how to automate the pulling of Coingecko daily prices via their API? I can't seem to do it via Cryptosheets haha.

Expand full comment
BowTiedIguana's avatar

Sorry I missed this!

Expand full comment
BowTiedBiotech's avatar

What are you doing for the Bull Case FDV calculation?

Expand full comment
hobo's avatar

That should be G*(1+F), MC augmented by the yearly volatility

Expand full comment
hobo's avatar

Wow that's great, thanks

Expand full comment
BowTiedPilled's avatar

thank you

Expand full comment
mastodon's avatar

I can't tell if that's horrible opsec that Owl posted his home address (Destination Degenistan, Home of the Apes)....or maybe he is such an Apex Predator he DNGAF if someone shows up at his place?

Expand full comment
Night Owl's avatar

I don’t live there. I do frequently vacation there though

Expand full comment
BowTied Phoenix's avatar

Great post! Will need to read three more times

Expand full comment
Dr Frog's avatar

Thank you sirs, nice to see the different approaches.

Expand full comment
Patricius's avatar

Good Read

Expand full comment
ethxxk's avatar

Hi, this is a great post! I recently subscribed to this substack. Is there a discord associated with it?

Expand full comment
BowTiedIguana's avatar

Welcome, please ask any questions here, we do not have a discord for DeFi Education.

Expand full comment
RM's avatar

do you plan to look at Temple DAO

Expand full comment
Night Owl's avatar

Yes we can cover it - I am invested in it.

Expand full comment
RM's avatar

Excellent - thank you

Expand full comment
Doge Brogan's avatar

wow ... these posts covering practical aspects of defi are amazing! Can you help me out with these?

(1) "Intuitively we know that it would be cheaper to allocate to a more volatile token due to the fixed costs (gas) and variable costs (slippage)." Can you explain the logic here? If a token is more volatile for example, the negative slippage could be v high. Thus, why would it be cheaper?

(2) Iguana - any possibility of providing a website that shows the charts you laid out on a real time basis? Like allow us to add a token and compare the return volatility of different projects etc.

Thanks man!

Expand full comment
BowTiedIguana's avatar

(1) Generally you need a lower dollar investment to get equivalent exposure ($ change per day) with a higher volatility token. e.g. buying $4.5k of SPELL vs $20k of Balancer. Yes you need to account for spread/slippage which can be worse on volatile tokens, so you make a good point.

(2) This could be useful! Any suggestions on where we could host it? Maybe a Google Sheet would do?

Good comments, thanks!

Expand full comment
Doge Brogan's avatar

Thanks Iguana for the responses!

On (2), while a simple Google Sheet will be fine, I guess placing it on (https://bowtiedisland.com/crypto-investing/) website would be even better? That way you can draw traffic to this Substack too :)

Expand full comment
Alex The Cat's avatar

Thanks for such a great post. Could you guide me to know where to pull the correct data for current FDV, %vol change? On coinmarket, it's showed market cap and FDC, could we use those data? btw, for the bull case FDV, how can we calculate this or we based on the valuation method from the Defi Substack?

Expand full comment
Helmut Stonegaarden's avatar

Owl, when you talk about 5X target, you mean in BTC or ETH terms or in the American fiat unit?

Expand full comment
Sindhu Sahab's avatar

Hi Team, may you please share your portfolio allocation and coins for all of us to get an idea. This can help us in kind of following your portfolio. May be it can be used as a future article.

Expand full comment
JJJ's avatar

Once some base level of wealth is built via crypto, wouldn't it then be ok to make a few small, ultra-degen bets?

BTB says to never use leverage, but with enough wealth wouldn't those trades begin to make more sense? If your team were to make an ultra-degen bet, what would it be? Crypto options?

Expand full comment
BowTiedIguana's avatar

Bulls view was (buy) options because it is obvious that your investment goes to zero if you aren't right in a precise time window. That way you don't take on too much risk as a loss should be an expected occurrence.

I've seen people make it by taking on nosebleed level risk. Sometimes whatever edge you have can be gone if you don't hit it hard and quickly. Haven't seen anything that compelling in DeFi yet though.

Expand full comment
btfpl's avatar

love it - a lot of thoughts/ideas running through my head - related question for you - how/where the hell do you go for researching coins? I'm in crypto twitter but keep feeling like I only hear about coins (toke, spell, ohm, etc) once they've made it mainstream. Where/how can I research small caps before they go mainstream?

Expand full comment
BowTiedIguana's avatar

We're addressing the same question and will be leveraging automation (e.g. scrapers).

Expand full comment
JF's avatar

Iguana - would love to riff a bit on using FDV as a metric vs. Current cap. I always tell folks to ignore FDV because emissions schedules vary wildly from protocol to protocol. Curve, for example, won't hit its FDV for another 300 years. Tend to focus on current cap (price x circulating supply).

Using FDV, would agree with your analysis but not sure it's apples to apples from protocol to protocol.

Thoughts?

Expand full comment
Night Owl's avatar

Market cap + FDV + unlock/distribution schedule

We look at all three. Relative importance of each metric is case by case. By using FDV you risk being too conservative in some cases. Using market cap exclusively you risk missing incoming dumping. Hence, have to look at all the metrics and make a judgment call. For purposes of comps, we show both market cap and FDV, but when doing a deeper dive it’s important to understand what the supply dynamics actually are

Expand full comment
JF's avatar

Thank you for responding and appreciate the difficulty in trying to generate comps in an industry that doesn't have a ton of standardization. Am also just trying to use best judgement. Unlock schedules should be a standard part (and front / center) of project docs definitely the most opaque part of risk.

Great post!

Expand full comment
BowTiedIguana's avatar

Owl nailed it!

Expand full comment
User's avatar
Comment deleted
Nov 13, 2021
Comment deleted
Expand full comment
Night Owl's avatar

Thanks for reading! I use Zapper.fi + excel

Expand full comment
RiskOn's avatar

Zapper.fi currently doesn't support BTC does it. Only EVM compatible chains

Expand full comment
Desichad's avatar

It does.

Expand full comment
BowTiedIguana's avatar

I think Zerion did or does support BTC watch only wallet addresses also.

Expand full comment