time series

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,

[Wayne King]

Do you have the Financial Toolbox by any chance?

[Judah S]

Hi Wayne,

Yes I have but never used it.

Please suggest further.

Thanks.

Regards

Answer 1

[Walter Roberson]

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.

[Judah S]

Thanks Walter.

I have tried using datanum and successfully plotted A vs linear time.

But I was getting linear time on X axis as expected.

Can you please give an example of showing real time on X axis using datetick function?

Thanks.

Regards,

[Walter Roberson]

datetick('x', 'HH:MM:SS')

[Judah S]

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]

Done

datetick('x', 'dd/mm/yyyy HH:MM:SS','keepticks');