Date Issues When Importing
Moderators: EViews Gareth, EViews Jason, EViews Steve, EViews Moderator
-
- Posts: 24
- Joined: Fri Aug 14, 2015 7:54 am
Date Issues When Importing
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 !!
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13315
- Joined: Tue Sep 16, 2008 5:38 pm
-
- Posts: 24
- Joined: Fri Aug 14, 2015 7:54 am
Re: Date Issues When Importing
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 (62.47 KiB) Viewed 7540 times
-
- Screenshot 2015-08-15 15.10.34.png (65.81 KiB) Viewed 7540 times
-
- Screenshot 2015-08-15 15.10.16.png (62.47 KiB) Viewed 7540 times
-
- Posts: 24
- Joined: Fri Aug 14, 2015 7:54 am
Re: Date Issues When Importing
SORRY I MISSED THE LAST ONE THAT SHOWED WHAT I MEANT
- Attachments
-
- Screenshot 2015-08-15 15.11.32.png (69.21 KiB) Viewed 7539 times
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13315
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Date Issues When Importing
Can you provide the actual Excel file?
Follow us on Twitter @IHSEViews
-
- Posts: 24
- Joined: Fri Aug 14, 2015 7:54 am
Re: Date Issues When Importing
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 250 times
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13315
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Date Issues When Importing
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
-
- Posts: 24
- Joined: Fri Aug 14, 2015 7:54 am
Re: Date Issues When Importing
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
-
- Posts: 24
- Joined: Fri Aug 14, 2015 7:54 am
Re: Date Issues When Importing
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
-
- Fe ddaethom, fe welon, fe amcangyfrifon
- Posts: 13315
- Joined: Tue Sep 16, 2008 5:38 pm
Re: Date Issues When Importing
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
-
- Posts: 24
- Joined: Fri Aug 14, 2015 7:54 am
Re: Date Issues When Importing
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 264 times
-
- Posts: 24
- Joined: Fri Aug 14, 2015 7:54 am
Re: Date Issues When Importing
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
Who is online
Users browsing this forum: Cscottmcwall-ea and 13 guests