How to draw candle with dates?

9 views (last 30 days)
Avi Michaely
Avi Michaely on 21 Sep 2018
Commented: 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
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.

Accepted Answer

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.
  1 Comment
Ruby Singh
Ruby Singh on 8 Jan 2019
easiest fix ever!
thank you

Sign in to comment.

More Answers (1)

Avi Michaely
Avi Michaely on 21 Sep 2018
Thank you, it worked!


Find more on Dates and Time in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by