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
[cid:image001.png@01D34D57.222E27A0]
Thanks,
A.
-----Original Message-----
From: gretl-devel-bounces(a)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<mailto:Gretl-devel@lists.wfu.edu>
https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.wfu.edu_mailman...
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.