How do I specify variable names in Matlab?
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Calum Crichton
am 27 Jan. 2016
Kommentiert: Walter Roberson
am 27 Jan. 2016
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 Kommentar
Akzeptierte Antwort
Walter Roberson
am 27 Jan. 2016
[num, txt] = xlsread('YourXLSFile.xls');
Then the numbers are in num and the variable names are in txt.
2 Kommentare
Walter Roberson
am 27 Jan. 2016
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.
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!