|
Title: spreadsheets/apps to help decide points to cash out? Post by: xDan on November 20, 2013, 01:44:36 PM 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... :D 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) Title: Re: spreadsheets/apps to help decide points to cash out? Post by: davider on November 20, 2013, 01:53:48 PM I did a google docs spreadsheet:
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 Title: Re: spreadsheets/apps to help decide points to cash out? Post by: xDan on November 20, 2013, 10:36:45 PM 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. Title: Re: spreadsheets/apps to help decide points to cash out? Post by: sgbett on November 20, 2013, 11:57:56 PM 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. 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 Title: Re: spreadsheets/apps to help decide points to cash out? Post by: xDan on November 21, 2013, 10:04:36 AM thanks sgbett, that's quite helpful, I have a starting point now at least :D
Title: Re: spreadsheets/apps to help decide points to cash out? Post by: sgbett on November 21, 2013, 02:48:57 PM the spreadsheet part is easy. sticking to the plan is harder :)
Title: Re: spreadsheets/apps to help decide points to cash out? Post by: xDan on November 21, 2013, 05:07:12 PM the spreadsheet part is easy. sticking to the plan is harder :) heh [removed spreadsheet, see website below] Title: Re: spreadsheets/apps to help decide points to cash out? Post by: xDan on November 28, 2013, 12:41:29 PM Update:
Introducing... --> The Amazing Bitcoin Retirement Fund Calculator (http://xzist.org/amazing-bitcoin-retirement-fund-calculator/) |