Implementation of .xls data in Bay.Estimation???
Posted: 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
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