Implementation of .xls data in Bay.Estimation???

This forum is closed. You can read the posts but cannot write. We have migrated the forum to a new location where you will have to reset your password.
Forum rules
This forum is closed. You can read the posts but cannot write. We have migrated the forum to a new location (https://forum.dynare.org) where you will have to reset your password.

Implementation of .xls data in Bay.Estimation???

Postby neuling » Tue Mar 05, 2013 6:58 pm

Hi,
i want to implement a .xlsx excel sheet named Y.xlsx here:

shocks;
var eps = csigma^2;
end;
varobs y;

estimated_params;
cbeta, beta_pdf, .99, .02;
stderr eps, inv_gamma_pdf, .01, inf;
end;

estimation(datafile=EXCELSHEET???,mode_compute=4,mh_replic=0);


It doesnt work! The output of computation:


Error using read_variables (line 58)
Can't find datafile: data.{m,mat,xls,xlsx}

Error in initialize_dataset (line 32)
rawdata = read_variables(datafile,varobs,[],xls.sheet,xls.range);

Error in dynare_estimation_init (line 347)
dataset_ =
initialize_dataset(options_.datafile,options_.varobs,options_.first_obs,options_.nobs,transformation,options_.prefilter,xls);

Error in dynare_estimation_1 (line 59)
[dataset_,xparam1, M_, options_, oo_, estim_params_,bayestopt_] =
dynare_estimation_init(var_list_, dname, [], M_, options_, oo_, estim_params_, bayestopt_);

Error in dynare_estimation (line 70)
dynare_estimation_1(var_list,dname);

Error in eststoch (line 148)
dynare_estimation(var_list_);

Error in dynare (line 120)
evalin('base',fname) ;

What would be the correct code? Can anybody plug it in here, please?

THX
neuling
 
Posts: 2
Joined: Tue Mar 05, 2013 6:47 pm

Re: Implementation of .xls data in Bay.Estimation???

Postby jpfeifer » Wed Mar 06, 2013 1:53 pm

Never name your excel file data. Try using a different name and see if the problem persists.
------------
Johannes Pfeifer
University of Cologne
https://sites.google.com/site/pfeiferecon/
jpfeifer
 
Posts: 6940
Joined: Sun Feb 21, 2010 4:02 pm
Location: Cologne, Germany

Re: Implementation of .xls data in Bay.Estimation???

Postby neuling » Thu Mar 07, 2013 8:59 am

I did it was the same error.
What would be a correct code for the problem, please?

Ich habe das bereits versucht und es kam der selbe Fehler.
Ich denke mal ich habe den falschen code/verweis eingebettet?
Was wäre der korrekte?
neuling
 
Posts: 2
Joined: Tue Mar 05, 2013 6:47 pm

Re: Implementation of .xls data in Bay.Estimation???

Postby jpfeifer » Thu Mar 07, 2013 1:17 pm

Please post the exact names of the excel-file, of the worksheet, and the exact line curently used to specify the estimation-command as well as the varobs-command.
Even better: post the mod-file and the data-file.

In German: am besten laden Sie die Mod-Datei und die zugehörige Excel-Datei hoch. Ich schaue es mir dann an.
------------
Johannes Pfeifer
University of Cologne
https://sites.google.com/site/pfeiferecon/
jpfeifer
 
Posts: 6940
Joined: Sun Feb 21, 2010 4:02 pm
Location: Cologne, Germany


Return to Dynare help

Who is online

Users browsing this forum: Google [Bot] and 5 guests