Date Issues When Importing

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

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

fmantessof
Posts: 24
Joined: Fri Aug 14, 2015 7:54 am

Date Issues When Importing

Postby fmantessof » Fri Aug 14, 2015 12:57 pm

I cannot make Eviews recognize the date series . It reads the Excel file and try to open it is as an undated file. I tried to delete all the rows below the worksheet and the columns besides to clear them out, but it still does not recoginze....Help !!

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

Re: Date Issues When Importing

Postby EViews Gareth » Fri Aug 14, 2015 1:06 pm

Could you provide an example?
Follow us on Twitter @IHSEViews

fmantessof
Posts: 24
Joined: Fri Aug 14, 2015 7:54 am

Re: Date Issues When Importing

Postby fmantessof » Sat Aug 15, 2015 11:20 am

Please, see the screen shots attached. I selected to open a foreign data as workfile, it opened the data series, but it did not recognize the date column as dates and I cannot open the file as a data series only as a unstructured data.
Attachments
Screenshot 2015-08-15 15.10.16.png
Screenshot 2015-08-15 15.10.16.png (62.47 KiB) Viewed 2850 times
Screenshot 2015-08-15 15.10.34.png
Screenshot 2015-08-15 15.10.34.png (65.81 KiB) Viewed 2850 times
Screenshot 2015-08-15 15.10.16.png
Screenshot 2015-08-15 15.10.16.png (62.47 KiB) Viewed 2850 times

fmantessof
Posts: 24
Joined: Fri Aug 14, 2015 7:54 am

Re: Date Issues When Importing

Postby fmantessof » Sat Aug 15, 2015 11:22 am

SORRY I MISSED THE LAST ONE THAT SHOWED WHAT I MEANT
Attachments
Screenshot 2015-08-15 15.11.32.png
Screenshot 2015-08-15 15.11.32.png (69.21 KiB) Viewed 2849 times

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

Re: Date Issues When Importing

Postby EViews Gareth » Sat Aug 15, 2015 2:36 pm

Can you provide the actual Excel file?
Follow us on Twitter @IHSEViews

fmantessof
Posts: 24
Joined: Fri Aug 14, 2015 7:54 am

Re: Date Issues When Importing

Postby fmantessof » Sat Aug 15, 2015 3:50 pm

This happens frequently in different type of files and I couldn't find a reason for this yet. I selected to send you a very simple file as an example of one of the cases this is happening
Attachments
Pasta1.xlsx
(225.08 KiB) Downloaded 68 times

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

Re: Date Issues When Importing

Postby EViews Gareth » Sat Aug 15, 2015 4:49 pm

That file doesn't contain a valid date series. If the Excel file doesn't contain a valid date series, EViews won't be able to select a date series.
Follow us on Twitter @IHSEViews

fmantessof
Posts: 24
Joined: Fri Aug 14, 2015 7:54 am

Re: Date Issues When Importing

Postby fmantessof » Sat Aug 15, 2015 6:04 pm

That's the issue, I know, but why is this a non valid date series ? This are date series downloaded directly from yahoo finance or google finance, what can I do as a process to find the error and fix it ? tks

fmantessof
Posts: 24
Joined: Fri Aug 14, 2015 7:54 am

Re: Date Issues When Importing

Postby fmantessof » Sat Aug 15, 2015 6:21 pm

I found the mistake ! This data series came from Wiki and comparing to Yahoo's one there is some dates missing...I downloaded again and the series came again with the missing dates..tks

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

Re: Date Issues When Importing

Postby EViews Gareth » Sat Aug 15, 2015 6:35 pm

Generally if EViews refuses to auto-recognize a date series it is because there is something wrong with that date series
Follow us on Twitter @IHSEViews

fmantessof
Posts: 24
Joined: Fri Aug 14, 2015 7:54 am

Re: Date Issues When Importing

Postby fmantessof » Sun Aug 16, 2015 4:54 am

Gareth, I tried with a file that seemed to be a correct data set, and it worked the same....This one is a direct download of BXP ticker from yahoo finance, see attached
Attachments
Workbook3.xlsx
(324.77 KiB) Downloaded 74 times

fmantessof
Posts: 24
Joined: Fri Aug 14, 2015 7:54 am

Re: Date Issues When Importing

Postby fmantessof » Sun Aug 16, 2015 5:15 am

Gareth, I found out what is going on...I use Quandl to download the data in Excel, however Quandl is delivering the dataset with missing dates both through Google and Yahoo


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 8 guests