Allin,

The test data you provided below worked fine. Gretl did not ask me to give it a time series of panel interpretation and immediately understood it is a time series. For example the time series plot option in the Variable tab was allowed together with correlogram and other time series features.

I suspected that I perhaps have to change the name of my date variable from ASOF_DATE to DATE. When I do this the program understands the first variable as a row label variable (improvement) but it does not understand it as a date and it continues to ask me about what interpretation I would like to give to the data.

BTW the data look like as shown below and I deleted the double row. File attached in the email. Also below you can find the log from importing the csv and the pop up window asking for the interpretation of the data.

Note that I get exactly the same behavior when I try to import the data Helio sent.

date	MKT
10/1/2007	389.6862
10/2/2007	382.1424
10/3/2007	380.0537
10/4/2007	382.5805
10/5/2007	371.6119
10/9/2007	359.7062

parsing \\naspm\portmgr\Sangvinatsos_Antonios\private\Appsense\gretl\Sent_to_Gretl.csv...

using delimiter ','

longest line: 24 characters

first field: 'DATE'

seems to be observation label

number of columns = 2

number of variables: 1

number of non-blank lines: 2451

scanning for variable names...

line: DATE,MKT

scanning for row labels and data...

first row label "10/1/2007", last label "9/25/2017"

trying to parse row labels as dates...

definitely not a four-digit year

treating these as undated data

Thanks,

-----Original Message-----
From: gretl-devel-bounces@lists.wfu.edu [mailto:gretl-devel-bounces@lists.wfu.edu] On Behalf Of Allin Cottrell
Sent: Tuesday, October 24, 2017 4:25 PM
To: Gretl development
Subject: Re: [Gretl-devel] Time series data with gaps and plots

On Tue, 24 Oct 2017, Sangvinatsos, Antonios wrote:

> Should I assume that the format 12/16/2008 is not supported?

No, it is supported.

> I changed the d-Mon-YY to MM/DD/YYYY format using excel, but again it

> was not accepted by Gretl.

Did you fix the duplicated date? (12/17/2015).

Here's a daily CSV fragment which you should be able to verify as recognized OK by gretl:

date,x

12/16/2008,1

12/17/2008,2

12/18/2008,3

12/19/2008,4

12/20/2008,1

12/21/2008,2

12/22/2008,3

12/23/2008,4

Allin

_______________________________________________

Gretl-devel mailing list

Gretl-devel@lists.wfu.edu

https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.wfu.edu_mailman_listinfo_gretl-2Ddevel&d=DwICAg&c=91HTncUBNS9Yv-Uuv2IlCA&r=E7D_CHy_hIJ7pRRDWHTeorb4B3Ubq4JxRJjE-NbzNLw&m=fk7dVn4ndGWkc3uxtJKl1nE-rb_wHIgPLbvEEhEsNp4&s=qAKMOo6bFxKd6r31dDWySMUgesGvv0REsaupU3CXXCU&e=

This message contains confidential information and is intended only for the individual named. If you are not the named addressee, you should not disseminate, distribute, alter or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmissions cannot be guaranteed to be secure or without error as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender, therefore, does not accept liability for any errors or omissions in the contents of this message which arise during or as a result of e-mail transmission. If verification is required, please request a hard-copy version. This message is provided for information purposes and should not be construed as a solicitation or offer to buy or sell any securities or related financial instruments in any jurisdiction. Securities are offered in the U.S. through PIMCO Investments LLC, distributor and a company of PIMCO LLC.

The individual providing the information herein is an employee of Pacific Investment Management Company LLC ("PIMCO"), an SEC-registered investment adviser. To the extent such individual advises you regarding a PIMCO investment strategy, he or she does so as an associated person of PIMCO. To the extent that any information is provided to you related to a PIMCO-sponsored investment fund ("PIMCO Fund"), it is being provided to you in the individual's capacity as a registered representative of PIMCO Investments LLC ("PI"), an SEC-registered broker-dealer. PI is not registered, and does not intend to register, as a municipal advisor and therefore does not provide advice with respect to the investment of the proceeds of municipal securities or municipal escrow investments. In addition, unless otherwise agreed by PIMCO, this communication and any related attachments are being provided on the express basis that they will not cause PIMCO LLC, or its affiliates, to become an investment advice fiduciary under ERISA or the Internal Revenue Code.