How to build a zero curve object from excel

2 次查看(过去 30 天)
I would like to create a matlab ratecurve object directly inside excel. My goal is to have a few ranges in excel for ratecurve object inputs - market rates (overrnight rate, notes, bonds), curve build features act-360, days to spot, holiday types, etc. I then build a ratecurve object from which I can pull zero rates or discount factors for use elsewhere in the workbook. For example - if i wanted to discount a forward cash flow using the matlab generated zero curve i could have a function similar to =matlabdiscountfactor(curveid, forwarddate), that looks to the ratecurve object.

采纳的回答

Jacob Mathew
Jacob Mathew 2025-6-25
Hey @Greg,
You can follow the below example provided by MathWorks to read spreadsheets into MATLAB Table. This should enable you to read data from your Microsoft Excel spreadsheet:
Note that there are two seperate methods to deal with a single worksheet (readtable) or mulitiple worksheets (spreadsheetDatastore).
Once you have read the spreadsheet into MATLAB workspace, you can then create your ratecurve by following the below example:
  1 个评论
Greg
Greg 2025-6-25
Thank you very much Jacob - I am going to explore these links. I am a newbie to MathWorks as you can probably sense... thanks for getting me started!

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Data Import from MATLAB 的更多信息

产品


版本

R2025a

Community Treasure Hunt

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

Start Hunting!

Translated by