Importing from XLSX file, column dates, column data

7 次查看（过去 30 天）
Jelle
Jelle 2012-5-27
Hello,
I am new to Matlab and I want to test the MACD rule on a dataset.
I downloaded the data into Excel and imported the data into Matlab
The first column gives the dates, ranging from 01-Jan-1990 to 18-May-2012. i changed these dates to numeric data in excel and then applied the following command in Matlab:
x = xlsread('x.xlsx')
Date(:,datecol) = Date(:,datecol) + datenum('30-Dec-1899');
D = datestr(x(:,1))
Now the problem is that Matlab creates a seperate variable containing the dates and this variable is an (ab) variable, but this type of variable is strange because i caanot plot it in combination with the share prices. how do I get the dates in a variable that i can work with?
Thanks in advance,
  3 个评论
显示 1更早的评论
Jelle
Jelle 2012-5-27
I am not sure what a char variable is but in the workspace there is an 'ab' in the yellow box in front of the variable name. I think its like the answer (ans) variable that matlab computes automatically
Oleg Komarov
Oleg Komarov 2012-5-27
You can right-click on the column headings of the workspace pane and select the voice 'Class'. It will tell which class the variable belongs to.

请先登录，再进行评论。

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

回答（1 个）

Oleg Komarov
Oleg Komarov 2012-5-27
Keep the dates in double format, then plot then call datetick()
  5 个评论
显示 3更早的评论
Jelle
Jelle 2012-5-27
Ok that is clear, so i keep the dates in a seperate variable shown as numerical data. DJ is the dowjones containg prices of the dow jones from 01-01-1990 to 18-05-2012, so I used DJ instead of xData.
I now have a seperate variable named 'dates' containing all the days (in numerical form) from Jan 1990 untill May 2012
Oleg Komarov
Oleg Komarov 2012-5-27
Then you should just call:
plot(dates, DJ)
datetick()

请先登录，再进行评论。

类别

在 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