Simple Question
1 回表示 (過去 30 日間)
古いコメントを表示
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 件のコメント
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
2012 年 3 月 16 日
Hi
are you getting any complex number in TE? Check is there any complex number.
Sreenu
回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で MATLAB Parallel Server についてさらに検索
製品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!