Post
Topic
Board Speculation
Re: Gold collapsing. Bitcoin UP.
by
hdbuck
on 30/06/2015, 09:09:29 UTC
I am struggling making a comparaison chart of Bitcoin's vs Euro's volatility, anyone knows a tool to do so please?

A while back I put something on this thread which touches both on how to obtain data from someone else's Google spreadsheet (using it as a quasi-database) and also feeding data into gnuplot.  Sometimes I get carried away trying to do one-liners on the command line (though I'm losing my edge for lack of practice over the last few years.)  Probably won't do you much good, but here it is:

  https://bitcointalk.org/index.php?topic=68655.msg925384#msg925384



erf i'm having this excel issue, where i have on one cell multiple data

for ex: 2015-06-14,233.8536,5.454695278537045,0.004716184177479654,0.011187287496159574

how do i separate and reaffect each to single cell?

Don't know much about excel (have not used it for several decades) but you might try making sure you import the data as 'csv' (comma separated values.)  It looks like it is such but excel is not interpreting it that way.

It is also sometimes the case that the input data can have something which excel interpreted as 'escapes'.  That is, it might be being inadvertently instructed to be treating the commas as literal values.



yea no i have managed it thx,

in the end i have this:



so bitcoin is more stable than euro! Grin

Édit: any feed-back tho? Im having doubts as to if i have done it right..