Category: Functions
| Q | |
| Q | Can I compute the logarithmic return from a time series without any intermediate calculations? |
| Q | |
| Q | How can I use NumXL to compute the correlation matrix for 2 time series? |
| Q | |
| Q | How do I use differencing to obtain a stationary time series? |
| Q | |
| Q |
The calibration with Excel 2010 Solver does not give optimal coefficients. |
| A | In Excel version 2010, the solver has a non-negative constraint turned on by default; restricting the model's coefficients to non-negative values, and, as a result, it yields less than optimal solution. This constraint is not relevant for model calibration process, and should be turned off. As a work-around, please uncheck this option (as shown below) before you click on "Solve".
|
| Q | |
| Q | When I try to use the calibration icon, an error message pops stating that solver is not found. |
| Q | |
| Q | |
| Q | Why does the calibration function in NumXL shows the constraint's rhs of 0.9999? |
