how to use the load-command

6 次查看（过去 30 天）
tr206
tr206 2015-3-23
评论： tr206 2015-3-24
Hi,
I am trying to upload my stock return data. The person who wrote the code told me that the data file is a Matlab data file and he applies the load-command to the data. I have my data in Excel and the xlsread-command does not do the trick as I do not get the data the way I want.
How can I use the load-command? As far as I understand, I must have a Matlab file to use this command but how can I create a Matlab file (.m format)??
I would be very grateful if someone could help me with that. I cannot find the solution in one of my books on Matlab.
Thanks in advance.
  1 个评论
tr206
tr206 2015-3-24
Hi, Thanks for your help. I made it the way you described using uiimport and dlmwrite. Now I get the message Error using load Unknown text on line number 1 of ASCII file C:\Users\tr206\Documents\MATLAB\stkmkt_ret_data "M".
Error in garchmidas_roll (line 39) load stkmkt_ret_data;
What am I doing wrong?
I have also imported the data as matrix, dataset etc. using the import tool in matlab. In this case I get the message that the function
ft_ind0=find( diff(daily_stk(:,2)) ~= 0 ) is not applicable.
Would it help if I sent you the code in addition to my dataset so that you can look into it?

请先登录，再进行评论。

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

采纳的回答

Guillaume
Guillaume 2015-3-23
Your question is a bit lacking in details. Most likely, the code you're trying to run expects a .mat file (not an .m file which is for code) with certain variables. You would have to extract your excel file into variables with the same name and save that as a .mat file for it to work.
Your best course of action is to go back to the person who wrote the code and ask him/her how to generate the .mat file (or what variables of what type are supposed to be in it). A good lesson from this is to properly document code when you write it. Particularly, give a good explanation of inputs and outputs.
  3 个评论
显示 1更早的评论
Ilham Hardy
Ilham Hardy 2015-3-23
Yes? --> No,
You 'read' the excel file using xlsread() command, arrange the data until you satisfied the above conditions, then save the workspace into matfile using save() command.
But maybe better if you use uiimport() command instead of xlsread() just to have more overview on the data format you're importing (ie. mm format)
Guillaume
Guillaume 2015-3-23
Thorsten, yes the idea was to import the excel file, modify the data as appropriate and save it in the format that the code expects.
However, from the description you got, it looks like the code is expecting a text file rather than a .mat file. A .mat file is binary, it just contain variables and values, it does not have 'columns' or 'format'.
The idea is still the same. Import the excel file (with xlsread or uiimport), manipulate it to it fits the required format, and save it. For text files, use dlmwrite instead of save. Possibly, all this can be done in excel.
If you post of sample of the excel file, we may be able to help further.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

尚未输入任何标签。

Community Treasure Hunt

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

Start Hunting!

Translated by