Welcome to the best scientific community!

I have cleaned up your files, turning them into EN data. You can import them in Gretl with no problems.

I can confirm the bug you found.

To produce "nice" values you should first compact from Daily to Weekly data (with "last"), next from Weekly to Monthly, and finally from Monthly to Annual.


On Thu, Jan 29, 2015 at 9:38 PM, Allin Cottrell <cottrell@wfu.edu> wrote:
On Thu, 29 Jan 2015, Wingenroth, Thorsten wrote:

first of all: I think Gretl is great. Just what I had looking for my students and myself. Clean, fast, easy, powerful but - most of all - a nice user interface. That's what R is missing.

Thanks, glad you like it!

That said [...]

The menu item for compacting series does not work correctly. Although the option "last" is specified in the attributes, another method to compact is used. In contrast, if you use the command line interface, everything works fine.

Thanks for the report. I see the problem, and it's specific to running two compaction steps: daily to monthly then monthly to annual. I've found the source of the problem and fixed it in CVS; fixed snapshots will follow tomorrow.

If you want to try out yourself, just try to compact these two files via the menu to a frequency of 1 year. A lot of data gets lost at the beginning of the series.

One thing to note is that your DAX CSV file is not suitable for importation to gretl as it stands. You can't include a thousands separator in such a file. (When I experimented with it I had to open it in a text editor and delete all instances of '.'.) All the supposedly numerical values such as "10.666,43" (meaning, I take it, 10 thousand, six hundred and sixty six point four three) are read as string variables since gretl can't make any numerical sense of such constructions with two bits of punctuation.

Allin Cottrell

Gretl-users mailing list