spreadsheets/apps to help decide points to cash out?

[xDan]

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)

[davider]

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

[xDan]

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.

[sgbett]

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

[xDan]

thanks sgbett, that's quite helpful, I have a starting point now at least

[sgbett]

the spreadsheet part is easy. sticking to the plan is harder

[xDan]

the spreadsheet part is easy. sticking to the plan is harder

heh

[removed spreadsheet, see website below]

[xDan]

Update:

Introducing...

--> The Amazing Bitcoin Retirement Fund Calculator