MATLAB: Draw candlestick chart by reading the data in excel file.

candlestick chartFinancial Toolbox

I need some help, i downloaded some data in excel format. Any idea to draw a candlestick chart by reading the excel file?

Attached file is the example of excel data file. First to the following column of the excel file represent (Date,Time,Open,High,Low,Close,Volume).

Any idea using this information and data to draw a candlestick chart?

Best Answer

Hi,

you can use the following code:

Data = readtable('DAT_MT_EURAUD_M1_2018.csv');
Data = mergevars(Data,[1 2]);
Data.Var1 = join(Data{:,1});
Data.Var1 = datetime(Data.Var1,'InputFormat','yyyy.MM.dd HH:mm');
Data.Properties.VariableNames = {'Date_Time', 'Open', 'High', 'Low',...
    'Close', 'Volume'};
Data = table2timetable(Data);
candle(Data)

It takes a little moment to execute, since this is a pretty big dataset. But it is working.

Best regards

Stephan

Related Solutions

MATLAB: Error with using xlsread on 9000 files

Here is one way of reading semi-colon delimited CSV [sic] files quickly using textscan, which has the advantage that the file can be closed via fclose. The data file you supplied (attached below) is complicated by the use of a comma , as the decimal radix point, so I read the second column as strings to convert to numeric later. As such it would be easier if the file was saved as a true CSV file (with , delimiter and . radix point).

In any case, this will read your sample data file:

% Read CSV file data:
fid = fopen('SampleFile.csv','rt');
hdr = regexp(fgetl(fid),';','split');
C = textscan(fid,'%s%s%f','Delimiter',';');
fclose(fid);
% Convert decimal comma to period:
C{2} = str2double(strrep(C{2},',','.'));
% Convert to numeric matrix and serial date number:
mat = horzcat(C{2:3});
dtn = cellfun(@datenum8601,C{1});

Note that the last line requires my FEX submission datenum8601, which will convert those beautiful ISO 8601 date strings into serial date numbers.

MATLAB: Looking for candlestick, rsi, csv file example

Hi,

here is a working example for candlestick containing .csv-data which works on R2018b:

https://de.mathworks.com/matlabcentral/answers/442627-draw-candlestick-chart-by-reading-the-data-in-excel-file

Based on this code, the data and the Documentation of RSI it should be easy to plot the RSI.