MATLAB Answers

0

How to draw candle with dates?

Asked by Avi Michaely on 21 Sep 2018
Latest activity Commented on by Ruby Singh on 8 Jan 2019
Hello, I'm trying to create a candle chart with dates at the X axis, but it only shows index numbers. This is my code:
function createCandle(tbl, dateStart, dateEnd)
tbl(tbl.Date<datetime(dateStart,'InputFormat','dd/MM/yyyy'),:)=[]; %Delete what's befor start date
tbl(tbl.Date>datetime(dateEnd,'InputFormat','dd/MM/yyyy'),:)=[]; %Delete what's after end date
candle(tbl);
I call it like this:
createCandle('DAX_Index_Candle.xlsx', '21/02/2016', '13/03/2017');
Table is attached.
This is what I'm getting:
As you see in the bottom there's numbers which I'm guessing are index numbers for the samples, but not the dates from the table.

  0 Comments

Sign in to comment.

2 Answers

Answer by Greg
on 21 Sep 2018
 Accepted Answer

First, your function cannot work with the example provided. You pass a filename then use it as a table or timetable variable. Please provide the full code.
Otherwise, assuming you're using a straightforward read operation on the file, it is almost certainly returning a table. Simply use table2timetable and then plot that with candle.

  1 Comment

easiest fix ever!
thank you

Sign in to comment.


Answer by Avi Michaely on 21 Sep 2018

Thank you, it worked!

  0 Comments

Sign in to comment.