EViews.com

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 !!

Could you provide an example?

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.

SORRY I MISSED THE LAST ONE THAT SHOWED WHAT I MEANT

Can you provide the actual Excel file?

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

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.

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

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

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

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

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