Simple Question

1 次查看（过去 30 天）

显示更早的评论

Oliver 2012-3-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/32409-simple-question

Hi all,

I'm trying to write an M-file or function that has the following lines:

CM = xlsread('Risk_Budget_Tano.XLS','sheet1','B23:Q38')

AE = xlsread('Risk_Budget_Tano.XLS','sheet1','D2:D17')

Vol = xlsread('Risk_Budget_Tano.XLS','sheet1','F2:F17')

TE = sqrt(AE' * CM * AE)

fprintf('The portfolio Tracking Error is: ', TE)

However, when I run them. It gave me error on 'Risk'. Could anybody help/teach me how to write the above function please?

Thanks heaps.

Oliver.

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

Image Analyst 2012-3-16

Are you sure all those workbooks are in the "Current Folder"? If they aren't then you need to specify the full path (folder + base filename + extension) of the workbook. It would be a good idea to use exist(filename, 'file') to check that the file exists before you call xlsread().