#91 [Data Import] date repeated error



Version of Gretl: 1.8.0

I have the following error when importing my file XAU.csv

date '2008/01/08' is repeated

But in fact it is not. I think the software get an error beetween 08/01/2008 and 01/08/2008 (both dates are the file) but they are in fact respectively 08 Jan 2008 and the 01 Aug 2008

I am trying to use a another date format to avoid this bug

Thanks for your help
Adrien Aulagnier


  • Nobody/Anonymous

    File in which i get the error

  • Allin Cottrell

    Allin Cottrell - 2009-02-16

    Gretl is having difficulty working out the time-series pattern of
    your data. On the basis of the first several observations it
    seems that these are business-day data (Monday to Friday),
    but there are 6 Saturdays among the 2259 observations.
    Gretl's throwing an error at the first Saturday. The error
    message is misleading, admittedly.

  • Allin Cottrell

    Allin Cottrell - 2009-02-16
    • labels: --> data storage/retrieval
    • assigned_to: nobody --> allin
  • Allin Cottrell

    Allin Cottrell - 2009-02-16

    Ah, there's also one Sunday among the 2259 dates.
    The file is now read correctly in CVS: it is interpreted
    as 7-day data with lots of missing values.

  • Allin Cottrell

    Allin Cottrell - 2009-02-16
    • status: open --> closed-fixed
  • Nobody/Anonymous

    Thanks for your help

    I didn't notice this potential saturday and sunday problem...

    I will try without those dates in version 1.8.0

  • Nobody/Anonymous

    Yes / removing saterday and sunday dates works in 1.8.0

  • Allin Cottrell

    Allin Cottrell - 2009-02-17

    I'm glad to hear that works.

    What happens in current CVS gretl is that we form
    an initial guess at the frequency of the daily data,
    but as we go through the whole file we stand ready
    to modify that guess if we discover dates that
    "shouldn't be there". We also print a message in
    that case, e.g., "Found a Saturday (<date>)".


Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

No, thanks