Hello,
You can store the results in a MATLAB table which is both easy to understand and easy to export to a excel sheet using the "writetable" function. Each row of the table corresponds to a unique combination of "theta", "rho", and "gamma", along with the resulting "kss".
Refer to the following code for better understanding:
thetas = [1, 1.5];
rhos = [0, 0.99, 2];
gammas = [-1, 0, 0.76, 0.9, 1];
results = {};
row = 1;
for i = 1:length(thetas)
theta = thetas(i);
for j = 1:length(rhos)
rho = rhos(j);
for ii = 1:length(gammas)
gamma = gammas(ii);
kss = equilibirum(debt);
% Store parameters and kss as a row
results{row, 1} = theta;
results{row, 2} = rho;
results{row, 3} = gamma;
results{row, 4} = kss;
row = row + 1;
end
end
end
T = cell2table(results, 'VariableNames', {'Theta', 'Rho', 'Gamma', 'KSS'});
% Export to Excel
writetable(T, 'kss_results.xlsx');
For more details on the above functions, please refer to the following documentation pages:
- cell2table function: https://www.mathworks.com/help/matlab/ref/cell2table.html
- writetable function: https://www.mathworks.com/help/matlab/ref/writetable.html
I hope this resolves your query.
Thanks
