How to draw candle with dates?

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.

Answer 1

[Greg]

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.

[Ruby Singh]

easiest fix ever!

thank you

Answer 2

[Avi Michaely]

Thank you, it worked!