Well, yes. Because governments came out and said our currency is backed by gold and/or silver, so you can always exchange the money for that.
It's slightly different, I know, but if you cant buy goods in BTC, the currency is worthless.


And OP, are you dense for giving investment advice to friends and family? I'd rather have poor friends than none.
Never ever do this, this is the most risky asset they could possibly invest in and you CONVINCE them to buy it. What do you think happens when BTC goes to 0, they'll be like "whatever"? Hell no, they blame you for losing their money.
Given the small sum invested, it's most likely not a big deal, but refrain from doing that.
It also doesnt help the currency at all, because they have no idea what it is about and never use it, just see it as an investment.

If you want to help the community, tell them about BTC, educate them, this is what we need.

So, I calculated the standard deviations of logarithmic changes (ln(Price(n)/Price(n-1)) and multiplied by square root of sample to get annualized standard dev.

Total: 26.77807002
Since April 1st: 7.344956362


Are those numbers reasonable?

Your formula doesnt work for an unknown reason and I dont get why.

Edit: I split it between two columns and it works now.

Idiot me.

1282038389,0.06300000,100.00000000

Ok, I misunderstood sth.

Ok, first one is time and I used the excel formula above and it didnt work for time only date.

=DATE(1970;1;1+(A3/(60*60*24)))+TIME(MOD(INT(A3/3600);24);MOD(INT(A3/60);60);MOD(A3;60))

Is this correct? I had to replace , with ;

I havent downloaded it, because I cant download it in .csv format, it just shows me a HTML page with all the values and I look at it and say wtf.

Can you explain to me how I can get them with timestamps? My browser just shows me the the content of a .csv file and I cant really use it.