Page 1 of 1

Unix time importing

Posted: Fri Aug 28, 2015 1:37 pm
by delta575
Hi, is there a easy way to import a .csv with unix time?

I'm working with bitcoin data for my thesis and I need to make price closes every 5 - 15 - 30 - 60 minutes.


The database I'm using can be obtained here:
http://api.bitcoincharts.com/v1/csv/bitfinexUSD.csv.gz

Thanks

Re: Unix time importing

Posted: Fri Aug 28, 2015 2:24 pm
by EViews Gareth
EViews doesn't understand unixtime by default, but it is easy to work around. Bring the file in as you normally would. Then convert the unixtime stamp into an EViews date:

Code: Select all

series date = unixtime/86400+@dateval("01/01/1970")
Then structure by the new date series.