How to add time information to candlestick chart?

Hello,

I have below code to chart candlesticks for financial data, I created a timetable, TT, and tried to skecth candle sticks but output figure is not correct, I cannot see sticks, only candle appears. Instead of timetable, if I tried to plot with a matrix without time information, results look good but without time. How to add time information to candlestick chart?

[a,b,c]=xlsread('202001.csv');
load('priceM1_2020.mat');
time=datetime(c(:,1));
Open=priceM1_2020(1:31652,1);
High=priceM1_2020(1:31652,2);
Low=priceM1_2020(1:31652,3),
Close=priceM1_2020(1:31652,4);
TT=timetable(time,Open,High,Low,Close);
candle(TT(end-50:end,:))

Result with timetable input;

Results with matrix(double) input;

[Adam Danz]

What release of Matlab are you using?

I get an error at this line,

time=datetime(c(:,1));

Error using datetime (line 647)
Could not recognize the format of the date/time text. You can specify a format using the 'InputFormat' parameter. If the date/time text contain day, month, or
time zone names in a language foreign to the 'en_US' locale, those might not be recognized. You can specify a different locale using the 'Locale' parameter. 

Datetime values look like this,

 c(1:5,1)
ans =
  5×1 cell array
    {'2020-01-01 17:00;1.1212;1.1212;1.1212;1.1212;.0000'}
    {'2020-01-01 17:01;1.1211;1.1214;1.1211;1.1214;.0000'}
    {'2020-01-01 17:02;1.1214;1.1214;1.1214;1.1214;.0000'}
    {'2020-01-01 17:03;1.1214;1.1214;1.1212;1.1212;.0000'}
    {'2020-01-01 17:04;1.1212;1.1213;1.1212;1.1213;.0000'}

[Siddharth Bhutiya]

I tried plotting both the data as timetable and as a double and I am getting the same plot for both the cases. Can you share the double matrix that is generating the candlesticks graph you showed above.

candle(TT(end-50:end,:)) % Plot using timetable input
mat = TT{end-50:end,:}; % Extract the data from the timetable into a matrix
candle(mat) % Plot using matrix input

On a side note, it would be better to use readtable instead of xlsread to read your csv file into MATLAB.

[Çağlar İŞLEK]

Hi @Siddharth Bhutiya, @Adam Danz,

Thank you for responses, below are the additional information and answers to your questions.

I tried this on both r2020a and r2019a and got same results.

The source of data is attached. "trial.csv".

Below is 2 trials, frist one tried to plot from original file. Second one, keep only time, open, high, low, close values in the table. Both methods output same result. Stil I dont have time information on the plot.

Trial-1

TT=readtable('trial.csv');
candle(TT(end-50:end,:))

Trial-2

TT=readtable('trial.csv');
TT(:,1)=[];
TT(:,1)=[];
TT(:,6)=[];
candle(TT(end-50:end,:))

Result: