[Gretl-users] exporting to excel

2007-05-11 Thread Chris
Hi, Is it possible to get gretl to put output into an excel spreadsheet? It would be great to be able to build vba scripts in excel to do analysis and output the coefficients back to a specified range in excel for further vba tweaking Hi,   Is it possible to get gretl to put output into an excel s

Re: [Gretl-users] exporting to excel

2007-05-11 Thread Chris
That's fine, I suppose it's just a couple more lines of VBA to import the csv file;) Thanks, Chris On 5/11/07, Allin Cottrell wrote: > > On Fri, 11 May 2007, Chris wrote: > > > Is it possible to get gretl to put output into an excel spreadsheet? > > Not unless

Re: [Gretl-users] exporting to excel

2007-05-11 Thread Chris
Thanks, I'll look into it, but I think it will be easier to just write the script to pull data from the csv and plop it onto a sheet in the excel spread sheet. Thanks, Chris On 5/11/07, Riccardo (Jack) Lucchetti wrote: > > On Fri, 11 May 2007, Chris wrote: > > > That&#x

Re: [Gretl-users] exporting to excel

2007-05-12 Thread Chris
miss that this is not possible in the manual? Thanks, Chris On 5/11/07, Chris wrote: > > Thanks, > > I'll look into it, but I think it will be easier to just write the script > to pull data from the csv and plop it onto a sheet in the excel spread > sheet. > >

[Gretl-users] econometrics question

2007-05-12 Thread Chris
time period used for estimation right? Thanks, Chris Hi,  If you run a regression like Y= XB + GH + error where GH is unobserved so the actual regression you will run is Y = XB + (GH + error) and then use the output to forecast various things. If G has variables in it that trend in one direction or

[Gretl-users] arch forecasting

2007-05-25 Thread Chris
values to get a forecasted Y? Do I have to do anything with the alphas? Reading my copy of Greene, they just seem to be forcing structure on the error term and estimating that structure so I'm just not certain if I have to use them somehow to get a forecasted value or not. Thanks, Chris Hi,

[Gretl-users] is there a way to use relative paths?

2007-05-29 Thread Chris
Hi, I have a script that I want to run and put the output in the same directory as the script but the directory that the script is in can change. Is there a way to tell gretl to put the output in the same dir as the script? Thanks, Chris Hi,   I have a script that I want to run and put the

Re: [Gretl-users] is there a way to use relative paths?

2007-05-29 Thread Chris
passes and it's not working. The first portion works though, if I just pass the location of gretl it runs... Thanks, Chris On 5/29/07, Ignacio Diaz-Emparanza wrote: > > On Tuesday 29 May 2007 15:46:06 Sven Schreiber wrote: > > Chris schrieb: > > > Hi, > > > &g

Re: [Gretl-users] is there a way to use relative paths?

2007-05-29 Thread Chris
this is what it is actually passing: C:\Program Files\gretl\gretlcli.exe -b G:\temp\temp\1.inp I'll try and get quotes in there somehow.. On 5/29/07, Ignacio Diaz-Emparanza wrote: > > On Tuesday 29 May 2007 16:07:46 Chris wrote: > > sweet, thanks guys that worked. >

Re: [Gretl-users] is there a way to use relative paths?

2007-05-29 Thread Chris
Thanks guys, It's working. it seems to just be that VBA is crappy;) I put it back the way I had it when I started this journey, basically the way Allin has it, and it worked now. I really appreciate all your help, Chris On 5/29/07, Allin Cottrell wrote: > > On Tue, 29 May 2007,

[Gretl-users] skipping observations in arch regressions

2007-05-29 Thread Chris
command to just skip the observations and continue on with the regression? Thanks, Chris Hi,   I know it's improper to skip observations (and likely mucks about the result) but I'm dealing with hourly data so the effect isn't that great. I'm missing about 21 observations in a data

[Gretl-users] arima + arch ?

2007-06-05 Thread Chris
is there any way to combine arima with arch? Is this a stupid question? When I run the arima stuff I get a fantastic fit to the data, but when I run the arch test it shows I definitely have an arch process. Thanks, Chris is there any way to combine arima with arch? Is this a stupid question

[Gretl-users] R question

2007-06-06 Thread Chris
h the x variables I get this error: Error in model.frame(formula, rownames, variables, varnames, extras, extranames, : invalid type (list) for variable 'x' here's the command used: archoutput <- garchFit(formula=~arma(1,1)+garch(2,24), xy.df) Any help would be greatly

Re: [Gretl-users] arima + arch ?

2007-06-07 Thread Chris
he function total = B1 + B2*X2 + B3*X3? i.e how do I get it to estimate the B's as well? Thanks, Chris On 6/5/07, Riccardo (Jack) Lucchetti wrote: > > On Tue, 5 Jun 2007, Chris wrote: > > > is there any way to combine arima with arch? Is this a stupid question? > When >

Re: [Gretl-users] arima + arch ?

2007-06-07 Thread Chris
variables. I'm trying to figure out how to estimate the coefficients on the other explanatory variables as well... I really appreciate your help, Sincerely, Chris On 6/7/07, Riccardo (Jack) Lucchetti wrote: > > On Thu, 7 Jun 2007, Chris wrote: > > > Hi, > > Your scr

Re: [Gretl-users] arima + arch ?

2007-06-07 Thread Chris
Also, Thank you, the pointers on i fixed that problem and the regression is running now. Chris On 6/7/07, Chris wrote: > > Hi, > > The actual model isn't just based on the Y variable, it's of the form y = > B1 + B2*X2 + B3*X3 . in your example you seem to generat

[Gretl-users] any work on allowing fcast to substitute different values?

2007-06-12 Thread Chris
ng to fiddle with sample ranges. Thanks, Chris Hi,   I notice in the manual that there is no provision for fcast to substitute different values for doing the forecast. Is anyone working on allowing this? It would seem much neater to be able to specify the forecast X's seperately rather than addi

[Gretl-users] fcast arch bug?

2007-06-12 Thread Chris
Hi, When I try to use fcast after an arch command I get the error ? fcast fit2 --dynamic Can't do this: no model has been estimated yet but when I replace the "arch 24" with "ols" the fcast command works fine. Is this a bug or am I missing something? Thanks, Chri

Re: [Gretl-users] fcast arch bug?

2007-06-13 Thread Chris
g the model right now, but when I am I will try and get you some output. Chris On 6/13/07, Allin Cottrell wrote: > > On Tue, 12 Jun 2007, Chris wrote: > > > When I try to use fcast after an arch command I get the error > > > > ? fcast fit2 --dynamic > > Can'

Re: [Gretl-users] fcast arch bug?

2007-06-16 Thread Chris
and then correct? Thanks, Chris On 6/13/07, Chris wrote: > > when I run the arch command I get an arch model returned and can see that > it is significant. Furthermore, when I run the arch command through the gui > I get the same model returned and I can estimate using fcasterr th

Re: [Gretl-users] fcast arch bug?

2007-06-16 Thread Chris
mount I've been able to cram into my head over the last little while. Chris On 6/16/07, Riccardo (Jack) Lucchetti wrote: > > On Sat, 16 Jun 2007, Allin Cottrell wrote: > > > On Sat, 16 Jun 2007, Chris quoted me: > > > >> The arch command is a bit unusual (thi

Re: [Gretl-users] arima forecasting

2007-06-20 Thread Chris
to what you want right in the fcast command. Hope this helps Chris On 6/20/07, walgula(a)wp.pl wrote: > > Hello, I'm trying to use an a raima model to forecasting. > How to write a script that forecasts forwards some variable? > I've dataset/file that includes &q

[Gretl-users] Is it possible to get a windows recompile?

2007-06-26 Thread Chris
The windows cvs compile has some arch forecast fixes i need to use, but is also really crash prone. Would it be possible to get a recompile? maybe current cvs is better. Thanks, Chris The windows cvs compile has some arch forecast fixes i need to use, but is also really crash prone. Would it be

Re: [Gretl-users] Is it possible to get a windows recompile?

2007-06-26 Thread Chris
running the arch regression. If you still have the script from my last arch error report, it's remarkably similar to that, but with a bigger dataset and without the squares and cubed terms. Chris On 6/26/07, Allin Cottrell wrote: > > On Tue, 26 Jun 2007, Chris wrote: > > > The

[Gretl-users] license of gretl script

2009-08-13 Thread chris
Hi, I have written some gretl scripts which I would like to publish, but it seems like some parts of it are covered, or might be covered, by patents. But I think I could publish the code with some strings attached, i.e. only use in academia, no allowance to give code to somebody else. Now my q

Re: [Gretl-users] Script Questions

2009-08-22 Thread chris
a small script which uses the $windows variable in order to offer some file routines in a platform independent manner to gretl scripts. chris system.inp Description: chemical/gamess-input

[Gretl-users] problems with gretl libr foreign blocks under win32

2009-09-01 Thread chris
add a workaround for this problem, but if not we should at least give a hint in a helpfile somewhere. chris

Re: [Gretl-users] GRETL string concatenation for use in SQL statement

2009-09-02 Thread chris
Allin Cottrell wrote: > > However, I'm not sure offhand whether gretl's ODBC routines will > handle this sort of input correctly. I'll have to test. > Did you change the string parsing code? Because with current windows snapshot the follwing snippet no longer works: string a="\" chris

Re: [Gretl-users] broken snapshot; R path

2009-09-07 Thread chris
Allin Cottrell wrote: > A couple of gretl-on-Windows things: > > > 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. > works now for me. thanks!! chris

Re: [Gretl-users] Corrgm function (after thinking)

2009-09-09 Thread chris
From http://ricardo.ecn.wfu.edu/pub/gretl/gretl_install.exe you always get the most recent version. Ofer Cornfeld wrote: > How do I get a working copy of this Windows snapshot? > > With kind regards, > > Ofer Cornfeld > > -Original Message- > From: gretl-users-bounces(a)lists.wfu.edu

Re: [Gretl-users] PROBLEMS GRETL

2009-11-04 Thread chris
I have not yet updated to 9.10 but to me it seems you are using a rather old gretl package. The file libblas.so.3 is supplied by the refblas3 package of debian etch (http://packages.debian.org/search?searchon=contents&keywords=libblas.so.3&mode=filename&suite=oldstable&arch=any) . Updating the g

[Gretl-users] ODBC troubles

2010-02-02 Thread Chris
Also, are there any plans to implement more robust ODBC support? It would be great to be able to import multiple variables at once. Thanks, Chris Hi,I'm having some trouble getting data into gretl through ODBC. I have a fairly large sql statement, so I'm importing it from a file. When I

Re: [Gretl-users] ODBC troubles

2010-02-03 Thread Chris
, now that it's in gretl, when I try to view the dat I get an "maxbufftemp: no valid values" error, however, when I look at the data in query analyzer It's there (example piece of data from query analyzer: 39.900" Thanks, Chris On Tue, Feb 2, 2010 at 8:34 PM, Allin Cottre

Re: [Gretl-users] ODBC troubles

2010-02-03 Thread Chris
quot; not the data that shows up when I run the same query in query analyzer. Thanks, Chris On Wed, Feb 3, 2010 at 10:37 AM, Allin Cottrell wrote: > > On Wed, 3 Feb 2010, Chris wrote: > > > Thanks for the help Allin, > > > > That was just my own lack of understandin

Re: [Gretl-users] ODBC troubles

2010-02-03 Thread Chris
I believe we can read that as numeric precision 7, numeric scale 3 For the small and simple test query I was using the data is stored as numeric(16,3) in the same sql server. Chris On Wed, Feb 3, 2010 at 2:06 PM, Allin Cottrell wrote: > > On Wed, 3 Feb 2010, Chris wrote: > > >

Re: [Gretl-users] ODBC troubles

2010-02-03 Thread Chris
his I would appreciate it. Thanks, Chris On Wed, Feb 3, 2010 at 3:20 PM, Allin Cottrell wrote: > > On Wed, 3 Feb 2010, Chris wrote: > > > It should be an integer string that is the date without the / in > > them so feb 1 , 2007 stored as 20070201. In the case where I > >

Re: [Gretl-users] ODBC troubles

2010-02-03 Thread Chris
reciate it. As a side note, do you know if anyone is working on updating the import features to allow multiple variable imports? Thanks, Chris On Wed, Feb 3, 2010 at 3:51 PM, Allin Cottrell wrote: > > On Wed, 3 Feb 2010, Chris wrote: > > > That straightens out some