How do I specify variable names in Matlab?

2016 1 27
1 个回答
回答已采纳
更新时间：2016 1 27
6 次查看（30 天）

0 个投票

I have a portfolio of 10 stocks on an excel spreadsheet and have the names of the stocks in the first row. I can import this to Matlab by defining my data as a numeric matrix as opposed to a column vector. This allows me to calculate the variance-covariance matrix, which I was unable to do by importing the spreadsheet as a column vector.
The problem now is that I now cannot specify that my first row is variable names. Does anyone have any advice? I would be most grateful for your help. Thank you!

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

jgg
jgg 2016-1-27
编辑：jgg 2016-1-27
Try using readtable instead of the method you're using to import the data. You can then use table2array to calculate your covariance matrix.
Basically, you'll save a lot of time and effort by using the right datatypes off the bat.

请先登录，再进行评论。

请先登录，再回答此问题。

 采纳的回答

Walter Roberson
Walter Roberson 2016-1-27

0 个投票

[num, txt] = xlsread('YourXLSFile.xls');
Then the numbers are in num and the variable names are in txt.

2 个评论
显示 无 隐藏 无

Calum Crichton
Calum Crichton 2016-1-27
编辑：Calum Crichton 2016-1-27
This worked. Thank you! The last thing I need help with is that after doing this how do I define an AssetList? E.g. when I use
p = Portfolio('AssetList', {'stockA','stockB'etc},'RiskFreeRate',CashRet);
it will not recognise the names of the assets
Walter Roberson
Walter Roberson 2016-1-27
p = Portfolio('AssetList', txt(:).', 'RiskFreeRate', CashRet);
I do not know for sure that the cell array needs to be a row vector, but that is what I see in the examples.

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Matrix Indexing 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by