Update:
Introducing...
--> The Amazing Bitcoin Retirement Fund Calculator
Topic: spreadsheets/apps to help decide points to cash out? (Read 1213 times)
the spreadsheet part is easy. sticking to the plan is harder 
heh
[removed spreadsheet, see website below]
the spreadsheet part is easy. sticking to the plan is harder
thanks sgbett, that's quite helpful, I have a starting point now at least 
I... I don't really think that helps me 
I don't need to know the current price for any reason.
Surely this sorta thing is commonly done though, for other assets/investments.. Maybe it's just elementary spreadsheet stuff but I just can't get my head around spreadsheets, they're too damn boring.
I don't need to know the current price for any reason.
Surely this sorta thing is commonly done though, for other assets/investments.. Maybe it's just elementary spreadsheet stuff but I just can't get my head around spreadsheets, they're too damn boring.
say you want to sell 5% every time the price doubles.
row 1 put this stuff
column a - [current BTC holding]
column b - [A1*0.05]
column c - [current BTC price]
row 2 put this
column a - [A1-B1]
column b - [A2*0.05]
column c - [C1*2]
copy row 2 and paste it into the next 20 rows or so, it should automagically adjust formulas.
your spreadsheet then shows
column1 - remaining bitcoin
column2 - your target sell amount in BTC
column3 - your target sell price in BTC
tweak the multipliers, tweak the percentage, until you like what you see
if you can't do spreadsheets, then try pencil, paper and a calculator. thats how it was done before spreadsheets were invented
if you think that sounds like a pain in the ass, it is, thats why you learn spreadsheets
I... I don't really think that helps me
I don't need to know the current price for any reason.
Surely this sorta thing is commonly done though, for other assets/investments.. Maybe it's just elementary spreadsheet stuff but I just can't get my head around spreadsheets, they're too damn boring.
I don't need to know the current price for any reason.
Surely this sorta thing is commonly done though, for other assets/investments.. Maybe it's just elementary spreadsheet stuff but I just can't get my head around spreadsheets, they're too damn boring.
I did a google docs spreadsheet:
I use these formulas:
Bitstamp price
LTC price
To test scenarios you can use the IF formula:
http://spreadsheets.about.com/od/otherspreadsheets/qt/090808-google-spreadsheet-if-function.htm
Hope it helps
I use these formulas:
Bitstamp price
Code:
=Index(ImportHTML("http://bitcoincharts.com/"&"?workaround="&INT(NOW()*1E3)&REPT(GoogleFinance("GOOG");0),"table",4),4,2)
LTC price
Code:
=SUBSTITUTE(Index(ImportHTML("http://www.cryptocoincharts.info/period-charts.php?period=today&resolution=hour&pair=ltc-usd&market=btc-e", "table", 0), 24, 5), " USD", "")
To test scenarios you can use the IF formula:
http://spreadsheets.about.com/od/otherspreadsheets/qt/090808-google-spreadsheet-if-function.htm
Hope it helps
Has anyone made any spreadsheets/apps to help decide when to cash out?
Like, say, I start with X bitcoins and decide I'll sell X/10 of them every time the price doubles, and the spreadsheet/app will then show me some graph showing the resulting $$ over time including the final amount.
and for other methods too,
e.g.
- selling X amount every time the price goes up by fixed $ amount Y
- perhaps combining strategies, selling X amount every Y increase, along with also selling Z amount every doubling...
- selling X amount every Y% increase (so it compounds but not as exponentially as doubling... I don't really understand this stuff)
Just something to play with, to experiment with finding the optimum balance between shorter term reward, while still keeping the possibility of getting filthy rich if the price does ever go up a few more orders of magnitude...
feel free to tell me your strategies...
(of course, I never intend to *fully* cash out - this should be more thought of as a simple diversification / spreading of risk. I would apply these strategy to just a portion of my BTC, e.g. 2/3 of it)
Like, say, I start with X bitcoins and decide I'll sell X/10 of them every time the price doubles, and the spreadsheet/app will then show me some graph showing the resulting $$ over time including the final amount.
and for other methods too,
e.g.
- selling X amount every time the price goes up by fixed $ amount Y
- perhaps combining strategies, selling X amount every Y increase, along with also selling Z amount every doubling...
- selling X amount every Y% increase (so it compounds but not as exponentially as doubling... I don't really understand this stuff)
Just something to play with, to experiment with finding the optimum balance between shorter term reward, while still keeping the possibility of getting filthy rich if the price does ever go up a few more orders of magnitude...
feel free to tell me your strategies...
(of course, I never intend to *fully* cash out - this should be more thought of as a simple diversification / spreading of risk. I would apply these strategy to just a portion of my BTC, e.g. 2/3 of it)
Jump to: