Date Issues When Importing

[fmantessof]

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]

Could you provide an example?

[fmantessof]

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.

[fmantessof]

SORRY I MISSED THE LAST ONE THAT SHOWED WHAT I MEANT

[EViews Gareth]

Can you provide the actual Excel file?

[fmantessof]

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

[EViews Gareth]

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.

[fmantessof]

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]

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]

Generally if EViews refuses to auto-recognize a date series it is because there is something wrong with that date series

[fmantessof]

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

[fmantessof]

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