I wish to use MATLAB rather than the following Excel worksheet
The following MATLAB code acheives this
May I ask is there a better approach than the above, which is sort of like using visual basic in Excel?
For example, is there a more "object orientated" approach where the formulas representing each excel column, e.g. "opening(t) = closing(t-1)", are specified in their own separate file or something? Or, perhaps there is a MATLAB toolbox suitable for this type of model?