Simple Question

2 次查看（过去 30 天）
Oliver
Oliver 2012-3-15
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更早的评论
Image Analyst
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().
KSSV
KSSV 2012-3-16
Hi
are you getting any complex number in TE? Check is there any complex number.
Sreenu

请先登录，再进行评论。

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

回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Portfolio Optimization and Asset Allocation 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by