MATLAB Answers

time series

1 view (last 30 days)
Hello,
If I have two vectors in excel file:
col A 0.34 0.65 0.21 0.54 0.34 0.89 . .
col B (22/01/2012 08:10:30) (22/01/2012 08:11:30) (22/01/2012 08:12:30) (22/01/2012 08:13:30) . .
My question is how can I plot both vectors?
Thanks.
Best,

  2 Comments

Wayne King
Wayne King on 21 Jan 2012
Do you have the Financial Toolbox by any chance?
Judah S
Judah S on 21 Jan 2012
Hi Wayne,
Yes I have but never used it.
Please suggest further.
Thanks.
Regards

Sign in to comment.

Accepted Answer

Walter Roberson
Walter Roberson on 21 Jan 2012
You can use datenum to convert the date/times to linear times. You can plot(B,A) and you can use datetick to cause the x axis to be shown as time.

  4 Comments

Show 1 older comment
Walter Roberson
Walter Roberson on 21 Jan 2012
datetick('x', 'HH:MM:SS')
Judah S
Judah S on 22 Jan 2012
Thanks.
Here is my code
[ndata, text, alldata] = xlsread('D:\matlab\a.xlsx')
x = datenum(text, 'dd/mm/yyyy HH:MM:SS');
plot(x,ndata)
datetick('x', 'dd/mm/yyyy HH:MM:SS');
Only date is working but not time. Why is that?
if I check z=datestr(x), I get all correct values.
Thanks.
Judah S
Judah S on 22 Jan 2012
Done
datetick('x', 'dd/mm/yyyy HH:MM:SS','keepticks');

Sign in to comment.

More Answers (0)

Sign in to answer this question.