How to draw candle with dates?

5 ビュー (過去 30 日間)
Avi Michaely
Avi Michaely 2018 年 9 月 21 日
コメント済み: Ruby Singh 2019 年 1 月 8 日
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.

採用された回答

Greg
Greg 2018 年 9 月 21 日
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 件のコメント
Ruby Singh
Ruby Singh 2019 年 1 月 8 日
easiest fix ever!
thank you

サインインしてコメントする。

その他の回答 (1 件)

Avi Michaely
Avi Michaely 2018 年 9 月 21 日
Thank you, it worked!

Community Treasure Hunt

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

Start Hunting!

Translated by