How to draw candle with dates?
9 views (last 30 days)
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
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.
Greg on 21 Sep 2018
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.