Opening a spreadsheet file
by Henrique
Dear Gretl community,
According to Gretl Command Reference:
When opening a spreadsheet file (Gnumeric, Open Document or XLS), you may
give up to three
additional parameters following the filename. First, you can select a
particular worksheet within
the file. This is done either by giving its (1-based) number, using the
syntax, e.g., --sheet=2, or, if
you know the name of the sheet, by giving the name in double quotes, as in
--sheet="MacroData".
When I try to use the syntax --sheet="dados (previsão)", I get the following
error: Error executing script: halting. My
file is a Excel spreadsheet and I´m getting this problem on both Windows XP
and Mac OS/X. What can I do to fix this?
Best,
Henrique C. de Andrade
Doutorando em Economia Aplicada
Universidade Federal do Rio Grande do Sul
www.ufrgs.br/ppge
15 years, 6 months
Corrgm function
by Ofer Cornfeld
Hi,
I'm working on version 1.8.4 of GRETL.
I've been trying to use programmatically corrgm on two series.
smpl -no-missing F_NFCB E_NFCB
cgm = corrgm(F_NFCB,12,E_NFCB)
but this fails with
gretl version 1.8.4
Current session: 2009-09-07 19:54
? smpl --no-missing F_NFCB E_NFCB
? cgm = corrgm(F_NFCB,12,E_NFCB)
Missing values within sample -- can't do correlogram
Error executing script: halting
> cgm = corrgm(F_NFCB,12,E_NFCB)
Any hints or clues what's wrong?
Ofer Cornfeld
15 years, 6 months
Open .xls files
by Henrique
Dear Gretl community,
I'm trying to open a specific tab in a Excel spreadsheet using a Gretl
script file:
open "/Users/henrique/Projetos/Câmbio de Equilíbrio/Dados/Previsões/4p.PEL -
Previsto.xls" --sheet=2 --rowoffset=1
And I'm getting the following output:
One or more variable names are missing.
Perhaps you need to adjust the starting column or row?
Error executing script: halting
> open "/Users/henrique/Projetos/Câmbio de Equilíbrio/Dados/Previsões/4p.PEL
- Previsto.xls" --sheet=2 --rowoffset=1
What's wrong?
Best,
Henrique C. de Andrade
Doutorando em Economia Aplicada
Universidade Federal do Rio Grande do Sul
www.ufrgs.br/ppge
15 years, 6 months
Re: [Gretl-users] Gretl-users Digest, Vol 32, Issue 10
by Data Analytics Corp.
Hi,
I want to thank all who responded to my random walk question. You can
see this coming a mile away - right after I sent the email, I decided to
try what other languages use: X(-1). This worked. Flipping through the
documentation, I found examples of this. So - I now have what I want.
Thanks,
Walt
gretl-users-request(a)lists.wfu.edu wrote:
> Send Gretl-users mailing list submissions to
> gretl-users(a)lists.wfu.edu
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://lists.wfu.edu/mailman/listinfo/gretl-users
> or, via email, send a message with subject or body 'help' to
> gretl-users-request(a)lists.wfu.edu
>
> You can reach the person managing the list at
> gretl-users-owner(a)lists.wfu.edu
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Gretl-users digest..."
>
>
> Today's Topics:
>
> 1. Generating a random walk (Data Analytics Corp.)
> 2. Re: Generating a random walk (artur bala)
> 3. Generating a random walk (Walter R. Paczkowski)
> 4. Re: Generating a random walk (Allin Cottrell)
> 5. Re: Generating a random walk (artur bala)
> 6. Re: broken snapshot; R path (chris)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sun, 06 Sep 2009 13:02:52 -0400
> From: "Data Analytics Corp." <dataanalytics(a)earthlink.net>
> Subject: [Gretl-users] Generating a random walk
> To: gretl-users(a)lists.wfu.edu
> Message-ID: <4AA3EB3C.8090303(a)earthlink.net>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Hi,
>
> I'm still new to GRETL, so please pardon a simple question. I want my
> students to generate a simple random walk of, say 1000 values, so that
> they can compare (graph) this against changes in the DOW. How is a
> random walk generated in GRETL? More fundamentally, how do I lag a
> series and use it on the right-hand-side? I tried
>
> genr rw = lags(dow, 1) + randgen(N, 0, 1)
>
> but this didn't work.
>
>
> Thanks,
>
> Walt Paczkowski
>
>
--
________________________
Walter R. Paczkowski, Ph.D.
Data Analytics Corp.
44 Hamilton Lane
Plainsboro, NJ 08536
________________________
(V) 609-936-8999
(F) 609-936-3733
dataanalytics(a)earthlink.net
www.dataanalyticscorp.com
15 years, 6 months
broken snapshot; R path
by Allin Cottrell
A couple of gretl-on-Windows things:
1) Sorry, there was a broken snapshot in place for a short while,
where wgnuplot.exe would not be found. That's now fixed.
2) I've revised the code that is supposed to tell R where its DLLs
are, in case it can't find them. I think this should now work
properly.
Allin Cottrell
15 years, 6 months
Generating a random walk
by Data Analytics Corp.
Hi,
I'm still new to GRETL, so please pardon a simple question. I want my
students to generate a simple random walk of, say 1000 values, so that
they can compare (graph) this against changes in the DOW. How is a
random walk generated in GRETL? More fundamentally, how do I lag a
series and use it on the right-hand-side? I tried
genr rw = lags(dow, 1) + randgen(N, 0, 1)
but this didn't work.
Thanks,
Walt Paczkowski
--
________________________
Walter R. Paczkowski, Ph.D.
Data Analytics Corp.
44 Hamilton Lane
Plainsboro, NJ 08536
________________________
(V) 609-936-8999
(F) 609-936-3733
dataanalytics(a)earthlink.net
www.dataanalyticscorp.com
15 years, 6 months
Generating a random walk
by Walter R. Paczkowski
Hi,
I'm still new to GRETL, so please pardon a simple question. I want my
students to generate a simple random walk of, say 1000 values, so that
they can compare (graph) this against changes in the DOW. How is a
random walk generated in GRETL?
Thanks,
Walt Paczkowski
15 years, 6 months
backward-incompatible change
by Allin Cottrell
This is in the log on the website, but I thought I'd alert people
here too.
For gretl 1.8.5, I'm removing the --long option to gretl's "print"
command along with the associated longdigits parameter for the
"set" command.
These things date back to a time before gretl has a "printf"
command. Reviewers remarked that one couldn't readily print out a
gretl variable to more significant digits that were offered by
"print". That was true at the time, but you can now use printf to
examine a variable to as many digits as you want (and we also have
GUI means of showing more digits).
So I think we can retire "--long" and "longdigits", in the
interest of removing redundant baggage from the gretl codebase.
Allin Cottrell
15 years, 6 months
Ox support on OS/X
by Henrique
Dear Developers,
Is it possible to enable Ox support on Mac OS/X?
Best,
Henrique C. de Andrade
Doutorando em Economia Aplicada
Universidade Federal do Rio Grande do Sul
www.ufrgs.br/ppge
15 years, 6 months
