MATLAB Answers

Best way to convert an Excel model to MATLAB

3 ビュー (過去 30 日間)
Tim Berry
Tim Berry 2021 年 8 月 8 日
コメント済み: Tim Berry 2021 年 8 月 8 日
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?
  2 件のコメント
Tim Berry
Tim Berry 2021 年 8 月 8 日
Thanks Darova. I hope to bring into MATLAB a much more complicated version of the sample Excel worksheet above, and then hope that MATLAB will allow a much faster calculation when I repeat the calculation thousands of times with different inputs. If a more complicated worksheet has say 60 columns each with a formula, then the simple script approach above would become difficult to work with. It might be nicer if each formula were its own sort of object. Possibly the Excel formulas could be made into MATLAB functions, but each formula may depended on other formulas (and sometimes another formula calcuated in the previous row e.g. at t-1.)


回答 (0 件)


Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by