Import initial values from Excel

Perfect foresight simulations
1

Dear all,

I want to give a command with which I can import data from excel as histval values.
I have excel file which contains time series of different variables. I want to take the last values of these series (which are current values) as my histval values in dynare. How can I do that?
I’m also attaching the model code (which consists of MOD file and M file, you just have to run the MOD file) and the excel file from which I want to take the histvals

Thanks in advance.

excel_histvals.xlsx (20.7 KB)
Figure_2.mod (7.9 KB)
simulation_sheet.m (1.1 KB)

2

Usually, you would use the histval_file-command.

3

thank you very much ! I will try to see how it works