MATLAB: Plot with dates on matlab

datesgraphs

Hi All, I have some historical time series prices for some assets in a matrix of size 295×34. (Matrix called Absy)

Also I have the corresponding 295 dates in another matrix (295×1) called dates. The dates are in the format of 20060606 20060613 etc (weekly).

I want to plot Absy but with the x axis being the corresponding dates.

When I do plot (dates,Absy) I get a wrong graph. Could someone help me.

Best Answer

One way:

Convert to a MATLAB serial date first, using datenum()

d = datenum('20060606','yyyymmdd')

then plot, and use the datetick() function.

Related Solutions

MATLAB: Excel dates

Use [Num,Txt,Raw]=xlsread() and then "Raw" will keep the "hh:mm" string format, then you can use datenum() to convert it.

If the format of the cells in Excel is "Time", it looks like the numerical value is imported using xlsread(). You can use datestr() to convert it back. For example:

>> [Num,Txt,Raw]=xlsread('test.xls')
Num =
    0.4743
    0.5160
    0.5576
    0.5576
Txt = 
    'Date'          'Time'
    '12/31/1899'        ''
    '1/1/1900'          ''
    '1/2/1900'          ''
    '1/3/1900'          ''
Raw = 
    'Date'          'Time'  
    '12/31/1899'    [0.4743]
    '1/1/1900'      [0.5160]
    '1/2/1900'      [0.5576]
    '1/3/1900'      [0.5576]
>> datestr(Num,'HH:MM')
ans =
11:23
12:23
13:23
13:23

MATLAB: Visualization Dates

Using keeplimits argument you can avoid this issue.

Mtlb Usr

Best Answer

Related Solutions

MATLAB: Excel dates

MATLAB: Visualization Dates

Related Question