Unix time importing

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason

delta575
Posts: 1
Joined: Fri Aug 28, 2015 1:32 pm

Unix time importing

Postby delta575 » Fri Aug 28, 2015 1:37 pm

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

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13604
Joined: Tue Sep 16, 2008 5:38 pm

Re: Unix time importing

Postby EViews Gareth » Fri Aug 28, 2015 2:24 pm

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.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests