Post
Topic
Board Trading Discussion
Merits 1 from 1 user
Re: JJG's Bitcoin Investment Ideas (Sustainable Withdrawal / Portfolio Maintenance)
by
fillippone
on 23/12/2023, 22:02:05 UTC
⭐ Merited by bitmover (1)
I am not sure if it might be helpful to better highlight which numbers are changeable and which numbers have formulas. 
What about this?

All the cells that need to be edited are highlighted in Green. 
Every other format is directly computed from those green cells cells.
Settling a unique format for the cells to be edited can be a nice idea, even more if this is coherent across the various spreadsheets.

Yes.  That does look better in terms of highlighting that the green fields are the ones in which data would be entered, and then Viola!!!!! The spreadsheet will do the remainder of the calculations based on what is put into the green input fields.. although the labels are not input fields.. #justsaying..  hahahahaha

And, yeah, it is probably better to choose some kind of a similar format across various spreadsheets, whether it is color or some other way of distinguishing input fields from non-input fields.

Opening Post 2:  Creating monthly withdrawal limits - based on the then BTC Spot price's direction and distance from the 200-week moving average, and of course a withdrawal rate and quantity of coins in the account
Ideas of sustainable withdrawal that attempts to measure monthly budget limits based BTC spot price relative to the 200-week moving average
I have been working with JJG in a tool to implement this idea in a website. We will release the first version soon, and it will be nice to see fillippone and others who are discussing this giving their suggestion about this new tool.

Yes.  Thanks a lot bitmover.  Like you suggested, I think that we are getting very close to a version that would be ready for public release and open for public commentary.  Furthermore, the website (rather than spreadsheet) design would likely be more user-friendly, yet I am thinking that we still might have some uphill battles in regards to getting folks used to thinking about spot price in relation to 200-week moving average - because people get so focused upon spot price, and maybe even become confused about what to do in regards to managing their bitcoin holdings and when to do it, and hopefully tools like this can be helpful in terms of providing some guidelines to bitcoin holders in regards to more conservative, moderate and/or aggressive ways in which they might choose to spend their coins.

This is a very interesting strategy. I plan to implement this strategy in my personal BTC withdrawals from next month, as we are moving to confortable rates above the 200WMA now (about 47% already)

For sure, anyone who considers using either this strategy or even the strategy that is described in Opening post 3, may well need to consider whether he has assessed his bitcoin to be in a kind of "overaccumulation" or even a sufficiently adequately accumulated status, so in that regard, I consider either the strategy from Opening Post 2 or the one from Opening post 3 to help to serve as ways to provide insurance for something close to inevitable bitcoin volatility that has been in its history, and there is no reason to conclude that such inevitable volatility is not going to continue into the future, and surely we do not always know which direction the BTC price is going to go or how intense such price performance is going to be in one direction or the other.. but one of the things that does seem most guaranteed about bitcoin and its price performance is that it is quite strongly likely to continue to be ongoingly volatile.

By the way, from my discussions with bitmover, it does seem that he is planning to start a new thread in regards to the website related to Opening Post 2, and I will likely continue to keep this thread active and provide a link to such thread, if that is the direction that the discussion goes.  We are also in discussions regarding the creation of another website for Opening post 3, and over the years, I had seen some of bitmover's earlier work products in the creation of websites about bitcoin (and form-related) subject matters, and of course bitmover has a thread in which he talks about his bitcoin unit conversion website.. which is a pretty handy tool for quick conversion of BTC (or choose other bitcoin units) to dollars but to other currencies (and a bonus that it does not include shitcoins - unless you want to consider fiat as a shitcoin?.. hahahahhaha).

I just erudireste the labels as per your suggestion!
And
u]Voilà!!!!! [/u]

Now the spreadsheets updates automatically when you enter the numbers in the green cells.

I can’t wait to see the final website.
Even if I have a concern: if you want to play with those hypothesis, you might want to come back multiple times. Coming back multiple times call for some sort of registration: but is this privacy friendly?