I have been having trouble with this too and have found variance with cvs files in daily format versus hourly. Gretl seemed to read the daily chart with some attempts and not on other attempts. I adjusted the format of date in reverse as well. The time series data is in the format of Open,High,Low,Close (I am skipping the volume) and is somewhere between five and six days of the week as it is the Foreign Exchange starting on Sunday evening and ending Friday evening from my time zone. The default for six days a week with gretl skips Sunday, not Saturday so the observed dates are not in the proper sequence.
I am investigating the 'setobs' gretl command to remedy this and would further appreciate understanding how to direct gretl to read time in hours of the day as well. I plan to stack these time series of daily charts, four hour charts and then one hour charts with the Open, High, Low and Close observed prices of currencies.
Once I am able to load the data into gretl I would like to experiment utilizing a Mobius Map as the paradigm with the two by two matrix having the Range of High and Low and the Domain being the Open and Close. The other experiment has the Mobius Map with a range of Open and High and domain of Close and Low:
T(z) = Hz + L / Oz + C
or
T(z) = Oz + H / Cz +L
I must be able to load the time series data to conduct these experiments. Thank you for your help.
On Wed, Nov 19, 2008 at 4:08 PM, Allin Cottrell
<cottrell@wfu.edu> wrote:
On Wed, 19 Nov 2008, Sven Schreiber wrote:
> Am 19.11.2008 17:56, Sven Schreiber schrieb:
> >
> > Even after naming the first column 'obs', still it doesn't work! Could
> > it be that the problem is that my data is stored in reverse
> > chronological order (t=T at the top, t=1 at the bottom)?
>
> replying to myself: this indeed seems to be the problem. I imported the
> csv file into OpenOffice without problems, and there I could easily
> change the sorting to chronological order (instead of reverse). Then I
> exported the file to csv again, with the dates in the format YYYY-MM-DD.
> That new csv file could be easily imported into gretl.
>
> Bottom line: IMHO gretl's import mechanism should also allow reverse
> chronological ordering, which at present apparently it doesn't.
It doesn't, but it's easy enough to reverse the data in gretl (as
in the Cheatsheet chapter of the manual):
genr sortkey = -obs
dataset sortby sortkey
However, I'll take a look at auto-reversing.
Allin.