MATLAB: How to convert a CSV formatted string to a table or timetable

csv convert table time series table

How do I convert a CSV formatted string to a table or time series table, so it then can be plotted as a candle stick plot? The string is the output result of a http: request and could look something like:
'timestamp,open,high,low,close,volume
2019-01-07 14:45:00,102,102.4,103.23,103.00,1955320
2019-01-07 14:46:00,102.3,102.2,102,6,103.9,267856
'

Best Answer

NEW ANSWER
Try a variation of this, where your CSV-formatted string is directly read and converted to a table. 
TextStr = ['timestamp,open,high,low,close,volume', newline, ...
       '2019-01-07 14:45:00,102,102.4,103.23,103.00,1955320', newline, ...
       '2019-01-07 14:46:00,102.3,102.2,102.6,103.9,267856', newline]
HeaderFmt = '%s%s%s%s%s%s';
DataFmt = '%D%f%f%f%f%f';
Fields = cellfun(@(x) x{1}, textscan(TextStr, HeaderFmt, 1, 'Delimiter', ','), 'un', 0);
Data = textscan(TextStr, DataFmt, 'Headerlines', 1, 'EndOfLine', newline, 'Delimiter', ',');
Table = table(Data{:}, 'VariableNames', Fields);
-----
OLD ANSWER
Why not save the CSV-formatted string as a real .csv file, and then reload via readtable?
TextStr = ['timestamp,open,high,low,close,volume', char(10), ...
       '2019-01-07 14:45:00,102,102.4,103.23,103.00,1955320', char(10), ...
       '2019-01-07 14:46:00,102.3,102.2,102.6,103.9,267856', char(10)]
   
FID = fopen('temp.csv', 'w');
fprintf(FID, TextStr);
fclose(FID);
Table = readtable('temp.csv');
If you have the Financial Toolbox, then you can use the candle function
https://www.mathworks.com/help/finance/candle.html
Related Question