**YES**, you can use the Solver add-in that ships with Microsoft Excel. If you don't have enabled, go to the Add-Ins manager and enable it.

- describe the model you are trying to fit. This is done by guessing the initial coefficients of the model, and compute the log-likelihood (*_LL()) of the model.

- Designate the cell that hold the log-likelihood as the Target cell, set equal to "Max", cells that hold model coefficients as "Changing-cells", and click on "Solve".

- Using *_CHECK (GARCH_CHECK for GARCH model, ARMA_CHECK for ARMA model, etc.), examine the coefficients whether they yield a stable model. Add a constraint to the solver by designating this cell equals to one(1).

- Now, click on "Solve" button on the Solver dialog box. The Solver will search for a set of optimal coefficients.
- Upon completion, the solver will report an optimal solution is found. Click "OK".

- In the rare occasions where a solution can't be found, change you initial guess of the coefficients, and try again.

## 0 Comments