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
Unix time importing
Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason
-
EViews Gareth
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13604
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Unix time importing
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:
Then structure by the new date series.
Code: Select all
series date = unixtime/86400+@dateval("01/01/1970")
Who is online
Users browsing this forum: No registered users and 2 guests
